No entry is registered for key 'db'


(Lorax) #1

When attempting to install piwik, the first couple of pages are fine, but on “Database setup” I get the error:

Error while trying to connect to the database server:
No entry is registered for key ‘db’

The settings I’m attempting to use are (in field order):

127.0.0.1
piwik
thecorrectpassword
piwik
piwik_
mysqli

(mysqli is the only option available in the form)

(I’ve also tried “localhost” the FQDN of the host, the IP, etc.)

I see in the forums a similar error with an older version of piwik and an inability to write the configuration file, permissions are correct for this to be written by the httpd uid.

Additionally, if I manually create config.ini.php with appropriate values, I get the following error:
The mysql driver is not currently installed
Backtrace:

#0 /oanda/httpd/htdocs/piwik/libs/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /oanda/httpd/htdocs/piwik/core/Db/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /oanda/httpd/htdocs/piwik/core/Piwik.php(1473): Piwik_Db_Pdo_Mysql->getConnection()
#3 /oanda/httpd/htdocs/piwik/core/FrontController.php(218): Piwik::createDatabaseObject()
#4 /oanda/httpd/htdocs/piwik/index.php(90): Piwik_FrontController->init()
#5 {main}

This is of course rather odd and vexing, as a simple php test script which connects to the database works without issue.


(draingirl) #2

[quote=Lorax @ Oct 27 2009, 03:49 PM]When attempting to install piwik, the first couple of pages are fine, but on “Database setup” I get the error:

Error while trying to connect to the database server:
No entry is registered for key ‘db’

The settings I’m attempting to use are (in field order):

127.0.0.1
piwik
thecorrectpassword
piwik
piwik_
mysqli

(mysqli is the only option available in the form)

(I’ve also tried “localhost” the FQDN of the host, the IP, etc.)

I see in the forums a similar error with an older version of piwik and an inability to write the configuration file, permissions are correct for this to be written by the httpd uid.

Additionally, if I manually create config.ini.php with appropriate values, I get the following error:
The mysql driver is not currently installed
Backtrace:

#0 /oanda/httpd/htdocs/piwik/libs/Zend/Db/Adapter/Pdo/Mysql.php(96): Zend_Db_Adapter_Pdo_Abstract->_connect()
#1 /oanda/httpd/htdocs/piwik/core/Db/Pdo/Mysql.php(30): Zend_Db_Adapter_Pdo_Mysql->_connect()
#2 /oanda/httpd/htdocs/piwik/core/Piwik.php(1473): Piwik_Db_Pdo_Mysql->getConnection()
#3 /oanda/httpd/htdocs/piwik/core/FrontController.php(218): Piwik::createDatabaseObject()
#4 /oanda/httpd/htdocs/piwik/index.php(90): Piwik_FrontController->init()
#5 {main}

This is of course rather odd and vexing, as a simple php test script which connects to the database works without issue.[/quote]

I had the same problem.
Contact your hoster and ask him if Pdo_mysql is installed.
This could be the problem.


(avatarworf) #3

[quote=draingirl @ Nov 23 2009, 07:50 PM]I had the same problem.
Contact your hoster and ask him if Pdo_mysql is installed.
This could be the problem.[/quote]

Yes, the " extension=pdo_mysql.so " object needed to be installed before the db could be created.

Shouldn’t this extension be in the pre-flight checks?