Cannot be able to c...
 
Notifications
Clear all

Cannot be able to create New User in Newly Created database with MySQL

6 Posts
3 Users
0 Reactions
1,522 Views
Posts: 3
Topic starter
(@supremeelectrical)
New Member
Joined: 7 years ago

I cannot be able to create New User with Newly created database with MySQL.

When I check Audit Log it says::

Server was unable to process request. ---> String 'supremeelectrical_admin' is too long for user name (should be no longer than 16)
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at SolidCP.EnterpriseServer.DatabaseServerController.AddSqlUser(SqlUser item, String groupName)

===================

It only allow me to create New User with default Account Name like 'supremeelectrical_' (Default)  which exceed 16 character so how can I change that Default Name?

5 Replies
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Hello,

The max 16 chars is a mysql limit.

in your case you must have set prefix [USER_NAME]_ in the mysql policy (found under serveradmin home --> bottom right --> Policies).

Your best to change this to [USER_ID]_ to solve the issue.

Regards,

Marco

Reply
Posts: 3
Topic starter
(@supremeelectrical)
New Member
Joined: 7 years ago

Can you please guide me from where I can change [USER_NAME] from my account?. It is under which Menu and Submenu ?

Reply
Posts: 1995
Admin
(@m-tiggelaar)
Noble Member
Joined: 9 years ago

Only the serveradmin can change the policy values for prefixes and suffixes.

If you just have a normal account you will need to check with the Hosting provider to solve this for you.

Reply
Posts: 3
Topic starter
(@supremeelectrical)
New Member
Joined: 7 years ago

Thanks Marco,

However, SolidCP is the hosting provider and I request you to resolve it.

You can email me on writetoapex AT gmail DOT com

 

Thanks

Reply
Page 1 / 2
Share: