problem enabling auditing in ASE

[darrenmackenzie]

The docs that I found on enabling auditing have been good
for the most part, but I'm stuck. The section says to do
this:

[...]
11. Add the additional audit tables:
sp_addaudittable auditdev2
go
sp_addaudittable auditdev3
go
12. Enable auditing:
sp_configure “auditing”,1
13. Display the current settings of all the auditing
options:
sp_displayaudit
go
14. Enable auditing options:
[...]

But when I get to steps 12/13, I get these errors:

1> sp_configure "auditing",1
2> sp_displayaudit
3> go
Msg 102, Level 15, State 1:
Server 'SYBASE', Line 2:
Incorrect syntax near 'sp_displayaudit'.
1> sp_configure "auditing",1
2> go
Msg 7628, Level 16, State 3:
Server 'SYBASE', Procedure 'sp_configure', Line 1054:
Invalid value for audit related configuration parameter
because the audit subsystem is not running. Verify that the
auditing subsystem is installed, then restart the server.
Msg 5849, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_configure', Line 1054:
Verification failed for parameter 'auditing'.
(return status = 1)
1>

What am I doing wrong? Thanks in advance...

[Neal Stack [Sybase]]

Hello,

Separate the two commands like this:
sp_configure "auditing",1
go
sp_displayaudit
go

Or prepend the commands with "exec":
1> exec sp_configure "auditing",1
2> exec sp_displayaudit
3> go

Regards,
Neal

[darrenmackenzie]

Thanks for the fast response. When I do it like that, it
tells me that the auditing subsystem is not running. What
did I miss enabling before running this:

1> sp_configure "auditing",1
2> go
Msg 7628, Level 16, State 3:
Server 'SYBASE', Procedure 'sp_configure', Line 1054:
Invalid value for audit related configuration parameter
because the audit
subsystem is not running. Verify that the auditing subsystem
is installed, then
restart the server.
Msg 5849, Level 16, State 1:
Server 'SYBASE', Procedure 'sp_configure', Line 1054:
Verification failed for parameter 'auditing'.
(return status = 1)

?

Thanks for the help.

[Mark A. Parsons]

After loading/running the installsecurity script, did you bounce the dataserver?

[darrenmackenzie]

> After loading/running the installsecurity script, did you
> bounce the dataserver?
>

No, let me try that. It wasn't in the docs I was using, but
I'm a Sybase novice, so somebody more familiar may have
known to do it. I'll try it and see if that lets me
continue...

[Mark A. Parsons]

FWIW, there's a whole chapter (Auditing) in the Admin Guide. One of the subsections covers the installation and setup
of auditing, and includes a section titled 'installing auditing with sybsecurity':

1 - create auditing devices and auditing database ...

2 - use isql to execute installsecurity ...

3 - shut down and restart ASE

[darrenmackenzie]

On attempting to restart it, I get this:

-bash-3.00$ cd /opt/sybase/ASE-15_0/install

-bash-3.00$ ./startserver .f RUN_SYBASE
-bash-3.00$ /opt/sybase/ASE-15_0/bin/dataserver: error while
loading shared libraries: libkonavm.so: cannot open shared
object file: No such file or directory

But the library is there, is it not in the library path by
default?

/opt/sybase/ASE-15_0/symlib/libkonavm.so
/opt/sybase/ASE-15_0/lib/libkonavm.so

I tried rebooting...same issue.

[Mark A. Parsons]

Ummmm ... did you source SYBASE.[c]sh in order to load your environment variables?