Ticket #260 (closed Bug: invalid)

Opened 4 months ago

Last modified 3 months ago

Error on Installation > Step 2

Reported by: joelji Assigned to:
Priority: major Milestone: RobotRock
Component: Core Version:
Keywords: Cc:

Description

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.

Attachments

piwik-error.gif (69.5 kB) - added by joelji on 06/25/08 12:28:02.
Installation-Error

Change History

06/25/08 12:28:02 changed by joelji

  • attachment piwik-error.gif added.

Installation-Error

06/25/08 12:30:19 changed by joelji

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

06/26/08 23:14:27 changed by MHudson

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.

(follow-up: ↓ 6 ) 06/30/08 01:20:44 changed by matt

  • milestone set to RobotRock.

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

06/30/08 01:21:04 changed by matt

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

06/30/08 15:26:49 changed by MHudson

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.

(in reply to: ↑ 3 ) 07/01/08 15:15:06 changed by joelji

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.

(follow-up: ↓ 10 ) 07/01/08 15:31:29 changed by 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

07/01/08 22:01:57 changed by MHudson

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

Thank you.

07/01/08 23:37:10 changed by matt

  • status changed from new to closed.
  • resolution set to invalid.

(in reply to: ↑ 7 ) 07/03/08 07:14:36 changed by joelji

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.