Networker

[Networker] Unable to perform a scheduled backup using Sybase Module for NetWorker

2008-03-20 12:36:29
Subject: [Networker] Unable to perform a scheduled backup using Sybase Module for NetWorker
From: Shyam Hegde <hegde.shyam AT GMAIL DOT COM>
To: NETWORKER AT LISTSERV.TEMPLE DOT EDU
Date: Thu, 20 Mar 2008 22:02:39 +0530
Hello List,

Is there anybody using NetWorker Module for Sybase in environment mentioned
below please? Need your help!

NetWorker Server 7.4SP1 on AIX operating system (32-bit) version 5.3
NetWorker Storage Node/client 7.4 AIX operating system (32-bit) version 5.3
Sybase ASE server (32-bit) software version 15.0


When we run nsrsyb script with root logon or scheduled backup from backup
server GUI, it throws following error.

/usr/bin>nsrsyb3 -vvvv -U sybase -P sybase SYBASE:/CBSUATDB01/testdb
Backing up database testdb.
24146:nsrsybsv:Error from server CBSUATDB01_BS: Msg 412402, Level 2, State 1
        Backup Server: 4.124.2.1: Archive API error for device='bms::
cbssrv1.CBSUATDB01.testdb*../sybase/tmp/syQTan7a*::00': Vendor application
name=EMC, Library version=200, API routine=syb_open(), Message=unable to
create environment variables.

24146:nsrsybsv:Error from server CBSUATDB01: Msg 8009, Level 16, State 1
        Error encountered by Backup Server.  Please refer to Backup Server
messages for details.
24115:nsrsybsv:Error: unable to dump database testdb in instance CBSUATDB01.
nsrsybsv returned status of 1
/usr/bin/nsrsyb3 exiting.
/usr/bin>

Here, when we run savegrp, it calls nsrsyb script as root logon. The Sybase
ASE is running with sybase user logon.
When I further investigated, the temporary file nsrsyb script creates (to
transfer variable to ASE) on path mentioned in NSR_TEMPDIRE variable
(/sybase/tmp in this case which has 777) has permissions -rw------- that
means no other user i.e. sybase user in whose logon Sybase ASE is running is
able to read, hence the backup fails to complete.

To support the above threory, when I ran nsrsyb script as sybase user,
backup completes with error. When I run nsrsyb script with sybase user
logon, the temp file is created and read by the same user ID and hence no
permission issue.

Setting the umask to 022 and 002 also did not help.

If nsrsybsv can create the temp file which has read permission for other
users, it solves the problem. But so far I could not find a way.

Thanks in advance !

Shyam

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER

<Prev in Thread] Current Thread [Next in Thread>