cloudy cloudy

Author Topic: WD and the SQL Database Setup  (Read 2383 times)

0 Members and 1 Guest are viewing this topic.

Offline wxgeek

  • Posts: 10
  • OS/Browser:
  • Win NT 10.0
  • Firefox 46.0
WD and the SQL Database Setup
« on: May 16, 2016, 09:54:17 PM »
I've read the file readmedatabase.txt. The first thing it says is to download the WDdatabase program. I've looked at the web site download section and cannot find anything with that name. I'm using version 10.37R build 80. Just need a little help!

Jim

Offline meteo

  • Davis VP2+ FARS/solar/UV
  • Posts: 162
  • France (SE)
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Firefox 46.0
    • Météo Turbie
Re: WD and the SQL Database Setup
« Reply #1 on: May 17, 2016, 10:27:01 PM »
Hi,

At first I would suggest updating to latest version of WD. Mods
have been made since your vers. regarding mySQL.

After, Control Panel -> MYSQL Database

There, set up paramters for your mySQL database.  Ringt buton on 'On', Save.

Next clion Run the wdmysql.exe program now

Depending on the Windows version you have, you can
access this program any time if running, n the bottom left of your screen
the little up triangle, left clic, you should seen an icon kind of vertical blue tube (barrel).
Left clic and choose   show.

You shouls now have the WDMYSQL vers 10.7 showing.

Do what you wish, but.    DO NOT use 'Setup custom' it does NOT work.

Hope it help.

Other solution writing your own php script to maintain a mySQL data base
structured as you wish and getting data from your  testtags.php file.
Run as cron job every xx minutes.

Regards.

-= Guy =-

    ................................... Updated each 5 minutes ...................................
W7 64b

Offline Weather Display

  • Posts: 87,209
  • Davis VP2
  • New Zealand
  • OS/Browser:
  • Win NT 10.0
  • Chrome 50.0.2661.94
    • Weather Display
Re: WD and the SQL Database Setup
« Reply #2 on: May 18, 2016, 04:39:15 AM »
@ wxgeek@comcast.net
that is the for the MS Database , which is old technology
the download link is
http://www.weather-display.com/downloadfiles/wddatabasesetup.zip

as suggested you might be better to use the MYSQL support

Offline GW400

  • Posts: 83
  • Klepp, Norway
  • OS/Browser:
  • Win NT 10.0
  • Chrome 71.0.3578.98
Re: WD and the SQL Database Setup
« Reply #3 on: February 04, 2019, 07:03:28 AM »
Brian,
The setup does not work on newer versions of Windows.
Is there a more recent version?
Also, where can I find reliable documentation for using MySQL to store WD data?
Regards G400

Offline GW400

  • Posts: 83
  • Klepp, Norway
  • OS/Browser:
  • Win NT 10.0
  • Chrome 71.0.3578.98
Re: WD and the SQL Database Setup
« Reply #4 on: February 04, 2019, 09:15:33 AM »
Installed MySQL v8.0
Created an empty database named wdmysql
Created a user and granted all privileges to database wdmysql
Launched WDMYQL v. 10.7 from Control Panel

Status in WDMYSQL:
Login OK to localhost
Database wdmysql opened OK

When click on "Create table" I get the error : SELECT command denied to user 'xxx'@'localhost' for table 'weatherdata'

1 - Any hints on what can be wrong?
2 - I can create the table myself, but I will need documentation of the schema. Where can I find this?
Regards G400

Offline Weather Display

  • Posts: 87,209
  • Davis VP2
  • New Zealand
  • OS/Browser:
  • Win NT 10.0
  • Chrome 71.0.3578.98
    • Weather Display
Re: WD and the SQL Database Setup
« Reply #5 on: February 05, 2019, 12:21:03 AM »
that sounds like a permissions problem
if you can create the table yourself, then I would do that

what is with all the grave digging pots?

Offline GW400

  • Posts: 83
  • Klepp, Norway
  • OS/Browser:
  • Win NT 10.0
  • Chrome 72.0.3626.81
Re: WD and the SQL Database Setup
« Reply #6 on: February 06, 2019, 09:24:16 PM »
It is no digging for anything, just polite asking for documentation of table structure etc. that can help us to get going storing our data in MySQL.
Regards G400

Offline niko

  • syzygy
  • Global Moderator
  • Posts: 28,171
  • Crystal Ball broken! Please post the URL.
  • Northern California, U.S.A.
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 71.0.3578.98
Re: WD and the SQL Database Setup
« Reply #7 on: February 06, 2019, 10:42:14 PM »
Forum "gravedigging" refers to re-opening old threads. It would be easier to keep up with your questions if you started a new thread and continued to address your issues in one place.

Offline bitsostring

  • Posts: 975
  • Oregon Scientific WMR200
  • Edinburgh, U.K.
  • OS/Browser:
  • Win NT 10.0
  • Chrome 64.0.3282.140
    • Home Weather Station
Re: WD and the SQL Database Setup
« Reply #8 on: February 07, 2019, 12:08:45 AM »
It would be easier to keep up with your questions if you started a new thread and continued to address your issues in one place.

Difficult one. Members are advised to search the forum for answers before posting, so may cotton on to an old thread. And if we post a new thread without searching we are often told the problem was solved way back when. . .
 
It's meant to be fun. . .

Offline niko

  • syzygy
  • Global Moderator
  • Posts: 28,171
  • Crystal Ball broken! Please post the URL.
  • Northern California, U.S.A.
  • OS/Browser:
  • Win 7/Srvr 2008R2
  • Chrome 71.0.3578.98
Re: WD and the SQL Database Setup
« Reply #9 on: February 07, 2019, 12:34:06 AM »
Difficult one. Members are advised to search the forum for answers before posting, so may cotton on to an old thread. And if we post a new thread without searching we are often told the problem was solved way back when. . .

If the old thread had the solution there would be no reason to re-open it...

Offline GW400

  • Posts: 83
  • Klepp, Norway
  • OS/Browser:
  • Win NT 10.0
  • Chrome 72.0.3626.81
Re: WD and the SQL Database Setup
« Reply #10 on: February 07, 2019, 04:15:26 PM »
And if it had, wouldn't it be better to share that information instead of serving vague hints?
Regards G400

 

cumulus