Re: MYSQL not starting
Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
I have disabled selinux but no luck [EMAIL PROTECTED] ~]# system-config-securitylevel Security Level (*) Disabled OK [EMAIL PROTECTED] ~]# /etc/init.d/mysql start Starting MySQL... [FAILED] [EMAIL PROTECTED] ~]# I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process I have also tried running these commands : [EMAIL PROTECTED] sqlserver4.1]# rpm -Uvh MySQL-server-4.1.14-0.i386.rpm --force warning: MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f 5 Preparing...### [100%] Giving mysqld a couple of seconds to exit nicely 1:MySQL-server ### [100%] 060301 15:16:12 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:16:12 [ERROR] Can't create interrupt-thread (error 11, errno: 4) Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL...[FAILED] [EMAIL PROTECTED] sqlserver4.1]# [EMAIL PROTECTED] sqlserver4.1]# /usr/sbin/mysqld --skip-grant 060301 15:20:44 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:20:44 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 060301 15:20:44 [ERROR] Aborting 060301 15:20:44 [Note] /usr/sbin/mysqld: Shutdown complete [EMAIL PROTECTED] sqlserver4.1]# Can anyone Please HELP - Original Message - From: Tom Brown [EMAIL PROTECTED] To: Atul Aggarwal [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 9:18 PM Subject: Re: MYSQL not starting Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
I have disabled selinux but no luck how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
Thanks Tom! Ya it was a problem of SELinux but i had to turn it off from GUI not from CUI(system-config-securitylevel). It really did worked. Thanks Again :) - Original Message - From: Tom Brown [EMAIL PROTECTED] To: Atul Aggarwal [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 11:04 PM Subject: Re: MYSQL not starting I have disabled selinux but no luck how? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] - Original Message - From: Atul Aggarwal [EMAIL PROTECTED] To: Tom Brown [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 10:50 PM Subject: Re: MYSQL not starting I have disabled selinux but no luck [EMAIL PROTECTED] ~]# system-config-securitylevel Security Level (*) Disabled OK [EMAIL PROTECTED] ~]# /etc/init.d/mysql start Starting MySQL... [FAILED] [EMAIL PROTECTED] ~]# I am receiving these errors in /var/lib/mysql/*.err 060301 14:32:08 mysqld started 060301 14:32:08 [Warning] Asked for 196608 thread stack, but got 126976 InnoDB: Error: pthread_create returned 11 060301 14:32:08 mysqld ended And when I scroll through /var/log/messages I get these : Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process I have also tried running these commands : [EMAIL PROTECTED] sqlserver4.1]# rpm -Uvh MySQL-server-4.1.14-0.i386.rpm --force warning: MySQL-server-4.1.14-0.i386.rpm: V3 DSA signature: NOKEY, key ID 5072e1f 5 Preparing...### [100%] Giving mysqld a couple of seconds to exit nicely 1:MySQL-server ### [100%] 060301 15:16:12 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:16:12 [ERROR] Can't create interrupt-thread (error 11, errno: 4) Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. You can also try to start the mysqld daemon with: /usr/sbin/mysqld --skip-grant You can use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell /usr/bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in /var/lib/mysql that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the /usr/bin/mysqlbug script! Starting MySQL...[FAILED] [EMAIL PROTECTED] sqlserver4.1]# [EMAIL PROTECTED] sqlserver4.1]# /usr/sbin/mysqld --skip-grant 060301 15:20:44 [Warning] Asked for 196608 thread stack, but got 126976 060301 15:20:44 [ERROR] Fatal error: Please read Security section of the manual to find out how to run mysqld as root! 060301 15:20:44 [ERROR] Aborting 060301 15:20:44 [Note] /usr/sbin/mysqld: Shutdown complete [EMAIL PROTECTED] sqlserver4.1]# Can anyone Please HELP - Original Message - From: Tom Brown [EMAIL PROTECTED] To: Atul Aggarwal [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, March 01, 2006 9:18 PM Subject: Re: MYSQL not starting Mar 1 14:32:12 moon kernel: audit(1141241528.781:45036): avc: denied { execmem } for pid=20857 comm=mysqld scontext=root:system_r:mysqld_t tcontext=root:system_r:mysqld_t tclass=process you have enabled selinux disable it or learn how to use it correctly -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-4.1.16 starting trouble
On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed: http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html Do you know, 4.1.14 or 4.1.15 has this bug? I need to use 4.1.x. When will be released 4.1.17? Thanks. -- Wed Jan 18 22:33:42 ALMT 2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-4.1.16 starting trouble
Privet! This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed: http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html Trux wrote: Hi! Sorry for my english, im russian. I have trouble with starting mysql-4.1.16. I compiled it from source, and when i run: # mysql_install_db --user=mysql i've got: - ERROR: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 060115 10:47:57 [ERROR] Aborting 060115 10:47:57 [Note] /usr/libexec/mysqld: Shutdown complete bin/mysql_install_db: line 299: 20545 Broken pipe cat $fill_help_tables - Anyone know how solve it? Thanks. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-4.1.16 starting trouble
On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed: http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html Well, thanks! What about next release in 4.1.x? May be it will fix this bug? -- Tue Jan 17 16:10:15 ALMT 2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql-4.1.16 starting trouble
What about next release in 4.1.x? May be it will fix this bug? I hope it will. Trux wrote: On Tuesday 17 January 2006 14:37, Gleb Paharenko wrote: This is a bug: http://bugs.mysql.com/bug.php?id=15965 Have a look here as well: http://bugs.mysql.com/bug.php?id=15151 Most probable you will have to install the latest development source, which has this bug fixed: http://dev.mysql.com/doc/refman/5.0/en/installing-source-tree.html Well, thanks! What about next release in 4.1.x? May be it will fix this bug? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Hello. Are you able to start MySQL server by this command? service mysqld start I think you should put the correct values for the basedir, datadir, PATH variables at the beginning of the /etc/init.d/mysql file. Mark Sargent [EMAIL PROTECTED] wrote: Hi All, attempting another mysql install, on a 3rd machine. Extracted the tar.gz file to /usr/local/mysql. Followed the install docs here, http://dev.mysql.com/doc/mysql/en/installing-binary.html and successfully ran the MySql grant tables script, 6. If you haven't installed MySQL before, you must create the MySQL grant tables: shell scripts/mysql_install_db --user=mysql I then followed here, http://dev.mysql.com/doc/mysql/en/automatic-start.html to a T, and copied mysql.server to /etc/init.d, and just for good measure, gave it permission to execute, chmod +x /etc/init.d/mysql I then rebooted, to see how things would go at boot, and saw a failed message for mysqld_safe, Apr 16 21:20:01 localhost lsb_log_message: Can't execute ./bin/mysqld_safe failed Can anyone explain why it wouldn't start..? Anything I should be looking for..? I can start the server with ./mysqld_safe from within the bin dir and I can connect as root or mysql. Cheers. /etc/init.dmysql permissions [EMAIL PROTECTED] init.d]# ls -lh mysql -rwxr-xr-x 1 root root 6.2K Apr 16 21:11 mysql Mark Sargent. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. (It was safe_mysqld in mysql 3.) [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] Your error message is right there -- Can't execute ./bin/mysqld_safe. If you look in mysql.server, you'll see cd $basedir case $mode in 'start') # Start daemon if test -x $bindir/mysqld_safe then # ... code to start the server ... else log_failure_msg Can't execute $bindir/mysqld_safe fi Clearly, ./bin/mysqld_safe is failing the -x test. As you previously reported that ./mysqld_safe works if you are in mysql's bin directory, we know that mysqld_safe is executable. Hence, when mysql.server tries to run ./bin/mysqld_safe, it must not be in the right directory. That is, it has the wrong value for $basedir. Perhaps you installed mysql somewhere other than the standard location? You could edit mysql.server to add an echo $basedir right before the cd, then run it by hand to you can see where the script thinks it should go. The fix will probably involve setting the basedir in /etc/my.cnf to the correct value. If that's not enough to get you going in the right direction, write back and let us know. Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Michael Stassen wrote: Mark Sargent wrote: Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. (It was safe_mysqld in mysql 3.) Not sure what you mean there.. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] Your error message is right there -- Can't execute ./bin/mysqld_safe. If you look in mysql.server, you'll see cd $basedir case $mode in 'start') # Start daemon if test -x $bindir/mysqld_safe then # ... code to start the server ... else log_failure_msg Can't execute $bindir/mysqld_safe fi Clearly, ./bin/mysqld_safe is failing the -x test. As you previously reported that ./mysqld_safe works if you are in mysql's bin directory, we know that mysqld_safe is executable. Hence, when mysql.server tries to run ./bin/mysqld_safe, it must not be in the right directory. That is, it has the wrong value for $basedir. Perhaps you installed mysql somewhere other than the standard location? Nope, it is located here, /usr/local/mysql. You could edit mysql.server to add an echo $basedir right before the cd, then run it by hand to you can see where the script thinks it should go. The fix will probably involve setting the basedir in /etc/my.cnf to the correct value. Yes, I went and looked at the script, to see if something was wrong. I couldn't see anything out of order, although, I'm a novice at scripts(programming). If that's not enough to get you going in the right direction, write back and let us know. Hopefully it'll get me going. Cheers. Michael Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting at boot-Fedora Core 3
Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy -- Registered Linux User Number 379093 -- --BEGIN GEEK CODE BLOCK- Version: 3.1 GAT/O/E$ d-(---)+ s:(+): a--(-)? C$(+++) UL$ P-(+)++ L+++$ E---(-)@ W++$ !N@ o? !K? W--(---) !O !M- V-- PS++(+++) PE--(-) Y+ PGP++(+++) t+(++) 5-- X++ R*(+)@ !tv b-() DI(+) D+(+++) G(+) e$@ h++(*) r--++ y--() -- ---END GEEK CODE BLOCK-- -- Check out these few php utilities that I released under the GPL2 and that are meant for use with a php cli binary: http://www.vlaamse-kern.com/sas/ -- -- pgpAURHhrWK92.pgp Description: PGP signature
Re: MySQL not starting at boot-Fedora Core 3
Andy Pieters wrote: Hi Try to see in the log files cat /var/log/mysqld or start the mysql server and then type tail /var/log/messages On Fedora, once you have properly installed mysql there is no need to reboot your system to test it. Just type /sbin/service mysql start other options you can use there: stop restart I have a MySql server on one of my machines that is running FC3 and I don't even have mysql_safe here. (Version 3.23.58) Andy Hi All, that's just the problem. It won't start that way. I had already checked the logs, but, it only seems to log things after starting, bringing me back to zero position, a server that won't start this way. Cheers. [EMAIL PROTECTED] ~]# /sbin/service mysql start Can't execute ./bin/mysqld_safe[FAILED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql not starting at boot
On Wednesday, March 30, 2005 23:26, Mark Sargent wrote: Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives an error stating it can't connect. Cheers. Mark Sargent. I assume you are able to start it after boot using 'service mysql start'. Run: chkconfig --list mysql This should show a list of runlevels with on and off. If not run: chkconfig --add mysql -- Tom Crimmins Interface Specialist Pottawattamie County, Iowa -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql not starting at boot
Tom Crimmins wrote: On Wednesday, March 30, 2005 23:26, Mark Sargent wrote: Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives an error stating it can't connect. Cheers. Mark Sargent. I assume you are able to start it after boot using 'service mysql start'. Run: chkconfig --list mysql This should show a list of runlevels with on and off. If not run: chkconfig --add mysql Hi All, thanx, that did it. Cheers. Mark Sargent. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql not starting at boot
To have mysql to start at boot you need to inform the inetd (daemon) that mysql should be launched at one of the 6 levels: Use chkconfig to have mysql start in one of the level (2,3,4,5,6) 5 being X windows. There are two ways to check that mysql will be loaded: - 1 - by checking the file in /etc/rc.d/rcX.d (X being a number: 1,2,3,4,5,6) - 2 - by executing chkconfig execute the following to see if mysql runs at any level /sbin/chkconfig --list | grep mysql you should see at which level mysql is running. mysql 0:off 1:off 2:off 3:off 4:off 5:off 6:off If it is all off then execute: /sbin/chkconfig --level 2345 mysql on (this will make sure that mysql runs at level 2, 3, 4 and 5) On my machine (Fedora 2) it runs at 2,3,4 and 5. Once you have it run at a level you can verify it by looking at rcX.d (X being a level): for example to check that it runs at level 4: go to /etc/rc.d/rc4.d/ and look at a file named ...mysql S20mysql (S means it will be picked up by the inetd daemon) K30mysql (K means Kill and mysql wont start) good luck Laurie On Wednesday 30 March 2005 09:26 pm, Mark Sargent wrote: Hi All, below is my /etc/init.d/mysql content, but, mysql is not starting at boot on Fedora3. Have I missed something fundamental.? I need mysql to start at boot for snort to connect to it. Currently, snort gives an error stating it can't connect. Cheers. Mark Sargent. [EMAIL PROTECTED] ~]# cat /etc/init.d/mysql #!/bin/sh # Copyright Abandoned 1996 TCX DataKonsult AB Monty Program KB Detron HB # This file is public domain and comes with NO WARRANTY of any kind # MySQL daemon start/stop script. # Usually this is put in /etc/init.d (at least on machines SYSV R4 based # systems) and linked to /etc/rc3.d/S99mysql and /etc/rc0.d/K01mysql. # When this is done the mysql server will be started when the machine is # started and shut down when the systems goes down. # Comments to support chkconfig on RedHat Linux # chkconfig: 2345 90 20 # description: A very fast and reliable SQL database engine. # Comments to support LSB init script conventions ### BEGIN INIT INFO # Provides: mysql # Required-Start: $local_fs $network $remote_fs # Required-Stop: $local_fs $network $remote_fs # Default-Start: 2 3 4 5 # Default-Stop: 0 1 6 # Short-Description: start and stop MySQL # Description: MySQL is a very fast and reliable SQL database engine. ### END INIT INFO # If you install MySQL on some other places than /usr/local/mysql, then you # have to do one of the following things for this script to work: # # - Run this script from within the MySQL installation directory # - Create a /etc/my.cnf file with the following information: # [mysqld] # basedir=path-to-mysql-installation-directory # - Add the above to any other configuration file (for example ~/.my.ini) # and copy my_print_defaults to /usr/bin # - Add the path to the mysql-installation-directory to the basedir variable # below. # # If you want to affect other MySQL variables, you should make your changes # in the /etc/my.cnf, ~/.my.cnf or other MySQL configuration files. basedir= # The following variables are only set for letting mysql.server find things. # Set some defaults datadir=/usr/local/mysql/data pid_file= if test -z $basedir then basedir=/usr/local/mysql bindir=./bin else bindir=$basedir/bin fi PATH=/sbin:/usr/sbin:/bin:/usr/bin:$basedir/bin export PATH mode=$1# start or stop case `echo testing\c`,`echo -n testing` in *c*,-n*) echo_n= echo_c= ;; *c*,*) echo_n=-n echo_c= ;; *) echo_n= echo_c='\c' ;; esac parse_arguments() { for arg do case $arg in --basedir=*) basedir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --datadir=*) datadir=`echo $arg | sed -e 's/^[^=]*=//'` ;; --pid-file=*) pid_file=`echo $arg | sed -e 's/^[^=]*=//'` ;; esac done } # Get arguments from the my.cnf file, # groups [mysqld] [mysql_server] and [mysql.server] if test -x ./bin/my_print_defaults then print_defaults=./bin/my_print_defaults elif test -x $bindir/my_print_defaults then print_defaults=$bindir/my_print_defaults elif test -x $bindir/mysql_print_defaults then print_defaults=$bindir/mysql_print_defaults else # Try to find basedir in /etc/my.cnf conf=/etc/my.cnf print_defaults= if test -r $conf then subpat='^[^=]*basedir[^=]*=\(.*\)$' dirs=`sed -e /$subpat/!d -e 's//\1/' $conf` for d in $dirs do d=`echo $d | sed -e 's/[ ]//g'` if test -x $d/bin/my_print_defaults then print_defaults=$d/bin/my_print_defaults break fi if test -x $d/bin/mysql_print_defaults then print_defaults=$d/bin/mysql_print_defaults break fi done fi # Hope it's in the PATH ... but I doubt it test -z $print_defaults print_defaults=my_print_defaults fi # # Test if someone changed datadir; In
Re: MYSQL not starting
did you look at datadir specification in my.ini? -Martin - Original Message - From: Jerry Rasmussen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 5:59 PM Subject: MYSQL not starting I recently installed mysql 4 from source. After compiling everything I am unable to start mysql. This is the error I get in the log when I try to start mysql. 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) I am trying to get this to run on a Red Hat 9 install of Linux. Any help would be appreciated. Thanks Jerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
I do not have a my.ini. I do have a my.cnf. Any other ideas. On Fri, 2003-09-05 at 00:44, Martin Gainty wrote: did you look at datadir specification in my.ini? -Martin - Original Message - From: Jerry Rasmussen [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 04, 2003 5:59 PM Subject: MYSQL not starting I recently installed mysql 4 from source. After compiling everything I am unable to start mysql. This is the error I get in the log when I try to start mysql. 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) I am trying to get this to run on a Red Hat 9 install of Linux. Any help would be appreciated. Thanks Jerry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MYSQL not starting
In the last episode (Sep 04), Jerry Rasmussen said: I recently installed mysql 4 from source. After compiling everything I am unable to start mysql. This is the error I get in the log when I try to start mysql. 030901 19:41:35 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13) I am trying to get this to run on a Red Hat 9 install of Linux. Any help would be appreciated. $ perror 13 Error code 13: Permission denied Check the permissions on the datadir and make sure whatever user mysqld is running as can read the files. -- Dan Nelson [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySQL not starting.
You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting.
I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting.
One line says : The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Does it exist? Is it executable? Is it owned my mysql? Does mysql own /usr/local/mysql and all its subdirectories and files? Another line says ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) Error 2 means that the directory doesn't exist. Does it? Does mysql own it and all its subdirectories and files? Why is one directory /usr/local/mysql and the other /usr/local/mysql-3.23.52-pc-linux-gnu-i686 ? It looks to me like the log is telling you everything you need to know to find the problem. [EMAIL PROTECTED] wrote: I have tried both as myself and as root and received the same results. Thanks, Ed On Wed, 23 Oct 2002, gerald_clark wrote: You are not logged in as root. [EMAIL PROTECTED] wrote: I recently installed MySQL-3.23.52 and ranthrough the config and installation without any trouble. The server was running just fine. Today I performed a reboot of the system and the server will not start up again. I also tried to start the server by hand and these are the error messages I'm receiving: from /usr/local/mysql/bin... [ed@home bin]$ ./safe_mysqld The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable Please do a cd to the mysql installation directory and restart this script from there as follows: ./bin/safe_mysqld. [ed@home bin]$ ./mysqld 021023 7:03:11 Warning: setrlimit couldn't increase number of open files to mo re than 256 021023 7:03:11 Warning: Changed limits: max_connections: 100 table_cache: 73 ./mysqld: Can't change dir to '/usr/local/mysql-3.23.52-pc-linux-gnu-i686/var/' (Errcode: 2) 021023 7:03:11 Aborting 021023 7:03:11 ./mysqld: Shutdown Complete Can anyone gather from this info why it's not starting and what I need to do to make it work again. The main installation directory is /usr/local/mysql-3.23.52-pc-linux-gnu-i686 and /usr/local/mysql is a link. Like I said before the server started just fine after initial installation. TIA, Ed Curtis - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting.
Are you sure your sym-links have not been deleted? - Mark System Administrator Asarian-host.org --- If you were supposed to understand it, we wouldn't call it code. - FedEx - Original Message - From: gerald_clark [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, October 23, 2002 10:14 PM Subject: Re: MySQL not starting. One line says : The file /usr/local/mysql/libexec/mysqld doesn't exist or is not executable - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL not starting ?
On Friday, June 14, 2002, at 03:48 PM, Laura Findley wrote: Normally, I issue the command: [root@localhost root]# safe_mysqld -user=root [1] 1781 [root@localhost root]# Starting mysqld daemon with databases from /var/lib/mysql 020614 02:09:36 mysqld ended Are you really only using one hyphen before user? Try using two: [root]# safe_mysqld --user=root Erik Price Web Developer Temp Media Lab, H.H. Brown [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MYSQL not starting properly
I had the same problem on with Red Hat 7 using mysql-3.23.33. I installed from RPM and source. Never could get the darn thing working. I just scrapped .33 and downloaded .36. Works like a charm now. DG Description: I am having a problem starting the mysql daemon from the command line. I am using the following command from /usr/local/mysql :- bin/safe_mysqld -u root The resultant error file /usr/local/mysql/data/bon.err, has the following entries:- mysqld started on Thursday April 26 14:24:48 BST 2001 010426 14:24:48 /usr/local/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 010426 14:24:48 /usr/local/mysql/bin/mysqld: Normal shutdown 010426 14:24:48 /usr/local/mysql/bin/mysqld: Shutdown Complete mysqld ended on Thursday April 26 14:24:48 BST 2001 Any clues ? How-To-Repeat: Use above command Fix: Unknown Submitter-Id: submitter ID Originator:Mark Leedham Organization: Startle plc 18-21 Cavaye Place Chelsea London UK SW10 9PT +44 (0)207 341 0947 MySQL support: none Synopsis: mysql not starting properly Severity: critical Priority: high Category: mysql Class: support Release: mysql-3.23.33 (Official MySQL binary) Environment: machine System: SunOS bon 5.7 Generic_106541-14 sun4u sparc SUNW,Ultra-80 Architecture: sun4 Some paths: /usr/bin/perl /usr/local/bin/make /usr/local/bin/gcc GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs gcc version 2.8.1 Compilation info: CC='gcc' CFLAGS='-O3 ' CXX='gcc' CXXFLAGS='-O3 -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1732880 Dec 15 00:43 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 30 2000 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 bin bin 1147500 Dec 15 00:44 /usr/lib/libc.so.1 Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=Official MySQL binary' --with-extra-charsets=complex --enable-assembler --disable-shared _ Get your FREE download of MSN Explorer at http://explorer.msn.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php