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.
