Debian 10 to 11 upgrade phpadmin error

themew · March 20, 2022, 7:55pm

I did an upgrade on our staging server with Debian 10 to 11 with hestiacp 1.15.11 installed with no issues.

Then, I did the update on a live server, and no issues except it shows a phpadmin screen asking to install phpmyadmin using apache (the server is an NGINX only machine) or lighttpd. I chose none and hit CANCEL.

The server and hestiacp panel are working, and I can log into my phpmyadmin from the panel button or the URL but I can’t get past this error:

The version of phpmyadmin from the hestiacp button is the current 5.0.4 version.

Any ideas would be helpful. Thanks!

eris · March 20, 2022, 8:02pm

I have no experience with phpmyadmin migration from 10 to 11

I suggest you to run:

github.com

hestiacp/hestiacp/blob/main/install/upgrade/manual/migrate_phpmyadmin.sh

#!/bin/bash
# info: Disconnect phpMyadmin from APT and solving issues with PHPMyadmin accidental updates from ATP

#----------------------------------------------------------#
#                    Variable&Function                     #
#----------------------------------------------------------#

# Includes
source $HESTIA/func/main.sh
# get current phpmyadmin version 
source $HESTIA/install/upgrade/upgrade.conf
source $HESTIA/conf/hestia.conf

#----------------------------------------------------------#
#                    Verifications                         #
#----------------------------------------------------------#

echo "To remove phpMyAdmin you will need use the root password. Password can be found in /usr/local/hestia/conf/mysql.conf"
read -p 'Would you like to continue? [y/n]'

This file has been truncated. show original

themew · March 20, 2022, 9:03pm

Do I also need to update these repos from buster to bullseye (didn’t do this in staging)

root@server:/etc/apt/sources.list.d# cat hestia.list
deb [arch=amd64 signed-by=/usr/share/keyrings/hestia-keyring.gpg] https://apt.hestiacp.com/ buster main
root@server:/etc/apt/sources.list.d# cat mariadb.list
deb [arch=amd64 signed-by=/usr/share/keyrings/mariadb-keyring.gpg] https://mirror.mva-n.net/mariadb/repo/10.5/debian buster main
root@server:/etc/apt/sources.list.d# cat nginx.list
deb [arch=amd64 signed-by=/usr/share/keyrings/nginx-keyring.gpg] https://nginx.org/packages/mainline/debian/ buster nginx
root@server:/etc/apt/sources.list.d# cat php.list
deb [arch=amd64 signed-by=/usr/share/keyrings/sury-keyring.gpg] https://packages.sury.org/php/ buster main

eris · March 20, 2022, 9:06pm

Yes

So more changes
Install: HestiaCP + Debian 11 - #5 by eris

themew · March 21, 2022, 6:33pm

Thanks @eris – got both source lists updated.

Since my hestiacp panel and phpmyadmin works, can I simply apt-mark hold phpmyadmin to prevent Debian from updating the package? Will hestiacp continue to update phpmyadmin when new hestiacp updates are pushed?

eris · March 21, 2022, 6:35pm

Yes, and yes

eris · March 22, 2022, 12:24am

See

github.com

hestiacp/hestiacp/blob/main/CHANGELOG.md

# Changelog
All notable changes to this project will be documented in this file.

## [1.5.11] - Service release

### Bugfixes
- Fixed an issue where Hestia port change did not update chain for fail2ban (#2465)
- Fixed permission issues with /var/log/roundcube (#2466)
- Fixed multiple issues in UI (#2464)
- Allow v-change-user-template update backend templates (#2475)
- Update composer dependencies (#2458 #2459)
- Fixed an XSS vulnerability in "Edit" server page. (#2471) [CVE-2022-0986](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-0986)
- Fixed an issue with caching templates and internal redirects (#2482)

## [1.5.10] - Service release

### Bugfixes
- Fixed an issue where webmail client options were not displayed in the Web UI (#2445)
- Fixed an issue where users where not able to create an backup. (#2448 / #2449)
- Fixed an issue where saving server settings could fail due to an incorrect PHP version check on mod-php servers (#2451)

This file has been truncated. show original

github.com

hestiacp/hestiacp/blob/main/CHANGELOG.md#dependencies-1

# Changelog
All notable changes to this project will be documented in this file.

## [1.5.11] - Service release

### Bugfixes
- Fixed an issue where Hestia port change did not update chain for fail2ban (#2465)
- Fixed permission issues with /var/log/roundcube (#2466)
- Fixed multiple issues in UI (#2464)
- Allow v-change-user-template update backend templates (#2475)
- Update composer dependencies (#2458 #2459)
- Fixed an XSS vulnerability in "Edit" server page. (#2471) [CVE-2022-0986](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-0986)
- Fixed an issue with caching templates and internal redirects (#2482)

## [1.5.10] - Service release

### Bugfixes
- Fixed an issue where webmail client options were not displayed in the Web UI (#2445)
- Fixed an issue where users where not able to create an backup. (#2448 / #2449)
- Fixed an issue where saving server settings could fail due to an incorrect PHP version check on mod-php servers (#2451)

This file has been truncated. show original

github.com

hestiacp/hestiacp/blob/main/CHANGELOG.md#dependencies-2

# Changelog
All notable changes to this project will be documented in this file.

## [1.5.11] - Service release

### Bugfixes
- Fixed an issue where Hestia port change did not update chain for fail2ban (#2465)
- Fixed permission issues with /var/log/roundcube (#2466)
- Fixed multiple issues in UI (#2464)
- Allow v-change-user-template update backend templates (#2475)
- Update composer dependencies (#2458 #2459)
- Fixed an XSS vulnerability in "Edit" server page. (#2471) [CVE-2022-0986](https://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2022-0986)
- Fixed an issue with caching templates and internal redirects (#2482)

## [1.5.10] - Service release

### Bugfixes
- Fixed an issue where webmail client options were not displayed in the Web UI (#2445)
- Fixed an issue where users where not able to create an backup. (#2448 / #2449)
- Fixed an issue where saving server settings could fail due to an incorrect PHP version check on mod-php servers (#2451)

This file has been truncated. show original

Probally a few more…

Hmm it doesn’t like anchors…

themew · March 22, 2022, 3:19pm

Yup, I see now that Packages for phpMyAdmin, Roundcube, and Rainloop will be pulled directly from their upstream source instead of APT for new installations. was added in hestiacp 1.4.0 but since I upgraded an existing install, APT wasn’t blocked.

Thanks again for your help @eris. Really appreciate it.

system · April 21, 2022, 3:19pm

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.