Any known issues in changing machine name of Vault server

This forum is now locked, since Gold Support is no longer offered.

Moderator: SourceGear

Locked
ismangil
Posts: 197
Joined: Wed Jun 30, 2004 10:49 am
Location: Sheffield, UK
Contact:

Any known issues in changing machine name of Vault server

Post by ismangil » Tue Mar 14, 2006 7:29 am

Are there any server side or client side issues in relation to changing the machine/host name of the Vault server?

Obviously all clients need to point to a different server name, but are there any underlying configs, secret keys, values in databases, license keys, client cache, etc that depends on the Vault server being a certain name?

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Tue Mar 14, 2006 8:45 am

Is SQL Server or MSDE (SQL Server Express) installed on that machine?
Jeff Clausius
SourceGear

ismangil
Posts: 197
Joined: Wed Jun 30, 2004 10:49 am
Location: Sheffield, UK
Contact:

Post by ismangil » Tue Mar 14, 2006 8:48 am

jclausius wrote:Is SQL Server or MSDE (SQL Server Express) installed on that machine?
Yes, the sqlserver is on the same machine. It is configured as Server=(local);

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Tue Mar 14, 2006 9:17 am

SQL Server's engine need to be updated when a machine's host name is changed.

In regards to Vault, Vault Server uses the machine's name in the default.html page. Also, if you are also using Vault's shadow folders, you will need to re-configure Shadow Folders on a host name change.

You'll need to investigate "Renaming a Server" in SQL Server for additional information.


If you don't want to mess with all the re-configuration, you could also:
  1. Backup the sgvault database (as well as any other databases you are using) from SQL Server.
  2. Backup Vault Server's web.config / vault.config.
  3. Uninstall Vault Server.
  4. Uninstall SQL Server.
  5. Rename the machine.
  6. Install SQL Server.
  7. Restore the sgvault database.
  8. Install Vault Server (same version that was removed in step 3). Keep the database when prompted.
  9. Copy over web.config / vault.config.
In either case, you'll probably need to reconfigure Shadow Folders.

HTH
Jeff Clausius
SourceGear

ismangil
Posts: 197
Joined: Wed Jun 30, 2004 10:49 am
Location: Sheffield, UK
Contact:

Post by ismangil » Tue Mar 14, 2006 9:39 am

Thanks, we don't use shadow folders. I will notify our DBA

What about vault plugins hosted on the same server?

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Tue Mar 14, 2006 9:40 am

What type of plugins?
Jeff Clausius
SourceGear

ismangil
Posts: 197
Joined: Wed Jun 30, 2004 10:49 am
Location: Sheffield, UK
Contact:

Post by ismangil » Tue Mar 14, 2006 9:42 am

jclausius wrote:What type of plugins?


Vault server plugins. The kind that automatically gets called after each transaction.

I seem to recall you have to "register" the plugin, and it noted the url to the plugin webservice.

jclausius
Posts: 3702
Joined: Tue Dec 16, 2003 1:17 pm
Location: SourceGear
Contact:

Post by jclausius » Tue Mar 14, 2006 9:53 am

The only plugin written by SourceGear is Vault Shadow Folders. I mentioned them in the earlier post.

Also, you may want to look at the database's sgvault.dbo.tblplugins. If there are rows in the table that reference you're old host name for Shadow Folders, you may want to delete the row.

If there are other rows in this table, you may need to contact the author/vendor and ask them about a name change.
Jeff Clausius
SourceGear

ismangil
Posts: 197
Joined: Wed Jun 30, 2004 10:49 am
Location: Sheffield, UK
Contact:

Post by ismangil » Tue Mar 14, 2006 9:56 am

jclausius wrote:The only plugin written by SourceGear is Vault Shadow Folders. I mentioned them in the earlier post.

Also, you may want to look at the database's sgvault.dbo.tblplugins. If there are rows in the table that reference you're old host name for Shadow Folders, you may want to delete the row.

If there are other rows in this table, you may need to contact the author/vendor and ask them about a name change.
I am sorry for not making myself clear earlier in the post: the plugin is written by ourselves :D

I suppose I can just modify the url directly in tblplugins.

Locked