MySQL Settings Help
Posted: Sat 06 Feb 2016 10:21 pm
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
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