Gajim - 2023-12-13

How do I export my friend's group chat history into a cleanly formatted, easily viewable and searchable document at year's end ?

lovetox, probably for the same reason as 'if someone else can compile your software why prefer FOSS?' or something like that. just curious and in a mood to tinker with protocols

shodan: sqlite

u can export to any file

Just had a look at the structure. Looks like it's one big table of all messages on all channels. The actual source of each message is stored somewhere else. (This is logs.db table "logs") That's going to be a huge jobs reconstituting this into something coherent

I think I'm going to screen record a video scrolling up the chat history instead. Too bad it won't be searchable though. So, nobody saves their chat history, it all gets deleted eventually ?

u need to select where channelid

is the GC encrypted with omemo?

then u need omemo db

http://cheat.sh/sqlite3 or use dbeaver or something if ur unfamiliar

i just opened logs.db and i can't figure out how it stores what channel the log message belongs to

it states who sent it

like which user, but not which use in which room

what's the reason for sqlite vs. plain text here?

There isn't a channel_id columns in the logs table of logs.db There is stanza_id and message_id I presume somewhere else in the file there is a lookup table which lists all message_id and which channel_id it is ? But that's getting really heavy to manage

Ah, it's the jid_id columns, it has a lookup in the "jids" table

So it looks like this

https://chat.domn.net:5443/upload/500b07a7efeff7dd5a382d5bf3fa0d30cec686c6/DW3psscR1HFEqrDU9d5mRFJGWj28S1BckzurhRvZ/da5713dc-2ec3-4a46-8793-1f362b4b5716.png

weird

I haven't got much experience with SQL

somewhere in there

maybe not logs.db ✏

check all da sqli files tbh

it's gonna be in there somewhere if u see it in the client

I'm not at my desk rn

> People get more prone to infections with age too. lol

shodan: there is a export in the account settings

Thanks that's great plain text format with all the image urls It's going to take only a little more effort to embed the images

hello, I am trying to make an appimage for Gajim. So having to look into dependencies.

is `systemd` a dependency for Gajim?

I've visited gajim/common/dbus/ and feel a bit worried that I might need to bundle systemd, dbus (hopefully not; still exploring the AppImage format) ✏

Appimage does not work on Wayland

Just so you know

kurion: and we list dependencies in our readme

> Appimage does not work on Wayland Thanks for the heads-up

I plan to stick to X11 as long as it serves me well enough.

watch it the waylands gang might come for you 😉

> is `systemd` a dependency for Gajim? When I setup gajim on freebsd it didn't require systemd but it did require a machineID ↺

polarian: :)

> unclearam: it did require a machineID is machineID a BSD-specific thing? ✏

kurion: no its specific to the systemd suite and a like. https://unix.stackexchange.com/questions/402999/is-it-ok-to-change-etc-machine-id#403054 You need to create a file in /etc/machine-id and randomly generate a string of characters.

You will offend a lot of BSD people though cause you systemdified your instance.

unclearam: 😅

> i dont need an account for connecting > > just give me the address lovetox: My family only uses mobile client with my server. Images work for them. I decided that I can live without images on desktop. I always can look at the picture on the phone. Topic closed.

> beduk, https://security.stackexchange.com/a/105647 > > Every single article I have read on this says you are wrong > > soooo What can I say?🤷better nothing. 👋

beduk, your problem was that you could not connect unencrypted

i dont get why dont just give me the server adress so i can look into it

There's no way to re-share a file right? In a different tab

I mean, directly without looking for the file that's saved locally

you mean like a share button

no, you can copy the http upload link, and copy it to another chat

And gajim will add the oob itself?

just to add, if image previews are enabled, right-click the image and select 'Copy Link', since that might be not noticed

what is oob?

>> unclearam: it did require a machineID > is machineID a BSD-specific thing? dbus

fjklp, https://docs.modernxmpp.org/client/protocol/#communicating-the-url

thanks

pep.: no, at least you can configure gajim that it does not care

Does not care about.. the oob tag?

I want receiving clients (on the other end) to display it nicely :)

But ok

I have just attached the file saved locally for now

but how would the gui should look like which you expected

a share button on the image? and this brings up some kind of contact dialog

or switching to the other chat, pressing the file button, and see maybe "recent files" and select it there?

hmm, right it's not as obvious as on Android