Welcome to the Cumulus Support forum.

Latest Cumulus MX V3 release 3.28.6 (build 3283) - 21 March 2024

Cumulus MX V4 beta test release 4.0.0 (build 4019) - 03 April 2024

Legacy Cumulus 1 release 1.9.4 (build 1099) - 28 November 2014
(a patch is available for 1.9.4 build 1099 that extends the date range of drop-down menus to 2030)

Download the Software (Cumulus MX / Cumulus 1 and other related items) from the Wiki

Server generated SQL

From build 3044 the development baton passed to Mark Crossley. Mark has been responsible for all the Builds since. He has made the code available on GitHub. It is Mark's hope that others will join in this development, but at the very least he welcomes your ideas for future developments (see Cumulus MX Development suggestions).

Moderator: mcrossley

water01
Posts: 3255
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10 64bit
Location: Burnham-on-Sea
Contact:

Re: Server generated SQL

Post by water01 »

in /etc/php/7.3/apache2/php.ini I have ;open_basedir =
The ; in front of open_basedir means it is commented out, did you mean that?
David
Image
richard_newberry
Posts: 481
Joined: Tue 12 Apr 2011 10:23 pm
Weather Station: Watson W-8186
Operating System: Raspbian Bookworm & Debian 12
Location: Leicester
Contact:

Re: Server generated SQL

Post by richard_newberry »

It is indeed.

TZ statement only works with +00:00 then apache2 error displays invalid.
Desford Weather (at parents)
https://desford-weather.co.uk

Countesthorpe Weather (at mine)
https://countesthorpe-weather.co.uk
sfws
Posts: 1183
Joined: Fri 27 Jul 2012 11:29 am
Weather Station: Chas O, Maplin N96FY, N25FR
Operating System: rPi 3B+ with Buster (full)

Re: Server generated SQL

Post by sfws »

richard_newberry wrote: Mon 04 May 2020 12:49 pm TZ statement only works with +00:00
The easiest way to set timezone is not in individual applications.
Use date.timezone = Europe/London in php.ini. Obviously changes to php.ini only take effect when the web server is restarted and reads that file.
richard_newberry
Posts: 481
Joined: Tue 12 Apr 2011 10:23 pm
Weather Station: Watson W-8186
Operating System: Raspbian Bookworm & Debian 12
Location: Leicester
Contact:

Re: Server generated SQL

Post by richard_newberry »

Thanks for replying,

What do i put in the Graphsettings.php file for the timezone instead of +00:00?
Desford Weather (at parents)
https://desford-weather.co.uk

Countesthorpe Weather (at mine)
https://countesthorpe-weather.co.uk
richard_newberry
Posts: 481
Joined: Tue 12 Apr 2011 10:23 pm
Weather Station: Watson W-8186
Operating System: Raspbian Bookworm & Debian 12
Location: Leicester
Contact:

Re: Server generated SQL

Post by richard_newberry »

I have got it to work http://desford-weather.co.uk/images/graphCloudbase.php

However I have found a bug or have I done this?

It's the Cloudbase but the image is displaying Barometer?

Also I can't get http://desford-weather.co.uk/images/graphWindRose.php to work

Any ideas?

Can we have FeelsLike Gauge and Apparent Gauge with image please?

Thanks.
You do not have the required permissions to view the files attached to this post.
Desford Weather (at parents)
https://desford-weather.co.uk

Countesthorpe Weather (at mine)
https://countesthorpe-weather.co.uk
water01
Posts: 3255
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10 64bit
Location: Burnham-on-Sea
Contact:

Re: Server generated SQL

Post by water01 »

I took a look at all your gauges and they are showing the correct popups apart from cloudbase. Perhaps you have a browser caching problem and you need to clear it to see the correct image.

Wind rose is showing the wind direction graph.

What each shows is determined by the gauges.js list and this must match the .htaccess file in the images directory.
David
Image
richard_newberry
Posts: 481
Joined: Tue 12 Apr 2011 10:23 pm
Weather Station: Watson W-8186
Operating System: Raspbian Bookworm & Debian 12
Location: Leicester
Contact:

Re: Server generated SQL

Post by richard_newberry »

I have cleared the cache same issue.

Why does cloudbase imaging displaying the barometer i am no idea. Coding is correct images folder cloudbase.php is working correctly just in gauges its wrong.

I am having invalid errors for timezone "+0:00" and when i enable windrose.php file i am getting a database error.

Any ideas?
Desford Weather (at parents)
https://desford-weather.co.uk

Countesthorpe Weather (at mine)
https://countesthorpe-weather.co.uk
richard_newberry
Posts: 481
Joined: Tue 12 Apr 2011 10:23 pm
Weather Station: Watson W-8186
Operating System: Raspbian Bookworm & Debian 12
Location: Leicester
Contact:

Re: Server generated SQL

Post by richard_newberry »

How do i add a Feels Like Gauge to Gauges?

Thanks.
Desford Weather (at parents)
https://desford-weather.co.uk

Countesthorpe Weather (at mine)
https://countesthorpe-weather.co.uk
water01
Posts: 3255
Joined: Sat 13 Aug 2011 9:33 am
Weather Station: Ecowitt HP2551
Operating System: Windows 10 64bit
Location: Burnham-on-Sea
Contact:

Re: Server generated SQL

Post by water01 »

David
Image
richard_newberry
Posts: 481
Joined: Tue 12 Apr 2011 10:23 pm
Weather Station: Watson W-8186
Operating System: Raspbian Bookworm & Debian 12
Location: Leicester
Contact:

Re: Server generated SQL

Post by richard_newberry »

Great link but how do you add a Feels Like Gauge.

I guess you need to add it Gauges Template file?
Desford Weather (at parents)
https://desford-weather.co.uk

Countesthorpe Weather (at mine)
https://countesthorpe-weather.co.uk
Mapantz
Posts: 1820
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Server generated SQL

Post by Mapantz »

You'll need to add the feels like webtag info to realtimegauges.txt as the first port of call.

Wouldn't be easier to change the 'apparent temp' data to feels like?
Image
User avatar
HansR
Posts: 5967
Joined: Sat 20 Oct 2012 6:53 am
Weather Station: GW1100 (WS80/WH40)
Operating System: Raspberry OS/Bookworm
Location: Wagenborgen (NL)
Contact:

Re: Server generated SQL

Post by HansR »

I assume an extra option is needed below the gauge displaying the apparent, dewpoint etc...
And the data must be present. Pretty sure that is not the case.

So this requires some updating somewhere. New version of the gauges. It is not something you can do on the fly.

New version of the CumulusCharts as well required btw (which is minor because effort, the data are already present, I did it already in CumulusUtils)
Hans

https://meteo-wagenborgen.nl
CMX build 4017+ ● RPi 3B+ ● Raspbian Linux 6.1.21-v7+ armv7l ● dotnet 8.0.3
Mapantz
Posts: 1820
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Server generated SQL

Post by Mapantz »

I added this to the realtimegaugesT.txt

Code: Select all

"feelsLike":"<#feelslike>",
"feelslikeTL":"<#feelslikeTL>",
"feelslikeTH":"<#feelslikeTH>",
"TfeelslikeTL":"<#TfeelslikeTL>",
"TfeelslikeTH":"<#TfeelslikeTH>",
Then searched for 'app' in gauges.js and changed them all to the appropriate feels like text above ^
I went in to language.min.js and looked for the 'apparent' text, and changed that accordingly.

The page that shows the gauges needs to show 'Feels Like' in the label id as well.

Took about 10 minutes to do.

https://warehamwx.co.uk/gauges.php

It will take a bit longer if you want to add 'feels like' alongside the other data, but I prefer feels like to apparent.
Image
User avatar
HansR
Posts: 5967
Joined: Sat 20 Oct 2012 6:53 am
Weather Station: GW1100 (WS80/WH40)
Operating System: Raspberry OS/Bookworm
Location: Wagenborgen (NL)
Contact:

Re: Server generated SQL

Post by HansR »

It's a bit hacking around isn't it?
Now you lost the Apparent temp in the gauge.
Hans

https://meteo-wagenborgen.nl
CMX build 4017+ ● RPi 3B+ ● Raspbian Linux 6.1.21-v7+ armv7l ● dotnet 8.0.3
Mapantz
Posts: 1820
Joined: Sat 17 Dec 2011 11:55 am
Weather Station: Davis Vantage Pro2
Operating System: Windows 11 x64
Location: Dorset - UK
Contact:

Re: Server generated SQL

Post by Mapantz »

HansR wrote: Sun 10 May 2020 7:42 pm It's a bit hacking around isn't it?
Now you lost the Apparent temp in the gauge.
I know. I didn't want it anymore, hence why I said I prefer feels like over apparent.
Image
Post Reply