Thanks for the great project! I'm currently fiddling around with trying to get this to work on the newest Raspberry Pi OS (instead of upgrading the working buster image, which also didn't quite work for me).
Some things have to be fixed for that; e.g., since MariaDB v10.4, you can't alter the users table directly (because it doesn't exist any more), so that
|
UPDATE mysql.user SET Password=PASSWORD('$MYSQL_ROOT_PASSWORD') WHERE User='root'; |
must be replaced by something like
SET PASSWORD FOR 'root'@localhost = PASSWORD('$MYSQL_ROOT_PASSWORD'); and such. Unfortunately, I couldn't resolve some issues with the pinned, oldish python dependencies and never might, I'm very inexperienced with python as such.
Would you be willing to accept a pull-request for the things I managed to fix, even though this might break the script on buster, or should I just collect stuff like that in here for reference?
Thanks for the great project! I'm currently fiddling around with trying to get this to work on the newest Raspberry Pi OS (instead of upgrading the working buster image, which also didn't quite work for me).
Some things have to be fixed for that; e.g., since MariaDB v10.4, you can't alter the users table directly (because it doesn't exist any more), so that
OpenBabyMonitor/setup_server.sh
Line 463 in 40589a4
SET PASSWORD FOR 'root'@localhost = PASSWORD('$MYSQL_ROOT_PASSWORD');and such. Unfortunately, I couldn't resolve some issues with the pinned, oldish python dependencies and never might, I'm very inexperienced with python as such.Would you be willing to accept a pull-request for the things I managed to fix, even though this might break the script on buster, or should I just collect stuff like that in here for reference?