[SOLVED] LAMP install on Lucid, mysqld.sock missing, mysql terminating status=1
Linux - NewbieThis Linux forum is for members that are new to Linux.
Just starting out and have a question?
If it is not in the man pages or the how-to's this is the place!
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
Apache and PHP5 seem to work fine. From terminal prompt as root getting error msgs.
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
I have chown and chmod'd the directories for both var/run and tmp
but no files are being created.
Also ps -ln | grep mysql returns nothing
I've removed and reinstalled mysql-server.
bind is set to localhost
I read one post about inetd using port 3306 but that doesn't seem to be the problem.
The daemonl.log repeats these lines
Dec 29 19:17:16 ubuntu init: mysql post-start process (12652) terminated with status 1
Dec 29 19:17:16 ubuntu init: mysql main process (12730) terminated with status 1
Dec 29 19:17:16 ubuntu init: mysql main process ended, respawning
Kernal log keeps adding this line.
Dec 29 19:08:11 ubuntu kernel: [ 3833.393457] type=1505 audit(1293678491.371:142): operation="profile_replace" pid=11344 name="/usr/sbin/mysqld"
The error.log from/var/log/mysql shows this
101229 19:11:43 [Note] Plugin 'FEDERATED' is disabled.
/usr/sbin/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
101229 19:11:43 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
101229 19:11:43 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.
Can someone suggest debugging tricks to figure out this problem?
Thanks for the suggestion but that use states
"i can access mysql with cocoamysql and through phpmyadmin no problem i have mysql-standard-4.1.12-"
I get the same error, no mysqld.sock when I access phpmyadmin.
I am running a dual boot, and the file system was ntfs (vista), an HP laptop.
I have used both apt-get install,remove, purge and the Synaptic Package Monitor.
Apache works
PHP info page works
MYSQL -V works
any mysql or mysqladmin command results in no mysqld.sock msg.
That is what I have been following, the packages all seemed to install ok -
I've made some scripts to display error msgs and file/pkg status
<?PHP
root@ubuntu:/# bash checkpkgs
check of LAMP dependencies
apt-get check apache2
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check apache2-mpm-prefork
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check apache2-utils
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check apache2.2-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libapache2-mod-php5
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libapr1
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libaprutil1
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libdbd-mysql-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libdbi-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libmysqlclient15off
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libnet-daemon-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libplrpc-perl
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check libpq5
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check mysql-client-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check mysql-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check mysql-server-5.0
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check php5-common
Reading package lists... Done
Building dependency tree
Reading state information... Done
apt-get check php5-mysql
Reading package lists... Done
Building dependency tree
Reading state information... Done
checkpkgs completed
root@ubuntu:/#
?>
LinuxQuestions.org is looking for people interested in writing
Editorials, Articles, Reviews, and more. If you'd like to contribute
content, let us know.