Uniserver 5.7.2 can not connect to mySQL

[molitar]

Ok I downloaded 5.7.2 and can not connect to mySQL so can not change password. So for a test I download the old 3.5 and it connected and changed password fine. It appears the admin panel is seriously bugged in the latest release and will not connect to mySQL. Latest being 5.7.2 because when I try to change password connection fails.. try to open phpmyadmin.. fails with error #2002.

 

I tried 5.6.1.2 and it is working fine also.. definitely appears to be a major bug with the newest version.. 5.7.0 also had the bug.

[Marlboroman213]

same problem here using Uniserver 5.7.3

i been using 4.3 mona for awhile and i figure i would try to upgrade and then i saw this may wait till its fixed to do any thing

[Ric]

Without any further information it really is extremely difficult to resolve this type of problem.

 

What do the log files show? Check the following files:

UniServer\usr\local\apache2\logs\error.log

UniServer\usr\local\mysql\data\mysql.err

 

Run the test batch files in folder UniServer\a_diagnostic in particular 3_Start_MySQL_program.bat

Any diagnostic information obtained will help.

 

Please use UniServer 5.7.3 and state your OS

 

All the best

Ric

[molitar]

Without any further information it really is extremely difficult to resolve this type of problem.

 

What do the log files show? Check the following files:

UniServer\usr\local\apache2\logs\error.log

UniServer\usr\local\mysql\data\mysql.err

 

Run the test batch files in folder UniServer\a_diagnostic in particular 3_Start_MySQL_program.bat

Any diagnostic information obtained will help.

 

Please use UniServer 5.7.3 and state your OS

 

All the best

Ric

 

Error

 

MySQL said: Documentation

#2002 - The server is not responding (or the local MySQL server's socket is not correctly configured)

Connection for controluser as defined in your configuration failed.

Open new phpMyAdmin window

 

110210 18:52:34 [Note] Plugin 'FEDERATED' is disabled.
110210 18:52:34 [Note] Plugin 'InnoDB' is disabled.
110210 18:52:37 [Note] Event Scheduler: Loaded 0 events
110210 18:52:37 [Note] C:/Tmp/UniServer/usr/local/mysql/bin/mysqld-opt.exe: ready for connections.
Version: '5.5.8'  socket: ''  port: 3306  MySQL Community Server (GPL)

 

[Thu Feb 10 18:52:33 2011] [notice] Apache/2.2.17 (Win32) PHP/5.3.5 DAV/2 configured -- resuming normal operations
[Thu Feb 10 18:52:33 2011] [notice] Server built: Oct 18 2010 01:58:12
[Thu Feb 10 18:52:33 2011] [notice] Parent: Created child process 2228
[Thu Feb 10 18:52:34 2011] [notice] Child 2228: Child process is running
[Thu Feb 10 18:52:34 2011] [notice] Child 2228: Acquired the start mutex.
[Thu Feb 10 18:52:34 2011] [notice] Child 2228: Starting 250 worker threads.
[Thu Feb 10 18:52:34 2011] [notice] Child 2228: Starting thread to listen on port 80.
[Thu Feb 10 18:54:52 2011] [error] [client 127.0.0.1] PHP Warning:  mysql_connect(): [2002] No connection could be made because the target machine actively  (trying to connect via tcp://127.0.0.1:3306) in C:\\Tmp\\UniServer\\home\\admin\\www\\mqsetup.php on line 64, referer: http://localhost/apanel/mqsetup.php
[Thu Feb 10 18:54:52 2011] [error] [client 127.0.0.1] PHP Warning:  mysql_connect(): No connection could be made because the target machine actively refused it.\r\n in C:\\Tmp\\UniServer\\home\\admin\\www\\mqsetup.php on line 64, referer: http://localhost/apanel/mqsetup.php

[Ric]

Your log files show some interesting results.

mysql.err: While starting MySQL shows correct sequence. MySQL is running and ready to receive connections.

 

Apache error.log: Shows Apache started and listening on port 80.

The error shows an attempt was made from apanel to change the MySQL password. Apanel cannot complete its task because MySQL is no longer running resulting in error message [2002].

 

Above results suggest MySQL initially starts and them stops.

 

More diagnostic info is required:

 

Download UniServer 5.7.3

From tray menu switch php.ini to development.

Run Servers.

From apanel change the MySQL password.

Expected result: Error [2002]

From tray menu run server status:

Expected result: MySQL not running and port 3306 free to use.

 

Directly run MySQL:

Navigate to folder UniServer\a_diagnostic

Double click on 3_Start_MySQL_program.bat

Note any errors.

Hopefully this will provide more information as to why the server should start and then stop.

 

All the best

Ric

[Gojo]

Your log files show some interesting results.

mysql.err: While starting MySQL shows correct sequence. MySQL is running and ready to receive connections.

 

Apache error.log: Shows Apache started and listening on port 80.

The error shows an attempt was made from apanel to change the MySQL password. Apanel cannot complete its task because MySQL is no longer running resulting in error message [2002].

 

Above results suggest MySQL initially starts and them stops.

 

More diagnostic info is required:

 

Download UniServer 5.7.3

From tray menu switch php.ini to development.

Run Servers.

From apanel change the MySQL password.

Expected result: Error [2002]

From tray menu run server status:

Expected result: MySQL not running and port 3306 free to use.

 

Directly run MySQL:

Navigate to folder UniServer\a_diagnostic

Double click on 3_Start_MySQL_program.bat

Note any errors.

Hopefully this will provide more information as to why the server should start and then stop.

 

All the best

Ric

 

I have exactly the same problem after my old one had a lot of corrupted files in the cgi-bin!!!