|
From: Dan F. <da...@ha...> - 2007-01-10 18:16:12
|
Not sure. I run on several sqlgreys on Debian Sarge myself and havnt had this problem. But i do seem to recall that the default Debian settings for Mysql is either having "skip-networking" enabled or bind to 127.0.0.1 (depending on versions). If skip-networking is enabled, that would definently explain it, as sqlgrey doesn't connect through the socket file "/var/run/mysqld/mysqld.sock" like eg. php does pr. default. and if mysql is bound to 127.0.0.1 and youre using the servers real ip or hostname in db_host, then that would also explain your problem. - Dan Juraj Variny wrote: > 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. > > > |