WDMYSQL Problem

Archive Archived Weather Display Problems
1

Hi

I don’t think this is a problem with wdmysql, i think it is a problem with my os (xp prof).

The problem is:

Wdmysql starts when I boot and when I start it manually, its in the process list as running. It has stopped appearing in the task bar. and i cannot get to the gui screen. Also it has stopped updating the dbase.

What should I check to see if i have a setting wrong, or an error in the registry ?

Thanks

Keith

Currently i am on xp sp2 amd WD 10.17x

2

hi
is that vers 2.5 of wdmysql?
maybe its being blocked by a firewall,…and cant connect
(it then wont show until it has)

3

Brian

its version 2.6. Curiously it is running this morning, it started around 18:30 last night, so it took around 2 hours to get going !

Its probable I have a configuration problem in MYSQL, two dbases one Weather_data and one Windy one both with wx_data files in.

I’ll tidy that up and see how it goes

thanks

Keith

4

MySQL can happily have a wx_data table in every database on the server, so that’s not your problem. Database fields are more correctly defined as:

databasename.tablename.fieldname

So you can have the same table or field in many databases and the same field in many tables.

I should add that I have two wx_data tables in two databases on the server we’re using now.

5

Thanks for that.

i’ve given up on solving the problem for the moment, I just wait till next morning and its working. Curious thing over the last week I have twice found another instance of the programme running.

Any Ideas ?

Thanks

Keith

6

are you using the wdwatch at all?

7

Hi Brian

Yes watch=dog ver 1.1

8

Brian

I have more info on the failure of WDMYSQL to start.

Stopping the MYSQL service immediatly brings WDMYSQL to life and in the task bar.

In the log file I get this:

09:31:07 - STATUS Connecting [Connect] 0

09:31:07 - STATUS Active Connect to mySQL Server 0

  • ERROR MySQL server has gone away
    09:33:01 - STATUS Active Add Entry 0
    09:34:00 - STATUS Active Add Entry 0
    09:35:00 - STATUS Active Add Entry 0
    09:36:00 - STATUS Active Add Entry 0

You can see where I stopped the service

9

bacwak,

I have exactly the same problem. I have just spotted that wdmysql was fixed from a bug it used to have of getting getting slower and slower so I am trying using it again after giving up some time ago due to the performance problem. But I am having the same problem as you namely no notification area icon (or data added) until mysql service is stopped wherupon the icon appears and can be double clicked to bring the windo up.

Upon restarting wdmysql connectes to the database and starts adding records to my database. Is this what you are seeing?

Maybe we can compare notes and see if anything is in common.

Firstly Win XP SP2.
MySQL version 4.0.20a.
I also get an entry in the Application Logs: Hanging application wdmysql.exe, version 9.5.2.0, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

Any similarities?
Regards,
Adrian

10

Hi Adrian

For the first part yes thats all the same.

I’m on XP Pro sp2 but I doubt that makes any difference. I’m not getting the message in the event log (applications)though, or am I looking in the wrong place ?. I’m not that good with MySQl , is there a logging facility that may show the problem ?

Cheers

Keith

11

What platform are you running MySQL on? On Linux you can add entries into /etc/my.cnf to turn on debugging logging (to various levels). I’ve used the debug logs to watch the low level interactions between WDMYSQL and a database, so I know you can get a lot of info out of the MySQL server if you really want it.

12

Thanks Chris

I was trying to avoid this but it looks like i will have to go the the MYSQL site and read the manual to turn the logging on !!! :lol:

when I get the command I will poste it here

I’m using Windows xp pro

Cheers

Keith

13

ok

the command to start logging is --log

this needs to be at the end of the startup command line. I did this manually and the log file appeared in the data directory.

cheers

Keith

14

There’s more, in the data directory there is a .err file

Reading the log file there are some strange commands and messages.

Where I would have expected an INSERT command there’s this "1 Connet username@localhost 1 Query REPLACE INTO wx_data "

Neither of the files are reoporting the connection problem. I have gone through a reboot, WDMYSQL failed to start. Stopped the MYSQL service, WDMSYL appeared in the system tray and when I started MYSQL again all was OK. Still nothing in the log file. I’ll leave it overnight and see if it picks up anything

cheers

Keith

15

hi
try the wdmysql version that comes with wd 10.19j
as chris and i have fixed a problem with it not using insert correctly
maybe that will help

16

Brian is correct. I found a fault in the library he was using that meant that each time he tried to use INSERT the library would use REPLACE. REPLACE requires DELETE privilege as well as INSERT privilege, so if you haven’t given your user those rights you will get errors.

17

I tried 10.19j but it does not help. I still dont get the tray icon until i end/restart the MySQL service… then everything is OK.
Adrian

18

Thank for the responses

I have installed the new version but I’m still getting the same problem with connection.
The log file has this "041109 8:34:50 6 Connect user@localhost on windy 6 Create DB windy "
Its the create that I find curious.

Cheers

Keith

19

i can change that…
i have a use and a create for the table, the later is most likely not needed

20

try 2.9 vers:
http://www.weather-display.com/downloadfiles/Wdmysql.zip