Forum / Remote Desktop Manager Mac - Support

User Management

  • Create an Issue
  • Cancel

Hello,

i've got some questions regarding the user management.

Until now we used RDM as the same user, but now we want to implement some sort of user permissions.

We use MYSQL for our RDM Database and if i try to add some user in RDM, i get some error that RDM can't create a new user in mysql.users. If i give the user the permissions to create an mysql.users entry (trying to avoid), the newly created user gets no permissions to the rdm database.

I tried to find a solution in the online help but i can't change the Authentication Type in the create user form, the only option is "Database".

How can i do this the correct way?

Greetings

Clock2 yrs

Hello,

Firstly, the authentication type using a SQL Server, SQL Azure, MariaDB and/or MySQL is database. This is why you are not able to change it.

Secondly, the user creation. How the MYSQL database was created? Does the database was created from RDM or in another database management software like HeidiSQL?

In conclusion, I would also need the error message that you receive.

Best regards,



Jeff Dagenais

OFFICE CLOSURE!
Although our various support queues will be monitored for emergencies, Devolutions' offices will be closed on June 24 and July 1st, 2019.

signaturesignature

Clock2 yrs

Hello,

Sorry, I forgot asking in my previous post, what version of RDM are you using?

Best regards,



Jeff Dagenais

OFFICE CLOSURE!
Although our various support queues will be monitored for emergencies, Devolutions' offices will be closed on June 24 and July 1st, 2019.

signaturesignature

Clock2 yrs

Hi,

thanks for the quick response.

I created the Database rdm and User rdm in phpmyadmin, i could delete it if you want me to.

We use RDM 5.1.0.0 for Mac

----
I deleted the rdm db and let rdm create it again, no difference.

Errors at user creation:
SELECT command denied to user 'rdm'@'XXXIPXXX' for table 'user'

Details:
MySql.Data.MySqlClient.MySqlException (0x80004005): SELECT command denied to user 'rdm'@'XXXIPXXX' for table 'user'
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.ExecuteScalar () [0x0002e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at A.c1b7e8caf3fa8e5fb77cc57c00e8d5e1c.c27bc2696e54a01b19073e7b8c7a31372 (System.String c0543ca550f15febd1b069e16fd4b95e1, System.Data.IDbTransaction cb0e84463dceab1dc0c9748e2f11fdfc1, System.Data.IDbDataParameter[] c91084b2aae54f62d01e2a4664a847bd7) [0x00039] in <5bdc05cd3b4d4cc398ae9315e62a537f>:0
at A.c1386f0c36ceb87c848f150120d1ce698.cb0fdcceb2ddd3371bf057cfec3bc05f8 (System.Data.IDbTransaction cb0e84463dceab1dc0c9748e2f11fdfc1, System.Data.IDbDataParameter[] c827703dfdb5f1ac48b7246fbb132bdef, System.String c0543ca550f15febd1b069e16fd4b95e1) [0x00006] in <5bdc05cd3b4d4cc398ae9315e62a537f>:0
at A.c1386f0c36ceb87c848f150120d1ce698.cae9f4ffd50ce8b7a50054eb4e0ebb59d (System.String cb72c9169e711f40c477598ce7c102f30, System.Boolean c76f68d50cdd6cf840d582135de367ce5, System.Data.IDbTransaction cb0e84463dceab1dc0c9748e2f11fdfc1) [0x00055] in <5bdc05cd3b4d4cc398ae9315e62a537f>:0
at A.c1386f0c36ceb87c848f150120d1ce698.cd2fd1429191f37f6a2f400d3388eaef2 (Devolutions.RemoteDesktopManager.Business.Entities.UserEntity c03a060829e6ffb23a02a911a6c7f9354, System.Boolean c58958e21b2557e9fded09d64ed2f0da7, System.String c20a45f64caf6be3bb404afc7e28da849, A.cc920622727084c42f744018197caa94b+c19f5f7101ba3557f42c24fd806a11e8b c4272a7a2a87934de86e05f41660dd2a6, System.Guid[] c65b4a5d45794dc5ff1b454aef988e35e) [0x000f9] in <5bdc05cd3b4d4cc398ae9315e62a537f>:0

Next window:
Unable to save the user in the database!

The user has insufficient privileges to read from table mysql.user and/or create server logins.

Please check with your dba or user 'root' user to create a proper Remote Desktop Manager admin user. The system will grant all required privileges automatically.

Raw error: SELECT command denied to user 'rdm'@'XXXIPXXX' for table 'user'
-----
Then i gave the rdm user the rights for mysql.user and it creates a new mysql user without any rights
-----


Thank you smile

Clock2 yrs

Ok i fixed it.

Deleted everything rdm related in the database
Entered the root credentials to the database
Let RDM create the database schema
Created a rdm admin user
changed the data source to the rdm admin user

now everything seems to be working smile

Is there a written guide on creating a valid rdm database?
Greetings

Clock2 yrs

Hello,

We have a guide to create a SQL Server data source in the RDM Windows online help. It's the same process for MySQL.
https://help.remotedesktopmanager.com/installation_configuresqlserver.htm

Glad that is now working on your side.

Best regards,



Jeff Dagenais

OFFICE CLOSURE!
Although our various support queues will be monitored for emergencies, Devolutions' offices will be closed on June 24 and July 1st, 2019.

signaturesignature

Clock2 yrs

Hi,

oh thats why i did not find it. Thank you!

Everything works now as it should, but i got in some sort of trouble. I deleted the "root" user in RDM because nobody should use it for RDM, but unfortunately it also deleted the mysql % root user which was not my intention wink

It was an easy fix but now i do not know how to prevent that behavior, because someone in my company is going to delete the root user in RDM again.

Greetings

Clock2 yrs