-----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]
