Re: [Sqlgrey-users] Sqlgrey dies while creating mysql tables

[Dan F. <da...@ha...>]

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.
>
>
>