|
Home > Archive > SQL Anywhere for Linux > April 2005 > xp_cmdshell on Debian Sarge.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
xp_cmdshell on Debian Sarge.
|
|
| Hans Erik Büscher 2005-04-05, 8:03 pm |
| Hi.
Running a simple dbisql -c " uid=DBA;pwd=sql;eng=
Rx;dbn=REX" -q
"xp_cmdshell('ls -lrt /home/DATA/Sybase')" stops the database - nicely - but
it stops.
Error message from isql :
Line 1, column 1
Error! The connection to the database was closed by the server.
Error message from syslog:
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** REQUEST conn: 134583032
STMT_PREPARE "xp_cmdshell('ls -lrt /home/DATA/Sybase')"
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** DONE conn: 134583032
STMT_PREPARE Stmt=131107
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** REQUEST conn: 134583032
STMT_DESCRIBE_OUTPUT
Stmt=-1
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** DONE conn: 134583032
STMT_DESCRIBE_OUTPUT
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** REQUEST conn: 134583032
STMT_DESCRIBE_INPUT Stmt=-1
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** DONE conn: 134583032
STMT_DESCRIBE_INPUT
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** REQUEST conn: 134583032
STMT_EXECUTE Stmt=131107
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** DONE conn: 134583032
STMT_EXECUTE
Jan 30 11:40:11 localhost SQLAnywhere(rx): ** DONE conn: 134583032
STMT_EXECUTE
Jan 30 11:40:11 localhost SQLAnywhere(rx): Starting checkpoint of "REX"
(REX.db) at Sun Jan 30 2005 11:40
Jan 30 11:40:11 localhost SQLAnywhere(rx): Finished checkpoint of "REX"
(REX.db) at Sun Jan 30 2005 11:40
Jan 30 11:40:11 localhost SQLAnywhere(rx): Starting checkpoint of "REXREX"
(REXREX.db) at Sun Jan 30 2005 11:40
Jan 30 11:40:11 localhost SQLAnywhere(rx): Finished checkpoint of "REXREX"
(REXREX.db) at Sun Jan 30 2005 11:40
Jan 30 11:40:11 localhost SQLAnywhere(rx): Database server stopped at Sun
Jan 30 2005 11:40
Rights in directory /home/DATA/Sybase OK, xp_cmdshell not dropped. Database
runs fine (very) on Debian Woody. Any other operation than xp_cmdshell works
very fine.
Any suggestions to what this might be about ???
Regards
Hans Erik Büscher
| |
| Greg Fenton 2005-04-05, 8:03 pm |
| Hans Erik Büscher wrote:
>
> Running a simple dbisql -c " uid=DBA;pwd=sql;eng=
Rx;dbn=REX" -q
> "xp_cmdshell('ls -lrt /home/DATA/Sybase')" stops the database - nicely - but
> it stops.
>
What version and build number of ASA are you using (e.g. use the command
"dbeng9 -v" for ASA 9.x)
What kernel version are you running?
greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/
| |
| Hans Erik Büscher 2005-04-05, 8:03 pm |
| Sorry
It is Sybase : 9.0.0 (1120) & Deb 2.6.8-1-386
I just reinstalled Sybase this time WITH the JAVA-stuff - but it did'nt make
any difference.
§;>heb
"Greg Fenton" <greg. fenton_NOSPAM_@ianyw
here.com> skrev i en meddelelse
news:41fce228$1@foru
ms-1-dub...
> Hans Erik Büscher wrote:
but[color=darkred]
>
> What version and build number of ASA are you using (e.g. use the command
> "dbeng9 -v" for ASA 9.x)
>
> What kernel version are you running?
>
> greg.fenton
> --
> Greg Fenton
> Consultant, Solution Services, iAnywhere Solutions
> --------
> Visit the iAnywhere Solutions Developer Community
> Whitepapers, TechDocs, Downloads
> http://www.ianywhere.com/developer/
|
|
|
|
|