You're leaving out a lot of details, in particular, how you are using the second database in your report.
But, is it possible that it *is* working, but the databases have identical content? After all, they both come from the simulator. You can use the tool sqlite3 to see what's in the databases. On Thu, Aug 6, 2020 at 6:18 AM George Alexander <[email protected]> wrote: > > Good evening, > > I have been trying, thus far without success, to display the measurements > from two separate databases of weewx on the one report. > > I have installed weewx using the setup.py method, and followed the > instructions to allow multiple instances of weewx to run on the same ubuntu > server - one called "fousb", the other "wh2950". Both are running fine > (using only the simulator to provide input data initially while I prove the > concept). > > I then followed the instructions on binding a second database, the details > of which are posted below. This has been done in the "fousb.conf' file to > bind the 'wh2950' database to it. Running the "fousb" instance with debug=1 > is producing no errors, however there appear to be no extra data fields or > points from the WH2950 showing in the SeasonsReport html output for the > fousb. > > "fousb" has been restarted multiple times, and I have also deleted the > fousb.sdb file and tried restarting it again too. I'm sure I am missing > something obvious; a pointer in the right direction would be a great help. > > Thanks. > > > > [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_sqlite > # The name of the table within the database > table_name = archive > # The manager handles aggregation of data for historical summaries > manager = weewx.manager.DaySummaryManager > # The schema defines the structure of the database. > # It is *only* used when the database is created. > schema = schemas.wview_extended.schema > > > [[wh2950_binding]] > # Binding for WH2950 > database = wh2950_sqlite > # The name of the table within the databse > table_name = archive > # The class to manage the database > manager = weewx.manager.DaySummaryManager > # The schema defines the structure of the database contents > schema = schemas.wview_extended.schema > > > > ############################################################################## > > > # This section defines various databases. > > > [Databases] > > > # A SQLite database is simply a single file > [[archive_sqlite]] > database_name = fousb.sdb > database_type = SQLite > > > [[wh2950_sqlite]] > database_name = wh2950.sdb > database_type = SQLite > > > # MySQL > [[archive_mysql]] > database_name = fousb > database_type = MySQL > > > -- > 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 [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/weewx-user/11f37b5b-fb67-473f-aebb-79e26170140co%40googlegroups.com > <https://groups.google.com/d/msgid/weewx-user/11f37b5b-fb67-473f-aebb-79e26170140co%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/CAPq0zEC0GmEcoE-bcz%3DAoKAj7p-zoc_6%2BZ%2BX%2B2fDr%2B6nmRFx-Q%40mail.gmail.com.
