[Sqlgrey-users] SQLGrey setup

[Bastien LAMOUREUX]

Hi

Actually trying to install SQLGrey in a setup with
server1 : postfix and sqlgrey
server2 : postfix and sqlgrey
server3 : mysql and the sqlgrey shared database

I created a sqlgrey database with sqlgrey user and all privileges on this database on server3
There is no firewall between servers, and I am able to ping from server1 to server3

In sqlgrey.conf, I enabled
db_host = server3IP
db_port = default
db_user = sqlgrey
db_pass = mypassword


But when I launch sqlgrey on server1, I encounter this problem
Did I miss something ?

Jan 13 10:58:21 PCACTI01 sqlgrey: Binding to TCP port 2501 on host localhost#012
Jan 13 10:58:21 PCACTI01 sqlgrey: Setting gid to "111 111"
Jan 13 10:58:21 PCACTI01 sqlgrey: Setting uid to "106"
Jan 13 10:58:21 PCACTI01 sqlgrey: dbaccess: can't connect to DB: Can't connect to MySQL server on 'server3IP' (111)
Jan 13 10:58:21 PCACTI01 sqlgrey: dbaccess: error: couldn't get now() from DB: Can't connect to MySQL server on 'server3IP' (111)
Jan 13 10:58:21 PCACTI01 sqlgrey: fatal: Can't call method "do" on an undefined value at /usr/sbin/sqlgrey line 308.

[Urban, Frank]

can you
telnet 'server3IP' 3306 ?
Can you logon to mysql with the sqlgrey user on the local mysql in
server3?
That is my most taken mistake that I set the rights and than I forget to
flush rights



________________________________

From: Bastien LAMOUREUX [mailto:***@yousaas.com]
Sent: Wednesday, January 13, 2010 11:36 AM
To: sqlgrey-***@lists.sourceforge.net
Subject: [Sqlgrey-users] SQLGrey setup



Hi



Actually trying to install SQLGrey in a setup with

server1 : postfix and sqlgrey

server2 : postfix and sqlgrey

server3 : mysql and the sqlgrey shared database



I created a sqlgrey database with sqlgrey user and all
privileges on this database on server3

There is no firewall between servers, and I am able to ping from
server1 to server3



In sqlgrey.conf, I enabled

db_host = server3IP

db_port = default

db_user = sqlgrey

db_pass = mypassword





But when I launch sqlgrey on server1, I encounter this problem

Did I miss something ?



Jan 13 10:58:21 PCACTI01 sqlgrey: Binding to TCP port 2501 on
host localhost#012

Jan 13 10:58:21 PCACTI01 sqlgrey: Setting gid to "111 111"

Jan 13 10:58:21 PCACTI01 sqlgrey: Setting uid to "106"

Jan 13 10:58:21 PCACTI01 sqlgrey: dbaccess: can't connect to DB:
Can't connect to MySQL server on 'server3IP' (111)

Jan 13 10:58:21 PCACTI01 sqlgrey: dbaccess: error: couldn't get
now() from DB: Can't connect to MySQL server on 'server3IP' (111)

Jan 13 10:58:21 PCACTI01 sqlgrey: fatal: Can't call method "do"
on an undefined value at /usr/sbin/sqlgrey line 308.

[Winfried Neessen]

Hi,

did you verify that your MySQL server is listening on a network port and
not only on the local
unix socket? Check you my.cnf file for "skip-networking"


Winni

_____

From: Bastien LAMOUREUX [mailto:***@yousaas.com]
Sent: Wednesday, January 13, 2010 11:36 AM
To: sqlgrey-***@lists.sourceforge.net
Subject: [Sqlgrey-users] SQLGrey setup



Hi



Actually trying to install SQLGrey in a setup with

server1 : postfix and sqlgrey

server2 : postfix and sqlgrey

server3 : mysql and the sqlgrey shared database



I created a sqlgrey database with sqlgrey user and all privileges on
this database on server3

There is no firewall between servers, and I am able to ping from server1
to server3



In sqlgrey.conf, I enabled

db_host = server3IP

db_port = default

db_user = sqlgrey

db_pass = mypassword





But when I launch sqlgrey on server1, I encounter this problem

Did I miss something ?



Jan 13 10:58:21 PCACTI01 sqlgrey: Binding to TCP port 2501 on host
localhost#012

Jan 13 10:58:21 PCACTI01 sqlgrey: Setting gid to "111 111"

Jan 13 10:58:21 PCACTI01 sqlgrey: Setting uid to "106"

Jan 13 10:58:21 PCACTI01 sqlgrey: dbaccess: can't connect to DB: Can't
connect to MySQL server on 'server3IP' (111)

Jan 13 10:58:21 PCACTI01 sqlgrey: dbaccess: error: couldn't get now()
from DB: Can't connect to MySQL server on 'server3IP' (111)

Jan 13 10:58:21 PCACTI01 sqlgrey: fatal: Can't call method "do" on an
undefined value at /usr/sbin/sqlgrey line 308.