Continuing this topic
mysql has been added to nginx services. sql_mode also crashes after restarting mysql, although mysql is running.
Can you please tell me when the update with fixes for these bugs will be released?
Hello @SVADO,
I donβt know when Hestia 1.8.9 will be released but Iβve just found another bug (that I introduced myself when fixing another bug 
) in command v-list-sys-services so I would like to test it with real people before submitting a pull request to github.
If you want to try it.
As root:
cd /usr/local/hestia/bin/
mv v-list-sys-services v-list-sys-services.original
curl -sSL "https://gist.sahsanu.net/sahsanu/7ada3ee79bfe4ff493ef79f56728af87/raw/HEAD/v-list-sys-services.sh" -o v-list-sys-services
chmod +x v-list-sys-services
And check in Web UI whether it works fine again.
If you want to revert the change:
cd /usr/local/hestia/bin/
mv v-list-sys-services.original v-list-sys-services
Cheers,
sahsanu
2 Likes
Perhaps you know why sql_mode resets after restarting mysql?
How did you change the sql_mode ? What modes you are using? You should check mysql log, maybe you will get more info about the error.
I install it through the root user
set global sql_mode='';
You must add spaces before and after the equal:
set global sql_mode = '';
But if you want to do it permanent you should add it to my.cnf in [mysqld] section. Pay attention because in my.cnf conf file, it uses a dash instead of underscore);
sql-mode=""
Please send a PR will merge it β¦
1 Like
I wanted to test it first with real users but⦠here we go 
1 Like