Up to Discussions in Openfire Support

This Question is Answered

2 "helpful" answers available (5 pts)
4 Replies Last post: Apr 9, 2008 4:53 PM by Jason L  
Jason L Silver
Jason L
219 posts since
May 2, 2007
Currently Being Moderated

Apr 9, 2008 1:31 PM

Enable Security Audit Logs?

 

I am testing 3.5 and I know one of the features is to enable security logs for the admin interface and I can go to the security audit log viewer, but nothing is there.  And I can't seem to find where I need to go to enable this.

 

 

 

TIA for help

 

 

Daniel Henninger Jiver
Daniel Henninger
2,933 posts since
Aug 10, 2005
Currently Being Moderated
Apr 9, 2008 3:25 PM in response to: Jason L
Re: Enable Security Audit Logs?

They're activated by default (in fact you can't really turn them off)  Did you perform an action in the admin console?  Log events are when admin actions are performed, like changing server settings.  If you did try changing something and it still didn't trigger something in the security audit log, check your various logs to see if there's anything bring thrown when you try to change settings.

Report Abuse
Jason L Silver
Jason L
219 posts since
May 2, 2007
Currently Being Moderated
Apr 9, 2008 3:54 PM in response to: Daniel Henninger
Re: Enable Security Audit Logs?

 

I did change some things and nothing registered.  I didn't think to look in the logs.  this was in my error.log:

 

 

2008.04.09 16:51:12 org.jivesoftware.openfire.security.DefaultSecurityAuditProvider.getEvents(Defaul tSecurityAuditProvider.java:144)

com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Table 'openfire.jiveSecurityAuditLog' doesn't exist

 

 

 

 

I upgraded this from 3.3.1 to 3.5 and everything else seems to work (besides sparkweb ssl )

 

 

Report Abuse
Daniel Henninger Jiver
Daniel Henninger
2,933 posts since
Aug 10, 2005
Currently Being Moderated
Apr 9, 2008 4:46 PM in response to: Jason L
Re: Enable Security Audit Logs?

Sounds like you didn't get one of the DB upgrades.  I'm guessing that upgrade 14 failed.  Look in your install directory/resources/database/upgrade/14 and open openfire_mysql.sql  change the ALTER TABLE ... ALTER COLUMN ...  line to be ALTER TABLE .... CHANGE COLUMN ... and then restart openfire.

Report Abuse
Jason L Silver
Jason L
219 posts since
May 2, 2007
Currently Being Moderated
Apr 9, 2008 4:57 PM in response to: Daniel Henninger
Re: Enable Security Audit Logs?

that did it, thanks.  now if I could only get my sparkweb ssl problem resolved

Report Abuse

More Like This

  • Retrieving data ...