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
