LAMP install on Lucid, mysqld.sock missing, mysql terminating status=1
Linux - SoftwareThis forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.
Notices
Welcome to LinuxQuestions.org, a friendly and active Linux Community.
You are currently viewing LQ as a guest. By joining our community you will have the ability to post topics, receive our newsletter, use the advanced search, subscribe to threads and access many other special features. Registration is quick, simple and absolutely free. Join our community today!
Note that registered members see fewer ads, and ContentLink is completely disabled once you log in.
If you have any problems with the registration process or your account login, please contact us. If you need to reset your password, click here.
Having a problem logging in? Please visit this page to clear all LQ-related cookies.
Get a virtual cloud desktop with the Linux distro that you want in less than five minutes with Shells! With over 10 pre-installed distros to choose from, the worry-free installation life is here! Whether you are a digital nomad or just looking for flexibility, Shells can put your Linux machine on the device that you want to use.
Exclusive for LQ members, get up to 45% off per month. Click here for more info.
LAMP install on Lucid, mysqld.sock missing, mysql terminating status=1
Can't get MYSQL running
Ubuntu 10.04, linux 2.6.32-27-generic, 2G mem, intel duo T5250 1.5 ghz
dual boot with Vista
Apache2 works fine, PHP info page shows up, mysql -V works
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
ha
Error msgs
mysql Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (x86_64) using readline 6.1
hannah@ubuntu:~$ sudo mysql -u root -p
[sudo] password for hannah:
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysqld.sock' (2)
hannah@ubuntu:~$
I have chmoded /etc/mysql and /tmp, put a link from /tmp to /var/run/mysqld
Some posts use mysql/mysql.sock, others show myslqd/mysqld.sock, which is correct for Ubuntu?
my.cnf info
hannah@ubuntu:~$ cat /etc/mysql/my.cnf | grep socket
# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
#socket = /var/run/mysqld/mysqld.sock
socket = /tmp/mysqld.sock
#socket = /var/run/mysqld/mysqld.sock
socket = /tmp/mysqld.sock
#socket = /var/run/mysqld/mysqld.sock
socket = /tmp/mysqld.sock
hannah@ubuntu:~$ cat /etc/mysql/my.cnf | grep port
# One can use all long options that the program supports.
# It has been reported that passwords should be enclosed with ticks/quotes
port = 3306
port = 3306
hannah@ubuntu:~$ cat /etc/mysql/my.cnf | grep dir
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
!includedir /etc/mysql/conf.d/
hannah@ubuntu:~$ cat /etc/mysql/my.cnf | grep addr
#bind-address = 192.168.1.20
bind-address = 127.0.0.1
#bind-address = localhost
I have created a mysql dir in /var/run, but it disappears when i reboot.
Here are the log files msgs
kern.log
-rw-r----- 1 syslog adm 2657550 2010-12-31 15:11 /var/log/kern.log
Dec 31 15:06:54 ubuntu kernel: [ 1954.728774] type=1505 audit(1293836814.701:82): operation="profile_replace" pid=6655 name="/usr/sbin/mysqld"
Dec 31 15:07:24 ubuntu kernel: [ 1985.003696] type=1505 audit(1293836844.981:83): operation="profile_replace" pid=6729 name="/usr/sbin/mysqld"
Dec 31 15:07:55 ubuntu kernel: [ 2015.276972] type=1505 audit(1293836875.251:84): operation="profile_replace" pid=6807 name="/usr/sbin/mysqld"
Dec 31 15:08:25 ubuntu kernel: [ 2045.554549] type=1505 audit(1293836905.531:85): operation="profile_replace" pid=6886 name="/usr/sbin/mysqld"
Dec 31 15:08:55 ubuntu kernel: [ 207
5.831692] type=1505 audit(1293836935.811:86): operation="profile_replace" pid=6978 name="/usr/sbin/mysqld"
Dec 31 15:09:26 ubuntu kernel: [ 2106.107412] type=1505 audit(1293836966.081:87): operation="profile_replace" pid=7061 name="/usr/sbin/mysqld"
Dec 31 15:09:56 ubuntu kernel: [ 2136.383562] type=1505 audit(1293836996.361:88): operation="profile_replace" pid=7139 name="/usr/sbin/mysqld"
Dec 31 15:10:26 ubuntu kernel: [ 2166.660813] type=1505 audit(1293837026.633:89): operation="profile_replace" pid=7214 name="/usr/sbin/mysqld"
Dec 31 15:10:56 ubuntu kernel: [ 2196.938785] type=1505 audit(1293837056.913:90): operation="profile_replace" pid=7288 name="/usr/sbin/mysqld"
Dec 31 15:11:27 ubuntu kernel: [ 2227.213716] type=1505 audit(1293837087.191:91): operation="profile_replace" pid=7362 name="/usr/sbin/mysqld"
----------------------------------------------------------------------
sys.log
-rw-r----- 1 syslog adm 392717 2010-12-31 15:11 /var/log/syslog
Dec 31 15:10:26 ubuntu init: mysql main process (7218) terminated with status 1
Dec 31 15:10:26 ubuntu init: mysql main process ended, respawning
Dec 31 15:10:56 ubuntu init: mysql post-start process (7219) terminated with status 1
Dec 31 15:10:56 ubuntu kernel: [ 2196.938785] type=1505 audit(1293837056.913:90): operation="profile_replace" pid=7288 name="/usr/sbin/mysqld"
Dec 31 15:10:56 ubuntu init: mysql main process (7292) terminated with status 1
Dec 31 15:10:56 ubuntu init: mysql main process ended, respawning
Dec 31 15:11:27 ubuntu init: mysql post-start process (7293) terminated with status 1
Dec 31 15:11:27 ubuntu kernel: [ 2227.213716] type=1505 audit(1293837087.191:91): operation="profile_replace" pid=7362 name="/usr/sbin/mysqld"
Dec 31 15:11:27 ubuntu init: mysql main process (7366) terminated with status 1
Dec 31 15:11:27 ubuntu init: mysql main process ended, respawning
----------------------------------------------------------------------
apache2 error.log
-rw-r----- 1 root adm 42847 2010-12-31 14:40 /var/log/apache2/error.log
[Fri Dec 31 14:34:41 2010] [error] mod_log_sql: insufficient configuration info to establish database link
[Fri Dec 31 14:34:41 2010] [error] mod_log_sql: child spawned but unable to open database link
[Fri Dec 31 14:40:37 2010] [error] mod_log_sql: insufficient configuration info to establish database link
[Fri Dec 31 14:40:37 2010] [error] mod_log_sql: child spawned but unable to open database link
[Fri Dec 31 14:40:40 2010] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico
[Fri Dec 31 14:40:49 2010] [error] [client 127.0.0.1] File does not exist: /var/www/~user
[Fri Dec 31 14:40:49 2010] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico
[Fri Dec 31 14:40:50 2010] [error] mod_log_sql: insufficient configuration info to establish database link
[Fri Dec 31 14:40:50 2010] [error] mod_log_sql: child spawned but unable to open database link
[Fri Dec 31 14:40:52 2010] [error] [client 127.0.0.1] File does not exist: /var/www/favicon.ico
----------------------------------------------------------------------
Here's the msql error log
101231 15:21:32 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
101231 15:21:32 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101231 15:21:32 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
101231 15:22:03 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
101231 15:22:03 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101231 15:22:03 InnoDB: Operating system error number 13 in a file operation.
InnoDB: The error means mysqld does not have the access rights to
InnoDB: the directory.
InnoDB: File name ./ibdata1
InnoDB: File operation call: 'create'.
InnoDB: Cannot continue operation.
root@ubuntu:/#
Can someone point me to a detailed description of how mysql and/or php5 create a socket? Thanks.
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.