Re: [Sqlgrey-users] sqlgrey fails when configured with multiple machines

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

Alex wrote:
> Yes, that is the very same messages I receive:
>
>
> Jun 30 06:35:16 mail03 sqlgrey: warning: Could not connect to any server
> in WRITE_HOSTS at /usr/sbin/sqlgrey line 827.
> Jun 30 06:35:16 mail03 sqlgrey: dbaccess: can't connect to DB: Can't
> connect to MySQL server on 'mail02.example.com' (113) Jun 30 06:35:16
> mail03 sqlgrey: dbaccess: error: couldn't access config table: Can't
> connect to MySQL server on 'mail02.example.com' (113) Jun 30 06:35:16
> mail03 sqlgrey: mail: failed to send: Jun 30 06:35:16 mail03 sqlgrey:
> fatal: setconfig error at /usr/sbin/sqlgrey
> line 195.

I believe the error 113 means "no route to host" and that should fail
instantly. Which means you are probably not having timeout issues. And
then I'm at a loss, since i cannot reproduce the issue here. And if theres
nothing else in the logs from sqlgrey indicating errors, well...

I'd go with Lionel's suggestion to try and run sqlgrey without
db_clustering to simplify the setup. Though i dont think itll show any
difference, it should be an easy test and it will rule out (or confirm)
that it has something to do with db_clustering.

Then I'd try the same with the "spawn" setup you described below. Does it
make any difference if you comment out that line, and simply run it using
$ /usr/sbin/sqlgrey -d

I'm just thinking, that if I cannot reproduce your error, it must be
something specific to your setup.

- Dan

>
> I have sqlgrey defined as such in master.cf:
>
>
> greylist  unix  -       n       n       -       0       spawn user=nobody
> argv=/usr/bin/perl /usr/sbin/sqlgrey
>
> and "check_policy_service inet:127.0.0.1:2501" in main.cf.
>
>> In fact, the ONLY way i have been able to get a "Server configuration
>> problem" in my tests, is if i point the db_host to a server that behind
>> a firewall that DROPS packages. This makes "connect" hang for a very
>> long time, which makes postfix drop the connection due to timeout and
>> cry "Server configuration problem".
>>
>
> Have I configured postfix incorrectly? I'll include my sqlgrey.conf
> again, in hopes it helps.
>
> loglevel = 3 log_override = whitelist:1,grey:3,spam:2 reconnect_delay = 5
> db_type = mysql db_name = sqlgrey db_host = mail02.example.com db_port =
> default db_user = sqlgrey db_pass = mypass
> db_cleanup_hostname=mail02.example.com db_cleandelay = 1800 clean_method =
> sync db_cluster = on
> read_hosts=localhost,mail02.example.com,mail03.example.com,
> mail01.example.com prepend = 1 admin_mail = my...@me...
>
> Thanks again,
> Alex
> --------------------------------------------------------------------------
> ----
> Open source business process management suite built on Java and Eclipse
> Turn processes into business applications with Bonita BPM Community
> Edition
> Quickly connect people, data, and systems into organized workflows
> Winner of BOSSIE, CODIE, OW2 and Gartner awards
> http://p.sf.net/sfu/Bonitasoft____________________________________________
> ___
> Sqlgrey-users mailing list
> Sql...@li...
> https://lists.sourceforge.net/lists/listinfo/sqlgrey-users
>
>