Install problem: configure --prefix not working
I am trying to install mysql in a non-standard directory - specifically /app/mysql Subsequently, I ran the following configure command: ./configure --prefix=/app/mysql --with-plugins=innobase,myisam There were no problems with the compile, but mysql failed to start. Furthermore, the following output was produced in the nohup.out file -bash-3.2$ cat nohup.out 090211 09:40:35 mysqld_safe Logging to '/var/log/mysqld.log'. mkdir: cannot create directory `/var/lib/mysql': Permission denied chown: cannot access `/var/lib/mysql': No such file or directory chmod: cannot access `/var/lib/mysql': No such file or directory 090211 09:40:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied 090211 09:40:35 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied For some reason, the mysql install is looking to /var even though I specificied /app/mysql in the compile. How do I fix this? Thanks! Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Install problem: log file issue
In the process of installing MySQL 5.1.31, I receive the following error when I attempt to start mysqld_safe: 090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'. 090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from /app/mysql/data /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission denied 090212 10:57:40 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission denied My my.cnf file reads: # The MySQL server [mysqld] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M datadir = /app/mysql/data #data_file_path = /app/mysql/data general_log = 1 general_log_file = /app/mysql/log/ socket = /app/mysql/var/mysql.sock log-error = /app/mysql/log/error.log I thought the general_log_file variable would define the location of the log file, yet mysqld is trying to write the log file to a different directory. Does anyone have any suggestions on how to fix this? Thanks! Colin -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install problem: log file issue
That is intentional. I want to write the log to a non-standard location. Thanks! C fire9 wrote: > Colin, > hi, so I think your mysql account doesn't have access /var/log/ > directory Permission. > > > Yours, > fire9 > ÔÚ 2009-2-13£¬ÉÏÎç1:02£¬ csego...@gmail.com > <mailto:csego...@gmail.com> дµÀ£º > >> In the process of installing MySQL 5.1.31, I receive the following error >> when I attempt to start mysqld_safe: >> >> 090212 10:57:40 mysqld_safe Logging to '/var/log/mysqld.log'. >> 090212 10:57:40 mysqld_safe Starting mysqld daemon with databases from >> /app/mysql/data >> /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission >> denied >> /app/mysql/bin/mysqld_safe: line 133: /var/log/mysqld.log: Permission >> denied >> 090212 10:57:40 mysqld_safe mysqld from pid file >> /var/run/mysqld/mysqld.pid ended >> /app/mysql/bin/mysqld_safe: line 96: /var/log/mysqld.log: Permission >> denied >> >> >> My my.cnf file reads: >> >> # The MySQL server >> [mysqld] >> port= 3306 >> socket = /tmp/mysql.sock >> skip-locking >> key_buffer = 16M >> max_allowed_packet = 1M >> table_cache = 64 >> sort_buffer_size = 512K >> net_buffer_length = 8K >> read_buffer_size = 256K >> read_rnd_buffer_size = 512K >> myisam_sort_buffer_size = 8M >> datadir = /app/mysql/data >> #data_file_path = /app/mysql/data >> general_log = 1 >> general_log_file = /app/mysql/log/ >> socket = /app/mysql/var/mysql.sock >> log-error = /app/mysql/log/error.log >> >> I thought the general_log_file variable would define the location of the >> log file, yet mysqld is trying to write the log file to a different >> directory. Does anyone have any suggestions on how to fix this? >> >> Thanks! >> Colin >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: >>http://lists.mysql.com/mysql?unsub=fire9di...@gmail.com >> > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install problem: log file issue
Andy, Thanks for the suggestion. my_print_defaults mysqld indicates that it is reading my my.cnf. Furthermore, I have tried both the log and log-output variables in my.cnf with no success. Any other ideas? Thanks! C Andy Smith wrote: > It could be that your my.cnf isn't being read (permissions or in the > wrong directory), or that you have multiple my.cnf files. > > Quoting "csego...@gmail.com" : > >> That is intentional. I want to write the log to a non-standard >> location. >> > > > This message was sent using IMP, the Internet Messaging Program. > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Re: Install problem: log file issue
Andy, Michael, and Walter - thank you! Adding a [mysqld_safe] group to my.cnf gets me further but the start still fails. The good thing is that the failure is no longer due to the inability to write the log file. The [mysqld_safe] section of my.cnf reads: [mysqld_safe] port= 3306 socket = /tmp/mysql.sock skip-locking key_buffer = 16M max_allowed_packet = 1M table_cache = 64 sort_buffer_size = 512K net_buffer_length = 8K read_buffer_size = 256K read_rnd_buffer_size = 512K myisam_sort_buffer_size = 8M datadir = /app/mysql/data #data_file_path = /app/mysql/data #log = /app/mysql/log/mysqld.log log-bin = /app/mysql/log/mysql-bin.log log-output = FILE general_log = 1 general_log_file = /app/mysql/log/msyql_general.log socket = /app/mysql/var/mysql.sock log-error = /app/mysql/log/error.log Luckily, I now have an error log which reads: 090212 18:24:04 mysqld_safe Starting mysqld daemon with databases from /app/mysql/data InnoDB: Log scan progressed past the checkpoint lsn 0 39548 090212 18:24:04 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... InnoDB: Doing recovery: scanned up to log sequence number 0 46409 090212 18:24:04 InnoDB: Starting an apply batch of log records to the database... InnoDB: Progress in percents: 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 InnoDB: Apply batch completed 090212 18:24:04 InnoDB: Started; log sequence number 0 46409 090212 18:24:04 [ERROR] /app/mysql/libexec/mysqld: Can't create/write to file '/var/run/mysqld/mysqld.pid' (Errcode: 2) 090212 18:24:04 [ERROR] Can't start server: can't create PID file: No such file or directory 090212 18:24:04 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended Now I need to figure out how to point PID file creation the appropriate directory. C Walter Heck wrote: > I haven't looked into it in detail an don't have time right nw, but it > is also hardcoded in mysqld_safe. I have seen a case where it had to > be changed there to make it work. try that and please report back :) > > Walter > > OlinData: Professional services for MySQL > Support * Consulting * Administration > http://www.olindata.com > > > > On Thu, Feb 12, 2009 at 6:39 PM, csego...@gmail.com > wrote: > >> Andy, >> >> Thanks for the suggestion. my_print_defaults mysqld indicates that it >> is reading my my.cnf. Furthermore, I have tried both the log and >> log-output variables in my.cnf with no success. Any other ideas? >> >> Thanks! >> C >> >> >> >> >> Andy Smith wrote: >> >>> It could be that your my.cnf isn't being read (permissions or in the >>> wrong directory), or that you have multiple my.cnf files. >>> >>> Quoting "csego...@gmail.com" : >>> >>> >>>> That is intentional. I want to write the log to a non-standard >>>> location. >>>> >>>> >>> >>> This message was sent using IMP, the Internet Messaging Program. >>> >>> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe:http://lists.mysql.com/mysql?unsub=li...@olindata.com >> >> >> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
