MySQL on RaspberriPi B+ fail to start

bergie5737 · 7. Juli 2016

After some advice on this post

Zitat

http://forums.openmediavault.o…?postID=118011#post118011

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.

Zitat

WARNING: 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 ...

Alles anzeigen

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

Zitat

<html>
<head><title>502 Bad Gateway</title></head>
<body bgcolor="white">
<center><h1>502 Bad Gateway</h1></center>
<hr><center>nginx</center>
</body>
</html>







Alles anzeigen

I've left all settings at default.
I can attach the full output of syslog and the install log if it will help.

ryecoaaron · 7. Juli 2016

If you update *all* of the packages then the comment on the readme on sourceforge applies:

need to update php5-pam manually to work on RPi1

I would re-write the image to the card and when you update, don't select php5-pam to update.

bergie5737 · 7. Juli 2016

I never see the php5-pam update in the gui . From another post I prevent updating php5-pam with this command.

Zitat

apt-mark hold php5-pam

I also ran some check, I can't recall the post or the command, that confirmed the package was as is, but the post was a bit dated, so I may be wrong.

If my memory serve me right you said in some post I should do the below to manually update.

Code

wget http://omv-extras.org/debian/pool/main/p/php5-pam/php5-pam_1.0.3-2_armhf.deb
dpkg -i php5-pam_1.0.3-2_armhf.deb

ryecoaaron · 7. Juli 2016

Yep, that is it. I would update that comment to not use an RPi1 anymore though

bergie5737 · 9. Juli 2016

Ok, so there is no help for me then?

I see my miniDLNA has now stopped as well.... Don't know if its related.

ryecoaaron · 9. Juli 2016

I only have so much time. So, I have to pick and choose what I support. Supporting the super slow RPi1 is not on the top of my list. I don't think it too much to ask to spend $35 on an RPi3. I know I have spent much more than that on just SD cards let alone RPis.

If minidlna stopped, it sounds like your sd card is starting to fail. There is no way to save a failing SD card. If you don't want to buy a new RPi3, at least buy a new SD card.

bergie5737 · 11. Juli 2016

LOL!
I have two RPI 1's lying around. They are still great little machines. I personally would rather buy off the shelve NAS in stead of another RPI. But then I probably won't get OMV working and have 2TB hard drive collecting dust. I live in South Africa, $35 is too much as our exchange rate has effectively made the Raspi 3 times more expensive than when I first bought mine.

The SD I use cost about as much as I initially paid for my RPi, and it's quite new. Anyway, I think the miniDLNA issue was related to mySQL. After removing both and re-installing miniDLNA, it worked. I add mySQL back again, and gone is miniDLNA.

Its for you to decide if you want to check a bug. I am steering clear of mySQL now.

Once again thank you so much for a great system. I really enjoy OMV enough to stick with it. I will try out new things, and revert if I break it. It's after all just a "WinDiskImager" away from fixing!

Jetzt mitmachen!