WXforum.net
Weather Software => Meteohub/Meteobridge => Topic started by: jfields47 on January 26, 2019, 01:17:37 PM
-
I am try to use the meteobridge mysql upload to push my weather data to a Synology DS213j Diskstation. The diskstation has phpMyAdmin installed as well as a MariaDB 10 that uses port 3307. The meteobridge and diskstation are on the same internal network with no firewall.
I am getting the follow error on the meteobridge services tab. Error: Timed out to connect to MYSQL database: 6 seconds
I am not vary familar with mysql to begin with but I have tried everything I could find on the web to resolve this to no avail. Maybe someone here can help. Attached are the screen shots of the meteobridge, phpmyadmin page, and one from PuTTy.
-
Try changing MySQL upload to every Full 5 minutes. Every 15 seconds is a bit much. I don't know if that is the problem. But from the screenshots you showed that is the only difference between yours and mine.
Every Full 5 minutes makes it upload predictably every 5 minutes on the exact 5 minute marks of 00, 05, 10, 15, 20, 25....etc.
Paste your MySQL Query here to inspect that.
-
Well it looks like I got the upload working back on 1/27 and didn't realize it.
Galfert- I had that upload set at every 15 sec just to test my query, which was working. I have it set to every full 10 min now and it's working great.
However, on my services tab of the meteobridge, I still have the time out error and the red x beside the host. Not sure what's up that with but it's uploading every full 10 min as set.
-
root can only access from the synology box.
root@127.0.0.1
root@localhost
you are coming from a remote location so you need to add
root@<MB.IP.ADD.RESS> to the mysql database setup else root from meteobridge has no permission.
-
I added that account but the time out error is still there as well as the X beside the host. [ You are not allowed to view attachments ]