Most likely the host and/or port is wrong.

Experiment using the tool mysql:

*mysql --host=192.168.0.15 --port=3306 -u weewx -p*



On Fri, May 14, 2021 at 10:07 AM Luc Heijst <[email protected]> wrote:

> Weewx version 4.5.1, Python 3.7.1
>
> When in weewx.conf a sqlite database is selected, then a new database is
> created and initialized.
> But when in weewx.conf a MySQL database is selected, then no database is
> created.
> Also I can't create a MySQL database with command 'wee_database'; see
> logging below
>
> Luc
>
>
> No MySQL database 'sdr1' is created at startup of weewx, see logging
> below. An error occurs: Can't connect to MySQL server
> =========================================
> May 14 13:39:25 pi32 sdr1[11692] INFO __main__: Initializing weewx version
> 4.5.1
> May 14 13:39:25 pi32 sdr1[10691] INFO __main__: Using Python 3.7.3
> (default, Jan 22 2021, 20:04:44) #012[GCC 8.3.0]
> May 14 13:39:25 pi32 sdr1[10691] INFO __main__: Platform
> Linux-5.10.17-v7+-armv7l-with-debian-10.9
> May 14 13:39:25 pi32 sdr1[10691] INFO __main__: Locale is 'en_GB.UTF-8'
> May 14 13:39:25 pi32 sdr1[10691] INFO __main__: PID file is
> /var/run/weewx_sdr1.pid
> May 14 13:39:25 pi32 sdr1[10695] INFO __main__: Using configuration file
> /home/weewx/weewx_sdr1.conf
> May 14 13:39:25 pi32 sdr1[10695] INFO __main__: Debug is 2
> May 14 13:39:25 pi32 sdr1[10695] DEBUG __main__: Initializing engine
> May 14 13:39:25 pi32 sdr1[10695] INFO weewx.engine: Loading station type
> SDR (user.sdr)
> May 14 13:39:25 pi32 sdr1[10695] INFO user.sdr: driver version is 0.78
> May 14 13:39:25 pi32 sdr1[10695] INFO user.sdr: sensor map is {'temp1':
> 'temperature.6A55.TFA_1Packet', 'humidity1': 'humidity.6A55.TFA_1Packet',
> 'rssi1': 'rssi.6A55.TFA_1Packet', 'batteryStatus1':
> 'lowbat.6A55.TFA_1Packet', 'temp2': 'temperature.7131.TFA_1Packet',
> 'humidity2': 'humidity.7131.TFA_1Packet', 'rssi2': 'rssi.7131.TFA_1Packet',
> 'batteryStatus2': 'lowbat.7131.TFA_1Packet', 'temp3':
> 'temperature.6C85.TFA_1Packet', 'humidity3': 'humidity.6C85.TFA_1Packet',
> 'rssi3': 'rssi.6C85.TFA_1Packet', 'batteryStatus3':
> 'lowbat.6C85.TFA_1Packet', 'temp4': 'temperature.55C7.TFA_1Packet',
> 'humidity4': 'humidity.55C7.TFA_1Packet', 'rssi4': 'rssi.55C7.TFA_1Packet',
> 'batteryStatus4': 'lowbat.55C7.TFA_1Packet', 'temp5':
> 'temperature.61AA.TFA_1Packet', 'humidity5': 'humidity.61AA.TFA_1Packet',
> 'rssi5': 'rssi.61AA.TFA_1Packet', 'batteryStatus5':
> 'lowbat.61AA.TFA_1Packet', 'temp6': 'temperature.0000.TFA_1Packet',
> 'humidity6': 'humidity.0000.TFA_1Packet', 'rssi6': 'rssi.0000.TFA_1Packet',
> 'batteryStatus6': 'lowbat.0000.TFA_1Packet', 'temp7':
> 'temperature.4562.TFA_1Packet', 'humidity7': 'humidity.4562.TFA_1Packet',
> 'rssi7': 'rssi.4562.TFA_1Packet', 'batteryStatus7':
> 'lowbat.4562.TFA_1Packet', 'temp8': 'temperature.5565.TFA_1Packet',
> 'humidity8': 'humidity.5565.TFA_1Packet', 'rssi8': 'rssi.5565.TFA_1Packet',
> 'batteryStatus8': 'lowbat.5565.TFA_1Packet'}
> May 14 13:39:25 pi32 sdr1[10695] INFO user.sdr: deltas is {'rain':
> 'rain_total', 'strikes': 'strikes_total'}
> May 14 13:39:25 pi32 sdr1[10695] INFO user.sdr: startup process 'rtl_433
> -M utc -F json -R 150 -f 868.250M -s 1536k'
> May 14 13:39:25 pi32 sdr1[10695] DEBUG user.sdr: start async reader for
> stdout-thread
> May 14 13:39:25 pi32 sdr1[10695] DEBUG user.sdr: start async reader for
> stderr-thread
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Loading service
> weewx.engine.StdTimeSynch
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdTimeSynch
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Loading service
> weewx.engine.StdConvert
> May 14 13:39:25 pi32 sdr1[10695] INFO weewx.engine: StdConvert target unit
> is 0x10
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdConvert
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Loading service
> weewx.engine.StdCalibrate
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdCalibrate
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Loading service
> weewx.engine.StdQC
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdQC
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.engine: Loading service
> weewx.wxservices.StdWXCalculate
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.wxservices: Calculations for
> LOOP packets: {'windDir': 'software', 'windGustDir': 'software'}
> May 14 13:39:25 pi32 sdr1[10695] DEBUG weewx.wxservices: Calculations for
> archive records: {'windDir': 'software', 'windGustDir': 'software'}
> May 14 13:39:25 pi32 sdr1[10695] INFO user.sdr: shutdown process rtl_433
> -M utc -F json -R 150 -f 868.250M -s 1536k
> May 14 13:39:25 pi32 sdr1[10695] DEBUG user.sdr: waiting for stdout-thread
> May 14 13:39:35 pi32 sdr1[10695] INFO user.sdr: timed out waiting for
> stdout-thread
> May 14 13:39:35 pi32 sdr1[10695] DEBUG user.sdr: waiting for stderr-thread
> May 14 13:39:45 pi32 sdr1[10695] INFO user.sdr: timed out waiting for
> stderr-thread
> May 14 13:39:45 pi32 sdr1[10695] DEBUG user.sdr: close stdout
> May 14 13:39:45 pi32 sdr1[10695] DEBUG user.sdr: close stderr
> May 14 13:39:46 pi32 sdr1[10695] DEBUG user.sdr: kill process
> May 14 13:39:46 pi32 sdr1[10695] CRITICAL __main__: Database connection
> exception: (2002, "Can't connect to MySQL server on '192.168.0.15' (115)")
> May 14 13:39:46 pi32 sdr1[10695] CRITICAL __main__:     ****  Waiting 60
> seconds then retrying...
> =========================================
>
> NOTE: When instead sqlite is configured as database then a database will
> be created.
> A sqlite database is created at startup of weewx, see logging below
> =========================================
> May 14 13:49:33 pi32 sdr1[11692] INFO __main__: Initializing weewx version
> 4.5.1
> May 14 13:49:33 pi32 sdr1[11692] INFO __main__: Using Python 3.7.3
> (default, Jan 22 2021, 20:04:44) #012[GCC 8.3.0]
> May 14 13:49:33 pi32 sdr1[11692] INFO __main__: Platform
> Linux-5.10.17-v7+-armv7l-with-debian-10.9
> May 14 13:49:33 pi32 sdr1[11692] INFO __main__: Locale is 'en_GB.UTF-8'
> May 14 13:49:33 pi32 sdr1[11692] INFO __main__: PID file is
> /var/run/weewx_sdr1.pid
> May 14 13:49:33 pi32 sdr1[11696] INFO __main__: Using configuration file
> /home/weewx/weewx_sdr1.conf
> May 14 13:49:33 pi32 sdr1[11696] INFO __main__: Debug is 2
> May 14 13:49:33 pi32 sdr1[11696] DEBUG __main__: Initializing engine
> May 14 13:49:33 pi32 sdr1[11696] INFO weewx.engine: Loading station type
> SDR (user.sdr)
> May 14 13:49:33 pi32 sdr1[11696] INFO user.sdr: driver version is 0.78
> May 14 13:49:33 pi32 sdr1[11696] INFO user.sdr: sensor map is {'temp1':
> 'temperature.6A55.TFA_1Packet', 'humidity1': 'humidity.6A55.TFA_1Packet',
> 'rssi1': 'rssi.6A55.TFA_1Packet', 'batteryStatus1':
> 'lowbat.6A55.TFA_1Packet', 'temp2': 'temperature.7131.TFA_1Packet',
> 'humidity2': 'humidity.7131.TFA_1Packet', 'rssi2': 'rssi.7131.TFA_1Packet',
> 'batteryStatus2': 'lowbat.7131.TFA_1Packet', 'temp3':
> 'temperature.6C85.TFA_1Packet', 'humidity3': 'humidity.6C85.TFA_1Packet',
> 'rssi3': 'rssi.6C85.TFA_1Packet', 'batteryStatus3':
> 'lowbat.6C85.TFA_1Packet', 'temp4': 'temperature.55C7.TFA_1Packet',
> 'humidity4': 'humidity.55C7.TFA_1Packet', 'rssi4': 'rssi.55C7.TFA_1Packet',
> 'batteryStatus4': 'lowbat.55C7.TFA_1Packet', 'temp5':
> 'temperature.61AA.TFA_1Packet', 'humidity5': 'humidity.61AA.TFA_1Packet',
> 'rssi5': 'rssi.61AA.TFA_1Packet', 'batteryStatus5':
> 'lowbat.61AA.TFA_1Packet', 'temp6': 'temperature.0000.TFA_1Packet',
> 'humidity6': 'humidity.0000.TFA_1Packet', 'rssi6': 'rssi.0000.TFA_1Packet',
> 'batteryStatus6': 'lowbat.0000.TFA_1Packet', 'temp7':
> 'temperature.4562.TFA_1Packet', 'humidity7': 'humidity.4562.TFA_1Packet',
> 'rssi7': 'rssi.4562.TFA_1Packet', 'batteryStatus7':
> 'lowbat.4562.TFA_1Packet', 'temp8': 'temperature.5565.TFA_1Packet',
> 'humidity8': 'humidity.5565.TFA_1Packet', 'rssi8': 'rssi.5565.TFA_1Packet',
> 'batteryStatus8': 'lowbat.5565.TFA_1Packet'}
> May 14 13:49:33 pi32 sdr1[11696] INFO user.sdr: deltas is {'rain':
> 'rain_total', 'strikes': 'strikes_total'}
> May 14 13:49:33 pi32 sdr1[11696] INFO user.sdr: startup process 'rtl_433
> -M utc -F json -R 150 -f 868.250M -s 1536k'
> May 14 13:49:33 pi32 sdr1[11696] DEBUG user.sdr: start async reader for
> stdout-thread
> May 14 13:49:33 pi32 sdr1[11696] DEBUG user.sdr: start async reader for
> stderr-thread
> May 14 13:49:33 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdTimeSynch
> May 14 13:49:33 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdTimeSynch
> May 14 13:49:33 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdConvert
> May 14 13:49:33 pi32 sdr1[11696] INFO weewx.engine: StdConvert target unit
> is 0x10
> May 14 13:49:33 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdConvert
> May 14 13:49:33 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdCalibrate
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdCalibrate
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdQC
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdQC
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.wxservices.StdWXCalculate
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.wxservices: Calculations for
> LOOP packets: {'windDir': 'software', 'windGustDir': 'software'}
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.wxservices: Calculations for
> archive records: {'windDir': 'software', 'windGustDir': 'software'}
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.manager: Created and
> initialized table 'archive' in database 'sdr1a.sdb'
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.manager: Created daily summary
> tables
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.manager: Daily summary
> version is 4.0
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.wxservices.StdWXCalculate
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdWXXTypes
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdWXXTypes
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdPressureCooker
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdPressureCooker
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdRainRater
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdRainRater
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.wxxtypes.StdDelta
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.wxxtypes.StdDelta
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdArchive
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.engine: Archive will use data
> binding wx_binding
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.engine: Record generation will
> be attempted in 'hardware'
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.engine: Using archive interval
> of 300 seconds (specified in weewx configuration)
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Use LOOP data in
> hi/low calculations: 1
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdArchive
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdPrint
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdPrint
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Loading service
> weewx.engine.StdReport
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Finished loading
> service weewx.engine.StdReport
> May 14 13:49:34 pi32 sdr1[11696] INFO __main__: Starting up weewx version
> 4.5.1
> May 14 13:49:34 pi32 sdr1[11696] DEBUG weewx.engine: Station does not
> support reading the time
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.engine: Using binding
> 'wx_binding' to database 'sdr1a.sdb'
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.manager: Starting backfill of
> daily summaries
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.manager: Empty database
> May 14 13:49:34 pi32 sdr1[11696] INFO weewx.engine: Starting main packet
> loop.
> May 14 13:49:37 pi32 sdr1[11696] DEBUG user.sdr: lines=['{"time" :
> "2021-05-14 16:49:34", "model" : "Klimalogg Pro", "id" : 27781,
> "battery_ok" : 1, "temperature_C" : "-20.5 C", "humidity" : 106,
> "sequence_nr" : 15, "mic" : "CRC"}\n']
> May 14 13:49:37 pi32 sdr1[11696] DEBUG user.sdr: parse_json: unknown model
> Klimalogg Pro
> May 14 13:49:37 pi32 sdr1[11696] DEBUG user.sdr: punt unrecognized line
> '{"time" : "2021-05-14 16:49:34", "model" : "Klimalogg Pro", "id" : 27781,
> "battery_ok" : 1, "temperature_C" : "-20.5 C", "humidity" : 106,
> "sequence_nr" : 15, "mic" : "CRC"}#012'
> May 14 13:49:40 pi32 sdr1[11696] DEBUG user.sdr: lines=[]
> =========================================
>
> Can't create MySQL database with command wee_database either, see logging
> below
> =========================================
> root@pi32:/home/weewx# ./bin/wee_database --config=weewx_sdr1.conf
> --create
> Using configuration file weewx_sdr1.conf
> Using database binding 'wx_binding', which is bound to database
> 'sdr1_mysql'
> Traceback (most recent call last):
>   File "/home/weewx/bin/weedb/mysql.py", line 54, in guarded_fn
>     return fn(*args, **kwargs)
>   File "/home/weewx/bin/weedb/mysql.py", line 137, in __init__
>     db=database_name, **kwargs)
>   File "/usr/lib/python3/dist-packages/MySQLdb/__init__.py", line 86, in
> Connect
>     return Connection(*args, **kwargs)
>   File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204,
> in __init__
>     super(Connection, self).__init__(*args, **kwargs2)
> _mysql_exceptions.OperationalError: (2002, "Can't connect to MySQL server
> on '192.168.0.15' (115)")
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "./bin/wee_database", line 248, in createMainDatabase
>     with weewx.manager.open_manager_with_config(config_dict, db_binding)
> as dbmanager:
>   File "/home/weewx/bin/weewx/manager.py", line 746, in
> open_manager_with_config
>     return open_manager(manager_dict, initialize)
>   File "/home/weewx/bin/weewx/manager.py", line 737, in open_manager
>     manager_dict['table_name'])
>   File "/home/weewx/bin/weewx/manager.py", line 129, in open
>     connection = weedb.connect(database_dict)
>   File "/home/weewx/bin/weedb/__init__.py", line 92, in connect
>     return driver_mod.connect(**db_dict)
>   File "/home/weewx/bin/weedb/mysql.py", line 72, in connect
>     database_name=database_name, engine=engine, autocommit=autocommit,
> **kwargs)
>   File "/home/weewx/bin/weedb/mysql.py", line 63, in guarded_fn
>     raise klass(e)
> weedb.CannotConnectError: (2002, "Can't connect to MySQL server on
> '192.168.0.15' (115)")
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "/home/weewx/bin/weedb/mysql.py", line 54, in guarded_fn
>     return fn(*args, **kwargs)
>   File "/home/weewx/bin/weedb/mysql.py", line 137, in __init__
>     db=database_name, **kwargs)
>   File "/usr/lib/python3/dist-packages/MySQLdb/__init__.py", line 86, in
> Connect
>     return Connection(*args, **kwargs)
>   File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204,
> in __init__
>     super(Connection, self).__init__(*args, **kwargs2)
> _mysql_exceptions.OperationalError: (2002, "Can't connect to MySQL server
> on '192.168.0.15' (115)")
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "/home/weewx/bin/weewx/manager.py", line 151, in open_with_create
>     connection = weedb.connect(database_dict)
>   File "/home/weewx/bin/weedb/__init__.py", line 92, in connect
>     return driver_mod.connect(**db_dict)
>   File "/home/weewx/bin/weedb/mysql.py", line 72, in connect
>     database_name=database_name, engine=engine, autocommit=autocommit,
> **kwargs)
>   File "/home/weewx/bin/weedb/mysql.py", line 63, in guarded_fn
>     raise klass(e)
> weedb.CannotConnectError: (2002, "Can't connect to MySQL server on
> '192.168.0.15' (115)")
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "/home/weewx/bin/weedb/mysql.py", line 54, in guarded_fn
>     return fn(*args, **kwargs)
>   File "/home/weewx/bin/weedb/mysql.py", line 137, in __init__
>     db=database_name, **kwargs)
>   File "/usr/lib/python3/dist-packages/MySQLdb/__init__.py", line 86, in
> Connect
>     return Connection(*args, **kwargs)
>   File "/usr/lib/python3/dist-packages/MySQLdb/connections.py", line 204,
> in __init__
>     super(Connection, self).__init__(*args, **kwargs2)
> _mysql_exceptions.OperationalError: (2002, "Can't connect to MySQL server
> on '192.168.0.15' (115)")
>
> During handling of the above exception, another exception occurred:
>
> Traceback (most recent call last):
>   File "./bin/wee_database", line 1138, in <module>
>     main()
>   File "./bin/wee_database", line 200, in main
>     createMainDatabase(config_dict, db_binding)
>   File "./bin/wee_database", line 253, in createMainDatabase
>     db_binding, initialize=True) as dbmanager:
>   File "/home/weewx/bin/weewx/manager.py", line 746, in
> open_manager_with_config
>     return open_manager(manager_dict, initialize)
>   File "/home/weewx/bin/weewx/manager.py", line 734, in open_manager
>     manager_dict['schema'])
>   File "/home/weewx/bin/weewx/manager.py", line 159, in open_with_create
>     weedb.create(database_dict)
>   File "/home/weewx/bin/weedb/__init__.py", line 80, in create
>     return driver_mod.create(**db_dict)
>   File "/home/weewx/bin/weedb/mysql.py", line 85, in create
>     **kwargs)
>   File "/home/weewx/bin/weedb/mysql.py", line 63, in guarded_fn
>     raise klass(e)
> weedb.CannotConnectError: (2002, "Can't connect to MySQL server on
> '192.168.0.15' (115)")
> root@pi32:/home/weewx#
>
>
> Part of weewx_sdr1.conf
> =========================================
>
>
> ##############################################################################
>
> #   This section binds a data store to a database.
>
> [DataBindings]
>
>     [[wx_binding]]
>         database = sdr1_mysql
>         table_name = archive
>         manager = weewx.wxmanager.WXDaySummaryManager
>         schema = user.sdr1.schema
>     [[sdr1_binding]]
>         database = sdr1_mysql
>         table_name = archive
>         manager = weewx.wxmanager.WXDaySummaryManager
>         schema = user.sdr1.schema
>
>
> ##############################################################################
>
> #   This section defines various databases.
>
> [Databases]
>
>     # A SQLite database is simply a single file
>     [[sdr1_sqlite]]
>         database_type = SQLite
>         database_name = sdr1.sdb
>     [[sdr1_mysql]]
>         database_type = MySQL
>         database_name = sdr1
>
>
> ##############################################################################
>
> #   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 = /home/pi
>
>     # Defaults for MySQL databases
>     [[MySQL]]
>         driver = weedb.mysql
>         # The host where the database is located
>         host = 192.168.0.15
>         port = 3306    # 3306=mariadb 5, 3307=mariadb 10
>         # The user name for logging in to the host
>         user = weewx
>         # The password for the user name
>         password = XXXXXXXXXX
> =========================================
>
> File user/sdr1.py
> #
> =============================================================================
> schema = [('dateTime',             'INTEGER NOT NULL UNIQUE PRIMARY KEY'),
>           ('usUnits',              'INTEGER NOT NULL'),
>           ('interval',             'INTEGER NOT NULL'),
>           ('temp1',                'REAL'),
>           ('temp2',                'REAL'),
>           ('temp3',                'REAL'),
>           ('temp4',                'REAL'),
>           ('temp5',                'REAL'),
>           ('temp6',                'REAL'),
>           ('temp7',                'REAL'),
>           ('temp8',                'REAL'),
>           ('temp9',                'REAL'),
>           ('temp10',               'REAL'),
>           ('humidity1',            'REAL'),
>           ('humidity2',            'REAL'),
>           ('humidity3',            'REAL'),
>           ('humidity4',            'REAL'),
>           ('humidity5',            'REAL'),
>           ('humidity6',            'REAL'),
>           ('humidity7',            'REAL'),
>           ('humidity8',            'REAL'),
>           ('humidity9',            'REAL'),
>           ('humidity10',           'REAL'),
>           ('rssi1',                'REAL'),
>           ('rssi2',                'REAL'),
>           ('rssi3',                'REAL'),
>           ('rssi4',                'REAL'),
>           ('rssi5',                'REAL'),
>           ('rssi6',                'REAL'),
>           ('rssi7',                'REAL'),
>           ('rssi8',                'REAL'),
>           ('rssi9',                'REAL'),
>           ('rssi10',               'REAL'),
>           ('batteryStatus1',       'REAL'),
>           ('batteryStatus2',       'REAL'),
>           ('batteryStatus3',       'REAL'),
>           ('batteryStatus4',       'REAL'),
>           ('batteryStatus5',       'REAL'),
>           ('batteryStatus6',       'REAL'),
>           ('batteryStatus7',       'REAL'),
>           ('batteryStatus8',       'REAL'),
>           ('batteryStatus9',       'REAL'),
>           ('batteryStatus10',      'REAL')
>     ]
> =========================================
>
> --
> 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/bdea6021-3f34-478d-a119-dcde64589b0en%40googlegroups.com
> <https://groups.google.com/d/msgid/weewx-user/bdea6021-3f34-478d-a119-dcde64589b0en%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/CAPq0zECJfLByC8DgKfrokF9r3WgMYcsygJO_UOfOY%2Bf5U0S9ig%40mail.gmail.com.

Reply via email to