Php in Symfony and php run from the command line are loading different drivers

Question

I am trying to connect to a remote sql server, and have succeeded in doing so from the command line. When running php -i | grep PDOI get

PDO
PDO support => enabled
PDO drivers => sqlsrv, dblib, mysql
PDO Driver for FreeTDS/Sybase DB-lib => enabled
PDO Driver for MySQL => enabled`

When running a php script from the command line, I can connect to the remote DB no problem. When running that exact same code in my Symfony application, I get

[Doctrine\DBAL\Driver\PDOException]                              
SQLSTATE[01002] Adaptive Server connection failed (severity 9)

When I run phpinfo() in Symfony, the only PDO driver that comes up is mysql

When I run phpinfo() from the command line, I get mysql, sqlsrv, and dblib

Why are some pdo drivers not loading in Symfony?

Edit: The DB is configured properly in Symfony as php bin/console doctrine:query:sql "SELECT * FROM my_table" returns results. The same query executed in Symfony errors with "could not load driver"

You have two different php.ini files on your system. Run php --ini and compare it to the path listed via phpinfo — Cerad
– Cerad, Commented Feb 16, 2017 at 1:15
@cerad, both show /etc/php/7.0/cli/php.ini as the loaded config file — Alex Slocum
– Alex Slocum, Commented Feb 16, 2017 at 1:39
The mods enabled can also be different. Check the /etc/php/7.0/apache or fpm or whatever folder and see if the pdo mod is enabled like it is in the cli folder — mickadoo
– mickadoo, Commented Feb 16, 2017 at 10:08
Just for grins, try running the builtin symfony server bin/console server:run It really should not make any difference but for some reason your server is getting the php configuration information from someplace else. Are you doing some kind of docker or vagrant thing? — Cerad
– Cerad, Commented Feb 16, 2017 at 13:22

Community · Accepted Answer · 2017-05-23 11:53:59Z

0

Did you mention those pdo drivers in the app/config.yml file in your symfony project ?

You need to tell symfony ( that means write it in the config.yml file ) about those drivers in order for him to recognize and use them.

Check out this topic, it may help you, it is about using a mysql pdo driver and a postgresql pdo driver

Use a postgres database with symfony3

edited May 23, 2017 at 11:53

CommunityBot

11 silver badge

answered Feb 16, 2017 at 0:56

paris93

2021 gold badge2 silver badges16 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Alex Slocum Over a year ago

I had, but this got me to the solution nonetheless. Turns out you can't directly set a driver to "dblib", but this link creates a driver class you can use instead. Thanks for getting me there, marking this correct

Alex Slocum Over a year ago

Scratch that, didn't actually get me there. I was able to connect to the DB using doctrine, but again, only from the command line using bin/console. When I run a query in the app, I get "Could not load driver"

Collectives™ on Stack Overflow

Php in Symfony and php run from the command line are loading different drivers

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related