mysql failed to start. reinstall failed either!!!

gavin2u · 08-13-2008, 02:45 AM

some days ago, mysql crashed for some unknown reasons. So i reinstalled it then.

still, i find out that, mysql could not be started till now.
Once i attempt to start mysql and finally fails, i find this log in /var/log/syslog file:

Quote:

Aug 13 15:25:08 tp05ftp /etc/init.d/mysql[17845]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Aug 13 15:25:08 tp05ftp /etc/init.d/mysql[17845]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Aug 13 15:25:08 tp05ftp /etc/init.d/mysql[17845]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Aug 13 15:25:08 tp05ftp /etc/init.d/mysql[17845]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!

and when i dpkg my box, it reads like this:

Quote:

$ dpkg -l | grep -v ^ii
Desired=Unknown/Install/Remove/Purge/Hold
| Status=Not/Installed/Config-f/Unpacked/Failed-cfg/Half-inst/t-aWait/T-pend
|/ Err?=(none)/Hold/Reinst-required/X=both-problems (Status,Err: uppercase=bad)
||/ name dist sum
+++-=====================================-===========================-=================
iU mysql-server 5.0.51a-3ubuntu5.1 MySQL database se
iF mysql-server-5.0 5.0.51a-3ubuntu5.1 MySQL database se

it seems that something went wrong, when i reinstall it.

please help. how can i fix it? my box is running ubuntu 8.04 server.

thanks in advance.

gavin2u · 08-13-2008, 09:04 AM

after i removed all mysql-server and mysql-server-5.0 packages, it failed again when i attempted to install mysql server

Quote:

sudo apt-get install mysql-server
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
mysql-server-5.0
Suggested packages:
mysql-doc-5.0 tinyca
Recommended packages:
apparmor libhtml-template-perl mailx
The following NEW packages will be installed:
mysql-server mysql-server-5.0
0 upgraded, 2 newly installed, 0 to remove and 2 not upgraded.
Need to get 53.7kB/27.5MB of archives.
After this operation, 86.2MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Get:1 http://us.archive.ubuntu.com hardy-updates/main mysql-server 5.0.51a-3ubuntu5.1 [53.7k
Fetched 53.7kB in 2s (21.5kB/s)
Preconfiguring packages ...
Selecting previously deselected package mysql-server-5.0.
(Reading database ... 40454 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb) ...
Your account has expired; please contact your system administrator
chfn: PAM authentication failed
adduser: `/usr/bin/chfn -f MySQL Server mysql' returned error code 1. Exiting.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb
subprocess pre-installation script returned error exit status 1
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.51a-3ubuntu5.1_all.deb) ...
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

any tips?

gavin2u · 08-13-2008, 07:02 PM

any idea please?

thanks again.

maas187 · 08-13-2008, 07:09 PM

Quote:

Originally Posted by gavin2u

any idea please?

thanks again.

i had the same problem ..
.......
i just uninstalled it and issue the commands to install it again .

yum install mysqld mysql-server

and it worked fine .

chrism01 · 08-13-2008, 08:24 PM

Quote:

Your account has expired; please contact your system administrator

I'd start by checking what caused that msg.

gavin2u · 08-14-2008, 03:25 AM

Quote:

Originally Posted by chrism01

I'd start by checking what caused that msg.

i see that message from the command line.

and i deleted mysql group and user.

and then i reinstall mysql-server.

it display the same message. Failed again.

gavin2u · 08-21-2008, 03:30 AM

when i remove(--purge) mysql-server mysql-server-5.0 mysql-common
and also del mysql user and mysql group.

finally, i reinstall mysql. but, error again:

Quote:

sudo apt-get install mysql-server mysql-client libmysqlclient15-dev
Reading package lists... Done
Building dependency tree
Reading state information... Done
The following extra packages will be installed:
libdbd-mysql-perl libmysqlclient15off mysql-client-5.0 mysql-common mysql-server-5.0
Suggested packages:
mysql-doc-5.0 tinyca
Recommended packages:
apparmor libhtml-template-perl mailx
The following NEW packages will be installed:
libdbd-mysql-perl libmysqlclient15-dev libmysqlclient15off mysql-client mysql-client-5.0
mysql-common mysql-server mysql-server-5.0
0 upgraded, 8 newly installed, 0 to remove and 2 not upgraded.
Need to get 0B/44.6MB of archives.
After this operation, 130MB of additional disk space will be used.
Do you want to continue [Y/n]? y
Preconfiguring packages ...
Selecting previously deselected package mysql-common.
(Reading database ... 40139 files and directories currently installed.)
Unpacking mysql-common (from .../mysql-common_5.0.51a-3ubuntu5.1_all.deb) ...
Selecting previously deselected package libmysqlclient15off.
Unpacking libmysqlclient15off (from .../libmysqlclient15off_5.0.51a-3ubuntu5.1_i386.deb) ...
Selecting previously deselected package libdbd-mysql-perl.
Unpacking libdbd-mysql-perl (from .../libdbd-mysql-perl_4.005-1_i386.deb) ...
Selecting previously deselected package mysql-client-5.0.
Unpacking mysql-client-5.0 (from .../mysql-client-5.0_5.0.51a-3ubuntu5.1_i386.deb) ...
Setting up mysql-common (5.0.51a-3ubuntu5.1) ...
(Reading database ... 40240 files and directories currently installed.)
Unpacking mysql-server-5.0 (from .../mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb) ...
Your account has expired; please contact your system administrator
chfn: PAM authentication failed
adduser: `/usr/bin/chfn -f MySQL Server mysql' returned error code 1. Exiting.
dpkg: error processing /var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb (--unpack):
subprocess pre-installation script returned error exit status 1
Selecting previously deselected package libmysqlclient15-dev.
Unpacking libmysqlclient15-dev (from .../libmysqlclient15-dev_5.0.51a-3ubuntu5.1_i386.deb) ...
Selecting previously deselected package mysql-client.
Unpacking mysql-client (from .../mysql-client_5.0.51a-3ubuntu5.1_all.deb) ...
Selecting previously deselected package mysql-server.
Unpacking mysql-server (from .../mysql-server_5.0.51a-3ubuntu5.1_all.deb) ...
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.0_5.0.51a-3ubuntu5.1_i386.deb
E: Sub-process /usr/bin/dpkg returned an error code (1)

Your account has expired; please contact your system administrator
!!! which account has expired? (i have mysql user and group been deleted already).

help, please.

gavin2u · 08-21-2008, 04:36 AM

i find these msg in /var/log/auth.log

Quote:

Aug 21 16:59:09 tp05ftp chage[11549]: changed password expiry for mysql
Aug 21 16:59:09 tp05ftp chfn[11550]: pam_unix(chfn:account): account root has expired (account expired)
Aug 21 17:00:01 tp05ftp CRON[11717]: pam_unix(cron:account): account root has expired (account expired)
Aug 21 17:09:01 tp05ftp CRON[14081]: pam_unix(cron:account): account root has expired (account expired)
Aug 21 17:30:05 tp05ftp CRON[18367]: pam_unix(cron:account): account root has expired (account expired)

my root account has expired?

gavin2u · 08-21-2008, 08:11 AM

using the following cmd, i fixed the problem above, and sucessfully installed mysql

Quote:

sudo chage -E never root

Quote:

sudo apt-get install mysql-server

however, the last step of the mysql installation, the following tips appears on the screen:

Quote:

* Stopping MySQL database server mysqld [ OK ]
* Starting MySQL database server mysqld [ OK ]
* Checking for corrupt, not cleanly closed and upgrade needing tables.

how can i fix it?

thanks in advance.

gavin2u · 08-21-2008, 08:45 AM

when checking mysql databases, i got the msg below:

Quote:

sudo mysqlcheck -u root -p --repair --all-databases
Enter password:
mysql.columns_priv OK
mysql.db OK
mysql.func OK
mysql.help_category OK
mysql.help_keyword OK
mysql.help_relation OK
mysql.help_topic OK
mysql.host OK
mysql.proc OK
mysql.procs_priv OK
mysql.tables_priv OK
mysql.time_zone OK
mysql.time_zone_leap_second OK
mysql.time_zone_name OK
mysql.time_zone_transition OK
mysql.time_zone_transition_type OK
mysql.user OK

apokluda · 11-13-2008, 10:07 PM

Hey - I don't know why, but I had the same problem when setting up mysql on my VPS server. Maybe this has to do with the way the VPS was set up... it was set up for me with only one user account, the root account, and then I changed things back to the Ubuntu way using 'sudo'.