PDO is installed but not working in shell

deydod

Hi
I can see that PDO is installed via phpinfo function. I am trying to execute a simple shell script that I have used on previous server to connect another database and grab data from there, however I am getting this error:
PHP Fatal error: Uncaught PDOException: could not find driver in xxxxxx.php

with php -m I can see that the module is loaded.

Any ideas?

aaPanel_Jose

Hello deydod
When you use PHP to execute the script, did you specify the php with PDO installed?
E.g
/www/server/php/73/bin/php xxx.php

deydod

Hi
Yes, I've tried both commands "php" and "/www/server/php/74/bin/php", both returning same error.

deydod

I've figured it out.

What I needed was pdo_pgsql module to be installed, but in order to install that module you need to install PostgreSQL on your server. In my case I am doing only remote connection to another server with PostgreSQL and I am fetching data from it (local server uses MySQL). Hope this helps to others with same problem.