Yes, error on my part typing that, apologies. On Monday, January 16, 2017 at 12:50:05 AM UTC-5, Andrew Milner wrote: > > Your answer confuses me. .sdb files are related to SQLite and not MySQL - > which are you trying to use?? > > > > On Monday, 16 January 2017 07:38:59 UTC+2, Dan'l B wrote: > >> 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.
