-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Hello,
I also tried the 5.0.1 MAX binaries looking for a solution to my previously posted problem of permissions (see at the bottom of the message for the previous post).
According to the hostname.err file:
040810 13:31:44 mysqld started 040810 13:31:44 bdb: /usr/local/mysql5/data: Permission denied 040810 13:31:44 bdb: /usr/local/mysql5/data/log.0000000001: Permission denied 040810 13:31:44 bdb: PANIC: Permission denied 040810 13:31:44 bdb: PANIC: DB_RUNRECOVERY: Fatal error, run database recovery 040810 13:31:44 bdb: fatal region error detected; run recovery 040810 13:31:44 bdb: /usr/local/mysql5/data: Permission denied 040810 13:31:44 InnoDB: Started; log sequence number 0 43634 040810 13:31:44 Can't init databases 040810 13:31:44 Aborting
040810 13:31:44 InnoDB: Starting shutdown... 040810 13:31:46 InnoDB: Shutdown completed; log sequence number 0 43634 040810 13:31:46 /usr/local/mysql5/bin/mysqld: Shutdown complete
040810 13:31:46 mysqld ended
A complete archived plaintext strace logfile can be found here: http://www.lwo-lab.net/log.mysql-list.01.gz It was generated using: # strace -v -s 512 -o log -f -v -t ./mysqld --user=mysql
Before suggesting any chmod/chown, please take a look at this:
tearspath www # ls -l -h /usr/local/mysql5/data/
total 19M -rw-rw---- 1 mysql mysql 4.0M Aug 10 14:25 ib_logfile0 -rw-rw---- 1 mysql mysql 4.0M Aug 9 14:36 ib_logfile1 -rw-rw---- 1 mysql mysql 10M Aug 10 14:25 ibdata1 drwxr-x--- 2 mysql mysql 4.0K Aug 9 14:27 mysql -rw-rw---- 1 mysql root 6.1K Aug 10 13:31 tearspath.err drwxr-x--- 2 mysql mysql 4.0K Jul 27 20:53 test
I'd like to add that mysqld is properly running as mysql:mysql according to the strace log:
12299 14:25:07 setgid32(506) = 0 12299 14:25:07 setuid32(1006) = 0
(506 and 1006 are the respective GID and UID for mysql and mysql) Any help will be really appreciated, I'm on this for a month now. Thanks in advance.
Elie `woe` BLETON
Elie `woe` BLETON wrote: | Hello, | | I'd like to ask for some help on a problem which have prevented my mysql | server to run since I updated it from 4.0 to 4.1 | Anyway, even if in the idea it's an update, in the facts it's a fresh | install, from sources. | Sources were configure'd with "./configure --prefix=/usr/local/mysql". | | After doing everything I could find on google, manual, mailing lists and | stuff, I still have basicly the same problems : | | (a) Running "mysql_install_db --user=mysql > /dev/null" prints a lot of | errors, most of them are Errcode: 13 (Permission denied), and resulting | "Table 'xxx.yyy' doesn't exist" messages. See Annex A for detailed output. | | (b) Running "libexec/mysqld --console --user=mysql" prints : | InnoDB: Operating system error number 13 in a file operation. | InnoDB: The error means mysqld does not have the access rights to | InnoDB: the directory. | InnoDB: File name /usr/local/mysql/var/ibdata1 | InnoDB: File operation call: 'create'. | InnoDB: Cannot continue operation. | | Running both of these programs as root works fine, but I don't really | want mysql to run as root, even if it's just for testing purposes. | | There are some points which seems really strange to me. First point is | that mysql_install_db is able to create "mysql" and "test" directories | in var without problem. | Nothing changes if I "chown -R mysql:mysql /usr/local/mysql/var" | Nothing changes if I "chown -R mysql:mysql /usr/local/mysql" | Nothing changes if I "chmod -R 777 /usr/local/mysql" | Nothing changes if these these elements are made altogether. | | The other strange point is that if the var directory isn't owned by | mysql user, InnoDB complaints about not beeing able to create | innodb.status.xxxx in var. Once var is owned by mysql, it can create the | file without problem. | I can't understand why it cannot create ibdata1 if it can create the | other one. | | I've also tried to install_db as root, then run mysqld as root for one | time in order to get inno files created properly. Switching back to | mysqld --user=mysql isn't possible anyway. | | I'm open to any suggestion or help, and available to provide any further | information as needed. Thanks in advance for your time. | | Elie `woe` BLETON | | #### APPENDIX A #### | Output of "/usr/local/mysql/bin/mysql_install_db --user=mysql" | | ERROR: 1 Can't create/write to file '/usr/local/mysql/var/mysql/db.MYI' | (Errcode: 13) | ERROR: 1146 Table 'mysql.db' doesn't exist | ERROR: 1146 Table 'mysql.db' doesn't exist | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/host.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/user.MYI' (Errcode: 13) | ERROR: 1146 Table 'mysql.user' doesn't exist | ERROR: 1146 Table 'mysql.user' doesn't exist | ERROR: 1146 Table 'mysql.user' doesn't exist | ERROR: 1146 Table 'mysql.user' doesn't exist | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/func.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/tables_priv.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/columns_priv.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/help_topic.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/help_category.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/help_relation.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/help_keyword.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/time_zone_name.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/time_zone.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/time_zone_transition.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/time_zone_transition_type.MYI' (Errcode: 13) | ERROR: 1 Can't create/write to file | '/usr/local/mysql/var/mysql/time_zone_leap_second.MYI' (Errcode: 13) | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_category' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_category' doesn't exist | ERROR: 1146 Table 'mysql.help_category' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_topic' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_keyword' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist | ERROR: 1146 Table 'mysql.help_relation' doesn't exist
-----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
iD8DBQFBGOXOPGZshgdzBbgRAvI8AJ9gdwH3aQLf3RZSptKKabEQltoV/QCfXESi /yZrrlMaxDQTWs8RwLkZ8Co= =NAzI -----END PGP SIGNATURE-----
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]