Jump to content

All Activity

This stream auto-updates     

  1. Yesterday
  2. Hi Brian, Those two buttons below should take you to each of the relevant URLs - are they taking you to a different URL?
  3. A small recap then: I can reproduce the error with the following server setup. All system are Windows Server 2016 Server Core WebServer Language: English - United States Time and Currency Format: Norwegian - Bokmål Keyboard: Norwegian - Bokmål (I don't think the keyboard layout matters) SQL Server Language: English - United States Time and Currency Format: Norwegian - Bokmål Keyboard: Norwegian - Bokmål SQL Server default collation: Danish_Norwegian_CI_AS The error is gone on the folowing setup WebServer Language: English - United States Time and Currency Format: English - United States <--- Difference Keyboard: Norwegian - Bokmål SQL Server Language: English - United States Time and Currency Format: Norwegian - Bokmål Keyboard: Norwegian - Bokmål SQL Server default collation: Danish_Norwegian_CI_AS Conclusion As it stands, it seems the error is because of the time and date settings used when installing Windows Server. Please don't hesitate to contact me if i can help in anyway. I hope you are able to reproduce this error on your end!
  4. We are able to get to the documentation simply by adding winapi to the end of the url replacing api instead of using the link provided on the page. https://server:9119/api/ https://server:9119/winapi/
  5. Thanks Jack - we do appreciate all your help. We've going to try and setup our own server in a different language, as we need to reproduce this issue ourselves - we don't want to keep asking for your help in testing this. Hopefully we should have some good news early next week some time. Regards Click Studios
  6. Hi Ted, Sorry you've run into this issue, and we believe this bug only affects customers who have upgraded from version 7. We will have a fix in the next release for this, but for now can you please do the following: Edit the Discovery Job, and re-select the appropriate Host Type and Operating Systems options Using SQL Server Management Studio, execute the following SQL script: DECLARE @ScriptID int SET @ScriptID = (SELECT ScriptID FROM [ValidationScripts] WHERE ValidationScripts.ScriptName = 'Validate Password for Windows Account' AND ValidationScripts.Inbuilt = 1) SELECT @ScriptID UPDATE [DiscoveryJobs] SET ValidationScriptID = @ScriptID WHERE JobType = 'Windows Local Admin Accounts' This should resolve the issue for you. Regards Click Studios
  7. Hi Brian, Is your URL being detected in the Local Intranet Zone in IE - can you share a screenshot? And can you tell us which browser you are using? If it is, then the following forum post provides a few more suggestions which will fix this - https://www.clickstudios.com.au/community/index.php?/topic/1305-passwordstate-prompts-for-authentication/ Can you let us know if any of the following helps? Regards Click Studios
  8. Last week
  9. I am still getting prompted for username and password and it will not be accepted. The "Windows Integrated API Documentation" is the only page with this behavior thus far. You do not have permission to view this directory or page.
  10. After upgrading to version 8 we are getting the following error with our Windows Local Admin Account discovery jobs: Error: An error has occurred in the Passwordstate Windows Service executing the method 'ProcessAccountsDiscoveryJob'. Error = Conversion from string "" to type 'Integer' is not valid.&stacktrace= at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(String Value) at Microsoft.VisualBasic.CompilerServices.Conversions.ToInteger(Object Value) at PasswordstateService.PasswordstateService.ProcessAccountsDiscoveryJob(DataTable DataTable) These jobs where running without an error before the upgrade.
  11. Hi, I updated the files are per your instructions, but i still get the same error at the admin creation screen. This is what i did Created a new server Installed passwordstate Setup SSL Checked that the site worked Stopped the PWS service Did a manual overwrite of the file with the zip you gave me Started the PWS service Went through the setup Failed with the exact same error on the admin creation screen and was logged in the PWS debug log in the database I did a reboot of the server and tried again Same error.
  12. PS in HA in Azure (multi region)

    Hi Matt, Thanks for your post, and I'll try and provide some guidance - we do not have much in the way of experience with Azure, but hopefully between your knowledge of Azure, and ours of Passwordstate, we can get your questions answered. Passwordstate can connect to any version of SQL Server (2012 an above), and it really doesn't care what database replication technology is used. With On-Premise solutions, you can use Transnational Replication, High Availability Groups, Clustering etc. Within the web.config file, you will see the "database connection string" - it is this configuration which governs which SQL Server it can connect to. We've done limited testing with Azure SQL, and it seems to work fine - we can have Passwordstate pointed to one Azure SQL DB, and it seems to failover without any issues. So I do not believe this would be an issue for you. When you install the second node of Passwordstate, we recommend setting the PassiveNode key in the web.config file to "active", and then both Nodes of Passwordstate can have write access to the DB's - changing this key simply means the second Node will not duplicate processing with the Passwordstate Windows Service i.e. sending emails, synchronising AD Security Groups, performing Password Resets, etc. I hope this helps, and please let me know if you have any further questions about this. Regards Click Studios
  13. Thanks Jack, and this confirms what we believe the issue is. I've just sent you an email with the new test build, and hopefully this will resolve it. Thanks again for all your help. Regards Click Studios
  14. When trying to access the new Windows API Documentation from the Help menu in Passwordstate 8, it is possible you get a Windows based prompt asking for a username and password. To fix this, please ensure your Passwordstate URL is located in the Local Intranet Zone. To see if it is located in the Local Intranet zone, open Internet Explorer, browse to your website and open Internet Options -> Security. If it is detected it is in the Local Intranet zone, it will appear blue as per below screenshot: If you need to you can add the site in the Internet Options above, or add the site to group policy to ensure all machines detect it by default.
  15. Yes, that server is using the same culture and language settings as the new server. PS F:\Backup\passwordstate_upgrade\passwordstate> get-host Name : ConsoleHost Version : 5.1.14393.1532 InstanceId : 5f7a71e2-0fbf-4ea2-9cb7-90f811b499c3 UI : System.Management.Automation.Internal.Host.InternalHostUserInterface CurrentCulture : nb-NO CurrentUICulture : en-US PrivateData : Microsoft.PowerShell.ConsoleHost+ConsoleColorProxy DebuggerEnabled : True IsRunspacePushed : False Runspace : System.Management.Automation.Runspaces.LocalRunspace I hadn't updated to the latest bugfix version, so the preferences pane wasn't available (server error). So before I updated I tested changing the user password via the Administration > Users screen. It worked fine. Then I updated to the latest bugfix version 8065. I logged in after the update I then clicked on my username and the preferences panel come up (Yay!) I then went to Authentication Options I changed my password Clicked save Got en ERROR - The same error as on the new server 1768 2017-08-17 14:39:18.000 General Error Error Code = The statement has been terminated. The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value., StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.User.ResetUserPassword(String Password, String FormsPassHistory, Int32 PasswordStrengthIndex) Error
  16. Hi We are going to pull the trigger on PS and plan on running it as IaaS in Azure. We are purchasing the HA option as we plan to have an active/active setup. Some questions. Region 1: Web server and SQL server. Region 2: Web server and SQL server Plan to use availability groups and front them through an Azure load balancer. Preference is to use synchronous replication for data integrity. Questions Is this possible? How do I connect the two SQL instances, is it just using network security groups and specifying the appropriate ports? Can I use synchronous replication with SQL in Azure IaaS. Should I consider Azure SQL, does PS even support it? I'd rather not use an active/passive setup as PS documentation states that uses SQL transactional replication, and I have better experience with AoG and would prefer to use it. Thanks in advance Also posted in r/sysadmin
  17. Hi Jack, Can you do me one more favour? On your version 7 install which was upgraded to V8, does this have the same time/date settings as the failed server? If so, can you go to the Preferences screen, and then 'Authentication Options' tab, and try changing the password for an account - I'd like to know if this fails at all? Thanks very much. Regards Click Studios
  18. No rush. Glad to help. Feel free to put debug info or anything else that might be useful. The database is empty, it's a fresh install.
  19. Hi Jack, Thanks very much - we really appreciate it. This won't be today though, as we need to make the coding changes, recompile, and upload for you. I'll send you a message as soon as we have it ready. Thanks again. Regards Click Studios
  20. No problem. Just let me know what you need done and I'll do it. I'll have to do it later on tonight (my time) as I've got some family business to attend to. I'll send you my email in a private message and you can send me what needs to be done there.
  21. HI Jack, If you're willing, we could provide you a custom upgrade zip file to test i.e. overwrite all your existing files after your initially install Passwordstate. There are two fields I can make a change on here, and then hopefully we can determine what the cause is. Let me know if you're willing to do this, and have the time? Regards Click Studios
  22. Hi again, Did you reinstall the web server from scratch or just change the culture via Powershell? The reason i ask is because i tried to change the culture on the server installed with the nb-NO culture to en-US via powershell (system wide) . Although it seemed to be applied system wide I still got the error when installing Password state. When i reinstalled the webserver from scratch and choose English - United States at the start of the Windows Setup everything worked as intended. So if your server was installed with en-US as the culture then I would presume everything would still work even if you changed the culture via Powershell to nb-NO. Anyhow. I have now tested by reinstalling the server (2016 server core) with our usual settings (English, Norwegian Bokmål, Norwegian). The database is using the Danish_Norwegian_CI_AS collation as before. Here is a Get-Host of the server. PS F:\Backup> Get-Host Name : ConsoleHost Version : 5.1.14393.206 InstanceId : 05f6fb6c-4a82-41a0-b32b-5e1ff62a2afb UI : System.Management.Automation.Internal.Host.InternalHostUserInterface CurrentCulture : nb-NO CurrentUICulture : en-US PrivateData : Microsoft.PowerShell.ConsoleHost+ConsoleColorProxy DebuggerEnabled : True IsRunspacePushed : False Runspace : System.Management.Automation.Runspaces.LocalRunspace CurrentCulture = nb-NO CurrentUICulture = en-US This time i didn't join the server to the domain in case there was some strange GPO at work. I then reinstalled passwordstate and i get the same error as before on the admin creation page. The conversion of a nvarchar data type to a smalldatetime data type resulted in an out-of-range value. I really have no idea. But seeing as you cannot reproduce the error even with a server installed with my culture settings I think we should just cut our losses and move forward. Having the server installed with en-US as the primary culture is fine. As i mentioned above it didn't cause any problems during testing yesterday, so I don't expect any problems going forward. I really do appreciate you taking the time to troubleshoot on your end. But I'm fully aware that Cultures and Languages other than English are not supported. I'll reinstall (yet again :)) with United States as the primary culture and get our new server up and running.
  23. Yes, all the servers are installed in English - Trust me, no one uses language packs on a Windows Server. One of the main reasons is that error messages in Norwegian don't get many hits on Google No culture/language or UI settings are changed after install. All we do is update the server, run our DSC script to install IIS and required modules. Then we install Passwordstate and off we go. I'll reinstall a new server manually with our usual settings (English, Norwegian, Norwegian) and try again. I'll get back to you when I've done that. Thanks for taking the time to have a look at this and hopefully i haven't sent us on a wild goose chase. Maybe there was some sort of corruption with that initial server I setup that caused the issue and simply reinstalling (coincidentally with the United States Time and date format) fixed the issue.
  24. Hi Jack, We must be missing something, as we cannot seem to replicate this issue. I've tried: Time and Currency Format: Both Norwegian options And setting SQL Collation to "Danish_Norwegian_CI_AS" Rebooting the server after making these changes as well, and I cannot seem to fault this. Was your web server originally installed with English United States as the language, or was this changed afterwards? I also testing with SQL being installed on the same web server - I doubt that would make any difference. Regards Click Studios
  25. New Entry Time Out

    Hi Michael, You should only be logged out if you are inactive on the site for the timeout period specified - which is 10 minutes by default. You can check this on the screen Administration -> System Settings -> Miscellaneous tab. Are you leaving the Add Password screen open for more than 10 minutes without any activity on the screen? If you are not, then do you have any Anti-virus software installed on your web server - we've seen McAfee and Trend kill sessions in IIS, and this could be the cause? Regards Click Studios
  26. New Entry Time Out

    Is there a control to prevent being logged out while entering a new credential into PasswordState? I keep losing important passwords as i configure devices then dont get back in time to hit the save button.
  27. Hi Jack, Thanks very much, and we'll setup a new server today with those Time and Currency Format, and see if we can work on a fix for this. We appreciate the feedback. Regards Click Studios
  1. Load more activity