[MDEV-23735] MariaDB no longer works with QNAP NAS unit Created: 2020-09-14 Updated: 2020-09-16 Resolved: 2020-09-15 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | Configuration |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | Larry Dietz | Assignee: | Sergei Golubchik |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Environment: |
QNAP NAS unit |
||
| Description |
|
I appologize if I selected any incorrect options above. MariaDB recently stopped working on my QNAP TS459 Pro+ I reached out to the QNAP support team, and received the following response... ===QNAP Response=== MariaDB is a 3rd party apps we do not support, but I will do the best I can. MariaDB no longer works on our newer firmware because MariaDB stops updating it. To continue using MariaDB, you will have to downgrade the firmware to older version which supports MariaDB. The firmware could be downloaded at https://www.qnap.com/en/download?model=ts-459%20pro%2B&category=firmware You may also contact MariaDB for further support: https://mariadb.org/ I am unclear what updates they are expecting, but wanted to make you aware of the issue, so someone could look into it, as I am sure that a lot of QNAP users are currently facing the same problem. Any help you can provide would be greatly appreciated. For the time being, I am downgrading my firmware on the NAS, but I am hoping this is a short term fix until whatever issue has been resolved. Thank you, |
| Comments |
| Comment by Daniel Black [ 2020-09-15 ] |
|
As someone who recently discovered MySQL-5.1 on my WD Arm based NAS. I thank you for a story of MariaDB actually being on a NAS (or at least used to be). Can I get some more information as to how MariaDB got there? Where was it installed from? MariaDB has ended 5.5 releases and there is 1 more 10.1 release to go, however all new releases are still coming every 3 months or so. What does 'stopped working' mean? Is it failing to start? What exact error is being encounter? Which MariaDB are you after? Which Intel Atom model is it (/proc/cpuinfo)? Is there a qemu command line that can execute the QNAP TS459 Pro+ CPU and firmware image? |
| Comment by Larry Dietz [ 2020-09-15 ] |
|
The NAS is a QNAP TS-459 Pro+ MariaDB is installed as part of the firmware, with no way that I have found to be able to update it. The version that is used is 5.5.57. mysqli_real_connect(): (HY000/2002): No such file or directory I use Joomla for our intranet here, and trying to bring up out intranet results in the following... Error displaying the error page: Application Instantiation Error: Could not connect to MySQL. The processor in the TS-459 Pro+ is a 1.8Ghz Dual Core Atom CPU Not entirely sure what you are asking on that final line. If you are asking if I can manually update the firmware, then yes, but it is via the UI not command line. I just downgraded the firmware to an older version, the one they told me had the best chance of working, and am waiting for the unit to finish rebooting to see if that worked, I just hate rolling back the firmware due to loosing the security fixes that the new firmware versions add. I have no idea why they do not update their firmware to use a more recent version of MariaDB. I have asked them, but while answering most of my questions, they have ignored that one If I could figure out a way to manually install a newer version, without conflicting with the non functional version they have installed, I would go that route, but I don't know how to install software on this thing, other than through their app center, and it doesn't contain MariaDB, MySql, or any other flavor of SQL unfortunately. I appreciate your help, but my guess is that until they decide to fix their reliance on a no longer supported version of the software, I am just going to have to be stuck. Thanks, |
| Comment by Sergei Golubchik [ 2020-09-15 ] |
|
The first 5.5 release (5.5.20) was in Feb 2012, the last (5.5.68) — in May 2020. 5.5.57 was release in Jul 2017. Latest MariaDB major release is 10.5, supported till 2025 — https://mariadb.org/about/#maintenance-policy QNAP has to upgade MariaDB at least once in five years otherwise, indeed, the version will go out of support according to the published schedule. It seems that you can install MariaDB in a docker container, at least google found some suggestions to do that. And you can tell QNAP support that Synology, apparently, offers packages for MariaDB 10.3 |
| Comment by Larry Dietz [ 2020-09-15 ] |
|
I appreciate your response, and it makes perfect sense. I will reach out to QNAP again, but I doubt it will be of much help Again, thank you for the response!! -Larry |
| Comment by Daniel Black [ 2020-09-15 ] |
|
For QNAP, or whoever wants to build a QNAP application: https://wiki.qnap.com/wiki/QPKG_Development_Guidelines seams reasonably easy to follow. There will be a little manual build options with installing MariaDB into arch dependent location and non-architecture locations but not too much. These will be cmake -DINSTALL_Xxxx=location options (per https://github.com/MariaDB/server/blob/10.5/cmake/install_layout.cmake#L41-L61). For getting a built binary of the compatible architecture use: Try to stick to native compilation. Cross compilation is possible but it can be a little fiddly. MariaDB-10.5 has some performance improvements on Arm and work is continuing. On versions, good news - 5.5 to 10.5 upgrades are possible: If you need some advice - ask on https://mariadb.zulipchat.com , we may not have a QNAP on hand, however I'm sure we can work out some problems or work out the questions to ask of QNAP support/community developers. |
| Comment by Larry Dietz [ 2020-09-16 ] |
|
Thank you. I have passed this information on to QNAP, but I doubt they will do anything. They claim that they are not doing updates to my unit due to hardware limitations, but I think that they just don't want to spend their time on their older products I really appreciate all of your help! |