TSM BA client and SQL TDP behind the firewall, any ideals.

[deiow]

Hello Everyone

I'm having the same issue with TSM BA client and SQL TDP behind the firewall, any ideals.

Thinngs i've done and still not working for SQL TDP
1: register node and define HLA=10.10.10.1 LLA=1502
2: opt of file defined
TCPPORT 1500
TCPSERVERADDRESS 10.10.1.215
NODENAME MAN_SQL
TCPCLIENTADDRESS 10.10.10.1
TCPCLIENTPORT 1502
SCHEDMODE PROMPTED

3: Open the port 1500, 1502 Inbound and Outbound at firewall
4: Installed the TSM Scheduler

Thinngs of done and still not working for TSM BA
1: register node and define HLA=10.10.10.1 LLA=1501
2: opt of file defined
TCPPORT 1500
TCPSERVERADDRESS 10.10.1.215
NODENAME MAN_SQL
TCPCLIENTADDRESS 10.10.10.1
TCPCLIENTPORT 1501
SCHEDMODE PROMPTED
3: Open the port 1500, 1501, 1502 Inbound and Outbound at firewall
4: Installed the CAD TSM Scheduler

Have I miss anything, and when opening the port do we need TCP/IP and UDP protocol?

This is giving a headache.

 

[xaminmo]

TCPCLIENTPort doesn't work

For whatever reason, at least at 5.4, TCPCLIENTPort is ignored. In this Linux example, you'll see it picks ephemeral ports anyway.

It starts automagically below on login, but then when I define a client action, it fails to connect back to the client. I've got the ports open in iptables...

[root@CLIENT bin]# cat dsm.sys
SERVERNAME                      SERVER
TCPSERVERADDRESS                172.16.2.51
COMMmethod                      TCPIP
NODEName                        CLIENT
TCPPort                         1500
TCPCLIENTPort                   1502
SCHEDMODE                       PROMPTED
*SCHEDMODE                      POLLING
PasswordAccess                  Generate
(snip)

[root@SAPDVMBI bin]# ps auxww | grep dsm
root      5655  0.0  0.0  3884  148 pts/0    S    11:32   0:00 tail -f dsmwebcl.log
root      5703  0.0  0.0  3892  132 pts/0    S    11:50   0:00 tail -f dsmerror.log
root      5705  0.0  0.0  3892  128 pts/0    S    11:51   0:00 tail -f dsmsched.log
root      5865  0.0  1.7 45400 4568 ?        S    12:21   0:00 /opt/tivoli/tsm/client/ba/bin/dsmcad
root      5870  0.0  0.2  3684  668 pts/0    S    12:21   0:00 grep dsm

[root@CLIENT bin]# /opt/tivoli/tsm/client/ba/bin/dsmcad
[root@CLIENT bin]# 2007-07-23 12:21:14 (dsmcad) IBM Tivoli Storage Manager
2007-07-23 12:21:14 Client Acceptor - Built May 31 2007 12:19:44
2007-07-23 12:21:14 Version 5, Release 4, Level 1.0
2007-07-23 12:21:14 Dsmcad is working in   Webclient   Schedule   mode.
2007-07-23 12:21:14 ANS3000I HTTP communications available on port 1581.
2007-07-23 12:21:14 ANS3000I TCP/IP communications available on port 34472.
2007-07-23 12:21:14 Command will be executed
in 1 minute.
2007-07-23 12:21:14 Time remaining until execution:

2007-07-23 12:22:14 Scheduler has been started by Dsmcad.
2007-07-23 12:22:14 Querying server for next scheduled event.
2007-07-23 12:22:14 Node Name: CLIENT
Executing scheduled command now.
2007-07-23 12:22:19 Session established with server SERVER: Windows
2007-07-23 12:22:19   Server Version 5, Release 4, Level 0.3
2007-07-23 12:22:19   Server date/time: 2007-07-23 12:23:13  Last access: 2007-07-23 12:22:13

2007-07-23 12:22:19 --- SCHEDULEREC QUERY BEGIN
2007-07-23 12:22:23 --- SCHEDULEREC QUERY END
2007-07-23 12:22:23 Next operation scheduled:
2007-07-23 12:22:23 ------------------------------------------------------------
2007-07-23 12:22:23 Schedule Name:         @5
2007-07-23 12:22:23 Action:                Incremental
2007-07-23 12:22:23 Objects:
2007-07-23 12:22:23 Options:
2007-07-23 12:22:23 Server Window Start:   12:14:30 on 2007-07-23
2007-07-23 12:22:23 ------------------------------------------------------------
2007-07-23 12:22:23
Executing scheduled command now.
2007-07-23 12:22:23 --- SCHEDULEREC OBJECT BEGIN @5 2007-07-23 12:14:30
2007-07-23 12:22:24 Incremental backup of volume '/'
2007-07-23 12:22:24 Incremental backup of volume '/boot'
2007-07-23 12:22:24 Incremental backup of volume '/var/log'
2007-07-23 12:22:24 Incremental backup of volume '/vmfs'
2007-07-23 12:22:25 ANS1898I ***** Processed     9,000 files *****
2007-07-23 12:22:26 ANS1898I ***** Processed    25,000 files *****
(snip)

[root@CLIENT bin]# dsmadmc -id=admin -pa=admin q act begint=-00:01
2007-07-23 12:34:43      ANR2505I 1 schedules were defined for DEFINE CLIENTACTION. (SESSION: 12)
2007-07-23 12:35:02      ANR8213W Session open with 172.16.2.33 timed out. (SESSION: 15)

[root@SAPDVMBI bin]# iptables --list | grep 15
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1500 state NEW
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1581
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:15989
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1582
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:15988
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1583
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1501
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1500 state NEW
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1581
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1582
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1580
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1583
ACCEPT     tcp  --  anywhere             anywhere           tcp dpt:1501

 

[xaminmo]

Of course, I find the solution right after I post.

If you're using dsmcad, then TCPCLIENTPort is not used. TCPCLIENTPort is only used for "dsmc sched".

If you specify "WEBPorts 1502 1581" then it will set the equivalent for dsmcad.

 

[deviprasad.mk]

Iam also facing the same problem..with 64bit TSMBA client on windows xp 64bit running on EMT64

 

[deiow]

Will try this solution - define port number without dsmcad only use sched

Thanks,

Will try this stituation and update everyone.

1: remove the dsmcad scheduler
2: Install the dmsc sched and with port 1501 open (inbound and outbound)
3: define the HLL and LLA=1501

Of course, I find the solution right after I post.

If you're using dsmcad, then TCPCLIENTPort is not used. TCPCLIENTPort is only used for "dsmc sched".

If you specify "WEBPorts 1502 1581" then it will set the equivalent for dsmcad.

 

[deiow]

removing the dsmcad scheduler works

Removing the dsmcad scheduler works,

When I remove the dsmcad scheduler, by doing the steps below
1: remove the dsmcad scheduler
2: Install the dmsc sched and with port 1501 open (inbound and outbound)
3: define the HLL and LLA=1501[/quote]

Thanks for help on appreciated alot.

Deiow

Thanks,

Will try this stituation and update everyone.

1: remove the dsmcad scheduler
2: Install the dmsc sched and with port 1501 open (inbound and outbound)
3: define the HLL and LLA=1501