Weather-Watch.com

Weather Display => WD Questions => Topic started by: wxgeek on May 16, 2016, 09:54:17 PM

Title: WD and the SQL Database Setup
Post by: wxgeek 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
Title: Re: WD and the SQL Database Setup
Post by: meteo 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 =-
Title: Re: WD and the SQL Database Setup
Post by: Weather Display on May 18, 2016, 04:39:15 AM
@ [email protected]
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
Title: Re: WD and the SQL Database Setup
Post by: GW400 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?
Title: Re: WD and the SQL Database Setup
Post by: GW400 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?
Title: Re: WD and the SQL Database Setup
Post by: Weather Display 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?
Title: Re: WD and the SQL Database Setup
Post by: GW400 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.
Title: Re: WD and the SQL Database Setup
Post by: niko 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.
Title: Re: WD and the SQL Database Setup
Post by: bitsostring 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. . .
 
Title: Re: WD and the SQL Database Setup
Post by: niko 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...
Title: Re: WD and the SQL Database Setup
Post by: GW400 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?