@anonymous-piwik-user opened this issue on June 25th 2008

I get the error "You need to enable the PDO and PDO_MYSQL extensions in your php.ini file." followed by "Uncaught exception: 'Translation string 'Installation_SystemCheckPdoErrorHelp' not available.' " while installing piwik in the server.

I used "php-5.2.6-win32-installer.msi" for installing php and "mysql-5.0.45-win32.zip" for installing mySql. Both installed properly.

I've made sure that php extensions are installed and i could find 'php_pdo.dll' and 'php_pdo_mysql.dll' in the "C:\Program Files\PHP\ext"

extension_dir ="C:\Program Files\PHP\ext" is also set correctly.

the modules are mentioned in php.ini file as following: ### CODE

. . . ; If you wish to have an extension loaded automatically, use the following ; syntax: ; ; extension=modulename.extension ; extension=php_pdo.dll extension=php_pdo_mysql.dll ; ; ; For example, on Windows: ; ; extension=msql.dll ; ; ... ### CODE

I've even reset the IIS by running 'iisreset' command after modifying these.

Not sure whether the default mysql user/password has to be set as "sa" "sa" which i mentioned while installing mysql. Still mentioned in php.ini as following: ### CODE

mysql.default_user = sa . . . mysql.default_password = sa ### CODE

Earlier before these final steps of modifying php.ini. I got error in both 'Pdo extension' and 'Pdo_Mysql extension' but after resetting IIS I got a checkmark in 'Pdo extension' but same error in 'Pdo_Mysql extension'. The error screenshot is attached. BTW this is installed in a windows 2003 server enterprise with SP2.

@anonymous-piwik-user commented on June 25th 2008

Attachment: Installation-Error piwik-error.gif

@anonymous-piwik-user commented on June 25th 2008

I've uncommented the line of adding extension....

@anonymous-piwik-user commented on June 26th 2008

I hate to say I don't have a solution but I do have the same problem.

I've installed this on my testing server. I set it up with the latest WampServer installation. I went through the GUI WampServer has and make sure the extensions were enabled.

@mattab commented on June 30th 2008

Check a phpinfo (<?php phpinfo(); ?>), do both pdo and pdo_mysql extension show up in the list?

@mattab commented on June 30th 2008

(In [542]) -refs #5680 fixing wrong error string

@anonymous-piwik-user commented on June 30th 2008

Nope. Didn't show up anywhere. I take it I need to fix that? Thank you. I'll see if I can install those extensions properly this time.

@anonymous-piwik-user commented on July 1st 2008

Replying to matt:

Check a phpinfo (<?php phpinfo(); ?>), do both pdo and pdo_mysql extension show up in the list?

Hi Matt, No. PDO_MYSQL is not showing up in the list. But I could see PDO. PDO drivers has no value under enabled column.

Also please help me out how to fix these. Im not sure how to enable these extensions.

I have extension=php_pdo.dll extension=php_pdo_mysql.dll both uncommented in my php.ini file

I have even restarted my IIS server after changing these.

@mattab commented on July 1st 2008

If they're not showing in your phpinfo, there must be aproblem. Check your error logs, php must complain that he cannot load the pdo_mysql dll

@anonymous-piwik-user commented on July 1st 2008

I corrected my installation of the pdo and pdo_mysql extensions and was able to complete the set up.

Thank you.

@anonymous-piwik-user commented on July 3rd 2008

Replying to matt:

If they're not showing in your phpinfo, there must be aproblem. Check your error logs, php must complain that he cannot load the pdo_mysql dll

Yes. The php installation was not complete it seems. libmysql.dll was not available in the php folder. I copied it from the zip file and installation succeeded. Thanks Man.

This issue was closed on July 30th 2009
Powered by GitHub Issue Mirror