[ClusterLabs] Antw: SAPDatabase is not starting Sybase database

[Ulrich Windl]

Hi!

Your problem seems to be this:
"Database user authentication failed: No access to SecureStore or 
DB_CONNECT/SYB/SADB_USER or DB_CONNECT/SYB/SADB_PASSWORD is missing in 
SecureStore or password is incorrect. Provide credentials for user sapsa 
via command input or provide access to SecureStore. (fault code: 127) ]"

I suggest to use ocf-tester to debug the resource agent and configuration.

Regards,
Ulrich



>>> Muhammad Sharfuddin <M.Sharfuddin at nds.com.pk> schrieb am 16.09.2015 um 12:52 in
Nachricht <55F94A09.9000500 at nds.com.pk>:
> SLE 11 SP 3 + online updates, pacemaker version 1.1.11.x
> 
> SAP and Sybase manually starts smoothly but cluster fails to start the 
> Sybase database  with following errors:
> 
> Sep 16 14:23:53 KHIERP-PRD1 pengine[5885]:   notice: LogActions: Start   
> p_SAPDB        (KHIERP-PRD1)
> Sep 16 14:23:53 KHIERP-PRD1 pengine[5885]:   notice: process_pe_message: 
> Calculated Transition 7: /var/lib/pacemaker/pengine/pe-input-583.bz2
> Sep 16 14:23:53 KHIERP-PRD1 crmd[5886]:   notice: do_te_invoke: 
> Processing graph 7 (ref=pe_calc-dc-1442395433-81) derived from 
> /var/lib/pacemaker/pengine/pe-input-583.bz2
> Sep 16 14:23:53 KHIERP-PRD1 crmd[5886]:   notice: te_rsc_command: 
> Initiating action 19: start p_SAPDB_start_0 on KHIERP-PRD1 (local)
> Sep 16 14:23:53 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: WARNING: 
> saphostexec is not running on node KHIERP-PRD1, it will be started now
> Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: modified 
> /proc/sys/net/ipv4/ip_local_reserved_ports for SAP applications (SAP 
> note 401162)
> Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: modified 
> /proc/sys/net/ipv4/ip_local_port_range from 32768-61000 to 9000-65300
> Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of free ports: 39512
> Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of reserved ports: 
> 26024
> Sep 16 14:23:53 KHIERP-PRD1 saphostexec[8065]: number of reserved ports 
> within ip_local_port_range: 24767
> Sep 16 14:23:54 KHIERP-PRD1 SAPSAP_99[8072]: SAP Service SAPHostControl 
> successfully started.
> Sep 16 14:23:54 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:55 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:55 KHIERP-PRD1 su: (to erpadm) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: INFO: 
> saphostexec on node KHIERP-PRD1 was restarted !
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:58 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:23:59 KHIERP-PRD1 su: (to erpadm) root on none
> Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:01 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:01 KHIERP-PRD1 kernel: [ 1414.404685] Using mlock ulimits 
> for SHM_HUGETLB is deprecated
> Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:05 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:05 KHIERP-PRD1 su: (to erpadm) root on none
> Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:07 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:08 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:08 KHIERP-PRD1 su: (to erpadm) root on none
> Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:10 KHIERP-PRD1 su: (to syberp) root on none
> Sep 16 14:24:10 KHIERP-PRD1 su: (to erpadm) root on none
> Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: The 
> resource does not run any services which this RA could monitor!
> Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: The SAP 
> database ERP ist not running:
> Sep 16 14:24:13 KHIERP-PRD1 SAPDatabase(p_SAPDB)[8029]: ERROR: SAP 
> database ERP start failed:
> Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
> p_SAPDB_start_0:8029:stderr [ Error: Command execution failed. : 
> Database user authentication failed: No access to SecureStore or 
> DB_CONNECT/SYB/SADB_USER or DB_CONNECT/SYB/SADB_PASSWORD is missing in 
> SecureStore or password is incorrect. Provide credentials for user sapsa 
> via command input or provide access to SecureStore. (fault code: 127) ]
> Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
> p_SAPDB_start_0:8029:stderr [ Operation ID: 
> 0050568536081EE5978A95237846DD7F ]
> Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
> p_SAPDB_start_0:8029:stderr [  ]
> Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
> p_SAPDB_start_0:8029:stderr [  ]
> Sep 16 14:24:13 KHIERP-PRD1 lrmd[5883]:   notice: operation_finished: 
> p_SAPDB_start_0:8029:stderr [ Error: Database user authentication 
> failed: No access to SecureStore or DB_CONNECT/SYB/SADB_USER or 
> DB_CONNECT/SYB/SADB_PASSWORD is missing in SecureStore or password is 
> incorrect. Provide credentials for user sapsa via command input or 
> provide access to SecureStore. ]
> Sep 16 14:24:13 KHIERP-PRD1 crmd[5886]:   notice: process_lrm_event: LRM 
> operation p_SAPDB_start_0 (call=57, rc=1, cib-update=200, 
> confirmed=true) unknown error
> 
> here is the SAPDatabase configuration:
> 
> primitive p_SAPDB ocf:heartbeat:SAPDatabase \
>      op monitor interval="120" timeout="60" \
>      op start interval="0" timeout="1800" \
>      op stop interval="0" timeout="1800" \
>      params SID="ERP" DBTYPE="SYB"
> 
> 
> 
> 
> -- 
> Regards,
> 
> Muhammad Sharfuddin<http://www.nds.com.pk>