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

[Alex <mys...@gm...>]

Hi,

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

Yes, the server was unreachable because it was down.

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

I don't really see how that's an option, though, because a client could
conceivably have to try three different servers before being allowed to
connect, meaning up to a fifteen minute delay before the mail is even
accepted, assuming the client even retries that many times, which I doubt
it would. That's the whole reason for clustering in the first place.

> 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

That is how I'm running it.

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

The configuration isn't all that complex. Have you tested your environment
and know that yours works properly?

Could you post your config so I can compare with mine?

How did you set up mysql?

I'd really like to stick with sqlgrey if at all possible, so I'd really
appreciate your help in figuring this out.

Thanks,
Alex