[FLOW3-general] MySQL Troubles
Erik Frister
ef at aijko.de
Sat Feb 27 22:18:04 CET 2010
Hi all,
I am trying to get a MySQL database connected to the Blog example.
However, after spending the entire day I think I am missing something :)
I am using FLOW3 alpha7. I created a MySQL database with
latin1_general_ci and executed the SQL in
/Packages/Framework/FLOW3/Resources/Private/Persistence/SQL/DDL.sql.
This all works (as an aside, it doesn't work with utf8_general_ci, MySQL
will throw a "max key length is 1000 bytes" error because of utf8 uses
18 bytes).
Then I added the following to the Settings.yaml
FLOW3:
persistence:
# Options for the default PDO backend
backendOptions:
dataSourceName: 'mysql:host=localhost;dbname=blog_dev'
username: ef
password: ef
However, I get an exception. I think I have to add some basic data to
the table (at least I read that in a post, but that concerned the
TYPO3CR), but right now I get:
SQLSTATE[HY000] [2002] No such file or directory
PDOException thrown in file
Packages/Framework/FLOW3/Classes/Persistence/Backend/PdoBackend.php in
line 0.
F3\FLOW3\Persistence\Backend\PdoBackend::connect()
Any hints as to which steps I have to do to connect a MySQL database?
What am I doing wrong?
Thanks in advance...
Erik
More information about the FLOW3-general
mailing list