upload to MariaDB fails

khs1974 commented 5 years ago

Hello,

I installed the latest SBFspot version on my Raspberry Pi 3 Model B Rev 1.2 I selected MariaDB and the installation was successfull. However the datafiles (in the location /usr/local/bin/sbfspot.3) won´t update; the “last change date” is still the same as the date of installation and the file size doesn’t increase. When I run the SBFspot installation again and select the existing configuration (/usr/local/bin/sbfspot.3/SBFspot.cfg), "SQlite" is pre-selected and not "MariaDB". Previously I selected SQlite, but changed this later on. What am I doing wrong?

Kees

sbf- commented 5 years ago

Can you post the output of sbfspot-config script?

khs1974 commented 5 years ago

Hereby;

[19:51:22] openhabian@openhab:~$ sudo curl -s https://raw.githubusercontent.com/sbfspot/sbfspot-config/master/sbfspot-config | sudo bash
SBFspot Configuration Tool V1.0.14
Running on Raspberry Pi 3 Model B Rev 1.2
Checking whiptail... Installed.
architecture=armhf
Raspbian GNU/Linux 10 (buster)
username=openhabian
userhome=/home/openhabian
Minimum SBFspot version supported by this tool is 3.5.0
Request to install latest version (3.5.2)
Searching for existing configuration(s)...
Reading settings from /usr/local/bin/sbfspot.3/SBFspot.cfg
do_db_config:SBFspot
Saving defaults to /var/tmp/sbfspot.3/sbfspot.defaults... Done
Performing some checks before installation... Done
Downloading https://github.com/sbfspot/sbfspot/releases/download/V3.5.2/sbfspot-mysql-arm-linux.tar.gz
Copying files...
Checking database...
Schema Version=1
Configuring SBFspot... Done
Running SBFspot...
Creating cron jobs...

SBFspot
*/5 6-22 * * * /usr/local/bin/sbfspot.3/daydata
55 05 * * * /usr/local/bin/sbfspot.3/monthdata
NetID=04
Removing temporary files...
Installation complete
[20:10:46] openhabian@openhab:~$

khs1974 commented 5 years ago

and the file SBFspot.cfg:

SBFspot.cfg - Created Thu 26 Sep 2019 08:10:30 PM CEST with sbfspot-config V1.0.14
 For detailed configuration info, refer to SBFspot.default.cfg

BTAddress=00:80:25:A4:EE:57
MIS_Enabled=0
BTConnectRetries=15
Password=0000
Plantname=MyPlant
OutputPath=/home/openhabian/smadata/%Y
OutputPathEvents=/home/openhabian/smadata/%Y/Events
CSV_Export=1
CSV_ExtendedHeader=1
CSV_Header=1
CSV_SaveZeroPower=1
CSV_Delimiter=semicolon
CSV_Spot_TimeSource=inverter
CSV_Spot_WebboxHeader=0
Timezone=Europe/Amsterdam
Latitude=52.37
Longitude=4.90
Locale=en-US
DateTimeFormat=%d/%m/%Y %H:%M:%S
DateFormat=%d/%m/%Y
TimeFormat=%H:%M:%S
DecimalPoint=comma
CalculateMissingSpotValues=0
SQL_Database=SBFspot
SQL_Hostname=localhost
SQL_Username=SBFspotUser
SQL_Password=SBFspotPassword
# End of Config

sbf- commented 5 years ago

Looks OK to me... What is the output of /usr/local/bin/sbfspot.3/SBFspot -?

khs1974 commented 5 years ago

SBFspot_printscreen

khs1974 commented 5 years ago

the file "SBFspot" is not readable.

sbf- commented 4 years ago

is this OK now?

khs1974 commented 4 years ago

No, I'm using SQlite at the moment because that does work..

sbf- commented 4 years ago

Can't reproduce issue

SBFspot / sbfspot-config

upload to MariaDB fails #11