Re: phpMyAdmin - error 2002 - Server not responding

Hi,
Thank you Jim and Jack for responding.
Yes you are right, the daemon was ending - with end code 0, as mentioned below.

In previous posts, by both Jack and Mike P (thanks!), instructions for removing MySQL were given. I have followed them. Now the next step is a message and all is back working. I do get a bad message from phpMyAdmin, though, "Your PHP MySQL library version 5.0.45 differs from your MySQL server version 5.1.59. This may cause unpredictable behavior.". But I will figure this later.

Next step is to figure out how to import a table via green screen to avoid phpMyAdmin...

Thanks again for your help!
Jeff

From: Jim Oberholtzer <midrangel@xxxxxxxxxxxxxxxxx>
To:Web Enabling the AS400 / iSeries <web400@xxxxxxxxxxxx>
Date: 9/27/2012 1:22 PM
Subject: Re: [WEB400] phpMyAdmin - error 2002 - Server not responding
IIRC MySQL connects on port 3306. Is there a MySQL listener running?
(netstat to find out). If not it sounds like the deamon is not running
correctly.

If it is try the /pathtoyourinstance/MySQLadmin -u root password
'new-password' to reset the root password.

You might want to try to use: /pathtoyourserverinstance/MySQLd_safe &
to start the MySQL deamon in safe mode

(all commands issued inside QSH)

I think the time to update to the DBi is a good idea anyway since is is
the version that will get support if you have a contract with Zend/IBM.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 9/27/2012 12:13 PM, Jack Kingsley wrote:

jeff, if you pan through this site your error is described in here:

http://www.itjungle.com/fhg/fhg022008-story01.html



On Thu, Sep 27, 2012 at 12:16 PM, Jeffrey Day<Jeff.Day@xxxxxxxx> wrote:

Hi Folks,

Our MySQL server was installed on our IBM i a short while ago, and
everything appeared to be working. I was working on importing a database
from a different MySQL server implementation when I began getting the
following error message when I tried to login into phpMyAdmin. "#2002 -
The server is not responding (or the local MySQL server's socket is not
correctly configured)". This does not seem to be true though, because the
socket, mysql.default_socket, is set to /tmp/mysql.sock.

At this point, MySQL is unuseable as I cannot login to it, but PHP is
working fine.

Other symptoms I am seeing are when I try to start the MySQL daemon, it
starts and ends right away. It gens 2 spoolfiles. One that just has this
text in it "-n Starting MySQL ...". The second, a joblog, which says it ran
"CALL PGM(QP2SHELL) PARM('/QOpenSys/usr/bin/sh/usr/local/MySQL/bin/mysql.sh
start')" and completed with endcode 0.

Does anyone know a solution for this problem? Is my only option to
reinstall? I have found Mike Pavlak's instructions for how to remove MySQL
and I have downloaded the DBi savefile from Zend, but I'd like to here if
there is a better way before I proceed with the re-install.

Thanks,
Jeff