Hi support team!
I love to use Solidcp, it seems so smart.
I'm using Solidcp 1.4.2.with MySQL server 5.7. I have config successfully Solidcp connect to MySQL Service in Server Configuration Menu
But now, i only create a new DB but unable to GRANT user database MySQL. When create user DB, Solidcp always say that:
The operation you requested has failed to complete
We apologize for the inconvenience but your request could not be completed at this time. Please contact us on that matter and our support team will do its best to resolve the issue as soon as possible.
Thank you for your cooperation.
Page URL:
http://myIP:9001/Default.aspx?pid=SpaceMySql5&mid=163&ctl=edit_item&SpaceID=13
Logged User:
serveradmin
Work on Behalf:
myDB
Hosting Space:
13
Stack Trace:
System.Exception: Exception of type 'System.Exception' was thrown.
Please tell me how to fix it?
Thansk team!
Hello,
Can you check the event viewer --> application --> SolidCP log for details on what it's trying to do / error out on?
Optionally Audit log in the serveradmin home --> Account menu might have some more information too.
Regards,
Marco
Thanks Marco Tiggelaar !
Here is my Audit Log and i can't find any information to investigate more
[code]System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> MySql.Data.MySqlClient.MySqlException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OLD_PASSWORD('MIuX081rK8Ia')' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int64& insertedId)
at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId, Boolean force)
at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
at SolidCP.Providers.Database.MySqlServer.ExecuteNonQuery(String commandText, String connectionString)
at SolidCP.Providers.Database.MySqlServer.ChangeUserPassword(String username, String password)
at SolidCP.Providers.Database.MySqlServer.CreateUser(SqlUser user, String password)
at SolidCP.Server.DatabaseServer.CreateUser(SqlUser user, String password)
--- End of inner exception stack trace ---
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) [/code]
And the Log file of MySQL Server
[code]2019-03-19T16:14:21.813211Z 2 Connect root@localhost on mysql using TCP/IP
2019-03-19T16:14:21.816937Z 2 Query SHOW VARIABLES
2019-03-19T16:14:21.824182Z 2 Query SELECT TIMEDIFF(NOW(), UTC_TIMESTAMP())
2019-03-19T16:14:21.828757Z 2 Query SHOW COLLATION
2019-03-19T16:14:21.846300Z 2 Query SET NAMES latin1
2019-03-19T16:14:21.846768Z 2 Query SET character_set_results=NULL
2019-03-19T16:14:21.847261Z 2 Init DB mysql
2019-03-19T16:14:21.847643Z 2 Query SELECT user FROM user WHERE user = 'mydbname'
2019-03-19T16:14:21.918125Z 2 Init DB mysql
2019-03-19T16:14:21.918636Z 2 Query GRANT USAGE ON `mysql`.* TO 'mydbname'@'%' IDENTIFIED WITH 'mysql_native_password' AS '<secret>'
2019-03-19T16:14:21.919825Z 2 Query SHOW WARNINGS[/code]
Hello,
If you go into the MySQL Provider (Configuration -> Servers -> Select Mysql under the server) has the checkbox for "Use OLD_PASSWORD Algorithm:" been enabled?
Thanks,
Trevor
