Syndicate

Syndicate content

onaudit + onshowaudit Utility (How auditing is made in the IDS 11.5)

Submitted by karthik04 on Tue, 2009-09-22 08:49

Hi ,

I want to make use of the onaudit and onshowaudit utility in IDS 11.5 (Express Edition )

As I have configured the onaudit in the /home/informix/aaodir

O/P of onaudit -c
ADTMODE = 1
ADTERR = 0
ADTPATH = /home/production/audit_log
ADTSIZE = 5000000
Audit file = 0

When i try to run the new log audit file with the option
onaudit -n
Onaudit -- Audit Subsystem Configuration Utility
The directory name specified by the ADTPATH configuration parameter does not exist or does not have the necessary permissions.

what should be the file permission for /home/production/audit_log

And also could you Please give us the best link for knowing more about the onaudit & onshowaudit utility

As i want to audit every changes related the D/B that is table change forms change etc...how can be done?

Thanks
Karthik

‹ ** WARNING ** A level 0 archive of Root DBSpace will need to be done. Confusion about update statistics ›

Hi Karthik, Oddly enough, I

Submitted by Spokey on Tue, 2009-09-22 17:49.

Hi Karthik,

Oddly enough, I just got a very similar question from a chap called VJ. :-)

I guess from VJ's email that you don't have the correct permissions on /home/production/audit_log - they should be 770, if I remember correctly.

The Information Centre is the best place to find out more about onaudit and onshowaudit. Auditing changes to forms or 4GL source cannot be done using the Informix auditing commands, I would recommend doing this with a version control system, such as CVS or SCCS or one of the many other options.

There is a script here that can be customised to quickly create the database auditing you require. It also outlines a suggested list of things to audit.

Hi Spokey , Thanks for the

Submitted by karthik04 on Thu, 2009-09-24 08:32.

Hi Spokey ,

Thanks for the Valuable Information

Yes we are the TEAM of VJ,

WE have already assigned the permission 770 for the ADTPATH
that is ADTPATH = /home/production/audit_log

And we tried 770 now also and also checked with various file permissions But still it is showing the Same Error

The directory name specified by the ADTPATH configuration parameter does not exist or does not have the necessary permissions.

Could you Please let me know is any other reason for this error

Thanks & Regards
Karthik

Listing

Submitted by Spokey on Thu, 2009-09-24 12:51.

Can you post a file listing of the directory and the preceding directory?

ls -la /home/production/audit_log

ls -la /home/production

Hi Spokey Pls find the O/P

Submitted by karthik04 on Thu, 2009-09-24 13:33.

Hi Spokey

Pls find the O/P of the files

linux1:/ # ls -la /home/production/audit_log
-rwxrwx--- 1 informix informix 0 Sep24 :35 /home/production/audit_log

linux1:/home/production # ls -la /home/production
total 0
drwxrwx--- 2 informix informix 80 Sep 24 22:35 .
drwxr-xr-x 10 root root 272 Sep 24 22:35 ..
-rwxrwx--- 1 informix informix 0 Sep 24 22:35 audit_log

Thanks
karthik

That's your problem right there

Submitted by Spokey on Thu, 2009-09-24 14:31.

-rwxrwx--- 1 informix informix 0 Sep24 :35 /home/production/audit_log

/home/production/audit_log should be a directory, not a file.

Yes spokey You are right Now

Submitted by karthik04 on Thu, 2009-09-24 15:04.

Yes spokey You are right
Now it is Working now
Thaks a lot for your comments

Regards
Karthik