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 <[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.
