Page 2 of 4
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 5:58 pm
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
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.
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:12 pm
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
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:36 pm
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.
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:40 pm
by inaciovieira
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:46 pm
by ergie
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:47 pm
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) {
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:51 pm
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
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 6:55 pm
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"
Re: Realtime and mysql download available.
Posted: Mon 23 Apr 2012 9:14 pm
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
Re: Realtime and mysql download available.
Posted: Mon 23 Jul 2012 12:56 pm
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?
Re: Realtime and mysql download available.
Posted: Tue 24 Jul 2012 4:23 pm
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.
Re: Realtime and mysql download available.
Posted: Thu 26 Jul 2012 8:07 pm
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
Re: Realtime and mysql download available.
Posted: Mon 03 Sep 2012 6:31 am
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
Re: Realtime and mysql download available.
Posted: Tue 04 Sep 2012 1:42 pm
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.
Re: Realtime and mysql download available.
Posted: Tue 04 Sep 2012 1:49 pm
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".
