Forum / Remote Desktop Manager Mac - Support

User password problems

  • Create an Issue
  • Cancel

Hello,

as suggested in the other thread we switched from mariadb to mysql8. But we have some problems with user passwords.

The admin can't change the user passwords (greyed out) and the users getting this error if they try to change their password (fake pw):


MySql.Data.MySqlClient.MySqlException (0x80004005): 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 'PASSWORD('XXX123XXX')' at line 1
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00096] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.NativeDriver.GetResult (System.Int32& affectedRow, System.Int32& insertedId) [0x0001e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.GetResult (System.Int32 statementId, System.Int32& affectedRows, System.Int32& insertedId) [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.NextResult (System.Int32 statementId, System.Boolean force) [0x00022] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x00205] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x002ad] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery () [0x00033] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at A.c1b7e8caf3fa8e5fb77cc57c00e8d5e1c.ccb0c068e51ad8733a13bd92faee910ce (System.String c0543ca550f15febd1b069e16fd4b95e1, System.Data.IDbTransaction cb0e84463dceab1dc0c9748e2f11fdfc1, System.Data.IDbDataParameter[] c91084b2aae54f62d01e2a4664a847bd7, System.Int32 c582639be48e4a5226d664bc1d05eca02) [0x0005b] in <b81932db67c44bb4a9944935865c675b>:0
at A.c1386f0c36ceb87c848f150120d1ce698.c9ac34df167098069751877ae184b5e40 (Devolutions.RemoteDesktopManager.Business.Entities.UserEntity c6f33bed54aa06487f05d5821ae447437, System.String c1bf26bab6f6332bd8fde28cd487b94ad, System.String cc766e1aec18d3006ae71e73b1270c211) [0x000b1] in <b81932db67c44bb4a9944935865c675b>:0


It is a completely new DB (RDM connections imported from .rdm file)

Greetings

Clock12 mths

Oh just found out that the users can't do anything (no connections, no creation)

Clock12 mths

Hi,

I think changing a username password in a MySQL data source is a known limitation. At least I've tried to do it in RDM windows and the Change password option was absent from the Users Management window and disabled from the File Ribbon tab. I'm filing the issues right now.

As for you second message, RDM data sources are created with the most restrictive level of permissions by default. Is it possible that your root permission (Right click on the Root -> Properties -> Security -> Permissions -> Permission) is set to Never?

Best regards,

Xavier Fortin

signaturesignature

Clock12 mths

Hi,

I correct one of my previous statement. An admin doesn't have access to the Change Password item in the Ribbon but other users do not seem to have this issue. I was able to change my user password in both RDM Windows and RDM Mac. So I couldn't reproduce your scenario (with the error).

Is it possible there is some invalid character in the password that was attempted to be entered? Maybe we're failing to properly escape the password sequence in this specific instance.

Do you have access to a Windows computer? It would be nice to see the difference in behavior between the two RDM clients.

Best regards,

Xavier Fortin

signaturesignature

Clock12 mths

Hi,

Permission is set to default, so this should be no problem.

I tried the password from the error "XXX123XXX" (and some others).

Same behaviour on windows - no connections available and not able to create new ones.

could mysql8 be a problem?

Greetings

Clock12 mths

Hi,

If I understand correctly, the admin can add/edit entries correctly, right?

In the RDM Mac User Management, there is Add/Edit/Delete permissions:

UserPermissions

Are they checked?

Best regards,

Xavier Fortin

signaturesignature

UserPermissions.png
Clock12 mths

Hi,

they are all checked!

Greetings

Clock11 mths

Hi,

i did some troubleshooting:

mysql8 (8.0.13) package installation -> works fine
mysql8 (8.0.13) docker container -> has the same reproducible problem

we switched back to a mysql5 container and everything works again.

Greetings

Clock11 mths

Hi,

This is interesting. We'll investigate this.

Best regards,

Xavier Fortin

signaturesignature

Clock11 mths

Hi Xavier,

We are having the same issue with our database and the version is Aurora MySQL 5.6.10a.
The "Change Password" is disabled under the File menu.

Our version of RDM is 14.0.1.0 on 64bit.

Do you have any updates on your investigation so far?

Looking forward to your response.

Regards,
Ian

Clock12 mths

Hi Ian,

Is it just for admin users? In my case, the "Change Password" item is enabled for other user than the admin.

And to answer your question. No, we haven't had the time to dive in this yet. I'll post back as soon as I have any news.

Best regards,

Xavier Fortin

signaturesignature

Clock12 mths

@Ian Tait


FYI this is a RDM-Mac thread.

So to answer your RDM-Windows question. Yes, we've made changes in RDM v14.0.6.0 that should resolve your change password issue.

https://remotedesktopmanager.com/home/download

Please give it a try.

Best regards,

Stefane Lavergne

signaturesignature

Clock12 mths

I have found the issue in the DB.
We upgrade from version 13 to 14 the other day and noticed the "Change Password" became disabled.

I had noticed that new users had this enabled, which told me it must be a database issue with existing users.

I found in the database, the following

UserSecurity -> My USER -> AuthenticationType (was NULL changed to 2)
Restart RDM and testing confirmed to be working again.

Hope this helps lots of other users out there.

Clock12 mths

@Ian Tait


Nice investigative work.

When AuthenticationType is null (old users) we are suppose to guess/default the value to 2. I will look at why it wasn't happening in this case. When we don't know the type we can't/don't enable change password. For example: a domain user, we can't change the password. I will investigate and fix the issue

Best regards,

Stefane Lavergne

signaturesignature

Clock12 mths