Re: [weewx-user] Can't create a weewx MySQL database
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 paul.ba...@gmail.com:
> 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 tke...@gmail.com:
>>
>>> 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 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..TFA_1Packet',
'humidity6': 'humidity..TFA_1Packet', 'rssi6':
'rssi..TFA_1Packet',
'batteryStatus6': 'lowbat..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
Re: [weewx-user] Can't create a weewx MySQL database
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 tke...@gmail.com:
>
>> 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 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..TFA_1Packet',
>>> 'humidity6': 'humidity..TFA_1Packet', 'rssi6': 'rssi..TFA_1Packet',
>>> 'batteryStatus6': 'lowbat..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
Re: [weewx-user] Can't create a weewx MySQL database
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:
> 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 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..TFA_1Packet',
>> 'humidity6': 'humidity..TFA_1Packet', 'rssi6': 'rssi..TFA_1Packet',
>> 'batteryStatus6': 'lowbat..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:
Re: [weewx-user] Can't create a weewx MySQL database
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 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..TFA_1Packet',
> 'humidity6': 'humidity..TFA_1Packet', 'rssi6': 'rssi..TFA_1Packet',
> 'batteryStatus6': 'lowbat..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:
[weewx-user] Can't create a weewx MySQL database
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..TFA_1Packet',
'humidity6': 'humidity..TFA_1Packet', 'rssi6': 'rssi..TFA_1Packet',
'batteryStatus6': 'lowbat..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
