Process-one
ejabberd
ejabberd@conference.process-one.net
Sunday, January 13, 2019< ^ >
zinid has set the subject to: ejabberd discussions: https://docs.ejabberd.im
Room Configuration
Room Occupants

GMT+0
[00:01:11] erik joins the room
[00:02:27] fp leaves the room
[00:02:58] fp joins the room
[00:03:12] fp leaves the room
[00:08:30] 404 joins the room
[00:15:22] beri leaves the room
[00:37:45] Odin leaves the room
[00:37:47] Odin joins the room
[00:47:43] rom1dep leaves the room
[00:51:00] ave leaves the room: Machine is going to sleep
[00:55:49] edhelas leaves the room: Connection failed: connection closed
[00:58:00] debalance leaves the room
[00:58:04] edhelas joins the room
[01:02:45] Odin leaves the room
[01:05:48] rom1dep joins the room
[01:08:50] maddl joins the room
[01:15:44] debalance leaves the room
[01:20:49] debalance joins the room
[01:21:00] ChaosKid42 leaves the room
[01:23:30] jonny leaves the room
[01:23:51] jonny joins the room
[01:33:01] alexis joins the room
[01:33:11] shara joins the room
[01:34:52] alexis leaves the room
[01:35:19] alexis joins the room
[01:37:24] deavmi leaves the room
[01:38:27] jannic leaves the room
[01:38:39] jannic joins the room
[01:45:01] deavmi joins the room
[01:46:10] alexis leaves the room
[01:47:07] alexis joins the room
[01:47:53] Odin joins the room
[01:49:09] ulrich leaves the room
[01:49:10] ulrich joins the room
[01:49:51] cippaciong leaves the room
[01:51:29] Odin leaves the room
[01:52:48] Odin joins the room
[01:53:29] Odin leaves the room
[01:53:52] Odin joins the room
[01:53:58] lorddavidiii leaves the room
[01:54:05] lorddavidiii joins the room
[01:54:28] lorddavidiii leaves the room
[01:54:46] lorddavidiii joins the room
[01:58:04] alexis leaves the room
[01:58:29] alexis joins the room
[01:59:27] Odin leaves the room
[02:02:48] Odin joins the room
[02:03:37] mrDoctorWho joins the room
[02:11:55] alexis leaves the room
[02:12:20] alexis joins the room
[02:17:31] debalance leaves the room
[02:17:34] debalance joins the room
[02:17:53] Alacer joins the room
[02:18:09] debalance leaves the room
[02:19:18] alexis leaves the room
[02:19:44] alexis joins the room
[02:21:44] ThUnD3r|Gr33n© joins the room
[02:29:49] maddl leaves the room
[02:33:19] debalance joins the room
[02:35:05] mrDoctorWho leaves the room
[02:35:24] mrDoctorWho joins the room
[02:35:53] Alacer leaves the room
[02:35:54] Alacer joins the room
[02:41:46] rincewind joins the room
[02:44:24] jonny leaves the room
[02:45:05] jonny joins the room
[02:46:59] Alacer leaves the room
[02:47:10] debalance leaves the room
[02:48:49] alexis leaves the room
[02:51:19] Alacer joins the room
[02:56:47] chrys leaves the room: Disconnected: Replaced by new connection
[02:56:47] chrys joins the room
[02:58:31] jonny leaves the room
[03:00:05] jonny joins the room
[03:09:07] Alacer leaves the room
[03:10:04] debalance joins the room
[03:13:01] VC leaves the room
[03:13:02] VC joins the room
[03:13:06] mozart leaves the room
[03:18:33] rom1dep leaves the room
[03:19:30] mozart joins the room
[03:21:24] sezuan leaves the room
[03:27:21] doctor leaves the room
[03:41:02] Alacer joins the room
[03:41:19] Alacer leaves the room
[03:41:21] Alacer joins the room
[03:46:48] beri joins the room
[03:51:32] ulrich leaves the room
[04:26:27] Alacer leaves the room
[04:28:15] Alacer joins the room
[04:28:17] rom1dep joins the room
[04:42:05] alexis joins the room
[04:44:13] alexis leaves the room
[04:44:50] alexis joins the room
[04:51:15] integrationsfigur joins the room
[04:59:04] alexis leaves the room
[04:59:29] alexis joins the room
[05:06:39] debalance leaves the room
[05:18:20] pod joins the room
[05:19:32] Neustradamus joins the room
[05:22:17] debalance joins the room
[05:23:18] mrDoctorWho leaves the room
[05:31:05] pod joins the room
[05:33:51] ChaosKid42 joins the room
[05:34:58] alexis leaves the room
[05:35:23] alexis joins the room
[05:35:48] Neustradamus leaves the room
[05:42:53] alexis leaves the room
[05:44:14] alexis joins the room
[05:45:32] rincewind leaves the room
[05:46:42] Sergio joins the room
[05:51:18] alexis leaves the room
[05:51:54] alexis joins the room
[05:52:09] Alacer leaves the room
[05:59:37] Alacer joins the room
[06:03:16] Alacer leaves the room
[06:03:32] Alacer joins the room
[06:05:27] shara leaves the room
[06:06:55] jonny leaves the room: Rechner geht in den Ruhezustand
[06:08:11] rincewind leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[06:14:37] Alacer leaves the room
[06:15:01] alexis leaves the room
[06:15:26] alexis joins the room
[06:22:14] alexis leaves the room
[06:23:15] alexis joins the room
[06:24:21] Alacer joins the room
[06:30:54] ta leaves the room: Machine is going to sleep
[06:30:59] 404 leaves the room
[06:34:48] lorddavidiii joins the room
[06:36:24] torus371 joins the room
[06:37:13] mrDoctorWho joins the room
[06:43:41] deavmi leaves the room
[06:44:07] debalance leaves the room
[06:45:31] deavmi joins the room
[06:46:25] adrien joins the room
[06:50:08] debalance joins the room
[07:00:11] alexis leaves the room
[07:00:36] alexis joins the room
[07:00:41] ThUnD3r|Gr33n© leaves the room
[07:01:32] Alberto joins the room
[07:04:37] Alberto leaves the room
[07:07:24] alexis leaves the room
[07:08:13] alexis joins the room
[07:10:09] sezuan joins the room
[07:15:17] alexis leaves the room
[07:15:31] 404 joins the room
[07:15:37] alexis joins the room
[07:20:25] debalance leaves the room
[07:22:50] alexis leaves the room
[07:23:13] alexis joins the room
[07:24:10] Sergio joins the room
[07:26:19] zuglufttier joins the room
[07:26:26] alexis leaves the room
[07:26:52] alexis joins the room
[07:30:47] debalance joins the room
[07:33:54] nekit joins the room
[07:36:31] Licaon_Kter leaves the room
[07:36:55] Licaon_Kter joins the room
[07:43:04] <Licaon_Kter> jonny: no more participants for how long?
[07:45:48] info-screen leaves the room
[07:45:51] alexis leaves the room
[07:51:44] jonny leaves the room
[07:55:05] jonny joins the room
[07:59:55] debalance leaves the room
[08:01:54] mrDoctorWho leaves the room
[08:02:08] mrDoctorWho joins the room
[08:02:46] torus371 leaves the room
[08:03:49] ludo joins the room
[08:10:52] debalance joins the room
[08:13:18] Freyskeyd joins the room
[08:13:32] lorddavidiii leaves the room
[08:15:26] sezuan leaves the room
[08:17:17] debalance leaves the room
[08:30:07] debalance joins the room
[08:32:55] Marzanna joins the room
[08:35:00] ChaosKid42 leaves the room
[08:35:06] ChaosKid42 joins the room
[08:38:53] jonny leaves the room
[08:40:06] jonny joins the room
[08:41:25] zinid joins the room
[08:44:17] VC leaves the room
[08:44:18] VC joins the room
[08:44:47] 404 leaves the room
[08:45:30] mightyBroccoli leaves the room
[08:45:30] nico leaves the room
[08:45:30] nico joins the room
[08:45:31] mightyBroccoli joins the room
[08:46:58] torus371 joins the room
[08:49:01] 4223 joins the room
[08:49:10] 4223 leaves the room
[08:49:19] 4223 joins the room
[08:50:40] debalance leaves the room
[08:50:43] rom1dep leaves the room
[08:51:01] rom1dep joins the room
[08:52:54] ta leaves the room
[08:53:15] sezuan joins the room
[08:55:16] zinid leaves the room
[08:57:51] chrys leaves the room
[08:57:56] zuglufttier leaves the room: Machine is going to sleep
[09:00:28] zinid joins the room
[09:02:44] cippaciong joins the room
[09:05:00] sezuan joins the room
[09:08:06] marc joins the room
[09:16:23] jonny joins the room
[09:21:20] shara joins the room
[09:23:11] Sergio leaves the room
[09:23:12] marek leaves the room
[09:23:12] marek joins the room
[09:23:53] chrys joins the room
[09:24:06] integrationsfigur leaves the room
[09:26:29] integrationsfigur joins the room
[09:27:15] ChaosKid42 leaves the room
[09:27:21] ChaosKid42 joins the room
[09:28:18] vogt joins the room
[09:30:35] m7273 joins the room
[09:33:17] Alacer leaves the room
[09:33:30] jonny leaves the room
[09:35:05] jonny joins the room
[09:35:50] ta joins the room
[09:42:30] debalance joins the room
[09:45:04] sezuan leaves the room
[09:45:05] <jonny> not very long 12 hours...
[09:45:19] sezuan joins the room
[09:45:33] <jonny> but I like to know hot to force delete a muc room as admin too... :)
[09:46:05] <jonny> I'n new to ejabberd sorry for so many questions :D
[09:47:39] <jonny> but they appear as 'persistent' when I look into the ejabberd web config
[09:47:46] sezuan joins the room
[09:52:25] ChaosKid42 leaves the room
[09:52:31] ChaosKid42 joins the room
[09:53:39] debalance leaves the room
[09:55:06] rom1dep leaves the room
[09:56:03] torus371 leaves the room
[09:56:52] mrDoctorWho leaves the room
[10:05:33] rom1dep joins the room
[10:05:59] fp joins the room
[10:07:25] erik leaves the room: Stream closed by us: Replaced by new connection (conflict)
[10:07:29] erik joins the room
[10:09:50] debalance joins the room
[10:10:04] <Licaon_Kter> jonny: why do you care?
[10:10:19] mimi89999 leaves the room
[10:10:37] debalance leaves the room
[10:13:06] mrDoctorWho joins the room
[10:15:17] Akasch joins the room
[10:20:07] debalance joins the room
[10:26:21] <zinid> I think mod_muc_admin has some commands for that
[10:26:48] shara leaves the room
[10:26:50] shara joins the room
[10:27:22] <zinid> according to the code:
$ ejabberdctl destroy_room room conference.domain.tld
[10:28:13] integrationsfigur joins the room
[10:29:18] torus371 joins the room
[10:30:45] deavmi leaves the room
[10:31:42] deavmi joins the room
[10:31:43] ChaosKid42 leaves the room
[10:32:29] deavmi joins the room
[10:34:30] sezuan leaves the room
[10:36:12] ChaosKid42 joins the room
[10:39:13] debalance leaves the room
[10:41:44] sezuan joins the room
[10:45:39] Holger leaves the room
[10:45:46] Holger joins the room
[10:47:39] mightyBroccoli joins the room
[10:50:34] mightyBroccoli leaves the room
[10:50:38] nico joins the room
[10:50:41] mightyBroccoli joins the room
[10:50:45] nico leaves the room
[10:50:56] jonny leaves the room
[10:51:01] nico joins the room
[10:51:05] nico leaves the room
[10:51:06] nico joins the room
[10:51:09] <jonny> I already did that but the room still shows up in the web view..
I have ejabberd configured to use a postgresql db by the way...
[10:51:17] Sergio leaves the room
[10:52:07] bowlofeggs joins the room
[10:52:30] Sergio joins the room
[10:54:16] zuglufttier joins the room
[10:55:05] jonny joins the room
[10:55:51] <jonny> Thanks, it worked with ejabberdctl, my arguments were wrong.
in the webview i have a muc room with jabberid: huluv@conference.rimkus.it
the ejabberdctl command is: ejabberdctl destroy_room huluv conference.rimkus.it
but the question how to configure ejabberd sothat it is done automatically when the last participant has left is still on my mind :)
[10:56:38] ave joins the room
[10:58:03] shara leaves the room
[10:58:05] shara joins the room
[10:59:19] <zinid> there is no such command in ejabberd
[11:00:34] <jonny> Then what does the attribute persisent mean in the Webview for the muc rooms?
[11:00:51] <ChaosKid42> jonny: why not set `persistent` to false?
[11:00:57] joekokker leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[11:01:01] <jonny> well try that
[11:01:20] <jonny> Will
[11:02:23] jonny leaves the room
[11:02:23] jonny leaves the room
[11:04:58] jonny joins the room
[11:05:07] jonny joins the room
[11:05:55] info-screen joins the room
[11:06:26] joekokker joins the room
[11:06:42] Alacer joins the room
[11:07:20] infinihub joins the room
[11:07:51] <jonny> thx works
[11:07:57] <jonny> :)
[11:08:26] alexis joins the room
[11:08:42] <jonny> I changed #access_persistent: muc_create
    access_persistent: false
to
[11:09:57] zuglufttier leaves the room: Machine is going to sleep
[11:10:13] <zinid> note that MAM doesn't work in temporary rooms
[11:10:36] <jonny> good to know thanks
[11:11:49] <jonny> when I re enable persistant rooms could it led to problems with to many unused muc rooms?
[11:12:02] alexis leaves the room
[11:12:19] ave leaves the room: Machine is going to sleep
[11:12:29] alexis joins the room
[11:12:30] <zinid> jonny: default settings only affect newly created rooms
[11:12:47] <zinid> those already created will still be temporary
[11:13:24] <jonny> sure but when the persistant setting is active for a long time e.g 1 year i'm afraid of to many unused open muc rooms
[11:14:27] <zinid> well you still able to destroy them
[11:14:58] Alacer leaves the room
[11:15:02] <jonny> so I better should create a sheduled cleanup script right?
[11:15:07] <zinid> for example you can use SQL query to find rooms with outdated messages
[11:15:25] <jonny> I was thinking of bash with ejabberdctl...
[11:16:07] <zinid> well, I said above you cannot do that solely via ejabberdctl
[11:16:32] <zinid> what's the problem with querying SQL table?
[11:16:41] <jonny> nothing :)
[11:17:05] <zinid> collect those rooms in a file then run ejabberdctl desroy_rooms_file
[11:17:06] <jonny> then using sql to find rooms for deletion and then delete them via ejabberdctl
[11:17:12] <jonny> :)
[11:17:14] <jonny> right
[11:17:24] <zinid> 2 lines script
[11:17:35] <jonny> :)
[11:17:37] <ChaosKid42> You can use following command of ejabberdctl
> rooms_unused_destroy host days
>          Destroy the rooms that are unused for many days in host
[11:17:49] <zinid> ChaosKid42: ah
[11:17:53] <jonny> top
[11:18:05] <zinid> what's considered unused there?
[11:18:41] <ChaosKid42> Idk actually 😃
[11:19:28] sezuan leaves the room: Rechner geht in den Ruhezustand
[11:19:43] <ChaosKid42> zinid: You usually suggest to read the code. I'll try that.
[11:20:29] mimi89999 joins the room
[11:21:41] Sergio leaves the room
[11:22:06] integrationsfigur leaves the room
[11:23:44] Sergio joins the room
[11:25:42] Alacer joins the room
[11:26:43] integrationsfigur joins the room
[11:26:58] <ChaosKid42> Seems like a room is considered unused for n days if the last message is at least n days old.
[11:28:35] <ChaosKid42> And if it's not just created and has zero users.
[11:29:00] <ChaosKid42> And if it's persistent.
[11:29:46] Sergio leaves the room
[11:29:53] <ChaosKid42> https://github.com/processone/ejabberd/blob/master/src/mod_muc_admin.erl#L800
[11:30:46] <jonny> hmm in webview:
Jabber ID < >    # participants < >    Last message < >    Public < >    Persistent < >    Logging < >    Just created < >    Raumname < >
uwinitu@conference.rimkus.it    0    A long time ago    false    true    false    false
[11:31:00] <jonny> echo390:~# /etc/cron.daily/ejabberd-cleanup
Unused rooms: 0 out of 1
Unused rooms: 0 out of 1
[11:31:42] Sergio joins the room
[11:31:58] <jonny> sry
[11:32:00] <jonny> n days..
[11:32:16] Alacer leaves the room
[11:34:05] Alacer joins the room
[11:34:11] lorddavidiii joins the room
[11:40:05] debalance joins the room
[11:40:07] sezuan leaves the room
[11:40:23] sezuan joins the room
[11:40:31] Alacer leaves the room
[11:41:36] <zinid> ChaosKid42, this won't work when the room doesn't have history and solely relies on MAM
[11:41:41] integrationsfigur leaves the room
[11:41:53] zuglufttier joins the room
[11:41:57] Alacer joins the room
[11:45:23] <ChaosKid42> Then you need to make sure not to set history to 0.
[11:46:01] VC leaves the room
[11:46:46] debalance leaves the room
[11:48:44] VC joins the room
[11:49:17] spicewiesel leaves the room
[11:49:20] spicewiesel joins the room
[11:50:25] focus121 leaves the room
[11:50:48] VC leaves the room
[11:51:29] VC joins the room
[11:54:13] focus121 joins the room
[11:57:27] mightyBroccoli leaves the room: Machine is going to sleep
[11:57:27] nico leaves the room
[11:57:56] VC leaves the room
[11:57:59] VC joins the room
[12:02:14] info-screen leaves the room
[12:02:46] jonny leaves the room
[12:02:46] jonny joins the room
[12:03:19] debalance joins the room
[12:09:32] mrDoctorWho joins the room
[12:09:53] debalance leaves the room
[12:10:12] debalance joins the room
[12:11:04] mimi89999 joins the room
[12:11:11] mrDoctorWho leaves the room
[12:12:32] alexis leaves the room
[12:12:57] alexis joins the room
[12:12:57] jonny leaves the room
[12:12:57] jonny leaves the room
[12:13:17] debalance joins the room
[12:13:59] mimi89999 leaves the room
[12:13:59] mimi89999 leaves the room
[12:14:10] deavmi leaves the room
[12:15:51] robert_mobil joins the room
[12:16:06] ChaosKid42 joins the room
[12:18:13] sezuan joins the room
[12:18:41] jonny joins the room
[12:19:33] jonny joins the room
[12:20:47] Alacer leaves the room
[12:21:44] debalance leaves the room
[12:22:25] ChaosKid42 leaves the room
[12:22:33] ChaosKid42 joins the room
[12:26:42] ChaosKid42 leaves the room
[12:27:54] robert_mobil leaves the room
[12:29:04] ChaosKid42 leaves the room
[12:29:09] robert_mobil joins the room
[12:30:42] Alacer joins the room
[12:30:57] ChaosKid42 joins the room
[12:31:53] deavmi leaves the room
[12:32:02] alexis leaves the room
[12:32:50] ChaosKid42 joins the room
[12:33:29] alexis joins the room
[12:33:35] ChaosKid42 leaves the room
[12:34:43] ChaosKid42 leaves the room
[12:34:44] ChaosKid42 joins the room
[12:36:11] deavmi joins the room
[12:36:17] ChaosKid42 joins the room
[12:37:29] ChaosKid42 leaves the room
[12:37:54] Alacer leaves the room
[12:38:19] Alacer joins the room
[12:39:11] alexis leaves the room
[12:39:37] alexis joins the room
[12:40:56] <Holger> Also fails if the server was restarted within the period you're checking.
[12:41:26] alexis leaves the room
[12:42:19] <jonny> so mod_muc_log must be enabled?
[12:42:31] alexis joins the room
[12:49:09] <zinid> jonny, no
[12:49:53] mrDoctorWho joins the room
[12:50:57] debalance joins the room
[12:51:36] alexis leaves the room
[12:51:52] mrDoctorWho leaves the room
[12:52:05] alexis joins the room
[12:52:40] infinihub leaves the room
[12:52:57] debalance leaves the room
[12:53:09] infinihub joins the room
[12:55:24] deavmi joins the room
[12:58:31] maddl joins the room
[12:58:31] maddl leaves the room
[13:01:13] debalance leaves the room
[13:03:00] sezuan leaves the room
[13:06:07] jonny leaves the room
[13:06:15] rincewind joins the room
[13:06:46] joekokker leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[13:08:09] debalance joins the room
[13:08:42] joekokker joins the room
[13:09:44] jonny leaves the room
[13:15:33] Alacer leaves the room
[13:16:23] maddl joins the room
[13:16:25] maddl leaves the room
[13:18:16] torus371 leaves the room
[13:18:24] jonny joins the room
[13:19:10] jonny joins the room
[13:19:24] sezuan leaves the room: Rechner geht in den Ruhezustand
[13:21:06] Alacer joins the room
[13:21:21] fp joins the room
[13:25:05] debalance joins the room
[13:27:29] maddl joins the room
[13:27:53] zuglufttier leaves the room: Machine is going to sleep
[13:28:08] ave joins the room
[13:31:43] panpansh leaves the room
[13:32:14] alexis leaves the room
[13:32:43] alexis joins the room
[13:35:29] bowlofeggs leaves the room
[13:35:31] rincewind joins the room
[13:36:15] mrDoctorWho leaves the room
[13:41:34] deavmi leaves the room
[13:42:32] jonny leaves the room
[13:43:57] sezuan joins the room
[13:44:22] jonny joins the room
[13:47:33] maddl leaves the room
[13:47:39] maddl joins the room
[13:49:32] infinihub leaves the room
[13:51:37] infinihub joins the room
[13:56:15] jonny leaves the room
[13:58:35] spicewiesel leaves the room
[13:58:43] alexis leaves the room
[13:59:08] alexis joins the room
[13:59:46] spicewiesel joins the room
[14:01:39] bowlofeggs joins the room
[14:03:01] pprrks leaves the room
[14:03:09] pprrks joins the room
[14:05:06] <ChaosKid42> Holger, jonny, zinid: I conclude there is no easy, reliable way to destroy unused rooms.
I would suggest to regularily truncate mam by using `delete_old_mam_messages`, find all rooms with empty archive and just delete them.
[14:05:16] spicewiesel leaves the room
[14:05:49] spicewiesel joins the room
[14:06:42] torus371 joins the room
[14:06:50] <jonny> 👍 Will add it to the cleanup job thx
[14:07:18] infinihub leaves the room
[14:07:27] torus371 leaves the room: Disconnected: Replaced by new connection
[14:07:28] torus371 joins the room
[14:07:50] shara joins the room
[14:09:00] tyler leaves the room
[14:11:06] tyler joins the room
[14:11:34] sezuan joins the room
[14:12:43] jonny joins the room
[14:26:52] jonny leaves the room
[14:27:15] jonny joins the room
[14:29:15] <ChaosKid42> jonny: https://gist.github.com/ChaosKid42/5e4c8184f280c20736d772925a4555cd
[14:29:26] maddl leaves the room
[14:29:34] maddl joins the room
[14:31:18] <jonny> cool will adopt for postgresql :)
[14:31:49] doctor joins the room
[14:32:47] torus371 leaves the room
[14:34:15] pprrks leaves the room
[14:34:46] shara leaves the room
[14:36:09] shara leaves the room
[14:36:10] integrationsfigur leaves the room
[14:37:13] frainz leaves the room
[14:37:49] integrationsfigur joins the room
[14:38:46] sezuan leaves the room: Rechner geht in den Ruhezustand
[14:41:59] ave leaves the room
[14:43:35] debalance leaves the room
[14:43:37] shara joins the room
[14:44:11] ave joins the room
[14:44:15] frainz joins the room
[14:47:21] maddl leaves the room
[14:47:29] maddl joins the room
[14:51:34] Alacer leaves the room
[14:52:01] pprrks joins the room
[14:52:55] 404 joins the room
[14:53:12] infinihub joins the room
[14:54:15] torus371 joins the room
[14:54:16] debalance joins the room
[14:57:23] debalance leaves the room
[15:02:21] debalance leaves the room
[15:03:56] ChaosKid42 leaves the room
[15:05:02] ChaosKid42 joins the room
[15:05:45] marek leaves the room
[15:06:43] rom1dep leaves the room
[15:07:02] marek joins the room
[15:08:22] fp leaves the room
[15:08:28] fp joins the room
[15:08:44] frainz leaves the room
[15:09:21] debalance joins the room
[15:09:48] frainz joins the room
[15:09:50] fp leaves the room
[15:10:12] fp joins the room
[15:11:21] maddl leaves the room
[15:11:29] maddl joins the room
[15:11:42] fp leaves the room
[15:11:48] fp joins the room
[15:13:03] infinihub leaves the room
[15:14:13] infinihub joins the room
[15:15:17] debalance joins the room
[15:16:31] debalance leaves the room
[15:17:09] SouL leaves the room
[15:17:13] SouL joins the room
[15:19:21] bowlofeggs leaves the room
[15:19:53] marek joins the room
[15:22:57] <jonny> shouldn't the cursor be closed at the end?
[15:23:03] jonny leaves the room
[15:25:05] jonny joins the room
[15:29:14] zuglufttier joins the room
[15:30:33] <jonny> the query still returns a result after executing destroy_room, but does not show up in the admin web view...
[15:31:21] maddl leaves the room
[15:31:28] doctor leaves the room
[15:31:29] maddl joins the room
[15:31:56] zuglufttier leaves the room: Machine is going to sleep
[15:32:28] <jonny> https://pastebin.com/9fE5hQkp
[15:33:05] ave leaves the room
[15:35:46] torus371 leaves the room
[15:37:57] infinihub leaves the room
[15:40:27] ChaosKid42 leaves the room
[15:40:27] debalance joins the room
[15:40:42] infinihub joins the room
[15:42:08] doctor joins the room
[15:44:01] <jonny> sorry script is incomplete
[15:44:02] <jonny> mom.
[15:44:12] spicewiesel leaves the room
[15:44:59] spicewiesel joins the room
[15:45:26] <jonny> https://pastebin.com/nvWyW516
[15:46:08] <jonny> should i add a sql delete statement? or should ejabberdctl handle the delete in the postgres db?
[15:49:02] shara leaves the room
[15:49:29] zuglufttier joins the room
[15:49:46] shara joins the room
[15:51:37] ChaosKid42 joins the room
[15:51:51] 404 leaves the room
[15:54:13] chrys leaves the room: Disconnected: Replaced by new connection
[15:54:48] chrys joins the room
[15:54:57] maddl leaves the room
[15:55:04] maddl joins the room
[15:56:31] rom1dep joins the room
[15:57:32] torus371 joins the room
[15:58:13] <ChaosKid42> jonny: I'd let ejabberdctl do it. Deleting a room is more than just clearing some db tables.
[16:06:00] <jonny> Damn thx
[16:07:17] rom1dep leaves the room
[16:07:22] maddl leaves the room
[16:07:29] maddl joins the room
[16:08:49] marek leaves the room
[16:09:37] infinihub leaves the room
[16:10:36] ChaosKid42 leaves the room
[16:10:46] ChaosKid42 joins the room
[16:12:01] marek leaves the room
[16:12:55] sezuan leaves the room
[16:13:04] sezuan joins the room
[16:14:14] <jonny> strange thing is that the db entries are not deleted after ejabberctl_delete_room
[16:17:16] jonny leaves the room
[16:17:38] <ChaosKid42> Are the rooms destroyed at all? You can check with ejabberdctl. You can list all the rooms.
[16:17:38] jonny leaves the room
[16:17:47] jonny joins the room
[16:18:15] jonny joins the room
[16:21:15] <jonny> No they still show up
[16:23:00] <ChaosKid42> It's working for me. Check your script by using `echo` in front of your ejabberdctl command. What's the output?
[16:23:40] <ChaosKid42> Is the archive of those rooms empty?
[16:25:03] <jonny> the command is correct i check the archive mom...
[16:28:23] <jonny> there are entries for that room in the archive table
[16:28:49] <jonny> so no
[16:28:51] infinihub joins the room
[16:29:20] marek joins the room
[16:30:33] debalance leaves the room
[16:30:56] chrys leaves the room
[16:31:20] chrys joins the room
[16:32:07] 404 joins the room
[16:33:11] zuglufttier leaves the room: Machine is going to sleep
[16:35:03] rom1dep leaves the room
[16:35:10] rom1dep joins the room
[16:35:37] chrys leaves the room
[16:35:40] chrys joins the room
[16:36:36] infinihub leaves the room
[16:37:54] <jonny> after deleting the archive messages via sql it worked, but I guess this is not the correct way
[16:41:13] debalance joins the room
[16:41:27] infinihub joins the room
[16:42:40] info-screen joins the room
[16:43:27] jonny leaves the room
[16:43:27] jonny leaves the room
[16:43:35] <ChaosKid42> jonny: The script you posted does not execute the commands. It only prints them. You are aware of that, are you?
[16:43:41] jonny joins the room
[16:43:41] jonny leaves the room
[16:44:33] jonny joins the room
[16:44:33] jonny leaves the room
[16:45:57] sezuan joins the room
[16:48:59] zuglufttier joins the room
[16:50:39] sezuan leaves the room: Rechner geht in den Ruhezustand
[16:52:32] infinihub leaves the room
[16:56:36] rom1dep leaves the room
[16:56:37] jonny joins the room
[16:57:45] deavmi leaves the room
[16:58:48] infinihub joins the room
[16:58:58] debalance leaves the room
[16:59:14] alexis leaves the room
[16:59:39] alexis joins the room
[17:00:11] <jonny> Yes the last statement is missing
[17:00:12] ChaosKid42 leaves the room
[17:00:40] 4223 leaves the room
[17:00:45] 4223 joins the room
[17:00:48] <jonny> for row in c:
        cmd=DESTROY_COMMAND.format(row[0], row[1]);
        print('delete room "'+row[0]+'" on server "'+row[1]+'"');
os.system(cmd)
[17:00:50] 4223 leaves the room
[17:01:10] <jonny> It is working when the archive table is empty
[17:01:29] 4223 joins the room
[17:01:56] <jonny> It is your MySQL script edited for postgresql
[17:02:40] <jonny> Is it correct that os.system is outside the loop?
[17:07:21] rom1dep joins the room
[17:08:15] debalance leaves the room
[17:08:17] debalance joins the room
[17:08:31] maddl leaves the room
[17:10:19] rom1dep joins the room
[17:11:28] 404 leaves the room
[17:11:49] infinihub leaves the room
[17:12:43] ChaosKid42 joins the room
[17:18:14] rom1dep leaves the room
[17:23:54] info-screen leaves the room
[17:24:19] jonny leaves the room
[17:24:20] jonny joins the room
[17:25:45] infinihub joins the room
[17:26:21] ChaosKid42 leaves the room
[17:28:36] mimi89999 joins the room
[17:31:12] mimi89999 leaves the room
[17:32:59] mimi89999 joins the room
[17:34:37] m7273 leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[17:37:29] alexis leaves the room
[17:38:04] infinihub leaves the room
[17:39:04] alexis joins the room
[17:39:24] alexis leaves the room
[17:39:46] alexis joins the room
[17:41:24] alexis leaves the room
[17:43:53] torus371 leaves the room: Disconnected: Replaced by new connection
[17:43:53] mimi89999 leaves the room
[17:43:54] torus371 joins the room
[17:44:07] torus371 leaves the room
[17:45:37] torus371 joins the room
[17:47:38] chrys joins the room
[17:48:20] debalance leaves the room
[17:48:41] alexis joins the room
[17:54:29] alexis leaves the room
[17:54:56] alexis joins the room
[18:00:42] mimi89999 joins the room
[18:01:09] mimi89999 joins the room
[18:02:30] mimi89999 leaves the room: Disconnected: Replaced by new connection
[18:02:44] ludo leaves the room
[18:03:27] ludo joins the room
[18:06:56] ludo leaves the room
[18:07:16] alexis leaves the room
[18:07:29] maddl joins the room
[18:07:31] maddl leaves the room
[18:07:32] integrationsfigur leaves the room
[18:07:33] ludo joins the room
[18:07:42] nico leaves the room
[18:07:42] mightyBroccoli leaves the room
[18:07:47] alexis joins the room
[18:09:23] mimi89999 leaves the room
[18:09:27] mightyBroccoli joins the room
[18:10:26] integrationsfigur joins the room
[18:10:32] nico joins the room
[18:13:11] alexis leaves the room
[18:13:38] alexis joins the room
[18:15:22] rom1dep leaves the room
[18:15:32] alexis leaves the room
[18:15:34] mimi89999 joins the room
[18:15:59] alexis joins the room
[18:16:16] mimi89999 leaves the room
[18:16:39] mimi89999 joins the room
[18:16:58] shara leaves the room
[18:16:58] mimi89999 joins the room
[18:17:41] mimi89999 leaves the room
[18:17:57] mimi89999 leaves the room
[18:17:58] frainz leaves the room
[18:18:06] mimi89999 joins the room
[18:18:49] mimi89999 joins the room
[18:18:51] infinihub joins the room
[18:19:09] shara joins the room
[18:20:33] jonny leaves the room
[18:21:07] jonny joins the room
[18:21:27] <Freyskeyd> Hello, is it possible to invite someone in a MUC, define his nick (in the muc) and don't allow him to change it?
[18:21:38] <Freyskeyd> when the user is participant not visitor
[18:21:46] Freyskeyd leaves the room
[18:22:01] Freyskeyd joins the room
[18:24:47] <zinid> Freyskeyd: no, s/he always can rejoin with another nick
[18:25:56] <Freyskeyd> how can I identify a single one people in a MAM when he change he's nickname?
[18:28:12] <Freyskeyd> oh, I just read that MAM contains the bare jid
[18:29:03] rincewind joins the room
[18:32:57] <zinid> yeah, by jid
[18:34:00] <Freyskeyd> ok
[18:35:04] <Freyskeyd> another, weird, question. When I've MUC subscription (on messages), when I connect to an XMPP I will not receive any package from thoses subscription before sending my first presence right?
[18:37:17] rom1dep joins the room
[18:38:03] infinihub leaves the room
[18:39:58] frainz joins the room
[18:41:30] rom1dep leaves the room
[18:41:40] rom1dep joins the room
[18:42:33] <zinid> dunno
[18:42:53] m7273 joins the room
[18:43:09] jonny leaves the room
[18:50:05] jonny joins the room
[18:51:40] sezuan leaves the room
[18:52:31] info-screen joins the room
[18:53:44] nico leaves the room
[18:53:44] mightyBroccoli leaves the room
[18:53:45] nico joins the room
[18:53:46] mightyBroccoli joins the room
[18:55:18] sezuan joins the room
[19:02:53] ChaosKid42 joins the room
[19:04:44] ChaosKid42 joins the room
[19:05:36] <ChaosKid42> > Is it correct that os.system is outside the loop?
jonny: No it's wrong.
[19:06:54] pprrks leaves the room
[19:10:03] <jonny> OK 😊
[19:10:11] <jonny> Thx
[19:11:44] ChaosKid42 leaves the room
[19:13:17] ChaosKid42 joins the room
[19:14:45] jonny joins the room
[19:17:20] ChaosKid42 leaves the room
[19:17:26] ChaosKid42 joins the room
[19:18:50] infinihub joins the room
[19:20:37] torus371 leaves the room
[19:21:29] <jonny> this is my final script (credentials anonymized ;) ) https://pastebin.com/8jP1eJvz
[19:21:52] <jonny> but when there are messages in the archive table the romm is NOT deleted.
[19:22:41] ChaosKid42 leaves the room
[19:23:22] <ChaosKid42> jonny: Yes. See my previous post:
> I would suggest to regularily truncate mam by using `delete_old_mam_messages`, find all rooms with empty archive and just delete them.
[19:25:20] <ChaosKid42> If you truncate mam by that command (e.g delete all messages older than e.g. 30 days), you can then use the script to destroy all rooms that are empty.
[19:26:43] <jonny> yes thanks saw that already my cron.daily script looks like this: https://pastebin.com/QAZqcdiC (ejabberd-clean-empty-rooms) is the python script posted above
[19:28:13] <ChaosKid42> Looks good.
[19:32:03] alexis leaves the room
[19:33:24] carlos leaves the room
[19:33:25] carlos joins the room
[19:33:37] ludo leaves the room
[19:34:15] ludo joins the room
[19:36:56] zuglufttier leaves the room: Machine is going to sleep
[19:46:16] ChaosKid42 leaves the room
[19:46:22] ChaosKid42 joins the room
[19:50:29] jannic leaves the room
[19:51:54] frainz leaves the room
[19:52:08] frainz joins the room
[19:52:26] infinihub leaves the room
[19:58:56] jonny leaves the room
[20:03:56] jonny joins the room
[20:04:04] Licaon_Kter leaves the room
[20:07:28] maddl joins the room
[20:07:30] maddl leaves the room
[20:07:59] m7273 leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:09:42] APach leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[20:12:28] Licaon_Kter joins the room
[20:12:59] rom1dep leaves the room
[20:13:17] rom1dep joins the room
[20:14:42] APach joins the room
[20:22:25] integrationsfigur leaves the room
[20:23:55] mightyBroccoli joins the room
[20:24:08] nico joins the room
[20:24:14] nico leaves the room
[20:24:23] nico joins the room
[20:24:30] nico leaves the room
[20:24:31] nico joins the room
[20:24:38] nico leaves the room
[20:24:39] nico joins the room
[20:28:44] zuglufttier joins the room
[20:28:51] infinihub joins the room
[20:31:06] jonny leaves the room
[20:31:06] deavmi leaves the room
[20:31:06] jonny joins the room
[20:31:54] rom1dep leaves the room
[20:32:05] rom1dep joins the room
[20:32:12] zuglufttier leaves the room
[20:35:12] Sergio joins the room
[20:35:46] Sergio leaves the room
[20:36:48] jannic joins the room
[20:37:20] infinihub leaves the room
[20:40:28] ulrich joins the room
[20:41:08] mimi89999 leaves the room
[20:44:16] nico leaves the room
[20:44:16] mightyBroccoli leaves the room
[20:49:19] sezuan joins the room
[20:49:27] mimi89999 joins the room
[20:50:03] Neustradamus joins the room
[20:51:33] chrys leaves the room
[20:51:42] chrys joins the room
[20:52:24] Neustradamus leaves the room
[20:54:13] Marzanna leaves the room: Bye!
[20:54:14] sezuan leaves the room: Rechner geht in den Ruhezustand
[20:59:58] joekokker leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:01:17] ulrich leaves the room
[21:03:26] carlos joins the room
[21:04:13] ulrich joins the room
[21:05:14] Holger leaves the room
[21:05:23] Holger joins the room
[21:06:01] joekokker joins the room
[21:13:40] tyler leaves the room
[21:13:41] rom1dep leaves the room
[21:13:56] rom1dep joins the room
[21:14:07] vogt leaves the room
[21:14:58] jonny leaves the room
[21:14:58] jonny joins the room
[21:18:15] fp leaves the room
[21:18:18] rincewind leaves the room
[21:18:47] joekokker leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[21:20:00] jonny leaves the room
[21:20:00] jonny joins the room
[21:21:55] ludo leaves the room
[21:22:02] marc leaves the room
[21:22:11] marc joins the room
[21:24:24] infinihub joins the room
[21:25:04] jonny leaves the room
[21:25:05] jonny joins the room
[21:25:27] joekokker joins the room
[21:27:42] marc leaves the room
[21:27:51] marc joins the room
[21:30:26] chrys leaves the room
[21:31:32] torus371 joins the room
[21:33:28] rom1dep joins the room
[21:33:36] ta leaves the room
[21:33:38] ta joins the room
[21:35:43] zinid leaves the room
[21:37:21] jonny leaves the room: Rechner geht in den Ruhezustand
[21:38:54] marc leaves the room
[21:38:56] rom1dep leaves the room: Machine is going to sleep
[21:40:02] infinihub leaves the room
[21:40:58] info-screen leaves the room
[21:41:37] nekit leaves the room
[21:41:38] nekit joins the room
[21:44:22] jonny joins the room
[21:45:05] bowlofeggs joins the room
[21:45:26] Sergio leaves the room
[21:46:31] infinihub joins the room
[21:54:45] alexis joins the room
[21:55:01] torus371 leaves the room
[21:55:34] rom1dep leaves the room
[21:55:46] rom1dep joins the room
[21:59:45] edhelas leaves the room: Stream reset by peer
[22:00:33] edhelas joins the room
[22:01:32] pod leaves the room: Machine is going to sleep
[22:03:29] VC leaves the room
[22:03:29] VC joins the room
[22:04:43] maddl joins the room
[22:06:03] rom1dep leaves the room
[22:07:08] jonny leaves the room
[22:07:08] jonny joins the room
[22:09:02] edhelas leaves the room: Stream reset by peer
[22:09:07] infinihub leaves the room
[22:09:30] edhelas joins the room
[22:11:22] fp joins the room
[22:17:19] maddl leaves the room
[22:17:27] maddl joins the room
[22:18:54] VC leaves the room
[22:18:54] VC joins the room
[22:35:03] Licaon_Kter leaves the room
[22:35:04] frainz leaves the room
[22:36:13] Akasch leaves the room: Rechner geht in den Ruhezustand
[22:37:19] maddl leaves the room
[22:37:27] maddl joins the room
[22:38:23] Licaon_Kter joins the room
[22:39:03] lorddavidiii leaves the room
[22:39:11] rincewind leaves the room
[22:39:26] infinihub joins the room
[22:41:43] lorddavidiii joins the room
[22:43:16] sezuan leaves the room
[22:43:31] sezuan joins the room
[22:46:25] marek leaves the room
[22:46:42] bowlofeggs leaves the room
[22:52:04] lorddavidiii leaves the room
[22:55:32] Neustradamus leaves the room
[22:57:03] pod leaves the room
[22:57:04] pod joins the room
[22:57:13] Neustradamus joins the room
[23:00:51] ta leaves the room
[23:00:51] ta leaves the room
[23:00:54] infinihub leaves the room
[23:01:56] maddl leaves the room
[23:02:02] maddl joins the room
[23:02:51] ChaosKid42 leaves the room
[23:03:03] ChaosKid42 joins the room
[23:03:52] chrys leaves the room
[23:05:12] pod leaves the room
[23:06:08] Freyskeyd leaves the room: Disconnected: closed
[23:06:48] Freyskeyd joins the room
[23:08:07] fp leaves the room
[23:09:33] lorddavidiii joins the room
[23:10:02] infinihub joins the room
[23:11:24] Freyskeyd leaves the room: Disconnected: closed
[23:14:06] fp leaves the room
[23:15:15] fp joins the room
[23:15:31] lorddavidiii leaves the room
[23:16:57] cippaciong joins the room
[23:19:56] maddl leaves the room
[23:20:04] maddl joins the room
[23:22:29] joekokker leaves the room: Stream closed by us: Timed out waiting for stream resumption (connection-timeout)
[23:26:36] rincewind joins the room
[23:28:47] joekokker joins the room
[23:30:51] ThUnD3r|Gr33n© joins the room
[23:32:14] tyler joins the room
[23:34:23] carlos leaves the room
[23:34:26] Licaon_Kter leaves the room
[23:41:19] maddl leaves the room
[23:41:22] infinihub leaves the room
[23:41:27] maddl joins the room
[23:47:07] nekit leaves the room
[23:54:21] jonny leaves the room: Rechner geht in den Ruhezustand
[23:57:09] alexis leaves the room
[23:57:35] alexis joins the room
[23:57:47] info-screen joins the room
Powered by ejabberd - robust, scalable and extensible XMPP server Powered by Erlang Valid XHTML 1.0 Transitional Valid CSS!