09-22-2010, 05:56 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
Plesk Server 403 Forbidden
We were changing permissions and I don't believe thats why but here is what we got when we tried logging into SSH:
[root@globalwebseo /]# /etc/init.d/psa start
Starting xinetd service... done
Starting named service... done
Starting mysqld service... failed
Starting postgresql service... failed
Starting psa-spamassassin service... done
Plesk: Starting Mail Server... failed
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Starting Plesk... packagemng: Unable to create 'dirty' flag (/usr/local/psa/tmp/components_dirty_flag): Permission denied
System error 13: Permission denied
packagemng: Unable to create 'dirty' flag (/usr/local/psa/tmp/components_dirty_flag): Permission denied
System error 13: Permission denied
done
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
[root@globalwebseo /]# service mysqld start
MySQL Daemon failed to start.
Starting MySQL: [FAILED]
|
09-22-2010, 06:28 PM
|
|
Newbie
|
|
Join Date: Sep 2008
Location: Orange County, CA.
Posts: 17
|
|
Did you recently upgrade mySQL.
Like = yum upgrade?
|
09-22-2010, 06:29 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
|
09-22-2010, 06:33 PM
|
|
Newbie
|
|
Join Date: Sep 2008
Location: Orange County, CA.
Posts: 17
|
|
Strange, do you know what version of mySQL you are running on the server?
|
09-22-2010, 06:35 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
Does that matter? It can't connect to mysql whatsoever.
|
09-22-2010, 06:37 PM
|
|
Newbie
|
|
Join Date: Sep 2008
Location: Orange County, CA.
Posts: 17
|
|
"MySQL 5.1 removed the BERKLEY storage engine. Since it was not commonly used, to save resources it was recommended this be turned off. You must comment the following out or remove it from /etc/my.cnf or MySQL 5.1 will not start!"
From here:
http://www.atomicorp.com/wiki/index.php/Mysql
It could be why your mysql service isnt starting, something to try
|
09-22-2010, 06:38 PM
|
|
WHT Addict
|
|
Join Date: Oct 2006
Location: arizona/romania
Posts: 140
|
|
check perms. on /usr/local/psa/tmp/
/var/lib/mysql
also paste /var/log/mysql.log or messages.
__________________
System Administration *nix - ngnix,clustering solutions Mail
|
09-22-2010, 06:43 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
|
09-22-2010, 06:46 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
what should the permissions be?
|
09-22-2010, 06:46 PM
|
|
Newbie
|
|
Join Date: Sep 2008
Location: Orange County, CA.
Posts: 17
|
|
You might want to make sure that /etc/my.cnf has bdb commented out or that its not there at all.
|
09-22-2010, 06:51 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
bdb is not mentioned in the cnf file.
Heres the error log
Quote:
100922 0:24:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibAgQjEC' (Errcode: 13)
100922 0:24:59 InnoDB: Error: unable to create temporary file; errno: 13
100922 0:24:59 [ERROR] Plugin 'InnoDB' init function returned error.
100922 0:24:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 0:24:59 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 0:24:59 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 0:24:59 [ERROR] Aborting
100922 0:24:59 [Note] /usr/libexec/mysqld: Shutdown complete
100922 00:24:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 00:25:17 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 0:25:17 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 0:25:17 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 0:25:17 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib2EnHG2' (Errcode: 13)
100922 0:25:17 InnoDB: Error: unable to create temporary file; errno: 13
100922 0:25:17 [ERROR] Plugin 'InnoDB' init function returned error.
100922 0:25:17 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 0:25:17 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 0:25:17 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 0:25:17 [ERROR] Aborting
100922 0:25:17 [Note] /usr/libexec/mysqld: Shutdown complete
100922 00:25:17 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 11:01:26 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 11:01:26 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 11:01:26 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 11:01:26 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibPJytES' (Errcode: 13)
100922 11:01:26 InnoDB: Error: unable to create temporary file; errno: 13
100922 11:01:26 [ERROR] Plugin 'InnoDB' init function returned error.
100922 11:01:26 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 11:01:26 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 11:01:26 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 11:01:26 [ERROR] Aborting
100922 11:01:26 [Note] /usr/libexec/mysqld: Shutdown complete
100922 11:01:26 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:20:24 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:20:24 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:20:24 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:20:24 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibqe2yY7' (Errcode: 13)
100922 12:20:24 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:20:24 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:20:24 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:20:24 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:20:24 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:20:24 [ERROR] Aborting
100922 12:20:24 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:20:24 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:20:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:20:46 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:20:46 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:20:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibm78orA' (Errcode: 13)
100922 12:20:46 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:20:46 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:20:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:20:46 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:20:46 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:20:46 [ERROR] Aborting
100922 12:20:46 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:20:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:21:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:21:01 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:21:01 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:21:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibwF81dm' (Errcode: 13)
100922 12:21:01 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:21:01 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:21:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:21:01 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:21:01 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:21:01 [ERROR] Aborting
100922 12:21:01 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:21:01 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:23:16 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:23:16 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:23:16 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:23:16 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibhRYD5e' (Errcode: 13)
100922 12:23:16 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:23:16 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:23:16 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:23:16 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:23:16 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:23:16 [ERROR] Aborting
100922 12:23:16 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:23:16 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:25:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:25:33 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:25:33 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:25:33 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/iboFrhFU' (Errcode: 13)
100922 12:25:33 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:25:33 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:25:33 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:25:33 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:25:33 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:25:33 [ERROR] Aborting
100922 12:25:33 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:25:33 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:27:25 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:27:25 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:27:25 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:27:25 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibrJBxgk' (Errcode: 13)
100922 12:27:25 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:27:25 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:27:25 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:27:25 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:27:25 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:27:25 [ERROR] Aborting
100922 12:27:25 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:27:25 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 12:27:39 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 12:27:39 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 12:27:39 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 12:27:39 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibO2x3ar' (Errcode: 13)
100922 12:27:39 InnoDB: Error: unable to create temporary file; errno: 13
100922 12:27:39 [ERROR] Plugin 'InnoDB' init function returned error.
100922 12:27:39 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 12:27:39 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 12:27:39 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 12:27:39 [ERROR] Aborting
100922 12:27:39 [Note] /usr/libexec/mysqld: Shutdown complete
100922 12:27:39 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 16:31:34 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 16:31:34 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 16:31:34 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 16:31:34 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib6G4aww' (Errcode: 13)
100922 16:31:34 InnoDB: Error: unable to create temporary file; errno: 13
100922 16:31:34 [ERROR] Plugin 'InnoDB' init function returned error.
100922 16:31:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 16:31:34 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 16:31:34 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 16:31:34 [ERROR] Aborting
100922 16:31:34 [Note] /usr/libexec/mysqld: Shutdown complete
100922 16:31:34 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 16:34:05 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 16:34:05 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 16:34:05 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 16:34:05 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibS75QgS' (Errcode: 13)
100922 16:34:05 InnoDB: Error: unable to create temporary file; errno: 13
100922 16:34:05 [ERROR] Plugin 'InnoDB' init function returned error.
100922 16:34:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 16:34:05 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 16:34:05 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 16:34:05 [ERROR] Aborting
100922 16:34:05 [Note] /usr/libexec/mysqld: Shutdown complete
100922 16:34:05 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 16:48:14 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 16:48:14 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 16:48:14 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 16:48:14 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibQusdJx' (Errcode: 13)
100922 16:48:14 InnoDB: Error: unable to create temporary file; errno: 13
100922 16:48:14 [ERROR] Plugin 'InnoDB' init function returned error.
100922 16:48:14 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 16:48:14 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 16:48:14 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 16:48:14 [ERROR] Aborting
100922 16:48:14 [Note] /usr/libexec/mysqld: Shutdown complete
100922 16:48:14 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 16:55:46 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 16:55:46 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 16:55:46 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 16:55:46 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibyrN5dm' (Errcode: 13)
100922 16:55:46 InnoDB: Error: unable to create temporary file; errno: 13
100922 16:55:46 [ERROR] Plugin 'InnoDB' init function returned error.
100922 16:55:46 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 16:55:46 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 16:55:46 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 16:55:46 [ERROR] Aborting
100922 16:55:46 [Note] /usr/libexec/mysqld: Shutdown complete
100922 16:55:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:10:38 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:10:38 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:10:38 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:10:38 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/iblSrWh3' (Errcode: 13)
100922 17:10:38 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:10:38 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:10:38 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:10:38 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:10:38 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:10:38 [ERROR] Aborting
100922 17:10:38 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:10:38 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:18:32 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:18:32 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:18:32 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:18:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibgv9F9b' (Errcode: 13)
100922 17:18:32 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:18:32 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:18:32 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:18:32 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:18:32 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:18:32 [ERROR] Aborting
100922 17:18:32 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:18:32 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:23:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:23:51 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:23:51 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:23:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibGbKZhy' (Errcode: 13)
100922 17:23:51 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:23:51 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:23:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:23:51 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:23:51 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:23:51 [ERROR] Aborting
100922 17:23:51 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:23:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:24:59 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:24:59 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:24:59 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:24:59 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibAFHeyY' (Errcode: 13)
100922 17:24:59 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:24:59 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:24:59 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:24:59 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:24:59 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:24:59 [ERROR] Aborting
100922 17:24:59 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:24:59 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:25:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:25:01 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:25:01 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:25:01 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib3tqB7U' (Errcode: 13)
100922 17:25:01 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:25:01 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:25:01 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:25:01 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:25:01 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:25:01 [ERROR] Aborting
100922 17:25:01 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:25:02 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:26:45 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:26:45 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:26:45 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:26:45 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibyHKd8i' (Errcode: 13)
100922 17:26:45 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:26:45 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:26:45 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:26:45 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:26:45 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:26:45 [ERROR] Aborting
100922 17:26:45 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:26:45 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid mysql_enable="YES" ended
100922 17:30:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:30:53 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:30:53 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:30:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib2jnMnO' (Errcode: 13)
100922 17:30:53 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:30:53 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:30:53 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:30:53 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:30:53 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:30:53 [ERROR] Aborting
100922 17:30:53 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:30:53 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:34:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:34:35 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:34:35 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:34:35 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibkAwWD6' (Errcode: 13)
100922 17:34:35 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:34:35 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:34:35 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:34:35 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:34:35 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:34:35 [ERROR] Aborting
100922 17:34:35 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:34:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:39:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:39:31 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:39:31 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:39:31 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib2ZkDU8' (Errcode: 13)
100922 17:39:31 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:39:31 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:39:31 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:39:31 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:39:31 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:39:31 [ERROR] Aborting
100922 17:39:31 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:39:31 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:39:44 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:39:44 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:39:44 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:39:44 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibfVY67V' (Errcode: 13)
100922 17:39:44 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:39:44 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:39:44 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:39:44 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:39:44 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:39:44 [ERROR] Aborting
100922 17:39:44 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:39:44 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:40:51 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:40:51 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:40:51 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:40:51 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ib7I3L6I' (Errcode: 13)
100922 17:40:51 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:40:51 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:40:51 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:40:51 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:40:51 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:40:51 [ERROR] Aborting
100922 17:40:51 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:40:51 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:42:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:42:58 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:42:58 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:42:58 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibeYDZ1z' (Errcode: 13)
100922 17:42:58 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:42:58 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:42:58 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:42:58 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:42:58 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:42:58 [ERROR] Aborting
100922 17:42:58 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:42:58 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:47:43 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:47:43 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:47:43 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:47:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibcRf4nI' (Errcode: 13)
100922 17:47:43 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:47:43 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:47:43 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:47:43 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:47:43 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:47:43 [ERROR] Aborting
100922 17:47:43 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:47:43 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
100922 17:47:57 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
100922 17:47:57 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
100922 17:47:57 [Note] Plugin 'ndbcluster' is disabled.
/usr/libexec/mysqld: Table 'plugin' is read only
100922 17:47:57 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
/usr/libexec/mysqld: Can't create/write to file '/tmp/ibp4RyAB' (Errcode: 13)
100922 17:47:57 InnoDB: Error: unable to create temporary file; errno: 13
100922 17:47:57 [ERROR] Plugin 'InnoDB' init function returned error.
100922 17:47:57 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
100922 17:47:57 [ERROR] Can't start server : Bind on unix socket: Permission denied
100922 17:47:57 [ERROR] Do you already have another mysqld server running on socket: /var/lib/mysql/mysql.sock ?
100922 17:47:57 [ERROR] Aborting
100922 17:47:57 [Note] /usr/libexec/mysqld: Shutdown complete
100922 17:47:57 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended
|
|
09-22-2010, 06:54 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
Here is the cnf file
Quote:
[mysqld]
set-variable=local-infile=0
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
|
|
09-22-2010, 06:56 PM
|
|
WHT Addict
|
|
Join Date: Oct 2006
Location: arizona/romania
Posts: 140
|
|
PHP Code:
chown root:root /tmp
chmod 1777 /tmp
/etc/init.d/mysqld start
__________________
System Administration *nix - ngnix,clustering solutions Mail
|
09-22-2010, 06:59 PM
|
|
Newbie
|
|
Join Date: Sep 2010
Posts: 15
|
|
do we do that from the root of the folders or from usr/local/psa/tmp?
|
09-22-2010, 07:02 PM
|
|
WHT Addict
|
|
Join Date: Oct 2006
Location: arizona/romania
Posts: 140
|
|
Quote:
Originally Posted by kyles0623
do we do that from the root of the folders or from usr/local/psa/tmp?
|
no matter from where these commands will run.
__________________
System Administration *nix - ngnix,clustering solutions Mail
|
| Thread Tools |
Search this Thread |
|
|
|
| Display Modes |
 Linear Mode
|
| Postbit Selector |
|
|
Posting Rules
|
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
HTML code is Off
|
|
|
|
|
|
| Login: |
|
|
| Advertisement: |
|
|
| Web Hosting News: |
|
|
|
