New Nas Cannot access MariaDB 10

Post your questions about Web Server usage and Apache + PHP + MySQL/SQLite web applications.
purezerg
Getting the hang of things
Posts: 58
Joined: Wed Nov 18, 2009 7:41 pm

Re: New Nas Cannot access MariaDB 10

Post by purezerg »

is there any updates on this topic? I am trying to install nextcloud on quts hero. but I kept hitting this mariadb10 problem. mariadb5 can be detected by nextcloud23. still contemplating if i should just use mariadb5
vitaljik
New here
Posts: 3
Joined: Fri Jul 19, 2019 1:58 pm

Re: New Nas Cannot access MariaDB 10

Post by vitaljik »

Toxic17 wrote: Fri Nov 19, 2021 8:45 pm So QNP UK got back to me. they said the following:
We use a custom implementation of MariaDB10, you just need to define the socket in the connection command. The correct way to connect to the Qnap version of MariaDB is as follows:

Code: Select all

/share/"Data Mount Point"/.qpkg/MariaDB10/bin/mysql -S /var/run/mariadb10.sock -u root -p
the "/var/run/mariadb10.sock" parameter is what is used in this case, but can be different I guess. look at the MariaDB app and see what is listed in there.
I believe I have the same problem. Can someone guide me from where should I run this code?
User avatar
Toxic17
Ask me anything
Posts: 6469
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: New Nas Cannot access MariaDB 10

Post by Toxic17 »

vitaljik wrote: Tue Jan 18, 2022 5:46 pm
I believe I have the same problem. Can someone guide me from where should I run this code?
you run this from an ssh console using something like PuTTY or using the QNAP utility

Plenty of help if your willing to look/search for it.

https://www.qnap.com/en-uk/how-to/knowl ... nas-by-ssh

https://www.qnap.com/en/how-to/knowledg ... -using-ssh
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
yujungchang
Starting out
Posts: 35
Joined: Sun Sep 20, 2020 11:54 am

Re: New Nas Cannot access MariaDB 10

Post by yujungchang »

I came across this when setting up the wordpress 5.8.3 (another big setup issue on Qnap TS-231+) and the solution below works for me (don't have to run the additional command). From my perspective, they can spend time writing up this article, why not just putting those into the default config file or the post installation script? There's really no excuse not to release the MariaDB 10 with those 2 lines by default if that's what they recommended.

https://www.qnap.com/en/how-to/faq/arti ... phpmyadmin
In Web/phpMyAdmin/config.inc.php, add before "?>" at the end of the file.
The file is read only, so need to change the attribute before write and change it back afterward.
I also have a problem opening this file with the text editor in QTS GUI, have to SSH to edit with the vi.
port: $cfg['Servers'][$i]['port'] = '3307';
socket: $cfg['Servers'][$i]['socket'] = '/var/run/mariadb10.sock';
XDD missile launch @Taiwan https://www.thingiverse.com/thing:5448224

[How to] Recover no beep / dead Intel based Qnap x53/x51 (2014~2016?) viewtopic.php?f=45&t=157459
[How to] Debug the SATA backplane power issue (models w/ a brick power supply viewtopic.php?f=50&t=157649
[How to] Enable onboard SATA connectors on the x53/x51 (Total 4+2 SATA drives for a 4 bay model) viewtopic.php?f=97&t=157816
stevedh
Know my way around
Posts: 144
Joined: Wed Oct 29, 2008 4:40 am

Re: New Nas Cannot access MariaDB 10

Post by stevedh »

In the end this and php were giving me too many problems, so I dived into the wonderful world of containers, and all my problems went away.
TS-109 II -- Version 3.3.1 Build 0823T
TS-219P -- Version 4.3.3.0663 Build 2018/08/29
TS-253D -- Version 5.0.0.1850
.jon.
First post
Posts: 1
Joined: Mon Jul 13, 2020 3:59 am

Re: New Nas Cannot access MariaDB 10

Post by .jon. »

Toxic17 wrote: Fri Nov 19, 2021 8:45 pm So QNP UK got back to me. they said the following:
We use a custom implementation of MariaDB10, you just need to define the socket in the connection command. The correct way to connect to the Qnap version of MariaDB is as follows:

Code: Select all

/share/"Data Mount Point"/.qpkg/MariaDB10/bin/mysql -S /var/run/mariadb10.sock -u root -p
the "/var/run/mariadb10.sock" parameter is what is used in this case, but can be different I guess. look at the MariaDB app and see what is listed in there.
Thanks. I just spent the better part of a day troubleshooting this while trying to import a largish DB from cli. Was just about to give up :roll:
.jon.
fl5xgr
Starting out
Posts: 35
Joined: Fri Dec 28, 2018 10:34 pm

Re: New Nas Cannot access MariaDB 10

Post by fl5xgr »

Toxic17 wrote: Fri Nov 19, 2021 8:45 pm So QNP UK got back to me. they said the following:
We use a custom implementation of MariaDB10, you just need to define the socket in the connection command. The correct way to connect to the Qnap version of MariaDB is as follows:

Code: Select all

/share/"Data Mount Point"/.qpkg/MariaDB10/bin/mysql -S /var/run/mariadb10.sock -u root -p
the "/var/run/mariadb10.sock" parameter is what is used in this case, but can be different I guess. look at the MariaDB app and see what is listed in there.
Sorry, but it's still not clear to me how to solve this problem. If I run:

Code: Select all

# /share/CACHEDEV1_DATA/.qpkg/MariaDB10/bin/mysql -S /var/run/mariadb10.sock -u root -p
I still get this:

Code: Select all

# ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mariadb10.sock' (111)
I believe I have the same situation:

Code: Select all

# /share/CACHEDEV1_DATA/.qpkg/MariaDB10/bin/mysql --defaults-file=/share/CACHEDEV1_DATA/.qpkg/MariaDB10/etc/mariadb.conf --print-defaults
/share/CACHEDEV1_DATA/.qpkg/MariaDB10/bin/mysql would have been started with the following arguments:
--socket=/var/run/mariadb10.sock --default-character-set=utf8mb4 --port=3306 --no-auto-rehash --socket=/var/run/mariadb10.sock --default-character-set=utf8mb4
Except for this:

Code: Select all

# /share/CACHEDEV1_DATA/.qpkg/MariaDB10/bin/mysql --defaults-file=/share/CACHEDEV1_DATA/.qpkg/MariaDB10/etc/mariadb.conf -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mariadb10.sock' (111) 
User avatar
Toxic17
Ask me anything
Posts: 6469
Joined: Tue Jan 25, 2011 11:41 pm
Location: Planet Earth
Contact:

Re: New Nas Cannot access MariaDB 10

Post by Toxic17 »

is your actually mysql running?

and the sock path is correct?
Screenshot 2022-10-18 211930.png
You do not have the required permissions to view the files attached to this post.
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
Post Reply

Return to “Web Server & Applications (Apache + PHP + MySQL / SQLite)”