migrating HA addon to version alpine3.18_emoncms11.4.11 - possible issues

[alexandrecuer]

this version is adding ssl and https facilities

[alexandrecuer]

cf 9535fad

[alexandrecuer]

restoring a backup on ha

after installing new version, could not access to emoncms.
reverted to previous version alpine3.16
permissions were wrong on /data/emoncms

had to connect to the container and to fix permissions manually :

chown -R apache /data/emoncms
chown -R mysql /data/emoncms/mysql

[alexandrecuer]

Once reverted to alpine3.16 and connected to emoncms :

Admin > Update > Update Database > APPLY CHANGES

this created the app_config table in mariadb

Dont know why I did not have this table ?

Then I created backup with the emoncms backup module

And relaunched the addon update

[alexandrecuer]

could successfully access to emoncms after the upgrade without troubles but found this kind of errors in the logs :

2024-02-11 21:22:56 701 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'histogram' at position 10 to have type longblob, found type varbinary(255).
2024-02-11 21:23:01 702 [ERROR] Incorrect definition of table mysql.column_stats: expected column 'hist_type' at position 9 to have type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB'), found type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB').

and there is a higher ram usage than before the update :

so once connected to the container and to the mariadb database with the command mysql

the 2 following mysql commands removed the errors in the log

MariaDB [(none)]> ALTER TABLE mysql.column_stats MODIFY histogram longblob;
Query OK, 0 rows affected (0.102 sec)              
Records: 0  Duplicates: 0  Warnings: 0

MariaDB [(none)]> ALTER TABLE mysql.column_stats MODIFY hist_type enum('SINGLE_PREC_HB','DOUBLE_PREC_HB','JSON_HB');
Query OK, 0 rows affected (0.033 sec)
Records: 0  Duplicates: 0  Warnings: 0

[alexandrecuer]

using ngnix proxy manager to get trusted certificates

https://github.com/NginxProxyManager/nginx-proxy-manager

or for ha users :

https://github.com/hassio-addons/addon-nginx-proxy-manager

[alexandrecuer]

all my notes on ssl and https

https://github.com/Open-Building-Management/containers/tree/main/emoncms/alpine_persistent#31012024