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 [[email protected]] Enviado el: miércoles, 08 de junio de 2011 6:02 Para: Lazaro Rubén García Martinez CC: [email protected] Asunto: Re: [Pgpool-general] Error during md5 authentication On Mon, 6 Jun 2011 19:28:24 +0900 Toshihiro Kitagawa <[email protected]> wrote: > On Sun, 5 Jun 2011 22:57:21 -0430 > Lazaro Rubén García Martinez <[email protected]> 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 > > [email protected] > > http://pgfoundry.org/mailman/listinfo/pgpool-general > > -- Toshihiro Kitagawa SRA OSS, Inc. Japan _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
