Unable to log in to licenses pages after Vault 4.0 install

[rshillington]

The setup:
Vault database on a seperate machine running SQL Server 2000
Vault Web being installed to a non default web site previous setup with a host header, and a directory not in the c:\inetpub\wwwroot

First problem as previously mentioned elsewhere on this forum, the installer trys to launch the licenses.aspx page from http://localhost which is not correct in my case. An inconvenience but that's not the big issue.

I change the URL and get the expected login page, advising me to log in as Admin with the password I supplied at install time. But I can't get logged in. When use the same password (both by typing it in very carefully, and by copy and paste from notepad) I get
Login Failed: The username or password supplied is invalid.

At this point I'm at a loss --- there is a very slim possibiilty that the password for the admin accont under 3.51 was changed --- but I seriously doubt it. So now I'm at a loss on how to trouble shoot this.

Thanks in advance,
Ralph Shillington (A happy vault user since the very beginning!)

[jeremy_sg]

Ralph,

Check your Vault server log file to see if anything points to the cause of this problem.

[rshillington]

WHile I was waiting (which certainly wasn't long) I restored to the prvious version and using the GUI Admin tool of 3.51 verified that I do know what the admin password is. So I think I have now ruled out finger trouble.

As for the log file... Below is all that was there. What I find interesting here is the name of the machine recorded, which is not the host name that I have mapped to the web site (ala custom host header) I'm going to try and access that page from somewhere other than the server and see what happens.


----03/06/2007 7:57:13 AM admin--server2.ifoundtime.com(127.0.0.1)--SSL Disabled Login failed: FailNotValidLogin

[rshillington]

Since I restored the database back to the 3.51 backup, I'm unable to install the vault server. It now fails on upgrading the database with this:
Adding foreign keys to [dbo].[tblclientoptions]
Adding foreign keys to [dbo].[tblhistoryfavorites]
Adding foreign keys to [dbo].[tblwatchers]
Adding foreign keys to [dbo].[tblcloaks]
Adding foreign keys to [dbo].[tbldelayusersecuritychanges]
Adding foreign keys to [dbo].[tblfsobjectlabelchanges]
Adding foreign keys to [dbo].[tbltransactions]
Adding foreign keys to [dbo].[tblcheckoutlistitems]
The database update failed
Error during Vault upgrade script.
Vault Setup is exiting due to a failure or cancellation. Error Code = -1280

How wierd is that? Mercifully I can still run with 3.51 so if push comes to shove on Monday morning that will be my fall back position. Notwithstanding, I would like to get ths sorted, so thanks for any help you may provide.

[jeremy_sg]

Ralph,

On a 4.0 install, can you look at your VaultService/web.config? We use Forms authentication now, and there are machine keys that need to be set to handle web logins

<machineKey validationKey="BLAH" decryptionKey="BLAH" validation="SHA1" />

Can you confirm that those strings were set in your web.config?

[jeremy_sg]

I'm assuming that you restored a 3.51 Vault backup and you're trying to reupgrade? The thing that you need to do is to make sure that you delete the sgmaster database when you restore the upgrade. We now have two databases, sgvault and sgmaster.

If you delete sgmaster, you should be able to upgrade your restored backup.

[rshillington]

right I guessed that bit about removing sgmaster and that did it, the upgrade worked this time. Also I tried to access the licences page remotely and that's working now too. I can't explain it except for 2 things:

1) when I tried to log in I to a message about "Session dropped, try again likely because of a reconfiguration" (Sorry I didn't copy it down directly) but that was a new message --- and I'm now guessing that an iisreset after the intall may be worth a try? Anwyay the more likley reson is

2) The treat of remaining at 3.51 for Monday morning was heard by servers and they decided "Oh ok now he's serious -- better start cooperating"

My money is on #2.

BTW The vault GUI client is working fine on my Vista Ultimate (32 bit) machine ZERO heartache on the install.

Thank you for your collaboration on this setup --- I wish you ever sucess on this release, which I'm sure you all will enjoy.

Congratulations
Ralph Shillington
iFoundTime Inc.
Ottawa, Canada.

[Pierre Chew]

Is anyone else having this problem? I am getting the following error when I try and log in:

Login Failed: The username or password supplied is invalid.

I know the password is correct because I have uninstalled the re-installed the server several times and I was very careful with the password every time.

This is what my log shows me.

# SourceGear Vault Server
----8/5/2007 1:10:35 PM admin--DatabaseServer1.secureserver.net(10.0.0.1)--SSL Disabled Login failed: FailNotValidLogin

Any one have any suggestions on how to fix this?

Pierre Chew
pchew@pacbell.net

[jeremy_sg]

Pierre,

A couple of questions.

1. What version are you running?
2. What database connection type are you using (SQL or Windows authentication)?

[Pierre Chew]

I am trying to upgrade to 4.02. Should I just hold off for 4.04? Also, does it matter which database authentication mechanism I use? Should I be trying one over the other?

Is this configuration setting specified in the config file?

P.

[jeremy_sg]

4.0.4 is now released. There was a bug in the 4.0.2 installer which might have caused the error that you're seeing. Please try the latest version.