Please read the posts in the Announcements section about the current status of Cumulus development now that I have retired

Please read this post before posting

Latest Cumulus release v1.9.4 (build 1099) - Nov 28 2014
Latest Cumulus MX release - v3.0.0 build 3043 Jan 20 2017. See this post for download

Realtime and mysql download available.

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

Moderators: daj, TNETWeather

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

Re: Realtime and mysql download available.

Postby mspec » Mon Apr 23, 2012 5:58 pm

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 May 01, 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Postby inaciovieira » Mon Apr 23, 2012 6:12 pm

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: 52
Joined: Sun Jan 15, 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Postby mspec » Mon Apr 23, 2012 6:36 pm

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 May 01, 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Postby inaciovieira » Mon Apr 23, 2012 6:40 pm


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

Re: Realtime and mysql download available.

Postby ergie » Mon Apr 23, 2012 6:46 pm

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: 52
Joined: Sun Jan 15, 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Postby mspec » Mon Apr 23, 2012 6:47 pm

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 May 01, 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Postby inaciovieira » Mon Apr 23, 2012 6:51 pm

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: 52
Joined: Sun Jan 15, 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Postby mspec » Mon Apr 23, 2012 6:55 pm

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 May 01, 2011 7:13 pm
Weather Station: Watson
Operating System: Windows 7
Location: Funchal

Re: Realtime and mysql download available.

Postby inaciovieira » Mon Apr 23, 2012 9:14 pm

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: 216
Joined: Wed Dec 21, 2011 11:04 am
Weather Station: Oregon WRM200 and Davis VP1
Operating System: Raspberry Pi3, Raspberry Pi
Location: Essex
Contact:

Re: Realtime and mysql download available.

Postby SJG1976 » Mon Jul 23, 2012 12:56 pm

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?
Image

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

Re: Realtime and mysql download available.

Postby mspec » Tue Jul 24, 2012 4:23 pm

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: 216
Joined: Wed Dec 21, 2011 11:04 am
Weather Station: Oregon WRM200 and Davis VP1
Operating System: Raspberry Pi3, Raspberry Pi
Location: Essex
Contact:

Re: Realtime and mysql download available.

Postby SJG1976 » Thu Jul 26, 2012 8:07 pm

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
Image

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

Re: Realtime and mysql download available.

Postby mproper23 » Mon Sep 03, 2012 6:31 am

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: 52
Joined: Sun Jan 15, 2012 11:21 pm
Weather Station: Davis vantage pro 2 cabled.
Operating System: Windows 10
Location: Christchurch

Re: Realtime and mysql download available.

Postby mspec » Tue Sep 04, 2012 1:42 pm

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: 26619
Joined: Mon Jun 02, 2008 6:49 pm
Weather Station: None
Operating System: None
Location: Vienne, France
Contact:

Re: Realtime and mysql download available.

Postby steve » Tue Sep 04, 2012 1:49 pm

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
-----
Hosting available for Cumulus web sites. See http://sandaysoft.com/forum/viewtopic.php?f=2&t=11876

Please read the posts in the Announcements section about the current status of Cumulus development since I have retired from my day job


Return to “Web site - General”

Who is online

Users browsing this forum: No registered users and 3 guests