No mysql inserts

[Ben Barker]

Hi,

I had wfrog running succesfully logging to CSV

I have imported this data into mysql, using the schema given, and the website still works. Running with verbose output, I can see every refresh of the webpage generates a "SELECT" statement from the db to draw trhe plots. 

However, no new data is being inserted into the database, and I can't work out why.

I am using python 2.7, so had to use the workaround described at the bottom of this thread:

https://code.google.com/p/wfrog/issues/detail?id=85

To get it running at all. Any idea why I am not inserting new data...

[Roland Ehle]

Hi,

you need to check your /etc/wfrog/wfcommon/config/storage.yaml file. Make sure you have the mysql configuration part uncommented.

Regards,

Roland

[Ben Barker]

Thanks - unfortunately I don't know quite what was wrong, but now it isn't :-)

http://bbarker.dtdns.net/weather/

[Szopler]

Hi!
I changed storage.yaml to:

#storage: !user
#    choices:
#        root: !csv
#            path: /var/lib/wfrog/wfrog.csv
#        default: !csv
#            path: data/wfrog.csv

#storage: !firebird { database: 'localhost:/var/lib/firebird/2.0/data/wfrog.db',
#                     user: sysdba,
#                     password: masterkey }

storage: !mysql { database: wfrog,
                  host: localhost,
                  user: root,
                  password: secret }

But there is no data in mysql table METEO.

[Federico Osvald]

Any news on this topic?

[Jordi Puigsegur Figueras]

Hi,

Any entry on wflogger.log?

Jordi.

--
You received this message because you are subscribed to the Google Groups "wfrog-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to wfrog-users...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Federico Osvald]

I have got mistakes. 

It seems that the connection with the DB is broken!

I have created the appropriate mysql database. Which plugin should I install to connect python with mysql?

I am running a QNAP TS-220 with OS 4.1.1 and a WMR88A weather station. CSV works perfectly, with the database nothing is working.

Can you help me?

[Jordi Puigsegur Figueras]

To use mysql in wfrog you need to install python-mysqldb (http://code.google.com/p/wfrog/wiki/CustomizationGuide#Mysql) and then make the necessary changes in  config files (which seem ok in your mail). If you don't say which error you are getting in the logs we cannot help further ...

Jordi.