[ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

This is the best place for community developers to publish their genius work. Your Apps enrich the QNAP Turbo NAS.
mr_hyde
Easy as a breeze
Posts: 409
Joined: Sun Sep 02, 2007 3:51 pm
Location: Germany

Re: [ QMariaDB ] [ 10.5.9 ] MariaDB Server (wth PhPMyadmin)

Post by mr_hyde »

QNAP_Stephane wrote: Tue Apr 06, 2021 2:54 pm updated to 10.5.9 and PHPMyAdmin to 5.1.0
Thanks, it's running.

It would be nice if somehow the my.cnf and php config would be kept during update. It always falls back to the default which comes with the new update and settings will get lost.

Regards,
Alex
QNAP TS-453A
4 * Hitachi 3 TB HDD (RAID 5)
FW: 4.5.1 1540
niceasice
New here
Posts: 3
Joined: Wed Apr 08, 2009 10:17 am

Re: [ QMariaDB ] [ 10.5.9 ] MariaDB Server (wth PhPMyadmin)

Post by niceasice »

hi there,

i installed apache80 +QMariaDB and installed Joomla 4. I also enabled the virtual host to connect the Joomla site with a domain. Apache80 uses the port 4488. So the problem I've got now is if I enter http://joomlasite.com the browser leads me to an error page (-->Joomla needs php7.2.5 act) but if I insert http://joomlasite.com:4488/joomlasite_folder it leads me to the right homepage without an php7.2.5 error page.

How can I fix it so that I don't have to insert the port and folder at the end?

Thanks and greetings from Copenhagen ,
AJ
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QMariaDB ] [ 10.5.9 ] MariaDB Server (wth PhPMyadmin)

Post by QNAP_Stephane »

simply change port of your actual Qnap Webserver
and modify Apache80 httpd.conf to listen on port 80 (restart needed)

for path, think better user use Virtual Host (need be enabled in httpd.conf) and correctly setup
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
niceasice
New here
Posts: 3
Joined: Wed Apr 08, 2009 10:17 am

Re: [ QMariaDB ] [ 10.5.9 ] MariaDB Server (wth PhPMyadmin)

Post by niceasice »

Thanks a lot Qnap_Stephane, there Are days when you are not able to see a tree in front of a forest.
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by QNAP_Stephane »

updated to MariaDB 10.5.11
updated phpmyadmin to 5.1.1
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
Chris2409
New here
Posts: 2
Joined: Thu Jul 15, 2021 3:00 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by Chris2409 »

I have a very strange behavior after a power outage. I'm running 10.5.8 on a TS-451+ and after starting again QMariaDB wasn't running anymore. I couldn't find any reason why not. The DB was not starting. No lock-File, PID, etc.
To compare it with a running version I tried to install 10.5.8 on my second NAS TS-251A. Fresh system with no QMariaDB on it before. But it had the same problem. QMariaDB is not starting. I even used the same installable I used for the TS-451+ install some month before (and that worked until the power outage).
After that I updated on my second NAS to the latest QTS and tried my luck with 10.5.11. Same problem. This time I made the installation from Terminal, so I had the following output:
[/share] # sh CACHEDEV1_DATA/QMariaDB_10.5.11.0._x86_64.qpkg
Install QNAP package on TS-NAS...
./
./built_info
./qinstall.sh
./package_routines
./qpkg.cfg
22847+1 records in
22847+1 records out
567116525 bytes (540.8MB) copied, 15.357677 seconds, 35.2MB/s
553823+0 records in
553823+0 records out
567114752 bytes (540.8MB) copied, 15.358215 seconds, 35.2MB/s
Firmware check is fine.
Link service start/stop script: QMariaDB.sh
Set QPKG information in /etc/config/qpkg.conf
Installing MariaDB/MySQL system tables in '/share/CACHEDEV1_DATA/QMariaDB' ...
210714 20:55:42 [ERROR] mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs

We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

Server version: 10.5.11-MariaDB-log
key_buffer_size=0
read_buffer_size=262144
max_used_connections=0
max_threads=153
thread_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 121377 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
stack_bottom = 0x0 thread_stack 0x49000

mysqld crashes with a signal 11.

Unfortunately without any stacktrace. I found several entries in Google about broken Hardware. But as I have the same issue with 2 systems I don't think so.

Any ideas someone???
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by QNAP_Stephane »

No idea ... all works fine on my side on different NAS
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
Chris2409
New here
Posts: 2
Joined: Thu Jul 15, 2021 3:00 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by Chris2409 »

Strange is... I have same behaviour on 2 QNAPS. Even a clean install doesn't work.
Any dependencies that I miss? Or anything to get more logging out of it?
fuuss
Getting the hang of things
Posts: 66
Joined: Wed Apr 02, 2008 6:55 pm

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by fuuss »

Since I installed QTS 5.0 kodi take forever connecting to the DB , it take up to 30 seconds to get information what seems very strange does anybody of you has de same problem ?


This I get in the error message

2021-10-23 21:17:59 102 [Warning] Aborted connection 102 to db: 'kodi_video119' user: 'kodi' host: '192.168.1.119' (Got an error reading communication packets)
2021-10-23 21:17:59 105 [Warning] IP address '192.168.1.119' could not be resolved: Temporary failure in name resolution
2021-10-23 21:17:59 105 [Warning] Aborted connection 105 to db: 'unconnected' user: 'unauthenticated' host: '192.168.1.119' (This connection closed normally without authentication)
2021-10-23 21:18:02 106 [Warning] IP address '192.168.1.119' could not be resolved: Temporary failure in name resolution
2021-10-23 21:18:02 106 [Warning] Aborted connection 106 to db: 'unconnected' user: 'unauthenticated' host: '192.168.1.119' (This connection closed normally without authentication)
2021-10-23 21:18:05 107 [Warning] IP address '192.168.1.119' could not be resolved: Temporary failure in name resolution
2021-10-23 21:18:05 107 [Warning] Aborted connection 107 to db: 'unconnected' user: 'unauthenticated' host: '192.168.1.119' (This connection closed normally without authentication)



So it seems to be related to the dns resolve problem
kinglevel
Starting out
Posts: 46
Joined: Sat Oct 03, 2009 5:22 pm

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by kinglevel »

heck.. this was a deep rabbit hole to fall into..

it all started with me trying to get zabbix-proxy working, took me 2 days to figure out why it would not authenticate into the sql server... It was a version compatibility issue with MariaDB.. of course.

And now, i bought this package, and i cannot install it because i cannot upgrade my TS-439 Pro ii to QTS 4.3..
No minimum qts version mentioned in the descriptions...

Great! :D
excalibur470
New here
Posts: 3
Joined: Sun Nov 28, 2021 3:47 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by excalibur470 »

Hi all,
I Installed QMariaDB 10.5.11 on my TS-251D but I am unable to use it.
It is impossible to access via phpMyAdmin with the "mysqli::real_connect(): (HY000/2002): Connection refused" I used admin (or root) user and qnap password.
running "/etc/init.d/QMariaDB.sh restart" I obtain the following

Code: Select all

more: can't open '/share/CACHEDEV1_DATA/.qpkg/QMariaDB/QMariadDB2.pid': No such file or directory
share QMariaDB exists in your share
DB exists in your share
/etc/init.d/QMariaDB.sh: line 65: wait: pid 15 is not a child of this shell
/etc/init.d/QMariaDB.sh: line 71: wait: pid 15 is not a child of this shell
Changing QMariaDB Custom MariaDB root password to qnap
1
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/QMariadDB2.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/QMariadDB2.sock' exists! 
211127 21:25:32 mysqld_safe Logging to '/share/CACHEDEV1_DATA/QMariaDB/qmariadb.err'.
211127 21:25:32 mysqld_safe Starting mysqld daemon with databases from /share/CACHEDEV1_DATA/QMariaDB
2
/share/CACHEDEV1_DATA/.qpkg/QMariaDB/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/tmp/QMariadDB2.sock' (111)'
Check that mysqld is running and that the socket: '/tmp/QMariadDB2.sock' exists!
The sock file exists.
I removed and reinstalled the program but the results are the same
Could you please help me with this issue? Thank you in advance.

Alessandro
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by QNAP_Stephane »

try 127.0.0.1 instead of localhost and root /qnap
---------------------------------------------------------------------------------------------------------------------------

Find all QPKG in the MyQnap.org repository https://www.myqnap.org
join our discord server for any inquiry related to qpkg - https://discord.gg/4fPxHSWKQW

----------------------------------------------------------------------------------------------------------------------------
excalibur470
New here
Posts: 3
Joined: Sun Nov 28, 2021 3:47 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by excalibur470 »

I already had 127.0.0.1 but also using root / qnap I receive "mysqli::real_connect(): (HY000/2002): Connection refused"
excalibur470
New here
Posts: 3
Joined: Sun Nov 28, 2021 3:47 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by excalibur470 »

In attachment my my.cnf file.
Hoping it can help in some way.
You do not have the required permissions to view the files attached to this post.
mikaelke
New here
Posts: 9
Joined: Sat Jul 20, 2013 12:47 am

Re: [ QMariaDB ] [ 10.5.11 ] MariaDB Server (wth PhPMyadmin)

Post by mikaelke »

Hi,
I was to download QMariaDB, but became unsure if my TS-219 NAS is supported. As far as I can find out it has a 32-bit ARMv5TE-compliant CPU core ( Marvell 88F6281).
Is this supported by any of the packages; TS-X28A, TS-X30, TS-X32, TS-X32U or TS-XA28A?

Br,
Mikael
Post Reply

Return to “Community Apps”