|
FreeBSD General Other questions regarding FreeBSD which do not fit in any of the categories below. |
|
Thread Tools | Display Modes |
|
|
|||
MySQL continually restarting...
I really hope someone out there can help me with this!
My mysqld_safe daemon has suddenly begun to restart itself continually... jail0043# /usr/local/bin/mysqld_safe -user=mysql --log=/tmp/mysql.log & [1] 81057 jail0043# usage: touch [-A [-][[hh]mm]SS] [-acfhm] [-r file] [-t [[CC]YY]MMDDhhmm[.SS]] file ... usage: chown [-fhv] [-R [-H | -L | -P]] owner[:group] file ... chown [-fhv] [-R [-H | -L | -P]] :group file ... 080523 09:39:26 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql 080523 09:39:27 mysqld_safe mysqld restarted 080523 09:39:28 mysqld_safe mysqld restarted 080523 09:39:28 mysqld_safe mysqld restarted 080523 09:39:29 mysqld_safe mysqld restarted . . . The only means I have found to stop this is to "kill -9" the process, which is a bit nasty. The logfile shows nothing. myisamchk --recover did sort out my blog tables a bit - but hasn't solved this restarting problem. I can't find anything searching the 'net, which seems a bit strange - has anyone else come across this and can offer wordsof advice and wisdom? Cheers Bill |
|
||||
mysqld_safe restarts on error according to the man page.
Since it's a shells cript you are probably looking at this: Code:
echo "Starting $MYSQLD daemon with databases from $DATADIR" echo "`date +'%y%m%d %H:%M:%S mysqld started'`" >> $err_log while true do rm -f $safe_mysql_unix_port $pid_file # Some extra safety if test -z "$args" then $NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file >> $err_log 2>&1 else eval "$NOHUP_NICENESS $ledir/$MYSQLD $defaults --basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION --pid-file=$pid_file $args >> $err_log 2>&1" fi if test ! -f $pid_file # This is removed if normal shutdown then echo "STOPPING server from pid file $pid_file" break fi echo "`date +'%y%m%d %H:%M:%S'` mysqld restarted" | tee -a $err_log done echo "`date +'%y%m%d %H:%M:%S'` mysqld ended" | tee -a $err_log echo "" | tee -a $err_log
__________________
My Journal Thou shalt check the array bounds of all strings (indeed, all arrays), for surely where thou typest ``foo'' someone someday shall type ``supercalifragilisticexpialidocious''. |
|
||||
I might be a paranoid individual but I never give passwords over the command line.
To me, it's like using FTP...
__________________
My Journal Thou shalt check the array bounds of all strings (indeed, all arrays), for surely where thou typest ``foo'' someone someday shall type ``supercalifragilisticexpialidocious''. |
|
||||
If you are ssh'd into the box then I would respectfully assert that your paranoia is not justified. However, if you simply provide the -p without the password, it will prompt you to type the password, which will not appear.
If you are telnetted into the box you have already given away the keys to the kingdom upon login to the box itself.
__________________
Network Firefighter |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
MySql on NetBSD 5.0 | Zvrk | NetBSD General | 6 | 17th August 2009 12:31 PM |
Racoon: restarting a particular VPN connection | bram85 | General software and network | 0 | 21st January 2009 12:33 PM |
OpenLDAP and MySQL | PatrickBaer | FreeBSD General | 1 | 4th November 2008 04:44 PM |
MYSQL HOW TO START | disappearedng | FreeBSD General | 7 | 18th September 2008 09:48 AM |
mysql using >100% cpu | bdj | FreeBSD General | 5 | 16th May 2008 04:20 PM |