Bug #67036
closed
Switching between two RDBMS using dbal
Added by alexis nicolas over 9 years ago.
Updated about 9 years ago.
Category:
Database API (Doctrine DBAL)
Description
Hello there,
I set up T3 v7.2 to run with PostgreSQL but I need a fallback to MySQL. To do so I changed LocalConfiguration.php parameters to point to a working mysql server, but backend login form returns "Database connect not successful. Connecting to the database with given settings failed. Please check."
Have I forgotten to change parameters or is it a bug?
Thanks by advance,
Alex
- Status changed from New to Needs Feedback
Is there some configuration for the default DBAL handler in your LocalConfiguration.php?
'EXTCONF' => array (
'dbal' => array (
'handlerCfg' => array (
'_DEFAULT' => array(
'type' => 'adodb',
'config' => array(
'driver' => 'postgres',
),
),
),
),
)
If you switch to MySQL this needs to be changed to the mysql driver too.
At this moment, it works with PostgreSQL, my LocalConfiguration.php is this:
'EXTCONF' => array(
'dbal' => array(
'debugOptions' => array(
'enabled' => TRUE,
'numberRows' => TRUE,
'printErrors' => TRUE,
),
'handlerCfg' => array(
'_DEFAULT' => array(
'type' => 'adodb',
'config' => array(
'driver' => 'postgres',
),
),
),
),
),
I'm trying switching to mysql driver but, surprisingly, it complains about the use of mysql_connect function. I thought mysqli or PDO were already in use.
If I read it correctly you have two choices for switching back to MySQL:
1 - Set the key 'type' to 'native'
2 - Use 'mysqli' as driver type, not 'mysql', the latter uses the deprecated mysql_* functions
- Status changed from Needs Feedback to Closed
No feedback within the last 90 days => closing this issue.
If you think that this is the wrong decision or experience this issue again, then please write to the mailing list typo3.teams.bugs with issue number and an explanation or open a new ticket and add a relation to this ticket number.
Also available in: Atom
PDF
Updated by 
Updated by 
Updated by 
Updated by