Moving ListManager with MSDE

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.

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

2. 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.

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

5. Proceed with the installation as prompted.

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

8. 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

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

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

11. Open a command prompt, and change to the ListManager directory. Run the following commands to retrieve the activation code for the new machine:

lm clearactivation

lm getactivation

12. Start ListManager and the ListManager web server.

13. 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

If this is the case for your installation, we recommend you contact Lyris tech support for assistance with the following steps:

1. Open the file C:\Program Files\ListManager\tclweb\bin\tclhttpd.rc with a plain-text editor such as Notepad.

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

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

4. Note the values for $sql_user and $sql_password.

5. Open a command prompt, and cd to C:\Program Files\Microsoft SQL Server\80\Tools\bin

6. Run the following command, replacing username and password with the values from lmcfg.txt:

osql -Uusername -Ppassword

7. Run the following update command, substituting the IP address in tclhttpd.rc for the IP address below:

update lyrConfigNodeSettings
set TclPortBindIp ="123.456.789.000"

8.   Start ListManager and the ListManager web server.

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

15. Go to Utilities: Administration: Sites, and edit any sites you have, so that the Internet Host Name field for each site is the name of your new ListManager machine. Also assign the IP addresses ListManager should use for SMTP and NNTP on each site.

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

You're done!