Thread: Re: [NOVICE] Accessing Postgres db from apache using PHP
Re: [NOVICE] Accessing Postgres db from apache using PHP
From
christoph.dellavalle@goetheanum.ch
Date:
I'm not sure, but I think you have to start postgres with the option -i to allow it to use TCP/IP. if you get a socket error look at the php.ini, sockets.unix_socket_directory = /tmp, go to the directory indicated thereand have a look, if there is a socket. PHP and postgres both have a setting for the socket directory and they mustbe the same. Hope it helps, Christoph Della Valle >-----Ursprüngliche Nachricht----- >Von: bruce [mailto:bedouglas@earthlink.net] >Gesendet: Montag, 28. Juli 2003 03:00 >An: pgsql-novice@postgresql.org; pgsql-php@postgresql.org >Betreff: [NOVICE] Accessing Postgres db from apache using PHP > > >Hi... > >I'm new to Postgres... I've installed Postgres on a Linux RH >8.0 server. I'm >trying to access a pgsql db from an Apache website, using >PHP(v-4.2.2). I've >taken a look at google and through the archives with no real luck... > >I created a Linux user and given the user rights to the Postgres group. >I created a Linux user (gforge) and given it rights to the >Postgres group. >Using the gforge user, I created a postgres user, using > -> createuser gforge - W >I gave the user the password of ->gforge > >I gave the user rights to add/create databases, but not add new users >I then installed a database. > pgsql -U gforge -d gforge < gforge3.sql > >At this point, I can see that I have a db in postgres.... >I did a "\l" and it displayed: > name owner encoding >-->> gforge gforge sql_ascii > > >In my php code, I have.... > >$sys_dbhost = "localhost"; >$sys_dbname = "gforge"; >$sys_user = "gforge"; >$sys_dbpasswd = "gforge"; > >i then do a: > $tmp = "host=localhost dbname=gforge user=gforge >password=gforge"; > $conn = @pg_connect($tmp); > >at this point $conn is not set... it should be a resouce if >I've connect to >the DB..!!!!!!! > >So.. the question... Anybody have any idea as to what I've >done wrong/left >out/etc... > >Any pointers/comments/criticisms would be helpful..... >Any sample docs, or code that illustrates how this should be >accomplished >would be helpful... > > >Thanks... > >Bruce Douglas >(925) 866-2790 >bedouglas@earthlink.net > > >---------------------------(end of >broadcast)--------------------------- >TIP 4: Don't 'kill -9' the postmaster >