[Pgpool-general] Error during md5 authentication

Thu Jun 23 14:55:34 UTC 2011

Toshihiro, thank you very much for your answer and patch, I proved it and works as expected. One other error that I see in pgpool log file is related with SSL conection, these are the SSL configurateion parameters in my pgpool.conf

# If true, enable SSL support for both frontend and backend connections.
# note that you must also set ssl_key and ssl_cert for SSL to work in
# the frontend connections.
ssl = true
# path to the SSL private key file
ssl_key = '/opt/pgpool/ssl/server.key'
# path to the SSL public certificate file
ssl_cert = '/opt/pgpool/ssl/server.cert'

But in pgpool log file this error is shown:

2011-06-23 	10:53:33 	LOG: 	pid 	3996: 	connection received: host=psp01.psp.vnz.uci.cu port=51498 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	Protocol Major: 1234 Minor: 5679 database: user: 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	SSLRequest from client 	
2011-06-23 	10:53:33 	ERROR: 	pid 	3996: 	pool_ssl: Loading SSL certificate: No such file or directory 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	Protocol Major: 3 Minor: 0 database: tesis user: postgres 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	new_connection: connecting 0 backend 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	new_connection: connecting 1 backend 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	new_connection: skipping slot 1 because backend_status = 3 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	pool_ssl: sending client->server SSL request 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	pool_ssl: client->server SSL response: N 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	pool_ssl: server doesn't want to talk SSL 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	pool_read_message_length: slot: 0 length: 12 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	pool_do_auth: auth kind:5 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	trying md5 authentication 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	read_password_packet_password: failed to read password packet "p" 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	do_md5: read_password_packet failed 	
2011-06-23 	10:53:33 	DEBUG: 	pid 	3996: 	do_md5failed in slot 0 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	I am 3996 accept fd 14 	
2011-06-23 	10:53:35 	LOG: 	pid 	3996: 	connection received: host=psp01.psp.vnz.uci.cu port=51512 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	Protocol Major: 1234 Minor: 5679 database: user: 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	SSLRequest from client 	
2011-06-23 	10:53:35 	ERROR: 	pid 	3996: 	pool_ssl: Loading SSL certificate: system lib 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	Protocol Major: 3 Minor: 0 database: tesis user: postgres 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	new_connection: connecting 0 backend 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	new_connection: connecting 1 backend 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	new_connection: skipping slot 1 because backend_status = 3 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	pool_ssl: sending client->server SSL request 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	pool_ssl: client->server SSL response: N 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	pool_ssl: server doesn't want to talk SSL 	
2011-06-23 	10:53:35 	DEBUG: 	pid 	3996: 	pool_read_message_length: slot: 0 length: 12

Can you tell my the reason of this error?

Regards.

________________________________________
De: Toshihiro Kitagawa [kitagawa at sraoss.co.jp]
Enviado el: miércoles, 08 de junio de 2011 6:02
Para: Lazaro Rubén García Martinez
CC: pgpool-general at pgfoundry.org
Asunto: Re: [Pgpool-general] Error during md5 authentication

On Mon, 6 Jun 2011 19:28:24 +0900
Toshihiro Kitagawa <kitagawa at sraoss.co.jp> wrote:

> On Sun, 5 Jun 2011 22:57:21 -0430
> Lazaro Rubén García Martinez <lgarciam at vnz.uci.cu> wrote:
>
> > Hello, every one in the list, When a try to connect to postgresql servers through pgpool-II using md5 authetication method, in pgpool-II log file, this error is shown:
> >
> > trying md5 authentication
> > 2011-06-05      18:00:55        DEBUG:  pid     8147:   read_password_packet_password: failed to read password packet "p"
> > 2011-06-05      18:00:55        ERROR:  pid     8147:   do_md5: read_password_packet failed
> > 2011-06-05      18:00:55        DEBUG:  pid     8147:   do_md5failed in slot 0
> >
> > Can any body tell my, why is the reason of this problem???
>
> I found the cause of the error message.
> It seems to be no problem except emitting the error message.
> I will make the patch. Wait a minute.

After all, I changed the error message into debug level.

>
> >
> > thank you very much for your time.
> > Regards.
> > _______________________________________________
> > Pgpool-general mailing list
> > Pgpool-general at pgfoundry.org
> > http://pgfoundry.org/mailman/listinfo/pgpool-general
> >

--
Toshihiro Kitagawa
SRA OSS, Inc. Japan