ejabberd - Monday, March 31, 2025

[07:36:59] <Marc> Hi, this morning I saw rosters and MAM were broken, and in logs there were SQL errors so I deleted the line `new_sql_schema: true` and this problem is now solved, but they are still PLAIN connections
[07:37:47] <Licaon_Kter> Marc: You've read what new_sql_schema entails?
Why is everyone switching that out of the blue? Seen at least one this week on Github
[07:38:00] <Licaon_Kter> Marc: You've read what new_sql_schema entails? https://docs.ejabberd.im
Why is everyone switching that out of the blue? Seen at least one this week on Github

[07:39:01] samuel leaves the room

[07:40:00] banana leaves the room

[07:40:01] nega†ive1 leaves the room

[07:40:31] banana joins the room

[07:41:06] meson joins the room

[07:41:08] <Marc> Just before the upgrade I updated the SQL schema by adding `update_sql_schema: true` and then reloading ejabberd because I saw in the release announcement the new schema was needed to enable `auth_stored_password_types`

[07:41:11] karme joins the room

[07:42:09] mogad0n leaves the room

[07:42:15] <Marc> I added the line `new_sql_schema: true` only after several attempts to get it working

[07:42:50] marc joins the room

[07:42:53] <Licaon_Kter> Marc: Not related.... use docs please
The actual sql schema is different, not sure ejabberd can updated from OLDDB schema to NEWDB schema
This is confusing because IT'S NOT ABOUT ejabberd update, it's something else

[07:43:15] debacle leaves the room

[07:43:16] <Licaon_Kter> Damn naming things pfft

[07:43:41] mogad0n joins the room

[07:43:54] <Licaon_Kter> old_schema is "one db per host"
new_schema is "one huge db"

[07:44:32] robert_mobil leaves the room

[07:44:43] robert_mobil joins the room

[07:44:44] <Marc> > This release requires SQL database schema update to allow storage of multiple passwords per user. This task can be performed automatically by ejabberd, if your config has enabled update_sql_schema toplevel option.
> If you prefer to perform the SQL schema update manually yourself, check the corresponding instructions, depending if your config has enabled new_sql_schema:

[07:44:56] ClapTrap leaves the room

[07:44:58] <Licaon_Kter> Right
[07:45:14] <Licaon_Kter> It does not say TO ENABLE new_schema

[07:45:21] midou leaves the room

[07:45:30] <Licaon_Kter> It says, IF you use old do this
IF you use new_schema do that
[07:45:34] <Licaon_Kter> Separate things

[07:45:37] Qasim solimany leaves the room

[07:46:02] prefiks joins the room

[07:46:33] <Licaon_Kter> With "update_sql_schema" you don't need to do anything, (in theory)

[07:46:41] Qasim solimany joins the room

[07:46:47] zain leaves the room

[07:47:19] <Licaon_Kter> In practice bugs happen https://github.com/processone/ejabberd/issues/4365

[07:48:03] zain joins the room

[07:50:11] <Marc> Before upgrading I was using old schema but enabled the option `update_sql_schema` in order to perform the task automatically

[07:50:38] Mirror leaves the room

[07:50:52] <Marc> Since there were SQL errors when I added the line `new_sql_schema: true` I have to assume I'm still in the old schema ?

[07:50:53] Mirror joins the room

[07:51:18] <Licaon_Kter> Confusion yes...wow...
[07:51:40] <Licaon_Kter> > Since there were SQL errors when I added the line `new_sql_schema: true` I have to assume I'm still in the old schema ?
Not sure what happens, disable that and find the exact error
[07:51:41] <Marc> But I didn't see errors when upgrading ejabberd
[07:51:49] <Licaon_Kter> Mmmkay.,.,
[07:52:04] <Licaon_Kter> > Before upgrading I was using old schema but enabled the option `update_sql_schema` in order to perform the task automatically
Yes, there was no need to modify .yml
[07:52:06] <Marc> > > Since there were SQL errors when I added the line `new_sql_schema: true` I have to assume I'm still in the old schema ?
> Not sure what happens, disable that and find the exact error
I deleted this line this morning because it caused errors
[07:52:21] <Licaon_Kter> Which error?

[07:52:32] Holger joins the room

[07:52:38] <Licaon_Kter> Are you using sqlite or postgres or mariadb or?

[07:53:06] nega†ive1 joins the room

[07:53:09] Adrien joins the room

[07:54:09] Adrien leaves the room

[07:54:15] <Marc> I'm using MariaDB
```
2025-03-31 09:30:53.381826+02:00 [error] <0.635.0>@ejabberd_sql:check_error/2:1432 SQL query 'SELECT COUNT(*) FROM archive WHERE  username='user2' and server_host='domain.tld' and bare_peer='user1@domain.tld' and timestamp >= 1731317637563000 and timestamp <= 1742974252804000;' failed: <<"#42S22Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.383692+02:00 [error] <0.636.0>@ejabberd_sql:check_error/2:1425 SQL query 'Q62216458' at {mod_privacy_sql,{392,12}} failed: <<"Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.385496+02:00 [error] <0.637.0>@ejabberd_sql:check_error/2:1432 SQL query 'SELECT  timestamp, xml, peer, kind, nick FROM archive WHERE username='user2' and server_host='domain.tld' and bare_peer='user1@domain.tld' and timestamp >= 1742974252804000 and timestamp <= 1742974252611000 ORDER BY timestamp ASC  limit 51;' failed: <<"#42S22Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.386898+02:00 [error] <0.638.0>@ejabberd_sql:check_error/2:1432 SQL query 'SELECT COUNT(*) FROM archive WHERE  username='user2' and server_host='domain.tld' and bare_peer='user1@domain.tld' and timestamp >= 1742974252804000 and timestamp <= 1742974252611000;' failed: <<"#42S22Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.388692+02:00 [error] <0.639.0>@ejabberd_sql:check_error/2:1425 SQL query 'Q62216458' at {mod_privacy_sql,{392,12}} failed: <<"Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.390401+02:00 [error] <0.640.0>@ejabberd_sql:check_error/2:1432 SQL query 'SELECT  timestamp, xml, peer, kind, nick FROM archive WHERE username='user2' and server_host='domain.tld' and timestamp >= 1742974252611000 ORDER BY timestamp ASC  limit 51;' failed: <<"#42S22Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.391889+02:00 [error] <0.641.0>@ejabberd_sql:check_error/2:1432 SQL query 'SELECT COUNT(*) FROM archive WHERE  username='user2' and server_host='domain.tld' and timestamp >= 1742974252611000;' failed: <<"#42S22Unknown column 'server_host' in 'WHERE'">>
2025-03-31 09:30:53.393696+02:00 [error] <0.642.0>@ejabberd_sql:check_error/2:1425 SQL query 'Q62216458' at {mod_privacy_sql,{392,12}} failed: <<"Unknown column 'server_host' in 'WHERE'">>
```
[07:54:36] <Holger> New vs. old schema.

[07:54:38] zain leaves the room

[07:54:52] <Marc> I'm using MariaDB
https://privatebin.net/?6c812cacb63aaa78#C15ARcgZu31jMhHqst81Lhe86TixiqxstYVZupXZuAQs

[07:55:43] badlop joins the room

[07:56:28] <Holger> "I updated the SQL schema by adding `update_sql_schema: true` and then reloading ejabberd", I don't think that's supposed to work automagically (as Licaon_Kter said).

[07:56:30] serafean joins the room

[07:56:52] zain joins the room

[07:58:12] neox leaves the room

[07:59:23] Adrien joins the room

[08:00:06] <Marc> Ok

[08:00:23] Adrien leaves the room

[08:00:58] <prefiks> yes, schema is not upgraded when you do that, it purelly to inform ejabberd what db schema has
[08:01:33] <Marc> So I'm performing these commands to the SQL database:
```
ALTER TABLE users ADD COLUMN type smallint NOT NULL DEFAULT 0;
ALTER TABLE users ALTER COLUMN type DROP DEFAULT;
ALTER TABLE users DROP PRIMARY KEY, ADD PRIMARY KEY (username(191), type);
```

[08:01:58] spacecat leaves the room

[08:03:06] samuel joins the room

[08:03:06] <prefiks> so first thing that you need to do is remove new_sql_schema: true (or change it to false, as this is what you really have)

[08:03:06] Marc leaves the room

[08:03:36] debacle joins the room

[08:03:38] <prefiks> and yes, to update schema you execute those lines
[08:03:44] <badlop> for reference, notice the difference (maybe the docs should clarify this difference):
- UPDATE schema from ejabberd version xx.xx to yy.yy --> enable option update_sql_schema or update sql manually
- SWITCH from default to new schemas: use update_sql command or update manually, see http://127.0.0.1:8000/admin/configuration/database/#database-schema

[08:05:18] Benson leaves the room

[08:05:27] Titi joins the room

[08:05:28] <Marc> It's done, changing the SQL database and commenting the line `new_sql_schema: true`
[08:05:44] <Marc> I restarted ejabberd and mariadb, I don't see SQL errors in the logs

[08:05:46] Adrien joins the room

[08:06:01] Marc joins the room

[08:06:05] meson joins the room

[08:06:46] Adrien leaves the room

[08:07:03] random_tester_123 leaves the room

[08:07:13] spacecat joins the room

[08:07:54] Adrien joins the room

[08:08:08] <Marc> Now I will again to enable `auth_stored_password_types`

[08:08:15] raucao leaves the room

[08:08:47] Marc leaves the room

[08:08:49] Marc joins the room

[08:08:49] raucao joins the room

[08:08:54] Adrien leaves the room

[08:10:34] <Marc> My Gajim reconnected using SCRAM-SHA-512, I'm asking my contact to connect also
[08:11:08] <Marc> Ouch: Failed c2s SCRAM-SHA-512-PLUS

[08:11:28] marc leaves the room

[08:11:48] <prefiks> hm, possibly password was not stored in that type?

[08:14:17] zain leaves the room

[08:14:23] Adrien joins the room

[08:15:23] Adrien leaves the room

[08:15:24] zeank leaves the room

[08:15:47] <Marc> ```
auth_stored_password_types:
  - plain
  - scram_sha1
  - scram_sha256
  - scram_sha512
disable_sasl_scram_downgrade_protection: false
```

[08:15:58] zeank joins the room

[08:16:04] spacecat leaves the room

[08:16:23] <Marc> > hm, possibly password was not stored in that type?
I added them all of them to prevent this error and then removing the less secured ones

[08:16:34] mogad0n leaves the room

[08:17:57] rintinfinn leaves the room

[08:18:04] spacecat joins the room

[08:19:09] <Marc> > hm, possibly password was not stored in that type?
I added all of them to prevent this error and then removing the less secured ones

[08:19:48] mogad0n joins the room

[08:20:43] Adrien joins the room

[08:21:19] Qasim solimany leaves the room

[08:21:43] Adrien leaves the room

[08:21:57] chrys joins the room

[08:23:02] Qasim solimany joins the room

[08:23:33] zeank leaves the room

[08:27:42] Adrien joins the room

[08:28:42] Adrien leaves the room

[08:28:53] hexZoN3 leaves the room

[08:30:05] zeank joins the room

[08:30:46] zeank leaves the room

[08:30:58] zeank joins the room

[08:33:05] zeank leaves the room

[08:34:25] Adrien joins the room

[08:35:25] Adrien leaves the room

[08:36:01] hexZoN3 joins the room

[08:38:19] random_tester_123 joins the room

[08:39:50] Adrien joins the room

[08:40:26] neox joins the room

[08:40:50] Adrien leaves the room

[08:41:41] <Holger> prefiks, badlop: I messed with 'stun's option handling, it no longer tries to validate the input, no longer accepts non-binary strings nor IP addresses as strings, and no longer accepts unknown options. Should be fine with ejabberd but in theory could of course break other users.

[08:42:05] Adrien joins the room

[08:42:08] <Holger> Seemed acceptable to me but I can of course revert the changes if you disagree.

[08:43:05] Adrien leaves the room

[08:44:04] zeank joins the room

[08:46:42] samuel leaves the room

[08:46:53] Adrien joins the room

[08:47:53] Adrien leaves the room

[08:48:36] IGImonster joins the room

[08:49:28] <prefiks> if it works with ejabberd passed to it, i don't see a problem

[08:49:28] sander leaves the room

[08:49:33] <prefiks> with what

[08:49:52] Adrien joins the room

[08:50:52] Adrien leaves the room

[08:52:35] nutcracker500 leaves the room

[08:52:45] neox leaves the room

[08:53:26] marc joins the room

[08:53:28] marzzzello leaves the room

[08:53:42] nutcracker500 joins the room

[08:53:51] <badlop> if it's an overall improvement that may provoke some problem in specific cases, then let's document those cases and how to solve them in the relase notes/documentation

[08:53:54] tobiasd leaves the room

[08:53:54] samuel joins the room

[08:54:35] IGImonster leaves the room

[08:54:53] Adrien joins the room

[08:55:07] raucao leaves the room

[08:55:10] raucao joins the room

[08:55:12] igor joins the room

[08:55:31] <badlop> additionally, github has a feature to pin issues on top of the issue page, useful to give visibility for some weeks/months

[08:55:52] neox joins the room

[08:55:53] Adrien leaves the room

[08:56:03] Hanketsu leaves the room

[08:56:25] Hanketsu joins the room

[08:56:52] Adrien joins the room

[08:57:04] sander joins the room

[08:57:52] Adrien leaves the room

[08:58:18] Marc leaves the room

[08:58:20] igor leaves the room

[08:58:20] Marc joins the room

[08:59:42] marzzzello joins the room

[08:59:52] bio leaves the room

[09:01:01] spacecat leaves the room

[09:02:58] Adrien joins the room

[09:03:00] Titi leaves the room

[09:03:43] spacecat joins the room

[09:03:58] Adrien leaves the room

[09:04:27] <Holger> I would've kept the validation but it was executed on each and every TCP request which seemed excessive. And no easy way to do that on application startup only. And ejabberd has better validation anyway.

[09:04:49] midou joins the room

[09:05:52] <Holger> > if it's an overall improvement that may provoke some problem in specific cases, then let's document those cases and how to solve them in the relase notes/documentation
Yes I'll write up a few words 👍

[09:06:03] Adrien joins the room

[09:06:24] samuel leaves the room

[09:06:55] egnun leaves the room

[09:07:03] Adrien leaves the room

[09:08:03] rain joins the room

[09:08:07] <Marc> On a second attempt my contact successfully connected with Gajim through SCRAM-SHA-512 🥳

[09:08:09] gandalf leaves the room

[09:08:42] <Marc> Thanks for your help, I'll check everyone can connect through SCRAM and then I'll remove plain and scram-sha1 lines on the config file

[09:10:12] Adrien joins the room

[09:11:12] Adrien leaves the room

[09:11:54] marc leaves the room

[09:12:27] kinetik leaves the room

[09:12:29] kinetik joins the room

[09:13:11] maidlover joins the room

[09:13:36] leke joins the room

[09:14:00] ermete leaves the room

[09:17:05] Adrien joins the room

[09:17:18] raucao leaves the room

[09:17:21] raucao joins the room

[09:17:50] paul joins the room

[09:18:05] Adrien leaves the room

[09:19:13] chrys leaves the room

[09:19:24] APach joins the room

[09:20:30] paul leaves the room

[09:22:53] tobiasd joins the room

[09:23:56] Adrien joins the room

[09:24:56] Adrien leaves the room

[09:26:31] gandalf joins the room

[09:26:45] gooya joins the room

[09:26:46] Qasim solimany leaves the room

[09:27:01] gooya leaves the room: Disconnected: not-well-formed

[09:27:13] Qasim solimany joins the room

[09:27:52] gooya joins the room

[09:28:35] PatRiot joins the room

[09:29:21] Adrien joins the room

[09:30:21] Adrien leaves the room

[09:33:22] yellow leaves the room

[09:33:24] yellow joins the room

[09:33:35] carlos leaves the room

[09:33:38] carlos joins the room

[09:33:45] coockie leaves the room

[09:33:50] coockie joins the room

[09:34:44] Marc leaves the room

[09:35:52] Adrien joins the room

[09:36:37] kaptan leaves the room

[09:36:52] Adrien leaves the room

[09:37:30] kaptan joins the room

[09:39:01] samuel joins the room

[09:39:03] bio leaves the room

[09:39:21] bio joins the room

[09:41:54] zeank leaves the room

[09:42:48] Adrien joins the room

[09:43:07] neox leaves the room

[09:43:48] Adrien leaves the room

[09:43:52] neox joins the room

[09:47:57] dusty leaves the room

[09:48:04] Kris leaves the room

[09:48:56] Adrien joins the room

[09:49:46] zeank joins the room

[09:49:56] Adrien leaves the room

[09:50:06] zeank joins the room

[09:51:30] zeank joins the room

[09:52:11] rom1dep leaves the room

[09:53:07] akshay joins the room

[09:53:43] Kris joins the room

[09:54:48] Adrien joins the room

[09:55:48] Adrien leaves the room

[09:56:14] neox leaves the room

[09:56:22] mike joins the room

[09:56:50] Adrien joins the room

[09:57:50] Adrien leaves the room

[09:59:15] karme leaves the room

[09:59:58] jc joins the room

[10:00:56] neox joins the room

[10:01:11] rom1dep joins the room

[10:03:16] Adrien joins the room

[10:03:31] Adrian Kieß joins the room

[10:04:16] Adrien leaves the room

[10:06:24] Titi leaves the room

[10:06:26] PatRiot joins the room

[10:06:47] Adrien joins the room

[10:07:47] Adrien leaves the room

[10:09:33] nega†ive1 leaves the room

[10:09:55] nega†ive1 joins the room

[10:10:50] midou leaves the room

[10:12:17] midou joins the room

[10:13:04] Adrien joins the room

[10:13:53] Satish joins the room

[10:14:04] Adrien leaves the room

[10:14:10] <badlop> Marc: i didn't follow your conversation: is there anything in the ejabberd documentation/tutorial/release notes that could be improved/rephrased to be more clear (in addition to the "update sql schema" confusion i noticed earlier)?

[10:16:19] Marc leaves the room

[10:17:24] Marc joins the room

[10:17:48] neox leaves the room

[10:17:57] rintinfinn joins the room

[10:18:25] jc joins the room

[10:19:26] Adrien joins the room

[10:19:32] neox joins the room

[10:20:11] brian leaves the room

[10:20:26] Adrien leaves the room

[10:21:18] <Marc> Well I thought the issue was resolved but actually it's not
[10:21:44] <Marc> Previously succeeded SCRAM-SHA-512 connections are now failing

[10:22:20] writer77 joins the room

[10:22:31] gandalf joins the room

[10:23:25] jc joins the room

[10:24:10] Marc joins the room

[10:25:33] Adrien joins the room

[10:26:04] Molnija Bjornsson joins the room

[10:26:33] Adrien leaves the room

[10:26:57] jc joins the room

[10:27:18] claas leaves the room

[10:27:18] ff leaves the room

[10:27:18] nega†ive1 leaves the room

[10:28:23] jc leaves the room

[10:29:03] VC leaves the room

[10:29:19] VC joins the room

[10:30:12] prefiks leaves the room

[10:31:22] ff joins the room

[10:31:24] prefiks joins the room

[10:31:46] PatRiot leaves the room

[10:31:46] <prefiks> Marc: could you run ejabberdctl debug

[10:31:46] Adrien joins the room

[10:32:02] PatRiot joins the room

[10:32:18] jc joins the room

[10:32:46] Adrien leaves the room

[10:33:02] marc joins the room

[10:33:23] jc leaves the room

[10:33:38] <prefiks> and inside that execute ejabberd_auth:get_password(<<"your-username">>, <<"your-domain">>), and see if it returns password in plain text, or {scram, ...} and if scram if there is one with sha512

[10:34:24] Molnija Bjornsson leaves the room

[10:34:50] Molnija Bjornsson joins the room

[10:36:49] neox leaves the room

[10:36:54] jc leaves the room

[10:37:00] jesse leaves the room

[10:37:01] jesse joins the room

[10:37:05] neox joins the room

[10:37:12] IGImonster joins the room

[10:37:39] gandalf leaves the room

[10:37:47] stp leaves the room

[10:37:47] Mickaël joins the room

[10:38:01] Adrien joins the room

[10:38:33] DzajewSH leaves the room

[10:38:34] DzajewSH joins the room

[10:38:47] Mickaël leaves the room

[10:39:00] Adrien leaves the room

[10:39:35] IGImonster leaves the room

[10:42:15] jc leaves the room

[10:42:25] Holger leaves the room

[10:43:09] Alacer_dsrt leaves the room

[10:44:11] Mickaël joins the room

[10:44:48] Adrien joins the room

[10:45:11] Mickaël leaves the room

[10:45:13] EmleyMoor leaves the room

[10:45:27] claas joins the room

[10:45:47] Adrien leaves the room

[10:46:16] Titi joins the room

[10:48:45] nega†ive1 joins the room

[10:48:45] EmleyMoor joins the room

[10:49:56] nega†ive1 joins the room

[10:51:29] Adrien joins the room

[10:51:40] Mickaël joins the room

[10:52:29] Adrien leaves the room

[10:52:40] Mickaël leaves the room

[10:53:07] samuel leaves the room

[10:53:45] marc leaves the room

[10:55:55] psbsg joins the room

[10:57:20] Adrien joins the room

[10:58:20] Adrien leaves the room

[10:58:25] Mickaël joins the room

[10:59:11] Molnija Bjornsson leaves the room

[10:59:25] Mickaël leaves the room

[11:00:01] EmleyMoor leaves the room

[11:00:33] samuel joins the room

[11:00:38] insanity leaves the room

[11:00:48] insanity joins the room

[11:00:49] Molnija Bjornsson joins the room

[11:01:41] Arya Kiran leaves the room

[11:01:59] <Marc> https://xmpp-upload.framboiserouge.fr:5443/upload/a47f479db8486f77961c065bd3429aca81246ec5/C7HhCH5h3w1MqimHX6E5BsfwhfDg6MGNTuZX9zva/47869bc5-af41-4567-9ef1-9d8b8ebeaae8.png

[11:02:25] kaptan leaves the room

[11:03:11] Adrien joins the room

[11:03:14] Arya Kiran joins the room

[11:03:17] <Licaon_Kter> Put a dot at the end maybe
`ejabberd_auth:get_password(<<"your-username">>, <<"your-domain">>).`

[11:03:23] EmleyMoor joins the room

[11:03:25] fernando joins the room

[11:04:11] fernando leaves the room

[11:04:11] Adrien leaves the room

[11:04:17] hexZoN3 leaves the room

[11:04:37] hexZoN3 joins the room

[11:05:09] Mickaël joins the room

[11:05:21] <prefiks> hm, is that elixir console maybe?
[11:05:33] <prefiks> or is that shell prompt?

[11:06:09] Mickaël leaves the room

[11:06:38] <Marc> > Put a dot at the end maybe
> `ejabberd_auth:get_password(<<"your-username">>, <<"your-domain">>).`
I get again Unknown command
[11:06:39] <prefiks> if this is elixir console then try :ejabberd_auth.get_password("username", "domain")
[11:09:00] <Marc> I exited the shell and reenter in it, it is different now

[11:09:01] Adrien joins the room

[11:09:16] <Marc> https://xmpp-upload.framboiserouge.fr:5443/upload/a47f479db8486f77961c065bd3429aca81246ec5/5oRTTurqNaGOW2gdEZsPV4zgOzHXMRwCnPwXTTfI/cdbe0356-a704-4062-a901-94733d7b7de1.png
[11:09:36] <prefiks> yeah, then ejabberd_auth:get_password(<<"your-username">>, <<"your-domain">>). should work here
[11:09:39] <prefiks> with . at end
[11:09:55] <prefiks> ctrl-c twice to exit

[11:10:01] Adrien leaves the room

[11:10:20] spacecat leaves the room

[11:10:21] <Marc> I got it
[11:10:28] <Marc> The password is written in plain
[11:10:35] <Marc> With /utf8 at the end
[11:10:53] <prefiks> ok, strange then scram-512 doesn't work then
[11:11:25] <prefiks> or is that -plus is failing but non plus version is working?
[11:12:19] <Marc> I also got "Failed c2s SCRAM-SHA-512 authentication" in the logs

[11:12:35] Mickaël joins the room

[11:12:38] Marc leaves the room

[11:13:08] <prefiks> ok, will try to see if i get something like that here too

[11:13:35] Mickaël leaves the room

[11:13:59] <Marc> Thanks

[11:14:33] kaptan joins the room

[11:14:36] Marc joins the room

[11:14:45] Alacer_dsrt joins the room

[11:15:01] EmleyMoor leaves the room

[11:15:31] Adrien joins the room

[11:15:56] EmleyMoor joins the room

[11:15:59] spacecat joins the room

[11:16:31] Adrien leaves the room

[11:17:34] erik joins the room

[11:18:05] Alacer_dsrt leaves the room

[11:19:03] Mickaël joins the room

[11:20:03] Mickaël leaves the room

[11:21:14] alacer joins the room

[11:21:22] Adrien joins the room

[11:22:22] Adrien leaves the room

[11:25:35] Mickaël joins the room

[11:26:35] Mickaël leaves the room

[11:27:12] Adrien joins the room

[11:28:12] Adrien leaves the room

[11:30:46] Mickaël joins the room

[11:30:48] marc joins the room

[11:31:46] Mickaël leaves the room

[11:31:50] 孤独的小数点 joins the room

[11:31:51] <孤独的小数点> 欢迎使用 Gboard 剪贴板，您复制的所有文本都会保存到这里。

[11:31:51] IGImonster joins the room

[11:33:31] Adrien joins the room

[11:34:24] neox leaves the room

[11:34:31] Adrien leaves the room

[11:35:42] EmleyMoor leaves the room

[11:35:46] PatRiot leaves the room

[11:36:01] PatRiot joins the room

[11:36:10] maidlover leaves the room

[11:36:13] maidlover joins the room

[11:36:13] Mirror leaves the room

[11:37:21] Qasim solimany leaves the room

[11:37:23] neox joins the room

[11:37:30] EmleyMoor joins the room

[11:37:32] Mickaël joins the room

[11:38:22] alacer leaves the room

[11:38:32] Mickaël leaves the room

[11:38:44] danielepiccoli leaves the room

[11:38:50] 孤独的小数点 leaves the room

[11:38:52] 孤独的小数点 joins the room

[11:39:37] Qasim solimany joins the room

[11:39:51] Adrien joins the room

[11:40:43] rintinfinn leaves the room

[11:40:51] Adrien leaves the room

[11:41:46] Chanaka Jayalath joins the room

[11:42:44] egnun joins the room

[11:44:22] IGImonster leaves the room

[11:44:51] Mickaël joins the room

[11:45:28] gandalf leaves the room

[11:45:51] Mickaël leaves the room

[11:45:53] Adrien joins the room

[11:46:53] Adrien leaves the room

[11:47:15] rintinfinn joins the room

[11:48:36] igor joins the room

[11:48:55] rain joins the room

[11:50:46] Titi joins the room

[11:51:52] Mickaël joins the room

[11:51:58] Adrien joins the room

[11:52:50] Marc leaves the room

[11:52:52] Mickaël leaves the room

[11:52:58] Adrien leaves the room

[11:53:46] <Licaon_Kter> 孤独的小数点: Wrong chat? English only pls

[11:55:44] Titi leaves the room

[11:57:30] Titi joins the room

[11:58:11] Mickaël joins the room

[11:58:22] Adrien joins the room

[11:59:12] Mickaël leaves the room

[11:59:19] Adrien leaves the room

[12:00:16] EmleyMoor leaves the room

[12:00:57] EmleyMoor joins the room

[12:01:14] mogad0n leaves the room

[12:01:40] mogad0n joins the room

[12:02:00] prefiks leaves the room

[12:02:01] TheCoffeMaker leaves the room

[12:03:13] marc leaves the room

[12:03:20] <Kris> Also oddly backdated message?

[12:03:35] nega†ive1 leaves the room

[12:03:42] <Kris> It shows here as send yesterday, but out of order

[12:03:57] nega†ive1 joins the room

[12:03:58] zoidberg leaves the room

[12:03:58] yenemy leaves the room

[12:03:58] hallu leaves the room

[12:03:58] Qasim solimany leaves the room

[12:03:58] 孤独的小数点 leaves the room

[12:03:58] spacecat leaves the room

[12:03:58] meson leaves the room

[12:03:58] random_tester_123 leaves the room

[12:03:58] hecker3000 leaves the room

[12:03:58] meson leaves the room

[12:04:45] Adrien joins the room

[12:04:58] Adrian Kieß leaves the room

[12:05:10] Mickaël joins the room

[12:05:39] prefiks joins the room

[12:05:45] Adrien leaves the room

[12:06:10] Mickaël leaves the room

[12:08:11] gooya leaves the room: Disconnected: Replaced by new connection

[12:08:16] gooya joins the room

[12:08:18] TheCoffeMaker joins the room

[12:10:21] PatRiot leaves the room

[12:10:33] gooya leaves the room: Disconnected: Replaced by new connection

[12:10:55] gooya joins the room

[12:10:58] Adrien joins the room

[12:11:41] samuel leaves the room

[12:11:54] Mickaël joins the room

[12:11:58] Adrien leaves the room

[12:12:42] Squeaky Latex Folf joins the room

[12:12:54] Mickaël leaves the room

[12:14:09] neox leaves the room

[12:14:10] savagepeanut leaves the room

[12:16:07] Marc joins the room

[12:17:48] Adrien joins the room

[12:18:39] Mickaël joins the room

[12:18:48] Adrien leaves the room

[12:19:39] Mickaël leaves the room

[12:19:42] gooya leaves the room: Disconnected: Replaced by new connection

[12:19:47] karme joins the room

[12:19:55] gooya joins the room

[12:21:22] samuel joins the room

[12:24:27] Adrien joins the room

[12:25:07] Chanaka Jayalath leaves the room

[12:25:09] john leaves the room

[12:25:17] Mickaël joins the room

[12:25:27] Adrien leaves the room

[12:25:28] john leaves the room

[12:26:02] TheCoffeMaker leaves the room

[12:26:17] Mickaël leaves the room

[12:26:31] TheCoffeMaker joins the room

[12:26:56] gooya leaves the room

[12:27:11] gooya joins the room

[12:30:14] <prefiks> Marc: i tried couple times with user which have only plain password stored, and sha-512 auth seems to be working

[12:30:32] Adrien joins the room

[12:31:03] <prefiks> you said you have /utf8 in that get_password - do you have password with char outside ascii in it?

[12:31:24] raucao leaves the room

[12:31:27] raucao joins the room

[12:31:32] Adrien leaves the room

[12:31:58] Mickaël joins the room

[12:32:54] Chanaka Jayalath joins the room

[12:32:58] Mickaël leaves the room

[12:34:16] <Marc> prefiks: the command returns [<<"my_password"/utf8>>]

[12:34:54] gooya leaves the room: Disconnected: Replaced by new connection

[12:35:07] gooya joins the room

[12:35:11] <Marc> But I found something very strange: it returns my password when I test it on my own account but for every other accounts of my server it returns false
[12:35:17] <prefiks> ok, but do you have any character in your password that is outside a-z? some diacritics, or something like that?
[12:35:33] <prefiks> hm, now that strange
[12:36:15] <Marc> > ok, but do you have any character in your password that is outside a-z? some diacritics, or something like that?
Yes, there is numbers, special characters, diacritics and even a "
[12:36:30] <prefiks> ok

[12:36:32] Adrien joins the room

[12:37:32] Adrien leaves the room

[12:37:33] <prefiks> could you run ejabberd_sql:sql_query(<<"your-domain">>, <<"select * from users">>). (or you can run "select * from users" if you have access to console on your db), and see if there ary entries for other users?

[12:38:31] Mickaël joins the room

[12:38:40] IGImonster joins the room

[12:39:31] Mickaël leaves the room

[12:41:16] snowstorm joins the room

[12:42:24] Adrien joins the room

[12:42:31] neox leaves the room

[12:43:17] IGImonster leaves the room

[12:43:24] Adrien leaves the room

[12:44:55] <Marc> There is no return
```
MariaDB [ejabberd]> "SELECT * FROM USERS"
->
```
[12:45:04] <prefiks> ;

[12:45:04] brian joins the room

[12:45:34] <prefiks> i mean press ; and enter

[12:45:55] Mickaël joins the room

[12:45:57] <Marc> Right
[12:46:14] <Marc> Oups the server doesn't authentificate with mysql
[12:46:22] <prefiks> ah
[12:46:24] <Marc> Oups the server doesn't authenticate with mysql

[12:46:34] jc leaves the room

[12:46:37] <Marc> But with LDAP

[12:46:37] neox joins the room

[12:46:44] <prefiks> ah

[12:46:55] Mickaël leaves the room

[12:47:32] random_tester_123 joins the room

[12:47:38] marc joins the room

[12:47:47] stp joins the room

[12:47:53] <Marc> Sorry I was confused because there is SQL for the other data

[12:48:52] eevvoor joins the room

[12:49:10] Adrien joins the room

[12:49:11] Holger joins the room

[12:49:15] <prefiks> ldap doesn't have get_password, authentication here is performed by ldap server, so ejabberd doesn't get to know password here

[12:49:18] hallu joins the room

[12:49:41] ffunk joins the room

[12:50:07] <prefiks> i am guessing you have also some other backend for auth enabled and that why you get password for one user - it has password set in that other backend

[12:50:10] Adrien leaves the room

[12:50:29] <Marc> > i am guessing you have also some other backend for auth enabled and that why you get password for one user - it has password set in that other backend
Yes my server runs YunoHost

[12:51:22] zoidberg joins the room

[12:51:23] <prefiks> i don't think you have scram-sha-512 working with ldap, as password check is performed by ldap server, and that doesn't know how to do that
[12:51:55] <Marc> When I started it there was Metronome as XMPP server but it was unmaintained and I already had ejabberd experience so I reinstalled it and manually connected it to LDAP backend

[12:52:24] kaptan leaves the room

[12:52:34] <prefiks> for ldap you pretty much need to have plain password

[12:52:38] Adrien joins the room

[12:52:57] Mickaël joins the room

[12:52:59] hecker3000 joins the room

[12:53:32] <Marc> Ok, but according to Wikipedia LDAP is compatible with SCRAM: https://en.wikipedia.org/wiki/Salted_Challenge_Response_Authentication_Mechanism
[12:53:35] <prefiks> some ldap server can use scram, but from what i remember it's not compatible with how xmpp works - different usernames are used by both

[12:53:38] Adrien leaves the room

[12:53:48] <Marc> Ok

[12:53:57] Mickaël leaves the room

[12:54:18] ffunk leaves the room

[12:54:29] Satish leaves the room

[12:54:37] meson joins the room

[12:54:51] <Marc> So if I want SCRAM I have to disconnect ejabberd from LDAP and add MariaDB for authentication

[12:55:13] Furyan leaves the room

[12:55:14] Furyan joins the room

[12:56:07] <prefiks> yes, i will check if we could use scram on ldap, but iirc ldap in it's check uses username, and on xmpp it's username@domain, and calculated hashed aren't the same
[12:57:10] <Marc> Ok thank you

[12:57:20] Chanaka Jayalath leaves the room

[12:58:57] Adrien joins the room

[12:59:43] Mickaël joins the room

[12:59:57] Adrien leaves the room

[13:00:43] Mickaël leaves the room

[13:00:53] Chanaka Jayalath joins the room

[13:01:01] spacecat joins the room

[13:01:02] rintinfinn leaves the room

[13:01:38] Chanaka Jayalath leaves the room

[13:02:27] kaptan joins the room

[13:02:33] igor leaves the room

[13:05:46] Marc leaves the room

[13:06:35] midou leaves the room

[13:06:51] Mickaël joins the room

[13:07:25] Adrien joins the room

[13:07:51] Mickaël leaves the room

[13:08:25] Adrien leaves the room

[13:08:47] Mirror joins the room

[13:09:22] Ramiro Romani joins the room

[13:09:42] kinetik leaves the room

[13:09:54] spacecat leaves the room

[13:11:26] reso leaves the room

[13:11:33] 孤独的小数点 joins the room

[13:11:44] reso joins the room

[13:13:03] spacecat joins the room

[13:13:40] Adrien joins the room

[13:14:04] Mickaël joins the room

[13:14:40] Adrien leaves the room

[13:15:04] Mickaël leaves the room

[13:15:10] Satish joins the room

[13:15:16] stp leaves the room

[13:15:37] stp joins the room

[13:16:06] savagepeanut joins the room

[13:16:48] 孤独的小数点 leaves the room

[13:16:51] 孤独的小数点 joins the room

[13:17:26] Titi leaves the room

[13:17:58] Titi joins the room

[13:18:26] kinetik joins the room

[13:19:39] Adrien joins the room

[13:19:40] qsx leaves the room

[13:20:26] random_tester_123 leaves the room

[13:20:39] Adrien leaves the room

[13:21:11] j.r joins the room

[13:21:28] Mickaël joins the room

[13:22:14] 孤独的小数点 leaves the room

[13:22:18] 孤独的小数点 joins the room

[13:22:27] midou joins the room

[13:22:28] Mickaël leaves the room

[13:23:03] egnun leaves the room

[13:23:57] egnun joins the room

[13:24:51] Chanaka Jayalath joins the room

[13:24:58] Squeaky Latex Folf leaves the room

[13:25:08] Squeaky Latex Folf joins the room

[13:27:33] Adrien joins the room

[13:28:33] Mickaël joins the room

[13:28:33] Adrien leaves the room

[13:28:49] karme leaves the room

[13:29:17] Satish leaves the room

[13:29:33] Mickaël leaves the room

[13:29:35] isotelo joins the room

[13:31:04] qy leaves the room

[13:31:11] 孤独的小数点 leaves the room

[13:31:18] karme joins the room

[13:31:33] qy joins the room

[13:32:27] random_tester_123 joins the room

[13:32:45] rom1dep joins the room

[13:33:45] Adrien joins the room

[13:34:37] qy leaves the room

[13:34:45] Adrien leaves the room

[13:35:09] Mickaël joins the room

[13:35:20] qy joins the room

[13:36:05] jjj333_p (any pronouns) leaves the room

[13:36:09] Mickaël leaves the room

[13:37:19] john joins the room

[13:37:34] john joins the room

[13:37:35] Adrien joins the room

[13:38:35] Adrien leaves the room

[13:39:03] jjj333_p (any pronouns) joins the room

[13:40:38] Adrien joins the room

[13:40:43] Adrien joins the room

[13:41:02] Ramiro Romani leaves the room

[13:41:25] PatRiot joins the room

[13:41:38] Adrien leaves the room

[13:41:38] prefiks leaves the room

[13:41:43] Adrien leaves the room

[13:41:59] Mickaël joins the room

[13:42:23] Mirror leaves the room

[13:42:59] Mickaël leaves the room

[13:43:12] Mirror joins the room

[13:43:43] Adrien joins the room

[13:44:43] Adrien leaves the room

[13:45:04] Kris joins the room

[13:46:43] zoidberg leaves the room

[13:46:44] Adrien joins the room

[13:47:40] Adrien joins the room

[13:47:44] Adrien leaves the room

[13:48:40] Adrien leaves the room

[13:48:41] Mickaël joins the room

[13:49:16] St0ne leaves the room

[13:49:33] inkey leaves the room

[13:49:41] Mickaël leaves the room

[13:49:44] Adrien joins the room

[13:50:42] Satish joins the room

[13:50:43] Adrien leaves the room

[13:51:26] barlas joins the room

[13:52:43] Adrien joins the room

[13:53:14] nutcracker500 joins the room

[13:53:25] Satish leaves the room

[13:53:44] Adrien leaves the room

[13:53:53] bio joins the room

[13:54:50] Satish joins the room

[13:55:13] gandalf joins the room

[13:55:43] Adrien joins the room

[13:55:55] Mickaël joins the room

[13:56:04] spacecat leaves the room

[13:56:39] Adrian Kieß joins the room

[13:56:43] Adrien leaves the room

[13:56:48] Adrien joins the room

[13:56:55] Mickaël leaves the room

[13:57:48] Adrien leaves the room

[13:58:07] spacecat joins the room

[13:58:09] hexZoN3 leaves the room

[13:58:26] EmleyMoor leaves the room

[13:58:35] neox joins the room

[13:58:37] prefiks joins the room

[13:58:43] Adrien joins the room

[13:59:02] reso leaves the room

[13:59:43] Adrien leaves the room

[14:01:44] Adrien joins the room

[14:01:50] EmleyMoor joins the room

[14:02:43] Adrien leaves the room

[14:02:45] Adrien joins the room

[14:03:10] Jeroen joins the room

[14:03:12] Jeroen leaves the room

[14:03:21] gandalf leaves the room

[14:03:38] Mickaël joins the room

[14:03:45] Adrien leaves the room

[14:04:00] stp leaves the room

[14:04:15] reso joins the room

[14:04:38] Mickaël leaves the room

[14:04:43] Adrien joins the room

[14:04:56] akshay leaves the room

[14:05:06] Qasim solimany joins the room

[14:05:14] gandalf joins the room

[14:05:43] Adrien leaves the room

[14:06:47] satish joins the room

[14:06:52] uira leaves the room

[14:06:56] uira joins the room

[14:07:43] Adrien joins the room

[14:08:19] terminaldweller leaves the room

[14:08:26] zoidberg joins the room

[14:08:43] Adrien leaves the room

[14:09:23] Adrien joins the room

[14:09:23] Chanaka Jayalath leaves the room

[14:10:23] Adrien leaves the room

[14:10:44] Adrien joins the room

[14:11:08] Mickaël joins the room

[14:11:44] Adrien leaves the room

[14:12:08] Mickaël leaves the room

[14:12:24] kaptan leaves the room

[14:12:33] midou leaves the room

[14:12:35] Satish leaves the room

[14:12:39] pod leaves the room

[14:12:45] spacecat leaves the room

[14:12:56] barlas leaves the room

[14:13:15] midou joins the room

[14:13:38] gooya leaves the room

[14:13:44] Adrien joins the room

[14:13:52] gooya joins the room

[14:14:12] spacecat joins the room

[14:14:19] bio leaves the room

[14:14:44] Adrien leaves the room

[14:15:56] Satish joins the room

[14:15:59] Adrien joins the room

[14:16:59] Adrien leaves the room

[14:17:40] Mickaël joins the room

[14:18:19] Adrien joins the room

[14:18:40] Mickaël leaves the room

[14:19:19] Adrien leaves the room

[14:19:41] bio leaves the room

[14:19:42] bio joins the room

[14:20:18] bio joins the room

[14:20:24] Benson joins the room

[14:21:38] schäfchen726 joins the room

[14:21:47] j.r leaves the room

[14:22:27] kaptan joins the room

[14:23:29] mogad0n leaves the room

[14:24:20] raucao leaves the room

[14:24:24] raucao joins the room

[14:24:29] Mickaël joins the room

[14:24:43] Adrien joins the room

[14:25:29] Mickaël leaves the room

[14:25:43] Adrien leaves the room

[14:26:04] mightyBroccoli joins the room

[14:26:27] ave leaves the room

[14:27:17] PatRiot leaves the room

[14:28:49] mogad0n joins the room

[14:29:08] Qasim solimany leaves the room

[14:30:36] Adrien joins the room

[14:30:50] Mickaël joins the room

[14:31:36] Adrien leaves the room

[14:31:48] ave joins the room

[14:31:50] Mickaël leaves the room

[14:32:32] rain leaves the room

[14:32:43] Ramiro Romani joins the room

[14:34:29] Satish leaves the room

[14:35:09] Satish joins the room

[14:36:29] Qasim solimany joins the room

[14:36:36] Adrien joins the room

[14:36:43] inkey joins the room

[14:36:50] Mickaël joins the room

[14:37:11] Adrien joins the room

[14:37:36] Adrien leaves the room

[14:37:50] Mickaël leaves the room

[14:38:22] Adrien leaves the room: offline

[14:39:02] mogad0n leaves the room

[14:39:02] Citlali leaves the room

[14:39:50] Jeroen joins the room

[14:39:51] Jeroen leaves the room

[14:39:52] debacle leaves the room

[14:41:59] neox leaves the room

[14:42:35] Lazarus leaves the room

[14:42:41] Lazarus joins the room

[14:43:07] mirux leaves the room

[14:43:10] Mickaël joins the room

[14:43:12] nutcracker500 leaves the room

[14:43:21] Adrien joins the room

[14:44:10] Mickaël leaves the room

[14:44:13] Lazarus leaves the room

[14:44:15] serafean leaves the room

[14:44:19] Lazarus joins the room

[14:44:21] Adrien leaves the room

[14:45:32] nutcracker500 joins the room

[14:45:54] neox joins the room

[14:46:01] Mickaël joins the room

[14:46:30] reso leaves the room

[14:46:50] reso joins the room

[14:46:55] Holger leaves the room

[14:47:01] Qasim solimany leaves the room

[14:47:01] Mickaël leaves the room

[14:47:25] rain joins the room

[14:48:11] qsx joins the room

[14:49:17] Adrien joins the room

[14:49:17] terminaldweller joins the room

[14:49:21] km leaves the room

[14:50:17] Adrien leaves the room

[14:52:46] Mickaël joins the room

[14:53:46] Mickaël leaves the room

[14:53:47] psbsg leaves the room

[14:53:53] km joins the room

[14:55:35] igor leaves the room

[14:55:45] Adrien joins the room

[14:56:22] gandalf leaves the room

[14:56:45] Adrien leaves the room

[14:59:38] Mickaël joins the room

[15:00:37] Satish leaves the room

[15:00:38] Mickaël leaves the room

[15:01:22] Satish joins the room

[15:01:43] hammock-backer leaves the room

[15:01:45] mirux leaves the room: Disconnected: Received SIGTERM

[15:01:57] debacle joins the room

[15:02:25] Adrien joins the room

[15:03:25] Adrien leaves the room

[15:04:08] hammock-backer joins the room

[15:06:04] mogad0n joins the room

[15:06:10] Mickaël joins the room

[15:06:46] mirux joins the room

[15:07:11] Mickaël leaves the room

[15:07:49] nutcracker500 leaves the room

[15:08:19] Satish leaves the room

[15:08:29] marc leaves the room

[15:08:32] marc joins the room

[15:08:54] Satish joins the room

[15:10:09] Adrien joins the room

[15:11:09] Adrien leaves the room

[15:11:22] Alexander leaves the room

[15:11:46] Alexander joins the room

[15:12:19] mogad0n leaves the room

[15:12:49] spacecat leaves the room

[15:13:40] Mickaël joins the room

[15:14:40] Mickaël leaves the room

[15:15:39] spacecat joins the room

[15:15:48] rain leaves the room

[15:17:19] Qasim solimany joins the room

[15:17:57] savagepeanut leaves the room

[15:18:41] savagepeanut joins the room

[15:19:21] Adrien joins the room

[15:19:50] robert_mobil leaves the room

[15:20:21] Adrien leaves the room

[15:20:45] Mickaël joins the room

[15:21:33] Arya Kiran leaves the room

[15:21:36] Chanaka Jayalath leaves the room

[15:21:45] Chanaka Jayalath joins the room

[15:21:45] Mickaël leaves the room

[15:21:51] nutcracker500 joins the room

[15:22:00] gandalf joins the room

[15:23:45] hexZoN3 joins the room

[15:24:29] Ramiro Romani leaves the room

[15:25:13] Adrien joins the room

[15:26:12] mike_ joins the room

[15:26:14] Adrien leaves the room

[15:27:54] hydrogen joins the room

[15:28:16] Mickaël joins the room

[15:28:37] igor joins the room

[15:29:16] Mickaël leaves the room

[15:30:37] catchy leaves the room: Disconnected: Hibernating too long

[15:31:12] danielepiccoli joins the room

[15:31:23] Adrien joins the room

[15:31:48] 孤独的小数点 joins the room

[15:32:27] Adrien leaves the room

[15:32:31] <hydrogen> mm, just upgraded my system a few minutes ago and rebooted, and now i can't log into my account
[15:32:42] <hydrogen> gives me and incorrect password error, and when i try to change the password from ejabberdctl it says unknown user
[15:33:00] <hydrogen> trying to register the user says it already exists, and listing the users lists the users fine
[15:33:18] <hydrogen> trying to access the admin webui just makes it reset the connection, too...

[15:33:37] Ramiro Romani joins the room

[15:33:50] <hydrogen> `lsof` shows several established connections but trying to message my JID from this account gives me "service-unavailable"

[15:33:51] reso leaves the room

[15:34:10] <prefiks> did you upgrade database schema? could you check ejabberd.log to see if there are any errors?

[15:34:25] reso leaves the room

[15:34:31] reso joins the room

[15:35:16] Citlali joins the room

[15:35:26] reso joins the room

[15:35:27] <hydrogen> well there sure are a lot of invalid password errors in my log

[15:35:30] Mickaël joins the room

[15:35:34] <hydrogen> i didn't touch the db, i had no idea i was supposed to
[15:36:30] <prefiks> could you check what auth_method: you have listed in your ejabber.yml config file?

[15:36:31] Mickaël leaves the room

[15:37:13] 孤独的小数点 leaves the room

[15:37:21] Adrien joins the room

[15:37:29] neox leaves the room

[15:37:36] jesse joins the room

[15:37:58] marc leaves the room

[15:38:00] <hydrogen> nothing in there for auth_method

[15:38:21] Adrien leaves the room

[15:38:27] <hydrogen> i have `auth_password_format: scram` and `auth_scram_hash: sha`, i assume they're related

[15:38:35] gooya leaves the room

[15:38:40] gooya joins the room

[15:39:12] <prefiks> do you have default_db: in there?
[15:39:47] <prefiks> auth_method will tell us what db type is used your server
[15:39:54] <hydrogen> i'm using sqlite
[15:40:13] <hydrogen> ```
default_db: sql
sql_type: sqlite
new_sql_schema: true
sql_database: /opt/ejabberd/database/db.sqlite3
```
i believe this is all related
[15:40:20] <prefiks> yep
[15:40:42] <hydrogen> gimme a sec, i'll remove the secrets from my config
[15:40:51] <prefiks> no not needed
[15:41:00] <hydrogen> aight
[15:41:52] <prefiks> so you can find instuction for schema upgrades here: https://docs.ejabberd.im/archive/25.03/upgrade/
[15:42:01] <hydrogen> thanks, i'll take a look

[15:42:21] 孤独的小数点 joins the room

[15:42:36] schäfchen726 leaves the room

[15:42:40] Mickaël joins the room

[15:43:00] Citlali leaves the room

[15:43:01] <hydrogen> and...what do i do with this?

[15:43:04] sezuan joins the room

[15:43:11] <prefiks> unfortunatelly automatic upgrade has problem on sqlite in released version, that i did fix today
[15:43:11] <hydrogen> ah i think i figured it
[15:43:18] <hydrogen> ...ah.

[15:43:30] Citlali joins the room

[15:43:31] <hydrogen> in that case i'm completely lost

[15:43:40] Mickaël leaves the room

[15:44:23] Mirror leaves the room

[15:44:42] Qasim solimany leaves the room

[15:44:49] Marc joins the room

[15:44:55] Adrien joins the room

[15:45:01] Citlali leaves the room

[15:45:05] Citlali joins the room

[15:45:39] <hydrogen> so like what do i do with this block of SQL commands
[15:45:42] <prefiks> you can do that using sqlite3 command line, should be also possible to trigger that from ejabberd, one sec

[15:45:55] Adrien leaves the room

[15:47:19] christian joins the room

[15:47:46] meson joins the room

[15:49:22] stp joins the room

[15:49:31] Mickaël joins the room

[15:50:28] 孤独的小数点 leaves the room

[15:50:28] lucas leaves the room

[15:50:31] Mickaël leaves the room

[15:51:00] Adrien joins the room

[15:51:09] <prefiks> could you check your ejabberd logs and see if you have "Error while processing SQL query result:" in there?

[15:52:00] Adrien leaves the room

[15:52:54] Mirror joins the room

[15:53:09] marc joins the room

[15:54:23] <hydrogen> `ejabberd.log`?
[15:54:36] <prefiks> yes

[15:54:41] nutcracker500 leaves the room

[15:55:20] <hydrogen> oh yeah there's a ton
[15:55:28] <hydrogen> 19 lines

[15:56:15] Mickaël joins the room

[15:56:28] <prefiks> could you please copy/paste one of those log entries?
[15:56:38] <hydrogen> if i can find one without grep, sure

[15:56:54] meson leaves the room

[15:57:10] Adrien joins the room

[15:57:15] Mickaël leaves the room

[15:57:24] 孤独的小数点 joins the room

[15:57:39] <hydrogen> here we go
[15:57:42] <hydrogen> ```
2025-03-31 16:12:21.759944+01:00 [error] <0.474.0>@ejabberd_sql:sql_query_format_res/2:940 Error while processing SQL query result:
** Row: [<<"TIroWHH9Ukxeb5I6BX5M8FOQ4bY=">>,
         <<"p7MAYqH1g1iv5fb2vihVGrZGXDc=">>,
         <<"MTk4NTg0NWQtOTMwYy00ZDViLTgwODctMTFlNTUzNzBlNjM1">>,<<"10000">>,
         <<"2024-11-17 21:25:56">>]
** exception error: bad argument
   in function  binary_to_integer/1
      called as binary_to_integer(<<"TIroWHH9Ukxeb5I6BX5M8FOQ4bY=">>)
      *** argument 1: not a textual representation of an integer
   in call from ejabberd_auth_sql:'-get_password_scram/2-fun-1-'/1 (src/ejabberd_auth_sql.erl, line 307)
   in call from ejabberd_sql:'-sql_query_format_res/2-fun-0-'/2 (src/ejabberd_sql.erl, line 936)
   in call from lists:flatmap_1/2 (lists.erl, line 2116)
   in call from ejabberd_sql:sql_query_format_res/2 (src/ejabberd_sql.erl, line 933)
   in call from ejabberd_sql:sql_query_internal/1 (src/ejabberd_sql.erl, line 735)
   in call from ejabberd_sql:run_sql_cmd/4 (src/ejabberd_sql.erl, line 547)
   in call from p1_fsm:handle_msg/10 (/home/runner/work/ejabberd/ejabberd/deps/p1_utils/src/p1_fsm.erl, line 582)
```

[15:58:10] Adrien leaves the room

[15:58:34] <prefiks> ok, so you got hit with auto upgrade error, let me prepare something that can be used to fix this

[15:58:35] qy joins the room

[15:59:11] Drakfot joins the room

[15:59:13] marc leaves the room

[15:59:23] Drakfot leaves the room

[16:00:37] Citlali leaves the room

[16:00:43] Adrien joins the room

[16:01:43] Adrien leaves the room

[16:02:14] Wojtek joins the room

[16:02:18] Ramiro Romani leaves the room

[16:02:32] Kris leaves the room

[16:02:47] Mickaël joins the room

[16:02:57] debalance leaves the room

[16:03:00] igor joins the room

[16:03:38] stp leaves the room

[16:03:43] mirux joins the room

[16:03:47] Mickaël leaves the room

[16:04:39] midou leaves the room

[16:05:02] Ramiro Romani joins the room

[16:05:32] midou joins the room

[16:05:58] Manis leaves the room

[16:05:59] Manis joins the room

[16:06:39] meson joins the room

[16:06:40] Adrien joins the room

[16:07:30] marc joins the room

[16:07:40] Adrien leaves the room

[16:07:58] reso leaves the room

[16:08:12] nutcracker500 joins the room

[16:08:30] reso joins the room

[16:08:34] Kris joins the room

[16:08:42] pitchum joins the room

[16:08:49] pitchum leaves the room

[16:09:16] 孤独的小数点 leaves the room

[16:09:18] Mickaël joins the room

[16:10:18] Mickaël leaves the room

[16:10:32] mirux joins the room

[16:10:54] mirux leaves the room

[16:11:25] mirux joins the room

[16:11:43] mirux leaves the room: Disconnected: Replaced by new connection

[16:11:46] christian leaves the room

[16:12:13] mirux joins the room

[16:12:34] Xi leaves the room

[16:12:36] nito joins the room

[16:12:38] Xi joins the room

[16:12:41] Adrien joins the room

[16:12:56] nito leaves the room

[16:13:41] Adrien leaves the room

[16:13:55] chrys joins the room

[16:13:56] mirux leaves the room

[16:14:04] pitchum leaves the room

[16:14:27] gs joins the room

[16:14:43] midou leaves the room

[16:14:58] inkey leaves the room

[16:15:02] christian joins the room

[16:15:14] midou joins the room

[16:16:12] Mickaël joins the room

[16:16:54] Satish leaves the room

[16:17:13] Mickaël leaves the room

[16:17:13] Citlali joins the room

[16:17:56] meson leaves the room

[16:18:00] zoidberg leaves the room

[16:18:30] igor leaves the room

[16:18:47] terminaldweller leaves the room

[16:19:02] Adrien joins the room

[16:19:04] meson joins the room

[16:19:31] mirux leaves the room

[16:19:51] zeank leaves the room

[16:19:53] zeank joins the room

[16:19:56] terminaldweller joins the room

[16:20:02] Adrien leaves the room

[16:21:00] zeank leaves the room

[16:21:09] zeank joins the room

[16:21:26] Squeaky Latex Folf leaves the room

[16:21:39] ij joins the room

[16:21:51] satish leaves the room

[16:21:54] <prefiks> hydrogen: start ejabberd debug console with 'ejabberdctl debug'
[16:22:01] <hydrogen> yup
[16:22:29] <hydrogen> yummy erlang shell
[16:22:30] <prefiks> and in that type:
ejabberd_sql:sql_query(<<"your-domain-name">>, <<"update users set type=created_at, password=type, serverkey=password,salt=serverkey,iterationcount=salt,created_at=iterationcount">>).

[16:22:39] Mickaël joins the room

[16:22:50] <prefiks> just change to domain that you are using
[16:22:54] <hydrogen> only substitute `your-domain-name`, i assume?
[16:22:58] <prefiks> yes
[16:23:17] <hydrogen> {updated,35}
[16:23:19] <hydrogen> seems like it worked
[16:23:29] <prefiks> see if you can login

[16:23:39] Mickaël leaves the room

[16:23:41] <prefiks> hm, you may need to clear auth cache first
[16:23:53] <hydrogen> i cannot log in
[16:23:57] <hydrogen> you may be correct
[16:24:02] <prefiks> one sec

[16:24:38] Adrien joins the room

[16:24:55] serafean joins the room

[16:25:30] <prefiks> ets_cache:clear(ejabberd_auth_sql_cache).
[16:25:33] <prefiks> in debug console

[16:25:38] Adrien leaves the room

[16:25:41] <hydrogen> `ok`
[16:25:42] <hydrogen> let's see
[16:25:55] <hydrogen> ayyyy it works
[16:25:56] <hydrogen> thanks
[16:25:59] <prefiks> cool

[16:26:31] hydrogen leaves the room

[16:26:33] hydrogen joins the room

[16:28:08] Neustradamus joins the room

[16:29:18] PatRiot joins the room

[16:29:43] Mickaël joins the room

[16:30:43] Mickaël leaves the room

[16:30:57] Adrien joins the room

[16:31:27] kapad joins the room

[16:31:29] Ramiro Romani leaves the room

[16:31:42] <Marc> Hi, I'm planning to switch auth backend from LDAP to SQL

[16:31:57] Adrien leaves the room

[16:33:16] hexZoN3 leaves the room

[16:33:24] <Marc> I think assign to each user a temporary password and change all of them before the switch, then recreating all the accounts using the actual usernames and temporary passwords, finally let them change their password through in-band-registration

[16:33:25] PatRiot leaves the room

[16:33:49] <Marc> Would this permit to make the switch ass painless as possible ?

[16:35:02] karme leaves the room

[16:35:51] midou leaves the room

[16:36:09] karme joins the room

[16:36:40] Mickaël joins the room

[16:36:47] nutcracker500 leaves the room

[16:36:58] raucao leaves the room

[16:37:00] raucao joins the room

[16:37:13] alacer joins the room

[16:37:34] Adrien joins the room

[16:37:40] Mickaël leaves the room

[16:37:46] zain joins the room

[16:37:58] alacer leaves the room

[16:38:19] sachaobado leaves the room

[16:38:34] william.chatner joins the room

[16:38:34] Adrien leaves the room

[16:38:49] alacer joins the room

[16:38:53] terminaldweller leaves the room

[16:39:05] hydrogen leaves the room

[16:39:29] gs leaves the room

[16:39:38] alacer leaves the room

[16:43:34] PatRiot joins the room

[16:43:45] qsx leaves the room

[16:43:51] nutcracker500 joins the room

[16:44:01] Adrien joins the room

[16:44:04] karme leaves the room

[16:44:25] Mickaël joins the room

[16:45:01] Adrien leaves the room

[16:45:25] Mickaël leaves the room

[16:46:03] spacecat leaves the room

[16:47:54] rain joins the room

[16:48:06] spacecat joins the room

[16:48:42] rain joins the room

[16:49:24] midou joins the room

[16:50:18] deimosBSD joins the room

[16:50:24] deimosBSD joins the room

[16:50:39] Adrien joins the room

[16:51:00] Mickaël joins the room

[16:51:39] Adrien leaves the room

[16:51:47] qsx joins the room

[16:52:00] Mickaël leaves the room

[16:52:53] deimosBSD leaves the room

[16:54:10] <Marc> _*as painless_ sorry

[16:55:24] meson leaves the room

[16:55:59] leke leaves the room

[16:56:16] leke joins the room

[16:56:43] rain leaves the room

[16:57:14] Adrien joins the room

[16:57:42] Mickaël joins the room

[16:58:14] Adrien leaves the room

[16:58:30] terminaldweller joins the room

[16:58:41] reso leaves the room

[16:58:42] Mickaël leaves the room

[16:58:55] reso joins the room

[17:00:02] pitchum joins the room

[17:00:48] igor leaves the room

[17:01:20] Ramiro Romani joins the room

[17:02:52] gs joins the room

[17:03:21] Adrien joins the room

[17:04:21] Adrien leaves the room

[17:04:24] zoidberg joins the room

[17:05:16] Mickaël joins the room

[17:05:59] pitchum leaves the room

[17:06:16] Mickaël leaves the room

[17:06:24] nutcracker500 leaves the room

[17:08:26] Wojtek leaves the room

[17:08:26] igor joins the room

[17:09:22] Adrien joins the room

[17:10:22] Adrien leaves the room

[17:10:27] midou leaves the room

[17:10:29] zoidberg leaves the room

[17:10:55] midou joins the room

[17:11:02] PatRiot leaves the room

[17:11:08] hallu leaves the room

[17:11:09] hallu joins the room

[17:12:07] PatRiot joins the room

[17:12:09] Wojtek joins the room

[17:12:44] Mickaël joins the room

[17:13:44] Mickaël leaves the room

[17:14:45] pitchum joins the room

[17:14:50] Wojtek leaves the room

[17:15:15] Adrien joins the room

[17:15:30] neox joins the room

[17:15:54] gratuxri joins the room

[17:15:59] gratuxri leaves the room

[17:16:15] Adrien leaves the room

[17:16:22] mirux leaves the room

[17:16:52] pitchum leaves the room

[17:17:35] pitchum joins the room

[17:20:05] PatRiot leaves the room

[17:20:10] Mickaël joins the room

[17:20:54] qsx leaves the room

[17:21:10] Mickaël leaves the room

[17:21:15] Adrien joins the room

[17:21:34] Citlali leaves the room

[17:21:37] gs leaves the room

[17:21:50] gs joins the room

[17:22:15] Adrien leaves the room

[17:25:23] Wojtek joins the room

[17:26:16] badlop leaves the room

[17:26:54] Mickaël joins the room

[17:27:54] Mickaël leaves the room

[17:28:22] Adrien joins the room

[17:28:40] pitchum leaves the room

[17:29:22] Adrien leaves the room

[17:29:29] IGImonster joins the room

[17:29:58] pitchum joins the room

[17:30:16] rom1dep leaves the room

[17:32:45] Adrien joins the room

[17:33:15] deimosBSD leaves the room

[17:33:22] pitchum leaves the room

[17:33:26] ij leaves the room

[17:33:40] Mickaël joins the room

[17:33:45] Adrien leaves the room

[17:34:40] Mickaël leaves the room

[17:35:59] raucao leaves the room

[17:36:00] raucao joins the room

[17:38:28] ermete joins the room

[17:38:32] Mickaël joins the room

[17:39:12] Adrien joins the room

[17:39:32] Mickaël leaves the room

[17:40:12] Adrien leaves the room

[17:41:17] debacle leaves the room

[17:42:37] prefiks leaves the room

[17:42:41] gooya leaves the room

[17:42:57] spacecat leaves the room

[17:42:58] gooya joins the room

[17:43:36] ij joins the room

[17:43:51] marc leaves the room

[17:44:42] marc joins the room

[17:45:06] Mickaël joins the room

[17:45:44] Adrien joins the room

[17:45:56] hexZoN3 joins the room

[17:46:26] qsx joins the room

[17:46:41] gs leaves the room

[17:46:44] Adrien leaves the room

[17:46:54] mirux joins the room

[17:46:54] Mickaël leaves the room

[17:46:55] gratuxri joins the room

[17:47:21] gratuxri leaves the room

[17:47:22] Mickaël joins the room

[17:47:35] spacecat joins the room

[17:48:22] Mickaël leaves the room

[17:48:31] gratuxri joins the room

[17:48:32] gs joins the room

[17:49:11] gs leaves the room

[17:50:51] marc leaves the room

[17:51:44] rain leaves the room

[17:52:10] Adrien joins the room

[17:53:10] Adrien leaves the room

[17:53:29] neox leaves the room

[17:53:46] Mickaël joins the room

[17:54:46] Mickaël leaves the room

[17:55:00] neox joins the room

[17:55:36] jc joins the room

[17:55:49] insanity leaves the room

[17:55:58] Ramiro Romani leaves the room

[17:56:07] insanity joins the room

[17:58:03] Adrien joins the room

[17:59:01] St0ne joins the room

[17:59:03] Adrien leaves the room

[17:59:25] Benson leaves the room

[17:59:41] ij leaves the room

[17:59:46] danielepiccoli joins the room

[18:00:04] nik leaves the room

[18:00:29] nik joins the room

[18:00:37] Mickaël joins the room

[18:01:36] rain joins the room

[18:01:37] Mickaël leaves the room

[18:01:56] Ramiro Romani joins the room

[18:03:06] Mirror leaves the room

[18:03:10] hexZoN3 leaves the room

[18:03:39] Mirror joins the room

[18:03:42] debacle joins the room

[18:03:54] Adrien joins the room

[18:04:20] Titi leaves the room

[18:04:31] Mickaël joins the room

[18:04:45] Neustradamus leaves the room

[18:04:54] Adrien leaves the room

[18:05:01] spacecat leaves the room

[18:05:31] zain leaves the room

[18:05:31] Mickaël leaves the room

[18:05:39] jc joins the room

[18:06:44] ij joins the room

[18:07:17] pinkolik leaves the room

[18:08:10] spacecat joins the room

[18:09:44] Adrien joins the room

[18:09:46] Lazarus leaves the room

[18:09:49] Lazarus joins the room

[18:09:55] ClapTrap joins the room

[18:10:10] hexZoN3 joins the room

[18:10:17] Titi joins the room

[18:10:43] ermete leaves the room

[18:10:44] ermete joins the room

[18:10:45] Adrien leaves the room

[18:10:47] danielepiccoli leaves the room

[18:11:00] Mickaël joins the room

[18:11:13] Ramiro Romani leaves the room

[18:11:44] jc joins the room

[18:12:00] Mickaël leaves the room

[18:13:31] gs joins the room

[18:13:58] igor leaves the room

[18:14:14] IGImonster leaves the room

[18:14:45] sachaobado joins the room

[18:15:10] spacecat leaves the room

[18:15:34] Adrien joins the room

[18:15:36] jc leaves the room

[18:15:46] ij leaves the room

[18:16:00] Ramiro Romani joins the room

[18:16:34] Adrien leaves the room

[18:16:42] red curry leaves the room

[18:16:42] red curry joins the room

[18:16:46] ij joins the room

[18:16:58] Xi leaves the room

[18:16:59] Xi joins the room

[18:17:28] zain joins the room

[18:17:29] Mickaël joins the room

[18:18:10] spacecat joins the room

[18:18:26] ClapTrap leaves the room

[18:18:29] Mickaël leaves the room

[18:18:34] EmleyMoor leaves the room

[18:18:47] EmleyMoor joins the room

[18:19:03] erik leaves the room

[18:19:58] jc joins the room

[18:21:09] mirux leaves the room

[18:21:23] igor joins the room

[18:21:25] Adrien joins the room

[18:21:29] mirux joins the room

[18:21:42] jc leaves the room

[18:22:25] Adrien leaves the room

[18:24:12] Mickaël joins the room

[18:25:13] Mickaël leaves the room

[18:27:14] Adrien joins the room

[18:28:06] rintinfinn joins the room

[18:28:14] Adrien leaves the room

[18:28:27] APach leaves the room

[18:29:55] jc leaves the room

[18:30:09] pod joins the room

[18:30:46] Mickaël joins the room

[18:30:47] midou leaves the room

[18:30:58] erik joins the room

[18:31:46] Mickaël leaves the room

[18:32:13] Manis leaves the room

[18:32:27] moparisthebest joins the room

[18:32:30] reso leaves the room

[18:32:55] Titi leaves the room

[18:33:25] Adrien joins the room

[18:33:59] Titi joins the room

[18:34:25] Adrien leaves the room

[18:35:21] EmleyMoor leaves the room

[18:37:19] Hanketsu leaves the room

[18:37:23] Mickaël joins the room

[18:38:23] Mickaël leaves the room

[18:38:26] EmleyMoor joins the room

[18:38:38] Tim joins the room

[18:39:03] stp joins the room

[18:39:34] reso joins the room

[18:39:46] Adrien joins the room

[18:39:56] Hanketsu joins the room

[18:40:46] Adrien leaves the room

[18:41:21] Manis joins the room

[18:41:58] jc joins the room

[18:42:29] pod leaves the room

[18:42:48] qsx leaves the room

[18:44:05] Mickaël joins the room

[18:44:05] deimosBSD joins the room

[18:44:13] deimosBSD joins the room

[18:45:01] rain leaves the room

[18:45:05] Mickaël leaves the room

[18:45:27] rain joins the room

[18:46:10] Adrien joins the room

[18:46:23] qsx joins the room

[18:46:39] Chanaka Jayalath joins the room

[18:47:10] Adrien leaves the room

[18:47:23] marc joins the room

[18:48:47] jc joins the room

[18:49:01] igor leaves the room

[18:49:33] jesse leaves the room

[18:49:44] rain leaves the room

[18:49:52] rain joins the room

[18:49:57] jesse joins the room

[18:50:18] jc joins the room

[18:50:50] Mickaël joins the room

[18:51:15] karme joins the room

[18:51:50] Mickaël leaves the room

[18:51:51] jc joins the room

[18:51:52] Licaon_Kter leaves the room

[18:51:59] jc leaves the room

[18:52:45] mirux leaves the room: Disconnected: Received SIGTERM

[18:53:04] jc joins the room

[18:53:04] karme leaves the room

[18:53:30] marc leaves the room

[18:53:30] jc joins the room

[18:54:25] stp leaves the room

[18:54:32] deimosBSD leaves the room

[18:56:12] spacecat leaves the room

[18:56:47] Adrien joins the room

[18:56:52] EmleyMoor leaves the room

[18:57:07] EmleyMoor joins the room

[18:57:31] spacecat joins the room

[18:57:40] Mickaël joins the room

[18:57:47] Adrien leaves the room

[18:58:20] jesse leaves the room

[18:58:40] Mickaël leaves the room

[18:58:45] jc leaves the room

[18:59:19] mirux joins the room

[19:00:15] jc leaves the room

[19:01:49] jc leaves the room

[19:01:52] jc joins the room

[19:01:55] ZHOSKA joins the room

[19:02:15] jesse joins the room

[19:02:32] jc joins the room

[19:03:00] jc leaves the room

[19:03:28] jc leaves the room

[19:03:29] meson joins the room

[19:04:16] stp joins the room

[19:04:36] Mickaël joins the room

[19:04:50] Adrien joins the room

[19:04:57] king joins the room

[19:05:36] Mickaël leaves the room

[19:05:50] Adrien leaves the room

[19:05:57] igor joins the room

[19:06:50] rain leaves the room

[19:07:45] rain joins the room

[19:08:29] jc joins the room

[19:09:21] jc joins the room

[19:10:04] jc joins the room

[19:10:58] Adrien joins the room

[19:11:21] Mickaël joins the room

[19:11:25] EmleyMoor leaves the room

[19:11:50] jc leaves the room

[19:11:58] Adrien leaves the room

[19:12:21] Mickaël leaves the room

[19:12:30] jc leaves the room

[19:12:38] jc joins the room

[19:13:10] jc joins the room

[19:14:14] king leaves the room

[19:14:15] Marc leaves the room

[19:14:18] king joins the room

[19:15:17] jc joins the room

[19:16:02] jc joins the room

[19:16:20] sachaobado leaves the room

[19:17:12] Adrien joins the room

[19:17:31] igor leaves the room

[19:17:50] jc joins the room

[19:17:53] Mickaël joins the room

[19:18:01] igor joins the room

[19:18:12] Adrien leaves the room

[19:18:25] jc leaves the room

[19:18:53] Mickaël leaves the room

[19:18:56] PatRiot leaves the room

[19:19:08] deimosBSD joins the room

[19:19:12] Marc joins the room

[19:19:16] Marc joins the room

[19:19:19] jc leaves the room

[19:19:26] deimosBSD leaves the room

[19:19:29] igor leaves the room

[19:20:02] jc leaves the room

[19:20:14] akshay joins the room

[19:20:29] igor joins the room

[19:20:42] ij leaves the room

[19:20:43] rintinfinn leaves the room

[19:21:11] igor joins the room

[19:21:49] PatRiot joins the room

[19:22:25] kaptan leaves the room

[19:22:36] jc leaves the room

[19:23:03] Adrien joins the room

[19:23:08] jc leaves the room

[19:24:00] eevvoor leaves the room

[19:24:03] Adrien leaves the room

[19:24:34] Mickaël joins the room

[19:24:46] kaptan joins the room

[19:25:15] jc leaves the room

[19:25:34] Mickaël leaves the room

[19:26:00] jc leaves the room

[19:27:15] EmleyMoor joins the room

[19:27:47] jc leaves the room

[19:28:10] alacer joins the room

[19:28:39] christian leaves the room

[19:28:42] karme leaves the room

[19:29:11] Adrien joins the room

[19:30:11] Adrien leaves the room

[19:31:14] Mickaël joins the room

[19:32:14] Mickaël leaves the room

[19:32:18] Tim leaves the room

[19:32:50] kinetik leaves the room

[19:33:10] christian joins the room

[19:33:26] rintinfinn joins the room

[19:33:53] Wojtek leaves the room

[19:35:37] Adrien joins the room

[19:35:38] Jeroen joins the room

[19:35:40] Jeroen leaves the room

[19:35:51] ij joins the room

[19:35:56] EmleyMoor leaves the room

[19:36:37] Adrien leaves the room

[19:37:56] EmleyMoor joins the room

[19:38:04] Mickaël joins the room

[19:39:04] Mickaël leaves the room

[19:41:31] leke leaves the room

[19:41:46] Satish leaves the room

[19:41:47] Satish joins the room

[19:42:01] Adrien joins the room

[19:43:01] Adrien leaves the room

[19:44:34] Mickaël joins the room

[19:45:34] Mickaël leaves the room

[19:45:48] qsx leaves the room

[19:48:09] Adrien joins the room

[19:49:09] Adrien leaves the room

[19:51:07] spacecat leaves the room

[19:51:09] Emru leaves the room

[19:51:14] Mickaël joins the room

[19:51:41] EmleyMoor leaves the room

[19:51:51] erik leaves the room

[19:51:51] EmleyMoor joins the room

[19:52:15] Mickaël leaves the room

[19:53:13] spacecat joins the room

[19:53:35] igor leaves the room

[19:54:22] Adrien joins the room

[19:55:22] Adrien leaves the room

[19:55:59] Marc leaves the room

[19:56:16] alacer leaves the room

[19:57:48] Mickaël joins the room

[19:58:04] Marc joins the room

[19:58:07] igor joins the room

[19:58:48] Mickaël leaves the room

[20:00:09] leke joins the room

[20:00:59] Adrien joins the room

[20:01:20] spacecat leaves the room

[20:01:59] Adrien leaves the room

[20:02:05] arcanicanis joins the room

[20:02:11] Marc leaves the room

[20:02:14] marc joins the room

[20:02:15] Marc leaves the room

[20:02:17] gandalf leaves the room

[20:02:33] stp leaves the room

[20:03:05] spacecat joins the room

[20:03:41] Licaon_Kter joins the room

[20:04:38] Mickaël joins the room

[20:05:39] Mickaël leaves the room

[20:06:31] zain leaves the room

[20:06:47] random_tester_123 leaves the room

[20:07:07] Adrien joins the room

[20:08:03] arcanicanis leaves the room

[20:08:07] Adrien leaves the room

[20:09:21] Marc joins the room

[20:09:46] marc leaves the room

[20:10:56] zain joins the room

[20:11:33] Mickaël joins the room

[20:12:34] Mickaël leaves the room

[20:12:58] Adrian Kieß leaves the room

[20:13:32] Adrien joins the room

[20:14:28] Marc joins the room

[20:14:32] Adrien leaves the room

[20:14:45] mightyBroccoli leaves the room

[20:15:05] erik joins the room

[20:15:17] robert_mobil leaves the room

[20:15:24] spacecat leaves the room

[20:15:57] Marc leaves the room

[20:15:59] Marc joins the room

[20:16:00] EmleyMoor leaves the room

[20:16:07] spacecat joins the room

[20:16:57] isotelo leaves the room

[20:17:36] midou joins the room

[20:18:23] Mickaël joins the room

[20:19:23] Mickaël leaves the room

[20:20:06] chrys leaves the room

[20:20:06] chrys leaves the room: Disconnected: Received SIGINT

[20:20:09] Adrien joins the room

[20:20:22] Marc leaves the room

[20:20:44] Marc joins the room

[20:21:08] Adrien leaves the room

[20:21:12] Marc leaves the room

[20:21:18] Marc joins the room

[20:21:30] Citlali joins the room

[20:21:54] arcanicanis joins the room

[20:22:05] EmleyMoor joins the room

[20:23:15] chrys joins the room

[20:23:30] chrys leaves the room: Disconnected: Replaced by new connection

[20:23:31] chrys joins the room

[20:25:09] Mickaël joins the room

[20:25:15] pod leaves the room

[20:25:15] pod joins the room

[20:26:05] ij leaves the room

[20:26:09] Mickaël leaves the room

[20:26:57] Adrien joins the room

[20:27:35] Сергій leaves the room

[20:27:48] banana leaves the room

[20:27:57] Adrien leaves the room

[20:29:01] banana joins the room

[20:29:25] Marc leaves the room

[20:29:26] Marc joins the room

[20:30:21] Titi leaves the room

[20:30:31] Olivia leaves the room

[20:30:45] rain leaves the room

[20:31:10] gs leaves the room

[20:31:12] gs joins the room

[20:31:44] ij joins the room

[20:31:56] Mickaël joins the room

[20:32:03] Marc leaves the room

[20:32:09] Marc joins the room

[20:32:14] spacecat leaves the room

[20:32:41] leke leaves the room

[20:32:56] Mickaël leaves the room

[20:33:01] Adrien joins the room

[20:33:25] kaptan leaves the room

[20:34:01] Adrien leaves the room

[20:34:58] gandalf joins the room

[20:35:08] spacecat joins the room

[20:35:20] karme joins the room

[20:36:08] Citlali leaves the room

[20:36:23] dusty joins the room

[20:36:56] marc joins the room

[20:37:55] bio leaves the room

[20:38:20] sander joins the room

[20:39:10] Adrien joins the room

[20:39:11] Mickaël joins the room

[20:39:55] rain joins the room

[20:39:58] samuel leaves the room

[20:40:10] Adrien leaves the room

[20:40:11] Mickaël leaves the room

[20:42:48] leke joins the room

[20:43:36] neox leaves the room

[20:44:16] Titi leaves the room

[20:45:29] Mickaël joins the room

[20:45:47] Adrien joins the room

[20:46:29] Mickaël leaves the room

[20:46:40] nega†ive1 leaves the room

[20:46:47] Adrien leaves the room

[20:48:22] stp joins the room

[20:48:45] rintinfinn leaves the room

[20:48:50] pitchum joins the room

[20:49:27] marc leaves the room

[20:50:42] spacecat leaves the room

[20:50:48] ff leaves the room

[20:51:17] Hanketsu leaves the room

[20:51:29] ff joins the room

[20:51:48] Hanketsu joins the room

[20:51:53] pitchum leaves the room

[20:51:56] Mickaël joins the room

[20:52:29] Ramiro Romani leaves the room

[20:52:56] Mickaël leaves the room

[20:53:28] Adrien joins the room

[20:53:29] spacecat joins the room

[20:53:30] Hanketsu leaves the room

[20:54:28] Adrien leaves the room

[20:54:55] Marc leaves the room

[20:55:06] moparisthebest leaves the room

[20:55:48] karme leaves the room

[20:56:05] zain leaves the room

[20:57:17] marc joins the room

[20:58:13] Mickaël joins the room

[20:59:14] Mickaël leaves the room

[20:59:26] igor joins the room

[20:59:43] Adrien joins the room

[21:00:12] tobiasd leaves the room

[21:00:43] Adrien leaves the room

[21:01:30] christian leaves the room

[21:03:01] gandalf leaves the room

[21:03:04] rain leaves the room

[21:03:44] marc leaves the room

[21:04:11] Mickaël joins the room

[21:04:31] rain joins the room

[21:04:32] gandalf joins the room

[21:04:50] agh leaves the room

[21:05:11] Mickaël leaves the room

[21:06:10] Adrien joins the room

[21:07:10] Adrien leaves the room

[21:07:28] agh leaves the room

[21:08:36] Ramiro Romani joins the room

[21:09:09] marc joins the room

[21:09:33] pod leaves the room

[21:10:30] Mickaël joins the room

[21:10:57] rain leaves the room

[21:11:19] ff leaves the room

[21:11:30] Mickaël leaves the room

[21:11:39] ff joins the room

[21:12:05] Adrien joins the room

[21:13:05] Adrien leaves the room

[21:13:38] Citlali joins the room

[21:15:13] jjj333_p (any pronouns) leaves the room

[21:15:15] jjj333_p (any pronouns) joins the room

[21:15:19] marc leaves the room

[21:16:10] igor leaves the room

[21:16:52] Mickaël joins the room

[21:17:52] Mickaël leaves the room

[21:18:09] Adrien joins the room

[21:18:32] midou leaves the room

[21:19:09] Adrien leaves the room

[21:19:09] midou joins the room

[21:19:11] rain joins the room

[21:19:17] gandalf leaves the room

[21:21:40] igor leaves the room

[21:21:57] robert_mobil leaves the room

[21:23:15] Mickaël joins the room

[21:24:05] Adrien joins the room

[21:24:15] Mickaël leaves the room

[21:25:05] Adrien leaves the room

[21:25:27] midou leaves the room

[21:26:26] marc joins the room

[21:26:44] midou joins the room

[21:27:27] Ramiro Romani joins the room

[21:27:56] yellow leaves the room

[21:29:36] Mickaël joins the room

[21:30:13] Adrien joins the room

[21:30:36] Mickaël leaves the room

[21:30:58] erik leaves the room

[21:31:11] Adrien leaves the room

[21:32:39] jc leaves the room

[21:35:08] Chanaka Jayalath leaves the room

[21:35:39] serafean joins the room

[21:35:54] Mickaël joins the room

[21:36:55] Mickaël leaves the room

[21:37:11] Adrien joins the room

[21:37:20] kinetik joins the room

[21:38:11] Adrien leaves the room

[21:39:39] brahms leaves the room

[21:40:46] midou leaves the room

[21:40:52] brahms joins the room

[21:41:10] midou joins the room

[21:42:19] Mickaël joins the room

[21:43:04] serafean leaves the room

[21:43:07] marc36 leaves the room

[21:43:14] Adrien joins the room

[21:43:19] Mickaël leaves the room

[21:43:25] serafean joins the room

[21:43:58] serafean leaves the room

[21:44:14] Adrien leaves the room

[21:44:28] meson leaves the room

[21:44:55] serafean joins the room

[21:45:08] serafean leaves the room

[21:45:40] ff leaves the room

[21:46:21] serafean joins the room

[21:46:35] serafean leaves the room

[21:47:22] PatRiot leaves the room

[21:48:38] Mickaël joins the room

[21:49:08] Adrien joins the room

[21:49:39] Mickaël leaves the room

[21:50:08] Adrien leaves the room

[21:50:31] marc leaves the room

[21:51:26] ij leaves the room

[21:52:47] marc joins the room

[21:53:08] maidlover leaves the room

[21:54:43] midou leaves the room

[21:54:58] Adrien joins the room

[21:55:00] Mickaël joins the room

[21:55:23] mirux leaves the room

[21:55:25] midou joins the room

[21:55:58] Adrien leaves the room

[21:56:00] Mickaël leaves the room

[21:58:17] midou leaves the room

[21:58:47] midou joins the room

[22:00:24] midou leaves the room

[22:00:27] hallu leaves the room

[22:00:47] midou joins the room

[22:00:54] serafean leaves the room

[22:00:56] Adrien joins the room

[22:01:17] Mickaël joins the room

[22:01:31] PatRiot joins the room

[22:01:56] Adrien leaves the room

[22:01:57] hallu joins the room

[22:02:18] Mickaël leaves the room

[22:03:55] jc leaves the room: Disconnected: Hibernating too long

[22:05:57] EmleyMoor leaves the room

[22:06:18] serafean joins the room

[22:07:12] EmleyMoor joins the room

[22:07:29] Adrien joins the room

[22:07:49] Mickaël joins the room

[22:08:06] midou leaves the room

[22:08:29] Adrien leaves the room

[22:08:34] bio joins the room

[22:08:49] Mickaël leaves the room

[22:12:01] midou joins the room

[22:12:29] stian leaves the room

[22:13:01] stian joins the room

[22:13:10] kinetik leaves the room

[22:13:28] ermete leaves the room

[22:13:30] ermete joins the room

[22:13:35] Adrien joins the room

[22:14:15] Mickaël joins the room

[22:14:21] writer77 leaves the room

[22:14:35] Adrien leaves the room

[22:15:13] gs leaves the room

[22:15:15] Mickaël leaves the room

[22:15:27] gs joins the room

[22:16:10] kinetik joins the room

[22:19:05] jjj333_p (any pronouns) leaves the room

[22:19:09] jjj333_p (any pronouns) joins the room

[22:19:54] Adrien joins the room

[22:20:37] Mickaël joins the room

[22:20:54] Adrien leaves the room

[22:21:29] egnun leaves the room

[22:21:37] Mickaël leaves the room

[22:22:50] EmleyMoor leaves the room

[22:22:53] Holger leaves the room

[22:23:00] Holger joins the room

[22:26:16] Adrien joins the room

[22:26:55] Mickaël joins the room

[22:27:16] Adrien leaves the room

[22:27:42] SouL leaves the room

[22:27:55] Mickaël leaves the room

[22:28:17] rintinfinn joins the room

[22:28:37] rain leaves the room

[22:28:49] EmleyMoor joins the room

[22:29:03] rain joins the room

[22:30:24] qsx joins the room

[22:32:12] uira leaves the room

[22:32:17] Adrien joins the room

[22:33:13] Mickaël joins the room

[22:33:17] Adrien leaves the room

[22:34:13] Mickaël leaves the room

[22:36:46] rain leaves the room

[22:37:15] EmleyMoor leaves the room

[22:38:21] Adrien joins the room

[22:38:54] rintinfinn leaves the room

[22:39:21] Adrien leaves the room

[22:39:29] Mickaël joins the room

[22:40:29] Mickaël leaves the room

[22:43:14] qsx leaves the room

[22:44:24] Adrien joins the room

[22:45:24] Adrien leaves the room

[22:45:50] Mickaël joins the room

[22:46:32] EmleyMoor joins the room

[22:46:48] schäfchen726 leaves the room

[22:46:50] Mickaël leaves the room

[22:48:22] rintinfinn leaves the room

[22:50:24] Adrien joins the room

[22:51:09] Licaon_Kter leaves the room

[22:51:24] Adrien leaves the room

[22:52:16] Mickaël joins the room

[22:53:16] Mickaël leaves the room

[22:53:19] EmleyMoor leaves the room

[22:54:47] Mirror leaves the room

[22:56:09] ermete leaves the room

[22:56:09] ermete joins the room

[22:56:15] Adrien joins the room

[22:56:29] Licaon_Kter joins the room

[22:56:30] EmleyMoor joins the room

[22:57:15] Adrien leaves the room

[22:57:30] rain joins the room

[22:57:43] zoidberg joins the room

[22:58:33] Mickaël joins the room

[22:59:00] bio leaves the room

[22:59:33] Mickaël leaves the room

[22:59:57] william.chatner leaves the room

[23:01:06] marc leaves the room

[23:01:09] Arya Kiran joins the room

[23:02:05] Adrien joins the room

[23:03:05] Adrien leaves the room

[23:03:30] stian leaves the room

[23:04:50] Mickaël joins the room

[23:05:50] Mickaël leaves the room

[23:06:10] spacecat leaves the room

[23:06:37] stian joins the room

[23:06:58] SouL joins the room

[23:07:15] Arya Kiran leaves the room

[23:07:48] paul leaves the room

[23:07:48] paul joins the room

[23:07:54] Robbilie leaves the room: Disconnected: Replaced by new connection

[23:07:55] Robbilie joins the room

[23:07:55] Adrien joins the room

[23:07:59] moparisthebest joins the room

[23:08:10] spacecat joins the room

[23:08:46] rain leaves the room

[23:08:55] Adrien leaves the room

[23:10:32] Ramiro Romani leaves the room

[23:10:55] moparisthebest leaves the room

[23:11:12] Mickaël joins the room

[23:12:08] rain joins the room

[23:12:12] Mickaël leaves the room

[23:13:45] Adrien joins the room

[23:13:51] Arya Kiran joins the room

[23:14:47] Adrien leaves the room

[23:17:33] Mickaël joins the room

[23:18:33] Mickaël leaves the room

[23:19:35] Adrien joins the room

[23:20:32] midou leaves the room

[23:20:35] Adrien leaves the room

[23:22:20] agates leaves the room

[23:22:59] meson leaves the room

[23:23:10] dusty leaves the room

[23:23:58] Mickaël joins the room

[23:24:16] king leaves the room

[23:24:46] midou joins the room

[23:24:58] Mickaël leaves the room

[23:25:26] Adrien joins the room

[23:26:26] Adrien leaves the room

[23:26:43] qsx leaves the room

[23:27:07] qsx joins the room

[23:28:35] brahms leaves the room

[23:29:17] dusty joins the room

[23:29:42] stian leaves the room

[23:30:16] Mickaël joins the room

[23:31:16] Mickaël leaves the room

[23:31:17] Adrien joins the room

[23:31:32] stian joins the room

[23:32:17] Adrien leaves the room

[23:32:29] VC leaves the room

[23:32:44] VC joins the room

[23:33:45] ermete leaves the room

[23:36:40] Mickaël joins the room

[23:37:07] Adrien joins the room

[23:37:40] Mickaël leaves the room

[23:38:07] Adrien leaves the room

[23:39:27] Neimi leaves the room

[23:41:00] agates joins the room

[23:41:03] nutcracker500 joins the room

[23:41:44] rain leaves the room

[23:42:24] rain leaves the room

[23:42:57] Adrien joins the room

[23:43:02] Mickaël joins the room

[23:43:39] Citlali leaves the room

[23:43:57] Adrien leaves the room

[23:44:02] Mickaël leaves the room

[23:44:03] midou leaves the room

[23:44:34] midou joins the room

[23:46:46] sezuan leaves the room

[23:46:48] sezuan joins the room

[23:48:35] Arya Kiran leaves the room

[23:48:48] Adrien joins the room

[23:49:24] Mickaël joins the room

[23:49:49] Adrien leaves the room

[23:49:56] midou leaves the room

[23:49:57] Arya Kiran joins the room

[23:50:24] Mickaël leaves the room

[23:52:39] igor joins the room

[23:53:14] Citlali joins the room

[23:53:14] midou joins the room

[23:54:39] Adrien joins the room

[23:55:39] Adrien leaves the room

[23:55:41] Mickaël joins the room

[23:56:41] Mickaël leaves the room

[23:59:21] Arya Kiran leaves the room

Powered by ejabberd - robust, scalable and extensible XMPP server