RE: Startup Error
Richard, In my instructions, the chowns are as follows: shell chown -R root /usr/local/mysql/. shell chown -R mysql /usr/local/mysql/data shell chgrp -R mysql /usr/local/mysql/. Note no slash after data. However, you have world read and write on the data folder anyway The mysql folder is a link into /root/mysql-max-4.1.14-pc-linux-gnu-i686 My guess is that the tomcat user can't create a file in /root/ mysql-max-4.1.14-pc-linux-gnu-i686/data What do you get if you do: ls -l /root/mysql-max-4.1.14-pc-linux-gnu-i686 Can tomcat write into this? Andy _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: 20 September 2005 12:00 To: 'Andy Eastham' Subject: RE: Startup Error [EMAIL PROTECTED] mysql]# ls -l /usr/local/mysql lrwxrwxrwx1 root root 40 Sep 19 09:00 /usr/local/mysql - /root/mysql-max-4.1.14-pc-linux-gnu-i686 Richard Johnson 212-589-6503 [EMAIL PROTECTED] -Original Message- From: Andy Eastham [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 20, 2005 4:58 AM To: Johnson, Richard (NY Int) Subject: RE: Startup Error Richard, What output do you get from: ls -l /usr/local/mysql Andy -Original Message- From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: 19 September 2005 19:57 To: 'mysql@lists.mysql.com' Subject: RE: Startup Error Still getting the following errors after running the chown's below... Here is what the ls -l result window shows... mysql]# ls -l /usr/local/mysql/data total 20536 -rw-rw1 mysqlmysql10485760 Sep 19 10:05 ibdata1 -rw-rw1 mysqlmysql 5242880 Sep 19 10:05 ib_logfile0 -rw-rw1 mysqlmysql 5242880 Sep 19 09:33 ib_logfile1 drwxr-x---2 mysqlmysql4096 Sep 19 09:30 mysql The error log shows.. 050919 14:44:36 mysqld started 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 14:44:36 [ERROR] bdb: PANIC: Permission denied 050919 14:44:36 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 14:44:36 [ERROR] bdb: fatal region error detected; run recovery 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 14:44:36 InnoDB: Started; log sequence number 0 43634 050919 14:44:36 [ERROR] Can't init databases 050919 14:44:36 [ERROR] Aborting 050919 14:44:36 InnoDB: Starting shutdown... 050919 14:44:38 InnoDB: Shutdown completed; log sequence number 0 43634 050919 14:44:38 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 14:44:38 mysqld ended Richard Johnson 212-589-6503 [EMAIL PROTECTED] -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:49 AM To: mysql@lists.mysql.com Subject: RE: Startup Error Well, as you can see in the first few lines, you have a Permission Denied problem. This means that your /data/ folder doesn't have the write permissions to it via the mysql user. Try running the permission scripts again, but this time use the full shell names. shell chown -R root /usr/local/mysql/. shell chown -R mysql /usr/local/mysql/data/. shell chgrp -R mysql /usr/local/mysql/. Then check to make sure that user has write permission to the folders: shell ls -l /usr/local/mysql/data It should say something similar to: shell ls -l /usr/local/mysql/data total 63868 drwx--2mysqlmysqlsizedatedirname -rw-rw1mysqlmysqlsizedatefilename- bin.000 . . -rw-rw1mysqlmysqlsizedatehostname.err J.R. _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:35 AM To: 'J.R. Bullington' Subject: RE: Startup Error Here are the contents of the file 050919 09:33:52 mysqld started 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:33:52 [ERROR] bdb: fatal region error detected; run recovery 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050919 9:33:52 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait
RE: Startup Error
Check your hostname.err logs located in the /data/ directory. This will tell you why you can't start the server. J.R. -Original Message- From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 10:38 AM To: 'mysql@lists.mysql.com' Subject: Startup Error Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid 050919 10:05:36 mysqld ended Here are the steps I followed to loading mysql onto my linux box.. shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf - shell ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql Richard Johnson 212-589-6503 [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Startup Error
Johnson, Richard (NY Int) wrote: Hi there Total Newbie here.Any idea why I am getting these error messages [EMAIL PROTECTED] mysql]# Starting mysqld daemon with databases from /usr/local/mysql/data STOPPING server from pid file /usr/local/mysql/data/ RJLINUX.rj.johnson.net.pid 050919 10:05:36 mysqld ended Here are the steps I followed to loading mysql onto my linux box.. shell groupadd mysql shell useradd -g mysql mysql shell cd /usr/local shell gunzip /PATH/TO/MYSQL-VERSION-OS.tar.gz | tar xvf - shell ln -s FULL-PATH-TO-MYSQL-VERSION-OS mysql shell cd mysql shell scripts/mysql_install_db --user=mysql shell chown -R root . shell chown -R mysql data shell chgrp -R mysql . shell bin/mysqld_safe --user=mysql Richard Johnson There should be an error log (hostname.err) in your data directory (/usr/local/mysql/data/). What does it say? Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Startup Error
Well, as you can see in the first few lines, you have a Permission Denied problem. This means that your /data/ folder doesn't have the write permissions to it via the mysql user. Try running the permission scripts again, but this time use the full shell names. shell chown -R root /usr/local/mysql/. shell chown -R mysql /usr/local/mysql/data/. shell chgrp -R mysql /usr/local/mysql/. Then check to make sure that user has write permission to the folders: shell ls -l /usr/local/mysql/data It should say something similar to: shell ls -l /usr/local/mysql/data total 63868 drwx--2mysqlmysqlsizedatedirname -rw-rw1mysqlmysqlsizedatefilename-bin.000 . . -rw-rw1mysqlmysqlsizedatehostname.err J.R. _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:35 AM To: 'J.R. Bullington' Subject: RE: Startup Error Here are the contents of the file 050919 09:33:52 mysqld started 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:33:52 [ERROR] bdb: fatal region error detected; run recovery 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050919 9:33:52 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050919 9:33:53 InnoDB: Started; log sequence number 0 0 050919 9:33:53 [ERROR] Can't init databases 050919 9:33:53 [ERROR] Aborting 050919 9:33:53 InnoDB: Starting shutdown... 050919 9:33:55 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:33:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:33:55 mysqld ended 050919 09:46:55 mysqld started 050919 9:46:55 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:46:56 [ERROR] bdb: fatal region error detected; run recovery 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 InnoDB: Started; log sequence number 0 43634 050919 9:46:56 [ERROR] Can't init databases 050919 9:46:56 [ERROR] Aborting 050919 9:46:56 InnoDB: Starting shutdown... 050919 9:46:58 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:46:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:46:58 mysqld ended 050919 09:56:10 mysqld started 050919 9:56:10 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:56:10 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:56:10 [ERROR] bdb: PANIC: Permission denied 050919 9:56:10 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:56:10 [ERROR] bdb: fatal region error detected; run recovery 050919 9:56:10 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:56:10 InnoDB: Started; log sequence number 0 43634 050919 9:56:10 [ERROR] Can't init databases 050919 9:56:10 [ERROR] Aborting 050919 9:56:10 InnoDB: Starting shutdown... 050919 9:56:12 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:56:12 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:56:12 mysqld ended 050919 10:05:33 mysqld started 050919 10:05:34 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 10:05:34 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 10:05:34 [ERROR] bdb: PANIC: Permission denied 050919 10:05:34 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 10:05:34 [ERROR] bdb: fatal region error detected; run recovery 050919 10:05:34 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 10:05:34 InnoDB: Started; log sequence number 0 43634 050919 10:05:34 [ERROR] Can't init databases 050919 10:05:34 [ERROR] Aborting 050919
RE: Startup Error
Still getting the following errors after running the chown's below... Here is what the ls -l result window shows... mysql]# ls -l /usr/local/mysql/data total 20536 -rw-rw1 mysqlmysql10485760 Sep 19 10:05 ibdata1 -rw-rw1 mysqlmysql 5242880 Sep 19 10:05 ib_logfile0 -rw-rw1 mysqlmysql 5242880 Sep 19 09:33 ib_logfile1 drwxr-x---2 mysqlmysql4096 Sep 19 09:30 mysql The error log shows.. 050919 14:44:36 mysqld started 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 14:44:36 [ERROR] bdb: PANIC: Permission denied 050919 14:44:36 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 14:44:36 [ERROR] bdb: fatal region error detected; run recovery 050919 14:44:36 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 14:44:36 InnoDB: Started; log sequence number 0 43634 050919 14:44:36 [ERROR] Can't init databases 050919 14:44:36 [ERROR] Aborting 050919 14:44:36 InnoDB: Starting shutdown... 050919 14:44:38 InnoDB: Shutdown completed; log sequence number 0 43634 050919 14:44:38 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 14:44:38 mysqld ended Richard Johnson 212-589-6503 [EMAIL PROTECTED] -Original Message- From: J.R. Bullington [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:49 AM To: mysql@lists.mysql.com Subject: RE: Startup Error Well, as you can see in the first few lines, you have a Permission Denied problem. This means that your /data/ folder doesn't have the write permissions to it via the mysql user. Try running the permission scripts again, but this time use the full shell names. shell chown -R root /usr/local/mysql/. shell chown -R mysql /usr/local/mysql/data/. shell chgrp -R mysql /usr/local/mysql/. Then check to make sure that user has write permission to the folders: shell ls -l /usr/local/mysql/data It should say something similar to: shell ls -l /usr/local/mysql/data total 63868 drwx--2mysqlmysqlsizedatedirname -rw-rw1mysqlmysqlsizedatefilename-bin.000 . . -rw-rw1mysqlmysqlsizedatehostname.err J.R. _ From: Johnson, Richard (NY Int) [mailto:[EMAIL PROTECTED] Sent: Monday, September 19, 2005 11:35 AM To: 'J.R. Bullington' Subject: RE: Startup Error Here are the contents of the file 050919 09:33:52 mysqld started 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: Permission denied 050919 9:33:52 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:33:52 [ERROR] bdb: fatal region error detected; run recovery 050919 9:33:52 [ERROR] bdb: /usr/local/mysql/data: Permission denied InnoDB: The first specified data file ./ibdata1 did not exist: InnoDB: a new database to be created! 050919 9:33:52 InnoDB: Setting file ./ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 InnoDB: Log file ./ib_logfile0 did not exist: new to be created InnoDB: Setting log file ./ib_logfile0 size to 5 MB InnoDB: Database physically writes the file full: wait... 050919 9:33:53 InnoDB: Log file ./ib_logfile1 did not exist: new to be created InnoDB: Setting log file ./ib_logfile1 size to 5 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 050919 9:33:53 InnoDB: Started; log sequence number 0 0 050919 9:33:53 [ERROR] Can't init databases 050919 9:33:53 [ERROR] Aborting 050919 9:33:53 InnoDB: Starting shutdown... 050919 9:33:55 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:33:55 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919 09:33:55 mysqld ended 050919 09:46:55 mysqld started 050919 9:46:55 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data/log.01: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: Permission denied 050919 9:46:56 [ERROR] bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 050919 9:46:56 [ERROR] bdb: fatal region error detected; run recovery 050919 9:46:56 [ERROR] bdb: /usr/local/mysql/data: Permission denied 050919 9:46:56 InnoDB: Started; log sequence number 0 43634 050919 9:46:56 [ERROR] Can't init databases 050919 9:46:56 [ERROR] Aborting 050919 9:46:56 InnoDB: Starting shutdown... 050919 9:46:58 InnoDB: Shutdown completed; log sequence number 0 43634 050919 9:46:58 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 050919
Re: Startup error on 4.0.15
Try commenting out the entry in the file /Library/MySQL/var/my.cnf If it does not exist, copy one of the files from /Library/MySQL/dist/my-small,medium,large.cnf renamed to the above location, or, to /etc/my.cnf Though, you may want to try uninstalling the package and reinstalling it again, just to be sure, as that'innodb_buffer_pool_size = 70M' entry seems valid. -- Adam Goldstein White Wolf Networks http://whitewlf.net On Jan 26, 2004, at 9:07 PM, Kev wrote: I just installed the server logistics package of mysql 4.0.15 and am getting the following error entry in the error log on attempting to start the server: 040126 20:43:45 mysqld started /Library/MySQL/libexec/mysqld: ERROR: unknown variable 'innodb_buffer_pool_size = 70M' 040126 20:43:45 mysqld ended The directory referenced in the error message only contains the mysqld file: Kevins-Computer:/Library/MySQL/libexec kevinbarry$ ls mysqld Kevins-Computer:/Library/MySQL/libexec kevinbarry$ where is the innodb file reference being picked up? What am I missing? There is not config file in the error directory, is that the problem? I upgraded from 3.0.x to 4.0.17 on Linux over the weekend and the install went easier than it has thus far on Mac OS X!!! go figure. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: re: startup error
Hello Maximo, Wednesday, October 16, 2002, 8:05:23 PM, you wrote: MM nscd?? nscd - A Name Service Caching Daemon It's a DNS-something for glibc.. MM I searched for that program and did not find it in linux. MM How would you go about fixing that problem? It will be fixed in 3.23.53a that will come ASAP MM Could you give us a more detailed explanation? Run nscd and then run MySQL server. 3.23.53 was built with another glibc that has no nss staticlly linked in. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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
re: startup error
Zack, Wednesday, October 16, 2002, 5:56:11 PM, you wrote: ZWK I followed the directions in the Mysql documentation, but I can't get it ZWK to fire up properly. I dl the binary distribution ZWK mysql-max-3.23.53-pc-linux-gnu-i686.tar.gz ZWK Mysql 3.23.53 ZWK Redhat 8.0 ZWK When I start it from safe_mysqld I get in the .err log ZWK Fatal error: 'Can't change to run as user 'mysql'; Please check that the ZWK user exists! ZWK The mysql user does exist :-) ZWK How do I fix this please? Run nscd and then run MySQL server. 3.23.53 was built with another glibc that has no nss staticlly linked in. -- For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.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