Skip to Content
avatar image
Former Member

Sybase database backup script

Hi,

We have multiple server with SAP ERP ECC 6.0 EHP 7 SP13 , where we have made script for taking backup. Backup script is working for SAP server which has sybase ASE version 16.0.01.01 but same script is not working for server which has ASE version 16.0.02.05. Please find the script and error message. Please help me out to resolve the issues.

Backup Script
#/usr/ksh!
passwd=PRD#4321
dt=`date +"%d-%m-%Y"`
cd /dbbackup
su - sybprd -c "isql64 -Usapsa -SPRD -P$passwd -X" << EOF
dump database PRD to "/dbbackup/dbbk$dt.dmp" with compression = 101
go
EOF

Error message
[root@mtprod scripts]# ./BkpDailyDBOnline.sh
Msg 1640, Level 16, State 2:
Server 'PRD':
Adaptive Server requires encryption of the login password on the network.
Msg 4002, Level 14, State 1:
Server 'PRD':
Login failed.
CT-LIBRARY error:
ct_connect(): protocol specific layer: external error: The attempt to connect to the server failed.

Thanks & Regards,

Islam Shaikh

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jul 02, 2017 at 07:45 PM

    I don't see anything obviously wrong with the script.
    The behavior, though, suggests that isql64 isn't seeing the -X parameter and so isn't sending an encrypted
    password. Perhaps passing the password through a variable is interfering somehow? I'd try moving
    the -X parameter ahead of the -P to see if that makes any difference.

    -bret

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 05, 2017 at 07:17 AM

    Dear Bret Halford,

    Thanks for your suggestion i have already tried that but it did not work. I am still confused and not able to resolve the issues. I forgot to mentioned OS which we are using which is Red Hat Enterprise Linux Server release 7.3 (Maipo) . I am suspecting that there may be new feature introduced in ASE version 16.0.02.05 which may not allowing the script to login in to the server. Not sure !!!

    ~Islam

    Add comment
    10|10000 characters needed characters exceeded