Dragnet 1.0 beta - cannot access through web browser

dwenzel · Post by **dwenzel** » Wed Nov 03, 2004 3:46 pm

I just downloaded the Vault 3.0 and Dragnet 1.0 beta installations. I get the login screen and correctly enter the admin user with password, but the login screen redisplays. I must be correctly entering the user/password because I have tried other combinations which do not exist and I get a corresponding error message. Similarly, I cannot access the VaultService in the same manner through the web browser, i.e., the same results of entering a correct username/password and the login screen redisplays. I can use the Vault client GUI to access the Vault server without a problem, and I correctly configured the Dragnet for bug tracking because I can bring up the "Show my bugs" dialog. Any thoughts on what may be the problem?

Post by **jclausius** » Wed Nov 03, 2004 9:19 pm

Can you place both the Vault server and Dragnet Web app into "Debug" mode for logging?

Dragnet's setting is in web.config. Change the app setting from Quiet to Debug. Vault's setting can be configured from the Vault Admin Tool.

Once you have made the changes ( and restarted Vault ), try the login(s) again. Then, let's see what the log files have recorded.

Guest · Post by **Guest** » Thu Nov 04, 2004 8:11 am

I went into the web.config file for both Vault and Dragnet and change the logging option from "Quiet" to "Debug". I then rebooted my machine. I went through the same process of trying to login through the web browser.

See attached sgvault.log and dragnet.log files.

I should point out that I am IE 6.0.2900 on Windows XP Pro with SP2. I am also running Norton Internet Security, and I have tried this with the firewall disabled and enabled.

dwenzel · Post by **dwenzel** » Thu Nov 04, 2004 8:17 am

Sorry, I accidently posted the last reply as Guest.

I also wanted to mention that the last entry in both log files is my attempt to login through the web browser. In both cases, it looks like I logged. That is indicated by login's without corresponding logouts. Some of the login's you see in the sgvault.log are from yesterday when I was using the Vault Admin/Client GUI tools. The one Vault login this morning as Admin was to change the logging option, and that is when I was notified that I should restart IIS and I just decided to perform a complete reboot.

Post by **jclausius** » Thu Nov 04, 2004 8:57 am

Is it possible you've disabled Cookies in your browser? One thing that both browser interfaces require for authorization is a ticket which is stored in a Cookie by your client browser.

Now the Vault GUI client handles its own cookie containers, so I don't believe those can be "turned off". Is it possible your browser is not allowing cookies from either web application?

dwenzel · Post by **dwenzel** » Thu Nov 04, 2004 9:35 am

I have the default Medium level privacy set in IE for Intranet sites with no additional changes. I lowered the setting to enable all cookies and I get the same operation.

Here is something interesting. I have two machines with Vault server loaded -- one with 2.0.6 and one with 3.0. I decided to load the 3.0 on a different machine to try it out before I committed my active repository to it. Anyway, using the same web browser (i.e., same "client" machine), I can access the 2.0.6 Vault server without any problem. It is only when I try to access the 3.0 server that I have the problem. Note that the web browser and the Vault server 3.0 are on the same machine. I have a third machine from which I can use the web browser to access the 2.0.6 server without a problem, and from this browser I can access the 1.0 Dragnet but the 3.0 Vault server keeps giving me a redirection page (Object moved to here). When I went back to the web browser where I was having problems and I entered the IP address for the same machine instead of using its machine name, I then got into the Internet (instead of Intranet) zone, and I could access the Dragnet server, but I still cannot access the Vault server.

Post by **jclausius** » Thu Nov 04, 2004 9:47 am

A colleague just pointed out something. Your host name is "CEREBRAL_DEV".

DNS only allows certain characters for host names, and '_' is not one of them. I wrote a SOS Collab KB article about this http://support.sourcegear.com/viewtopic.php?t=11. Although it is a Collab article, the same will apply to Vault Web as well as Dragnet.

See what affect changing the machine's name to CEREBRALDEV has on your configuration.

dwenzel · Post by **dwenzel** » Thu Nov 04, 2004 10:24 am

Thanks. However, I have uninstalled the Vault and Dragnet, renamed my machine to remove the underscrore, rebooted, and then when I tried to install Vault it failed because the SQL account changed. So, can I uninstall SQL to reinstall it so that it sees the new computer name without losing my database?

Post by **jclausius** » Thu Nov 04, 2004 10:36 am

Yes.

Just detach or backup your databases first, then Uninstall SQL Server. Once it has been removed move the vault / dragnet databases out of SQL Server's Data directory. If you did a "detach", do not delete the .mdf and .ldf files, as these are your databases.

Once SQL Server's directories have been cleaned, reinstall SQL Server. If you detached, move the .mdf / .ldf files back into the Data directory and attach. If you backed up, then restore the databases.

Once SQL Server is up and running, and you confirmed the databases are available, reinstall Vault / Dragnet.

Post by **jclausius** » Thu Nov 04, 2004 11:00 am

Please note, you do not necessarily have to uninstall / reinstall SQL Server when the machine's (which is hosting SQL Server) name changes.

I believe SQL Server's Books Online has some information about what to do when the machine's name changes.

dwenzel · Post by **dwenzel** » Thu Nov 04, 2004 12:07 pm

I followed the MSDN documented procedure for SQL Server to rename a server. Now, when I try to install Vault, I get as far as the installation detecting that I have an existing Vault database on the server, but when I select to keep the database I get the following error message:

(note using Machine login for IIS Process Model)

"The user, CEREBRALDEV\ASPNET, could not be added as a SQL Server login. Please verify the windows account exists on this machine."

But, ASPNET is an active user account on the machine. Is there a problem in that the database knows about ASPNET from CEREBRAL_DEV before I changed the name of the machine and has it associated with the database when it was created? How do I get around this?

tbdean · Post by **tbdean** » Thu Nov 04, 2004 1:59 pm

Should we continue to post dragnet issues here, or will there be a dragnet section of the forum created?

Post by **jclausius** » Thu Nov 04, 2004 2:18 pm

A couple of questions:

1) Are you configuring things to connect to SQL Server through Windows Auth or SQL Server Auth? From your description, it appears you are using Windows Auth.

2) If you log in to Query Analyzer or a different query tool (using the same account you use in the installation), can you run the following queries:

sp_grantlogin 'CEREBRALDEV\ASPNET'
sp_revokelogin 'CEREBRALDEV\ASPNET'

Any unexpected errors from those queries?

3) If you run sp_revokelogin 'CEREBRAL_DEV\ASPNET', does that remove the left over user?

sterwill · Post by **sterwill** » Thu Nov 04, 2004 2:27 pm

I've just created a new Dragnet category with the usual forums. For now, any questions about the test releases of Dragnet should go to the Support (Dragnet) forum.

dwenzel · Post by **dwenzel** » Fri Nov 05, 2004 2:57 pm

Sorry, but I have not had a chance to get back resolving this issue until now. To answer your questions:

1. Yes, I am using Windows authentication.
2. I tried both commands. The sp_grantlogin failed saying that it could not find the user. The sp_revokelogin succeeded.
3. This sp_revokelogin succeeded and I suspect this is the one which now allows me to get through the Vault server installation successfully where it finds the existing database. Perhaps, the installation could do this (i.e., the sp_revokelogin in the case of the error) for us?

I am going to go through all of these steps one more time so that I can document them for future reference.

Thanks much for your help!

SourceGear Support

Dragnet 1.0 beta - cannot access through web browser

Dragnet 1.0 beta - cannot access through web browser

DragNet