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 [2]
16
MySQL / Re: MySQL Manager in CWP not working
« on: October 24, 2024, 11:28:32 AM »
/etc/my.cnf
[mysqld]
performance-schema=0
max_connections=150
max_user_connections=100
query_cache_size=0
skip-external-locking
table_open_cache=2048
sort_buffer_size=2M
net_buffer_length=24K
read_buffer_size=512K
read_rnd_buffer_size=512K
innodb_buffer_pool_size=24G
innodb_file_per_table=1
tmp_table_size=512M
max_heap_table_size=512M
thread_cache_size=32
open_files_limit=32961
max_allowed_packet=512M
log-error=/var/log/mariadb/mariadb.log
sql_mode="NO_ENGINE_SUBSTITUTION"
# InnoDB
innodb_fast_shutdown=1
#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d
[mysqld]
performance-schema=0
max_connections=150
max_user_connections=100
query_cache_size=0
skip-external-locking
table_open_cache=2048
sort_buffer_size=2M
net_buffer_length=24K
read_buffer_size=512K
read_rnd_buffer_size=512K
innodb_buffer_pool_size=24G
innodb_file_per_table=1
tmp_table_size=512M
max_heap_table_size=512M
thread_cache_size=32
open_files_limit=32961
max_allowed_packet=512M
log-error=/var/log/mariadb/mariadb.log
sql_mode="NO_ENGINE_SUBSTITUTION"
# InnoDB
innodb_fast_shutdown=1
#
# This group is read both by the client and the server
# use it for options that affect everything
#
[client-server]
#
# include *.cnf from the config directory
#
!includedir /etc/my.cnf.d
17
MySQL / Re: MySQL Manager in CWP not working
« on: October 24, 2024, 11:24:54 AM »
The passw in /root/.my.cnf file hasn't got quotes. Need to insert ?. In another server, where the SQL Manager works well, the password does not have quotes.
18
MySQL / Re: MySQL Manager in CWP not working
« on: October 24, 2024, 11:10:17 AM »cat /usr/local/cwpsrv/htdocs/resources/admin/include/db_conn.php
<?php
/* MySQL hostname [ localhost (127.0.0.1 via TCP/IP) ] */
$db_host = "localhost";
/* The name of the database */
$db_name = "root_cwp";
/* MySQL database username */
$db_user = "root";
/* MySQL database password */
$db_pass = '#Asfe33#frWBVv@';
//Password used for encryptions (don't change)
$crypt_pwd = 'gMV6bAeiVBFX';
?>
cat /root/.my.cnf
[client]
password=#Asfe33#frWBVv@
user=root
Same password. I was able to log in to the MySQL user without any problems
19
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?
20
Updates / Re: yum -y update ///
« on: August 24, 2023, 11:34:08 PM »
make the change in /etc/yum.repos.d/mariadb.repo and it works perfect !
thanxss !!!!
thanxss !!!!
21
Updates / Re: yum -y update ///
« on: August 22, 2023, 11:56:21 PM »
In other Server, I use the CWP Updates, and appear the same problem.
-----------------------------------------------------------------------------------
This message appear after Update :::
Update All
×
Package updated successfully.
--------------
Last metadata expiration check: 0:00:19 ago on Tue Aug 22 20:38:48 2023.
Dependencies resolved.
================================================================================
Package Architecture Version Repository Size
================================================================================
Upgrading:
MariaDB-server x86_64 11.0.3-1.el8 mariadb-main 27 M
Transaction Summary
================================================================================
Upgrade 1 Package
Total download size: 27 M
Downloading Packages:
MariaDB-server-11.0.3-1.el8.x86_64.rpm 24 MB/s | 27 MB 00:01
--------------------------------------------------------------------------------
Total 23 MB/s | 27 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64 1/1
Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64 1/2
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.11.3-1.el8.x86_64) is installed.
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 ' 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
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
-----------------------------------------------------------------------------------
This message appear after Update :::
Update All
×
Package updated successfully.
--------------
Last metadata expiration check: 0:00:19 ago on Tue Aug 22 20:38:48 2023.
Dependencies resolved.
================================================================================
Package Architecture Version Repository Size
================================================================================
Upgrading:
MariaDB-server x86_64 11.0.3-1.el8 mariadb-main 27 M
Transaction Summary
================================================================================
Upgrade 1 Package
Total download size: 27 M
Downloading Packages:
MariaDB-server-11.0.3-1.el8.x86_64.rpm 24 MB/s | 27 MB 00:01
--------------------------------------------------------------------------------
Total 23 MB/s | 27 MB 00:01
Running transaction check
Transaction check succeeded.
Running transaction test
Transaction test succeeded.
Running transaction
Preparing : 1/1
Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64 1/1
Running scriptlet: MariaDB-server-11.0.3-1.el8.x86_64 1/2
******************************************************************
A MySQL or MariaDB server package (MariaDB-server-10.11.3-1.el8.x86_64) is installed.
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 ' 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
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
22
Updates / Re: yum -y update ///
« on: August 22, 2023, 06:35:58 PM »
/////Not sure where you got those instructions from, but they are wrong for CWP. ////
running yum -y update from SSH console, I got that message.
I also tried changing the repository, but it doesn't work either.
running yum -y update from SSH console, I got that message.
I also tried changing the repository, but it doesn't work either.
23
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
24
Installation / Re: CentOS migration plan for 2024?
« on: July 04, 2023, 06:59:01 PM »
HI... Im working Fine with Alma8 !!!!!,
Pages: 1 [2]
