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
lrwxrwxrwx 1 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: '[email protected]'
> 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-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
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: J.R. Bullington [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 19, 2005 11:49 AM
> To: [email protected]
> 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:[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.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
> [EMAIL PROTECTED]
>
> -----Original Message-----
> From: J.R. Bullington [mailto:[EMAIL PROTECTED]
> Sent: Monday, September 19, 2005 10:52 AM
> To: [email protected]
> 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:[EMAIL PROTECTED]
> Sent: Monday, September 19, 2005 10:38 AM
> To: '[email protected]'
> 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]
