Recent Posts
81
CentOS-WebPanel Bugs / Re: Can't update linux OS because of mysql-common
« Last post by overseer on October 27, 2025, 11:27:49 PM »Code: [Select]
rpm -qa | grep mysql-common
yum remove mysql-common
yum remove mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_6482
CentOS-WebPanel Bugs / Can't update linux OS because of mysql-common
« Last post by Linux on October 27, 2025, 11:18:55 PM »Hello!
Got a message to update the os, did update but it failed with the error below.
In order to avoid that error and update the rest of the system, i used the command:
Got a message to update the os, did update but it failed with the error below.
In order to avoid that error and update the rest of the system, i used the command:
Code: [Select]
yum -x 'mysql-common-*' -x 'mysql-libs-*' update
Code: [Select]
Error: Transaction test error:
file /usr/share/mysql/charsets/Index.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/armscii8.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/ascii.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp1250.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp1251.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp1256.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp1257.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp850.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp852.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/cp866.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/dec8.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/geostd8.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/greek.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/hebrew.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/hp8.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/keybcs2.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/koi8r.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/koi8u.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/latin1.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/latin2.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/latin5.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/latin7.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/macce.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/macroman.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
file /usr/share/mysql/charsets/swe7.xml from install of mysql-common-8.0.43-1.module_el8.10.0+4049+06e4dcce.x86_64 conflicts with file from package MariaDB-common-10.11.14-1.el8.x86_64
83
CentOS-WebPanel Bugs / Re: Issues with PHP version swither (php_switch_v2)
« Last post by Linux on October 27, 2025, 11:05:57 PM »I don't follow your logic. No company offers indemnity against CVE or 0-day exploits. Not Red Hat, not Oracle, not cPanel. None will reimburse you for lost time or recovery efforts (and even a product refund is very unlikely). Many are setting up bug bounty programs to prevent such public damage to their products (and therefore their reputation) and the open source world expects their code to be reviewed by knowledgeable coders. You can purchase insurance against exploits if you want, though...Sorry to disappoint you but you are wrong - "It's up to you to secure your core system and reduce your attack surface.". Stop making excuses for the devs.
But really, this is a value proposition to provide you with an inexpensive web panel to make administration easier for you and end users. It's up to you to secure your core system and reduce your attack surface. A secure (and backed up) system won't have as much of a problem with a 0-day or CVE without an immediate patch.
Still no fix for php_switch_v2.
84
Installation / Re: Problems installing CWP 8 with MariaDB
« Last post by overseer on October 27, 2025, 12:33:48 AM »You should be able to manually migrate, no problem. I just had to manually migrate my last CentOS 7 server to AlmaLinux 8 because I was continually encountering a bug with CWP Migration (even though it's worked just fine for me for other servers). You dump all DB to a single SQL file, on the new server create the user accounts you are replicating, load the DB SQL on the new server and rsync in all your files -- /home and /var/vmail. (Also move any conf you want to carry over -- CSF firewall, Roundcube, nginx vhosts, DNS zone files, etc.).
https://wiki.centos-webpanel.com/how-to-manually-import-emails
But the postfix DB, particularly the mailbox table has all the end user PW hashes stored. So recreating that DB on the new server will get you all the user PW you need. No need to recreate any mail user accounts or aliases. Also bring over the roundcube DB for a seamless mail experience. Just make sure their /var/vmail IMAP storage is in place and all the references will point appropriately. Voila!
https://wiki.centos-webpanel.com/how-to-manually-import-emails
But the postfix DB, particularly the mailbox table has all the end user PW hashes stored. So recreating that DB on the new server will get you all the user PW you need. No need to recreate any mail user accounts or aliases. Also bring over the roundcube DB for a seamless mail experience. Just make sure their /var/vmail IMAP storage is in place and all the references will point appropriately. Voila!
85
MySQL / Re: MariaDB Password Reset Script Doesn't Work
« Last post by overseer on October 26, 2025, 11:30:08 PM »Yes, that script is defunct. Use this instead:
https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
https://www.digitalocean.com/community/tutorials/how-to-reset-your-mysql-or-mariadb-root-password
86
MySQL / MariaDB Password Reset Script Doesn't Work
« Last post by Wonder on October 26, 2025, 10:11:03 PM »I know this script worked perfectly before.
I've recently done several installations of CWP 8 (for various tests), and after installing CWP 8 without restarting, if we run the password reset script, it works. However, if we restart CWP 8 after installing it, it no longer works, and from what I can see, we lose access to CWP administration (and therefore, the MariaDB service is inoperative).
I've tested it with both the stock and upgraded versions of MariaDB.
I understand that, over time and with updates, the script has become "outdated."
This is the code that appears when we run it:
Code: [Select]
/scripts/mysql_pwd_resetI've recently done several installations of CWP 8 (for various tests), and after installing CWP 8 without restarting, if we run the password reset script, it works. However, if we restart CWP 8 after installing it, it no longer works, and from what I can see, we lose access to CWP administration (and therefore, the MariaDB service is inoperative).
I've tested it with both the stock and upgraded versions of MariaDB.
I understand that, over time and with updates, the script has become "outdated."
This is the code that appears when we run it:
Code: [Select]
[root@server ~]# /scripts/mysql_pwd_reset
Enter the new root password (at least 8 chars).
Or leave it empty if you would like to generate it.
Or press CTRL+C to abort and do not touch it
Enter MySQL root password (NO special characters): testpass9876
Shutting down any mysql processes...
/scripts/mysql_pwd_reset: line 14: [: -eq: unary operator expected
Redirecting to /bin/systemctl stop mariadb.service
/scripts/mysql_pwd_reset: line 26: [: -eq: unary operator expected
Redirecting to /bin/systemctl start mariadb.service
Resetting password... hold on
--------------
UPDATE mysql.user SET Password=PASSWORD('testpass9876'),Authentication_string=PASSWORD('testpass9876') WHERE user='root'
--------------
ERROR 1348 (HY000) at line 1: Column 'Password' is not updatable
Cleaning up...
/scripts/mysql_pwd_reset: line 14: [: -eq: unary operator expected
Redirecting to /bin/systemctl stop mariadb.service
Password reset has been completed
New MySQL root password: testpass9876
Remember to store this password safely!
/scripts/mysql_pwd_reset: line 26: [: -eq: unary operator expected
Redirecting to /bin/systemctl start mariadb.service
[root@server ~]#87
Installation / Re: Problems installing CWP 8 with MariaDB
« Last post by Wonder on October 26, 2025, 09:41:24 PM »There's isn't a mariadb repo right after the CWP installation anymore, since the version they are installing is past EOL.Yes, that's what I've seen. A fresh CWP installation doesn't have a MariaDB repository.
Regarding these instructions:
Quote
You also don't need to disable the whole cwp.repo, you can just add this form the above, so MariaDB won't try to install from it.I could swear I tried it, I could swear I tried it and it didn't work, but now I'm doubting it. I did a lot of testing to be able to post here with confidence. And this point, I think I tried it and it didn't work, but I can't be 100% sure, maybe 90% sure. Since I have a test server now, I can test it and be sure.
You add this to cwp.repo below enabled=1Code: [Select]exclude=mariadb*
Then follow the upgrade instructions from AlphaGNU.
Quote
All of our servers run AL9 with CWP.Indeed, I don't need PHP below 7.4 on two out of three sites, and I'm using AL8 on all of them.
If you don't need PHP below 7.4 or site migration (problem with 2 different security algorithms) AL9 would be better.
And if you want, do the basic AL9 image, and I can login and get everything installed for you. (no cost)
You would just need to PM me your login info.
But... if I have the problem you mentioned, I need a migration. I can migrate the website and the database manually, but not the email accounts. I can rsync the email accounts, but, above all, I have a server with many email accounts and the password. I can't ask them to reset it (the password for the email accounts). That would have to be migrated. And it's one of the two issues you mentioned, the migration, which is why it's so important to me, because of the email accounts.
Regarding the basic AL9 image, you can't imagine how much I appreciate it. I installed AL9 from scratch, but unlike AL8, I've noticed that iptables must be installed to activate CSF, and that makes me think maybe more things are needed. It would be helpful to know what those things are. I'll contact you.
Let's see if CWP 9 evolves further and isn't still in Beta...
Thank you sincerely.
88
CentOS-WebPanel Bugs / Re: Issues with PHP version swither (php_switch_v2)
« Last post by overseer on October 26, 2025, 06:35:37 PM »I don't follow your logic. No company offers indemnity against CVE or 0-day exploits. Not Red Hat, not Oracle, not cPanel. None will reimburse you for lost time or recovery efforts (and even a product refund is very unlikely). Many are setting up bug bounty programs to prevent such public damage to their products (and therefore their reputation) and the open source world expects their code to be reviewed by knowledgeable coders. You can purchase insurance against exploits if you want, though...
But really, this is a value proposition to provide you with an inexpensive web panel to make administration easier for you and end users. It's up to you to secure your core system and reduce your attack surface. A secure (and backed up) system won't have as much of a problem with a 0-day or CVE without an immediate patch.
But really, this is a value proposition to provide you with an inexpensive web panel to make administration easier for you and end users. It's up to you to secure your core system and reduce your attack surface. A secure (and backed up) system won't have as much of a problem with a 0-day or CVE without an immediate patch.
89
CentOS-WebPanel Bugs / Re: Issues with PHP version swither (php_switch_v2)
« Last post by Linux on October 26, 2025, 05:23:26 PM »CWP Pro is well worth the few $$ to support the development and gain useful features.Yeah right, I can see that very well with the "development" part. Buy and use pro, then surprize - your server is hacked. Is cwp going to pay any damages to hundreds of websites for not securing their panel? No.
90
CentOS-WebPanel Bugs / Re: Issues with PHP version swither (php_switch_v2)
« Last post by Linux on October 26, 2025, 05:20:24 PM »What OS are you installing CWP onto?Cwp is installed on Almalinux 8.10
Are you able to switch to PHP 8.2 or 8.3?
There are 2 versions of PHP that don't have vulnerabilities: 8.1.33 and 8.2.29. No, it did not work switching to php 8.2. I'm not interested in making experiments with my time.
