WampServer

Problem:
I recently upgraded to windows 8 and i have encountered a problem trying to connect to localhost/phpmyadmin. Connecting to localhost seems to be working okay, it's only when i try to connect to phpmyadmin that i have problems. Currently the wamp icon in my system tray is yellow. If anyone has any ideas on how i might solve this i would appreciate your help.

Error Msg:
Error
MySQL said:
#2002 - No connection could be made because the target machine actively refused it.
The server is not responding (or the local server's socket is not correctly configured).



Edited 1 time(s). Last edit at 10/31/2012 03:41AM by Stebon24.

If icon is orange then either apache or mysql is not starting. Its usually apache, and usually because something else has grabbed port 80 before you start wamp.

Run:
wampmanager -> Apacge -> Services -> Test Port 80

That should tell you what is using port 80.
That could be many things but its usually either:
SKYPE - Configure the connection not to use port 80
IIS - I prefer to uninstall this but you could just disable it. There are howto's on the web just google it.

If you cant figure out how to remove or re-configure whatever it is then get back to use here

Okay so i ran the test port 80 service and got the following message...

Server: Apache/2.4.2 (Win64) PHP/5.4.3

Does this mean that mySQL is not starting?

I don't have Skype installed, and I have already disabled IIS. Where do i go from here?

Yes I guess it does.

If its mysql that the problem when you so wampmanager -> MySQL -> Services , the Start Resume Services menu item will be green and available to use rather than gray and disabled.

Have you tried installing MySQL before if so you probably didn't uninstall it all properly. Uninstall other mysql's

I have also seen some systems that have a my.ini file that is not in the wamp folder set that causes problems like this. Do a search for my.ini and my.cnf and delete any that exist outside the wamp folder structure.

If i go to "wampmanager -> MySQL -> Services", I am able to click "start/resume service". The wamp icon remains yellow.

So i checked the mySQL log to see if there is some kind of report to give me a clue whats going on. This is the block of text that repeats in the log every time i click "Start/Resume service...

121031 22:07:37 [Note] Plugin 'FEDERATED' is disabled.
121031 22:07:37 InnoDB: The InnoDB memory heap is disabled
121031 22:07:37 InnoDB: Mutexes and rw_locks use Windows interlocked functions
121031 22:07:37 InnoDB: Compressed tables use zlib 1.2.3
121031 22:07:37 InnoDB: Initializing buffer pool, size = 128.0M
121031 22:07:37 InnoDB: Completed initialization of buffer pool
121031 22:07:37 InnoDB: highest supported file format is Barracuda.
121031 22:07:37 InnoDB: Operating system error number 87 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: [dev.mysql.com]
InnoDB: File name .\ib_logfile0
InnoDB: File operation call: 'aio read'.
InnoDB: Cannot continue operation.

I also re-installed wamp and deleted the associated files from the previous install.

Hopefully this gives someone a clue what might be going on.

Could be a few things.

Is there an old my.ini or my.cnf on the PC outside the wamp folder? Have a search

Is there something unusual about the setup?

Ssd drives?
Windows user folder on seperate drives?
Networked drives?
No admin access?
Installed wamp in program files?

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]

Drives:

My C Drive is a SSD.

I have a storage pool set up that includes 4 Hard drives, this is a new feature in windows 8. There is one virtual partition (M:\) on that storage pool that is setup in a mirror configuration. The Wamp folder is installed in the main directory of this partition (M:\).

Details:

I searched all drives for my.ini, the only matches where the ones inside the wamp folder.

I searched all drives for my.cnf and got back no results.

I store most of the contents of my Windows user folder off the C drive, and in the virtual partition (M:\).

Not sure about admin access. How would i find this?

Wamp is not in program files.



Edited 1 time(s). Last edit at 11/01/2012 07:42AM by Stebon24.

It's the drive setup. Something has read/write failure to this setup.

In the my.ini in wamp find a line like

#Tmpdir = /tmp

Enable that line and change the path to point to the c:/wamp/tmp folder


Note: Sorry I'm not at a PC to give an exact post on his

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 11/01/2012 09:58AM by stevenmartin99.

So i changed the part you mentioned so that it now looks like this...

# Point the following paths to different dedicated disks
tmpdir = M:/wamp/tmp/
#log-update = /path-to-dedicated-directory/hostname

I'm still getting the yellow icon though and the same error when attempting to connect to localhost/phpmyadmin.

I know we are on the right track here though, because i tried doing a fresh install onto my C: drive and it worked. So the problem as you suspected, probably has to do with an incorrect file path somewhere. Can you think of any other places where this might have occurred?

oh yes there is a second line about line 28

socket = /tmp/mysql.sock

needs to be

socket = M:/wamp/tmp/mysql.sock


btw i know the

tmpdir = M:/wamp/tmp/

example has a / at the but i think its wrong.


try

tmpdir = M:/wamp/tmp

or

tmpdir ="M:/wamp/tmp"


your drive is not setup properly for file sharing, mysql tries to use the windows tmp folder but it doesnt have access.

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]



Edited 1 time(s). Last edit at 11/02/2012 04:59AM by stevenmartin99.