Snort mailing list archives
Acid : OUTER JOINRe: CVS changes in ACID
From: Alexandre Dulaunoy <adulau-snort () colorado g-inter net>
Date: Sat, 5 May 2001 16:45:27 +0200 (CEST)
Hello, I have made a CVS checkout (it's version 0.9.6b8) but i run into trouble with postgresql 7.0.2. I got the error "OUTER JOIN is not supported" and Relation 'signature does not exist'. What type of mistake, i'm currenlty doing with acid ? The adodb is the version 1.00 and contain a hack for a "false" OUTER JOIN. Is it the problem ? If you have any idea... Thanks. alx On Fri, 4 May 2001 roman () danyliw com wrote:
I tar-ed up a check-out of the CVS code, 0.9.6b8, yesterday. It contains a number of bug fixes and is a recommended upgrade from 0.9.6b7. A "db schema" is exactly what is sounds like. It is the description of the layout of a particular database. Practically, the schema is the tables, indexes, and their relationships. Since there now are so many different versions of Snort running, schema versioning was introduced a little while back. The most current version is 101. The most significant reason to upgrade to at least version 100 is support for references and huge speed increases in certain queries. You can verify the schema you are running by watching the output generated by Snort at startup, or by checking the 'schema' table in the DB. Databases which are pre-schema version 100 (i.e. before there even existed the notion of schemas) will not be able to be upgraded, but the transition from 100->101 should be painless (actually the MySQL schema for version 100 and 101 are identical, only the PostgreSQL versions are different). cheers, RomanHi! I have ACID on an internal machine, version 0.9.6b7. I know that there are some bugs in that version that are already fixed in CVS. Are there patches floating around specific for those bugs or should I upgrade to the CVS version? Specifically, the bug where an action on an entire query won't work. Are there design changes which would prevent me from upgrading smoothly? (see below) And what is the "db schema"? Is it the organization of the tables on the SQL server? If yes, should I change the tables to this new schema manually or is there a script for it? _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: http://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users--------------------------------------------- This message was sent using Voicenet WebMail. http://www.voicenet.com/webmail/ _______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: http://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
_______________________________________________ Snort-users mailing list Snort-users () lists sourceforge net Go to this URL to change user options or unsubscribe: http://lists.sourceforge.net/lists/listinfo/snort-users Snort-users list archive: http://www.geocrawler.com/redir-sf.php3?list=snort-users
Current thread:
- CVS changes in ACID Andreas Hasenack (May 04)
- <Possible follow-ups>
- Re: CVS changes in ACID roman (May 04)
- Acid : OUTER JOINRe: CVS changes in ACID Alexandre Dulaunoy (May 05)
- Re: Acid : OUTER JOINRe: CVS changes in ACID Alexandre Dulaunoy (May 05)
- acid/snort 1.8beta Re: Acid : OUTER JOINRe: CVS changes in ACID Alexandre Dulaunoy (May 05)
- Acid : OUTER JOINRe: CVS changes in ACID Alexandre Dulaunoy (May 05)