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 4017) - 17 March 2024

Legacy Cumulus 1 release v1.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

Realtime and mysql download available.

Other discussion about creating web sites for Cumulus that doesn't have a specific subforum

Moderator: daj

mspec
Posts: 56
Joined: Sun 15 Jan 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Post by mspec »

inaciovieira wrote:i have traied in a file called teste and already moved the real.php to the root sit and its the same.
Is it because the version of cumulus? I have the Cumulus (1.9.2-b1031) .
I have also treid on a local server anda dosent run.
Is it because im portugal user :bash:
lol no its not because you are a portugal user, the version of cumulus should be fine as its putting out the same amount of fields. Could you start fresh on your local server and keep things as outlined in the instructions, make a database called weather then run the sqlsetup so it creates the table realtime then try running real.php in the root directory making sure you have defined the path correctly. There is no reason why it should not be working and I am sure its a simple mistake somewhere along the line.
inaciovieira
Posts: 54
Joined: Sun 01 May 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Post by inaciovieira »

well i traied on the local server
real.php

Code: Select all

//Edit below your sql info
$databasehost = "localhost";
$databasename = "weather";
$databasetable = "realtime";
$databaseusername ="root";
$databasepassword = "";
$fieldseparator = " ";
$lineseparator = "\n";
$realfile = "../realtime.txt"; //example /home/weather/www/realtime.txt
it guives an error on the page
You do not have the required permissions to view the files attached to this post.
mspec
Posts: 56
Joined: Sun 15 Jan 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Post by mspec »

Not sure why you should be getting that error , I see you are testing on windows, To be honest I have only ever had problems trying to run apache/php/mysql on windows I always use linux.
What version on php is running on your web server. Can you use something like phpinfo() to make sure the path to your realtime.txt is absolute.
inaciovieira
Posts: 54
Joined: Sun 01 May 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Post by inaciovieira »

User avatar
ergie
Posts: 44
Joined: Thu 19 Apr 2012 9:24 pm
Weather Station: WH1090
Operating System: Praspberry Pi2
Location: Oslo, Norway
Contact:

Re: Realtime and mysql download available.

Post by ergie »

yep for me on linux VPS was no problems to run these files. It still registering everything. But I still need somehow to pull data form mysql :D :roll: :D
mspec
Posts: 56
Joined: Sun 15 Jan 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Post by mspec »

Thanks for that seems everything is in order. Ok try this replace line 35 in real.php with the following.

foreach(preg_split($lineseparator,$realcontent) as $line) {
inaciovieira
Posts: 54
Joined: Sun 01 May 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Post by inaciovieira »

mspec wrote:Thanks for that seems everything is in order. Ok try this replace line 35 in real.php with the following.

foreach(preg_split($lineseparator,$realcontent) as $line) {
it guives this error

Code: Select all

Warning: preg_split() [function.preg-split]: Empty regular expression in C:\Users\chico\Desktop\xampp\htdocs\meteocasas\sit-teste\teste\real.php on line 35

Warning: Invalid argument supplied for foreach() in C:\Users\chico\Desktop\xampp\htdocs\meteocasas\sit-teste\teste\real.php on line 35
mspec
Posts: 56
Joined: Sun 15 Jan 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Post by mspec »

OK just change it back. Hmmmmmm, The only other thing I can think of is do you have access to the server web error logs ?? , depending on the error level set in php it may be logging it to the web server but not displaying the results. ie when you run real.php do you get anything on the screen at all ??, or is it just blank.
It looks like currently your php settings are "display_errors Off Off"
inaciovieira
Posts: 54
Joined: Sun 01 May 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Post by inaciovieira »

well
i could not put the data realtime with real.php file, I modified the file importcumulusfile.php and get put in that file
User avatar
SJG1976
Posts: 365
Joined: Wed 21 Dec 2011 11:04 am
Weather Station: Davis WLL, with Airlink
Operating System: Raspberry Pi3 MX on USB Drive
Location: Glemsford, Suffolk
Contact:

Re: Realtime and mysql download available.

Post by SJG1976 »

I relalise this thread is a bit old now, but was anything further developed to get the Highgrapgs WUG config working with the realtime database?

Seems to have gone a bit quiet on that, unless I missed it somewhere?
mspec
Posts: 56
Joined: Sun 15 Jan 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Post by mspec »

SJG1976 wrote:I relalise this thread is a bit old now, but was anything further developed to get the Highgrapgs WUG config working with the realtime database?

Seems to have gone a bit quiet on that, unless I missed it somewhere?
I got the database side of things up and running and had a play with highcharts but nothing really extensive as I have just not got the time at the moment, I got the database sorted you guys can do the rest of using all the information. ;)

Just a side note, I have had it running for quite a while now and its generated around 40k lines of data and is only coming in at 8meg so that's not to bad.
User avatar
SJG1976
Posts: 365
Joined: Wed 21 Dec 2011 11:04 am
Weather Station: Davis WLL, with Airlink
Operating System: Raspberry Pi3 MX on USB Drive
Location: Glemsford, Suffolk
Contact:

Re: Realtime and mysql download available.

Post by SJG1976 »

Thanks mspec,


Ive had a look at mixing the too together, but cant find what dta the WUG charts are looking for, the date format isnt right i think.

Like you ive not really had a chance to have a proper look.


Steve
mproper23
Posts: 14
Joined: Fri 31 Aug 2012 6:52 am
Weather Station: WH1080
Operating System: 7
Location: Germany

Re: Realtime and mysql download available.

Post by mproper23 »

Hi,

I installed it on my Webserver.
My Problem is that in my Realtime.txt the date is like this "03.09.12" meaning 3rd September 2012
and that the part where the date is changed that it fits to sql-standards is not working.
Can anyone Help me with that Problem?

Thank you

Greetings Andy
mspec
Posts: 56
Joined: Sun 15 Jan 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Post by mspec »

What version of Cumulus are you running ?? , Not sure if the current Beta version has changed the way it outputs realtime.txt. I have not updated mine for a while so don't know. If I get time I will have a look but at the moment i need 48hrs a day to get things done lol.
User avatar
steve
Cumulus Author
Posts: 26702
Joined: Mon 02 Jun 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: Realtime and mysql download available.

Post by steve »

mspec wrote:What version of Cumulus are you running ?? , Not sure if the current Beta version has changed the way it outputs realtime.txt.
It hasn't changed. Cumulus thinks it's using "/" for the date separator, but apparently what this means to the system code that actually does the formatting is "use the system's configured date separator".
Steve
Post Reply