Can't create a weewx MySQL database
228 views
Skip to first unread message
Luc Heijst
May 14, 2021, 1:07:19 PM5/14/21
to weewx-user
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')
]
=========================================
Tom Keffer
May 14, 2021, 1:22:49 PM5/14/21
to weewx-user
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
--
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.
To view this discussion on the web visit https://groups.google.com/d/msgid/weewx-user/bdea6021-3f34-478d-a119-dcde64589b0en%40googlegroups.com.
Luc Heijst
May 14, 2021, 1:56:40 PM5/14/21
to weewx-user
Tom,
You were right (as usual!)
Port 3306 is of a non-existing mariadb 5 configuration. I had to use port 3307 for mariadb 10
Problem solved. Thanks for your help.
Luc
Op vrijdag 14 mei 2021 om 14:22:49 UTC-3 schreef tke...@gmail.com:
paul.ba...@gmail.com
May 15, 2021, 3:07:13 PM5/15/21
to weewx-user
Hello Luc and Tom,
The problem is solved, but with a wrong solution. 3306 is the normal "port" for all versions of mysql AND mariadb . Do you have both running? mariadb even use the same configuration at installation.
Port numbers are defined by default in the system. From 0 to 1024 they are "hard" defined and can not be changed. Above, they are defined for many applications that can receive data from outside, including mysql, mariadb and postgress, ssh, ftp etc. You can change them at your own risk, including the fact that, being not standard, all other applications must then be adapted.
You can see all ports in use in your system with the command
sudo netstat -tulpn
or, if you want just mysql (== mariadb):
sudo netstat -tulpn | egrep mysql
Regards, Paul
Luc Heijst
May 15, 2021, 3:17:09 PM5/15/21
to weewx-user
Hello Paul,
I didn't make up these port numbers. They are the default port numbers for my Synology NAS.
You can install both MariaDB versions 5 and 10 on the same NAS.
The databases are on my DS216j model running DSM 6.2.4.
Luc
You can install both MariaDB versions 5 and 10 on the same NAS.
The databases are on my DS216j model running DSM 6.2.4.
Luc
Op zaterdag 15 mei 2021 om 16:07:13 UTC-3 schreef paul.ba...@gmail.com:
Reply all
Reply to author
Forward
0 new messages