cancel
Showing results for 
Search instead for 
Did you mean: 

Error (58) for SQL jobs (windows)

robertoaxity
Moderator
Moderator
   VIP   

Hello,

I have the next error, when i execute SQL job:

22-06-2020 12:07:35 - Info bpbrm (pid=266826) connect failed STATUS (18) CONNECT_FAILED
22-06-2020 12:07:35 - Info bpbrm (pid=266826)  status: FAILED, (10) SOCKET_FAILED; system: (113) No route to host; FROM 0.0.0.0 TO 16kprvsccm01 10.0.1.132 bpcd VIA pbx
22-06-2020 12:07:35 - Info bpbrm (pid=266826)  status: FAILED, (10) SOCKET_FAILED; system: (113) No route to host; FROM 0.0.0.0 TO 16kprvsccm01 10.0.1.132 bpcd VIA vnetd
22-06-2020 12:07:35 - Error bpbrm (pid=266826) cannot connect to 16kprvsccm01, Transport endpoint is not connected (107)

Info bpbkar (pid=0) done. status: 58: can't connect to client

 

The client is a windows 2016, the /etc/host have a master and media server netbackup, the services are running, i have ping from client to master and master to client.

i use the command ./bptestbpcd -verbose -debug -client 16kprvsccm01 in the master, and the result is 

13:02:52.835 [25135] <2> vnet_connect_to_vnetd_bpcd: js_bpcd_info: 0x15850a0
13:02:52.839 [25135] <2> vnet_pbxConnect_ex: pbxConnectExEx Succeeded
13:02:52.948 [25135] <8> do_pbx_service: [vnet_connect.c:2581] via PBX
13:02:52.949 [25135] <8> vnet_vnetd_connect_forward_socket_begin: [vnet_vnetd.c: 458] VN_REQUEST_CONNECT_FORWARD_SOCKET 10 0xa
13:02:52.962 [25135] <8> vnet_vnetd_connect_forward_socket_begin: [vnet_vnetd.c: 483] ipc_string 63463
127.0.0.1:36525 -> 127.0.0.1:39027 PROXY 10.55.0.9:35122 -> 10.55.1.15:1556
<2>bptestbpcd: EXIT status = 0
13:02:52.983 [25135] <2> bptestbpcd: EXIT status =0

Can you help me?

Regards

16 REPLIES 16

Thiago_Ribeiro
Moderator
Moderator
Partner    VIP    Accredited

Hi @robertoaxity

Have you checked and confirmed tcp/ip connectivity (ping, nslookup, telnet) ?

Is there a firewall active?

robertoaxity
Moderator
Moderator
   VIP   

Hello,

From Master Server:

[root@lprvnetbkp01 ~]# ping 16kprvsccm01
PING 16KPRVSCCM01.derco.cl (10.55.1.15) 56(84) bytes of data.
64 bytes from 16KPRVSCCM01.derco.cl (10.55.1.15): icmp_seq=1 ttl=128 time=0.325 ms
64 bytes from 16KPRVSCCM01.derco.cl (10.55.1.15): icmp_seq=2 ttl=128 time=0.359 ms

[root@lprvnetbkp01 ~]# nslookup 16kprvsccm01
Server: 10.55.0.75
Address: 10.55.0.75#53

Name: 16kprvsccm01
Address: 10.55.1.15

[root@lprvnetbkp01 ~]# telnet 10.55.1.15 1556
Trying 10.55.1.15...
Connected to 10.55.1.15.
Escape character is '^]'.

 

From Client:

C:\Users\svc_sccm_admin>ping lprvnetbkp01

Pinging lprvnetbkp01.derco.cl [10.55.0.9] with 32 bytes of data:
Reply from 10.55.0.9: bytes=32 time<1ms TTL=63
Reply from 10.55.0.9: bytes=32 time<1ms TTL=63

C:\Users\svc_sccm_admin>nslookup lprvnetbkp01
Server: 12kprvdc05
Address: 10.55.0.75

Name: lprvnetbkp01
Address: 10.55.0.9


C:\Users\svc_sccm_admin>hostname
16KPRVSCCM01

firewall is off, but have symantec endpoint protection ON, so i need to validate with the administrator if possible turn dow or allow access for master server ( what rule need)?

thanks 

please continue to help me

Regards.

Tape_Archived
Moderator
Moderator
   VIP   

status: FAILED, (10) SOCKET_FAILED; system: (113) No route to host; FROM 0.0.0.0 TO 16kprvsccm01 10.0.1.132 bpcd VIA pbx

Error Status code is 18 and for that recommendation is - Check the NetBackup Problems report for clues on why the failure occurred.

Looks like master server is trying to use different interface to connect to the client, can you please check if there is an interface which is up though its not suppose to be up. Something is wrong with Network interface here.

robertoaxity
Moderator
Moderator
   VIP   

Hello,

I see the master server and have 2 ethernet, which is correct, and the rest client sql, vmw, etc are work fine.

Regards

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@robertoaxity 

Please ensure that bpcd log folder exists on the SQL client. 

Review or upload bpcd log after the next failure. 

robertoaxity
Moderator
Moderator
   VIP   

Hello @Marianne ,

I execute the job sql manually and attached the log result.

Regards

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified
I cannot open .log files on my mobile phone. I will have a look tomorrow on my laptop.

robertoaxity
Moderator
Moderator
   VIP   

@Marianne Thanks, i be waiting, but i post the log to.

10:44:23.700 [1676.9260] <2> setup_debug_log: switched debug log file for bpcd
10:44:23.700 [1676.9260] <4> bpcd main: VERBOSE=0, BPCD VERBOSE=0
10:44:23.716 [1676.9260] <2> logparams: C:\Program Files\Veritas\NetBackup\bin\bpcd.exe -standalone
10:44:23.716 [1676.9260] <2> init_nbcurllib: Performing nbopenssl_init() before initGlobalCurl()
10:44:23.716 [1676.9260] <4> NBClientCURL::initGlobalCurl: Performing NB_curl_global_init() ONLY ONCE per process
10:44:23.716 [1676.9260] <2> CrankUpNTPrivs: About to EnablePrivilege(SeBackupPrivilege)
10:44:23.716 [1676.9260] <2> CrankUpNTPrivs: About to EnablePrivilege(SeDebugPrivilege)
10:44:23.716 [1676.9260] <2> CrankUpNTPrivs: About to EnablePrivilege(SeRestorePrivilege)
10:44:23.716 [1676.9260] <2> CrankUpNTPrivs: About to EnablePrivilege(SeSecurityPrivilege)
10:44:23.716 [1676.9260] <2> CrankUpNTPrivs: About to EnablePrivilege(SeTakeOwnershipPrivilege)
10:44:23.716 [1676.9260] <2> CrankUpNTPrivs: About to EnablePrivilege(SeTcbPrivilege)
10:44:23.716 [1676.9260] <2> setup_debug_log: switching debug log file for bpcd
10:44:23.716 [1676.9260] <2> setup_debug_log: switched debug log file for bpcd
10:44:23.732 [1676.9260] <2> daemon_startup_listeners_ex: 4 listening for legacy service bpcd
10:44:23.747 [1676.9260] <2> daemon_startup_listeners_ex: listening for vnetd service bpcd
10:44:23.747 [1676.9260] <2> vnet_registerPBXServer: ../../libvlibs/vnet_pbx.c.122: pbxRegisterExEx successful at 10.55.1.15:5126/bpcd, returns with 2 alt_addrs
10:44:23.747 [1676.9260] <2> vnet_registerPBXServer: ../../libvlibs/vnet_pbx.c.134: alt_addr: 169.254.224.68:5126
10:44:23.747 [1676.9260] <2> vnet_registerPBXServer: ../../libvlibs/vnet_pbx.c.134: alt_addr: 0.0.0.0:1556
10:44:23.747 [1676.9260] <2> bpcd main: Daily log cleanup will be delayed by 1120 seconds
10:44:23.763 [1676.9260] <2> bpcd main: Skipping USE_AUTHENTICATION refresh, host is not a media server
10:44:23.763 [1676.9260] <2> getServersFromMapInfo: Successfully read all servers.
10:44:23.779 [1676.9260] <2> bpcd main: Fired HostDB update after bpcd start
10:44:23.779 [1676.9260] <2> bpcd main: executing nbcertcmd -getAllCRL to get CRL for all domains
10:44:23.794 [1676.9260] <2> executeCommand: Created C:\Program Files\Veritas\NetBackup\bin\nbcertcmd.exe (pid=7436)
10:44:23.794 [1676.9260] <2> executeCommand: Created C:\Program Files\Veritas\NetBackup\bin\nbcertcmd.exe (pid=6444)
10:44:23.794 [1676.9260] <2> bpcd main: Starting bpclntcmd, machine certificates will be renewed if required
10:44:23.794 [1676.9260] <2> renew_machine_creds_ifneeded: Created bpclntcmd (pid=4072)
10:44:23.794 [1676.9260] <2> bpcd main: Checking if hostID based machine certificates needed renew
10:44:23.794 [1676.9260] <2> renew_host_creds_for_each_master_ifneeded: Reading host config failed with error=227, Marking auto_renew_disable=0
10:44:23.794 [1676.9260] <2> renew_host_creds_for_each_master_ifneeded: Calling renew for host certificate
10:44:23.794 [1676.9260] <2> getServersFromMapInfo: Successfully read all servers.
10:44:23.919 [1676.9260] <2> renew_host_certificate: Found certificate for the host. Checking if renewal is required...
10:44:23.919 [1676.9260] <8> vnet_vxss_check_if_certificate_renewal_is_required: [vnet_vxss_helper.c:2735] Certificate is good, no need to renew it 0 0x0
10:44:23.919 [1676.9260] <2> doGetCertMapInfo: Entering
10:44:23.919 [1676.9260] <2> doGetCertMapInfo: Using default path
10:44:23.919 [1676.9260] <2> doGetCertMapInfo: Checking if server entry is present for server lprvnetbkp01
10:44:23.919 [1676.9260] <2> executeCommand: Created C:\Program Files\Veritas\NetBackup\bin\nbcertcmd.exe (pid=11548)

Thanks for your help

Regards

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@robertoaxity 

What time did you attempt the backup?
There is no evidence in the log of any connection attempt from a master or media server in the 1-second log. 

We need to see what happens on the client during a connection attempt. 

robertoaxity
Moderator
Moderator
   VIP   

Hello,

I run the job again, attach the log.

Thanks for your help

Regards.

MustafaAogluGT
Level 3

 

Could you try

./bptestbpcd -verbose -debug -client 10.55.1.15    ?

Regards.

 

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@robertoaxity 

The client is resolving incoming server IP address to hostname lprvnetbkp01 - all lowercase.

There is no Server entry for this hostname on the client.

01:44:39.008 [1676.9260] <2> doGetCertMapInfo: Checking if server entry is present for server lprvnetbkp01
02:44:40.460 [1676.9260] <2> bpcd main: Skipping USE_AUTHENTICATION refresh, host is not a media server

Please add Server entry for lprvnetbkp01 in the client's Host Properties (or registry). 

robertoaxity
Moderator
Moderator
   VIP   

I have the file modified since before the creation of the policies and job executions

Netbackup 

10.55.0.9 lprvnetbkp01.x.cl lprvnetbkp01
10.55.0.54 lprpmedia01.x.cl lprpmedia01
10.55.0.133 lprpmedialevel01.x.cl lprpmedialevel01
10.55.0.3 lprpaplnetbk.x.cl lprpaplnetbk

Well i see the sql instance configuration and policy and the client is "16kprvsccm01" so i changed to "16kprvsccm01.x.cl", and execute the job again, buu fail and now the error is (59)


Request from host lprpaplnetbk.x.cl (10.55.0.3) to host 16KPRVSCCM01.x.cl (10.55.1.15) is not allowed access. Host lprpaplnetbk.x.cl (10.55.0.3) is not an authorized server for host 16kprvsccm01.x.cl.

I see the file host in master and aplnetbk and both have entry for the client 16kprvsccm01.x.cl

Regards

robertoaxity
Moderator
Moderator
   VIP   

Hello, i try post for 4 time and dont refresh my comment,

So i changed the sql client instance and client in policy the 16kprvsccm01 to 16kprvsccm01.yyy.cl, and execute again the job, now the error is (59)

Request from host lprpaplnetbk.yyy.cl (10.55.0.3) to host 16KPRVSCCM01.yyy.cl (10.55.1.15) is not allowed access. Host lprpaplnetbk.yyy.cl (10.55.0.3) is not an authorized server for host 16kprvsccm01.yyy.cl

The master and aplnet have entry for 16kprvsccm01.yyy.cl in the file.

can continue help me please.

Regards

Marianne
Moderator
Moderator
Partner    VIP    Accredited Certified

@robertoaxity 

I don't know how else to explain.
You need to check the client's NetBackup Host Properties.
I guess Host Properties on the master server will not work because of missing/incorrect Server settings on the client.

You will need to do this on the client - either use the BAR GUI or edit the registry. 

Check the 'Server' entries on the client - you need to ensure that the entries here matches OS-level IP -> hostname resolution. 

robertoaxity
Moderator
Moderator
   VIP   

@Marianne 

I check the host file in the master, media and client, and i see all is correct.

In registry the client appears "lprnetbkp01" that is the master server.

Now i will check the bp.conf in master and media.

Regards