OVERALL ISSUE: mysql_connect() [function.mysql-connect]: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Hi,
I recently performed some upgrades and everything was working perfectly, until I stupidly tried to update PhpMyAdmin and DirectAdmin using the plugin and it appears to have broken my MySQL installation and deleted all of my databases... Here is the log:
I have tried running the instructions located here, but I cannot even perform the first step properly. Here is the logo of me trying everything with the server's responses:
Here is the .err log:
I have already tried removing my.conf, rebuilding and compiling MySQL and PhpMyAdmin and PHP. The mysqld process is completely stopped within the DirectAdmin web interface and I cannot get it to reload or restart.
How can I resolve this issue? I'd like to fix it ASAP. If this can't be fixed, I have a full system backup, but I don't know how I would use it to restore MySQL to how it was during the backup.
Thank you.
Hi,
I recently performed some upgrades and everything was working perfectly, until I stupidly tried to update PhpMyAdmin and DirectAdmin using the plugin and it appears to have broken my MySQL installation and deleted all of my databases... Here is the log:
Code:
[1mUpdating MySQL.(B[m
Dumping database admin_EIYD
Dumping database admin_WB
Dumping database admin_reflect
Dumping database da_roundcube
Dumping database mysql
Dumping database phpmyadmin
Downloading mysql/MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm...
--2016-06-29 13:22:05-- http://files.directadmin.com/services/custombuild/all/mysql/64-bit/5.6.29/MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm
Resolving files.directadmin.com... 208.167.226.3, 216.144.254.90, 69.162.69.58
Connecting to files.directadmin.com|208.167.226.3|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 23272943 (22M)
Saving to: `/usr/local/directadmin/custombuild/mysql/MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm'
0K .......... .......... .......... .......... .......... 0% 410K 55s
22650K .......... .......... .......... .......... .......... 99% 2.41M 0s
22700K .......... .......... ....... 100% 667K=29s
2016-06-29 13:22:35 (789 KB/s) - `/usr/local/directadmin/custombuild/mysql/MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm' saved [23272943/23272943]
Downloading mysql/MySQL-devel-5.6.29-1.linux_glibc2.5.x86_64.rpm...
--2016-06-29 13:22:35-- http://files.directadmin.com/services/custombuild/all/mysql/64-bit/5.6.29/MySQL-devel-5.6.29-1.linux_glibc2.5.x86_64.rpm
Resolving files.directadmin.com... 208.167.226.3, 216.144.254.90, 69.162.69.58
Connecting to files.directadmin.com|208.167.226.3|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 4585427 (4.4M)
Saving to: `/usr/local/directadmin/custombuild/mysql/MySQL-devel-5.6.29-1.linux_glibc2.5.x86_64.rpm'
0K .......... .......... .......... .......... .......... 1% 405K 11s
4400K .......... .......... .......... .......... .......... 99% 367K 0s
4450K .......... .......... ....... 100% 570K=8.8s
2016-06-29 13:22:44 (511 KB/s) - `/usr/local/directadmin/custombuild/mysql/MySQL-devel-5.6.29-1.linux_glibc2.5.x86_64.rpm' saved [4585427/4585427]
Downloading mysql/MySQL-server-5.6.29-1.linux_glibc2.5.x86_64.rpm...
--2016-06-29 13:22:44-- http://files.directadmin.com/services/custombuild/all/mysql/64-bit/5.6.29/MySQL-server-5.6.29-1.linux_glibc2.5.x86_64.rpm
Resolving files.directadmin.com... 208.167.226.3, 216.144.254.90, 69.162.69.58
Connecting to files.directadmin.com|208.167.226.3|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 88931584 (85M)
Saving to: `/usr/local/directadmin/custombuild/mysql/MySQL-server-5.6.29-1.linux_glibc2.5.x86_64.rpm'
0K .......... .......... .......... .......... .......... 0% 430K 3m22s
50K .......... .......... .......... .......... .......... 0% 431K 3m21s
86750K .......... .......... .......... .......... .......... 99% 430K 0s
86800K .......... .......... .......... .......... ....... 100% 406K=3m16s
2016-06-29 13:26:00 (443 KB/s) - `/usr/local/directadmin/custombuild/mysql/MySQL-server-5.6.29-1.linux_glibc2.5.x86_64.rpm' saved [88931584/88931584]
Downloading mysql/MySQL-shared-5.6.29-1.linux_glibc2.5.x86_64.rpm...
--2016-06-29 13:26:00-- http://files.directadmin.com/services/custombuild/all/mysql/64-bit/5.6.29/MySQL-shared-5.6.29-1.linux_glibc2.5.x86_64.rpm
Resolving files.directadmin.com... 208.167.226.3, 216.144.254.90, 69.162.69.58
Connecting to files.directadmin.com|208.167.226.3|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 2421764 (2.3M)
Saving to: `/usr/local/directadmin/custombuild/mysql/MySQL-shared-5.6.29-1.linux_glibc2.5.x86_64.rpm'
0K .......... .......... .......... .......... .......... 2% 287K 8s
2350K .......... ..... 100% 327M=4.8s
2016-06-29 13:26:05 (497 KB/s) - `/usr/local/directadmin/custombuild/mysql/MySQL-shared-5.6.29-1.linux_glibc2.5.x86_64.rpm' saved [2421764/2421764]
Found /usr/local/directadmin/custombuild/mysql/MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-devel-5.6.29-1.linux_glibc2.5.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-server-5.6.29-1.linux_glibc2.5.x86_64.rpm
Found /usr/local/directadmin/custombuild/mysql/MySQL-shared-5.6.29-1.linux_glibc2.5.x86_64.rpm
Stopping mysqld ...
Shutting down MySQL....... SUCCESS!
Upgrading MySQL 5.1.65 to 5.6.29
warning: MySQL-client-5.6.29-1.linux_glibc2.5.x86_64.rpm: Header V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ##################################################
MySQL-shared ##################################################
MySQL-client ##################################################
MySQL-devel ##################################################
MySQL-server ##################################################
Ensuring local-infile is disabled for security reasons in MySQL configuration file...
Starting MySQL.. ERROR! The server quit without updating PID file (/var/lib/mysql/server1.kylebivins.com.pid).
Giving mysqld a few seconds to start up...
Looking for 'mysql' as: /usr/bin/mysql
Looking for 'mysqlcheck' as: /usr/bin/mysqlcheck
Error: Failed while fetching Server version! Could be due to unauthorized access.
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2) when trying to connect
cp: `/usr/lib/libmysqlclient.so' and `/usr/lib/mysql/libmysqlclient.so' are the same file
Restarting MySQL.
ERROR! MySQL server PID file could not be found!
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server1.kylebivins.com.pid).
[1mUpdating phpMyAdmin.(B[m
Downloading phpMyAdmin-4.6.3-all-languages.tar.gz...
--2016-06-29 13:27:57-- http://files.directadmin.com/services/custombuild/phpMyAdmin/phpMyAdmin-4.6.3-all-languages.tar.gz
Resolving files.directadmin.com... 208.167.226.3, 216.144.254.90, 69.162.69.58
Connecting to files.directadmin.com|208.167.226.3|:80... connected.
HTTP request sent, awaiting response... 200 OK
Length: 10321074 (9.8M) [application/x-gzip]
Saving to: `/usr/local/directadmin/custombuild/phpMyAdmin-4.6.3-all-languages.tar.gz'
0K .......... .......... .......... .......... .......... 0% 213K 47s
50K .......... .......... .......... .......... .......... 0% 812K 30s
10000K .......... .......... .......... .......... .......... 99% 15.4K 0s
10050K .......... .......... ......... 100% 190M=19s
2016-06-29 13:28:17 (523 KB/s) - `/usr/local/directadmin/custombuild/phpMyAdmin-4.6.3-all-languages.tar.gz' saved [10321074/10321074]
Patching phpMyAdmin to log failed authentications for BFM...
patching file libraries/common.inc.php
Hunk #1 succeeded at 730 with fuzz 2 (offset 2 lines).
patching file libraries/logging.lib.php
phpMyAdmin 4.6.3-all-languages installation is done.I have tried running the instructions located here, but I cannot even perform the first step properly. Here is the logo of me trying everything with the server's responses:
Code:
[root@server1 ~]# ls -la /var/lib/mysql/mysql.sock
ls: /var/lib/mysql/mysql.sock: No such file or directory
[root@server1 ~]# netstat -lnp | grep mysql
[root@server1 ~]# ps ax | grep mysql
[root@server1 ~]# /etc/init.d/mysqld stop
ERROR! MySQL server PID file could not be found!
[root@server1 ~]# /etc/init.d/mysqld start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server1.kylebivins.com.pid).
[root@server1 ~]# killall -9 mysqld mysqld_safe
mysqld: no process killed
mysqld_safe: no process killed
[root@server1 ~]# /etc/init.d/mysqld start
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/server1.kylebivins.com.pid).Here is the .err log:
Code:
121209 08:36:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121209 8:36:05 [Note] Plugin 'FEDERATED' is disabled.
121209 8:36:05 InnoDB: Initializing buffer pool, size = 8.0M
121209 8:36:05 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
121209 8:36:05 InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
121209 8:36:19 InnoDB: Started; log sequence number 0 93292
121209 8:36:19 [Note] Event Scheduler: Loaded 0 events
121209 8:36:19 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.1.65' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL Community Server (GPL)
121209 14:05:22 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
121209 14:05:23 [Note] Plugin 'FEDERATED' is disabled.
121209 14:05:24 InnoDB: Initializing buffer pool, size = 8.0M
121209 14:05:24 InnoDB: Completed initialization of buffer pool
InnoDB: The log sequence number in ibdata files does not match
InnoDB: the log sequence number in the ib_logfiles!
"/var/lib/mysql/server1.kylebivins.com.err" 57215L, 4639425CI have already tried removing my.conf, rebuilding and compiling MySQL and PhpMyAdmin and PHP. The mysqld process is completely stopped within the DirectAdmin web interface and I cannot get it to reload or restart.
How can I resolve this issue? I'd like to fix it ASAP. If this can't be fixed, I have a full system backup, but I don't know how I would use it to restore MySQL to how it was during the backup.
Thank you.
