Forum

Posts by Ferd (Ferd)

Ferd
Ferd
Posts: 131

I just updated to 14.0.9.0 and it still doesn't work:


Devolutions.BitwardenManagement.ClientException: POST request to 'https://vault.bitwarden.com/identity/connect/token' failed with HTTP status code BadRequest (400) ---> System.Net.WebException: The remote server returned an error: (400) Bad Request.
at System.Net.WebClient.UploadDataInternal(Uri address, String method, Byte[] data, WebRequest& request)
at System.Net.WebClient.UploadString(Uri address, String method, String data)
at A.c47dc43029cb6c2e740ea95895c2f57ca.Post(String url, String content, Dictionary`2 headers)
at A.c35d393723cfe31f3f808596f6f7ecae8.ca51ed2a14eb15e276dd7b06431fc9b88[cb75a0a5d15a1ad8b8a8a5e57cca214a3](String c2ad4aaec0ff471d6c859511e38ba8050, String c2819ee8f388b5c32ac62d939dae428c0, Dictionary`2 c223084616c882f0595ad4fe678f119d2, Func`3 c4da66d4e934a12695b4a89ff6089eaa6, Func`2 c535082350bb62fbfdf7fe7397df45fdb)
--- End of inner exception stack trace ---
at A.c0c9b4376a95c83cda5c8aaa674f0a770.cd02f912d8fa446ef9da69b701293d6d8(String c4c707ece3170514f8504b161d5b38c17, Byte[] ccf269a0f4d2eb455fcab6fb74eb13c53, c35d393723cfe31f3f808596f6f7ecae8 cdbbf219ea292a848b5c568e2833a47f0)
at A.c0c9b4376a95c83cda5c8aaa674f0a770.c77435cee3d84f42b6bcb99578b7887e2(String c4c707ece3170514f8504b161d5b38c17, String ceb81d1ee93f91e0bc57f34876c263863, IHttpClient c7db9ccbcc9e363b4afa5482d2e2b187a)
at Devolutions.BitwardenManagement.Vault.Open(String username, String password)
at Devolutions.RemoteDesktopManager.Managers.BitwardenManager.Initialize(String username, String password)

2 yrs Bitwarden - unable to connect
Ferd
Ferd
Posts: 131

Great news, thank-you for prompt response - I still have LastPass active so it's not a problem for the moment.

2 yrs Bitwarden - unable to connect
Ferd
Ferd
Posts: 131

Sorry, I've been kind of busy of late but it does seem that things might have resolved themselves since installing v14.0.7.0 - LastPass hasn't even been asking me for authentication which is a bit odd. So I'm not sure if it's now using the saved credentials in Windows, or somewhere else as I deleted them all and it still connects me.

What's the best debug log level and setting for me to capture more of what is going on? It's not informing of updates either, had to discover 14.0.7.0 and 14.0.8.0 by looking at your site, and also I have another issue as I'm moving away from LastPass to Bitwarden and it won't let me connect (I submitted a separate thread for that one).

Cheers,
Taomyn

2 yrs 14.0.6.0 RDM uses proxy for LastPass when main option is set to none
Ferd
Ferd
Posts: 131

I'm moving over from LastPass to Bitwarden but I cannot get RDM v14.0.8.0 to connect to my account:


[23/11/2018 14:47:28 - 14.0.8.0 - 64-bit] Error: Devolutions.BitwardenManagement.ClientException: Invalid JSON in response from 'https://vault.bitwarden.com/api/accounts/prelogin' ---> Newtonsoft.Json.JsonSerializationException: Required property 'c22ac3933b44a3a846b9e8f0e30789aa4' not found in JSON. Path '', line 1, position 32.
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.EndProcessProperty(Object newObject, JsonReader reader, JsonObjectContract contract, Int32 initialDepth, JsonProperty property, PropertyPresence presence, Boolean setDefaultValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.PopulateObject(Object newObject, JsonReader reader, JsonObjectContract contract, JsonProperty member, String id)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.CreateObject(JsonReader reader, Type objectType, JsonContract contract, JsonProperty member, JsonContainerContract containerContract, JsonProperty containerMember, Object existingValue)
at Newtonsoft.Json.Serialization.JsonSerializerInternalReader.Deserialize(JsonReader reader, Type objectType, Boolean checkAdditionalContent)
at Newtonsoft.Json.JsonSerializer.DeserializeInternal(JsonReader reader, Type objectType)
at Newtonsoft.Json.JsonConvert.DeserializeObject(String value, Type type, JsonSerializerSettings settings)
at Newtonsoft.Json.JsonConvert.DeserializeObject[T](String value, JsonSerializerSettings settings)
at A.c35d393723cfe31f3f808596f6f7ecae8.ca51ed2a14eb15e276dd7b06431fc9b88[cb75a0a5d15a1ad8b8a8a5e57cca214a3](String c2ad4aaec0ff471d6c859511e38ba8050, String c2819ee8f388b5c32ac62d939dae428c0, Dictionary`2 c223084616c882f0595ad4fe678f119d2, Func`3 c4da66d4e934a12695b4a89ff6089eaa6, Func`2 c535082350bb62fbfdf7fe7397df45fdb)
--- End of inner exception stack trace ---
at A.c35d393723cfe31f3f808596f6f7ecae8.ca51ed2a14eb15e276dd7b06431fc9b88[cb75a0a5d15a1ad8b8a8a5e57cca214a3](String c2ad4aaec0ff471d6c859511e38ba8050, String c2819ee8f388b5c32ac62d939dae428c0, Dictionary`2 c223084616c882f0595ad4fe678f119d2, Func`3 c4da66d4e934a12695b4a89ff6089eaa6, Func`2 c535082350bb62fbfdf7fe7397df45fdb)
at A.c35d393723cfe31f3f808596f6f7ecae8.ca51ed2a14eb15e276dd7b06431fc9b88[cb75a0a5d15a1ad8b8a8a5e57cca214a3](String c2ad4aaec0ff471d6c859511e38ba8050, String c2819ee8f388b5c32ac62d939dae428c0, Dictionary`2 c223084616c882f0595ad4fe678f119d2, Func`3 c4da66d4e934a12695b4a89ff6089eaa6)
at A.c35d393723cfe31f3f808596f6f7ecae8.c9e75369d8d0083fc5f56896a897e2a62[cb75a0a5d15a1ad8b8a8a5e57cca214a3](String c2819ee8f388b5c32ac62d939dae428c0, Dictionary`2 cd859b08da59abe612143bd1559182965, String cb8465c85abec9e74db08b6fcb02138b8, Func`2 cd3ac9772090df77043f920c30744b665, Func`5 c4da66d4e934a12695b4a89ff6089eaa6)
at A.c35d393723cfe31f3f808596f6f7ecae8.c9e75369d8d0083fc5f56896a897e2a62[cb75a0a5d15a1ad8b8a8a5e57cca214a3](String c2819ee8f388b5c32ac62d939dae428c0, Dictionary`2 cd859b08da59abe612143bd1559182965)
at A.c0c9b4376a95c83cda5c8aaa674f0a770.cfb84b3ad2de99583727eb2671a0eef7f(String c4c707ece3170514f8504b161d5b38c17, c35d393723cfe31f3f808596f6f7ecae8 cdbbf219ea292a848b5c568e2833a47f0)
at A.c0c9b4376a95c83cda5c8aaa674f0a770.c77435cee3d84f42b6bcb99578b7887e2(String c4c707ece3170514f8504b161d5b38c17, String ceb81d1ee93f91e0bc57f34876c263863, IHttpClient c7db9ccbcc9e363b4afa5482d2e2b187a)
at Devolutions.BitwardenManagement.Vault.Open(String username, String password)
at Devolutions.RemoteDesktopManager.Managers.BitwardenManager.Initialize(String username, String password)


In case it helps, my Bitwarden email address is in "plus address format" e.g. myaddress+suffix@mydomain.com (I know this sometimes causes problems, but it's valid) and also the account is protected with Duo so it requires 2FA with my phone.

2 yrs Bitwarden - unable to connect
Ferd
Ferd
Posts: 131

It worked with whatever the previous version was to 14.0.5.0 as I update almost every time you release one.

2 yrs 14.0.6.0 RDM uses proxy for LastPass when main option is set to none
Ferd
Ferd
Posts: 131

I don't want to use the proxy, and when I did in the past I had the same problem and do now when I try it again (and no I am not going to use the manual option either).

There's a special firewall bypass I use on my machine so I don't have to use the proxy, yet for some reason RDM still wants to use it even though it's set to "No Proxy". Before 14.0.5.0 it worked fine and didn't use the proxy.

2 yrs 14.0.6.0 RDM uses proxy for LastPass when main option is set to none
Ferd
Ferd
Posts: 131

It's configured on both the workstation (proxy is set) and in RDM (no proxy set), but RDM does not need to use it in fact it gets blocked to LastPass and a few other things if it tries to use the proxy.

2 yrs 14.0.6.0 RDM uses proxy for LastPass when main option is set to none
Ferd
Ferd
Posts: 131

It was still the same, also when choosing the "Change" option instead of repair only the setting for association is shown.

2 yrs 14.0.6.0 RDM upgrade lost all my start menu icons
Ferd
Ferd
Posts: 131

Upgrading from 14.0.5.0 to 14.0.6.0 this morning I lost all my start menu icons - Windows 10 Enterprise, 1803.

If I have time today I will try a repair install.

2 yrs 14.0.6.0 RDM upgrade lost all my start menu icons
Ferd
Ferd
Posts: 131

Since the last beta and now this one, RDM is trying to use my system proxy even though the main application setting is set to "None" - this is making the use of LastPass impossible. See attached screenshot of the log view.

It doesn't seem to effect update downloads as they connect and download just fine.

2 yrs 14.0.6.0 RDM uses proxy for LastPass when main option is set to none
Ferd
Ferd
Posts: 131

Thanks, the files provided have fixed the problem

2 yrs 14.0.4.0 Data Source error since updating
Ferd
Ferd
Posts: 131

Just updated, now get this error trying to connect to any machine when using my MariaDB database source:


MySql.Data.MySqlClient.MySqlException (0x80004005): Invalid attempt to Read when reader is closed.
at MySql.Data.MySqlClient.MySqlDataReader.Throw(Exception ex)
at MySql.Data.MySqlClient.MySqlDataReader.Read()
at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseStateSubDataSource.GetCheckOut(String connectionID, Boolean canRetry)

When I run the test host/schema there are no issues reported.

2 yrs 14.0.4.0 Data Source error since updating
Ferd
Ferd
Posts: 131

I almost forgot to report that the latest beta allowed me to run RDM again, thanks again for that.

BTW, I still can't export the schema using the "Send schema via email" button, it always crashes with the same error previously reported.

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Seems you've broken my RDM again with the latest beta, and "Send schema" is far from fixed.

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

That'll teach me to be pro-active wink I've renamed it back, though I didn't see any difference at the time.

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Yes, as we suspected the case is now sensitive, so I ran your rename commands and now all is well. However a couple of things cropped up.

RENAME TABLE todousers TO TodoUsers;
/* SQL Error (1146): Table 'rdm.todousers' doesn't exist */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 32 of 41 queries: 2.687 sec. */

RENAME TABLE userinfo TO UserInfo;
/* SQL Error (1146): Table 'rdm.userinfo' doesn't exist */
/* Affected rows: 0 Found rows: 0 Warnings: 0 Duration for 2 of 8 queries: 0.234 sec. */

And I had to rename another table "versioning" to "Versioning".

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Hey there, thanks for all the fixes. Now I have another issue which is kind of related. I want to move the database to my MariaDB server running on Fedora. I've moved several other DBs without issue (phpBB and ownCloud for example), but with RDM it won't load and it seems to be related to the "lower case" difference between Windows and Linux.

When I move the database (export then import) and point RDM to it, it complains that tables are missing, and they are clearly there just not in the same case e.g. it was complaining it could not find "ConnectionHistory" which is called "connectionhistory" in my database.

How can I sort this?

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Hi again, finally success, though not everything is perfect, screen shots as follows:

  • The release notes were not for the version I downloaded - remember this is where we see what is going to change, not some link I have to search for
  • Ready to upgrade
  • Yay, it worked - but took about 10min or felt like it did
  • Tried to run the diagnostics
  • Went to check the data source
  • Still can't send you the schema


Also attached the logs and the current upgraded schema

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Thanks, I will test it tonight and get back to you

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Right, so I went back to my previous backup before this latest update and re-ran RDM after first enabling debugging as requested. Attached are screen shots of everything that happened, and the two log files.

Hope they help.

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Sorry, but both work - I'd paste the results but they are quite long, re-running from Heidi-SQL GUI, I can get you:

select * from Connections;
select * from connections;
/* Affected rows: 0 Found rows: 30 Warnings: 0 Duration for 2 queries: 0.000 sec. */

I've never know these to ever be case-sensitive in MySQL (I've coded for PHP in the past), so not sure why it would be a problem.

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

I'm unable to connect to the PC running RDM, but the database I can and you're correct, they are all lowercase:

[rdm]> SELECT TABLE_NAME FROM information_schema.tables WHERE table_schema = database() order by 1;
+---------------------------+
| TABLE_NAME |
+---------------------------+
| appsettings |
| attachment |
| backupjob |
| backupjobuser |
| backuplog |
| connectionhandbook |
| connectionhandbookhistory |
| connectionhistory |
| connectionlog |
| connections |
| connectionstate |
| customimage |
| databaseinfo |
| datasourcesettinghistory |
| groupchanged |
| groupinfo |
| groupinfohistory |
| inventory |
| loginattempt |
| loginhistory |
| logmessage |
| monitoring |
| report |
| repository |
| repositoryhistory |
| secureattachment |
| securemessage |
| sessionrecording |
| subscription |
| subscriptionevent |
| todo |
| todohistory |
| todousers |
| useraccount |
| usergroupinfo |
| userinfo |
| userinfohistory |
| userprofile |
| userroamingsettings |
| userrole |
| usersecurity |
| versioning |
+---------------------------+
42 rows in set (0.061 sec)

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

My schema and version haven't changed since the first time, I've been waiting for the fix and skipped all updates until now, plus the screen shots includes once again that the built-in tool won't export my schema.

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Stefane Lavergne wrote:

Yes, v13.9.6 does in fact contain the fix. You are correct it is missing from the release notes.

Best regards,


I'm afraid you have some more fixing to do

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Does 13.9.6 contain fixed support for MySQL as the release notes make no mention of it?

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Thanks, though unless the beta is weeks away I'm happy to wait for the fixed beta so I can test it for you - just be sure to flag it in the change-log that appears when the application detects a newer version (unlike not mentioning the MySQL issue in the first place, at least I never saw it until I visited the forums).

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

124

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

PM'd the schema

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

Stefane Lavergne wrote:

@Taomyn,

Could you please send us your MySQL for analysis. File > Data Sources > Upgrade > Email Schema to Support.

Best regards,


I tried but it won't allow me to, see screen shot

Also, does this file include my credentials?

2 yrs Beta 13.9.0.0 - Unable to upgrade MySQL database
Ferd
Ferd
Posts: 131

The shortcut now seems to be the 64bit one which is an improvement, but it's still being pinned to my taskbar each and every update which continues to annoys me.

2 yrs Installer/updater annoyances