Jump to content
View in the app

A better way to browse. Learn more.

The Uniform Server Community

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Uniserver 5.7.2 can not connect to mySQL

Featured Replies

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.

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

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 :)

  • Author

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

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 :)

  • 4 weeks later...

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!!!

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

Account

Navigation

Search

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.