Re: Postgre/PHP installation woes

2004-02-25 Thread jdc
Quoting Danny O'Brien <[EMAIL PROTECTED]>: > > OK -- many thanks, much better ... > However, the page is still refusing logins and passwords that were > scripted into the DB (from the "fake_data" file), including the > postgres db main user (not postgres, in our case). > > So, my next stop is

Re: Postgre/PHP installation woes

2004-02-25 Thread Chris Hewitt
Danny O'Brien wrote: Parse error: parse error in /var/www/srp/dbconnect.php on line 5 With this error... $link = pg_connect ("", "", "", "", "ourdb" or die ( "Could not connect to database." ); You are missing a closing bracket for pg_connect. With the bracket: $link =

Re: Postgre/PHP installation woes

2004-02-25 Thread Danny O'Brien
OK -- many thanks, much better -- the parse error is gone, so it appears that the PHP page is connecting to the database! Alll right! (Please forgive the missing ')' in the string below, I'm not a PHP programmer, but I'm learning in a hurry. And under the old config, these files worked perf

Re: Postgre/PHP installation woes

2004-02-25 Thread jdc
Quoting Danny O'Brien <[EMAIL PROTECTED]>: ... > This led me to examine "dbconnect.php" -- the following line is present: > > $link = pg_connect ("", "", "", "", "ourdb" or > die ( "Could not connect to database." ); Danny, First of all, that code snippet can't be rig

Re: Postgre/PHP installation woes

2004-02-25 Thread charlie derr
My recommendation (I didn't see this in your extensive littany of steps taken) is to add the following line to /etc/postgresql/postgresql.conf and then restart postgresql) tcpip_sociket = 1 good luck, ~c Danny O'Brien wrote: Thanks to everyone for the helpful replies (my or

Re: Postgre/PHP installation woes

2004-02-25 Thread Danny O'Brien
Thanks to everyone for the helpful replies (my original post is below, under the line). It appears that PHP is not connecting to our postgre database, as indicated by the following error that appears on the main PHP web page: Parse error: parse error in /var/www/srp/dbconnect.php on line 5

Re: Postgre/PHP installation woes

2004-02-24 Thread Joost De Cock
On Tuesday 24 February 2004 18:50, Danny O'Brien shoved this is my mailbox: > ... We have a PHP4 site that worked fine > under a previous RedHat build, but we just can't get it working on this > Debian build. ... > But when we go to login to our PHP site, our login is rejected and we > get the fol

Re: Postgre/PHP installation woes

2004-02-24 Thread Monique Y. Herman
On 2004-02-24, Danny O'Brien penned: > > > Warning: Supplied argument is not a valid PostgreSQL link resource in >/auth.php on line 10 > > Line 10 in auth.php looks like this: > > $result = pg_exec( $link, $sql ); > Well, first of all, from http://us2.php.net/manual/en/function.pg-query.php : No

Re: Postgre/PHP installation woes

2004-02-24 Thread Oliver Elphick
On Tue, 2004-02-24 at 17:27, Danny O'Brien wrote: > Any postgre experts out there? We have a PHP4 site that worked > fineunder a previous RedHat build, but we just can't get it working > onthis Debian build. ... > But when we go to login to our PHP site, our login is rejected and we > get the foll

Postgre/PHP installation woes

2004-02-24 Thread Danny O'Brien
Any postgre experts out there? We have a PHP4 site that worked fine under a previous RedHat build, but we just can't get it working on this Debian build. Here's what we're running: Debian 3.0r1 "woody" Kernel 2.4.18-bf2.4 Apache 1.3.26-0woo postgres 7.2.1-2wood php 4.1.2-6wood We've applied a s