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: '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-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: 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------    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: mysql@lists.mysql.com 
> 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: '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] 

 

Reply via email to