[Sqlgrey-users] 2 more (small) issues with SQLGrey 1.4.0

[HaJo S. <ha...@ha...>]

Hi Lionel,

Just discovered two start-up issues with sqlgrey while doing a reboot of 
my mail server:

- During boot, sqlgrey couldn't access postgresql yet (DBI returned "db 
is starting up"). sqlgrey then tried to create the from_awl table, 
failed (db still starting up) and died silently (rather than, what would 
IMO have been correct, retrying after a while). I have attached the 
relevant part of the log below fyi.

- I accidentially started sqlgrey (thorugh /etc/init.d/sqlgrey start) as 
non-root user. The init-script said:

'Starting SQLgrey: Pid_file "/var/run/sqlgrey.pid" already exists. 
Overwriting!'

and then '[ OK ]'. However, it was of course not OK, sqlgrey died with a 
  permission-denied on the PID file, did not tell me however...

Merry Christmas,
HaJo


----------[maillog sniplet]---------------
Dec 23 23:19:18 sun sqlgrey[3691]: Process Backgrounded 
Dec 23 23:19:18 sun sqlgrey[3691]: 2004/12/23-23:19:17 sqlgrey (type Net::Server::Multiplex) starting! pid(3691) 
Dec 23 23:19:20 sun sqlgrey[3691]: Binding to TCP port 2501 on host localhost 
Dec 23 23:19:20 sun sqlgrey[3691]: Group Not Defined.  Defaulting to EGID '0' 
Dec 23 23:19:20 sun sqlgrey[3691]: Setting uid to "91" 
Dec 23 23:19:21 sun sqlgrey[3691]: Can't connect to DB: FATAL:  The database system is starting up 
Dec 23 23:19:21 sun sqlgrey[3691]: Can't connect to DB: FATAL:  The database system is starting up 
Dec 23 23:19:21 sun sqlgrey[3691]: Warning: couldn't do query: SELECT 1 from from_awl LIMIT 0: FATAL:  The database system is starting up, reconnecting to DB 
Dec 23 23:19:22 sun sqlgrey[3691]: Can't connect to DB: FATAL:  The database system is starting up 
Dec 23 23:19:22 sun sqlgrey[3691]: Can't connect to DB: FATAL:  The database system is starting up 
Dec 23 23:19:22 sun sqlgrey[3691]: Warning: couldn't do query: CREATE TABLE from_awl (sender_name varchar(64) NOT NULL, sender_domain varchar(255) NOT NULL, host_ip varchar(15) NOT NULL, last_seen timestamp NOT NULL, PRIMARY KEY (sender_name, sender_domain, host_ip));: FATAL:  The database system is starting up, reconnecting to DB 
Dec 23 23:19:22 sun sqlgrey[3691]: Can't connect to DB: FATAL:  The database system is starting up 
Dec 23 23:19:23 sun sqlgrey[3691]: fatal: Couldn't create table from_awl: FATAL:  The database system is starting up 
Dec 23 23:36:42 sun postfix/smtpd[7424]: warning: connect to 127.0.0.1:2501: Connection refused


-- 
HaJo Schatz <ha...@ha...>
http://www.HaJo.Net

PGP-Key:  http://www.hajo.net/hajonet/keys/pgpkey_hajo.txt