When you removed the installation did you also remove and delete the archive database and let weewx create the database and necessary tables when it first runs?
On Monday, 16 January 2017 06:51:03 UTC+2, Dan'l B wrote: > On Sunday, January 15, 2017 at 9:19:57 PM UTC-5, Tom Keffer wrote: >> >> 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. >>> >> >> > Removed the installation and did a completely clean install. > Started from command line: sudo ./bin/weewxd weewx.conf and there is no > display in the terminal window. > Console (syslog) with grep for weewx > >> 15/1/2017 23:41:54.071 sudo[2015]: house : TTY=ttys000 ; >>> PWD=/Users/house/Documents/weewx-orig ; USER=root ; COMMAND=./bin/weewxd >>> weewx.conf >> >> 15/1/2017 23:41:55.516 weewx[2017]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 23:41:55.516 weewx[2017]: **** Waiting 2 minutes then >>> retrying... >> >> 15/1/2017 23:43:55.518 weewx[2017]: engine: retrying... >> >> 15/1/2017 23:43:55.533 weewx[2017]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 23:43:55.533 weewx[2017]: **** Waiting 2 minutes then >>> retrying... >> >> 15/1/2017 23:45:55.533 weewx[2017]: engine: retrying... >> >> 15/1/2017 23:45:55.552 weewx[2017]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 23:45:55.552 weewx[2017]: **** Waiting 2 minutes then >>> retrying... >> >> 15/1/2017 23:47:55.556 weewx[2017]: engine: retrying... >> >> 15/1/2017 23:47:55.570 weewx[2017]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 23:47:55.570 weewx[2017]: **** Waiting 2 minutes then >>> retrying... >> >> 15/1/2017 23:49:55.570 weewx[2017]: engine: retrying... >> >> 15/1/2017 23:49:55.578 weewx[2017]: engine: Caught database >>> OperationalError: (1054, "Unknown column 'usUnits' in 'field list'") >> >> 15/1/2017 23:49:55.579 weewx[2017]: **** Waiting 2 minutes then >>> retrying... >> >> >> > > -- 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.
