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 <[email protected]> schrieb am 16.09.2015 um >>> 12:52 in Nachricht <[email protected]>: > 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> _______________________________________________ Users mailing list: [email protected] http://clusterlabs.org/mailman/listinfo/users Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
