Yes, and in the eight minutes after I started it it created no .sdb files nor any reports in public_html
On Monday, January 16, 2017 at 12:36:45 AM UTC-5, Andrew Milner wrote: > > 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 <dan.hi...@gmail.com> 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 weewx-user+...@googlegroups.com. >>>> 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 weewx-user+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.
