[Sqlgrey-users] Sqlgrey dies while creating mysql tables

[Juraj V. <ju...@eq...>]

Hello,

I am trying to set it up on Debian Sarge.  In /etc/sqlgrey/sqlgrey.conf I have 
only:

db_type=mysql
db_name=sqlgrey
db_user=XXXX
db_pass=YYYY

When I start sqlgrey, it dies and leaves following in syslog. The db_user and 
pass are correct. Please advise where could be the problem.

Jan 10 16:07:28 testserver sqlgrey: Process Backgrounded
Jan 10 16:07:28 testserver sqlgrey: 2007/01/10-16:07:28 sqlgrey (type 
Net::Server::Multiplex) starting! pid(1658)
Jan 10 16:07:28 testserver sqlgrey: Binding to TCP port 2501 on host localhost
Jan 10 16:07:28 testserver sqlgrey: Setting gid to "109 109"
Jan 10 16:07:28 testserver sqlgrey: Setting uid to "108"
Jan 10 16:07:28 testserver sqlgrey: warning: Use of uninitialized value in 
concatenation (.) or string at /usr/local/sbin/sqlgrey line 227.
Jan 10 16:07:28 testserver sqlgrey: dbaccess: warning: couldn't do query: 
CREATE TABLE from_awl (sender_name varchar(64) NOT NULL, sender_domain 
varchar(255) NOT NULL, src va
rchar(39) NOT NULL, first_seen timestamp NOT NULL, last_seen timestamp NOT 
NULL, PRIMARY KEY (src, sender_domain, sender_name)): , reconnecting to DB
Jan 10 16:07:28 testserver sqlgrey: mail: child exited with value: 1
Jan 10 16:07:28 testserver sqlgrey: fatal: create_from_awl_table error 
at /usr/local/sbin/sqlgrey line 176.


-- 
Juraj Variny <ju...@eq...>

Administrator, Developer
Equilibrium Ltd. / Rovnovaha s r.o.
http://www.equit.sk/