Skip to Content
0

Sybase database backup script

Jul 01, 2017 at 10:43 AM

104

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

Bret Halford
Jul 02, 2017 at 07:45 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
islam Shaikh Jul 05, 2017 at 07:17 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded