I am looking to add information into my archive database that will show rainfall over the last 24 hours.
Today, I have the influxdb extension, and when I look in the influxdb, I see a measurement for "rain24_in". I would like for this to also appear within the mysql DB that I am using. I currently have "rain" and "rainRate" in mysql DB, but nothing about 24hour rainfall. How can I accomplish this? Relevant pieces of my weewx.conf: ############################################################################## # This section is for uploading data to Internet sites [StdRESTful] [[Influx]] host = tick.home database = weewx binding = loop log_success = False ############################################################################## # This section is for configuring the archive service. [StdArchive] # If the station hardware supports data logging then the archive interval # will be downloaded from the station. Otherwise, specify it (in seconds). archive_interval = 300 # If possible, new archive records are downloaded from the station # hardware. If the hardware does not support this, then new archive # records will be generated in software. # Set the following to "software" to force software record generation. record_generation = hardware # Whether to include LOOP data in hi/low statistics loop_hilo = True # The data binding used to save archive records data_binding = wx_binding ############################################################################## # This section binds a data store to a database. [DataBindings] [[wx_binding]] # The database must match one of the sections in [Databases]. # This is likely to be the only option you would want to change. database = archive_mysql # The name of the table within the database table_name = archive # The manager handles aggregation of data for historical summaries manager = weewx.wxmanager.WXDaySummaryManager # The schema defines the structure of the database. # It is *only* used when the database is created. schema = schemas.wview.schema ############################################################################## # This section defines various databases. [Databases] # MySQL [[archive_mysql]] database_type = MySQL database_name = weewx ############################################################################## # This section defines defaults for the different types of databases. [DatabaseTypes] # Defaults for MySQL databases [[MySQL]] driver = weedb.mysql # The host where the database is located host = <REDACTED> # The user name for logging in to the host user = <REDACTED> # The password for the user name. Put in quotes to guard against parsing errors. password = <REDACTED> -- You received this message because you are subscribed to the Google Groups "weewx-user" group. To unsubscribe from this group and stop receiving emails from it, send an email to weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.