[SOLVED!] Install HELP: database extensions

[babenj]

Hello everyone,

I'd like apologize in advance if this question has been asked and answered before. I have exhausted my limited time in searching for some answers. I have a new installation and did my best to ensure sure that the Serendipity install requirements (php, database, perms, etc) are met.

The Serendipity installation shows an error in the database extensions and can't proceed with the installation

Here's the URL:

http://....

My configuration:
postgresql-server-7.4.16-1 on a RHEL 4 server
php 4.3.9

I created a database 'serendipity' and granted the user full privilege with "gran all to...". I dont have any ideas what else to check or if I missed any install steps which I carefully followed.

Any help is greatly appreciated!

Best regards,
bbj

[garvinhicking]

Hi!

You must compile your php with "--with-pgsql" to make PHP able to have a database extension. If you use a packaged PHP, try to install a php-pgsql package, or php-postgres?

HTH,
Garvin

[babenj]

Hi Garvin,

Thank you for your quick reply! I was missing the php-pgsql-4.3.9-3.24 package in my RHEL 4 installation. I downloaded and installed the package, restarted the 'httpd' service, re ran the Serendipity installation and I was good to go!

Interestingly, I was going to update my post when I came across your reply. Your suggestion would've worked perfectly.

Thank you Garvin!

Hi!

You must compile your php with "--with-pgsql" to make PHP able to have a database extension. If you use a packaged PHP, try to install a php-pgsql package, or php-postgres?

HTH,
Garvin

[babenj]

Hi Gavin,

I can not specify the 'database type' in the simple or expert install mode. Should this be populated automagically from the previous pre-install report?

[babenj]

Hi Gavin,

My install, whether in simple or expert mode, keeps returning back to the pre-installation report page after completing all the fields and then clicking on "complete installation".

What else am I missing or what should I check?

Thanks!

[babenj]

While debugging an earlier install problem in the config_local.inc.php, I managed to screw up that file. Good thing I made a backup of the original config_local file. Now, the installation properly detects PostgreSQL as my database.

But now I can not connect to the database

From command line, i'm able to connect to database using 'psql serendipity'

I'm able to grant privileges while connected to database.

What else am I missing?

Thanks in advance for your help.

BBJ

[garvinhicking]

Hi!

You might need to configure your postgres master.conf file to allow connections from the psql client, which uses socket connections or something like that. It might be that currently your www-user is not allowed to access pgsql.

Sadly I don't use pgsql, so I can't help you much more with that

Best regards,
Garvin

[babenj]

Hello Gavin!

You have given me the critical clue regarding my problem: database tcp connection configuration.

I'm not familiar with postgresql database either but I have experience with other databases (IBM Informix, SQL Server, and MySQL). And in each database, you must configure host files to accept tcp connections. That was my problem, but I didn't know how to do it in postgresql.

I few minutes of googling yielded a positive link, which ultimately solved my problem. Here's the link: http://tinyurl.com/3ya8ao

Now my Serendipity BLOG space is up!!!

I'll find some time to contribute a tech how-to on how to install Serendipity on Redhat Enterprise Linux - AS v 4 with PostgreSQL with all of the config changes I made to get Serendipity installed, configured, and working -- as a token of my sincere appreciation for all your (and others) efforts.

Thanks again Gavin!

Hi!

You might need to configure your postgres master.conf file to allow connections from the psql client, which uses socket connections or something like that. It might be that currently your www-user is not allowed to access pgsql.

Sadly I don't use pgsql, so I can't help you much more with that

Best regards,
Garvin

[garvinhicking]

Hi!

Great to hear that it worked, and thanks for your wish to contribute to the s9y documentation. That would be most welcome

Best regards,
Garvin