1 minute ago, d00p said:

Please report this as issue via github: https://github.com/Froxlor/Froxlor/issues/new/choose

Will do, thanks! And thanks for the awesome work the froxlor team does, been using and recommending this software for... wow... is it 12 years now?  

Everything is now working except one page in the admin panel:
If I go to Traffic -> Customers and select the first customer by the link on their name I get an empty page.
URL: https://froxlor/admin_customers.php?page=customers&action=su&id=0

But if I select any other customer I jump into the specific customer panel dashboard of another customer. (the "impersonate" feature, but for the wrong customer - not the one I clicked on.)
eg: https://froxlor/admin_customers.php?page=customers&action=su&id=1

I found out that this is happening because there is no user with id 0 in my database. It seems to be a bug in the table, as it's simply enumerated from 0-n, instead of using the actual users id. The same user having the link with id=0 above actually has id=7 under Resources -> Customers, where the link works fine:
https://froxlor/admin_customers.php?page=customers&action=su&sort=customerName&id=7
Same for the mismatched customer links. The ids are just ascending no matter the name of the customer (as it seems).

If I manually edit the link to:
https://froxlor/admin_customers.php?page=customers&action=su&id=7
the link works as expected. So this seems to be a bug in the table, right?

Btw: 
The issues with chrome continued with clean caches until I deleted the cookies for the froxlor admin panel 😕 

3 minutes ago, d00p said:

no, it has not

Not by the froxlor team! Somebody must have intervened manually, as it has now a very specific name I recognise from the server owner  

3 minutes ago, d00p said:

User-Login should work without any issues after a update. Never had any issues with that.

So I feel stupid.
I changed the BROWSER from Chrome to Safari. And the page appeared after login just fine -.-

and the upgrade worked fine too...

Thank you for your time @d00p, sorry for wasting it. 😕 

PS: I am now setting up all services again, so maybe I come back soon(tm) with new issues.  

3 minutes ago, d00p said:

No nothing user related has been renamed.

I meant the froxlor user Admin has been renamed.

3 minutes ago, d00p said:

A deprecated warning will not prevent any logins

Also MySQL User Login != Froxlor webui Login. These are completely different things.

Good to know! Yeah, I though the message meant the login has been denied, it doesn't though.

 

I am one step further. mysql is throwing errors for a denied user. Thanks to the new ambiguous error reporting I cannot see which one, but from the time its fairly certain it's froxlor.
 

2024-02-03T21:50:43.502355Z 298 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-02-03T21:50:43.814065Z 299 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-02-03T21:50:43.853263Z 300 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'

However when I login from the command line, using the user and password provided in userdata.inc.php:

<?php
//automatically generated userdata.inc.php for Froxlor
$sql['host']='127.0.0.1';
$sql['user']='froxlor';
$sql['password']='secret';
$sql['db']='froxlor';
$sql_root[0]['caption']='Default';
$sql_root[0]['host']='127.0.0.1';
$sql_root[0]['user']='root';
$sql_root[0]['password']='evenmoresecret';
?>

I get no error:

$ mysql -u froxlor -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 301
Server version: 8.0.36-0ubuntu0.22.04.1 (Ubuntu)

Copyright (c) 2000, 2024, Oracle and/or its affiliates.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use froxlor;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> SELECT `value` FROM `panel_settings` WHERE `varname` = 'passwordcryptfunc';
+-------+
| value |
+-------+
| 2y    |
+-------+
1 row in set (0.00 sec)

 

17 minutes ago, d00p said:

/var/customers/tmp/froxlor.panel/

This folder doesn't even exist  

I just removed the fpm configuration for the froxlor vhost - still no joy and same behaviour as detailed above.

I also checked the database for the local froxlor user. User with adminid 1 seems to have been renamed in the past to a custom login name. But that shouldn't be an issue, should it?
I checked the used crypt method:
 

SELECT `value` FROM `panel_settings` WHERE `varname` = 'passwordcryptfunc'

which came back as '2y'

2 should be blowfish, correct?
How can I match - or regenerate a new password for the user? Although I am certain that it still worked before and after the upgrade to 20.04, where I logged in to froxlor for a quick sanity check.

17 minutes ago, d00p said:

This still exists? It should be libnss-extrausers for years now.

The server was from 2018, so yeah, it DID exist  - I installed libnss-extrausers now.

Thanks for your suggestions!

Good day to you, or good night, depending on the rotation of your location

I have upgraded a server running Froxlor 0.10.x from Ubuntu 18.04 in the following way:

• disabled all external sources
• Ubuntu 18.04 -> 20.04
• remove froxlor package, as it was blocking due to unmet dependencies (same with ibnss-mysql-bg)
• Ubuntu 20.04 -> 22.04
• followed upgrade guide from 0.10 -> 2.0 -> 2.1 (dovecot & proftpd)
• added froxlor repo
• Froxlor install 2.1.6-1
• Froxlor page not found
• fixed location in froxlor vhosts, apparently moved from /var/www/froxlor to /var/www/html/froxlor
• page shows internal server error, logs show php7.4-fpm not available (duh)
• fixed php-fpm failures: since it was looking for 7.4 I manually edited the froxlor vhost to 8.1
• Froxlor page reachable and shows:
  

However any login throws me back to above page with no additional shown errors or changes. Looks like a simple page refresh.

There are no errors in /var/log/apache2/error.log, so I created an error config in the vhost I am accessing (ErrorLog "/var/log/apache2/froxlor_error.log") -> file remains empty.

At this point I am out of ideas and hope that somebody can help me. 🙏