MySQL won't start, and no /etc/init.d/mysql--my stdout and syslog after trying...

ineloquucius · 01-29-2010, 06:37 PM

On Ubuntu Server 9.10, new install, mysql-server will not install properly. It produces no error on apt-get install. I get the following when running "mysqld" as root:

Code:

100129 19:08:42 [Note] Plugin 'FEDERATED' is disabled.
100129 19:08:43  InnoDB: Started; log sequence number 0 44233
100129 19:08:43 [ERROR] Can't start server : Bind on unix socket: No such file or directory
100129 19:08:43 [ERROR] Do you already have another mysqld server running on socket: /var/run/mysqld/mysqld.sock ?
100129 19:08:43 [ERROR] Aborting

100129 19:08:43  InnoDB: Starting shutdown...
100129 19:08:44  InnoDB: Shutdown completed; log sequence number 0 44233
100129 19:08:44 [Warning] Forcing shutdown of 1 plugins
100129 19:08:44 [Note] mysqld: Shutdown complete

The last syslog message after:

Code:

Jan 29 19:33:46 atlas kernel: [10896.208070] type=1503 audit(1264811626.581:22): operation="open" pid=2160 parent=2142 profile="/usr/sbin/my
sqld" requested_mask="r::" denied_mask="r::" fsuid=0 ouid=0 name="/sys/devices/system/cpu/"

Any help is appreciated.

evo2 · 01-30-2010, 07:46 AM

What files are in /var/run/mysqld/?

Evo2.

kbp · 01-30-2010, 08:05 AM

Do you have selinux enabled ? If so, can you disable it temporarily to see it the issue is related

cheers

prasanta · 01-30-2010, 09:19 AM

I don't think `selinux` is installed by default in Ubuntu. Just do a `ps aux | grep mysql` and check if it is already running. Kill the processes and then try starting it. After installing `mysql` via `apt`, it gets started automatically.

--
Prasanta

ineloquucius · 01-30-2010, 10:01 AM

Thanks all for the replies.

Oddly, there is no mysqld/ directory in said location. This confuses me as well. There is also no instance of mysqld running. It looks, in fact, very much as if it were never installed--since there is also no mysql startup script in init.d--except that the mysqld executable obviously exists (per the output shown in the OP).

Also, I've looked into many howto's on installing mysql on Ubu-srv 9.10, and all were business as usual, so I'm led to believe that there are no selinux-like issues, but have been wondering the same thing (about port/service blocking).

<grumble onread=ignore>What I find so frustrating about this sort of thing is what I find frustrating about a great many things Linux--I haven't the faintest notion where to begin looking. Often, simply tailing the syslog leaves me no clues, and if a log file (or error log file, or...) even exists for the application, I'm left with the same. In this case, I've spent hours googling and poring over the documentation, troubleshooting, etc., and...ah, nevermind me...</grumble>

prasanta · 01-30-2010, 10:15 AM

Then just install mysql server via apt. You will have the mysql(not mysqld) directory in /var/lib. You can start mysql by `sudo /etc/init.d/mysql start` .

--
Prasanta

ineloquucius · 01-30-2010, 06:28 PM

That's what I'm saying: I did use apt-get, and I didn't have a mysql script in init.d

evo2 · 01-30-2010, 11:09 PM

Is it really installed properly? What is the output of:

Code:

dpkg -l  '*mysql*'
dpkg --audit

What happens if you do the following?

Code:

apt-get remove --purge mysql-sever5.0
apt-get install mysql-server5.0

(I'm just guessing the exact package name)

Evo2?

prasanta · 01-31-2010, 11:24 AM

mysql-server-5.0

--
Prasanta