[weewx-user] Re: SQL Hosted on Synology NAS
In your original post, I missed you are using MariaDB 10 so the default port for it is 3307 instead of 3306 used by Maria DB 5. I also should have mentioned a way to test your connection from remote. Are you running WeeWX on a Raspberry PI? If so, you can install just the MariaDB client using: sudo apt-get install mariadb-client-10.1 Once the client is installed, you can run this command to test your connection to the Synology (my Synology is at 192.168.71.4): $ mysql -usaimail -p -h 192.168.71.4 Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 5.5.62-MariaDB Source distribution Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/822cafd7-4400-4836-844e-d9e695c58aa5%40googlegroups.com.
[weewx-user] Re: SQL Hosted on Synology NAS
The Synology does not have any remote user accounts enabled by default. I assume you are running phpMyAdmin on the Synology. Did you login to the Synology using SSH and create a remote account? You can check if you have a remote account configured by doing this: 1. Verify you have SSH enabled on the Synology using Control Panel | Terminal & SNMP | Enable SSH service 2. Connect to the Synology using SSH. Login with admin and your admin password 3. Change to the directory: /volume1/@appstore/MariaDB/usr/bin 4. Run the command ./mysql -u root -p and enter your MariaDB root password when prompted 5. Run this mysql command which will list your users: SELECT User, Host FROM mysql.user; 6. You must have at least one user who is allowed to connect remotely and that user must be used in the WeeWX config. In the info below, 'saimail@192.168.71.6' is my remote account that is allowed to connect remotely. I actually have phpMyAdmin on a Linux Server and use that install to manage MariaDB on my Synology using this remote account: Also, I think the Synology MariaDB listens on port 3306 by default for remote connections, but you have :3307 listed above. You can check your Synology by going to the Main Menu and clicking on MariaDB 5 . +-+-+ | User| Host | +-+-+ | root| 127.0.0.1 | | saimail | 192.168.71.6 | | root| ::1 | || localhost | | php4dvd | localhost | | root| localhost | || synology-216 | | root| synology-216 | +-++ 8 rows in set (0.06 sec) -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/9066e7fb-b780-4977-8459-273e970f69b7%40googlegroups.com.
