[pgpool-general: 362] pgpool-II 3.1.2 can connect to the first database but not to the others

Alessandro De Noia alessandro.denoia at gmail.com
Fri Apr 20 19:06:17 JST 2012


Hi,
I'm testing pooling and load balancing features with 6 servers and I get a
weird error.
I can connect to the first database (pgpoolAdmin shows the status
connected) but I can't connect to the others as I got an authentication
error.
Furthermore, I've tried to set just one database in the config file and
whatever it is I can connect.

This is the pgpool log:

2012-04-20 11:01:56 DEBUG: pid 28450: I am 28450 accept fd 6
2012-04-20 11:01:56 LOG:   pid 28450: connection received: host=
xxxxxxxxxx.uk port=52809
2012-04-20 11:01:56 DEBUG: pid 28450: Protocol Major: 1234 Minor: 5679
database:  user:
2012-04-20 11:01:56 DEBUG: pid 28450: SSLRequest from client
2012-04-20 11:01:56 DEBUG: pid 28450: pool_ssl: SSL requested but SSL
support is not available
2012-04-20 11:01:56 DEBUG: pid 28450: read_startup_packet:
application_name: pgAdmin III - Browser
2012-04-20 11:01:56 DEBUG: pid 28450: Protocol Major: 3 Minor: 0 database:
postgres user: xxxx
2012-04-20 11:01:56 DEBUG: pid 28450: new_connection: connecting 0 backend
2012-04-20 11:01:56 DEBUG: pid 28450: new_connection: connecting 1 backend
2012-04-20 11:01:56 DEBUG: pid 28450: new_connection: skipping slot 1
because backend_status = 1
2012-04-20 11:01:56 DEBUG: pid 28450: pool_ssl: SSL requested but SSL
support is not available
2012-04-20 11:01:56 DEBUG: pid 28450: pool_read_message_length: slot: 0
length: 12
2012-04-20 11:01:56 DEBUG: pid 28450: pool_do_auth: auth kind:5
2012-04-20 11:01:56 DEBUG: pid 28450: trying md5 authentication
2012-04-20 11:01:56 ERROR: pid 28450: pool_get_passwd: username is NULL
2012-04-20 11:01:56 DEBUG: pid 28450: do_md5: (null) does not exist in
pool_passwd
2012-04-20 11:01:56 DEBUG: pid 28450: do_md5failed in slot 0

All the servers have the same hardware and database schema.

Thanks,

Alex.

-- 
Alessandro De Noia
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20120420/1d1965ca/attachment.html>


More information about the pgpool-general mailing list