Control Web Panel

WebPanel => CentOS-WebPanel Bugs => Topic started by: mkaioh2 on February 19, 2024, 10:22:01 PM

Title: I can't create databases correctly
Post by: mkaioh2 on February 19, 2024, 10:22:01 PM

Help me, please watch my video.  https://youtu.be/Zrv9RjArmvM

Title: Re: I can't create databases correctly
Post by: overseer on February 19, 2024, 11:00:36 PM

What version of MariaDB are you using?

Title: Re: I can't create databases correctly
Post by: mkaioh2 on February 20, 2024, 12:56:25 AM

How i can know the version ?

Title: Re: I can't create databases correctly
Post by: overseer on February 20, 2024, 02:46:28 AM

It's on the home screen of the CWP Admin panel, under the Application Version box:

Code: [Select]

MySQL version: 10.6.17-MariaDB


Title: Re: I can't create databases correctly
Post by: mkaioh2 on February 20, 2024, 06:31:28 PM

Quote from: overseer on February 20, 2024, 02:46:28 AM

It's on the home screen of the CWP Admin panel, under the Application Version box:

Code: [Select]

MySQL version: 10.6.17-MariaDB


Database client version: libmysql - mysqlnd 5.0.12-dev - 20150407 - $Id: 3591daad22de08524295e1bd073aceeff11e6579 $

Title: Re: I can't create databases correctly
Post by: overseer on February 21, 2024, 03:06:36 AM

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

Title: Re: I can't create databases correctly
Post by: mkaioh2 on February 21, 2024, 05:11:42 PM

Quote from: overseer on February 21, 2024, 03:06:36 AM

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

Server version: 10.4.33-MariaDB - MariaDB Server

Title: Re: I can't create databases correctly
Post by: overseer on February 22, 2024, 03:00:01 AM

Can you put in a support ticket? You may have uncovered a bug, but difficult to say from here as I haven't encountered this on my servers.

Title: Re: I can't create databases correctly
Post by: josemnunez on February 22, 2024, 07:52:59 AM

please check the following file  /usr/local/cwp/.conf/mysql_user_prefix.conf

here you should find something like this

eskuchame:eskucham

Title: Re: I can't create databases correctly
Post by: Starburst on February 22, 2024, 01:23:23 PM

Quote from: overseer on February 21, 2024, 03:06:36 AM

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

@overseer, for some reason the CWP Admin Panel shows the client version.
Found this bug when testing MariaDB 11.x with how it queried the version running.

Title: Re: I can't create databases correctly
Post by: mkaioh2 on February 22, 2024, 05:44:34 PM

Quote from: Starburst on February 22, 2024, 01:23:23 PM

Quote from: overseer on February 21, 2024, 03:06:36 AM

I meant the MySQL server you have installed, not the client version. Look at the info box on the home screen of the CWP Admin panel.

@overseer, for some reason the CWP Admin Panel shows the client version.
Found this bug when testing MariaDB 11.x with how it queried the version running.

where i can find it?
/usr/local/cwp/.conf/mysql_user_prefix.con

in FTP? or ROOT?

Title: Re: I can't create databases correctly
Post by: Starburst on February 22, 2024, 06:03:38 PM

SSH into you server or access local terminal

Then just enter:

Code: [Select]

nano /usr/local/cwp/.conf/mysql_user_prefix.conf
You will see a list of the username prefixes. Which should match the Username under User Accounts.

Title: Re: I can't create databases correctly
Post by: mkaioh2 on February 22, 2024, 07:30:16 PM

I FOUND IT =D what i should be there?

image -> https://i.ibb.co/YbCP6D0/Sin-t-tulo3.jpg

look at my image please, you will see that eskuchame does not have eskuchame:eskuchame so what should I do there?

Title: Re: I can't create databases correctly
Post by: Starburst on February 22, 2024, 08:05:49 PM

That looks fine.

It how mine look also just username:
Nothing after.

Title: Re: I can't create databases correctly
Post by: josemnunez on February 22, 2024, 08:56:52 PM

Delete the empty lines, here there should only be the users who have more than 8 characters as a username and the prefix only with 8, as shown in the example

Title: Re: I can't create databases correctly
Post by: overseer on February 22, 2024, 10:04:01 PM

The file /usr/local/cwp/.conf/mysql_user_prefix.conf is blank on my servers, but are migrated from cPanel originally and I still follow the convention of ≤8 chars for a username when I set up new accounts, even though longer is now possible.