Yes, sorry, I was away for the weekend so didn't get a chance to answer.
Let's answer the last question first: For the intents of this discussion I
suppose the answer is that I have only one weewx.conf. But I have several
weewx installations running with each their database and each their own
weewx.conf. Apart from the fact that the skin uses some data from one of
the other databases (so there's a binding for that) there should be no
interaction between them. So I'd say there's only one weewx.conf file.
The output of show tables:
+---------------------------------------+
| Tables_in_weewxwftest |
+---------------------------------------+
| archive |
| archive_day_ET |
| archive_day_UV |
| archive_day__metadata |
| archive_day_altimeter |
| archive_day_appTemp |
| archive_day_appTemp1 |
| archive_day_barometer |
| archive_day_batteryStatus1 |
| archive_day_batteryStatus2 |
| archive_day_batteryStatus3 |
| archive_day_batteryStatus4 |
| archive_day_batteryStatus5 |
| archive_day_batteryStatus6 |
| archive_day_batteryStatus7 |
| archive_day_batteryStatus8 |
| archive_day_cloudbase |
| archive_day_co |
| archive_day_co2 |
| archive_day_consBatteryVoltage |
| archive_day_dewpoint |
| archive_day_dewpoint1 |
| archive_day_extraHumid1 |
| archive_day_extraHumid2 |
| archive_day_extraHumid3 |
| archive_day_extraHumid4 |
| archive_day_extraHumid5 |
| archive_day_extraHumid6 |
| archive_day_extraHumid7 |
| archive_day_extraHumid8 |
| archive_day_extraTemp1 |
| archive_day_extraTemp2 |
| archive_day_extraTemp3 |
| archive_day_extraTemp4 |
| archive_day_extraTemp5 |
| archive_day_extraTemp6 |
| archive_day_extraTemp7 |
| archive_day_extraTemp8 |
| archive_day_forecast |
| archive_day_hail |
| archive_day_hailBatteryStatus |
| archive_day_hailRate |
| archive_day_heatindex |
| archive_day_heatindex1 |
| archive_day_heatingTemp |
| archive_day_heatingVoltage |
| archive_day_humidex |
| archive_day_humidex1 |
| archive_day_inDewpoint |
| archive_day_inHumidity |
| archive_day_inTemp |
| archive_day_inTempBatteryStatus |
| archive_day_leafTemp1 |
| archive_day_leafTemp2 |
| archive_day_leafWet1 |
| archive_day_leafWet2 |
| archive_day_lightning_distance |
| archive_day_lightning_disturber_count |
| archive_day_lightning_energy |
| archive_day_lightning_noise_count |
| archive_day_lightning_strike_count |
| archive_day_luminosity |
| archive_day_maxSolarRad |
| archive_day_nh3 |
| archive_day_no2 |
| archive_day_noise |
| archive_day_o3 |
| archive_day_outHumidity |
| archive_day_outTemp |
| archive_day_outTempBatteryStatus |
| archive_day_pb |
| archive_day_pm10_0 |
| archive_day_pm1_0 |
| archive_day_pm2_5 |
| archive_day_pressure |
| archive_day_radiation |
| archive_day_rain |
| archive_day_rainBatteryStatus |
| archive_day_rainRate |
| archive_day_referenceVoltage |
| archive_day_rxCheckPercent |
| archive_day_signal1 |
| archive_day_signal2 |
| archive_day_signal3 |
| archive_day_signal4 |
| archive_day_signal5 |
| archive_day_signal6 |
| archive_day_signal7 |
| archive_day_signal8 |
| archive_day_snow |
| archive_day_snowBatteryStatus |
| archive_day_snowDepth |
| archive_day_snowMoisture |
| archive_day_snowRate |
| archive_day_so2 |
| archive_day_soilMoist1 |
| archive_day_soilMoist2 |
| archive_day_soilMoist3 |
| archive_day_soilMoist4 |
| archive_day_soilTemp1 |
| archive_day_soilTemp2 |
| archive_day_soilTemp3 |
| archive_day_soilTemp4 |
| archive_day_supplyVoltage |
| archive_day_txBatteryStatus |
| archive_day_uvBatteryStatus |
| archive_day_wind |
| archive_day_windBatteryStatus |
| archive_day_windDir |
| archive_day_windGust |
| archive_day_windGustDir |
| archive_day_windSpeed |
| archive_day_windchill |
| archive_day_windrun |
+---------------------------------------+
114 rows in set (0.00 sec)
The output of wee_debug --info :
Using verbosity=1, displaying most info
wee_debug output will be sent to stdout(console)
Using configuration file
/share/CACHEDEV1_DATA/homes/admin/weewxwftest/weewx.conf
Using database binding 'wx_binding', which is bound to database
'archive_mysql'
System info
Platform: Linux-4.2.8-armv7l-with-glibc2.4
Python Version: 2.7.15
Load Information
1 minute load average: 2.45
5 minute load average: 2.68
15 minute load average: 2.72
General Weewx info
Weewx version 4.5.1 detected.
Station info
Station type: WeatherFlowUDP
Driver: user.weatherflowudp
Driver info
[WeatherFlowUDP]
driver = user.weatherflowudp
token = 911669e1-f7d1-40bb-a0a8-1cda80232104
share_socket = True
Currently installed extensions
Extension Name Version Description
weatherflowudp 1.13 Capture data from WeatherFlow Bridge via UDP
broadcast packets
Archive info
Database name: weewxwftest
Table name: archive
Version 4.0
Unit system: 1 (US)
First good timestamp: 1970-01-01 01:05:00 CET (300)
Last good timestamp: 2021-07-12 21:15:00 CEST (1626117300)
Number of records: 133250
weewx (weewx.conf) is set to use an archive interval of 300 seconds.
The station hardware was not interrogated in determining archive interval.
Databases configured in weewx.conf
Database name: weewx.sdb
Database driver: weedb.sqlite
Database name: weewxwftest
Database driver: weedb.mysql
Database host: 127.0.0.1
Database name: weewxbt
Database driver: weedb.mysql
Database host: 127.0.0.1
Parsed and obfuscated weewx.conf
# WEEWX CONFIGURATION FILE
#
# Copyright (c) 2009-2020 Tom Keffer <[email protected]>
# See the file LICENSE.txt for your rights.
##############################################################################
# This section is for general configuration information.
# Set to 1 for extra debug info, otherwise comment it out or set to zero
debug = 0
# Root directory of the weewx data file hierarchy for this station
WEEWX_ROOT = /share/homes/admin/weewxwftest
# Whether to log successful operations
log_success = True
# Whether to log unsuccessful operations
log_failure = True
# How long to wait before timing out a socket (FTP, HTTP) connection
socket_timeout = 20
# Do not modify this. It is used when installing and updating weewx.
version = 4.5.1
##############################################################################
# This section is for information about the station.
[Station]
# Description of the station location
location = Sørengkaia Teststasjon
# Latitude in decimal degrees. Negative for southern hemisphere
latitude = 59.90204
# Longitude in decimal degrees. Negative for western hemisphere.
longitude = 10.75262
# Altitude of the station, with unit it is in. This is downloaded from
# from the station if the hardware supports it.
altitude = 30, meter # Choose 'foot' or 'meter' for unit
# Set to type of station hardware. There must be a corresponding stanza
# in this file with a 'driver' parameter indicating the driver to be
used.
station_type = WeatherFlowUDP
# If you have a website, you may specify an URL
#station_url = http://www.example.com
# The start of the rain year (1=January; 10=October, etc.). This is
# downloaded from the station if the hardware supports it.
rain_year_start = 1
# Start of week (0=Monday, 6=Sunday)
week_start = 6
##############################################################################
[WeatherFlowUDP]
driver = user.weatherflowudp
token = XXX obfuscated by wee_debug XXX
share_socket = True
[Simulator]
# This section is for the weewx weather station simulator
# The time (in seconds) between LOOP packets.
loop_interval = 2.5
# The simulator mode can be either 'simulator' or 'generator'.
# Real-time simulator. Sleep between each LOOP packet.
mode = simulator
# Generator. Emit LOOP packets as fast as possible (useful for
testing).
#mode = generator
# The start time. Format is YYYY-mm-ddTHH:MM. If not specified, the
default
# is to use the present time.
#start = 2011-01-01T00:00
# The driver to use:
driver = weewx.drivers.simulator
##############################################################################
# This section is for uploading data to Internet sites
[StdRESTful]
[[StationRegistry]]
# To register this weather station with weewx, set this to true
register_this_station = false
[[AWEKAS]]
# This section is for configuring posts to AWEKAS.
# If you wish to do this, set the option 'enable' to true,
# and specify a username and password.
# To guard against parsing errors, put the password in quotes.
enable = false
username = XXX obfuscated by wee_debug XXX
password = XXX obfuscated by wee_debug XXX
[[CWOP]]
# This section is for configuring posts to CWOP.
# If you wish to do this, set the option 'enable' to true,
# and specify the station ID (e.g., CW1234).
enable = false
station = XXX obfuscated by wee_debug XXX
# If this is an APRS (radio amateur) station, uncomment
# the following and replace with a passcode (e.g., 12345).
#passcode = replace_me (APRS stations only)
[[PWSweather]]
# This section is for configuring posts to PWSweather.com.
# If you wish to do this, set the option 'enable' to true,
# and specify a station and password.
# To guard against parsing errors, put the password in quotes.
enable = false
station = XXX obfuscated by wee_debug XXX
password = XXX obfuscated by wee_debug XXX
[[WOW]]
# This section is for configuring posts to WOW.
# If you wish to do this, set the option 'enable' to true,
# and specify a station and password.
# To guard against parsing errors, put the password in quotes.
enable = false
station = XXX obfuscated by wee_debug XXX
password = XXX obfuscated by wee_debug XXX
[[Wunderground]]
# This section is for configuring posts to the Weather Underground.
# If you wish to do this, set the option 'enable' to true,
# and specify a station (e.g., 'KORHOODR3') and password.
# To guard against parsing errors, put the password in quotes.
enable = false
station = XXX obfuscated by wee_debug XXX
password = XXX obfuscated by wee_debug XXX
# If you plan on using wunderfixer, set the following
# to your API key:
api_key = XXX obfuscated by wee_debug XXX
# Set the following to True to have weewx use the WU "Rapidfire"
# protocol. Not all hardware can support it. See the User's Guide.
rapidfire = False
##############################################################################
# This section specifies what reports, using which skins, to generate.
[StdReport]
# Where the skins reside, relative to WEEWX_ROOT
SKIN_ROOT = skins
# Where the generated reports should go, relative to WEEWX_ROOT
HTML_ROOT = public_html
# The database binding indicates which data should be used in reports.
data_binding = wx_binding
# Whether to log a successful operation
log_success = True
# Whether to log an unsuccessful operation
log_failure = True
# Each of the following subsections defines a report that will be run.
# See the customizing guide to change the units, plot types and line
# colors, modify the fonts, display additional sensor data, and other
# customizations. Many of those changes can be made here by overriding
# parameters, or by modifying templates within the skin itself.
[[SeasonsReport]]
# The SeasonsReport uses the 'Seasons' skin, which contains the
# images, templates and plots for the report.
skin = Seasons
enable = true
[[SmartphoneReport]]
# The SmartphoneReport uses the 'Smartphone' skin, and the images
and
# files are placed in a dedicated subdirectory.
skin = Smartphone
enable = true
HTML_ROOT = public_html/smartphone
[[MobileReport]]
# The MobileReport uses the 'Mobile' skin, and the images and files
# are placed in a dedicated subdirectory.
skin = Mobile
enable = true
HTML_ROOT = public_html/mobile
[[StandardReport]]
# This is the old "Standard" skin. By default, it is not enabled.
skin = Standard
enable = false
[[FTP]]
# FTP'ing the results to a webserver is treated as just another
report,
# albeit one with an unusual report generator!
skin = Ftp
# If you wish to use FTP, set "enable" to "true", then
# fill out the next four lines.
# Use quotes around passwords to guard against parsing errors.
enable = false
user = XXX obfuscated by wee_debug XXX
password = XXX obfuscated by wee_debug XXX
server = replace_me # The ftp server name, e.g, www.myserver.org
path = replace_me # The destination directory, e.g., /weather
# Set to True for an FTP over TLS (FTPS) connection. Not all servers
# support this.
secure_ftp = False
# To upload files from something other than what HTML_ROOT is set
# to above, specify a different HTML_ROOT here.
#HTML_ROOT = public_html
# Most FTP servers use port 21
port = 21
# Set to 1 to use passive mode, zero for active mode
passive = 1
[[RSYNC]]
# rsync'ing to a webserver is treated as just another report
skin = Rsync
# If you wish to use rsync, you must configure passwordless ssh
using
# public/private key authentication from the user account that weewx
# runs to the user account on the remote machine where the files
# will be copied.
#
# If you wish to use rsync, set "enable" to "true", then
# fill out server, user, and path.
# The server should appear in your .ssh/config file.
# The user is the username used in the identity file.
# The path is the destination directory, such as
/var/www/html/weather.
# Be sure that the user has write permissions on the destination!
enable = false
server = replace_me
user = XXX obfuscated by wee_debug XXX
path = replace_me
# To upload files from something other than what HTML_ROOT is set
# to above, specify a different HTML_ROOT here.
#HTML_ROOT = public_html
# Rsync can be configured to remove files from the remote server if
# they don't exist under HTML_ROOT locally. USE WITH CAUTION: if you
# make a mistake in the remote path, you could could unintentionally
# cause unrelated files to be deleted. Set to 1 to enable remote
file
# deletion, zero to allow files to accumulate remotely.
delete = 0
####
# Various options for customizing your reports.
[[Defaults]]
[[[Units]]]
# The following section sets what unit to use for each unit
group.
# NB: The unit is always in the singular. I.e., 'mile_per_hour',
# NOT 'miles_per_hour'
[[[[Groups]]]]
group_altitude = meter # Options are 'foot' or 'meter'
group_degree_day = degree_C_day # Options are
'degree_F_day' or 'degree_C_day'
group_distance = km # Options are 'mile' or 'km'
group_pressure = mbar # Options are 'inHg', 'mmHg',
'mbar', 'hPa', or 'kPa'
group_rain = mm # Options are 'inch', 'cm', or 'mm'
group_rainrate = mm_per_hour # Options are
'inch_per_hour', 'cm_per_hour', or 'mm_per_hour'
group_speed = meter_per_second # Options are
'mile_per_hour', 'km_per_hour', 'knot', or 'meter_per_second'
group_speed2 = meter_per_second2 # Options are
'mile_per_hour2', 'km_per_hour2', 'knot2', or 'meter_per_second2'
group_temperature = degree_C # Options are 'degree_F' or
'degree_C'
# The following section sets the formatting for each type of
unit.
[[[[StringFormats]]]]
centibar = %.0f
cm = %.2f
cm_per_hour = %.2f
degree_C = %.1f
degree_F = %.1f
degree_compass = %.0f
foot = %.0f
hPa = %.1f
hour = %.1f
inHg = %.3f
inch = %.2f
inch_per_hour = %.2f
km = %.1f
km_per_hour = %.0f
km_per_hour2 = %.1f
knot = %.0f
knot2 = %.1f
kPa = %.2f
mbar = %.1f
meter = %.0f
meter_per_second = %.1f
meter_per_second2 = %.1f
mile = %.1f
mile_per_hour = %.0f
mile_per_hour2 = %.1f
mm = %.1f
mmHg = %.1f
mm_per_hour = %.1f
percent = %.0f
second = %.0f
uv_index = %.1f
volt = %.2f
watt_per_meter_squared = %.0f
NONE = " N/A"
# The following section overrides the label used for each type
of unit
[[[[Labels]]]]
meter = " meter", " meters" # You may prefer "metre".
day = " day", " days"
hour = " hour", " hours"
minute = " minute", " minutes"
second = " second", " seconds"
NONE = ""
# The following section sets the format for each time scale.
# The values below will work in every locale, but they may not
look
# particularly attractive.
[[[[TimeFormats]]]]
hour = %H:%M
day = %H:%M
week = %H:%M (%A)
month = %d.%m.%Y %H:%M
year = %d.%m.%Y %H:%M
rainyear = %d.%m.%Y %H:%M
current = %d.%m.%Y %H:%M
ephem_day = %H:%M
ephem_year = %d.%m.%Y %H:%M
#day = %X
#week = %X (%A)
#month = %x %X
#year = %x %X
#rainyear = %x %X
#current = %x %X
#ephem_day = %X
#ephem_year = %x %X
[[[[Ordinates]]]]
# Ordinal directions. The last one is for no wind direction
directions = N, NNE, NE, ENE, E, ESE, SE, SSE, S, SSW, SW,
WSW, W, WNW, NW, NNW, N/A
# The following section sets the base temperatures used for the
# calculation of heating, cooling, and growing degree-days.
[[[[DegreeDays]]]]
# Base temperature for heating days, with unit:
heating_base = 65, degree_F
# Base temperature for cooling days, with unit:
cooling_base = 65, degree_F
# Base temperature for growing days, with unit:
growing_base = 50, degree_F
# A trend takes a difference across a time period. The following
# section sets the time period, and how big an error is allowed
to
# still be counted as the start or end of a period.
[[[[Trend]]]]
time_delta = 10800 # 3 hours
time_grace = 300 # 5 minutes
# The labels to be used for each observation type
[[[Labels]]]
# Set to hemisphere abbreviations suitable for your location:
hemispheres = N, S, E, W
# Formats to be used for latitude whole degrees, longitude whole
# degrees, and minutes:
latlon_formats = %02d, %03d, %05.2f
# Generic labels, keyed by an observation type.
[[[[Generic]]]]
barometer = Barometer
dewpoint = Dew Point
ET = ET
heatindex = Heat Index
inHumidity = Inside Humidity
inTemp = Inside Temperature
luminosity = Luminosity
outHumidity = Humidity
outTemp = Outside Temperature
radiation = Radiation
rain = Rain
rainRate = Rain Rate
UV = UV Index
windDir = Wind Direction
windGust = Gust Speed
windGustDir = Gust Direction
windSpeed = Wind Speed
windchill = Wind Chill
windgustvec = Gust Vector
windvec = Wind Vector
extraTemp1 = Temperature1
extraTemp2 = Temperature2
extraTemp3 = Temperature3
seaTemp = Sea Temperature
# Sensor status indicators
rxCheckPercent = Signal Quality
txBatteryStatus = Transmitter Battery
windBatteryStatus = Wind Battery
rainBatteryStatus = Rain Battery
outTempBatteryStatus = Tempest Battery
inTempBatteryStatus = Inside Temperature Battery
consBatteryVoltage = Console Battery
heatingVoltage = Heating Battery
supplyVoltage = Supply Voltage
referenceVoltage = Reference Voltage
signal1 = Tempest to Hub
signal2 = Hub to Tempest
signal3 = Hub WiFi
[[[Almanac]]]
# The labels to be used for the phases of the moon:
moon_phases = New, Waxing crescent, First quarter, Waxing
gibbous, Full, Waning gibbous, Last quarter, Waning crescent
##############################################################################
# This service acts as a filter, converting the unit system coming from
# the hardware to a unit system in the database.
[StdConvert]
# The target_unit affects only the unit system in the database. Once
# chosen it cannot be changed without converting the entire database.
# Modification of target_unit after starting weewx will result in
# corrupt data - the database will contain a mix of US and METRIC data.
#
# The value of target_unit does not affect the unit system for
# reporting - reports can display US, Metric, or any combination of
units.
#
# In most cases, target_unit should be left as the default: US
#
# In particular, those migrating from a standard wview installation
# should use US since that is what the wview database contains.
# DO NOT MODIFY THIS VALUE UNLESS YOU KNOW WHAT YOU ARE DOING!
target_unit = US # Options are 'US', 'METRICWX', or 'METRIC'
##############################################################################
# This section can adjust data using calibration expressions.
[StdCalibrate]
[[Corrections]]
# For each type, an arbitrary calibration expression can be given.
# It should be in the units defined in the StdConvert section.
# Example:
foo = foo + 0.2
##############################################################################
# This section is for quality control checks. If units are not specified,
# values must be in the units defined in the StdConvert section.
[StdQC]
[[MinMax]]
barometer = 26, 32.5, inHg
pressure = 24, 34.5, inHg
outTemp = -40, 120, degree_F
inTemp = 10, 120, degree_F
outHumidity = 0, 100
inHumidity = 0, 100
windSpeed = 0, 120, mile_per_hour
rain = 0, 10, inch
##############################################################################
# This section controls the origin of derived values.
[StdWXCalculate]
[[Calculations]]
# How to calculate derived quantities. Possible values are:
# hardware - use the value provided by hardware
# software - use the value calculated by weewx
# prefer_hardware - use value provide by hardware if available,
# otherwise use value calculated by weewx
pressure = prefer_hardware
altimeter = prefer_hardware
appTemp = prefer_hardware
barometer = prefer_hardware
cloudbase = prefer_hardware
dewpoint = prefer_hardware
ET = prefer_hardware
heatindex = prefer_hardware
humidex = prefer_hardware
inDewpoint = prefer_hardware
maxSolarRad = prefer_hardware
rainRate = prefer_hardware
windchill = prefer_hardware
windrun = prefer_hardware
##############################################################################
# For hardware that supports it, this section controls how often the
# onboard clock gets updated.
[StdTimeSynch]
# How often to check the weather station clock for drift (in seconds)
clock_check = 14400
# How much it can drift before we will correct it (in seconds)
max_drift = 5
##############################################################################
# This section is for configuring the archive service.
[StdArchive]
# If the station hardware supports data logging then the archive
interval
# will be downloaded from the station. Otherwise, specify it (in
seconds).
archive_interval = 300
# If possible, new archive records are downloaded from the station
# hardware. If the hardware does not support this, then new archive
# records will be generated in software.
# Set the following to "software" to force software record generation.
record_generation = hardware
# Whether to include LOOP data in hi/low statistics
loop_hilo = True
# The data binding used to save archive records
data_binding = wx_binding
##############################################################################
# This section binds a data store to a database.
[DataBindings]
[[wx_binding]]
# The database must match one of the sections in [Databases].
# This is likely to be the only option you would want to change.
database = archive_mysql
# The name of the table within the database
table_name = archive
# The manager handles aggregation of data for historical summaries
manager = weewx.manager.DaySummaryManager
# The schema defines the structure of the database.
# It is *only* used when the database is created.
schema = schemas.wview_extended.schema
[[badetassen_binding]]
# Binding for badetassen db.
database = badetassen_mysql
# The name of the table within the database
table_name = archive
# The manager handles aggregation of data for historical summaries
manager = weewx.manager.DaySummaryManager
# The schema defines the structure of the database.
# It is *only* used when the database is created.
schema = schemas.wview_extended.schema
##############################################################################
# This section defines various databases.
[Databases]
# A SQLite database is simply a single file
[[archive_sqlite]]
database_name = weewx.sdb
database_type = SQLite
# MySQL
[[archive_mysql]]
database_name = weewxwftest
database_type = MySQL
[[badetassen_mysql]]
database_name = weewxbt
database_type = MySQL_bt
##############################################################################
# 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 = /share/homes/admin/weewxwftest/archive
# Defaults for MySQL databases
[[MySQL]]
driver = weedb.mysql
# The host where the database is located
host = 127.0.0.1
# The user name for logging in to the host
user = XXX obfuscated by wee_debug XXX
# The password for the user name (quotes guard against parsing
errors)
password = XXX obfuscated by wee_debug XXX
[[MySQL_bt]]
driver = weedb.mysql
# The host where the database is located
host = 127.0.0.1
# The user name for logging in to the host
user = XXX obfuscated by wee_debug XXX
# The password for the user name (quotes guard against parsing
errors)
password = XXX obfuscated by wee_debug XXX
##############################################################################
# This section configures the internal weewx engine.
[Engine]
# The following section specifies which services should be run and in
what order.
[[Services]]
prep_services = weewx.engine.StdTimeSynch
data_services = ,
process_services = weewx.engine.StdConvert,
weewx.engine.StdCalibrate, weewx.engine.StdQC,
weewx.wxservices.StdWXCalculate
xtype_services = weewx.wxxtypes.StdWXXTypes,
weewx.wxxtypes.StdPressureCooker, weewx.wxxtypes.StdRainRater,
weewx.wxxtypes.StdDelta
archive_services = weewx.engine.StdArchive
restful_services = weewx.restx.StdStationRegistry,
weewx.restx.StdWunderground, weewx.restx.StdPWSweather,
weewx.restx.StdCWOP, weewx.restx.StdWOW, weewx.restx.StdAWEKAS
report_services = weewx.engine.StdPrint, weewx.engine.StdReport
wee_debug report successfully generated
Thanks,
Jan-Jaap
On Monday, July 12, 2021 at 2:06:33 AM UTC+2 [email protected] wrote:
> Anything new on this?
>
>
>
> On Fri, Jul 9, 2021 at 5:35 AM Tom Keffer <[email protected]> wrote:
>
>> Three things:
>>
>> 1. Let's see what's actually in your database.
>>
>> *show tables in weewxwftest;*
>>
>>
>> 2. Can we see the output of
>>
>> *wee_debug --info*
>>
>>
>> Double check that the utility obfuscated any passwords you might have in
>> weewx.conf.
>>
>> 3. Just to double check: you only have one weewx.conf file, right?
>>
>>
>>
>> On Thu, Jul 8, 2021 at 11:38 PM 'Jan-Jaap van der Geer' via weewx-user <
>> [email protected]> wrote:
>>
>>> The log doesn't seem to tell anything special:
>>>
>>> [/share/homes/admin/weewxwftest] # cat /var/log/messages | grep
>>> wee_database
>>> Jul 9 08:23:30 qnap user.info wee_database[20528] INFO weewx.manager:
>>> Dropping daily summary tables from 'weewxwftest' ...
>>> Jul 9 08:23:30 qnap user.info wee_database[20528] INFO weewx.manager:
>>> Dropped daily summary tables from database 'weewxwftest'
>>> Jul 9 08:23:49 qnap user.info wee_database[21058] INFO __main__: All
>>> daily summaries will be rebuilt.
>>> Jul 9 08:23:56 qnap user.info wee_database[21058] INFO weewx.manager:
>>> Created daily summary tables
>>> Jul 9 08:23:56 qnap user.info wee_database[21058] INFO __main__:
>>> Rebuilding daily summaries in database 'weewxwftest' ...
>>> Jul 9 08:23:56 qnap user.info wee_database[21058] INFO weewx.manager:
>>> Starting backfill of daily summaries
>>> Jul 9 08:32:32 qnap user.info wee_database[21058] INFO weewx.manager:
>>> Processed 132119 records to backfill 208 day summaries in 515.43 seconds
>>> Jul 9 08:32:32 qnap user.info wee_database[21058] INFO __main__:
>>> Rebuild of daily summaries in database 'weewxwftest' complete
>>>
>>> (I had to run it again as the log from yesterday had already been purged
>>> but I suppose the result is the same. I did watch the log and didn't notice
>>> anything interesting at the time)
>>>
>>> Thanks,
>>> Jan-Jaap
>>> On Friday, July 9, 2021 at 3:57:22 AM UTC+2 [email protected] wrote:
>>>
>>>> How about the log from when you tried dropping and rebuilding the
>>>> database?
>>>>
>>>> On Thu, Jul 8, 2021 at 2:29 PM 'Jan-Jaap van der Geer' via weewx-user <
>>>> [email protected]> wrote:
>>>>
>>>>> I have the exact same errors as fpb:
>>>>>
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: Generate failed with exception '<class
>>>>> 'NameMapper.NotFound'>'
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** Ignoring template
>>>>> /share/homes/admin/weewxwf/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** Reason: cannot find 'raw' while searching
>>>>> for
>>>>> 'day.wind.count.raw'
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** Traceback (most recent call last):
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** File
>>>>> "/share/CACHEDEV1_DATA/homes/admin/weewxwf/bin/weewx/cheetahgenerator.py",
>>>>>
>>>>> line 326, in generate
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** unicode_string =
>>>>> compiled_template.respond()
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** File
>>>>> "_share_homes_admin_weewxwf_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py",
>>>>> line 430, in respond
>>>>> Jul 8 23:20:16 qnap user.err weewx[2950] ERROR
>>>>> weewx.cheetahgenerator: **** NotFound: cannot find 'raw' while searching
>>>>> for 'day.wind.count.raw'
>>>>>
>>>>> I don't really understand what this 'new schema' and 'old schema' is,
>>>>> but I tried:
>>>>>
>>>>> wee_database --drop-daily
>>>>> wee_database --rebuild-daily
>>>>>
>>>>> both without changing the binding in weewx.conf and after changing it.
>>>>> Right now I have
>>>>>
>>>>> [[wx_binding]]
>>>>> # The database must match one of the sections in [Databases].
>>>>> # This is likely to be the only option you would want to
>>>>> change.
>>>>> database = archive_mysql
>>>>> # The name of the table within the database
>>>>> table_name = archive
>>>>> # The manager handles aggregation of data for historical
>>>>> summaries
>>>>> manager = weewx.manager.DaySummaryManager
>>>>> # The schema defines the structure of the database.
>>>>> # It is *only* used when the database is created.
>>>>> schema = schemas.wview_extended.schema
>>>>>
>>>>> but using:
>>>>>
>>>>> manager = weewx.wxmanager.WXDaySummaryManager
>>>>>
>>>>> and rebuilding still caused the errors.
>>>>>
>>>>> What should I do to fix this?
>>>>>
>>>>> Thanks,
>>>>> Jan-Jaap
>>>>>
>>>>> On Wednesday, December 16, 2020 at 2:26:19 PM UTC+1 [email protected]
>>>>> wrote:
>>>>>
>>>>>> You have the correct configuration, but remember, it only applies *when
>>>>>> the database is created*. Thereafter, the schema is read from the
>>>>>> database.
>>>>>>
>>>>>> You can try rebuilding the daily summaries using wee_database:
>>>>>>
>>>>>> *sudo wee_database --drop-daily*
>>>>>> *sudo wee_database --rebuild-daily*
>>>>>>
>>>>>>
>>>>>> The rebuild will use the configuration in weewx.conf.
>>>>>>
>>>>>> -tk
>>>>>>
>>>>>> On Tue, Dec 15, 2020 at 9:58 PM fpb <[email protected]> wrote:
>>>>>>
>>>>>>> @Tom,
>>>>>>>
>>>>>>> I'm having a similar issue but I'm trying to figure out what the
>>>>>>> correct schema (assuming that is the issue) but I can't find a
>>>>>>> combination.
>>>>>>>
>>>>>>> This is what I have;
>>>>>>>
>>>>>>> [DataBindings]
>>>>>>>
>>>>>>> [[wx_binding]]
>>>>>>> # The database must match one of the sections in [Databases].
>>>>>>> # This is likely to be the only option you would want to
>>>>>>> change.
>>>>>>> database = archive_sqlite
>>>>>>> # The name of the table within the database
>>>>>>> table_name = archive
>>>>>>> # The manager handles aggregation of data for historical
>>>>>>> summaries
>>>>>>> manager = weewx.manager.DaySummaryManager
>>>>>>> # The schema defines the structure of the database.
>>>>>>> # It is *only* used when the database is created.
>>>>>>> schema = schemas.wview_extended.schema
>>>>>>> [[forecast_binding]]
>>>>>>> database = forecast_sqlite
>>>>>>>
>>>>>>> and below my log errors;
>>>>>>>
>>>>>>> ec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> Generate failed with exception '<class 'NameMapper.NotFound'>'
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** Ignoring template /etc/weewx/skins/Seasons/NOAA/NOAA-%Y-%m.txt.tmpl
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** Reason: cannot find 'raw' while searching for 'day.wind.count.raw'
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** Traceback (most recent call last):
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** File "/usr/share/weewx/weewx/cheetahgenerator.py", line 323, in
>>>>>>> generate
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** unicode_string = compiled_template.respond()
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** File "_etc_weewx_skins_Seasons_NOAA_NOAA__Y__m_txt_tmpl.py",
>>>>>>> line
>>>>>>> 430, in respond
>>>>>>>
>>>>>>> Dec 16 00:55:18 weewx-vm weewx[11753] ERROR weewx.cheetahgenerator:
>>>>>>> **** NotFound: cannot find 'raw' while searching for
>>>>>>> 'day.wind.count.raw'
>>>>>>> Any help will be appreciate.
>>>>>>>
>>>>>>> On Thursday, June 4, 2020 at 6:01:51 PM UTC-4 [email protected]
>>>>>>> wrote:
>>>>>>>
>>>>>>>> That's probably what happened.
>>>>>>>>
>>>>>>>> You're not the first to get tripped up by this. Obviously, I need
>>>>>>>> to rethink how to manage the transition to the new way of specifying
>>>>>>>> schemas.
>>>>>>>>
>>>>>>>> On Thu, Jun 4, 2020 at 11:20 AM Jacques Terrettaz <
>>>>>>>> [email protected]> wrote:
>>>>>>>>
>>>>>>>>> Forget my last message : I used a new Raspberry PI to install
>>>>>>>>> weewx V4, and then I transferred my "old" mysql database to the new
>>>>>>>>> installation...
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Le 4 juin 2020 à 20:01, Jacques Terrettaz <[email protected]> a
>>>>>>>>> écrit :
>>>>>>>>>
>>>>>>>>> Tom,
>>>>>>>>>
>>>>>>>>> One comment about the old and new database schema : I didn't
>>>>>>>>> change anything by myself in the [DataBinding] section of weewx.conf
>>>>>>>>> after
>>>>>>>>> the upgrade to V4.0, so I suspect that the manager =
>>>>>>>>> weewx.manager.DaySummaryManager line was automatically modified
>>>>>>>>> during the upgrade process.
>>>>>>>>> Is it right ?
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> 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].
>>>>>>>>> To view this discussion on the web visit
>>>>>>>>> https://groups.google.com/d/msgid/weewx-user/ACB63400-3370-43DF-A186-A96D3BC23AA3%40gmail.com
>>>>>>>>>
>>>>>>>>> <https://groups.google.com/d/msgid/weewx-user/ACB63400-3370-43DF-A186-A96D3BC23AA3%40gmail.com?utm_medium=email&utm_source=footer>
>>>>>>>>> .
>>>>>>>>>
>>>>>>>> --
>>>>>>> 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].
>>>>>>>
>>>>>> To view this discussion on the web visit
>>>>>>> https://groups.google.com/d/msgid/weewx-user/d4d9e47e-ca30-4729-a81b-9d1cfd8dde76n%40googlegroups.com
>>>>>>>
>>>>>>> <https://groups.google.com/d/msgid/weewx-user/d4d9e47e-ca30-4729-a81b-9d1cfd8dde76n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>>>> .
>>>>>>>
>>>>>> --
>>>>> 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].
>>>>>
>>>> To view this discussion on the web visit
>>>>> https://groups.google.com/d/msgid/weewx-user/d4e7d688-fe41-4258-b7c9-6068c95012b3n%40googlegroups.com
>>>>>
>>>>> <https://groups.google.com/d/msgid/weewx-user/d4e7d688-fe41-4258-b7c9-6068c95012b3n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>>>> .
>>>>>
>>>> --
>>> 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].
>>> To view this discussion on the web visit
>>> https://groups.google.com/d/msgid/weewx-user/17e8d219-f018-493f-aef4-6a5b323f4075n%40googlegroups.com
>>>
>>> <https://groups.google.com/d/msgid/weewx-user/17e8d219-f018-493f-aef4-6a5b323f4075n%40googlegroups.com?utm_medium=email&utm_source=footer>
>>> .
>>>
>> --
> -tk
>
--
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].
To view this discussion on the web visit
https://groups.google.com/d/msgid/weewx-user/6481bf41-78d1-474d-b21a-45b1df74672an%40googlegroups.com.
