Ok, I seem to have found the issue... PDO Mysql driver does not accept a dsn in the format:
mysql://user:[EMAIL PROTECTED]/session_db instead you must specify: dsn: mysql:host=x.x.x.x;dbname=session_db username: user password: pass Maybe a note could be added to the docs to clarify this? On Nov 4, 10:49 am, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi, first off let me apologise for posting this here, I know it's not > strictly a dev issue but I've run out of ideas on what could be > causing this - I've tried the IRC channel and forum but no one seems > to be able to help. I thought i'd have one last try here to check I'm > doing everything correctly before I report it as a bug. > > I'm using Symfony 1.0.18 / Propel 1.2 > > I have sfMySQLSessionStorage + sfPropelDatabase working ok. I thought > it would be a simple swap-out for sfPDOSessionStorage + sfPDODatabase > but I seem to be running up against a very strange error. > > Using exactly the same dsn (which connects to a separate db server) > for sfPDODatabase as I used with sfPropelDatabase, I get the > following: > > sfDatabaseException: SQLSTATE[HY000] [2002] Can't connect to local > MySQL server through socket '/tmp/mysql.sock' (111) in /usr/local/ > symfony/symfony10/lib/database/sfPDODatabase.class.php on line 60 > > More details here:http://www.lazymanc.com/images/sfpdoerror.png > > So it seems to be completely ignoring the DSN for some reason? > > If I create a simple PHP script (not using Symfony) using exactly the > same DSN I can connect and query the server using PDO with no issues. > > My forum post for more > details:http://www.symfony-project.org/forum/index.php/t/16589/ > > What am I doing wrong? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/symfony-devs?hl=en -~----------~----~----~----~------~----~------~--~---
