<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Uruvela, could you explain the problem to Tatsuo, becouse in this moment is not possible to me reproduce your problem.<br><br>Regards.<br><br><hr id="zwchr"><blockquote style="border-left:2px solid rgb(16, 16, 255);margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;">Does not reproduce here.<br><br>pool_hba.conf:<br># TYPE DATABASE USER CIDR-ADDRESS METHOD<br>host test foo 127.0.0.1/32 md5<br>local test foo md5<br># "local" is for Unix domain socket connections only<br>local all all trust<br># IPv4 local connections:<br>host all all 127.0.0.1/32 trust<br><br>pool_passwd:<br>foo:md5<br><br>Lazaro,<br><br>Can you reproduce the problem there?<br>--<br>Tatsuo Ishii<br>SRA OSS, Inc. Japan<br>English: http://www.sraoss.co.jp/index_en.php<br>Japanese: http://www.sraoss.co.jp<br><br>> Oppss, the md5 sum is not present?? <br>> <br>> toto:md5 without the sum?? <br>> <br>> This very strange?. <br>> <br>> Is this a bug? <br>> <br>> Regards. <br>> <br>> ----- Mensaje original -----<br>> <br>>> I agree with 2nd and 3rd trys, i created it to show something wrong<br>>> with last one .<br>>> I disagree with 4th because the file is only :<br>> <br>>> toto:md5<br>> <br>>> Nothing behind md5. So pgpool didn't check the password and let<br>>> connection going to PG and be checked.<br>> <br>>> Regards.<br>> <br>>> > ----- Original Message -----<br>>> <br>>> > From: Lazaro Ruben Garcia Martinez<br>>> <br>>> > Sent: 03/14/13 05:05 PM<br>>> <br>>> > To: uruvela of india<br>>> <br>>> > Subject: Re: [pgpool-general: 1485] pgpool and md5 auth<br>>> <br>> <br>>> > 2nd launch : changing md5 to reject in pool_hba.conf (restarting<br>>> > pgpool) : DBI connect('dbname=mydb','toto',...) failed: ERROR: no<br>>> > pool_hba.conf entry for host "[local]", user "toto", database<br>>> > "mydb"<br>>> > at dbi.pl line 5<br>>> <br>> <br>>> > If you use md5, You have to use md5 between clients and pgpool and<br>>> > between pgpool and postgresql. That is the reason for<br>>> <br>>> > 2nd launch error.<br>>> <br>>> > > > > 3rd launch : back to md5 in pool_hba.conf and changing toto<br>>> > > > > by<br>>> > > > > tito<br>>> > > > > in pool_passwd (restarting pgpool) : DBI<br>>> > > > > connect('dbname=mydb','toto',...) failed: ERROR: "MD5"<br>>> > > > > authentication with pgpool failed for user "toto" at dbi.pl<br>>> > > > > line<br>>> > > > > 5<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > Role tito is not present in postgresql server, that is the<br>>> > > > reason<br>>> > > > of<br>>> > > > this error.<br>>> > > <br>>> > <br>>> <br>>> > > > > 4th launch : back to toto vs tito in pool_passwd and deleted<br>>> > > > > everything after md5 (now pool_passwd is like this<br>>> > > > > 'toto:md5')<br>>> > > > > +<br>>> > > > > restarting pgpool : working.<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > This is the expected behavior.<br>>> > > <br>>> > <br>>> <br>>> > Regards.<br>>> <br>>> > ----- Mensaje original -----<br>>> <br>> <br>>> > > No error with pool_passwd (i'm sure the file is ok if you looking<br>>> > > 3rd<br>>> > > try and username change with error).<br>>> > <br>>> <br>> <br>>> > > I create md5 hashing with tutorial (pg_md5 etc...)<br>>> > <br>>> <br>> <br>>> > > postgresql log is ok (md5 checking is good)<br>>> > <br>>> <br>> <br>>> > > > ----- Original Message -----<br>>> > > <br>>> > <br>>> <br>>> > > > From: Lazaro Ruben Garcia Martinez<br>>> > > <br>>> > <br>>> <br>>> > > > Sent: 03/14/13 04:39 PM<br>>> > > <br>>> > <br>>> <br>>> > > > To: uruvela of india<br>>> > > <br>>> > <br>>> <br>>> > > > Subject: Re: [pgpool-general: 1485] pgpool and md5 auth<br>>> > > <br>>> > <br>>> <br>> <br>>> > > > Is there any line in the log file with some information related<br>>> > > > with<br>>> > > > pool_password file?<br>>> > > <br>>> > <br>>> <br>> <br>>> > > > What does postgresql say in log file?<br>>> > > <br>>> > <br>>> <br>> <br>>> > > > Do you create the pool_password file as pgpool tutorial says,<br>>> > > > or<br>>> > > > just<br>>> > > > copy and paste the md5 from pg_authid of postgres server to<br>>> > > > pool_password, my advice, delete the pool_password and create<br>>> > > > it<br>>> > > > again follows the steps in pgpool tutorial.<br>>> > > <br>>> > <br>>> <br>> <br>>> > > > Regards.<br>>> > > <br>>> > <br>>> <br>>> > > > ----- Mensaje original -----<br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > I m looking to install last stable version .<br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > example of my log in debug mode :<br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > loading "/etc/pgpool2/pool_hba.conf" for client<br>>> > > > > authentication<br>>> > > > > configuration file<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pgpool-II successfully started. version 3.2.2 (namameboshi)<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > ...<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > Protocol Major: 3 Minor: 0 database: mydb user: toto<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > new_connection: connecting 0 backend<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_ssl: SSL requested but SSL support is not available<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length: slot: 0 length: 12<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_do_auth: auth kind:5<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > trying md5 authentication<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > : DB node id: 0 salt: 657c38<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 22<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: application_name value:<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 25<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: client_encoding value: UTF8<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 23<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: DateStyle value: ISO, DMY<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 25<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: integer_datetimes value: on<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 27<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: IntervalStyle value: postgres<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 21<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: is_superuser value: off<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 25<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: server_encoding value: UTF8<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 25<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: server_version value: 9.2.3<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 31<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: session_authorization value: toto<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 36<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: standard_conforming_strings value: off<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length2: master slot: 0 length: 17<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > 0 th backend: name: TimeZone value: GMT<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_read_message_length: slot: 0 length: 12<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_do_auth: cp->info[i]:0x7fbc47d7c800 pid:29617<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > pool_send_auth_ok: send pid 29617 to frontend<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > select_load_balancing_node: selected backend id is 0<br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > selected load balancing node: 0<br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > ----- Original Message -----<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > From: Lazaro Ruben Garcia Martinez<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > Sent: 03/14/13 04:05 PM<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > To: uruvela of india<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > Subject: Re: [pgpool-general: 1485] pgpool and md5 auth<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > Could you install the most stable release of 3.2 series,<br>>> > > > > > 3.2.3,<br>>> > > > > > because this realease has some bugs fixed.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > Enabled the debug mode in the pgpool.conf.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > start pgpool like this: pgpool -a pool_hba_file -d -f<br>>> > > > > > pgpool_config_file<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > In debug mode you should see any kind of information about<br>>> > > > > > the<br>>> > > > > > autentication process.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > In any moments I had been the same problem but it was<br>>> > > > > > related<br>>> > > > > > with<br>>> > > > > > the configuration access (chmod and shown comands) over the<br>>> > > > > > pool_hba.conf and pool_password file.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > Another reasons, If you have 2 pg servers or more, each<br>>> > > > > > server<br>>> > > > > > need<br>>> > > > > > to has the same autentication configuration.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > Regards.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > Sorry for my poor english.<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > ----- Mensaje original -----<br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > Pgpool log say everything ok, that's seems weird because<br>>> > > > > > > md5<br>>> > > > > > > crypt<br>>> > > > > > > is<br>>> > > > > > > wrong so i cant' understand why it's working in this<br>>> > > > > > > case.<br>>> > > > > > > I<br>>> > > > > > > feel<br>>> > > > > > > a<br>>> > > > > > > huge mistake from myself but i can't see where .<br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > Pgpool connection vs pg server is ok (everything work<br>>> > > > > > > well<br>>> > > > > > > with<br>>> > > > > > > pg<br>>> > > > > > > client).<br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > Regards.<br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > ----- Original Message -----<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > From: Lazaro Ruben Garcia Martinez<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > Sent: 03/14/13 03:27 PM<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > To: uruvela of india<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > Subject: Re: [pgpool-general: 1485] pgpool and md5 auth<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > What says pgpool log file?<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > Regards.<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > Would you try to connect to pg server from pgpool<br>>> > > > > > > > machine,<br>>> > > > > > > > but<br>>> > > > > > > > only<br>>> > > > > > > > from pgpool machine for testing is the pg service could<br>>> > > > > > > > accept<br>>> > > > > > > > connections from this machine??<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > Regards.<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > ----- Mensaje original -----<br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > Hi,<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > I'm looking for some help with MD5 authentification<br>>> > > > > > > > > in<br>>> > > > > > > > > pgpool.<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > 1st :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > pgpool-II version 3.2.2 (namameboshi)<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > PG 9.2.3<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > * On PG server : I create a toto role with encrypted<br>>> > > > > > > > > password,<br>>> > > > > > > > > and<br>>> > > > > > > > > add this line in pg_hba.conf :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > host mydb toto my_pgpool_ip/32 md5<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > Restarting PG.<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > * On pgpool server :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > pgpool.conf :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > enable_pool_hba = on<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > pool_passwd = 'pool_passwd'<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > Create toto md5 password in pool_passwd :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > toto:md5cb926329843e9a8f3eb15e0a2a5c9851<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > Checking same thing in PG in pg_authid :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > | toto | md5cb926329843e9a8f3eb15e0a2a5c9851 |<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > pool_hba.conf :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > add this line : local mydb toto md5<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > 2nd :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > Starting pgpool.<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > Using perl script dbi.pl to test on pgpool server :<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > use DBI;<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $DB_name = 'mydb';<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $DB_user = 'toto';<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $DB_pwd = 'mypassword';<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $dbh =<br>>> > > > > > > > > DBI->connect("dbi:Pg:dbname=$DB_name","$DB_user","$DB_pwd");<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > if ( !defined $dbh ) { die "Cannot connect to<br>>> > > > > > > > > database!\n";<br>>> > > > > > > > > }<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $sth = $dbh->prepare("SELECT * FROM pg_user");<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $sth->execute();<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > while ( ($id,$name) = $sth->fetchrow_array() ) {<br>>> > > > > > > > > print<br>>> > > > > > > > > "$id\t\t<br>>> > > > > > > > > $name<br>>> > > > > > > > > \n";<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > }<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $sth->finish();<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > $dbh->disconnect();<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > 1st launch : working<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > 2nd launch : changing md5 to reject in pool_hba.conf<br>>> > > > > > > > > (restarting<br>>> > > > > > > > > pgpool) : DBI connect('dbname=mydb','toto',...)<br>>> > > > > > > > > failed:<br>>> > > > > > > > > ERROR:<br>>> > > > > > > > > no<br>>> > > > > > > > > pool_hba.conf entry for host "[local]", user "toto",<br>>> > > > > > > > > database<br>>> > > > > > > > > "mydb"<br>>> > > > > > > > > at dbi.pl line 5<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > 3rd launch : back to md5 in pool_hba.conf and<br>>> > > > > > > > > changing<br>>> > > > > > > > > toto<br>>> > > > > > > > > by<br>>> > > > > > > > > tito<br>>> > > > > > > > > in pool_passwd (restarting pgpool) : DBI<br>>> > > > > > > > > connect('dbname=mydb','toto',...) failed: ERROR:<br>>> > > > > > > > > "MD5"<br>>> > > > > > > > > authentication with pgpool failed for user "toto" at<br>>> > > > > > > > > dbi.pl<br>>> > > > > > > > > line<br>>> > > > > > > > > 5<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > 4th launch : back to toto vs tito in pool_passwd and<br>>> > > > > > > > > deleted<br>>> > > > > > > > > everything after md5 (now pool_passwd is like this<br>>> > > > > > > > > 'toto:md5')<br>>> > > > > > > > > +<br>>> > > > > > > > > restarting pgpool : working.<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>> <br>>> > > > > > > > > I miss something i'm sure :) but why it's working in<br>>> > > > > > > > > 4th<br>>> > > > > > > > > try<br>>> > > > > > > > > ?<br>>> > > > > > > > > It's<br>>> > > > > > > > > seems only PG server do it's authentification job's.<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > _______________________________________________<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > pgpool-general mailing list<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > pgpool-general@pgpool.net<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br>>> > > > > > > > > http://www.pgpool.net/mailman/listinfo/pgpool-general<br>>> > > > > > > > <br>>> > > > > > > <br>>> > > > > > <br>>> > > > > <br>>> > > > <br>>> > > <br>>> > <br>>> <br></blockquote><br></div></body></html>