Server 2008 R2 64Bit strange behavior after install

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

Moderator: SourceGear

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Fri Jul 16, 2010 8:40 am

The scenario:
We are moving the vault database from a Server 2003 (32 Bit) to a 64 bit Server 2008 R2 (among other things).
We installed the new server on new hardware, gave it a name 'NewX', copied the files and stuff from 'X' to 'NewX', then renamed 'X'->'OldX' and 'NewX' -> 'X' (just so the internal network will appear to run the same to everyone else). Now in the process of installing the web services (like Vault) on 'X' (the new one).

The Server 2003 was running SQL server 2005 Standard. The Server 2008 R2 is running SQL Server 2008 Enterprise.
Server 2003 was running IIS6; Server 2008 R2 is running IIS7
Server 2003 Vault was installed as own 'site' on port 8000; on Server 2008, I created a separate site as well on port 8000 (this keeps the vault service separate from other web services like CRM running on the same machine)

Copy and restore of the database worked fine to Server 2008
I created a new directory and 'site' on Server 2008 stored in C:\Inetpub\VaultServer (on Server 2003 it had been stored at C:\InetPub\wwwroot)

I installed the 64 bit 5.0.4 release (just downloaded today); Server 2003 was running 5.0.3 32 bit version.

During installation that appeared to work just fine (it found the database, asked if we wanted to keep it, etc.) is when the strange behavior occurs;
[The web browser is IE8 and the URL is in the 'Trusted' sites zone which does have scripting turned on (I think)]

Immediately after installation, you are placed in a web browser for Admin functions. The url is http://xyz.domain.com:8000/vaultservice ... Login.aspx?........
but the web display has NO images, only simple text and hyperlinks; it is as if the javascript code that is in the page isn't being executed [this is my conjecture]. You can do some of the Admin stuff by clicking on the links that appear, but the background images etc.

Furthermore, a client computer accessing http://xyz.domain.com:800/vaultservice (to get the new client installed), is presented with a completely blank screen whose page contents contain only
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=windows-1252" http-equiv=Content-Type></HEAD>
<BODY></BODY></HTML>
This was using Firefox 3.6.6

If I use my existing 5.0.3 client to access the new server, the respository shows up just fine, and we can do normal vault things.

It appears that something in the 'web' delivery of pages is mucked up on this installation? or we have IIS7 configured in some bizarre fashion?

Have anyone else observed this behavior? Suggestions?

I have added a snippet of the sgvault log:

Code: Select all

----16/07/2010 9:29:00 AM    admin--fe80::e4be:e719:5335:ba6f%11(fe80::e4be:e719:5335:ba6f%11)--SSL Disabled	Login 
----16/07/2010 9:31:57 AM    kadorken--puma.thoughts.thinkage.ca(192.102.11.45)--SSL Disabled	Login 
----16/07/2010 9:44:07 AM    sgvaultsystem--()--	
	System Started
	Version 5.0.4.18845
	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 = 102400
	Overwrite Log on Startup = False
	Session Timeout = 10080
	SGVault Working Directory = C:\Windows\Temp
	SGVault Server URL = 
	Identity = IIS APPPOOL\VaultAppPool 
----16/07/2010 10:41:27 AM   admin--fe80::e4be:e719:5335:ba6f%11(fe80::e4be:e719:5335:ba6f%11)--SSL Disabled	Login 
----16/07/2010 10:46:55 AM   sgvaultsystem--()--	
	System Started
	Version 5.0.4.18845
	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 = 102400
	Overwrite Log on Startup = False
	Session Timeout = 10080
	SGVault Working Directory = C:\Windows\Temp
	SGVault Server URL = 
	Identity = IIS APPPOOL\VaultAppPool 
----16/07/2010 10:47:02 AM   admin--fe80::e4be:e719:5335:ba6f%11(fe80::e4be:e719:5335:ba6f%11)--SSL Disabled	Login 

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Fri Jul 16, 2010 9:52 am

Could you post a screenshot of what you're seeing when you log in from the Server machine?
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Fri Jul 16, 2010 10:44 am

sourcegearscreenshot.jpg
Screen short of Admin screen
sourcegearscreenshot.jpg (159.7 KiB) Viewed 11839 times

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Fri Jul 16, 2010 1:56 pm

It may be that static content is disabled in IIS. Static content should be enabled by default in IIS 7.

Go to ControlPanel->Programs and Features->Turn Windows Features on or off->Internet Information Services->World Wide Web Services->Common Http Features and make sure Static Content is turned on. You probably want most of those common things turned on for Fortress to work (except I don't think Fortress needs Directory Browsing).
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Fri Jul 16, 2010 2:20 pm

Thanks Linda, but have tried that and server side includes ;no change in behavior

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Fri Jul 16, 2010 3:10 pm

Have you tried restarting IIS with an iisreset from a command prompt?

If that doesn't work, I'd suggest we schedule a remote assist session where I can take a closer look. Email support at sourcegear.com, Attn: Linda, and we'll set something up. Please include a link to this forum post.
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Wed Jul 21, 2010 3:56 am

Yes, have tried iireset. Some more (probably important :)) information. I run the VaultService on port 8000; I'm wondering if there is something else besides TCP port 8000 incoming&outgoing I need to open on the firewall?

The behavior is like you can connect but no data comes back like it is being blocked (like by a firewall).

Have been busy last two days trying to get the Microsoft CRM back and running on the same machine on IIS7; Vault by comparison is a piece of cake and pleasure to setup (other than the strange behavior); Microsoft CRM on the other hand - stay way way away !

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Wed Jul 21, 2010 4:36 pm

If you use a browser on the server machine and connect to http://localhost/VaultService/VaultWeb/login.aspx instead of using the server name in the URL, do you get the same results? This would rule out any network issues.
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Thu Jul 22, 2010 7:23 am

Hypothesis based on getting our CRM add-on to work. I discovered that .net SQL client SqlReader quietly fails to return any data when the asp program was operating as 'network service'. I suspect some system 'right' is missing that prevents the low level read network packet that is used to fetch the SQL data from working (I traced it this far and no data was returned). When I changed our program to run in an app pool with an administrator account, our program started to return the data

Does some of the vault ui for the asp depend on reading information from the vault database (say for colors or styles?) and does it do it with some form of connection involving SqlReader (or even ado datasets that use sqlreader )

This is just a long shot guess....

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Thu Jul 22, 2010 5:07 pm

Our pages are dynamically generated from code. There are stylesheets in the Fortress virtual directory but I've renamed them in the past without much effect.

I know we've already discussed the Static Content configuration, but could you post a screenshot of your setting for that as it appears in IIS?

What you're seeing looks exactly like what we see when we turn Static Content off.
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Fri Jul 23, 2010 5:47 am

Have attached the screen shots of what I believe are correct illustration that static content is enabled. If I missed one, let me know - perhaps there is some other option I need to turn on elsewhere?

Also included the configuration of the web server (two pages).
Attachments
vaultstatic4.jpg
vaultstatic4.jpg (271.79 KiB) Viewed 11776 times
vaultstatic3.jpg
vaultstatic3.jpg (95.68 KiB) Viewed 11776 times
vaultstatic2.jpg
vaultstatic2.jpg (95.99 KiB) Viewed 11776 times
vaultstatic1.jpg
vaultstatic1.jpg (246.4 KiB) Viewed 11776 times

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Fri Jul 23, 2010 4:17 pm

I configured my Win 2008 R2 64-bit server to use the same settings as you're using -- everything looked fine. I turned off static content, and all the styling went away.

So I'm stumped. You might try uninstalling and then reinstalling Static Content.

Could there be something in your browser settings that are blocking the display? Is Javascript enabled?
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Wed Jul 28, 2010 1:01 pm

One of your earlier questions asked about using http://localhost versus http://server to make sure there were no 'firewall' problems.

One thing I tracked down with out CRM installation is that http://localhost (on the server) does NOT respond to web requests [In the CRM, the Async service was configured to use "" (i.e. localhost) and was getting 404 errors due to this configuration; I reconfigured the Async service to use the server name].

Is there any assumption in vault that 'localhost' should work to fetch things? (I cannot do http://localhost:8000/vaultserver on the server - it returns a 404 error).

Haven't yet tried uninstalling/reinstalling static content (have to wait till lull in CRM usage) on the server.

lbauer
Posts: 9736
Joined: Tue Dec 16, 2003 1:25 pm
Location: SourceGear

Re: Server 2008 R2 64Bit strange behavior after install

Post by lbauer » Wed Jul 28, 2010 3:20 pm

When you connect to "localhost" you're not going out on the network and coming back into the server. It's a useful tool for diagnosing connectivity issues. However not all web servers are set up to use localhost.

Is the the actual URL you're using? That's not a valid URL for Vault.
http://localhost:8000/vaultserver

Can you access
http://localhost:8000/vaultservice ?

That the "home page" for Vault.
Linda Bauer
SourceGear
Technical Support Manager

kadorken
Posts: 77
Joined: Mon Feb 16, 2004 8:38 am
Contact:

Re: Server 2008 R2 64Bit strange behavior after install

Post by kadorken » Thu Jul 29, 2010 4:54 am

lbauer wrote: Can you access
http://localhost:8000/vaultservice ?

That the "home page" for Vault.
Sorry, it was a typo in my earlier submission; I meant vaultservice and no, I cannot access http://localhost:8000/vaultservice

I uninstalled 'static content', restarted the server, reinstalled 'static content', restarted the server; no change in vault behavior; however, now my CRM installation is completely screwed up - back to fixing it ...

Post Reply