hello guyz!
Sorry if I'm not in the right section of the forum.
I upgraded Mariadb from 10.1 to 10.5 by following the commands below:
Adding the repo:
I tried to follow this solution: https://support.plesk.com/hc/en-us/articles/213369589-Unable-to-access-Plesk-Unknown-database-psa-
but I'm facing an error message after running this command:
Error message:
By checking the log, I have these lines when I try to access to plesk:
Any help would be much appreciated since it's a on prod server.
PS: Websites hosted on the server are working well.
Sorry if I'm not in the right section of the forum.
I upgraded Mariadb from 10.1 to 10.5 by following the commands below:
Adding the repo:
Upgrade:sudo apt-get install software-properties-common dirmngr apt-transport-https
sudo apt-key adv --fetch-keys 'https://mariadb.org/mariadb_release_signing_key.asc'
sudo add-apt-repository 'deb [arch=amd64,i386,ppc64el,arm64] https://mirror.its.dal.ca/mariadb/repo/10.5/debian stretch main'
Once done, I checked Mariadb version and it's 10.5. The bad news, I just realized that Plesk seems to to be disappeared from my server. The 'plesk' command is no longer working.sudo systemctl stop mariadb
sudo apt-get remove mariadb-server-10.1
sudo apt-get autoremove
sudo apt-get update
sudo apt-get install mariadb-server
sudo systemctl start mariadb
sudo mysql_upgrade
I tried to follow this solution: https://support.plesk.com/hc/en-us/articles/213369589-Unable-to-access-Plesk-Unknown-database-psa-
but I'm facing an error message after running this command:
zcat mysql.daily.dump.0.gz | sed -n '/-- Current Database: `psa`/,/-- Current Database:*/p' | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin
Error message:
ERROR 1265 (01000) at line 3461: Data truncated for column 'event_type' at row 103
By checking the log, I have these lines when I try to access to plesk:
2022/02/24 22:40:56 [error] 12375#0: *1952 directory index of "/opt/psa/admin/htdocs/" is forbidden, client: 142.120.129.193, server: , request: "GET / HTTP/1.1", host: "srv.XXXXXXXX.XX:8443"
2022/02/24 22:40:56 [error] 12375#0: *1952 open() "/opt/psa/admin/htdocs/error_docs/403.html" failed (2: No such file or directory), client: 142.120.129.193, server: , request: "GET / HTTP/1.1", host: "srv.XXXXXXXX.XX:8443"
Any help would be much appreciated since it's a on prod server.
PS: Websites hosted on the server are working well.