"too many users" error despite only single user-Va

If you are having a problem using Vault, post a message here.

Moderator: SourceGear

Post Reply
MikeTheTall
Posts: 6
Joined: Mon Apr 18, 2005 6:31 pm

"too many users" error despite only single user-Va

Post by MikeTheTall » Mon Apr 18, 2005 6:36 pm

My problem is that I'm getting the error message "You have more active users than valid licenses. User accounts are disabled until the "admin" user deactivates some users."

What's really problematic is that when I launch the Vault admin tool, and try to log in (in order to delete/inactivate some accounts), it still gives me that same error.

How I got the error:

I'm trying to use SourceGear Vault, in order to allow students in my classes to hand in their homeworks via SCM, rather than on paper/fileshare. In order to facilitate the creation of a large (ish - ~30 or so) accounts, I created a Perl script which would read a text file (of usernames-to-be), and use the command line tool to create a new user account, then create the new user's top-level directory.

When I ran this script, I started getting the above error message about 1/2 way through the list of names, which was fine. However, now I can't log in anymore, so I can't deactivate accounts, nor use teh client, etc, etc.

It appears that the server is 'jammed' (much like a photocopier :) ) on this one problem, and won't move beyond it.

Any help / suggestions would be great.
Thanks!
--Mike
Top
MikeTheTall
Posts: 6
Joined: Mon Apr 18, 2005 6:31 pm

More info

Post by MikeTheTall » Mon Apr 18, 2005 6:37 pm

This is SourceGear Vault, I *believe* version 3.0.1, with the server running on a different machine that the client.
Top
dan
Posts: 2448
Joined: Wed Dec 17, 2003 5:03 pm
Location: SourceGear
Contact:
Contact dan

Post by dan » Mon Apr 18, 2005 8:51 pm

Check the server log at c:\windows\temp\sgvault after you attempt the login and verify that the same problem is reported (and that it isn't something like a mistyped password). Also, you might verify that you get the same error message from the GUI client as well as the admin tool.
Top
MikeTheTall
Posts: 6
Joined: Mon Apr 18, 2005 6:31 pm

Thanks!

Post by MikeTheTall » Mon Apr 18, 2005 9:34 pm

I don't personally have access to the server machine, but will get it tomorrow, and check it then.

My guess is that it isn't a mistyped username/password, because the script runs in a loop, adding a user & a creating folder each iteration, and I was able to successfully create a number of accounts/folders prior to the snag.

The GUI client gives an error message identical to the admin tool's error message.

I've attached the output of the Perl script, since it contains a lot of Vault output, in the hopes that this helps. Basically, from Perl, I create a Windows command shell w/ the appropriate call to Vault.exe (hackish, I know, but it seemed to be working, even if it was quick and dirty :) ), and a number of these commands work, then I get the 'too many users message', and everything else fails.

A couple of thoughts:
Some of the user accounts already exist - rather than trying to query Vault & avoid duplicates, I simply go ahead & make the ADDUSER call, which (of course) fails. Is this ok? I'm happy, since the account is (already) there, but would it cause Vault problems?

I've changed stuff in the attachement - the students names aren't real, and my password has been changed.

Thanks very much for the quick reply - I'll grab the server logs tomorrow & post another reply here tomorrow (PST)

Thanks!
--Mike
Attachments
VaultBug.txt
Partial Transcript of perl script, immediately prior to, and then after, the server gets clogged with users.
(3.28 KiB) Downloaded 834 times
Top
dan
Posts: 2448
Joined: Wed Dec 17, 2003 5:03 pm
Location: SourceGear
Contact:
Contact dan

Post by dan » Tue Apr 19, 2005 8:33 am

Which version of vault are you running?
Top
MikeTheTall
Posts: 6
Joined: Mon Apr 18, 2005 6:31 pm

Version Info

Post by MikeTheTall » Tue Apr 19, 2005 9:44 am

Hello!

(From the Vault client:)

Client Information
Vault Client Version: 3.0.1.2769
Operating System: Microsoft Windows XP Professional
Service Pack: 2.0
OS Version: 5.1.2600
Total Physical Memory: 1022.98 MB
Time Zone: (GMT-08:00) Pacific Time (US & Canada); Tijuana

Server Information
Server version information unavailable

License Information
License information unavailable
Top
MikeTheTall
Posts: 6
Joined: Mon Apr 18, 2005 6:31 pm

Server log file

Post by MikeTheTall » Tue Apr 19, 2005 9:57 am

Hello!

I got the server log file, and have attached it.

Thanks!
--Mike

When I tried to attach it, I got the error message "The Extension log is not allowed", so I'm pasting it in here:

# SourceGear Vault Server
----4/18/2005 11:15:07 AM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:22:38 PM sgvaultsystem--()--
System Started
Version 3.0.1.2769
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 10000
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain = CASCADIA
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://STUSRCSAFE.cascadia.ctc.edu/VaultService
Identity = vaultservice
----4/18/2005 2:22:39 PM --()-- Vault Failed to establish a connection to the database.
----4/18/2005 2:22:39 PM --()-- Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:22:40 PM --()-- Vault Failed to establish a connection to the database.
----4/18/2005 2:22:40 PM --()-- Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:22:40 PM --()-- The session information was not removed from the database. Please check sgvault.dbo.tblsessions within SQL Server. There may be orphaned sessions stored within the database. Error: FailDBConn
----4/18/2005 2:22:42 PM --cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:22:42 PM --cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:22:43 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:22:43 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Active Directory authorization for user mpanitz failed.
Logon failure: unknown user name or bad password
----4/18/2005 2:30:19 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed: FailInvalidPassword
Active Directory authorization for user mpanitz failed.
Logon failure: unknown user name or bad password
----4/18/2005 2:30:37 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Disabled Login failed: FailInvalidPassword
----4/18/2005 2:30:41 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
Active Directory authorization for user mpanitz failed.
Logon failure: unknown user name or bad password
----4/18/2005 2:31:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Disabled Login failed: FailInvalidPassword
Active Directory authorization for user mpanitz failed.
Logon failure: unknown user name or bad password
----4/18/2005 2:32:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed: FailInvalidPassword
----4/18/2005 2:32:52 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:32:59 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
Active Directory authorization for user mpanitz failed.
Logon failure: unknown user name or bad password
----4/18/2005 2:33:35 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed: FailInvalidPassword
Active Directory authorization for user mpanitz failed.
Logon failure: unknown user name or bad password
----4/18/2005 2:34:08 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed: FailInvalidPassword
----4/18/2005 2:35:38 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 2:35:39 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:35:53 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 2:36:23 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 2:36:24 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:36:33 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 2:36:33 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 2:36:33 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled ListCloakedObjects returned: FailDBConn
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:58:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled The connection to the database failed for VaultServiceAPI.Logout: FailDBConn
----4/18/2005 2:58:24 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:58:24 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:59:06 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:59:06 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:59:14 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 2:59:14 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 2:59:27 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 2:59:34 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled ListCloakedObjects returned: FailDBConn
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
----4/18/2005 3:00:10 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled The connection to the database failed for VaultServiceAPI.Logout: FailDBConn
----4/18/2005 3:01:48 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:01:48 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 3:01:48 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:01:57 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:01:57 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 3:01:58 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:02:09 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:02:09 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 3:02:09 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:02:11 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:02:11 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:02:17 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled General network error. Check your network documentation.
----4/18/2005 3:02:17 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled FailDBReader
----4/18/2005 3:02:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled General network error. Check your network documentation.
----4/18/2005 3:02:22 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled FailDBReader
----4/18/2005 3:02:24 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:02:24 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled General network error. Check your network documentation.
----4/18/2005 3:02:47 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:02:47 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled SQL Server does not exist or access denied.
----4/18/2005 3:02:52 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:02:52 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled SQL Server does not exist or access denied.
----4/18/2005 3:03:00 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:03:00 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'CASCADIA\VaultService'.
----4/18/2005 3:03:02 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:03:02 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'CASCADIA\VaultService'.
----4/18/2005 3:03:04 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:03:04 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'CASCADIA\VaultService'.
----4/18/2005 3:03:06 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Vault Failed to establish a connection to the database.
----4/18/2005 3:03:06 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot open database requested in login 'sgvault'. Login fails.
Login failed for user 'CASCADIA\VaultService'.
----4/18/2005 3:03:15 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:03:16 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 3:03:16 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:03:18 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:03:19 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:03:21 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:03:21 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:03:23 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:03:24 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 3:03:26 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 3:03:26 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:39 PM sgvaultsystem--()--
System Started
Version 3.0.1.2769
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 10000
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain = CASCADIA
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://STUSRCSAFE.cascadia.ctc.edu/VaultService
Identity = vaultservice
----4/18/2005 4:14:43 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:44 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:46 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:47 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:49 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:49 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:51 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:51 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:54 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:54 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 4:14:54 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:55 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:56 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:14:58 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:14:58 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:00 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:00 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:03 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:03 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:04 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:05 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:07 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:07 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 4:15:07 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:09 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:09 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:12 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:12 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:14 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:14 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:16 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:16 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Cannot insert duplicate key row in object 'tblusers' with unique index 'idxuserlogins'.
The statement has been terminated.
----4/18/2005 4:15:16 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:18 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:18 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:15:21 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Login
----4/18/2005 4:15:21 PM mpanitz--cc1-319-1.cascadia.ctc.edu(216.186.69.128)--SSL Enabled Logout
----4/18/2005 4:48:02 PM sgvaultsystem--()--
System Started
Version 3.0.1.2769
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 10000
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain = CASCADIA
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://STUSRCSAFE.cascadia.ctc.edu/VaultService
Identity = vaultservice
----4/18/2005 5:26:59 PM sgvaultsystem--()--
System Started
Version 3.0.1.2769
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 10000
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain = CASCADIA
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://STUSRCSAFE.cascadia.ctc.edu/VaultService
Identity = vaultservice
----4/18/2005 8:20:54 PM sgvaultsystem--()--
System Started
Version 3.0.1.2769
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 10000
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain = CASCADIA
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://STUSRCSAFE.cascadia.ctc.edu/VaultService
Identity = vaultservice
----4/19/2005 8:43:04 AM sgvaultsystem--()--
System Started
Version 3.0.1.2769
Cache Level = 1
DataBase Buffer Size (KB) = 256
LogFile Path = C:\WINDOWS\Temp\sgvault
Log Level = Quiet
Archive Log = Weekly
ReverseDNS Lookup = True
Maximum HTTP Request Length = 10000
Overwrite Log on Startup = False
Session Timeout = 4320
Active Directory Domain = CASCADIA
SGVault Working Directory = C:\WINDOWS\Temp
SGVault Server URL = http://STUSRCSAFE.cascadia.ctc.edu/VaultService
Identity = vaultservice
Top
dan
Posts: 2448
Joined: Wed Dec 17, 2003 5:03 pm
Location: SourceGear
Contact:
Contact dan

Post by dan » Tue Apr 19, 2005 10:18 am

At which point did your login fail? It looks like you set up Active Directory (and had problems logging in), but those look like they were resolved?

If the log is not displaying anything at the time the "admin" user login fails, set the log level to Debug. You'll have to do this from the config file, since you can't login to the Admin Tool.

Go to c:\inetpub\wwwroot\VaultService (or wherever you installed the server), and edit the Vault.config file, and change LogLevel from "Quiet" to "Debug", then restart IIS.
Top
MikeTheTall
Posts: 6
Joined: Mon Apr 18, 2005 6:31 pm

Short-Term solution

Post by MikeTheTall » Thu Apr 21, 2005 6:30 pm

Hello!

The sysadmin who's actually allowed to access the server apparently managed to fire up some sort of admin tool (I'm not sure which, but I'll post here when I find out), deactivated a student, and now I'm allowed back in (through the https-based admin tool).

Would there be any harm in running the server in 'debug' mode all the time? What way when this happens again, I can get the debug log to you guys.

Thanks!
--Mike
Top
dan
Posts: 2448
Joined: Wed Dec 17, 2003 5:03 pm
Location: SourceGear
Contact:
Contact dan

Post by dan » Fri Apr 22, 2005 7:27 am

The only issues with debug mode is that the log will grow very big very quickly if left on. Also, it probably slows down the server some. Otherwise, it shouldn't affect anything else.

Glad you are up and running
Top
Post Reply

Return to “Support (Vault)”