From: | Shad Keene <shadkeene(at)hotmail(dot)com> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | perl and php connect problems to pgsql all of a sudden |
Date: | 2011-06-07 15:21:27 |
Message-ID: | BLU149-W48C4757411DE16B6B9A540B1630@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm getting some errors all of a sudden when using PHP and Perl to connect to my postgresql database.
I'm running Red Hat Enterprise Linux Client release 5.6 (Tikanga)
And php-5.1.6-27.el5_5.3
perl-5.8.8-32.el5_5.2
Here's the php error when trying to connect:
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pdo_pgsql.so' - libpq.so.4: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib64/php/modules/pgsql.so' - libpq.so.4: cannot open shared object file: No such file or directory in Unknown on line 0
And the perl error:
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib64/perl5/vendor_perl/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi /usr/lib/perl5/5.8.8 .) at (eval 3) line 3.
Perhaps the DBD::Pg perl module hasn't been fully installed,
or perhaps the capitalisation of 'Pg' isn't right.
Available drivers: DBM, ExampleP, File, Proxy, Sponge, mysql.
at pg_connect.pl line 9
This is strange because the same exact scripts worked about a month ago. And I do have DBD/pg.pm installed and pgsql.so and pdo_pgsql.so are also installed.
Is there a simple fix to this? I have read some ideas about installed libpq.so.4 to fix this, but I wanted to run this specific problem by some experts before making any changes.
Thanks for any help,
S
From | Date | Subject | |
---|---|---|---|
Next Message | Vincent Veyron | 2011-06-07 15:37:57 | Re: Recurring events |
Previous Message | Thomas Guettler | 2011-06-07 14:25:28 | Re: Recurring events |