[lug] MySQL debugging (more info)

[D. Stimits]

"D. Stimits" wrote:
> 
> "D. Stimits" wrote:
> >
> > I managed to get MySQL installed, along with the python module. This is
> > on a RH 6.2 box, SMP, with 2.2.15 kernel. mysqld --version gives:
> > mysqld  Ver 3.22.32 for pc-linux-gnu on i686
> >
> > I did run the script mysql_install_db, which appears to have been
> > successful. Running "mysqladmin version" gives:
> > error: 'Can't connect to local MySQL server through socket
> > '/tmp/mysql.sock' (111)'
> > Check that mysqld is running and that the socket: '/tmp/mysql.sock'
> > exists!
> >
> > The file /tmp/mysql.sock does NOT exist.
> >
> > Checking /var/log/messages shows nothing related to network rejection.
> > Looking at ps, I see it apparently running. Going to /etc/rc.d/init.d/
> > and running "./mysql stop" and "./mysql start" shows success as well.
> > Even though I start it and get a message that it succeeded,
> > /tmp/mysql.sock never appears.
> >
> > If I try to just run "mysqld" directly after attempting start, it says
> > the port is already in use. If I then stop via the init.d script, I can
> > run mysqld directly, it then says it is ready for connections. Still,
> > the /tmp/mysql.sock does not show up. However, there are these /tmp/
> > files:
> > mysqlbug-27370, and mysqldb-root. Running "mysqladmin version" still
> > fails in the same manner.
> >
> > Something somewhere is either in conflict, or not set up correctly. Does
> > anyone have any idea what might be wrong?
> >
> > Thanks,
> > D. Stimits, stimits at idcomm.com
> >
> > _______________________________________________
> > Web Page:  http://lug.boulder.co.us
> > Mailing List: http://lists.lug.boulder.co.us/mailman/listinfo/lug
> 
> I found part of the answer so far, but not all. I changed some directory
> permissions in /usr/local/var/msql to allow read and execute within the
> dir for non-root (all of what I tested previously was as root though).
> 
> At this point the safe_mysqld worked, but still the
> /etc/rc.d/init.d/mysqld stop or start fails. It is looking for the /tmp/
> file, and still can't find it. Should I remove this script as
> incompatible with my version, and simply place safe_mysqld there instead
> (seems a bit drastic)?
> 
> Thanks,
> D. Stimits, stimits at idcomm.com
> 

I found that if I get started via safe_mysqld, then do "mysqld --help",
it mentions this info:
basedir:     /
datadir:     /var/lib/mysql/
tmpdir:      /tmp/
language:    /usr/share/mysql/english/
pid file:    /var/lib/mysql/thanteros.pid
TCP port:    3306
Unix socket: /var/lib/mysql/mysql.sock

system locking is not in use


This conflicts with the /etc/rc.d/init.d/mysql start error, whereby it
is looking for the socket file in /tmp/. On the other hand, mysql.sock
does appear in /tmp/ now. Any suggestions on where I've set this up
incorrectly? I'd like to start it via /etc/rc.d/init.d/mysql start and
stop, during normal boot.

Thanks,
D. Stimits, stimits at idcomm.com