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
remove!
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.