After some advice on this post
Zitat
I decided to start from scratch, by reflashing my working image.
I did and update on all packages and then installed openmediavault-mysql.
Just as a quick background:
My previous attempts only started mysql seemingly at random. My biggest issue, was once I save and apply settings from the web interface, it failed to start. I've checked the my.cnf file and changes did seem to take effect, as the new values were in the file, but it won't start. Sometimes it start from command line and a reboot.
So tonight I've started from a fresh pre-sql backed-up image. And when installing, I noticed the following warnings and errors:
This is not the complete output, but just the lines around the warning or error. I copied warnings first, then errors.
ZitatAlles anzeigenWARNING: The following packages cannot be authenticated!
libaio1 libdbi-perl libmysqlclient16 libdbd-mysql-perl mysql-client-5.5
mysql-server-core-5.5 mysql-server-5.5 php5-pgsql php5-sqlite php5-mysqlnd
dbconfig-common mysql-server php5 mywebsql openmediavault-mysql
Authentication warning overridden.
Stopping MySQL database server: mysqld.
insserv: warning: current start runlevel(s) (empty) of script `mysql' overrides LSB defaults (2 3 4 5).
insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script `mysql' overrides LSB defaults (0 1 6).
Processing triggers for php5-fpm ...
Processing triggers for man-db ...
Processing triggers for php5-fpm ...
>>> *************** Error ***************
Bad Gateway
<<< *************************************
Restarting PHP5 FastCGI Process Manager: php5-fpm.
Processing triggers for openmediavault ...
Restarting engine daemon ...
insserv: warning: current start runlevel(s) (empty) of script `mysql' overrides LSB defaults (2 3 4 5).
insserv: warning: current stop runlevel(s) (0 1 2 3 4 5 6) of script `mysql' overrides LSB defaults (0 1 6).
Processing triggers for php5-fpm ...
>>> *************** Error ***************
Bad Gateway
<<< *************************************
Restarting PHP5 FastCGI Process Manager: php5-fpm.
Processing triggers for openmediavault ...
As you can see the same error repeat. My guess is that it try and start mysql at that stage.
Then in the web gui I enable MySQL, and save and apply. A pop-up showing "Bad gateway" appear.
Here is the full output of that.
Zitat
ZitatAlles anzeigen<html>
<head><title>502 Bad Gateway</title></head>
<body bgcolor="white">
<center><h1>502 Bad Gateway</h1></center>
<hr><center>nginx</center>
</body>
</html>
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
<!-- a padding to disable MSIE and Chrome friendly error page -->
I've left all settings at default.
I can attach the full output of syslog and the install log if it will help.