Create Random Password from Template without RDM installed

Hello,

With the Devolutions.PowerShell module, there is no need to have RDM installed.

Usually, the module should create a folder under %localappdata%\Devolutions\RemoteDesktopManager. Do you see that folder with files that have been created on that machine?

Please run the Get-RDMInstance cmdlet to get the configuration folder where the files should be created.

About the DS cmdlets, I don't see any that could use an existing password template to generate a password.

I will try to reproduce your issue.

Best regards,

%localappdata%\Devolutions\RemoteDesktopManager is existing but is empty

Get-RDMInstance throws an error:

PS C:\Users\Administrator> Get-RDMInstance
DllNotFoundException - Unable to load DLL 'sqlite3secure' or one of its dependencies: The specified module could not be found. (0x8007007E)

   at System.Data.SQLite.UnsafeNativeMethods.sqlite3_config_none_other(SQLiteConfigOpsEnum op)
   at System.Data.SQLite.UnsafeNativeMethods.Sqlite3_Config_None(SQLiteConfigOpsEnum op)
   at System.Data.SQLite.SQLite3.StaticIsInitialized()
   at System.Data.SQLite.SQLiteLog.Initialize()
   at System.Data.SQLite.SQLiteConnection..ctor(String connectionString, Boolean parseViaFramework)
   at System.Data.SQLite.SQLiteConnection..ctor(String connectionString)
   at Devolutions.RemoteDesktopManager.Business.DataSources.SQLiteConnectionDataSource.CreateDbConnection(String connectionString)
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.CreateDbConnection(Boolean master, Nullable`1 connectTimeout)
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseConnectionDataSource.CreateDbConnection(Nullable`1 connectTimeout)
   at Devolutions.RemoteDesktopManager.Business.DataSources.SqLiteUpdater.FetchDatabaseVersion()
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseUpdater.RefreshVersionNumber()
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseUpdater.get_DatabaseVersion()
   at Devolutions.RemoteDesktopManager.Business.DataSources.DatabaseUpdater.get_IsUpgradeRequired()
   at Devolutions.RemoteDesktopManager.Managers.DataSourceManager.IsDatabaseUpgradeRequired(BaseConnectionDataSource dataSource)
   at Devolutions.RemoteDesktopManager.Managers.DataSourceManager.UpgradeDatabase(BaseConnectionDataSource dataSource)
   at Devolutions.RemoteDesktopManager.Services.DataSourceService.UpgradeDatabase(BaseConnectionDataSource dataSource)
   at Devolutions.RemoteDesktopManager.Managers.DataSourceManager.UpgradeDatabase(BaseConnectionDataSource dataSource)
   at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnectionsFromDataSource(ConnectionEngine engine, Boolean hasChanged)
   at Devolutions.RemoteDesktopManager.Managers.ConnectionManager.LoadConnections(BaseConnectionDataSource dataSource)

ApplicationVersion OptionFilename
------------------ --------------
2023.3.1.0         C:\Users\Administrator\AppData\Roaming\Devolutions\RemoteDesktopManager\RemoteDesktopManager.cfg

I installed the module manually, as I do not have internet on that server, if that may caused the issue.

I just installed the module manually on a fresh server.

Also an error when running Get-RDMInstance:

PS C:\Users\Administrator> Get-RDMInstance
WARNING: Unable to create database.

Unable to load DLL 'sqlite3secure' or one of its dependencies: The specified module could not be found. (0x8007007E)

ApplicationVersion OptionFilename
------------------ --------------
2023.3.1.0         C:\Users\Administrator\AppData\Roaming\Devolutions\RemoteDesktopManager\RemoteDesktopManager.cfg

I will try the newer version of the module and also try installing it by Install-Module -Name Devolutions.PowerShell Command.

Automatic installation via Install-Module command worked, no error on Get-RDMInstance Command.

When I initially ran Get-RDMInstance, I saw something was loading, I assume that something has been downloaded/installed. Maybe I need to find a way to offline install this dependency of DLL 'sqlite3secure'

Hello,

Thank you for your feedback.

Do you still get an error when creating the DVLS data source using this automatically installed module?

Best regards,

Yes same error: "[Error] The operation was canceled." - so the issue isn't (just) caused by this sqlite3secure dependency.

However you mentioned with the Devolutions.PowerShell module, there is no need to have RDM installed.
But I just installed RDM and after that creating DVLS data source did actually work and I was able to use my password template.

Hello,

Thank you for your feedback.

For the error "[Error] The operation was canceled.", you can ignore it. The cmdlet tries to update the UI but there is no UI! So you can still use the data source even with that error.

For the missing dll file, you can refer to this thread. Then, you will only need to get the Microsoft Visual c++ 2015-2022 (version 14).

Let us know if that helps.

Best regards,