NAS540: Update of MySQL?

JockeSve · February 2019

Is there a way to update MySQL version from current (5.1.73) to more up to date(like 5.7) or even to MariaDB 10.2 (or newer)?

#NAS_Feb_2019

bigdyl69 · July 2019

Hi, I've been looking for something similar as I want to convert the MySQL tables to InnoDB which isn't possible with hte old version of MySQL (5.1.73 and InnoDB support came in at v5.5+).

Anyone know if this can be done?

JockeSve · July 2019

As Zyxel seems to have abandoned all support of 540 entirely the chance is minimal that the update is coming, like ever.
I don't have any idea of on what level the 542 runs, but if that's newer: maybe (hopefully!) someone with skills could port that package to 540 as well...

Mabenan · September 2019

Ok after days of work i finally get MySQL in version 5.7 running. Here are the steps i really don't know any more what i have to install but the logs will tell you.

!!!!!!!!!!!!!!!!! ATTENTION !!!!!!!!!!!!!
this will install a second mysql in the /opt folder

First you need to install Entware how To you find here https://github.com/Entware/Entware/wiki/Install-on-Zyxel-NAS542
Add /opt/bin and /opt/sbin to the path
Then you need to install CMake from Source https://github.com/Entware/Entware-ng/issues/672 ATTENTION: you have to adjust the prefix to /opt
Then you need the git clone of the mysql-server https://github.com/mysql/mysql-server/tree/5.7
Then you need to create a folder "bld" in the clone and cd in it
Then you need to generate the cmake files this you do the following
cmake .. -DDOWNLOAD_BOOST=1 -DWITH_BOOST=1 -DCMAKE_INSTALL_PREFIX=/opt
After it is succesfully finished you have to enter the following:
cmake --build . --target install --config release

So now the tricky point i mentioned in the intro the creation of CMake and MySQL will fail you have to install thousand of libs the console output will tell you what is missing. First try to install the libs over entware if this fails install the search for the sources in the internet and install it with make or cmake. After you installed a lib remove the "bld" folder and start over at point 6 otherwise it gets bugy.

I recommend to do that only if you a fluent in linux commands and cmake building.

PS: I takes a lot of time for the cmake commands so i recommend to setup screen over entware and to run the commands in an screen session that is detachable

JockeSve · September 2019

Well, thanks but my skills doesn't pass following requirement:

I recommend to do that only if you a fluent in linux commands and cmake building.

I've almost giving up the Zyxel MySQL feature due to poor/non-existent updates and running it with RPi4 together with PiHole.

NAS540: Update of MySQL?

All Replies

Categories

Consumer Product Help Center