Re: phpMyAdmin - error 2002 - Server not responding

["Jeffrey Day" <Jeff.Day@xxxxxxxx>]

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