Control Web Panel

WebPanel => CentOS 7 Problems => Topic started by: papa on February 06, 2024, 12:37:31 AM

Title: Database not showing for users
Post by: papa on February 06, 2024, 12:37:31 AM

I build a new server on Dec 20 2023
Everything working good. No issues.

Around Jan 15 2024, I noticed that users were not able to see their database on the database manager on their panel.
The databases are there, because the websites work fine and I can see them in phpmyAdmin.

The following is the output of:
[root@app ~]# mysql -e "SELECT @@sql_mode;"
mysql: unknown variable 'sql_mode=STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
[root@app ~]#

Anyone have had this issue and know how to solve it?
Thank you

Title: Re: Database not showing for users
Post by: Starburst on February 06, 2024, 12:33:59 PM

Under SQL Services -> MySQL Manager

Does it show the database and the correct associated database users?

If it does, login via the user control panel link next to the user name under User Accounts -> List Accounts

Let me know what you see.

Title: Re: Database not showing for users
Post by: papa on February 07, 2024, 05:04:07 AM

Thank you for the reply.

I get this: Attention! An error occurred when listing databases.

On the user side, no databases. The only way to see it is from the PHPMyAdmin.

Thank you

Title: Re: Database not showing for users
Post by: josemnunez on February 07, 2024, 10:37:21 AM

Please review this file and delete usernames that are empty or do not have more than 8 characters.

/usr/local/cwp/.conf/mysql_user_prefix.conf

Title: Re: Database not showing for users
Post by: papa on February 07, 2024, 10:08:56 PM

Hi  josemnunez

Thanks for the reply
I found the file mysql_user_prefix.conf
This file is empty. No content on it

Title: Re: Database not showing for users
Post by: overseer on February 08, 2024, 02:40:34 AM

Likewise, all of my CWP servers have that file as empty.

Title: Re: Database not showing for users
Post by: papa on February 08, 2024, 11:34:38 PM

Just wondering maybe an update caused that but I haven't updated anything on this server.
I started to configure another server today. I will replace the one with issues on Sunday. I will check this file and let you know if I find anything

Title: Re: Database not showing for users
Post by: josemnunez on February 10, 2024, 04:12:42 PM

Hello, please indicate the number of your support ticket.

Title: Re: Database not showing for users
Post by: papa on February 10, 2024, 09:58:25 PM

Hi josemnunez

Ticket #351715

Thank you for looking into this issue