Moving ListManager: Windows (with MSDE)

For best results, upgrade and move ListManager in two stages:

1. Upgrade to the current version on the old machine.

2. Follow the instructions below to move that ListManager installation to the new machine.

IMPORTANT Back up your database before moving.

1. Shut down ListManager on the old machine.

2. You need to know the name of this ListManager machine as it is configured in your database.

a. Open the file lmcfg.txt (located in C:\Program Files\ListManager using a plain-text editor such as Notepad.

b. Note the value of $node_name.

3. Use the service manager to stop MSDE.
 

4. Copy the following files to another location:
 

C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Data.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Log.LDF

5. On the new machine, download the installer. Start the installer by double clicking on the installer icon.

6. When prompted by the installer to specify the type of installation, select "New Install".

7. Proceed with the installation as prompted.

8. Shut down ListManager if you started it after the installation.

9. Replace the following files with their equivalents from the old machine:
 

C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Data.MDF
C:\Program Files\Microsoft SQL Server\MSSQL\Data\ListManager_Log.LDF

10. Open a command prompt, and change to the ListManager directory.

11. Open the file lmcfg.txt (located in C:\Program Files\ListManager) using a plain-text editor such as Notepad.

12. Edit the value of $node_name to be what it was for your old installation.

13. Open a command prompt, and change to the ListManager directory.

14. Run the following commands to retrieve the activation code for the new machine:

lm clearactivation

lm getactivation

15. Start ListManager and the ListManager web server.

16. Depending on your settings for your previous installation, the ListManager web server may not be able to communicate with ListManager on localhost (127.0.0.1), preventing it from running. If running ListManager from the command prompt, you will see a message like this one:

Error: unable to listen to: TCP/IP address: 192.168.0.5, port number: 2021

a. Open the file ~listmanager/tclweb/bin/tclhttpd.rc with a plain-text editor such as notepad.

b. Note the IP address being used in Config ipaddr.

c. Open a command prompt, and run the following command, specifying the IP address from tclhttpd.rc for the IP address:

lm tclportbindip ip_address

d. Start ListManager and the ListManager web server.

17. Log into the ListManager web interface as a server administrator.

18. Go to Utilities: Administration: Sites, and edit any sites for this node (or all sites if you are not on a clustered environment). Change the "Internet Host Name" and the "URL to web interface" (unless your webserver resides on a different machine) fields for each site to point to the name of your new ListManager machine. Then on the SMTP tab, change the "Incoming SMTP IP address" and "Outgoing SMTP IP address" to either "(all)" or the IP addresse of your current machine. Make the same change on the NNTP tab to the"NNTP IP address" field. Finally, if you have ClickTracks integration, hit the "Change" button next to the "Connection String" field on the ClickTracks tab to update the URL there.

19. Go to Utilities: Administration: Server: Server Settings: Machine Settings: IP Addresses, and specify what IP addresses ListManager should bind to for DNS lookups.