php - Issue connecting to postgresql using pdo on localhost (08006) -


i have set test server , installed php 5.4 (zend server nginx) , postgresql 9.1.

i trying connect postgresql database using following code:

define('db_type', 'pgsql'); define('db_host', 'localhost'); define('db_port', 5432); define('db_name', 'rockprofile'); define('db_username', 'rockprofile'); define('db_password', 'password');  $dsn = db_type . ':dbname=' . db_name . ';host=' . db_host . ';port=' . db_port;  try {    $db = new pdo($dsn, db_username, db_password); } catch (pdoexception $e) {    echo $e->getmessage();    print_r($e->gettrace()); }

however generating following:

sqlstate[08006] [7] fatal: ident authentication failed user "rockprofile"  array (    [0] => array (        [file] => /usr/share/nginx/inc/config.php        [line] => 24        [function] => __construct        [class] => pdo         [type] => -> [args] => array (             [0] => pgsql:dbname=rockprofile;host=localhost;port=5432             [1] => rockprofile             [2] => password ) )    [1] => array ( [file] => /usr/share/nginx/bands/index.php        [line] => 2        [args] => array (             [0] => /usr/share/nginx/inc/config.php )             [function] => include ) )

as can see using localhost. know dsn correct including username , password because if substitute localhost local 192 ip works. suspect issue configuration of postgresql , following current content:

local                                                  peer host                           127.0.0.1/32            ident host                           ::1/128                 ident host                            192.168.1.0/24          md5

on searching appeared resolve changing ident trust on config above has not helped in case.

it simple need add searches seem fruitless @ moment. can tell me how correct this.

*-----edit-----*

as per daniel vérité's response fix issue ident needs changed md5. had change both ipv4 , ipv6 entries.

local                                                  peer host                           127.0.0.1/32            md5 host                           ::1/128                 md5 host                            192.168.1.0/24          md5

see http://www.postgresql.org/docs/9.1/static/auth-methods.html:

the ident authentication method works obtaining client's operating system user name ident server , using allowed database user name (with optional user name mapping)

the ident authentication method not suited connections web server, because web processes run under account, typically www-data or such has no relationship databases account (rockprofile in case).

since want authentication password, replace md5 in pg_hba.conf , reload or restart postgresql.

also may change password because appears in clear in trace, negating substitution effort in code.


Comments

Post a Comment

Popular posts from this blog

How to mention the localhost in android -

i trying call localhost in android application. unfortunately not possible used several methods emulator local host http://10.0.2.2/android/dbconnection.php and network ip address http://192.168.1.xx/android/dbconnection.php also http://localhost:8080/android/dbconnection.php but nothing connected localhost. purpose refer stackoverflow answers not working i facing same problem when worked on localhost. referred stackoverflow answer got solution create new emulator works fine in new emulator.
Read more

php - Calling a template part from a post -

i include iframe within post in wordpress. located inside content of post, meaning cannot in post template file, otherwise either before or after. i'd add facebook plugin within posts: <div id="socialwrap"><div class="fb-like" data-href="http://onlinearizonahomes.info" data-send="true" data-width="450" data-show-faces="true" data-font="arial"></div></div> i thinking of calling template part within post <?php get_template_part( 'social' ); ?> cannot use php within post without plugin (i'd avoid using plugin this). an alternative using javascript create html in post, seems unnecessary use of javascript. what best way add html within wordpress post? you can use shortcode. add functions.php function cudjex_fbshare( $atts, $content = null ) { global $post; $link = get_permalink($post->id); return '<div id="socialwrap...
Read more

c# - String.format() DateTime With Arabic culture -

check below code snippet, namespace testdateconvertion { class program { static void main(string[] args) { datetime testvalue = new datetime(2013, 12, 15, 15, 33, 44); cultureinfo culture = new cultureinfo("ar-sa"); string stringvalue = string.format(culture, "{0:d} {0:hh:mm:ss}", testvalue); console.writeline(stringvalue); console.readline(); } } } it gives output 22/02/35 15:33:44 i not getting how possible. whats 35 doing in output there that's 13/12/2015 in hijri, 35 means 1435 in hijri, default date format saudi arabia.
Read more