I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the following error appears..: Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) But if I use psql and connects to the same db server with the same username and password, I can successfully connect... What am I missing? Regards, BTJ -- ----------------------------------------------------------------------------------------------- Bj?rn T Johansen btj at havleik.no ----------------------------------------------------------------------------------------------- Someone wrote: "I understand that if you play a Windows CD backwards you hear strange Satanic messages" To which someone replied: "It's even worse than that; play it forwards and it installs Windows" -----------------------------------------------------------------------------------------------
Am 16.03.2013 22:36, schrieb Bj?rn T Johansen:> I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the > following error appears..: > > Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so > Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied > Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting > Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? > Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) > > But if I use psql and connects to the same db server with the same username and password, I can successfully connect... > What am I missing?most likely the difference between TCP and socket-connection -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 263 bytes Desc: OpenPGP digital signature URL: <http://dovecot.org/pipermail/dovecot/attachments/20130316/b27f9246/attachment.bin>
Bj?rn T Johansen schrieb:> I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the > following error appears..: > Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied > Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting > Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? > Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) > > But if I use psql and connects to the same db server with the same username and password, I can successfully connect...Is your dovecot server allowed to connect to your db server (pg_hba.conf)? Patrick
On Sat, 16 Mar 2013 22:38:20 +0100 Reindl Harald <h.reindl at thelounge.net> wrote:> > > Am 16.03.2013 22:36, schrieb Bj?rn T Johansen: > > I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the > > following error appears..: > > > > Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth > > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so > > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so > > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so > > Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so > > Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied > > Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting > > Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? > > Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) > > > > But if I use psql and connects to the same db server with the same username and password, I can successfully connect... > > What am I missing? > > most likely the difference between TCP and socket-connection >Using tcp for both dovecot and my test with psql... BTJ
On Sat, 16 Mar 2013 22:39:49 +0100 Patrick Westenberg <pw at wk-serv.de> wrote:> Bj?rn T Johansen schrieb: > > I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the > > following error appears..: > > Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied > > Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting > > Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? > > Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) > > > > But if I use psql and connects to the same db server with the same username and password, I can successfully connect... > > Is your dovecot server allowed to connect to your db server (pg_hba.conf)? > > PatrickYes, as I said, it is working when using psql from my dovecot server... BTJ
Am 16.03.2013 22:50, schrieb Bj?rn T Johansen:> On Sat, 16 Mar 2013 22:38:20 +0100 > Reindl Harald <h.reindl at thelounge.net> wrote: > >> Am 16.03.2013 22:36, schrieb Bj?rn T Johansen: >>> I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the >>> following error appears..: >>> >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so >>> Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied >>> Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting >>> Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) >>> >>> But if I use psql and connects to the same db server with the same username and password, I can successfully connect... >>> What am I missing? >> >> most likely the difference between TCP and socket-connection > > Using tcp for both dovecot and my test with psql...i do not believe it.................. but however, if you do not post config informations and at teast the exact command of "psql" i doubt someone can help you most people do not realize that "localhost" is implicitly a unix-connection and not the same as "127.0.0.1" as example -------------- next part -------------- A non-text attachment was scrubbed... Name: signature.asc Type: application/pgp-signature Size: 263 bytes Desc: OpenPGP digital signature URL: <http://dovecot.org/pipermail/dovecot/attachments/20130316/796e27cb/attachment.bin>
On Sat, 16 Mar 2013 23:00:07 +0100 Reindl Harald <h.reindl at thelounge.net> wrote:> > > Am 16.03.2013 22:50, schrieb Bj?rn T Johansen: > > On Sat, 16 Mar 2013 22:38:20 +0100 > > Reindl Harald <h.reindl at thelounge.net> wrote: > > > >> Am 16.03.2013 22:36, schrieb Bj?rn T Johansen: > >>> I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the > >>> following error appears..: > >>> > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so > >>> Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied > >>> Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting > >>> Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) > >>> > >>> But if I use psql and connects to the same db server with the same username and password, I can successfully connect... > >>> What am I missing? > >> > >> most likely the difference between TCP and socket-connection > > > > Using tcp for both dovecot and my test with psql... > > i do not believe it.................. > > but however, if you do not post config informations and at teast the > exact command of "psql" i doubt someone can help you > > most people do not realize that "localhost" is implicitly a unix-connection > and not the same as "127.0.0.1" as example >Hmmm... Well, I am not most people... :P ;) psql -h 10.50.150.35 -U serviceadmin -d serviceadmin Password for user serviceadmin: psql (9.1.8, server 9.1.6) Type "help" for help. And my connection string for dovecot, looks like this: connect = host=10.50.150.35 dbname=serviceadmin user=serviceadmin password=xxxxxxxxxx And can not see any difference....? BTJ
On Sat, 16 Mar 2013 23:22:22 +0100 Bj?rn T Johansen <btj at havleik.no> wrote:> On Sat, 16 Mar 2013 23:00:07 +0100 > Reindl Harald <h.reindl at thelounge.net> wrote: > > > > > > > Am 16.03.2013 22:50, schrieb Bj?rn T Johansen: > > > On Sat, 16 Mar 2013 22:38:20 +0100 > > > Reindl Harald <h.reindl at thelounge.net> wrote: > > > > > >> Am 16.03.2013 22:36, schrieb Bj?rn T Johansen: > > >>> I have configured a new server and copied the dovecot-sql.conf file that works a different server to the new server... But when Dovecot tries to connect to the database, the > > >>> following error appears..: > > >>> > > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Loading modules from directory: /usr/lib64/dovecot/auth > > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libauthdb_ldap.so > > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_pgsql.so > > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libdriver_sqlite.so > > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: Module loaded: /usr/lib64/dovecot/auth/libmech_gssapi.so > > >>> Mar 16 22:28:25 smtp dovecot: auth: Error: pgsql: Connect failed to serviceadmin: could not connect to server: Permission denied > > >>> Mar 16 22:28:25 smtp dovecot: auth: Error: #011Is the server running on host "10.50.150.35" and accepting > > >>> Mar 16 22:28:25 smtp dovecot: auth: Error: #011TCP/IP connections on port 5432? > > >>> Mar 16 22:28:25 smtp dovecot: auth: Debug: auth client connected (pid=1768) > > >>> > > >>> But if I use psql and connects to the same db server with the same username and password, I can successfully connect... > > >>> What am I missing? > > >> > > >> most likely the difference between TCP and socket-connection > > > > > > Using tcp for both dovecot and my test with psql... > > > > i do not believe it.................. > > > > but however, if you do not post config informations and at teast the > > exact command of "psql" i doubt someone can help you > > > > most people do not realize that "localhost" is implicitly a unix-connection > > and not the same as "127.0.0.1" as example > > > > Hmmm... Well, I am not most people... :P ;) > > psql -h 10.50.150.35 -U serviceadmin -d serviceadmin > Password for user serviceadmin: > psql (9.1.8, server 9.1.6) > Type "help" for help. > > > And my connection string for dovecot, looks like this: > > connect = host=10.50.150.35 dbname=serviceadmin user=serviceadmin password=xxxxxxxxxx > > > And can not see any difference....? > > > BTJOK, found the guilty one... Just discovered than someone had enabled SELinux and it of course stopped the "suspicous" traffic from dovecot.... :-S BTJ