Hello, Daniel Could you include more of the log? It would help to understand the context of the error. Include it from the initial weewx startup.
-tk On Sun, Jan 15, 2017 at 5:50 PM, Dan'l B <[email protected]> wrote: > Trying to get the MySQL DB working in WeeWx on a Mac. > Is this a known error? The related topics here in the group were way too > complex for my circumstances. > > 15/1/2017 20:41:49.326 sudo[5627]: house : TTY=ttys002 ; >>> PWD=/Users/Shared/weewx ; USER=root ; COMMAND=bin/weewxd weewx.conf >> >> 15/1/2017 20:41:50.407 weewx[5628]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 20:41:50.407 weewx[5628]: **** Waiting 2 minutes then >>> retrying... >> >> 15/1/2017 20:43:50.412 weewx[5628]: engine: retrying... >> >> 15/1/2017 20:43:50.423 weewx[5628]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 20:43:50.423 weewx[5628]: **** Waiting 2 minutes then >>> retrying... >> >> 15/1/2017 20:45:50.424 weewx[5628]: engine: retrying... >> >> 15/1/2017 20:45:50.434 weewx[5628]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 20:45:50.434 weewx[5628]: **** Waiting 2 minutes then >>> retrying... >> >> >> > The MySQL server is a local install on the Mac > OSX El Cap > WeeWx 3.6.2 > Simulator mode > The DB user has full privileges and I can connect to the DB using Sequel > Pro with the user name/pwd. > debug = 1 > > > weewx.conf: > > [[wx_binding]] >> >> # The database should match one of the sections in [Databases] >> >> database = weewx_archive >> >> # The name of the table within the database >> >> table_name = archive >> >> # The class to manage the database >> >> manager = weewx.wxmanager.WXDaySummaryManager >> >> # The schema defines to structure of the database contents >> >> schema = schemas.wview.schema >> >> >>> ############################################################ >>> ################## >> >> >>> # This section defines various databases. >> >> >>> [Databases] >> >> >> >> # A SQLite database is simply a single file >> >> [[archive_sqlite]] >> >> database_type = SQLite >> >> database_name = weewx.sdb >> >> >> >> # MySQL >>> >> [[weewx_archive]] >> >> database_type = MySQL >> >> # database_name = weewx >> >> database_name = weewx_archive >> >> driver = weedb.mysql >> >> # The host where the database is located >> >> host = localhost >> >> # The user name for logging in to the host >> >> user = weewx_user >> >> # The password for the user name >> >> password = ********** >> >> >>> >>> ############################################################ >>> ################## >> >> >>> # This section defines defaults for the different types of databases. >> >> >>> [DatabaseTypes] >> >> >> >> # Defaults for SQLite databases >> >> [[SQLite]] >> >> driver = weedb.sqlite >> >> # Directory in which the database files are located >> >> SQLITE_ROOT = %(WEEWX_ROOT)s/archive >> >> >> >> # Defaults for MySQL databases >>> >> [[MySQL]] >> >> driver = weedb.mysql >> >> # The host where the database is located >> >> host = localhost >> >> # The user name for logging in to the host >> >> user = weewx_user >> >> # The password for the user name >> >> password = ************ >> >> >>> ############################################################ >>> ################## >> >> -- > 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]. > For more options, visit https://groups.google.com/d/optout. > -- 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]. For more options, visit https://groups.google.com/d/optout.
