Highlighted

Error (58) for SQL jobs (windows)

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

Tags (2)
16 Replies
Highlighted

Re: Error (58) for SQL jobs (windows)

Hi @robertoaxity

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

Is there a firewall active?

Highlighted

Re: Error (58) for SQL jobs (windows)

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.

Highlighted

Re: Error (58) for SQL jobs (windows)

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.

Highlighted

Re: Error (58) for SQL jobs (windows)

Hello,

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

Regards

Highlighted

Re: Error (58) for SQL jobs (windows)

@robertoaxity 

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

Review or upload bpcd log after the next failure. 

Highlighted

Re: Error (58) for SQL jobs (windows)

Hello @Marianne ,

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

Regards

Highlighted

Re: Error (58) for SQL jobs (windows)

I cannot open .log files on my mobile phone. I will have a look tomorrow on my laptop.
Highlighted

Re: Error (58) for SQL jobs (windows)

@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

Highlighted

Re: Error (58) for SQL jobs (windows)

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

Highlighted

Re: Error (58) for SQL jobs (windows)

Hello,

I run the job again, attach the log.

Thanks for your help

Regards.

Highlighted

Re: Error (58) for SQL jobs (windows)

 

Could you try

./bptestbpcd -verbose -debug -client 10.55.1.15    ?

Regards.

 

Highlighted

Re: Error (58) for SQL jobs (windows)

@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). 

Highlighted

Re: Error (58) for SQL jobs (windows)

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

Highlighted

Re: Error (58) for SQL jobs (windows)

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

Highlighted

Re: Error (58) for SQL jobs (windows)

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

Highlighted

Re: Error (58) for SQL jobs (windows)

@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