Are RDM SQLite passwords not compatible between Windows and OS X?
Are RDM SQLite passwords not compatible between Windows and OS X?
Hello!
I am in the process of evaluating RDM Enterprise to replace my use of Terminals. One of the limitations of the latter was Windows-only, so I think it's great that RDM supports both Windows and OS X.
I have run into a problem, though, in that when I protect a SQLite data source file with a password, that password does not work to open the file on the other platform. In other words, if I create the data source on Windows and secure it with a password, I am able to open that data source on different Windows computers with that password, but NOT from my Mac. Likewise, if I create the data source from the Mac and secure it with a password, the Windows computers are unable to open it.
Unsecured SQLite data sources work fine from both platforms...I am able to use my sessions and credentials on both.
Is this a known limitation, or should what I'm describing be working?
Many thanks!
Jim
edited by jharle on 8/15/2015
All Comments (5)
Hello Jim,
Yes it's a known limitation of SQlite. The problem is that by default SQLite does not implement an encryption by default. It uses an OS specific encryption and for Mac we had to do the encryption ourself.
However you have two solutions.
1. Use an XML encrypted with a masterkey on a share drive
2. Use Devolutions Online Drive which is a kind of RDM specif dropbox. You will also be able to encrypt the content with your own masterkey. https://blog.devolutions.net/2015/05/dropbox-vs-devolutions-online-drive.html This will also work on Android (already in beta) and IOS (coming soon)
Regards
David Hervieux
David - thanks, the DOD is a perfectly acceptable solution, and I have that implemented now. Thanks for the quick reply!
-Jim
So I've been using this DOD repository for a while (paid subscriber now), and notice one oddity - I have the RDM software running all day long (on Windows), and after a while, the connection to the DOD repository seems to break. When I attempt to create a new connection, or modify an existing one, the action fails, and the "session list" in the left pane changes to "not connected." I then have to close and re-launch RDM, then it's happy again for a while.
Have you heard of this issue with anyone else?
Could you try to press Ctrl+F5 or hold the Ctrl button while pressing the Refresh button to see if it fixes the problem?
David Hervieux
So I couldn't get Ctrl+F5 nor Ctrl+Refresh to fix it; but, I can simply click the "Data Sources" button, and then click OK with my preferred data source already selected, and the list comes back. So that is much faster than exiting all the way out of the app!