New Nas Cannot access MariaDB 10
-
- Getting the hang of things
- Posts: 58
- Joined: Wed Nov 18, 2009 7:41 pm
Re: New Nas Cannot access MariaDB 10
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
-
- New here
- Posts: 3
- Joined: Fri Jul 19, 2019 1:58 pm
Re: New Nas Cannot access MariaDB 10
I believe I have the same problem. Can someone guide me from where should I run this code?Toxic17 wrote: ↑Fri Nov 19, 2021 8:45 pm So QNP UK got back to me. they said the following:
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.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
- Toxic17
- Ask me anything
- Posts: 6477
- Joined: Tue Jan 25, 2011 11:41 pm
- Location: Planet Earth
- Contact:
Re: New Nas Cannot access MariaDB 10
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
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
- yujungchang
- Starting out
- Posts: 35
- Joined: Sun Sep 20, 2020 11:54 am
Re: New Nas Cannot access MariaDB 10
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.
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
[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
-
- Know my way around
- Posts: 144
- Joined: Wed Oct 29, 2008 4:40 am
Re: New Nas Cannot access MariaDB 10
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
TS-219P -- Version 4.3.3.0663 Build 2018/08/29
TS-253D -- Version 5.0.0.1850
-
- First post
- Posts: 1
- Joined: Mon Jul 13, 2020 3:59 am
Re: New Nas Cannot access MariaDB 10
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 upToxic17 wrote: ↑Fri Nov 19, 2021 8:45 pm So QNP UK got back to me. they said the following:
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.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
.jon.
-
- Starting out
- Posts: 36
- Joined: Fri Dec 28, 2018 10:34 pm
Re: New Nas Cannot access MariaDB 10
Sorry, but it's still not clear to me how to solve this problem. If I run:Toxic17 wrote: ↑Fri Nov 19, 2021 8:45 pm So QNP UK got back to me. they said the following:
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.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
Code: Select all
# /share/CACHEDEV1_DATA/.qpkg/MariaDB10/bin/mysql -S /var/run/mariadb10.sock -u root -p
Code: Select all
# ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mariadb10.sock' (111)
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
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)
- Toxic17
- Ask me anything
- Posts: 6477
- Joined: Tue Jan 25, 2011 11:41 pm
- Location: Planet Earth
- Contact:
Re: New Nas Cannot access MariaDB 10
is your actually mysql running?
and the sock path is correct?
and the sock path is correct?
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
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