Removing individual logs on iBall Auditor

Openfire Openfire Support
1

Hi,

Does anyone know how to remove per user logs? Or know where it reads the logs from?

Ta

Dan

2

daniel_uk

What kind of database are you using? I use MySQL. I don’‘t see the option in the admin cole to delete the user chat log so I just issued SQL command in MySQL to delete the log. I don’'t know how to delete the log if the database is the embeded one that came with WildFire.

Regards,

wmhtet

3

Hi wmhtet,

the embedded database is much more easy to edit, a text editor is fine. It stores the SQL statements which are needed to create the database tables and the content as plain SQL text. Of course Wifi should not be running while editing the text file, and deleting the wrong lines will likely lead to missing users, rosters, groups, …

It looks like this:

…

CREATE MEMORY TABLE JIVEID(IDTYPE INTEGER NOT NULL,ID BIGINT NOT NULL,CONSTRAINT JIVEID_PK PRIMARY KEY(IDTYPE))

…

INSERT INTO JIVEOFFLINE VALUES(’‘test56’’,34479,’‘001140009881935’’,170,’’’’)

…

LG

4

Thanks LG

wmhtet