Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
Pages: [1]
1
Updates / Problem Yesterday Update (19Dic)
« on: December 20, 2024, 04:58:15 AM »
Yesterday, I perfomed an important update from the CWP root panel. After completing the update, the created subdomains stopped working and started returning a 500Error. Any Ideas or Scripts to resolve this issue ?
2
CentOS 8 Problems / New Account Failed
« on: December 03, 2024, 04:59:17 PM »
Have an idea 
when I create a new account, this message appear :::: Warning! User Account XXXXX not added !!!
using Almalinux 8
when I create a new account, this message appear :::: Warning! User Account XXXXX not added !!!using Almalinux 8
3
CentOS 7 Problems / NEW ACCOUNT Failed
« on: December 03, 2024, 04:57:47 PM »
Have an idea when I create a new account, this message appear :::: Warning! User Account XXXXX not added !!!
when I create a new account, this message appear :::: Warning! User Account XXXXX not added !!!
4
MySQL / MySQL Manager in CWP not working
« on: October 24, 2024, 05:52:06 AM »
MySQL Manager in CWP not working issues:
- list of databases is not shown
- can't create new database
- can't create new user
Using... AlmaLinux release 8.10 (Cerulean Leopard) con 10.11.9-MariaDB
Log error : Invalid database response: ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
root Its OK !
SHOW GRANTS FOR 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED BY PASSWORD '*111111111111111111111111111111' WITH GRANT OPTION |
| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)
Have an idea ?? I saw https://wiki.centos-webpanel.com/mysql-manager-not-working , But I don't know what to check or do to fix it.
Most common issues are that you have added invalid config into mysql config files.
You can check this from the command line by using one of the following commands
mysql --version
mysql Ver 15.1 Distrib 10.11.9-MariaDB, for Linux (x86_64) using readline 5.1
mysql -e "show databases;"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
For MariaDB which is default with CWP please note that you need to add config into file
/etc/my.cnf.d/server.cnf under [mysqld]
What should I do?
- list of databases is not shown
- can't create new database
- can't create new user
Using... AlmaLinux release 8.10 (Cerulean Leopard) con 10.11.9-MariaDB
Log error : Invalid database response: ERROR 1045 (28000): Access denied for user root@localhost (using password: NO)
root Its OK !
SHOW GRANTS FOR 'root'@'localhost';
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO `root`@`localhost` IDENTIFIED BY PASSWORD '*111111111111111111111111111111' WITH GRANT OPTION |
| GRANT PROXY ON ''@'%' TO 'root'@'localhost' WITH GRANT OPTION |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.000 sec)
Have an idea ?? I saw https://wiki.centos-webpanel.com/mysql-manager-not-working , But I don't know what to check or do to fix it.
Most common issues are that you have added invalid config into mysql config files.
You can check this from the command line by using one of the following commands
mysql --version
mysql Ver 15.1 Distrib 10.11.9-MariaDB, for Linux (x86_64) using readline 5.1
mysql -e "show databases;"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)
For MariaDB which is default with CWP please note that you need to add config into file
/etc/my.cnf.d/server.cnf under [mysqld]
What should I do?
5
Updates / yum -y update ///
« on: August 21, 2023, 12:58:48 PM »
Did someone have trouble updating MariaDB? The Server component is not updating for me. The "mariadb-server" package remains in version 10.11, while "mariadb-client" has been updated to version 11.
Using Almalinux 8
---------------------------------------------------------
Upgrading directly from MySQL 10.11 to MariaDB 11.0 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server
Verifying : MariaDB-server-11.0.3-1.el8.x86_64 1/2
Verifying : MariaDB-server-10.11.3-1.el8.x86_64 2/2
Failed:
MariaDB-server-10.11.3-1.el8.x86_64 MariaDB-server-11.0.3-1.el8.x86_64
Error: Transaction failed
Using Almalinux 8
---------------------------------------------------------
Upgrading directly from MySQL 10.11 to MariaDB 11.0 may not
be safe in all cases. A manual dump and restore using mysqldump is
recommended. It is important to review the MariaDB manual's Upgrading
section for version-specific incompatibilities.
A manual upgrade is required.
- Ensure that you have a complete, working backup of your data and my.cnf
files
- Shut down the MySQL server cleanly
- Remove the existing MySQL packages. Usually this command will
list the packages you should remove:
rpm -qa | grep -i '^mysql-'
You may choose to use 'rpm --nodeps -ev <package-name>' to remove
the package which contains the mysqlclient shared library. The
library will be reinstalled by the MariaDB-shared package.
- Install the new MariaDB packages supplied by MariaDB Foundation
- Ensure that the MariaDB server is started
- Run the 'mysql_upgrade' program
This is a brief description of the upgrade process. Important details
can be found in the MariaDB manual, in the Upgrading section.
******************************************************************
error: %prein(MariaDB-server-11.0.3-1.el8.x86_64) scriptlet failed, exit status 1
Error in PREIN scriptlet in rpm package MariaDB-server
Verifying : MariaDB-server-11.0.3-1.el8.x86_64 1/2
Verifying : MariaDB-server-10.11.3-1.el8.x86_64 2/2
Failed:
MariaDB-server-10.11.3-1.el8.x86_64 MariaDB-server-11.0.3-1.el8.x86_64
Error: Transaction failed
Pages: [1]
