LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Server (http://www.linuxquestions.org/questions/linux-server-73/)
-   -   MySQL won't start, and no /etc/init.d/mysql--my stdout and syslog after trying... (http://www.linuxquestions.org/questions/linux-server-73/mysql-won%27t-start-and-no-etc-init-d-mysql-my-stdout-and-syslog-after-trying-785717/)

ineloquucius 01-29-2010 07:37 PM

MySQL won't start, and no /etc/init.d/mysql--my stdout and syslog after trying...
 
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 08:46 AM

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

Evo2.

kbp 01-30-2010 09: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 10: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 11: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 11: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 07: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-31-2010 12:09 AM

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 12:24 PM

mysql-server-5.0

--
Prasanta


All times are GMT -5. The time now is 01:11 AM.