Plesk admin won't log in

[dedibox]

When trying to log in, plesk will send me back to the blank login screen.

After trying to change the password, I then got this error:

ERROR: PleskMainDBException
MySQL query failed: MySQL server has gone away
0: /usr/local/psa/admin/plib/common_func.php3:250
db_query(string 'delete from lockout where login='admin'')
1: /usr/local/psa/admin/htdocs/login_up.php3:72

What's going on?

It had been several days since I last touched my plask admin panel, and I haven't even logged into the server via ssh recently.

Please help!

 

[danliker]

is mysql running ?

 

[dedibox]

MySQL server has gone away

It appeared to be running on my CentOS box with Plesk 8.6 installed

However, when doing /etc/rc.d/init.d/mysqld start

I get:

to start MySQL Daemon.
Starting MySQL: [FAILED]

As I had not set root password, I tried to do that to then REPAIR the mysql database:

ERROR 2006 (HY000): MySQL server has gone away
No connection. Trying to reconnect...
Connection id: 48
Current database: mysql

Query OK, 0 rows affected (0.01 sec)
Rows matched: 0 Changed: 0 Warnings: 0

...and I got the same error I was getting via plesk.

 

[breun]

Anything in the logs (/var/log/mysqld.log)?

 

[dedibox]

MySQL problems with Plesk 8.6

I've got this error that repeats:

080829 11:33:54 mysqld started
InnoDB: Unable to lock ./ibdata1, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.

And then I've got this:

080829 11:35:34 InnoDB: Unable to open the first data file
InnoDB: Error in opening ./ibdata1
080829 11:35:34 InnoDB: Operating system error number 11 in a file operation.
InnoDB: Error number 11 means 'Resource temporarily unavailable'.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/mysql/en/Operating_System_error_codes.html
InnoDB: Could not open or create data files.
InnoDB: If you tried to add new data files, and it failed here,
InnoDB: you should now edit innodb_data_file_path in my.cnf back
InnoDB: to what it was, and remove the new ibdata files InnoDB created
InnoDB: in this failed attempt. InnoDB only wrote those files full of
InnoDB: zeros, but did not yet use them in any way. But be careful: do not
InnoDB: remove old data files which contain your precious data!
080829 11:35:34 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
080829 11:35:34 [ERROR] Do you already have another mysqld server running on port: 3306 ?
080829 11:35:34 [ERROR] Aborting

080829 11:35:34 [Note] /usr/libexec/mysqld: Shutdown complete

080829 11:35:34 mysqld ended

080829 11:37:24 mysqld started
080829 11:37:25 InnoDB: Started; log sequence number 0 3402482
080829 11:37:25 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

I restarted in between, I think.

 

[hardweb]

Execute:

killall -9 safe_mysqld mysqld

and:

/etc/init.d/mysqld restart. If you still get that error execute:

netstat -lp

and see what processes answer on 3306.

 

[dedibox]

I managed to log in (the mysql problem is intermittent) and tried to upgrade but got this mysql error in the plesk control panel:

ERROR: PleskMainDBException Up Level
MySQL query failed: MySQL server has gone away
0: /usr/local/psa/admin/plib/common_func.php3:250
db_query(string 'SELECT id, type, url, priority, enabled, auth_required, login, password FROM ai_vendor_sources')
1: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerVendorSource.php:136
AutoInstallerVendorSource::getVendorSources()
2: /usr/local/psa/admin/plib/autoinstaller/AutoInstallerManager.php:209
AutoInstallerManager->install(string 'PLESK_8_6_0', array, boolean false, string 'rsadki@free.fr', boolean true)
3: /usr/local/psa/admin/htdocs/server/autoinstaller_install.php:101

In response to killall, I get

safe_mysqld: no process killed

netstat -lp

Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name
tcp 0 0 *:imaps *:* LISTEN 3130/couriertcpd
tcp 0 0 *op3s *:* LISTEN 3147/couriertcpd
tcp 0 0 *:mysql *:* LISTEN 4518/mysqld
tcp 0 0 *oppassd *:* LISTEN 3088/xinetd
tcp 0 0 *:submission *:* LISTEN 3088/xinetd
tcp 0 0 *op3 *:* LISTEN 3138/couriertcpd
tcp 0 0 *:imap *:* LISTEN 3120/couriertcpd
tcp 0 0 *:sunrpc *:* LISTEN 2870/portmap
tcp 0 0 *:cddbp-alt *:* LISTEN 3524/httpsd
tcp 0 0 *:smtps *:* LISTEN 3088/xinetd
tcp 0 0 sd-15153.dedibox.fr:domain *:* LISTEN 3243/named
tcp 0 0 localhost:domain *:* LISTEN 3243/named
tcp 0 0 *:ftp *:* LISTEN 3088/xinetd
tcp 0 0 localhost:ipp *:* LISTEN 3076/cupsd
tcp 0 0 localhostostgres *:* LISTEN 3436/postmaster
tcp 0 0 localhost:rndc *:* LISTEN 3243/named
tcp 0 0 *:smtp *:* LISTEN 3088/xinetd
tcp 0 0 *csync-https *:* LISTEN 3524/httpsd
tcp 0 0 *:955 *:* LISTEN 2893/rpc.statd
tcp 0 0 *:10108 *:* LISTEN 3971/autoinstaller
tcp 0 0 *:http *:* LISTEN 3491/httpd
tcp 0 0 *:ssh *:* LISTEN 3066/sshd
tcp 0 0 *:https *:* LISTEN 3491/httpd
udp 0 0 sd-15153.dedibox.fr:domain *:* 3243/named
udp 0 0 localhost:domain *:* 3243/named
udp 0 0 *:949 *:* 2893/rpc.statd
udp 0 0 *:952 *:* 2893/rpc.statd
udp 0 0 *:53452 *:* 3603/avahi-daemon:
udp 0 0 *:34519 *:* 3243/named
udp 0 0 *:mdns *:* 3603/avahi-daemon:
udp 0 0 *:sunrpc *:* 2870/portmap
udp 0 0 *:ipp *:* 3076/cupsd
udp 0 0 *:44827 *:* 3243/named
udp 0 0 *:40166 *:* 3603/avahi-daemon:
udp 0 0 *:mdns *:* 3603/avahi-daemon:
Active UNIX domain sockets (only servers)
Proto RefCnt Flags Type State I-Node PID/Program name Path
unix 2 [ ACC ] STREAM LISTENING 5183 3436/postmaster /tmp/.s.PGSQL.5432
unix 2 [ ACC ] STREAM LISTENING 5259 3466/spamd_full.soc /tmp/spamd_full.sock
unix 2 [ ACC ] STREAM LISTENING 5675 3617/hald @/var/run/hald/dbus-wJ98YdvgPV
unix 2 [ ACC ] STREAM LISTENING 4108 2816/python /var/run/audit_events
unix 2 [ ACC ] STREAM LISTENING 4179 2947/dbus-daemon /var/run/dbus/system_bus_socket
unix 2 [ ACC ] STREAM LISTENING 4299 3009/pcscd /var/run/pcscd.comm
unix 2 [ ACC ] STREAM LISTENING 4389 3053/acpid /var/run/acpid.socket
unix 2 [ ACC ] STREAM LISTENING 6096754 4518/mysqld /var/lib/mysql/mysql.sock
unix 2 [ ACC ] STREAM LISTENING 4458 3076/cupsd /var/run/cups/cups.sock
unix 2 [ ACC ] STREAM LISTENING 5676 3617/hald @/var/run/hald/dbus-xdjQHpLNsm
unix 2 [ ACC ] STREAM LISTENING 5642 3603/avahi-daemon: /var/run/avahi-daemon/socket
unix 2 [ ACC ] STREAM LISTENING 4837 3193/gpm /dev/gpmctl

I don't see port numbers with netstat...

 

[Amin Taheri]

try

kill -9 `ps aux | grep mysqld`

Then restart mysql