Bug #15179
closed
Added by Allan Jacobsen over 18 years ago.
Updated over 17 years ago.
Category:
Database API (Doctrine DBAL)
Description
When installing from scratch, it is a uphill battle.
Setting things up as in the manual gives this every time:
Warning: mysql_pconnect(): Access denied for user: 'www-data@localhost' (Using password: NO) in /var/www2/typo3conf/ext/adodb/adodb/drivers/adodb-mysql.inc.php on line 356
DBAL error: Connection to mysql://:@/?persistent=1&fetchmode=3 failed. Maybe PHP doesn't support the database?
Changing the type to native gives the forms where it is possible to enter username,password and host, but not the db.
Changing back to adodb gives the possibility to select a database, and then we can get on to input the tables into the db.
Here "Update required tables COMPARE" creates the tables but gives you a lot of changes to the tables, just ignore them.
Then create an admin user account, and login should work.
Crating a page and template works but changing the password for the backend user gives this warning:
"Warning: Illegal offset type in /var/www2/typo3conf/ext/dbal/class.ux_t3lib_db.php on line 1402"
standard debian sarge linux. typo3 version 3.8.0.
(issue imported from #M1781)
Further investigation showed that the configured username,password etc. in the $TYPO3_CONF_VARS['EXTCONF']['dbal']['handlerCfg'] array is not used, dbal uses the values from "$typo_db_username" etc.
I even got it to work with postgres 7.4.7 (debian sarge).
Under both postgres and mysql(using adodb) these warnings appear:
when saving content many lines with " Illegal offset type in /var/www/intra/typo3conf/ext/dbal/class.ux_t3lib_db.php on line 1402"
followed with "
Warning: Cannot modify header information - headers already sent by (output started at /var/www/intra/typo3conf/ext/dbal/class.ux_t3lib_db.php:1402) in /var/lib/typo3/typo3_src-3.8.1/typo3/template.php on line 601"
When save-and-exit the same many warning lines come with this after:
"Warning: Cannot modify header information - headers already sent by (output started at /var/www/intra/typo3conf/ext/dbal/class.ux_t3lib_db.php:1402) in /var/lib/typo3/typo3_src-3.8.1/typo3/alt_doc.php on line 1097"
The $typo_db* values are used for the _DEFAULT handler only, if you define other handlers it will use the ones defined in the handler configuration (as documented).
But indeed the install tool didn't work as expected (and this was assumed in the manual). This is fixed now, even with DBAL installed one can now enter username, password, host and select the database for the _DEFAULT handler in the install tool.
Also available in: Atom
PDF
Updated by 
Updated by