notavailable

Hi,

thanks for the quick response, the portable version behaves exactly like the installed version.

All the best

Hi,

i didn't use rdm for ssh in the last months. Today i connected to a server and noticed that the server locale was set to my native language. This would be wrong so I tried to reconfigure the server for 30 minutes - it was impossible.

Then i switched to putty where the server did have the correct language.

Then i did some further testing with RDM:

Reinstalling

Reset Language

Checking the RDM config

Strange behaviour:

Everything in RDM is English but after clicking on the connection, for the certificate password popup RDM switches to German (even the searchbars). After entering the password RDM switches back to English.

RDM is set to English, Windows is set to German and the server has Debian 12 installed.

All the best

Hi,

thank you for the fast fix!

Greetings

Hi,

we have the same Problem with mysql

Hi,

Thank you very much!

Greetings

Hi,

thanks for looking into it!

Greetings

Hi,

i sent the sourcecode.

Thank you!

Greetings

Hi,

we have a bunch of QNAP NAS and like to include them to our RDM but we have some problems with Auto-fill/Login.

Discovery has a small problem because it finds Username ID (username) and Password ID (pwd) but not Login Button ID which should be submit.

But the real problem is that the username autofill does not work. Password does work fine.

RDM Enterprise 6.1.2.0

QTS 4.3.3 + higher

Greetings

Hi,

ok, thats fine, just wanted to know if i can optimize the situation because we needed the new DB.

(maybe also a container db problem)

Thank you for your time and excellent support!

Greetings

Hi,

It was a completely new database. Should i clear it and recreate everything or is there currently a problem with the initializing script? (I also could try to initialize the DB with a windows client)

Thank you very much for your help!

Greetings

Hi,

oh sorry, i didn't saw it.

Every Statement works except:

ALTER TABLE rdm.LoginHistory MODIFY COLUMN CreationDate datetime null; ERROR 1171 (42000): All parts of a PRIMARY KEY must be NOT NULL; if you need NULL in a key, use UNIQUE instead

------------

But: Roles are are working now!

Thank you very much!

--------------

Are there some additional steps or is everything ok now?

Greetings

hi,

any updates?

Greetings

done!

thank you!

Greetings

sure:

[07.11.2018 14:47:44 - 6.0.1.0 64-bit]ERROR MySql.Data.MySqlClient.MySqlException (0x80004005): Field 'CreationDate' doesn't have a default value

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.c62151df7d13ceddef73b4c42194d331e.c3dea6f32f6a4c2f28ec22f618fe1c67f (Devolutions.RemoteDesktopManager.Business.Entities.UserEntity c03a060829e6ffb23a02a911a6c7f9354, System.Data.IDbTransaction cb0e84463dceab1dc0c9748e2f11fdfc1) [0x0041f] in <b81932db67c44bb4a9944935865c675b>:0

at A.c1386f0c36ceb87c848f150120d1ce698.c273918d0a77199f99e4ccbadcbe5b91f (Devolutions.RemoteDesktopManager.Business.Entities.UserEntity c03a060829e6ffb23a02a911a6c7f9354, System.Boolean c58958e21b2557e9fded09d64ed2f0da7, System.String c20a45f64caf6be3bb404afc7e28da849, A.cc920622727084c42f744018197caa94b+ca7828b2254254d519b31a1653896889d c4272a7a2a87934de86e05f41660dd2a6, System.Guid[] c65b4a5d45794dc5ff1b454aef988e35e) [0x001a9] in <b81932db67c44bb4a9944935865c675b>:0

Hi,

everything in the new DB works fine but if i try to assign roles to a user i get the following Error:

Unable to save the user in database!

Field 'CreationDate' doesn't have a default value

Greetings

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

Hi,

they are all checked!

Greetings

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

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

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

Hi,

works like a charm! Thank you!

Greetings

Hi,

i am used to the problem and it did not bother me enough to ask but now i have to copy lots of different texts in some rdp sessions.

Is there a way to prevent RDM to reconnect (the rdp session) nearly every time i copy something? (strg+c and gui)

Greetings

Thank you for your help and identifying the issue!

We will wait until next week and see if there is any progress.

Thank you!

Greetings

Hi,

thank you!

Oh, yes a colleague switched it to MariaDB and i forgot about it (Sorry, nice find). I tried it with the MariaDB connector but still get the same error. Should we switch back to MySQL?

Greetings

MariaDB connector error:

MySql.Data.MySqlClient.MySqlException (0x80004005): Out of sync with server

at MySql.Data.MySqlClient.NativeDriver.ReadOk (System.Boolean read) [0x00097] in <1add403c719d4eeeae437db5aa8f6c1a>:0

at MySql.Data.MySqlClient.NativeDriver.SetDatabase (System.String dbName) [0x0003c] in <1add403c719d4eeeae437db5aa8f6c1a>:0

at MySql.Data.MySqlClient.Driver.SetDatabase (System.String dbName) [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0

at MySql.Data.MySqlClient.MySqlConnection.ChangeDatabase (System.String databaseName) [0x00087] in <1add403c719d4eeeae437db5aa8f6c1a>:0

at MySql.Data.MySqlClient.MySqlConnection.Open () [0x0019d] in <1add403c719d4eeeae437db5aa8f6c1a>:0

at A.c8bb832eaa4caed25b50caade71232a37.cea9773bcf34f5a19ac6169d5f601a034 (System.String c3a7c71f30053a5a40fc3b4f66e72b871, System.Boolean c1b4a1fa885a8033610f52375d3643a7c) [0x00125] in <5550828c379a4180b5d5540eb56c73a4>:0

Full schema dump error:

Schema dump failed with error:

Value cannot be null.

Parameter name: value

Test Schema and Test Host are successful.