Page 1 of 1

Database extensions -> red

Posted: Mon Oct 22, 2007 6:31 pm
by cntlzw
Hi folks,

everything green on the first screen, but database extension stays red. Postgresql is up and running located in /usr/local/pgsql. I set up a user account and database, but it looks like my database is not in the search path. Sorry, I am not a php-Coder looking at the code doesn't help me much, gives me headaches instead ;-)
Searched forum but didn't find a solution.

Thanks in advance!

Re: Database extensions -> red

Posted: Tue Oct 23, 2007 9:30 am
by garvinhicking
Hi!

Your PHP is missing the DB extension. You must recompile PHP with pgsql/mysql/... support to be able to use any DB with PHP.

You might need to ask your server provider to do that, if you don'T know how to compile PHP.

Regards,
Garvin

Posted: Tue Oct 23, 2007 10:55 am
by cntlzw
Hi garvinhicking,

there is pgsql.so in /usr/lib/php5/20051025/pgsql.so. I added the following entrys in php.ini

pgsql.allow_persistent = On
pgsql.auto_reset_persistent = Off
pgsql.max_persistent = -1
pgsql.max_links = -1
pgsql.ignore_notice = 0
; Unless pgsql.ignore_notice=0, module cannot log notice message.
pgsql.log_notice = 0
extension=pgsql.so

So it looks like I already have support.

Posted: Tue Oct 23, 2007 11:53 am
by cntlzw
Ok, its up and running.

Well, quite embarrasing for me but I forgot to restart apache after installing the php5 postgresql extension. Shame on me ;-)

But thanks for the quick reply!