Mariadb conflict with nginx
On a totaly fresh install on alpine 3.8.
Just a have a bug just after this 3 lignes but it’s works after nginx
I really don’t understand why.
<code class="c"> alpine:~# uname -a Linux alpine 4.14.52-0-virt #1-Alpine SMP Tue Jun 26 07:21:56 UTC 2018 x86_64 Linux alpine:~# cat /etc/alpine-release 3.8.0 *alpine:~# apk add mariadb mariadb-client nginx* (1/10) Installing mariadb-common (10.2.15-r0) (2/10) Installing libaio (0.3.111-r0) (3/10) Installing pcre (8.42-r0) (4/10) Installing libgcc (6.4.0-r8) (5/10) Installing libstdc++ (6.4.0-r8) (6/10) Installing libxml2 (2.9.8-r0) (7/10) Installing mariadb (10.2.15-r0) Executing mariadb-10.2.15-r0.pre-install (8/10) Installing mariadb-openrc (10.2.15-r0) (9/10) Installing mariadb-client (10.2.15-r0) (10/10) Installing nginx (1.14.0-r0) Executing nginx-1.14.0-r0.pre-install Executing busybox-1.28.4-r1.trigger OK: 250 MiB in 60 packages *alpine:~# /etc/init.d/mariadb setup* * Creating a new MySQL database ... 2018-08-15 8:20:32 140300309826440 [ERROR] mysqld: Can't create/write to file '/var/tmp/ibXXXXXX' (Errcode: 13 "Permission denied") 2018-08-15 8:20:32 140300309826440 [ERROR] InnoDB: Unable to create temporary file; errno: 13 2018-08-15 8:20:32 140300309826440 [ERROR] mysqld: Can't create/write to file '/var/tmp/ibXXXXXX' (Errcode: 13 "Permission denied") 2018-08-15 8:20:32 140300309826440 [ERROR] InnoDB: Unable to create temporary file; errno: 13 2018-08-15 8:20:32 140300309826440 [ERROR] InnoDB: Plugin initialization aborted with error Generic error 2018-08-15 8:20:32 140300309826440 [ERROR] Plugin 'InnoDB' init function returned error. 2018-08-15 8:20:32 140300309826440 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 2018-08-15 8:20:33 140300309826440 [ERROR] Unknown/unsupported storage engine: InnoDB 2018-08-15 8:20:33 140300309826440 [ERROR] Aborting Installation of system tables failed! Examine the logs in /var/lib/mysql for more information. The problem could be conflicting information in an external my.cnf files. You can ignore these by doing: shell> /usr/bin/mysql_install_db --defaults-file=~/.my.cnf You can also try to start the mysqld daemon with: shell> /usr/bin/mysqld --skip-grant-tables --general-log & and use the command line tool /usr/bin/mysql to connect to the mysql database and look at the grant tables: shell> /usr/bin/mysql -u root mysql mysql> show tables; Try 'mysqld --help' if you have problems with paths. Using --general-log gives you a log in /var/lib/mysql that may be helpful. The latest information about mysql_install_db is available at https://mariadb.com/kb/en/installing-system-tables-mysql_install_db You can find the latest source at https://downloads.mariadb.org and the maria-discuss email list at https://launchpad.net/~maria-discuss Please check all of the above before submitting a bug report at http://mariadb.org/jira [ !! ] *alpine:~# apk del nginx* (1/1) Purging nginx (1.14.0-r0) Executing busybox-1.28.4-r1.trigger OK: 249 MiB in 59 packages *alpine:~# /etc/init.d/mariadb setup* * Creating a new MySQL database ... 2018-08-15 8:23:43 140432384334568 [Warning] Failed to load slave replication state from table mysql.gtid_slave_pos: 1146: Table 'mysql.gtid_slave_pos' doesn't exist PLEASE REMEMBER TO SET A PASSWORD FOR THE MariaDB root USER ! To do so, start the server, then issue the following commands: '/usr/bin/mysqladmin' -u root password 'new-password' '/usr/bin/mysqladmin' -u root -h alpine password 'new-password' Alternatively you can run: '/usr/bin/mysql_secure_installation' which will also give you the option of removing the test databases and anonymous user created by default. This is strongly recommended for production servers. See the MariaDB Knowledgebase at http://mariadb.com/kb or the MySQL manual for more instructions. Please report any problems at http://mariadb.org/jira The latest information about MariaDB is available at http://mariadb.org/. You can find additional information about the MySQL part at: http://dev.mysql.com Consider joining MariaDB's strong and vibrant community: https://mariadb.org/get-involved/ </code>
(from redmine: issue id 9246, created on 2018-08-15)
Revert "main/nginx: move /var/lib/nginx/tmp to /var/tmp/nginx" FHS-3.0 says that /var/tmp should survive reboots, but for it is common practice to ignore FHS for security reasons and wipe dirs that are world writable. There is no good reason to store nginx data under a world writable directory, so move it back to /var/lib/nginx/tmp. Other distros does something similar. fixes #9246 fixes #10258 ref #9364 This reverts commit d6d624a149ca62af8679baf9cc99ce1354c190f0.