Jump to content

Fabian Näf

  • Content count

  • Joined

  • Last visited

  • Days Won


Fabian Näf last won the day on February 14

Fabian Näf had the most liked content!

About Fabian Näf

  • Rank
    Advanced Member
  1. Fabian Näf

    Inplace Upgrade not working

    Dear all, I'm not sure if the added code was already there, but I just updated from the second newest version to release 8325. During that upgrade I had the issue again and I had to manually download the update. Best regards, Fabian
  2. Fabian Näf

    Best practice regarding securement of the Web.conf file

    Hi Kevin Passwordstate has a chapter in their installation instructions, about how to encrypt the sensitive data in the web.config. You find these information in this file on page 19 and 20. I would say, you can also use the function to add documents to a folder or passwordlist to securely store files from other applications (also by using the API). Best regards, Fabian
  3. Fabian Näf

    Restore from backup

    Hi SadSaddo Each backup process creates two files, which are located in your configured backup directory. For instance: Passwordstate20180405000026.bak Passwordstate20180405000026.zip The zip file contains a backup of your Passwordstate web application folder, which is by default under C:\inetpub\Passwordstate. The bak file is a SQL backup of your SQL database. To restore the Passwordstate web application, overwrite the content of your Passwordstate web application folder with the content of the zip file. To restore the SQL database use SQL Management studio or run the following commands in sqlcmd.exe (should be even easier). 1> ALTER DATABASE passwordstate SET SINGLE_USER WITH ROLLBACK IMMEDIATE 2> GO 1> RESTORE DATABASE passwordstate FROM DISK='C:\Folder\Example\Passwordstate20180119080851.bak' WITH REPLACE 2> go 1> ALTER DATABASE passwordstate SET MULTI_USER 2> go Best regards, Fabian Edit: Probably we could raise a feature request for an automated restore process function :-)
  4. Fabian Näf

    Help with invoke-restmethod and '\' char

    Hi Johhny You also could go for the following approach. Create a PowerShell object and convert it to JSON. Then you don't have to care about special character and escaping. $Body = @{ PasswordList = $Name Description = $Description ApplyPermissionsForUserID = $global:UserToPermit CopySettingsFromTemplateID = $global:PasswordstateTemplateID LinkToTemplate = "False" Permission = "A" PrivatePasswordList = "false" NestUnderFolderID = $ParentFolderID APIKey = $global:PasswordStateSystemWideAPIKey } $jsonBody = $Body | ConvertTo-Json Best regards, Fabian
  5. Fabian Näf

    Privileged Account Management

    Hi Kevin Clickstudios has a lot of good video tutorials. Probably the following video could give you a hint, how to work with expiring passwords. Best regards, Fabian
  6. Fabian Näf

    Importing from KeePass into Passwordstate

    Hi techcat You can try to change (in the function AddPasswordstatePasswordToPasswordlist) on line 116 "Mandatory=$True" to "Mandatory=$False". Probably this resolves the issue. Currently I don't have time to test it, I'm just guessing. So don't blame me if I'm wrong :-) Best regards, Fabian
  7. Fabian Näf

    Inplace Upgrade not working

    Dear all, Just to let you know: During the two last upgrades I again experienced the same issue as before. Best regards, Fabian
  8. Hi Staurt Clickstudios just uploaded a very good video manual about how to use the new remote session launcher. In this video they also explained how to replay these recordings. Best regards, Fabian
  9. Fabian Näf

    Importing from KeePass into Passwordstate

    Hi All I just made a new versions of my KeePass and Passwordsafe-Import scripts. Difference to the old version: You need to enter your windows credential Uses WinAPI (instead of using the system wide API key) Creates private passwordlists for the specified user In general: If you like to import shared KeePass/Passwordsafe files: Use the old version (system wide API key used) If you like to import personal KeePass/Passwordsafe files: Use the new version (WinAPI used with personal permission) Terms: These scripts are free to use, it's not allowed to resell my scripts or making business with it! There's absolutely no warranty about what the scripts are doing, you use them on your own risk. For more infomation about how to use it, take a look at my first post about the first version in this thread. Best regards, Fabian PasswordsafeImporterWinAPI.ps1 KeePassImporterWinAPI.ps1
  10. Fabian Näf

    Inplace Upgrade not working

    Hi I just wanted to report, that I just tried to do an inplace upgrade again for the newest version. And all of a sudden, it worked like a charm. I've no idea why it worked now, but it worked :-) I wish a happy new year! Best regards, Fabian
  11. Fabian Näf

    Bulk Import from Password Safe

    Hi Sarge Probably you can use my script: Best regards, Fabian
  12. Fabian Näf

    Inplace Upgrade not working

    Hi No I didn't harden my server at all. This error only occurs on my test server. So it's absolutely not important... no worrys ;-) In the eventlog I found the following error, every time when I try to run the update: Log Name: System Source: Schannel Date: 30.11.2017 16:14:03 Event ID: 36887 Task Category: None Level: Error Keywords: User: SYSTEM Computer: ************* Description: A fatal alert was received from the remote endpoint. The TLS protocol defined fatal alert code is 70. Regarding to this site, error 70 means "protocol_version". I already had problems to download this file by using my domain admin account using IE, I had to enable TLS1.2 in the IE settings. Can you tell me, which user is used to download the update file? Is this the configured In-Place-Upgrade user or the AppPool-User (NetworkService)? I tried to use differend users for In-Place-Upgrade, but this makes no difference at all. Best regards, Fabian
  13. Fabian Näf

    Inplace Upgrade not working

    Hi The service account has full control on the Passwordstate folder. I just repropagated all permissions down to all files and folders. My server has direct connection to the internet, not firewall or proxy between. I just tested to use my domain admin instead of the service account, but unfortunately I got the same error. Thanks for extending the upload-size! Just a sidenote about the upgrade process: If the upgrade fails, the Passwordstate-service stays in stopped status. Best regards, Fabian
  14. Fabian Näf

    Importing from KeePass into Passwordstate

    Hi Yoshi Have you enabled the "Anonymous API" and did you use the key for this API? (take a look at the screenshot above from Clickstudios). Best regards, Fabian
  15. Fabian Näf

    Inplace Upgrade not working

    Hi Together Everytime, when I run an inplace upgrade, I get the follwing error: HTTP Download Error It appears there is an issue in downloading the file http://www.clickstudios.com.au/downloads/passwordstate_upgrade.zip from Click Studios' web site. This could be caused by numerous things, including internal or external network issues, internal proxy server issues, or timeouts while downloading the file. The log file /upgrades/UpgradeLog.txt may be able to provide some more detail. To progress with the upgrade, you can manually download the file above and place it in the /upgrades folder of your Passwordstate install, then click on the Restart Upgrade button below. When I download this file manually and place it in the upgrades-Folder it works well (I did this every time so far, but it would be glad to resolve this issue). The UpgradeLog.txt contains the following content: 22.11.2017 18:57:47 - Passwordstate upgrade started. 22.11.2017 18:58:25 - Stopping of the Passwordstate Windows Service started. 22.11.2017 18:58:25 - Stopping of the Passwordstate Windows Service completed. 22.11.2017 18:58:25 - Compressing and backing up of web files started. 22.11.2017 18:59:28 - Compressing and backing up of web files completed. 22.11.2017 18:59:28 - Backing up of database started. 22.11.2017 18:59:29 - Backing up of database completed. 22.11.2017 18:59:29 - Removing old backups started. 22.11.2017 18:59:29 - Removing old backups completed. 22.11.2017 18:59:29 - Downloading of file passwordstate_upgrade.zip started. 22.11.2017 18:59:31 - The following error occurred during preparing for an upgrade - The request was aborted: Could not create SSL/TLS secure channel. - Method = DownloadButton_Click For In-Place Upgrades I use a dedicated service account with full rights on the Passwordstate-Service (start/stop permission was not enough). This service account has write access to the backup path and passwordstate-folder as well. This account doesn't have any more rights than this (no logon locally allowed). I already tried to start Internet Explorer with the service account and I was able to download the file by using the following urls: https://www.clickstudios.com.au/getupgradefile.aspx https://www.clickstudios.com.au/downloads/passwordstate_upgrade.zip Best regards Fabian By the way: Might it be possible to extend the attachment storage in this forum for my user, because I'm not able to update any more attachment?