facing this problem how to resolve plz help
Posted by: sachinfunworld (123.237.24.---)
Date: November 19, 2013 12:28PM

Error
MySQL said: Documentation

#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).

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: RiggsFolly (---.as13285.net)
Date: November 19, 2013 01:14PM

More specific information please.

Version of Operating system?
Version of Wamp Server installed?
Version of Apache you are running?
Version of MySQL you are running?
Version of PHP you are running?

What colour is your WampManager icon? ( in the system tray )

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: sachinfunworld (123.237.24.---)
Date: November 19, 2013 01:21PM

colour of WampManager icon is orange

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: RiggsFolly (---.as13285.net)
Date: November 19, 2013 01:22PM

How to tell which service is not running if the wampmanager icon is orange.

Left click the wampmanager icon to reveal the menu-> Apache -> Service
If the Start resume service menu item is Green then Apache is running.

Left click the wampmanager icon to reveal the menu-> MySQL -> Service
If the Start resume service menu item is Green then MySQL is running.

If Apache is the service that is not running it is normally, but not always, because something else has captured port 80.

Now do,
Left click the wampmanager icon to reveal the menu-> Apache -> Service -> Test port 80
This will launch a command window and display some information about what, if anything is using port 80.

Whatever it is should be re-configured to not use port 80 or uninstalled if you are not using it.

If port 80 is not the problem look for errors in the appropriate error log ( use the wamp manager menus to view the error logs )

If these do not exists or show no errors then also check the Windows Event Viewer
Start -> Administrative Tools -> Event Viewer
And look in the 'Windows Logs' -> Application' section accessed from the menu on the left of the dialog for error messages from Apache and or MySQL.


How to Configure SKYPE so it does not require port 80 or 443

Run SKYPE
then using the menus do this:
Tools -> Options -> Advanced -> Connection
Un-Check the checkbox next to 'Use port 80 and 443 as alternatives for incomming connections'
Now restart SKYPE for these changes to take effect.


How to Configure Team Viewer so it does not require port 80 or 443
Run TV
Extras -> Options -> Advanced -> Press the Advanced Button -> Advanced Network Connections
Check the checkbox saying [ Dont use incomming port 80 (recommended for web servers only ) ]

If the problem is not obvious then post the errors here

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: sachinfunworld (123.237.24.---)
Date: November 19, 2013 01:24PM

i havent installed skype or teamviewer

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: sachinfunworld (123.237.24.---)
Date: November 19, 2013 01:34PM

unknown/unsupported storage engine:innoDB
Log Name: Application
Source: MySQL
Date: 11/19/2013 5:55:58 PM
Event ID: 100
Task Category: None
Level: Information
Keywords: Classic
User: N/A
Computer: sachin-PC
Description:
wampmysqld: Shutdown complete


For more information, see Help and Support Center at [www.mysql.com].
Event Xml:
<Event xmlns="[schemas.microsoft.com];
<System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>4</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-11-19T12:25:58.000000000Z" />
<EventRecordID>17021</EventRecordID>
<Channel>Application</Channel>
<Computer>sachin-PC</Computer>
<Security />
</System>
<EventData>
<Data>wampmysqld: Shutdown complete


</Data>
</EventData>
</Event>



2.
Log Name: Application
Source: MySQL
Date: 11/19/2013 5:03:18 PM
Event ID: 100
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: sachin-PC
Description:
Plugin 'InnoDB' init function returned error.

For more information, see Help and Support Center at [www.mysql.com].
Event Xml:
<Event xmlns="[schemas.microsoft.com];
<System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-11-19T11:33:18.000000000Z" />
<EventRecordID>17005</EventRecordID>
<Channel>Application</Channel>
<Computer>sachin-PC</Computer>
<Security />
</System>
<EventData>
<Data>Plugin 'InnoDB' init function returned error.

</Data>
</EventData>
</Event>

3.
Log Name: Application
Source: MySQL
Date: 11/19/2013 5:01:19 PM
Event ID: 100
Task Category: None
Level: Error
Keywords: Classic
User: N/A
Computer: sachin-PC
Description:
Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

For more information, see Help and Support Center at [www.mysql.com].
Event Xml:
<Event xmlns="[schemas.microsoft.com];
<System>
<Provider Name="MySQL" />
<EventID Qualifiers="49152">100</EventID>
<Level>2</Level>
<Task>0</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2013-11-19T11:31:19.000000000Z" />
<EventRecordID>17000</EventRecordID>
<Channel>Application</Channel>
<Computer>sachin-PC</Computer>
<Security />
</System>
<EventData>
<Data>Plugin 'InnoDB' registration as a STORAGE ENGINE failed.

</Data>
</EventData>
</Event>


these are the error msg event manager showing

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: RiggsFolly (---.as13285.net)
Date: November 19, 2013 02:48PM

So in answer to my question, I guess the icon is orange and the service that has not started is MySQL!!!!!


I woudl guess you have tried to install MySQL some other way and you have left a my.ini or my.cnf file in the C:\windows\..... folders somewhere.
Sometimes PC builds from dodgy places have one in there somewgere as well.


Look for my.ini and my.cnf somewhere in the C:\windows folder structure.


Of course it could be that you have another MySQL installed manually or by some other pices of software this woudl also cause problems.

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: sachinfunworld (123.237.24.---)
Date: November 19, 2013 04:30PM

my search don't show " my.ini" or "my.cnf" type of file in c drive

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: RiggsFolly (---.as13285.net)
Date: November 19, 2013 08:11PM

On what drive is WAMPServer installed?

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: sachinfunworld (---.opera-mini.net)
Date: November 19, 2013 08:43PM

In C drive I have installed wampserver

Options: ReplyQuote
Re: facing this problem how to resolve plz help
Posted by: RiggsFolly (---.as13285.net)
Date: November 20, 2013 06:05PM

Install TeamViewer and I will troubleshoot for you.

Install TV, then run it.

Do this before attempting a connection.

How to Configure Team Viewer so it does not require port 80 or 443

Run TV
Extras -> Options -> Advanced -> Press the Advanced Button -> Advanced Network Connections

Check the checkbox saying [ Dont use incomming port 80 (recommended for web servers only ) ]
Stop and restart TV.

Then
Send me a Private Message containing the TV ID and PASSWORD so I can connect.
Leave TV running as it will change the password each time you restart it.

I am on UK time (GMT) and am normally available 09:00 - 16:00 and normally later into the evening.

Options: ReplyQuote


Sorry, only registered users may post in this forum.