Bastien LAMOUREUX
2010-01-13 13:35:23 UTC
Thanks to you
Mysql was only listening to 127.0.0.1
Everything is ok now
Thanks for help
-----Message d'origine-----
De : sqlgrey-users-***@lists.sourceforge.net [mailto:sqlgrey-users-***@lists.sourceforge.net]
Envoyé : mercredi 13 janvier 2010 12:17
À : sqlgrey-***@lists.sourceforge.net
Objet : Sqlgrey-users Digest, Vol 27, Issue 1
Send Sqlgrey-users mailing list submissions to
sqlgrey-***@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
or, via email, send a message with subject or body 'help' to
sqlgrey-users-***@lists.sourceforge.net
You can reach the person managing the list at
sqlgrey-users-***@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Sqlgrey-users digest..."
Today's Topics:
1. SQLGrey setup (Bastien LAMOUREUX)
2. Re: SQLGrey setup (Urban, Frank)
3. Re: SQLGrey setup (Winfried Neessen)
----------------------------------------------------------------------
Message: 1
Date: Wed, 13 Jan 2010 11:35:47 +0100
From: Bastien LAMOUREUX <***@yousaas.com>
Subject: [Sqlgrey-users] SQLGrey setup
To: "sqlgrey-***@lists.sourceforge.net"
<sqlgrey-***@lists.sourceforge.net>
Message-ID:
<***@PHMCBEXCHVS1.hosting.trekk.corp>
Content-Type: text/plain; charset="us-ascii"
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.
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 2
Date: Wed, 13 Jan 2010 11:56:19 +0100
From: "Urban, Frank" <***@commerzbank.com>
Subject: Re: [Sqlgrey-users] SQLGrey setup
To: "SQLgrey users mailing-list" <sqlgrey-***@lists.sourceforge.net>
Message-ID:
<***@SE000305.ztb.icb.commerzbank.com>
Content-Type: text/plain; charset="us-ascii"
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.
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 3
Date: Wed, 13 Jan 2010 11:58:53 +0100
From: "Winfried Neessen" <***@neessen.net>
Subject: Re: [Sqlgrey-users] SQLGrey setup
To: "'SQLgrey users mailing-list'"
<sqlgrey-***@lists.sourceforge.net>
Message-ID: <***@mail3.neessen.net>
Content-Type: text/plain; charset="us-ascii"
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.
-------------- next part --------------
An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6761 bytes
Desc: not available
------------------------------
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
------------------------------
_______________________________________________
Sqlgrey-users mailing list
Sqlgrey-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
End of Sqlgrey-users Digest, Vol 27, Issue 1
********************************************
Mysql was only listening to 127.0.0.1
Everything is ok now
Thanks for help
-----Message d'origine-----
De : sqlgrey-users-***@lists.sourceforge.net [mailto:sqlgrey-users-***@lists.sourceforge.net]
Envoyé : mercredi 13 janvier 2010 12:17
À : sqlgrey-***@lists.sourceforge.net
Objet : Sqlgrey-users Digest, Vol 27, Issue 1
Send Sqlgrey-users mailing list submissions to
sqlgrey-***@lists.sourceforge.net
To subscribe or unsubscribe via the World Wide Web, visit
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
or, via email, send a message with subject or body 'help' to
sqlgrey-users-***@lists.sourceforge.net
You can reach the person managing the list at
sqlgrey-users-***@lists.sourceforge.net
When replying, please edit your Subject line so it is more specific
than "Re: Contents of Sqlgrey-users digest..."
Today's Topics:
1. SQLGrey setup (Bastien LAMOUREUX)
2. Re: SQLGrey setup (Urban, Frank)
3. Re: SQLGrey setup (Winfried Neessen)
----------------------------------------------------------------------
Message: 1
Date: Wed, 13 Jan 2010 11:35:47 +0100
From: Bastien LAMOUREUX <***@yousaas.com>
Subject: [Sqlgrey-users] SQLGrey setup
To: "sqlgrey-***@lists.sourceforge.net"
<sqlgrey-***@lists.sourceforge.net>
Message-ID:
<***@PHMCBEXCHVS1.hosting.trekk.corp>
Content-Type: text/plain; charset="us-ascii"
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.
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 2
Date: Wed, 13 Jan 2010 11:56:19 +0100
From: "Urban, Frank" <***@commerzbank.com>
Subject: Re: [Sqlgrey-users] SQLGrey setup
To: "SQLgrey users mailing-list" <sqlgrey-***@lists.sourceforge.net>
Message-ID:
<***@SE000305.ztb.icb.commerzbank.com>
Content-Type: text/plain; charset="us-ascii"
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.
-------------- next part --------------
An HTML attachment was scrubbed...
------------------------------
Message: 3
Date: Wed, 13 Jan 2010 11:58:53 +0100
From: "Winfried Neessen" <***@neessen.net>
Subject: Re: [Sqlgrey-users] SQLGrey setup
To: "'SQLgrey users mailing-list'"
<sqlgrey-***@lists.sourceforge.net>
Message-ID: <***@mail3.neessen.net>
Content-Type: text/plain; charset="us-ascii"
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.
-------------- next part --------------
An HTML attachment was scrubbed...
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/x-pkcs7-signature
Size: 6761 bytes
Desc: not available
------------------------------
------------------------------------------------------------------------------
This SF.Net email is sponsored by the Verizon Developer Community
Take advantage of Verizon's best-in-class app development support
A streamlined, 14 day to market process makes app distribution fast and easy
Join now and get one step closer to millions of Verizon customers
http://p.sf.net/sfu/verizon-dev2dev
------------------------------
_______________________________________________
Sqlgrey-users mailing list
Sqlgrey-***@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
End of Sqlgrey-users Digest, Vol 27, Issue 1
********************************************