Re: [Sqlgrey-users] [RELEASE] 1.3.6

[Lionel B. <lio...@bo...>]

Derek Battams wrote the following on 01.12.2004 05:23 :

>
>Just upgraded to 1.3.6 and specified 'smart' for the algorithm.  New
>connections to the server are adding just the first three bytes of the IP
>address to the connect table, as expected, but the old entries in the
>connect and *_awl tables still contain the full four bytes for the IP
>address.  Do I need to delete/update those entries?
>

No, SQLgrey will clean them up automatically (in 24 hours for the 
connect table and 60 days for the others by default), in the meantime it 
will just create new ones.
If your goal is to inspect the table's content easily, you can clean 
them manually :
DELETE FROM <table> WHERE <tstamp_column> < NOW() - INTERVAL '1 DAY';


>  Since the four byte
>entries weren't updated on the upgrade I assume this means that reconnects
>for the four byte entries will not match (unless I manually update the
>tables)?
>  
>

They will not match the old entries (unless 'smart' decides that it 
can't trust the host and uses the whole IP) and create new ones, yes.

>As an aside, if anyone uses Trustix Secure Linux 2.2 and wants an RPM or
>SRPM for 1.3.6 on TSL 2.2 I built them and they're available at:
>
>http://www.battams.ca/software/tsl22/
>  
>

Did you need to change the spec file ?

Lionel.