<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: Times New Roman; font-size: 14pt; color: #000000'>Could you install the most stable release of 3.2 series, 3.2.3, because this realease has some bugs fixed.<br><br>Enabled the debug mode in the pgpool.conf.<br><br>start pgpool like this: pgpool -a pool_hba_file -d -f pgpool_config_file<br><br>In debug mode you should see any kind of information about the autentication process.<br><br>In any moments I had been the same problem but it was related with the configuration access (chmod and shown comands) over the pool_hba.conf and pool_password file.<br><br>Another reasons, If you have 2 pg servers or more, each server need to has the same autentication configuration.<br><br>Regards.<br><br>Sorry for my poor english.<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;"><span style="font-family:Verdana"><span style="font-size:12px"><span style="font-family:Verdana"><span style="font-size:12px">Pgpool log say everything ok, that's seems weird because md5 crypt is wrong so i cant' understand why it's working in this case. I feel a huge mistake from myself but i can't see where .<br><br>Pgpool connection vs pg server is ok (everything work well with pg client).<br><br>Regards.</span></span><p style="margin:0px; padding:0px;"> </p><blockquote style="border-left: 1px solid #CCC; padding-left: 5px; margin-left: 5px; margin-bottom: 0px; margin-top: 0px; margin-right: 0px;"><p style="margin:0px; padding:0px;"><span style="font-family:Verdana"><span style="font-size:12px">----- Original Message -----</span></span></p><p style="margin:0px; padding:0px;"><span style="font-family:Verdana"><span style="font-size:12px">From: Lazaro Ruben Garcia Martinez</span></span></p><p style="margin:0px; padding:0px;"><span style="font-family:Verdana"><span style="font-size:12px">Sent: 03/14/13 03:27 PM</span></span></p><p style="margin:0px; padding:0px;"><span style="font-family:Verdana"><span style="font-size:12px">To: uruvela of india</span></span></p><p style="margin:0px; padding:0px;"><span style="font-family:Verdana"><span style="font-size:12px">Subject: Re: [pgpool-general: 1485] pgpool and md5 auth</span></span></p> <div><div style="font-family: Times New Roman; font-size: 14pt; color: #000000">What says pgpool log file?<br><br>Regards.<br><br>Would you try to connect to pg server from pgpool machine, but only from pgpool machine for testing is the pg service could accept connections from this machine??<br><br>Regards.<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;"><div><p style="margin:0px; padding:0px; margin:0px; padding:0px; margin:0px; padding:0px;"><span style="font-family:Verdana"><span style="font-size:12px"><span style="font-family:Verdana"><span style="font-size:12px">Hi,<br><br>I'm looking for some help with MD5 authentification in pgpool.<br><br>1st :<br><br>pgpool-II version 3.2.2 (namameboshi)<br>PG 9.2.3<br><br>* On PG server : I create a toto role with encrypted password, and add this line in pg_hba.conf :<br>host mydb toto my_pgpool_ip/32 md5<br><br>Restarting PG.<br><br><br>* On pgpool server :<br><br>pgpool.conf :<br><br>enable_pool_hba = on <br>pool_passwd = 'pool_passwd'<br><br>Create toto md5 password in pool_passwd :<br><br>toto:md5cb926329843e9a8f3eb15e0a2a5c9851<br><br>Checking same thing in PG in pg_authid :<br><br>| toto | md5cb926329843e9a8f3eb15e0a2a5c9851 |<br><br>pool_hba.conf :<br><br>add this line : local mydb toto md5<br><br>2nd :<br><br>Starting pgpool.<br><br>Using perl script <a target="_blank" href="http://dbi.pl&lang=en">dbi.pl</a> to test on pgpool server :<br><br>use DBI;<br>$DB_name = 'mydb';<br>$DB_user = 'toto';<br>$DB_pwd = 'mypassword';<br>$dbh = DBI->connect("dbi:Pg:dbname=$DB_name","$DB_user","$DB_pwd");<br>if ( !defined $dbh ) { die "Cannot connect to database!\n"; }<br>$sth = $dbh->prepare("SELECT * FROM pg_user");<br>$sth->execute();<br>while ( ($id,$name) = $sth->fetchrow_array() ) { print "$id\t\t $name \n";<br>}<br>$sth->finish();<br>$dbh->disconnect();<br><br><br>1st launch : working<br><br>2nd launch : changing md5 to reject in pool_hba.conf (restarting pgpool) : DBI connect('dbname=mydb','toto',...) failed: ERROR: no pool_hba.conf entry for host "[local]", user "toto", database "mydb" at <a target="_blank" href="http://dbi.pl&lang=en">dbi.pl</a> line 5<br><br>3rd launch : back to md5 in pool_hba.conf and changing toto by tito in pool_passwd (restarting pgpool) : DBI connect('dbname=mydb','toto',...) failed: ERROR: "MD5" authentication with pgpool failed for user "toto" at <a target="_blank" href="http://dbi.pl&lang=en">dbi.pl</a> line 5<br><br>4th launch : back to toto vs tito in pool_passwd and deleted everything after md5 (now pool_passwd is like this 'toto:md5') + restarting pgpool : working.<br><br><br>I miss something i'm sure :) but why it's working in 4th try ? It's seems only PG server do it's authentification job's.</span></span></span></span></p></div><br>_______________________________________________<br>pgpool-general mailing list<br>pgpool-general@pgpool.net<br>http://www.pgpool.net/mailman/listinfo/pgpool-general</blockquote></div></div></blockquote><p style="margin:0px; padding:0px;"> </p></span></span>
</blockquote><br></div></body></html>