Page 1 of 1

MySQL Settings Help

Posted: Sat 06 Feb 2016 10:21 pm
by mike101
Hi. I just got CumulusMX working on my Raspberry Pi and uploading to WeatherUnderground. I have to say, what a fine job you guys do. I really appreciate the work, it's a fantastic piece of software!

The last piece I would like to set up is to have it dump the data in a MySQL database. I created a new schema/user, filled in the connection details, and clicked the "Create Realtime", "Create Monthly", and "Create Daily" table buttons. The tables were created perfectly. I see it inserted 3 records in to the monthly table at what seem to be 10 minute intervals, but it is not inserting anything in to the Realtime table. Am I missing something here? My settings are below. Running MySQL 5.6.

Thank you!


[MySQL]
Host=home.****.net
Port=48965
User=cumulusmx
Pass=****
Database=weatherdata
MonthlyMySqlEnabled=1
RealtimeMySqlEnabled=1
DayfileMySqlEnabled=1
MonthlyTable=Monthly
DayfileTable=Dayfile
RealtimeTable=Realtime
RealtimeRetention=
CustomMySqlSecondsCommandString=
CustomMySqlMinutesCommandString=
CustomMySqlRolloverCommandString=
CustomMySqlSecondsEnabled=0
CustomMySqlMinutesEnabled=0
CustomMySqlRolloverEnabled=0
CustomMySqlSecondsInterval=10
CustomMySqlMinutesIntervalIndex=6

Re: MySQL Settings Help

Posted: Mon 08 Feb 2016 7:56 am
by steve
Do you have 'Enable Realtime' selected in the Web/FTP settings on the Internet Settings page? Is it updating the realtime.txt file in the installation folder? Have you tried restarting Cumulus?

Re: MySQL Settings Help

Posted: Mon 08 Feb 2016 1:40 pm
by mike101
I didn't realize that I had to have EnableRealtime set under the [FTP] directive even though I'm not using FTP. That fixed it perfectly. Thank you!

PS: Made a small donation to show my appreciation :)