@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 Owner

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

@mattab commented on June 30th 2008 Owner

(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_pdomysql.dll both uncommented in my php.ini file

I have even restarted my IIS server after changing these.

@mattab commented on July 1st 2008 Owner

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