Using Sybase Failover in a High Availability System  Utility Guide

Release Bulletin Adaptive Server® Enterprise Version 12.5.2 for HP-UX

Configuring Adaptive Server resource groups

Step 2 of the section titled “Configuring Adaptive Server resource groups” in Chapter 11, “Active-Active Configuration for Sun Cluster 3.0” and in Chapter 12, “Active-Passive Configuration for Sun Cluster 3.0” is replaced with:

If you use another file at a different location, specify the full path for the resource extension property Dataserver_login_file when configuring the SY.ase resource. Create or edit a file that contains Adaptive Server login information for system administrator and the user you added for the fault monitor. The default file is $SYBASE/$SYBASE_ASE/SC-3_0/etc/ase_login_file.

The file consists of two lines; the first line is the login and password of the System Administrator, and the second line is the login and password of monitor_user. The fault monitoring program, ase_monitor, performs the thorough probe as user monitor_user.

login_type <tab> login string
login_type <tab> login_string

Valid values for login type are “encrypted” and “normal”. If you set login_type to “normal”, the value of the login_string is in the form “login_name/password”. If you set login_type to “encrypted”, the value of login_string is the encrypted string you get from the haisql utility (located in $SYBASE/$SYBASE_ASE/bin). Sybase recommends usage of “encrypted” login_type so the sensitive information in the file is well protected. To use haisql to generate the encrypted login string:

  1. Run haisql with no arguments to generate the encrypted string for a given login_name and password:

    /$SYBASE/ASE-12_5/bin/haisql
    Enter Username: sa
    Enter Password:
    TWAS8n1jSF2gBsvayUlw97861.cyTKaS1YhavBRQ2qKcJwtx.TmFBarGS2Kl553WDR7g8m5vrf86t@K4CU62HEccm4zkeexsP9E=FeuvX
    
  2. Copy and then paste the encrypted string to the ase_login_file file.

The following is an example of the ase_login_file using the “encrypted” login type:

encrypted
TWAS8n1jSF2gBsvayUlw97861.cyTKaS1YhavBRQ2qKcJwtx.TmFBarGS2Kl553WDR7g8m5vrf86t@K4CU62HEccm4zkeexsP9E=FeuvX
encrypted
rX2S8n1jSF2gBuD0q=AXEXKCZvzGcK5K3kWnp_P+e4avf=67kYVSzy7+h640@97FSP_dlkH_oV2Zima5+7tUyHnsm4zmSIHIUnKSTPoTD

The following is an example of the ase_login_file file using “normal” login type:

normal    sa/sa_password
normal     monitor_user/monitor_user_password

NoteThe two lines of the ase_login_file may use different login types.

You should protect the ase_login_file file with proper access permissions, particularly if you are not using the encrypted login strings. Perform the following to make the file readable only to the root user after editing the file with proper login_type and login_string values:

chmod 400 ase_login_file
chown root ase_login_file
chgrp sys ase_login_file




Copyright © 2004. Sybase Inc. All rights reserved. Utility Guide

View this release bulletin as PDF