Re: [NOVICE] Accessing Postgres db from apache using PHP

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]



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 there and have a look, if there is a socket.  PHP and postgres both have a setting for the socket directory and they must be the same.

Hope it helps,
Christoph Della Valle

>-----Ursprüngliche Nachricht-----
>Von: bruce [mailto:bedouglas@xxxxxxxxxxxxx]
>Gesendet: Montag, 28. Juli 2003 03:00
>An: pgsql-novice@xxxxxxxxxxxxxx; pgsql-php@xxxxxxxxxxxxxx
>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@xxxxxxxxxxxxx
>
>
>---------------------------(end of 
>broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>


[Index of Archives]     [Postgresql General]     [Postgresql Admin]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Backpacking]     [Postgresql Jobs]

  Powered by Linux