Migrating from the TL1 TSM

Migrating from the TL1 TSM entails converting the SERVERLOG information used by the TL1 TSM into a format that can be copied into the hosts file used by the TL1 Probe to connect to your TL1 devices.

To migrate from the TL1 TSM to the TL1 Probe, use the following steps:
  1. Backup the MySQL tsm database into a temporary file using the following command:

    ../tl1tsm/mysql/bin>./mysqldump tsm > tsm.sql

  2. Search through the resultant tsm.sql file for the code defining the SERVERLOG table and within that table, search for all entries containing a hostname entry.

    The following SQL content shows an example entry for defining the SERVERLOG table:

    INSERT INTO SERVERLOG VALUES (6,-1,'2010-10-14 09:50:28','root','\0\0+©éÕ¤ ´Ñð?¼Çck·',NULL,'NEManager','recreateAssociation',NULL, 'arg1=TL1TSMSNC,arg2=TL1PassThruNoLogin,arg3=null,arg4=telnet://portnumber=3083/hostname=9.127.97.246/, arg5=name=TL1TSMSNC,timeout=20,,arg6=null,arg7={OMNI_TL1TAD=tid=\'TL1TSMSNC\',gateway tid=\'null\',chatin string=\'.* ACT-USER:TL1TSMSNC:ADMIN:2::PASS; COMPLD\', chatout string=\'null\',wakeup string=\'RTRV-HDR:TL1TSMSNC::1; COMPLD\', wakeup attmpts=\'1\',wakeup intrvl=\'10\',heartbeat string=\'RTRV-HDR:TL1TSMSNC::1;\', heartbeat response=\'COMPLD\',heartbeat intrvl=\'300\', heartbeat timeout=\'330\',resync cmd=\'RTRV-SNCALM:TL1TSMSNC:ALL:3;\',resync intrvl=\'900\',login list=\'null\',logout list=\'null\'}',NULL);

    The part marked in bold typeface indicates the entry for connecting to a host.

  3. Convert this entry into the following format:

    <hostname> <portnumber>: "<name>","<chatin_string>" "<chatout_string>","<wakeup_string>" <wakeup_attempts> <wakeup__intrvl>, "<heartbeat_string>" "<heartbeat_response>" <heartbeat_intrvl> <heartbeat_timeout>, "<resync_cmd>" <resync_intrvl>;

    Note: Ignore the \' characters in the database log. If an entry is set to null, change this to "" for the entry in the hosts file.

    The following example shows how you would convert the example above into the required format:

    9.127.97.246 3083: "TL1TSMSNC",".* ACT-USER:TL1TSMSNC:ADMIN:2::PASS; COMPLD" "", "RTRV-HDR:TL1TSMSNC::1; COMPLD" 1 10,"RTRV-HDR:TL1TSMSNC::1;" "COMPLD" 300 330,"RTRV-SNCALM:TL1TSMSNC:ALL:3;" 900;

  4. Insert the resultant string into the hosts file specified by the HostsFile property.