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 Le Friday, May 14, 2021 à 7:56:40 PM UTC+2, Luc Heijst a écrit : > 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 [email protected]: > >> 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/4397c504-e1a4-49f7-b5d5-ce3b27ce5c5an%40googlegroups.com.
