List:General Discussion« Previous MessageNext Message »
From:Richard (NY Int) Johnson Date:September 19 2005 6:56pm
Subject:RE: Startup Error
View as plain text  
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-rw----    1 mysql    mysql    10485760 Sep 19
10:05 ibdata1
-rw-rw----    1 mysql    mysql     5242880 Sep 19
10:05 ib_logfile0
-rw-rw----    1 mysql    mysql     5242880 Sep 19
09:33 ib_logfile1
drwxr-x---    2 mysql    mysql        4096 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.0000000001: 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
rjohnson@stripped

-----Original Message-----
From: J.R. Bullington [mailto:bullijr@stripped] 
Sent: Monday, September 19, 2005 11:49 AM
To: mysql@stripped
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------    2    mysql    mysql    <size>    <date>    <dirname>
-rw-rw----    1    mysql    mysql    <size>    <date>   
<filename>-bin.000
.
.
-rw-rw----    1    mysql    mysql    <size>    <date>    <hostname>.err
 
 
 
J.R.
 

  _____  

From: Johnson, Richard (NY Int) [mailto:rjohnson@stripped] 
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.0000000001:
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.0000000001:
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.0000000001:
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.0000000001:
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 10:05:34  InnoDB: Starting shutdown... 
050919 10:05:36  InnoDB: Shutdown completed; log sequence number 0 43634 
050919 10:05:36 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete 

050919 10:05:36  mysqld ended 


Richard Johnson 
212-589-6503 
rjohnson@stripped 

-----Original Message----- 
From: J.R. Bullington [mailto:bullijr@stripped] 
Sent: Monday, September 19, 2005 10:52 AM 
To: mysql@stripped 
Subject: 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:rjohnson@stripped] 
Sent: Monday, September 19, 2005 10:38 AM 
To: 'mysql@stripped' 
Subject: Startup Error 

Hi there.... 

Total Newbie here.....Any idea why I am getting these error messages???? 

[root@RJLINUX 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 

rjohnson@stripped 



-- 
MySQL General Mailing List 
For list archives: http://lists.mysql.com/mysql 
To unsubscribe:
http://lists.mysql.com/mysql?unsub=1 


Thread
Startup ErrorNY Int)19 Sep
RE: Startup ErrorJ.R. Bullington19 Sep
Re: Startup ErrorMichael Stassen19 Sep
RE: Startup ErrorJ.R. Bullington19 Sep
RE: Startup ErrorNY Int)19 Sep
RE: Startup ErrorAndy Eastham20 Sep