Author Topic: HOMEWEATHERSTATION TEMPLATE with meteobridge options  (Read 7250 times)

0 Members and 1 Guest are viewing this topic.

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #125 on: October 06, 2017, 04:13:43 AM »
good morning you can now download the MYSQL version which is kind of exclusive to the meteobridge API users . i have included a set up guide in the download .

added database support this is exclusive for meteobridge users and my commitment to developing further solely for meteobridge .thanks to Boris
sorry it took so long to setup the meteobridge you sent many months ago but now I can focus properly and begin to really understand how it works
and a week in use Im seeing lots of benefits and possible ideas for the near future..

basically the meteobridge is doing everything from inserting in to database ,  creating chart files for year, month and daily maintenance which prevents the database becoming excessive in size i.e millions of rows which in time will drag your server to a slow performance , MYSQL is efficient but also realise there is a cpu PERFORMANCE HIT especially noticeable on low cost shared hosting environments. doing daily maintenance or weekly maintenance keeps everything running efficiently. remember I hate slow performing websites
so I always try to find a way to avoid adding something new and then only to find its a performance hit..

so example.. 10 visitors to your site all simultaneously calling millions of rows from your database  result equals big slow down !!

in the download if you read the set up guide mbx5mysqlsetup.pdf you will see how i set it all up without any use of cron jobs and added a small maintenace script to run at end of each day at 00:00 . in the setup guide there are images to help . snippet below. as always available at https://weather34.com/homeweatherstation and is running at https://weather34.com

*note only this version MB-X5MYSQL and a WF-X5 weatherflow version of the template will receive any further development. the other versions what is available today is has far Im going with them i.e. weather display,cumulus,ws1001 and the standard NON api meteobridge version.

so only MB-X5MYSQL & WF-X5(not released yet) will be developed on. the other downloads as they are are fully working and there is a good amount of forum support for those if needed from many weather enthusiasts which use the those versions.

1.enter your phpmyadmin screen via cPanel
or whichever method you use to access.
2.create a database called weatherstation
3.select / highlight database called weatherstation
4.now import the weatherstation.sql file
provided in the download .



if all was done correctly you should see something
like above screenshots. *note it contains sample
data this has to be removed before you connect
your meteobridge to the database.

now empty the database using the operations tab
and TRUNCATE .


Part 2.
meteobridge setup , meteobridge is going to
do all the work for us . *note we do not need any
cron job services or setup of cron job we are going to
simulate and let meteobridge do everything.

these files are in the folder /mdbfiles
stationcron.php
1.select services tab shown above
2.GOTO new select  service and choose
HTTP REQUEST
3.GOTO select event type and choose
PERIODICALLY
4.set the stationcron.php url to run
every 15 minutes.

addtoyear.php
1.GOTO new select  service and choose
HTTP REQUEST
3.GOTO select event type and choose
Specific Time
4.set the addtoyear.php url to run
every 23:45.

empty.php
1.GOTO new select  service and choose
HTTP REQUEST
3.GOTO select event type and choose
Specific Time
4.set the empty.php url to run
every 00:00.

you can manually test these but please empty
the tables via (TRUNCATE) method afterwards.

easyweathersetup.php

open easyweathersetup.php  add in the following

1.add database username
2.add database password
3.database name weatherstation

then check other settings.

and save.
« Last Edit: October 06, 2017, 04:40:15 AM by weatherist34 »
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #126 on: October 07, 2017, 04:47:15 AM »
(Updated 7th October 2017)
(Update fixes for conversions of metric to non metric in the charts,also windgust correction .missed apikey for forecast fixed tnx Josep)
34-X5 MB-X5SQL (4.1MB)
 

https://weather34.com/homeweatherstation/



brian
« Last Edit: October 07, 2017, 05:36:53 AM by weatherist34 »
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline prestwickwx

  • Member
  • *
  • Posts: 49
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #127 on: October 09, 2017, 10:40:40 AM »
good morning you can now download the MYSQL version which is kind of exclusive to the meteobridge API users . i have included a set up guide in the download .

added database support this is exclusive for meteobridge users and my commitment to developing further solely for meteobridge .thanks to Boris
sorry it took so long to setup the meteobridge you sent many months ago but now I can focus properly and begin to really understand how it works
and a week in use Im seeing lots of benefits and possible ideas for the near future..

basically the meteobridge is doing everything from inserting in to database ,  creating chart files for year, month and daily maintenance which prevents the database becoming excessive in size i.e millions of rows which in time will drag your server to a slow performance , MYSQL is efficient but also realise there is a cpu PERFORMANCE HIT especially noticeable on low cost shared hosting environments. doing daily maintenance or weekly maintenance keeps everything running efficiently. remember I hate slow performing websites
so I always try to find a way to avoid adding something new and then only to find its a performance hit..

so example.. 10 visitors to your site all simultaneously calling millions of rows from your database  result equals big slow down !!

in the download if you read the set up guide mbx5mysqlsetup.pdf you will see how i set it all up without any use of cron jobs and added a small maintenace script to run at end of each day at 00:00 . in the setup guide there are images to help . snippet below. as always available at https://weather34.com/homeweatherstation and is running at https://weather34.com

*note only this version MB-X5MYSQL and a WF-X5 weatherflow version of the template will receive any further development. the other versions what is available today is has far Im going with them i.e. weather display,cumulus,ws1001 and the standard NON api meteobridge version.

so only MB-X5MYSQL & WF-X5(not released yet) will be developed on. the other downloads as they are are fully working and there is a good amount of forum support for those if needed from many weather enthusiasts which use the those versions.

1.enter your phpmyadmin screen via cPanel
or whichever method you use to access.
2.create a database called weatherstation
3.select / highlight database called weatherstation
4.now import the weatherstation.sql file
provided in the download .



if all was done correctly you should see something
like above screenshots. *note it contains sample
data this has to be removed before you connect
your meteobridge to the database.

now empty the database using the operations tab
and TRUNCATE .


Part 2.
meteobridge setup , meteobridge is going to
do all the work for us . *note we do not need any
cron job services or setup of cron job we are going to
simulate and let meteobridge do everything.

these files are in the folder /mdbfiles
stationcron.php
1.select services tab shown above
2.GOTO new select  service and choose
HTTP REQUEST
3.GOTO select event type and choose
PERIODICALLY
4.set the stationcron.php url to run
every 15 minutes.

addtoyear.php
1.GOTO new select  service and choose
HTTP REQUEST
3.GOTO select event type and choose
Specific Time
4.set the addtoyear.php url to run
every 23:45.

empty.php
1.GOTO new select  service and choose
HTTP REQUEST
3.GOTO select event type and choose
Specific Time
4.set the empty.php url to run
every 00:00.

you can manually test these but please empty
the tables via (TRUNCATE) method afterwards.

easyweathersetup.php

open easyweathersetup.php  add in the following

1.add database username
2.add database password
3.database name weatherstation

then check other settings.

and save.

Brian,

This looks great. I am planning on giving it a try. One question - when I create a database my hosting services adds a prefix to the database name. Example username_weatherstation. Will this create any path issues when importing your weather.sql file?

Thanks,

Chuck

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #128 on: October 09, 2017, 11:00:43 AM »
Hello

First grab today’s update 9th oct few little enhancements and features added on.

Should be fine with your config . Just import ..brian

https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline prestwickwx

  • Member
  • *
  • Posts: 49
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #129 on: October 09, 2017, 03:53:41 PM »
Hello

First grab today’s update 9th oct few little enhancements and features added on.

Should be fine with your config . Just import ..brian

I gave it a whirl, but I seem to have some issues. Perhaps a permissions problem. Not showing forecast data or max-min wind. I setup a user for the database, but it does not seem to be populating from WU.

http://myrtlebeachweather.org/hwst/

Thanks,

Chuck


Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #130 on: October 09, 2017, 04:20:43 PM »
hello

this is very different from previous versions your http://myrtlebeachweather.org/hwst/mbridge/MBrealtimeupload.txt is completely empty ..

so i dont know where the data displayed on your site is coming from ..

note this does not use the same paths as previous non mysql versions

i did include a setup guide in the download see example attached .

when running the stationcron.php it returns could not fetch records .

you dont have much luck do you :-)

so either dbase not created ? or username/password incorrect or incorrect database name added . it is looking for weatherstation .

pm password to easysetup i will take a peek in the morning ..

brian






https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #131 on: October 10, 2017, 01:58:20 AM »
some updates this morning .

1.Boris has updated the API output , these now include trend data for temperature,humidity,dewpoint,indoor temp,indoor humidity .
you will need to reboot meteobridge to see the new values used.
2.updated template to use new API values
3.added a description at the easyweathersetup.php to show how to set the API url in the meteobridge network panel for HOMEWEATHERSTATION..see screenshot

*please ensure the API url is set like below as shown with http://yourdomain/mbridge/mb.php

or it could be http://yourdomain/pws/mbridge/mb.php depending where template resides.




brian
« Last Edit: October 10, 2017, 05:32:39 AM by weatherist34 »
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #132 on: October 10, 2017, 12:32:14 PM »
Hello

First grab today’s update 9th oct few little enhancements and features added on.

Should be fine with your config . Just import ..brian

I gave it a whirl, but I seem to have some issues. Perhaps a permissions problem. Not showing forecast data or max-min wind. I setup a user for the database, but it does not seem to be populating from WU.

http://myrtlebeachweather.org/hwst/

Thanks,

Chuck

Glad you got it all,working we learn something new everyday this time next year you will be a database expert ... have fun my friend ..

Brian
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #133 on: October 10, 2017, 12:56:51 PM »
bug fix just updated download , fixed temperature trend just replace livedata.php from todays earlier download..

https://weather34.com/homeweatherstation/

brian

https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline prestwickwx

  • Member
  • *
  • Posts: 49
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #134 on: October 10, 2017, 01:12:52 PM »
Hello

First grab today’s update 9th oct few little enhancements and features added on.

Should be fine with your config . Just import ..brian

I gave it a whirl, but I seem to have some issues. Perhaps a permissions problem. Not showing forecast data or max-min wind. I setup a user for the database, but it does not seem to be populating from WU.

http://myrtlebeachweather.org/hwst/

Thanks,

Chuck

Glad you got it all,working we learn something new everyday this time next year you will be a database expert ... have fun my friend ..

Brian

Many thanks for your great work!

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #135 on: October 11, 2017, 03:50:41 AM »
GOOD MORNING

this for anyone who has not already setup the database i have created a two click solution (pretty standard stuff nothing extreme) no need to change or use if oyu are already up
and running .. *one note I should make updated with minor css fixes.the info folder replace two files inside , simply replace moondata.php sunindex.php

Revised 11 October 2017 two click solution

1. once you have added your database username and password to the easysetup panel shown below
2.for now just click save at the bottom we can go back and set all settings shortly
3.now run the file included in the download called createdb.php
4.this will create the database called  "weatherstation" it will also create the table for the template

ID time outsideTemp barometer raintoday UV windgustmph windSpeed radiation dewpoint rainrate direction date timestamp lightning

thats it ! it doesn't get any easier than this and shouldn't deter anyone who little or no experience of database use ! click and run the createdb.php after you have added your database username and password . screenshot of included pdf in download.


brian
« Last Edit: October 11, 2017, 04:01:29 AM by weatherist34 »
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline parsoli

  • Why do I live where the wind hurts my face?
  • Senior Member
  • **
  • Posts: 57
    • WX-PARSOLI
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #136 on: October 14, 2017, 06:07:23 PM »
Hi Brian,

Downloaded the latest and greatest.  Noticed in one of your online instructions (https://www.weather34.com/homeweatherstation/setupmeteobridge.html), you reference the /MDBFILES/ vs /MBDBFILES.  Something you may want to correct as your .zip does not contain a folder called /MDBFILES.

To my issue.  Rebooted Meteobridge, grabbed latest image today.  Loaded all files, created new DB in Ubuntu, ensured I updated and activated PHPv7.1, tested access to SQL via command line successfully, purged tables, etc...  All good.  Template looks fine except for some reason, forecast is in metric vs imperial.

But the big issue and question is this.  I can't get Meteobridge to connect to http://server/mbridge/mb.php.  If I put that into a webbrowser, I can hit a blank page.  So we know the page is good.  But Meteobridge throws an error. 
Error: Home Weather Station:

Try by IP, same thing.  If I shorten and point to http://server/mb.php, another error, but a different error.
Error: Home Weather Station: <br />

But, I'm getting raw data into my MBrealtimeupload.txt file.  Unsure how that's happening!  The MB is not pushing any data there via any configured Services for http.  Speaking of that, I setup the (3) HTTP uploads, can get to them in a web browser, yet when hitting "TEST" on each one, I'm getting various errors:

STATION CRON
2017-10-14 13:02:27 Error: Read error (Connection timed out) in headers. (no more tries)

ADD TO YEAR
2017-10-14 13:13:22 Error: #!/usr/local/bin/php.cli Couldn"t fetch records (no more tries)

EMPTY
2017-10-14 13:14:45 Error: #!/usr/local/bin/php.cli (no more tries)

My assumption is, MB API call to /mb.php isn't working as the script in there to offload data that will make it's way to the db isn't able to perform.  My db shows the table with all the fields but after the purge, there is no data, which makes sense.

Any thoughts on where to look?

Thanks,

Steve

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #137 on: October 15, 2017, 01:37:09 AM »
good morning

ignore the red cross some misleading bug in meteobridge . as you can see its generating the file so its not the big issue :-) check livedata panel for http upload response..

i have updated the setup guide and thanks for highlighting the typo error in your email you sent earlier
https://weather34.com/homeweatherstation/setupmeteobridge.html

example 1 : http://yourdomain/mbdbfiles/stationcron.php
example 2 : http://yourdomain/pws/mbdbfiles/stationcron.php
example 3 : http://yourdomain/mbridge/mbdbfiles/stationcron.php


STATION CRON
2017-10-14 13:02:27 Error: Read error (Connection timed out) in headers. (no more tries)

ADD TO YEAR
2017-10-14 13:13:22 Error: #!/usr/local/bin/php.cli Couldn"t fetch records (no more tries)

EMPTY
2017-10-14 13:14:45 Error: #!/usr/local/bin/php.cli (no more tries)

#!/usr/local/bin/php.cli  is this causing you an error with your server if so remove the 1st line line from each of the three files mentioned above.
i have also updated download and removed the lines however some servers may require it just have to deal with that when an issue arrives.

from the download you only need to add the mbdbfiles folder ! inside that folder are three files mentioned above.

for reference the user(name) that use to connect to database must have the correct privileges set to write to the database .

also note if your sending me emails always take into consideration time differences hence it may be some 12 hours before i RESPOND ..

brian








https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline parsoli

  • Why do I live where the wind hurts my face?
  • Senior Member
  • **
  • Posts: 57
    • WX-PARSOLI
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #138 on: October 15, 2017, 12:00:39 PM »
Thanks Brian.  I removed the #! line from stationcron.  Still no data hitting livedata.php.  No values in the database as well.
I check the SQL error.log and find nothing but startup routines

I've created a new user, applied full perms to all db's, config'd in your configuration page, rebooted meteobridge, apache and SQL and still no writing to db.  I can logon to MySql with this new username and password...

Meteobridge does report successful HTTP Upload...

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #139 on: October 15, 2017, 12:36:01 PM »
Path to MBrealtimeupload.txt ??

Would help if you provide a url , if it’s private them pm .


Brian..
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline parsoli

  • Why do I live where the wind hurts my face?
  • Senior Member
  • **
  • Posts: 57
    • WX-PARSOLI

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #141 on: October 15, 2017, 01:09:36 PM »
That’s working fine now send easyweathersetup pass by pm . Brian..
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #142 on: October 15, 2017, 01:49:09 PM »
https://weather.parsoli.net/mbridge/MBreal.....

template output is working fine im watching the wind change direction frequently however you need to resolve database connection, stationcron.php is working fine as forecast data is updating ok ..brian

https://weather.parsoli.net

ps not reacheable here in turkey only via VPN but its slow nothing todo with your server speed even the VPNs seem like there throttled now at ISP level :-(
https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline parsoli

  • Why do I live where the wind hurts my face?
  • Senior Member
  • **
  • Posts: 57
    • WX-PARSOLI
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #143 on: October 15, 2017, 02:09:35 PM »
Sorry, had someone port-scanning me heavily from Turkey so I blocked that country  :)  Back up now

So what will try to write to the DB?  StationCron is my assumption.
What is the purpose of livedata.php and is it an issue it is blank?

I can connect to that db using the credentials I put into the settings.  I need to better understand what or which php is trying to commit to db.

Thank you for looking at this Brian!



mysql> show tables;
+--------------------------+
| Tables_in_weatherstation |
+--------------------------+
| weatherstation           |
+--------------------------+
1 row in set (0.00 sec)

mysql> describe weatherstation;
+-------------+---------------+------+-----+-------------------+-----------------------------+
| Field       | Type          | Null | Key | Default           | Extra                       |
+-------------+---------------+------+-----+-------------------+-----------------------------+
| ID          | int(11)       | NO   | PRI | NULL              | auto_increment              |
| time        | text          | NO   | MUL | NULL              |                             |
| outsideTemp | decimal(10,1) | NO   |     | NULL              |                             |
| barometer   | decimal(10,2) | NO   |     | NULL              |                             |
| raintoday   | decimal(10,2) | YES  |     | NULL              |                             |
| UV          | decimal(10,0) | YES  |     | NULL              |                             |
| windgustmph | decimal(10,1) | NO   |     | NULL              |                             |
| windSpeed   | decimal(10,1) | NO   |     | NULL              |                             |
| radiation   | decimal(10,2) | YES  |     | NULL              |                             |
| dewpoint    | decimal(10,2) | YES  |     | NULL              |                             |
| rainrate    | decimal(10,2) | YES  |     | NULL              |                             |
| direction   | decimal(10,2) | NO   |     | NULL              |                             |
| date        | text          | NO   |     | NULL              |                             |
| timestamp   | timestamp     | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| lightning   | decimal(10,0) | YES  |     | NULL              |                             |
+-------------+---------------+------+-----+-------------------+-----------------------------+
15 rows in set (0.00 sec)

Offline weatherist34

  • its just my hobby
  • Forecaster
  • *****
  • Posts: 481
    • Sinanoba Istanbul Home Weather Station
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #144 on: October 15, 2017, 02:14:59 PM »
Sorry, had someone port-scanning me heavily from Turkey so I blocked that country  :)  Back up now

So what will try to write to the DB?  StationCron is my assumption.
What is the purpose of livedata.php and is it an issue it is blank?

I can connect to that db using the credentials I put into the settings.  I need to better understand what or which php is trying to commit to db.

Thank you for looking at this Brian!



mysql> show tables;
+--------------------------+
| Tables_in_weatherstation |
+--------------------------+
| weatherstation           |
+--------------------------+
1 row in set (0.00 sec)

mysql> describe weatherstation;
+-------------+---------------+------+-----+-------------------+-----------------------------+
| Field       | Type          | Null | Key | Default           | Extra                       |
+-------------+---------------+------+-----+-------------------+-----------------------------+
| ID          | int(11)       | NO   | PRI | NULL              | auto_increment              |
| time        | text          | NO   | MUL | NULL              |                             |
| outsideTemp | decimal(10,1) | NO   |     | NULL              |                             |
| barometer   | decimal(10,2) | NO   |     | NULL              |                             |
| raintoday   | decimal(10,2) | YES  |     | NULL              |                             |
| UV          | decimal(10,0) | YES  |     | NULL              |                             |
| windgustmph | decimal(10,1) | NO   |     | NULL              |                             |
| windSpeed   | decimal(10,1) | NO   |     | NULL              |                             |
| radiation   | decimal(10,2) | YES  |     | NULL              |                             |
| dewpoint    | decimal(10,2) | YES  |     | NULL              |                             |
| rainrate    | decimal(10,2) | YES  |     | NULL              |                             |
| direction   | decimal(10,2) | NO   |     | NULL              |                             |
| date        | text          | NO   |     | NULL              |                             |
| timestamp   | timestamp     | NO   |     | CURRENT_TIMESTAMP | on update CURRENT_TIMESTAMP |
| lightning   | decimal(10,0) | YES  |     | NULL              |                             |
+-------------+---------------+------+-----+-------------------+-----------------------------+
15 rows in set (0.00 sec)

Without the livedata.php the template wouldn’t work at all..

You need to look at user privileges, does the user weather have the permission to,write , reading is not the issue . Sorry I’m not at all familiar with your  server software .

Brian

https://www.weather34.com
tip ..does your site make more than 50-70 or more HTTP requests,you've probably answered the question why your site performs so slow !

Offline prestwickwx

  • Member
  • *
  • Posts: 49
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #145 on: October 23, 2017, 09:23:33 AM »
GOOD MORNING

this for anyone who has not already setup the database i have created a two click solution (pretty standard stuff nothing extreme) no need to change or use if oyu are already up
and running .. *one note I should make updated with minor css fixes.the info folder replace two files inside , simply replace moondata.php sunindex.php

Revised 11 October 2017 two click solution

1. once you have added your database username and password to the easysetup panel shown below
2.for now just click save at the bottom we can go back and set all settings shortly
3.now run the file included in the download called createdb.php
4.this will create the database called  "weatherstation" it will also create the table for the template

ID time outsideTemp barometer raintoday UV windgustmph windSpeed radiation dewpoint rainrate direction date timestamp lightning

thats it ! it doesn't get any easier than this and shouldn't deter anyone who little or no experience of database use ! click and run the createdb.php after you have added your database username and password . screenshot of included pdf in download.


brian

Brian,

I see you have been busy updating the template! Quick question. Are they any special instructions for updating? My database has been up and running. I assume all I need to do for updates is to just overwrite with the updated files and re-enter the information in the easyweathersetup. Same procedure that we used on the old template, prior to the SQL version.

Thanks,

Chuck
« Last Edit: October 29, 2017, 08:06:34 AM by prestwickwx »

Offline Atlantic21

  • Member
  • *
  • Posts: 7
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #146 on: November 11, 2017, 08:53:54 AM »
Firstly i can not thank Brian enough for his help have just changed web provider.new web site www.ilfracombeweather.info/pws/index.php most of the time it is user error on my part
the temperatures for the day graphs are reading to high for UK (+30 ) no idea where this information is coming from
no values for month and year.
day values for wind graph are ok no values for month and year.
day values for rain are ok again no values for month and year.
how do I change the rain total for month and year ref the box to left of the rain gage
The database is being populated in MySQL
this is all using Meteobridge

Many thanks for any help or ideas Richard

Offline docbee

  • Moderator
  • Forecaster
  • *****
  • Posts: 592
    • smartbedded
Re: HOMEWEATHERSTATION TEMPLATE with meteobridge options
« Reply #147 on: November 12, 2017, 02:37:45 AM »
I got notice that the service gets a red mark on "weather network" tab, when "mb.php" is not located at root level but in the folder "mbridge". I have some code in beta to avoid this. Anybody facing this issue who wants to try this beta code? All I need is your MBs MAC. If you are interested to give it a try, please send to "info(at)meteobridge.com".
founder of smartbedded.com - home of meteohub, meteoplug, meteobridge, meteostick