ejabberd - Comments for "SQL administrative scripts"

Yes

mfoss — Mon, 28 Dec 2009 11:23:37 +0000

Quote:

Also I noticed that table "last" contains less entries comparing to the table "users". Is this because users never logged in do not get an entry in "last"?

Yes, that's the reason.

ejabberdctl unregister works now :)

Roi — Mon, 28 Dec 2009 11:15:00 +0000

Ah... This works:

ejabberdctl unregister username jabberdomain.tld

:-)

But could please somebody tell me about the questions regarding the tables? Thanks! :-)

Some questions about inactive users and cmdline command

Roi — Mon, 28 Dec 2009 10:55:19 +0000

Hello all,

I'm thinking about reading the MySQL database to look for inactive users.

I want to check the table "last". Everything in seconds (unix timestamp) which is older than x days gets deleted.

Also I noticed that table "last" contains less entries comparing to the table "users". Is this because users never logged in do not get an entry in "last"?

After the list with inactive users is complete I want to run a cmdline command for every user to delete those users.

This command does not work:

ejabberdctl unregister username@jabberdomain.tld ejabberd@servername

Is this the right command?

Kindest regards,
Martin

Deleted 0 users

Roi — Thu, 19 Nov 2009 15:28:45 +0000

Too bad, did not work:

> ejabberdctl delete-older-users 365
> Deleted 0 users: []

Any ideas?

mod_ctlextra / mod_admin_extra and mod_cron

mfoss — Wed, 18 Nov 2009 22:03:00 +0000

> remove inactive users automaticly

mod_ctlextra/mod_admin_extra provide an ejabberdctl command to remove accounts that were unused in last X days. But I only tested it using internal auth. You can at least try it. If so, please comment if it works or not when using a different auth method.

Regarding periodic calling this command, you can either set a cron task, or use mod_cron.