Summary: | [mysql overlay] Can't create/write to file '/var/tmp/portage/dev-db/percona-server-*/temp/MYh858qw' (Errcode: 13 - Permission denied) (when tempdir isn't set in my.cnf) | ||
---|---|---|---|
Product: | Gentoo Linux | Reporter: | Thomas Deutschmann (RETIRED) <whissi> |
Component: | Current packages | Assignee: | Gentoo Linux MySQL bugs team <mysql-bugs> |
Status: | RESOLVED FIXED | ||
Severity: | normal | ||
Priority: | Normal | ||
Version: | unspecified | ||
Hardware: | All | ||
OS: | Linux | ||
Whiteboard: | |||
Package list: | Runtime testing required: | --- | |
Attachments: |
`emerge --debug --config percona-server` output
/root/.my.cnf /etc/mysql/my.cnf |
Created attachment 377232 [details]
/root/.my.cnf
Created attachment 377234 [details]
/etc/mysql/my.cnf
*** Bug 510694 has been marked as a duplicate of this bug. *** Changes pushed to the overlay. |
Created attachment 377230 [details] `emerge --debug --config percona-server` output Hi, 1. Install dev-db/percona-server from mysql-overlay 2. Create your "/etc/mysql/my.cnf" (see the attachment) 3. Create "/root/.my.cnf" (see the attachment) 4. This is a fresh installation, so now it is time to initialize your DATADIR: # emerge --config percona-server Configuring pkg... * Creating the mysql database and setting proper * permissions on it ... * Command: '/usr/share/mysql/scripts/mysql_install_db' '--basedir=/usr' --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose-skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql '- -datadir=///srv/mysql/data/' * Starting mysqld ... * Command //usr/sbin/mysqld --log-warnings=0 --loose-skip-grant-tables --loose-skip-host-cache --loose-skip-name-resolve --loose-skip-networking --loose-skip-slave-start --loose- skip-ssl --loose-skip-log-bin --loose-skip-relay-log --loose-skip-slow-query-log --loose-skip-external-locking --loose-skip-log-slave-updates --user=mysql --user=mysql - -log-warnings=0 --basedir=//usr --datadir=///srv/mysql/data/ --max_allowed_packet=8M --net_buffer_length=16K --defa ult-storage-engine=MyISAM --socket=//var/run/mysqld/mysqld5831.sock --pid-file=//var/run/mysqld/mysqld6106.pid .2014-05-19 10:45:35 0 [Warning] options --log-slow-admin-statements, --log-queries-not-using-indexes and --log-slow-slave-statements have no effect if --slow-query-log is not set 2014-05-19 10:45:35 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). [ ok ] * Setting root password ... [ ok ] * Loading "zoneinfo", this step may require a few seconds ... ... Warning: Using a password on the command line interface can be insecure. ERROR 1 (HY000) at line 186129: Can't create/write to file '/var/tmp/portage/dev-db/percona-server-5.6.17.65.0/temp/MYeKBN1U' (Errcode: 13 - Permission denied) [ ok ] * Failed to load zoneinfo! * Stopping the server ... * Done You can workaround this problem when you do 1. mkdir /tmp/mysql 2. chown mysql:mysql /tmp/mysql 3. Add "tempdir=/tmp/mysql" to you /etc/mysql/my.cnf I don't think this a problem related to a custom my.cnf because the default my.cnf also doesn't set tempdir.