I am trying to setup post nuke and it needs mysql. mysql won't start. rcmysql start gives this error in /var/lib/mysql/lead.err (lead like "fishing weights" is the name of the box) <see below for the lead.err file> I turned on start mysql in rc.config (using yast2) and set it to yes (as per in the suse manuals/books) After reinstalling mysql from RPM.. bash-2.05# cat /var/log/y2logRPMShort Installing mysql-devel ... OK Installing mysql Updating etc/rc.config... ... OK bash-2.05# cat /var/log/boot.msg <snipped for brevity> Starting ProFTPD Server: done Starting SSH daemondone Starting syslog servicesdone Importing Net File System (NFS)done Starting service at daemon:done Starting cupsddone Loading keymap qwerty/us.map.gz doneLoading compose table winkeys shiftctrl latin1.adddone Loading console font lat1-16.psfu doneSetting up console ttys doneStarting service MySQL Starting mysqld daemon with databases from /var/lib/mysql 011018 01:05:37 mysqld ended failed Starting mail service (Postfix)done Starting CRON daemondone Starting Name Service Cache Daemondone Starting service kdmdone Starting inetddone Starting sound driver: snd-card-sb16 done Restoring the previous sound settingdone Starting httpd [ Jserv PERL PHP4 Python ]done Starting personal-firewall (final) [not active]unused Master Resource Control: ruhed Failed services in runlevel 5: mysql <snip some more..> a cat of the /var/lib/mysql/lead.err file shows.. (here is that lead.err) mysqld started Can't start server : Bind on unix socket: Permission denied Do you already have another mysqld server running on socket: /var/lib/mysql/msql.sock ? /usr/sbin/mysqld: shutdown complete mysqld ended Well, since the lead.err file asked me if I have another mysqld running.. a netstat -paut shows... bash-2.05# netstat -paut Active Internet connections (servers and established) Proto Recv-Q Send-Q Local Address Foreign Address State PID/Program name tcp 0 0 *:login *:* LISTEN 898/inetd tcp 0 0 *:time *:* LISTEN 898/inetd tcp 0 0 localhost:8007 *:* LISTEN 1024/java tcp 0 0 172.16.67.1:netbios-ssn *:* LISTEN 297/vmware-smbd tcp 0 0 *:6000 *:* LISTEN 1760/X tcp 0 0 *:www-http *:* LISTEN 1021/httpd tcp 0 0 *:ftp *:* LISTEN 401/proftpd (accept tcp 0 0 *:ipp *:* LISTEN 502/cupsd tcp 0 0 *:smtp *:* LISTEN 759/master tcp 0 0 *:32957 *:* LISTEN 1911/kdeinit: kxmlr tcp 0 0 localhost:8007 localhost:33337 TIME_WAIT - tcp 0 0 localhost:8007 localhost:33336 TIME_WAIT - tcp 0 0 localhost:8007 localhost:33335 TIME_WAIT - tcp 0 0 localhost:8007 localhost:33334 TIME_WAIT - tcp 0 0 localhost:8007 localhost:33333 TIME_WAIT - tcp 0 0 localhost:8007 localhost:33335 TIME_WAIT - tcp 0 0 *:ssh *:* LISTEN 421/sshd udp 0 0 172.16.67.1:netbios-ns *:* 272/vmware-nmbd udp 0 0 *:netbios-ns *:* 272/vmware-nmbd udp 0 0 172.16.67.1:netbios-dgm *:* 272/vmware-nmbd udp 0 0 *:netbios-dgm *:* 272/vmware-nmbd udp 0 0 *:time *:* 898/inetd udp 0 0 *:ipp *:* 502/cupsd I'd say no. I don't see it. other notes: there is no mysql.sock file in /var/lib/mysql (using ls -a) (there was before I reinstalled and rm -rf'd /var/lib/mysql ; but even then I was still getting a mysql.sock error and mysql wouldn't start. error was (111) Now it's either (2) or (13) ) there are no locks in /var/lock (I looked) I've uninstalled / reinstalled mysql, it still doesn't work I've rm -rf /var/lib/mysql it still don't work I've looked throug the /etc/my.cnf I don't see anything (over and over and over) I ran mysql_install_db (over and over and over) I ran mysqladmin (adding passwords for mysql and host ie. both commands over and over and over and over and over) Yikes. what have I done?
Hi Phil On Thursday 18 October 2001 09:47, you wrote:
Starting service MySQL Starting mysqld daemon with databases from /var/lib/mysql 011018 01:05:37 mysqld ended failed Failed services in runlevel 5: mysql
rcmysql start doesn't seem to like it if you have run mysql_install_db yourself - it wants to do it for you. That is, install the MySQL package, set START_MYSQL in rc.config to "yes" (Yast -> System Administration -> Change configuration file), and then (as root) run "rcmysql start". This creates the user databases and starts the demon running. Since you have done something else, what you might try doing as a shortcut is to rename the /var/lib/mysql folder to /var/lib/mysqlold, and then run rcmysql start. It may be that once you have done this, MySQL will not allow you to access the users you have set up. If you hit this problem, post again, and we can take it from there. Best wishes Kevin -- 4:17pm up 8 days, 8:03, 1 user, load average: 0.02, 0.05, 0.01
That was it. mv /var/lib/mysql /var/lib/mysqlold rcmysql I can't believe it was that easy. Post nuke is up and running. THANKS! On Thursday 18 October 2001 09:25 am, you wrote:
Hi Phil
On Thursday 18 October 2001 09:47, you wrote:
Starting service MySQL Starting mysqld daemon with databases from /var/lib/mysql 011018 01:05:37 mysqld ended failed Failed services in runlevel 5: mysql
rcmysql start doesn't seem to like it if you have run mysql_install_db yourself - it wants to do it for you.
That is, install the MySQL package, set START_MYSQL in rc.config to "yes" (Yast -> System Administration -> Change configuration file), and then (as root) run "rcmysql start". This creates the user databases and starts the demon running.
Since you have done something else, what you might try doing as a shortcut is to rename the /var/lib/mysql folder to /var/lib/mysqlold, and then run rcmysql start.
It may be that once you have done this, MySQL will not allow you to access the users you have set up. If you hit this problem, post again, and we can take it from there.
Best wishes
Kevin
participants (2)
-
Kevin Donnelly
-
phil