acid/snort 1.8beta Re: Acid : OUTER JOINRe: CVS changes in ACID

[Alexandre Dulaunoy <adulau-snort () colorado g-inter net>]

Ok after some testing, for a perfect world with ACID and snort. 

Now all is working smoothly with :

* Snort 1.8-beta4 (build15) (db format 1.00) (add the famous relation to
signature 8-)
* Acid from CVS
* Latest PHP
* Latest ADODB (v 1.00)
* Latest GD
* Postgres 4.1 (OUTER JOIN is now supported 8-)

Now, I can monitor my test-lab without any problems. 

Thanks to everybody, it's really a great piece of software. Now i will
put my old ISS/Real Secure to dustbin. 

Again thanks. 

Alx



On Sat, 5 May 2001, Alexandre Dulaunoy wrote:

> For the OUTER JOIN, it is now supported with postgres 7.1.0... so it's
> working correctly except the error (with 'relation singature does not
> exit').
>
> Any idea ?
>
> alx
>
>  On Sat, 5 May 2001, Alexandre Dulaunoy wrote:
>
> > 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,
> > > Roman
> > >
> > > > Hi!
> > > > 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

-- 
---
Alexandre J.D. Dulaunoy  | "Engineering is the implementation of science;
AD993-RIPE               | Politics is the implementation of faith".
http://www.foo.be/       |                      Another usenet quote...



_______________________________________________
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