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 Op zaterdag 15 mei 2021 om 16:07:13 UTC-3 schreef [email protected]: > 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/dd58a9a2-ba53-4098-a0a0-78159955141bn%40googlegroups.com.
