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?
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.
Sorry, I forgot asking in my previous post, what version of RDM are you using?
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 220.127.116.11 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'
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
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
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
Is there a written guide on creating a valid rdm database?
We have a guide to create a SQL Server data source in the RDM Windows online help. It's the same process for MySQL.
Glad that is now working on your side.
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
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.