Sybase database backup script

[Former Member]

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

[Former Member]

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

[former_member188958]

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