No access to mySQL database? SOLVED
Posted: Wed Oct 26, 2022 8:54 pm
I have set up my weather site using Hostinger as the host. I have been able to get my site available at:
https://www.owlsheadns.com/template/indexDesktop.php
which correctly shows some information from Environment Canada - so the template is working.
But getting data from my station into the mySQL database is not working. I have a Davis VantageVue and have been using a MeteoPi ethernet logger to upload the data to Weatherlink.com (Davis) and also to WeatherUnderground. I know the data is getting to those sites because I can see the results there, and I also have an alternate weather page at:
https://www.owlsheadns.com/pwsWD/index.php
which works fine - I wanted to try the Meteotemplate also.
I have tried using cron jobs to get data from WeatherUnderground (using the built-in functions) and also tried getting data from Weatherlink using the wlIP plugin. No data ever arrives. Hostinger allows you to test your cron job and I get an error message:
Cron output
Could not open input file: /home/<correct-host-account-number>/public_html/template/plugins/wlIP/wlIPupdate.php?password=<various-passwords>
or similar with the WU data.
(where <correct-host-account-number> matches my Hostinger account)
(where <various-passwords> are several I have tried that are one part or another from the template of the mySQL setup)
I am unsure of what precise password should be used here - is it the mySQL password or the update password or what? - In any event I have tried them all and always get a similar result. I *think* the error message is coming from my host provider because I haven't found such message string in the template .php files I checked.
What am I doing wrong?
https://www.owlsheadns.com/template/indexDesktop.php
which correctly shows some information from Environment Canada - so the template is working.
But getting data from my station into the mySQL database is not working. I have a Davis VantageVue and have been using a MeteoPi ethernet logger to upload the data to Weatherlink.com (Davis) and also to WeatherUnderground. I know the data is getting to those sites because I can see the results there, and I also have an alternate weather page at:
https://www.owlsheadns.com/pwsWD/index.php
which works fine - I wanted to try the Meteotemplate also.
I have tried using cron jobs to get data from WeatherUnderground (using the built-in functions) and also tried getting data from Weatherlink using the wlIP plugin. No data ever arrives. Hostinger allows you to test your cron job and I get an error message:
Cron output
Could not open input file: /home/<correct-host-account-number>/public_html/template/plugins/wlIP/wlIPupdate.php?password=<various-passwords>
or similar with the WU data.
(where <correct-host-account-number> matches my Hostinger account)
(where <various-passwords> are several I have tried that are one part or another from the template of the mySQL setup)
I am unsure of what precise password should be used here - is it the mySQL password or the update password or what? - In any event I have tried them all and always get a similar result. I *think* the error message is coming from my host provider because I haven't found such message string in the template .php files I checked.
What am I doing wrong?