Values from database not read?
Posted: Mon Jan 30, 2023 1:37 pm
Actually I am stucking with an issue I tried to solve the whole weekend - without success so far.
I did setup 2 VM for testing, currently both with PHP 7.4.
One is using the "custom" for updating the mysql database, the other use the "API" option.
Both VMs pull the weatherstation data from the real instance accessible in internet.
At both VMs I can see, that the databases are filled in 5 minute intervall with the data.
But: at both VMs it seems, that each PHP script reading the database does not work!??
I noticed that i.e. when using the stationAveragesBlock.php, at both VMs the averages remain empty:
So all interactive pages (graph.php or table.php) remain empty.
Checking the mysql database from host CLI I can run the queries. I even wrote a small PHP script to check access from browser - data can be retrieved, but not from meteotemplate scripts...?
At real internet all works without any issues, but not in the test environment.
Prior digging deeper into the scripts may be someone cn point me to the right direction?
Regards
I did setup 2 VM for testing, currently both with PHP 7.4.
One is using the "custom" for updating the mysql database, the other use the "API" option.
Both VMs pull the weatherstation data from the real instance accessible in internet.
At both VMs I can see, that the databases are filled in 5 minute intervall with the data.
But: at both VMs it seems, that each PHP script reading the database does not work!??
I noticed that i.e. when using the stationAveragesBlock.php, at both VMs the averages remain empty:
- stn_Average.png (16.01 KiB) Viewed 3297 times
Checking the mysql database from host CLI I can run the queries. I even wrote a small PHP script to check access from browser - data can be retrieved, but not from meteotemplate scripts...?
At real internet all works without any issues, but not in the test environment.
Prior digging deeper into the scripts may be someone cn point me to the right direction?
Regards