Forum

Posts by notavailable (notavailable)

notavailable
notavailable
Posts: 41

Hi,

thank you for the fast fix!

Greetings

5 mths Can't edit entries with RDM 6.2.0.0 and MariaDB
notavailable
notavailable
Posts: 41

Hi,

we have the same Problem with mysql

5 mths Can't edit entries with RDM 6.2.0.0 and MariaDB
notavailable
notavailable
Posts: 41

Hi,

Thank you very much!

Greetings

6 mths QNAP NAS Autofill
notavailable
notavailable
Posts: 41

Hi,

thanks for looking into it!

Greetings

6 mths QNAP NAS Autofill
notavailable
notavailable
Posts: 41

Hi,

i sent the sourcecode.

Thank you!

Greetings

6 mths QNAP NAS Autofill
notavailable
notavailable
Posts: 41

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

6 mths QNAP NAS Autofill
notavailable
notavailable
Posts: 41

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

9 mths Can't assign Roles
notavailable
notavailable
Posts: 41

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

8 mths Can't assign Roles
notavailable
notavailable
Posts: 41

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

8 mths Can't assign Roles
notavailable
notavailable
Posts: 41

hi,

any updates?

Greetings

8 mths Can't assign Roles
notavailable
notavailable
Posts: 41

done!

thank you!

Greetings

9 mths Can't assign Roles
notavailable
notavailable
Posts: 41

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

9 mths Can't assign Roles
notavailable
notavailable
Posts: 41

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

9 mths Can't assign Roles
notavailable
notavailable
Posts: 41

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

9 mths User password problems
notavailable
notavailable
Posts: 41

Hi,

they are all checked!

Greetings

9 mths User password problems
notavailable
notavailable
Posts: 41

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

9 mths User password problems
notavailable
notavailable
Posts: 41

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

9 mths User password problems
notavailable
notavailable
Posts: 41

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

9 mths User password problems
notavailable
notavailable
Posts: 41

Hi,

works like a charm! Thank you!

Greetings

9 mths RDP copy problems
notavailable
notavailable
Posts: 41

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

9 mths RDP copy problems
notavailable
notavailable
Posts: 41

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

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

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

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

Full schema dump error:

Schema dump failed with error:
Value cannot be null.
Parameter name: value


Test Schema and Test Host are successful.

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

Out of sync with server Error is back:

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

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

Hi,

No worries - i can't send the schema to support, I think its because i'm not (can't) connect to the DB.

The Version from Mr. Fortin seems to be working! I will give it a proper testdrive today. (Do you still need the schema?)

Thank you both!

Greetings

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

Tried a manual database upgrade - after the upgrade we could connect again but suddenly after 5 minutes the error was back and RDM crashes right after starting again.

It was possible to fetch the error details:

MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered during command execution. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Fatal error encountered attempting to read the resultset. ---> MySql.Data.MySqlClient.MySqlException (0x80004005): Reading from the stream has failed. ---> System.IO.EndOfStreamException: Attempted to read past the end of the stream.
at MySql.Data.MySqlClient.MySqlStream.ReadFully (System.IO.Stream stream, System.Byte[] buffer, System.Int32 offset, System.Int32 count) [0x00015] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlStream.LoadPacket () [0x00076] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlStream.LoadPacket () [0x000a5] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlStream.ReadPacket () [0x00000] 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 () [0x000d2] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlDataReader.NextResult () [0x001f3] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x001ea] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x002ac] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader () [0x00000] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.ExecuteReader()
at MySql.Data.MySqlClient.Driver.ReportWarnings (MySql.Data.MySqlClient.MySqlConnection connection) [0x00019] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.Driver.CloseQuery (MySql.Data.MySqlClient.MySqlConnection connection, System.Int32 statementId) [0x0000e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at MySql.Data.MySqlClient.MySqlCommand.Close (MySql.Data.MySqlClient.MySqlDataReader reader) [0x00053] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at (wrapper remoting-invoke-with-check) MySql.Data.MySqlClient.MySqlCommand.Close(MySql.Data.MySqlClient.MySqlDataReader)
at MySql.Data.MySqlClient.MySqlDataReader.Close () [0x0008e] in <1add403c719d4eeeae437db5aa8f6c1a>:0
at System.Data.Common.DbDataReader.Dispose (System.Boolean disposing) [0x00003] in <bbe64cb6cb954b0c8bf8dbf03087621a>:0
at System.Data.Common.DbDataReader.Dispose () [0x00000] in <bbe64cb6cb954b0c8bf8dbf03087621a>:0
at A.c8bb832eaa4caed25b50caade71232a37.cc36fefaaceb5acfdf3c4a14f7813df4d () [0x00140] in <9cceae2923fd466e8cbe314df4acd410>:0

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

Hi,

i can't connect to our datasource after upgrading the database scheme. RDM crashes right after trying to connect to the datasource. Cleaning the cache and creating a new data source does not help.

RDM 6.0.0.0

Error:
Unable to Connect to your Data Source
Fatal error encountered during command execution.

i can't click any button (e.g. details) because RDM hangs for good.

please help smile

greetings

9 mths Database problems after upgrade
notavailable
notavailable
Posts: 41

Sent it!

Greetings

2 yrs Credentials problem
notavailable
notavailable
Posts: 41

Hi,

this works!

How can i fix the entries and why does it work on my colleagues mac?

Greetings

2 yrs Credentials problem
notavailable
notavailable
Posts: 41

Hi,

checked but no override in User and Local Settings.

Greetings

2 yrs Credentials problem