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/3a4feb37-c82b-4430-879b-3e169636e7e4n%40googlegroups.com.
