Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

xp_cmdshell shuts down database server

2 posts in General Discussion Last posting was on 2004-09-10 20:28:42.0Z
Brett Posted on 2004-09-10 15:18:51.0Z
Sender: 40db.4141c520.1804289383@sybase.com
From: Brett
Newsgroups: ianywhere.public.general
Subject: xp_cmdshell shuts down database server
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4141c5db.40e1.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Sep 2004 08:18:51 -0700
X-Trace: forums-1-dub 1094829531 10.22.241.41 (10 Sep 2004 08:18:51 -0700)
X-Original-Trace: 10 Sep 2004 08:18:51 -0700, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3514
Article PK: 7414

I'm writing a page using PHP, HTML, and ASA 9.0.1 in Linux.
In my php code I make a call to xp_cmdshell('touch
$dlDir$docName') where $dlDir is the directory to be written
and $docName is the filename to use. This command gets
executed no problem and the file is created, but at that
point my database server shuts down and I have to restart
it. Any idea what's going on here? Thanks.


Greg Fenton Posted on 2004-09-10 20:28:42.0Z
From: Greg Fenton <greg.fenton_NOSPAM_@ianywhere.com>
Organization: iAnywhere Solutions Inc.
User-Agent: Mozilla Thunderbird 1.6.3.2f (Windows/20040803)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: ianywhere.public.general
Subject: Re: xp_cmdshell shuts down database server
References: <4141c5db.40e1.1681692777@sybase.com>
In-Reply-To: <4141c5db.40e1.1681692777@sybase.com>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: gfenton-xp.sybase.com
Message-ID: <41421022$1@forums-2-dub>
X-Original-Trace: 10 Sep 2004 13:35:46 -0700, gfenton-xp.sybase.com
Lines: 26
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 10 Sep 2004 13:17:01 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 10 Sep 2004 13:28:42 -0700
X-Trace: forums-1-dub 1094848122 10.22.108.75 (10 Sep 2004 13:28:42 -0700)
X-Original-Trace: 10 Sep 2004 13:28:42 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:3517
Article PK: 7417


Brett wrote:
> This command gets
> executed no problem and the file is created, but at that
> point my database server shuts down and I have to restart
> it. Any idea what's going on here?

Questions about ASA on Linux are better handled in the newsgroup:

sybase.public.sqlanywhere.linux

Which distro of "Linux" are you running on?
Which kernel and glibc version?
What is your command-line for starting the database engine?

Is there any error message logged in either your engine console
(assuming you started the engine with "-o /full/path/to/console.log") or
in your syslogd file (typically /var/log/messages) ?

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/