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] > <javascript:>> 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] <javascript:>. >> 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.
