[ 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.
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

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

Post by QNAP_Stephane »

Image

Source : https://mariadb.com

Download : x64 version, arm64

https://qnapclub.eu/fr/qpkg/525

Note :

-[ QPKG Integration ]-

all DB are stored in a share called QMariaDB create on first launch
Listen on port 3308 to not interact with embedded MariaDB
Socket under /tmp/QMariadDB2.sock
root password on start set as qnap (change it over the phpmyadmin embbeded)

About :

MariaDB creates open source database solutions to fulfill today's needs and tomorrow's possibilities by combining engineering leadership and community innovation on a global scale — and without sacrificing SQL or the performance, reliability and security you've come to expect.
Last edited by QNAP_Stephane on Sun Jul 04, 2021 12:43 am, edited 6 times in total.
---------------------------------------------------------------------------------------------------------------------------

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

----------------------------------------------------------------------------------------------------------------------------
presenceofmind
Know my way around
Posts: 198
Joined: Thu May 26, 2016 3:05 pm

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

Post by presenceofmind »

Hi QNAP_Stephane,

I can't access the database using PhpMyAdmin.

#2002 - Connection refused — The server is not responding (or the local server's socket is not correctly configured).

mysqli_real_connect(): (HY000/2002): Connection refused

Is there any setup needed?

oh wait. Does this install replace the current Qnap MariaDb v5? I dont know what happened but It caused caos on my NAS.

I had to uninstall.

Cheers
User avatar
Toxic17
Ask me anything
Posts: 6468
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

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

Post by Toxic17 »

this sometimes this happens with Cookies in phpMyAdmin. have you tried clearing the Browsers Cache?
Regards Simon

Qnap Downloads
MyQNap.Org Repository
Submit a ticket • QNAP Helpdesk
QNAP Tutorials, User Manuals, FAQs, Downloads, Wiki
When you ask a question, please include the following


NAS: TS-673A QuTS hero h5.1.2.2534 • TS-121 4.3.3.2420 • APC Back-UPS ES 700G
Network: VM Hub3: 500/50 • UniFi UDM Pro: 3.2.9 • UniFi Network Controller: 8.0.28
USW-Aggregation: 6.6.61 • US-16-150W: 6.6.61 • 2x USW Mini Flex 2.0.0 • UniFi AC Pro 6.6.62 • UniFi U6-LR 6.6.62
UniFi Protect: 2.11.21/8TB Skyhawk AI • 3x G3 Instants: 4.69.55 • UniFi G3 Flex: 4.69.55 • UniFi G5 Flex: 4.69.55
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

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

Post by QNAP_Stephane »

Use the embedded phpmyadmin inside qmariadb preset to listen on 3308

Envoyé de mon SM-G925F en utilisant Tapatalk
---------------------------------------------------------------------------------------------------------------------------

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

----------------------------------------------------------------------------------------------------------------------------
presenceofmind
Know my way around
Posts: 198
Joined: Thu May 26, 2016 3:05 pm

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

Post by presenceofmind »

I have reinstalled and cleared the browser cache but the issue persist.

#2002 - Connection refused — The server is not responding (or the local server's socket is not correctly configured).

I can see the process running.

Also QmariaDb v10 seems to be replacing Qnap MariaDB v5.

Control panel > SQL Server - QMariaDB v10.2.12

This is an issue because I have dbs in v5.
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

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

Post by QNAP_Stephane »

I will double check

Envoyé de mon SM-G925F en utilisant Tapatalk
---------------------------------------------------------------------------------------------------------------------------

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

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

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

Post by QNAP_Stephane »

OH think i think found Why....

by hazard they are sharing the same pid... i will change this in 10.2.12.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

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

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

Post by QNAP_Stephane »

published 10.2.12.1

tested PHPMyAdmin standard log well on the 5.5.57-MariaDB
tested PHPMy Admin (embbeded to QMariaDB2) log well on the 10.2.12-MariaDB-log

i just modified the pid location&name and also socket.. but i have no clue why QTS interface still display 10.2.12.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

----------------------------------------------------------------------------------------------------------------------------
presenceofmind
Know my way around
Posts: 198
Joined: Thu May 26, 2016 3:05 pm

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

Post by presenceofmind »

sorry but still the same issues.
presenceofmind
Know my way around
Posts: 198
Joined: Thu May 26, 2016 3:05 pm

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

Post by presenceofmind »

sorry but still the same issues.
User avatar
Trexx
Ask me anything
Posts: 5393
Joined: Sat Oct 01, 2011 7:50 am
Location: Minnesota

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

Post by Trexx »

Still seeing same interaction issues with QTS SQL Interface. Also seems to affect installation of QTS SQL if active during upgrade to 4.3.5beta. Removed QMariaDB, but QTS Sql was shown as uninstalled. Even post reboot after removal. Had to reinstall 4.3.5 beta2 firmware to fix.
Paul

Model: TS-877-1600 FW: 4.5.3.x
QTS (SSD): [RAID-1] 2 x 1TB WD Blue m.2's
Data (HDD): [RAID-5] 6 x 3TB HGST DeskStar
VMs (SSD): [RAID-1] 2 x1TB SK Hynix Gold
Ext. (HDD): TR-004 [Raid-5] 4 x 4TB HGST Ultastor
RAM: Kingston HyperX Fury 64GB DDR4-2666
UPS: CP AVR1350

Model:TVS-673 32GB & TS-228a Offline[/color]
-----------------------------------------------------------------------------------------------------------------------------------------
2018 Plex NAS Compatibility Guide | QNAP Plex FAQ | Moogle's QNAP Faq
User avatar
QNAP_Stephane
Experience counts
Posts: 4802
Joined: Wed Mar 27, 2013 1:00 am

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

Post by QNAP_Stephane »

think i have still some improvment to bring to isolate this qpkg from the whole QTS and not impact the behaviors of the OS
---------------------------------------------------------------------------------------------------------------------------

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

----------------------------------------------------------------------------------------------------------------------------
SenseoHasser
Starting out
Posts: 32
Joined: Sat Jan 03, 2009 1:21 am

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

Post by SenseoHasser »

Unfortunately I am facing the same issues as Trexx. Is there any update?
presenceofmind
Know my way around
Posts: 198
Joined: Thu May 26, 2016 3:05 pm

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

Post by presenceofmind »

Hi QNAP_Stephane,

was there any improvement in this? Is it safe to use?

I need to run updated mariadb and the qnap db is v5.5 outdated.

Last attempt I did with QMariaDB I was forced to reset firmware. Could you confirm it's ok now.

Cheers
Last edited by presenceofmind on Fri Jul 26, 2019 4:13 am, edited 1 time in total.
presenceofmind
Know my way around
Posts: 198
Joined: Thu May 26, 2016 3:05 pm

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

Post by presenceofmind »

Hi QNAP_Stephane,

I'm still unable to log on the server.

" #2002 - Connection refused — The server is not responding (or the local server's socket is not correctly configured)."

What do I have to do to get this going?

I tried installing another phpadmin (qnap store) and it returns

"Login without a password is forbidden by configuration (see AllowNoPassword)"

Please could you have a look? I really need updated mariadb running on my server.

Cheers
Post Reply

Return to “Community Apps”