MySQL -apparently- will not in Debian Etch

walterbyrd · 01-09-2010, 07:46 PM

I removed mysql, then reinstalled it. Everything seemed to go normally during the install. Apparently, debian thinks mysql is installed, but it isn't - or does not seem to be.

When I do a whereis, I get nothing. When I look for the files, they are really not there.

Quote:

# whereis mysql
mysql:
# /usr/local# mysqld
100109 18:40:23 [ERROR] Can't find messagefile '/usr/share/mysql/english/errmsg.sys'
100109 18:40:23 [ERROR] Aborting
# mysql_install_db
Could not find help file 'fill_help_tables.sql' in /usr/share/mysql or inside /usr.
# /etc/init.d/mysql
-bash: /etc/init.d/mysql: No such file or directory
# /usr/local# /etc/init.d/mysqld
-bash: /etc/init.d/mysqld: No such file or directory

Quote:

# aptitude install mysql-server mysql-client
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Reading task descriptions... Done
Building tag database... Done
The following packages have been kept back:
openssh-client openssh-server
0 packages upgraded, 0 newly installed, 0 to remove and 2 not upgraded.
Need to get 0B of archives. After unpacking 0B will be used.
Writing extended state information... Done

evo2 · 01-09-2010, 08:01 PM

Quote:

Originally Posted by walterbyrd

I removed mysql, then reinstalled it. Everything seemed to go normally during the install. Apparently, debian thinks mysql is installed, but it isn't - or does not seem to be.

"debian thinks" um, what part of Debian is doing this thinking? dpkg is what you should use to see the status of packages. For example:

Code:

dpkg -l 'mysql*' | grep ^ii

Quote:

When I do a whereis, I get nothing. When I look for the files, they are really not there.

So this is a question about "whereis"? Or how to query dpkg?

Evo2.

walterbyrd · 01-09-2010, 08:49 PM

Okay, I'll put it this way: nothing works. Directories such as "/usr/share/mysql" don't exist. There does not seem to be a socket file. Yet aptitude, and maybe even dpkg seem to indicate that everything installed correctly.

Quote:

# dpkg -l 'mysql*' | grep ^ii
ii mysql-client 5.0.32-7etch11 mysql database client (meta package depending on the latest version)
ii mysql-client-5.0 5.0.32-7etch11 mysql database client binaries
ii mysql-common 5.0.32-7etch11 mysql database common files (e.g. /etc/mysql/my.cnf)
ii mysql-server 5.0.32-7etch11 mysql database server (meta package depending on the latest version)
ii mysql-server-5.0 5.0.32-7etch11 mysql database server binaries

evo2 · 01-09-2010, 08:54 PM

Ok, I see. Seems somehow things have been deleted. Please try reinstalling the mysql pacakges

Code:

aptitude reinstall mysql-client-5.0 mysql-server-5.0 mysql-common

Cheers,

Evo2.

walterbyrd · 01-10-2010, 08:44 AM

Did that, got this message at the end of the aptitude output:

Quote:

invoke-rc.d: unknown initscript, /etc/init.d/mysql not found.

When I try to run mysql, I get this:

Quote:

# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
# mysqld
100110 7:37:39 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

100110 7:37:39 [ERROR] Aborting

100110 7:37:39 [Note] mysqld: Shutdown complete

evo2 · 01-10-2010, 08:40 PM

The install/remove scripts are failing because the mysql start/stop script is missing. You have a couple of options, edit the failing install/remove script to simply return 0 or you could try to manually recover /etc/init.d/mysql from somewhere.
For example, another machine, or manually unpack the mysql-server-5.0 pacakge using ar and tar, etc. Do you know how/why /etc/init.d/mysql was deleted in the first place, and if other files were deleted? Knowing this will help indicate the best way to recover your mysql installation

Evo2.

walterbyrd · 01-13-2010, 12:19 PM

After fighting with this for days on end, I gave up in complete frustration, and asked my VPS to completely re-image my server. And now I am still unable to get msyql installed. I have uninstalled, purged, reinstalled, and so on many *many* times.

There is an init script:

Quote:

# ls -l /etc/init.d/mysql
-rwxr-xr-x 1 root root 6127 2009-08-27 13:05 /etc/init.d/mysql

But it will not work.

this is from my latest attempt to install.

Quote:

# aptitude install mysql-server
Reading package lists... Done
Building dependency tree... Done
Reading extended state information
Initializing package states... Done
Writing extended state information... Done
Reading task descriptions... Done
Building tag database... Done
The following NEW packages will be installed:
mysql-server
0 packages upgraded, 1 newly installed, 0 to remove and 0 not upgraded.
Need to get 0B/48.6kB of archives. After unpacking 86.0kB will be used.
Writing extended state information... Done
Selecting previously deselected package mysql-server.
(Reading database ... 12745 files and directories currently installed.)
Unpacking mysql-server (from .../mysql-server_5.0.32-7etch11_all.deb) ...
Stopping MySQL database server: mysqld.
Setting up mysql-server-5.0 (5.0.32-7etch11) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)
A package failed to install. Trying to recover:
Setting up mysql-server-5.0 (5.0.32-7etch11) ...
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing mysql-server-5.0 (--configure):
subprocess post-installation script returned error exit status 1
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.0; however:
Package mysql-server-5.0 is not configured yet.
dpkg: error processing mysql-server (--configure):
dependency problems - leaving unconfigured
Errors were encountered while processing:
mysql-server-5.0
mysql-server

I have also tried install mysql-server-5.0, and mysql-common, and so much more.

walterbyrd · 01-13-2010, 01:21 PM

I looked in /var/log/dpkg.log, but that was not help - it just told that MySQL stopped installing half-way through.

I also looked in /var/log/deamon.log

Quote:

# tail daemon.log
Jan 13 19:13:03 wb mysqld_safe[17546]: http://www.mysql.com
Jan 13 19:13:03 wb mysqld_safe[17546]: Support MySQL by buying support/licenses at http://shop.mysql.com
Jan 13 19:13:04 wb mysqld_safe[17711]: started
Jan 13 19:13:04 wb mysqld[17714]: InnoDB: Error: pthread_create returned 12
Jan 13 19:13:04 wb mysqld_safe[17723]: ended
Jan 13 19:13:20 wb /etc/init.d/mysql[19870]: 0 processes alive and '/usr/bin/mysqladmin --defaults-file=/etc/mysql/debian.cnf ping' resulted in
Jan 13 19:13:20 wb /etc/init.d/mysql[19870]: ^G/usr/bin/mysqladmin: connect to server at 'localhost' failed
Jan 13 19:13:20 wb /etc/init.d/mysql[19870]: error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Jan 13 19:13:20 wb /etc/init.d/mysql[19870]: Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
Jan 13 19:13:20 wb /etc/init.d/mysql[19870]:

btw, I am not sure where that "wb" is coming from. That used to be the alias for my host name, but not anymore.

Also the .sock file does not exist.

[quote]
# ls -l /var/run/mysqld/mysqld.sock
ls: /var/run/mysqld/mysqld.sock: No such file or directory
[/quote

]

evo2 · 01-13-2010, 03:06 PM

So now it seems to be failing in the post install script during "/etc/init.d/mysql start". Have you tried putting "set -x" on the 2nd line of that script and then doing 'dpkg --reconfigure mysql-server-5.0'?

EVo2.

walterbyrd · 02-07-2010, 06:21 PM

I have given up, I am afraid to even try to install mysql.

I used to think that debian had a great package management system, now I am disappointed.

evo2 · 02-07-2010, 07:24 PM

In post #8 you have the error

Quote:

Jan 13 19:13:04 wb mysqld[17714]: InnoDB: Error: pthread_create returned 12

I think this is the root of your problems. Google has much to say about this error, with *many* of the problems happening on VPSs.

Evo2.