Page 1 of 1

[SOLVED] Install Not Finding Database Drivers

Posted: Sat Sep 25, 2010 11:27 pm
by rshepard
During step 2 of the installation I'm told that the postgres database driver is not found. However, in /var/www/htdocs/cmsms/lib/adodb_lite/adodbSQL_drivers/postgres8/ I see:

index.html                         postgres8_extend_module.inc
postgres8_datadict.inc          postgres8_meta_module.inc
postgres8_date_module.inc  postgres8_transaction_module.inc
postgres8_driver.inc

What do I need to do so the installer recognizes that the drivers are present?

Thanks,

Rich

Re: Install Not Finding Database Drivers

Posted: Sun Sep 26, 2010 11:53 am
by rAndom90
You have to have postgresql driver loaded, what You see in ADOdb is just layer between real driver & ADO.

which means check php/ext (or wherever You have PHP extensions stored) directory, for php_pgsql, (if it's not there build it) check php.ini for extension=php_pgsql.so, if it's not there append this line.

Re: Install Not Finding Database Drivers -- FIXED

Posted: Sun Sep 26, 2010 3:52 pm
by rshepard
Thank you. I need to rebuild php with postgres support.

 Later this morning:

 I rebuilt php with postgres support. /etc/httpd/php.ini now includes
extension=pgsql.so
extension=pdo_pgsql.so

and /usr/lib/php/extensions/ has pgsql.so* and pdo_pgsql.so*. I restarted httpd but still see the same failed test: no db driver installed.

  A few minutes later:

  Restarting httpd once again fixed the problem. Thank you for your help.

Rich

Rich