Jump to content

lunger

Members
  • Content count

    19
  • Joined

  • Last visited

  • Days Won

    1

lunger last won the day on July 4 2014

lunger had the most liked content!

About lunger

  • Rank
    Junior Member
  1. It would be nice if there was a Documents tab on the Edit Password screen to allow documents to be uploaded, rather than having to click the actions button from the list. It would also be nice if there was an option to show list-related documents on the same screen as the password list itself.
  2. Backup Failure

    Whoa... I've discovered that manual backup works with Firefox! Until now I've only tried it with Internet Explorer (version 11) because it allows clipboard clearing and pass-through authentication. Seems weird that the backup process can be subverted by the client. Manual Synchronization of AD groups also seems to have problems with IE11, as it works in Firefox. Did I miss a memo about IE11 being unsupported? So now that I've diagnosed that issue, let me get back to the Active Directory "Managed Service Account". Are you aware that a "Managed Service Account" is an actual account type introduced to Active Directory in Windows 7 and Server 2008 R2? You can read about it here: http://technet.microsoft.com/en-us/library/dd560633%28v=ws.10%29.aspx. Since the account type you really want is just a user account, this heading is very confusing for people who actually know about this type of account. Please change the heading.
  3. Backup Failure

    With regard to the naming convention, I believe the event log entry relates to the Test Permissions activity, not the manual backup attempt. With respect to the extra backslash, I had a trailing backslash in my backup path which I've since removed. My Backup and Upgrade Settings page looks like this:
  4. Backup Failure

    Thank you for your response. On the Active Directory Options tab the section for account information is labeled "Active Directory Managed Service Account". Is this just a normal user account in AD, or is it an actual Managed Service Account as defined in http://technet.microsoft.com/en-us/l...=ws.10%29.aspx? My understanding is that Managed Service Accounts have passwords that are managed automatically, so this is a point of confusion. If this is just a simple user account, then the heading should be changed to reflect that. Potential bug: I've created a domain user account which is able to enumerate AD group members using the Active Directory Security Groups Debug Screen. I've entered this user's credentials as the "Managed Service Account" on the Active Directory Options tab. The problem is, when I run a manual synchronization of a group, it does not actually synchronize new members. However, the group is synchronized properly at the interval specified on the Active Directory Options tab under Synchronize Security Group Memberships, and User Account status at. When you say I don't need to play with the App Pool or Windows Service any more, does this affect the identity for the SQL Server service? Does the "Managed Service Account" have anything to do with Backups? The bottom line, I still can't run a manual backup successfully. It creates the .zip file, but not the .bak file and not the log entry. For the time being the automatic backup is running. When I run the Test Permissions action in Backup and Upgrade Settings, it succeeds. I've also found the following event in Windows Event Viewer: Event 18264, MSSQL$SQLEXPRESS Database backed up. Database: passwordstate, creation date(time): 2013/09/27(16:42:50), pages dumped: 971, first LSN: 150:136:55, last LSN: 150:161:1, number of dump devices: 1, device information: (FILE=1, TYPE=DISK: {'\\\\PasswordState\\Paswor dstate_Test.bak'}). This is an informational message only. No user action is required. Similar events are present for automatic backups, but no events are present for manual backup attempts. It appears to me that the manual backup stops after creating the zip file and before dumping the database. Update: I've also enabled logging of successful logins on SQL Server and it shows a successful login when I attempt a manual backup. However, it doesn't log a backup entry
  5. Backup Failure

    You are correct, I do not have the "Exclude Backup of Database" option enabled. Also, when I run the "Test Permissions" action from Backup and Upgrade Settings, it indicates "Test Succeeded". This morning I discovered the following log entry: Event 0, Passwordstate Service An error has occurred executing the call 'QuerySystemSettings' - Cannot open database "passwordstate" requested by the login. The login failed.&stacktrace= at System.Data.OleDb.OleDbConnectionInternal..ctor(Ol eDbConnectionString constr, OleDbConnection connection) at System.Data.OleDb.OleDbConnectionFactory.CreateCon nection(DbConnectionOptions options, DbConnectionPoolKey poolKey, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.Creat eNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionFactory.TryGe tConnection(DbConnection owningConnection, TaskCompletionSource`1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryO penConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource`1 retry, DbConnectionOptions userOptions) at System.Data.ProviderBase.DbConnectionInternal.Open Connection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OleDb.OleDbConnection.Open() at ..() However, this error corresponds to a system restart, so I suspect the Passwordstate service was simply running before the SQL Server service was ready. Another error that I discovered, this one coinciding with a failed attempt to manually synchronize an AD security group: Event 0, Passwordstate Service You must specify an 'Active Directory Managed Service Account' on the screen Administration -> System Settings -> Active Directory Options tab in order to synchronize User Account and Security Group Membership status. What's this about a Managed Service Account? The point of a Managed Service Account is that the password is managed automatically by active directory. What do I enter for the account information in the Active Directory Options tab? By the way, I've just noticed another problem. My session times out in 2 to 3 minutes when I have the timeout option set to 10 minutes! Why does it seem like this software is falling apart?
  6. Backup Failure

    Thank you for your response. Just to recap, I've had two problems: 1. On two occasions, automatic scheduled backups stopped working. When this occurred, no email notification was sent and nothing was added to the log. 2. On both occasions, when I discovered that automatic backups were not taking place, I also discovered I could not do a manual backup. When I tried to do this, it would stop after "Compressing web files...". Because manual backup did not work, I could also not perform an an upgrade from the web interface.\ On the first occasion, I proceeded with a manual upgrade of Passwordstate. After the manual upgrade, I could once again perform a manual backup and automatic backups were also working again. On the second occasion, I completed the step about "Log on as batch job". After that I still couldn't do a manual backup, but the automatic backup started working again. Later, I tried a manual upgrade. No I am running the latest version, build 6250, and automatic backups work, but manual backups still stop after "Compressing web files...". I would like to be able to regain the manual backup functionality. It creates the zip file, but does not create a backup of the database. What would cause this? Lonnie
  7. Backup Failure

    I performed a manual upgrade from build 6231 to the latest build 6250. The problem persists. I still cannot complete a manual backup.
  8. Backup Failure

    In future updates to Passwordstate, it would be helpful to have more verbose progress information regarding manual backups. Also, when a scheduled backup fails, it should always send a notification email. With regard to Event 18456 "MSSQL$MICROSOFT##WID" "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database 'IPAM'. [CLIENT: ]". I found this forum post which indicates that the SQL Server service should always run under the NETWORK SERVICE user account. This event is being posted because Passwordstate requires it to run under a different account.
  9. Backup Failure

    The scheduled backup is working, but I still can't get the manual backup to run. I tried adding the NETWORK SERVICE account to the SQL Logins list for the passwordstate db, but that didn't seem to change anything. Can you explain what happens when running a manual backup? What is the order of operations? It seems that the web files are zipped first, then the database is backed up? What authentications are made? Is there any logging done by Passwordstate that could be used to debug?
  10. Backup Failure

    So this morning the scheduled backup magically succeeded, but I still get the same result when attempting a manual backup. I'm really at a loss.
  11. Backup Failure

    The first time this problem occurred, I was able to resolve it by doing a manual upgrade to the latest version. Now I'm experiencing the problem again. Scheduled backup was working fine until January 19. After that, it did not run and no entries were made in the backup log. I also experience the same behavior when attempting to run a manual backup. When I start the backup, it hangs on "Compressing web files...". It never indicates that it's finished and never creates an entry in the backup log. If I click the "Please Wait..." button it throws an error that the file already exists. In this case, it creates a log entry. The suggestions mentioned above have not been helpful. As I said, backups were being run successfully until suddenly not working. I have noted that when running a manual backup, the zip archive of the web files appears to have been created in the backup target directory. The .bak file containing the database backup is not created. I have also noted that the Windows Event Viewer shows several events that appear to be related to the backup: Events showing the Passwordstate Service being restarted. Event 1316, "ASP.NET 4.0.30319.0" relating to /sessionstatus.aspx with a secondary event code 4009 and message "Viewstate verification failed. Reason: The viewstate supplied failed integrity check." Event detail code: 50203. Process name: w3wp.exe. Event 18456 "MSSQL$MICROSOFT##WID" which states: "Login failed for user 'NT AUTHORITY\NETWORK SERVICE'. Reason: Failed to open the explicitly specified database 'IPAM'. [CLIENT: ]" Obviously, I need to get the scheduled backup working again. Also, why does Passwordstate not send a notification email when the backup fails in this manner? I should also mention that when I "Exclude Backup of Database" in "Backup and Upgrade Settings, the issue persists. When I click "Test Permissions", the test succeeds.
  12. Backup Failure

    I have two problems with the Backup feature. My first problem is that the scheduled backup has stopped working. The scheduled backup was working fine from October 1 (when I installed it) until October 11. Since then it has not automatically launched the backup. My second problem, which I suspect is related, is with the manual backup. When I start the backup, it hangs on "Compressing web files...". It never indicates that it's finished and never creates an entry in the backup log. If I click the "Please Wait..." button it throws an error that the file already exists. In this case, it creates a log entry. Any ideas how to troubleshoot this problem? Lonnie
  13. Don't want all users in AD security group

    Ok, so I understand how the feature is intended to work. Let me try to clarify my problem. I have an AD group named "All Staff" which I've added to passwordstate. This group contains 9 users. However, I only want 7 of these users in Passwordstate. The other two, "specialadmin" and "template", I do not want in Passwordstate at all. The active Directory Options are set as follows: "If a User Account is found within a Security Group which hasn't already been added to Passwordstate, would you like to automatically add the User Account" = No "Synchronize the enabled/disabled status of Active Directory user accounts with the user accounts in Passwordstate" = Yes "Synchronize the enabled/disabled status of Active Directory user accounts with the user accounts in Passwordstate" = No "Allow the Password List setting of 'Show Active Directory & Windows Actions for Passwords which are enabled for Sync'" = No "When an account in Active Directory is deleted, perform the following in Passwordstate" = "Disable Passwordstate Account" "Synchronize Security Group Memberships, and User Account status at" = 2 hour My problem is: Even though I never added the "special admin" and "template" users to Passwordstate, they keep appearing -- even after I delete them.
  14. I've added an AD security group, but I don't want all the users in the AD group to be present in Passwordstate. In System Settings\Active Directory Options I disabled the "If a User Account is found within a Security Group which hasn't already been added to Passwordstate, would you like to automatically add the User Account" option. Then I remove the undesired users from Passwordstate. The problem is, the users keep reappearing. What am I doing wrong?
  15. You are correct, the height is too small. Perhaps you could provide multiple layout options in a manner similar to the "Grid Layout Actions".
×