WAMP+MyPhpAdmin

wielkaradosc

Hello my friends,
I have installed WAMP, but myphpadmin is still messed up.
It says that it cannot load mysqli module.
I have:
a) copied php_mysql.dll to c:\windows\system
b) copied php_mysqli.dll to c:\windows\system;
c) copied libmysql.dll to windows and windows\system
This line looks like this:
extension_dir = "c:/wamp/bin/php/php5.2.9-2/ext/"
and this one:
extension=php_mysql.dll
What else can I do?
When I try to edit htaccess in apache/alias directories/myphpadmin, there is a signal that such file does not exist.
Could it be blocked port 3306?
Please help.

bradgrafelman

First of all, I've never used WAMP so I can't tell you exactly how it's supposed to work, but I do know how to setup PHP and Apache separately, which is why I say the following:

Never move any PHP-related files from outside the main PHP directory (e.g. c:/wamp/bin/php/) - especially not into a Windows system directory. Not only is it unnecessary, but it creates problems when you change versions around.

So the first thing you need to do is remove all copies of files you've placed outside of the main PHP directory.

Then, check to make sure that the main PHP directory where files such as libmysql.dll should be located (e.g. c:/wamp/bin/php/php5.2.9-2/ from the looks of it) is in your system's PATH environment variable.

Next, since you're talking about the MySQLi extension, did you also check the extension= line for this module? The one you showed us above points to the older MySQL extension, not mysqli.

Don't forget that after making changes to your php.ini file you must restart Apache for those changes to take effect.

cahva

How did you mess up "idiotproof" system like Wamp? 🙂 If you've made some adjustments, have you tried to uninstall it and install it again? Mysqli extension works just by enabling it from the wamp icon from bottom right corner.

EDIT: and as bradgrafelman suggested, remove those that you copied to windows system folder. The extensions are loaded from the "C:/wamp/bin/php/php5.2.9-2/ext" folder.

wielkaradosc

Thanks for the answer, boys.
To be honest, I have no idea how it is possible that WAMP is not working properly (but it is worth mentioning that I am not the only person that is struggling with this issue). I did no adjustments, what I did (only yesterday, trying to find solution) was to change "/" to "\" in line:
c:/wamp/bin/php/php5.2.9-2/ext/
I read somewhere that it may be the reason WAMP is not working properly.
Here is the line: extension=php_mysqli.dll
The previously exported files are removed.
Just tell me that there is another way to do something with it.

cahva

So does your system work otherwise, just not mysqli? Does plain mysql work? You can test this with phpmyadmin. Change to 'mysql' in this line in config.inc.php:

$cfg['Servers'][$i]['extension']     = 'mysqli';     // The php MySQL extension to use ('mysql' or 'mysqli')

wielkaradosc

Cahva,
this line (C:\wamp\apps\phpmyadmin3.1.3.1\config.inc.php) already looks like this:
$cfg['Servers'][$i]['extension'] = 'mysql';
I have found something like this:

$phpDllToCopy = array (
'fdftk.dll',
'fribidi.dll',
'libeay32.dll',
'libmhash.dll',
'libmysql.dll',
'msql.dll',
'libmysqli.dll',
'ntwdblib.dll',
'php5activescript.dll',
'php5isapi.dll',
'php5nsapi.dll',
'ssleay32.dll',
'yaz.dll',
'libmcrypt.dll',
'php5ts.dll',
'php4ts.dll');

Shouldn't it be mysql.dll?

wielkaradosc

wielkaradosc;10919859 wrote:
Cahva,
this line (C:\wamp\apps\phpmyadmin3.1.3.1\config.inc.php) already looks like this:
$cfg['Servers'][$i]['extension'] = 'mysql';
I have found something like this:

Shouldn't it be mysql.dll?

These latter come from c:\wamp\scripts\config.inc.php.

cahva

wielkaradosc;10919859 wrote:
Cahva,
this line (C:\wamp\apps\phpmyadmin3.1.3.1\config.inc.php) already looks like this:
$cfg['Servers'][$i]['extension'] = 'mysql';
I have found something like this:

Shouldn't it be mysql.dll?

As you see there is also libmysql.dll and libmysqli.dll so that doesnt mean anything. This is just a config file that wamp uses to enable/disable extensions and stuff.

You didnt say if your Wamp system works at all or is it only mysql(i) you are having problems with?

When you go to http://localhost/ and click phpinfo(), does it show mysql and mysqli as installed extension? And when you click over wampservericon "PHP->PHP extensions", do you see mysql is checked or not? And if it's there but not active, what does error logs say?

Have you tried uninstalling(and deleting the whole c:\wamp directory afterwards) and reinstalling?

Lots of questions.. heh.

wielkaradosc

Let's go:
a) WAMP is working properly - I have some troubling issues with running mysql service - it was impossible to start it:

090625 21:10:36 InnoDB: Started; log sequence number 0 46409
090625 21:10:36 [ERROR] Do you already have another mysqld server running on port: 3306 ?
090625 21:10:36 [ERROR] Aborting

090625 21:10:36 InnoDB: Starting shutdown...
090625 21:10:37 InnoDB: Shutdown completed; log sequence number 0 46409
090625 21:10:37 [Warning] Forcing shutdown of 1 plugins
090625 21:10:37 [Note] wampmysqld: Shutdown complete

but I solved it by removing sygate personal firewall and adding a rule for windows firewall and it's fine - both services response, WAMP tray is white as it should be;
b) php/extensions - both were and still are checked;
c) to quote the php log, look at this:

090628 21:58:35 InnoDB: Started; log sequence number 0 46409
090628 21:58:35 [Note] Event Scheduler: Loaded 0 events
090628 21:58:35 [Note] wampmysqld: ready for connections.
Version: '5.1.33-community-log' socket: '' port: 3306 MySQL Community Server (GPL)

Maybe this is the key point?
d) localhost/phpinfo() - all extensions are installed, but...
there is no value for mysql default host (mysqli - default port: 3306).
Also, configuration File (php.ini) Path is placed in c:\windows whether Loaded Configuration File is C:\wamp\bin\apache\Apache2.2.11\bin\php.ini.
WAMPP is another idiotproof package after XAMP or Drupal and I still face these obstacles in running applications. So before reinstallation I am trying to try all possible solutions.

cahva

Dont worry about the default value. It's set to "no value" in in my config too.

So phpinfo relly says that "Loaded Configuration File" is in windows directory? Do you still have php.ini in there?

By the looks of it, mysql is on and working so you should be able to go to phpmyadmin now. Does it give you an error anymore?

wielkaradosc

I have found no php.ini file in c:\windows, but - this morning I turn on WAMP and try to run myphpadmin. Guess what - it's working. But how? I have done literally nothin, at least that's what I think.
Do you have any suggestions?