Haunt of the dead hamster (MMS)

I tried to send MMS for my friend which contains photo of my hamster with text “Now he is sleeping.” It did not work. But now I can not get rid of that photo anymore. Everytime when I start chatty, I can not see it in my chat immediately, but after 10-30 minutes is will be the latest message between me and my friend. My friend does not seem to get the message, but I have plenty of these messages in queue and they are annoying, especially because our hamster died already about a year ago.

I have used 3 hours with following ways to track:

  1. Used ChatGPT and deleted everything in Chatty sqlite3 database relating the strings “Now he is sleeping.”, both messages, files, references everything and relating to MMS’s.
  2. Deleted the files of the purism user, which has this photo, including trash folder.
  3. Compiled new 0.8 prerelease from git.

Newer version only tells me that it failed to send mms, but how in the *#“¤! I can delete that f”!¤%!"¤# queue??? Is that message in some modem queue or where it is hanging?

2 Likes

I can clear the message with this query, but it reappears again after phone is booted (or sometimes when chatty is restarted)
sqlite3 ~/.purple/chatty/db/chatty-history.db “SELECT id, body FROM messages WHERE body LIKE ‘%Now he is sleeping%’;”

Chatgpt wrote a script, which checks all tables, not just message table, but can’t find it from anywhere else.

#!/bin/bash

DB_PATH=“$1”
SEARCH_STRING=“He is sleeping.”

if [[ -z “$DB_PATH” || ! -f “$DB_PATH” ]]; then
echo “Usage: $0 /path/to/database.db”
exit 1
fi

echo “Searching for: "$SEARCH_STRING" in $DB_PATH”
echo

sqlite3 “$DB_PATH” “.tables” | tr -s ’ ’ ‘\n’ | grep -v ‘^$’ | while read -r TABLE; do
echo “Checking table: $TABLE”

# Get TEXT columns only
COLUMNS=$(sqlite3 "$DB_PATH" "PRAGMA table_info($TABLE);" | awk -F'|' '$3 ~ /TEXT|VARCHAR|CHAR/ {print $2}')

for COLUMN in $COLUMNS; do
    QUERY="SELECT rowid, $COLUMN FROM $TABLE WHERE $COLUMN LIKE '%$SEARCH_STRING%';"
    MATCHES=$(sqlite3 "$DB_PATH" "$QUERY")
    if [[ -n "$MATCHES" ]]; then
        echo "  >> Matches in table '$TABLE', column '$COLUMN':"
        echo "$MATCHES" | sed 's/^/    /'
    fi
done

done

1 Like

I have used lsof to track it, but I guess I need to track with audit daemon whoever creating the file under ./.local/share/chatty/mms/ again and again…

1 Like

I think it is problem with Chatty, because it keeps creating those files, but I don’t know from where.


time->Sat May 31 17:55:40 2025
type=PROCTITLE msg=audit(1748703340.950:282): proctitle="chatty"
type=PATH msg=audit(1748703340.950:282): item=0 name="/home/purism/.local/share/chatty/mms/" inode=261582 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703340.950:282): cwd="/home/purism"
type=SYSCALL msg=audit(1748703340.950:282): arch=c00000b7 syscall=34 success=no exit=-17 a0=ffffffffffffff9c a1=ffff78041000 a2=1ff a3=0 items=1 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:40 2025
type=PROCTITLE msg=audit(1748703340.950:283): proctitle="chatty"
type=PATH msg=audit(1748703340.950:283): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:43:24+0200ee4c51b617bb9146a519bb813862149fd62b/mms.smil" inode=675220 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=CREATE cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703340.950:283): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:43:24+0200ee4c51b617bb9146a519bb813862149fd62b/" inode=675199 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703340.950:283): cwd="/home/purism"
type=SYSCALL msg=audit(1748703340.950:283): arch=c00000b7 syscall=56 success=yes exit=23 a0=ffffffffffffff9c a1=aaaae89e9660 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:40 2025
type=PROCTITLE msg=audit(1748703340.950:284): proctitle="chatty"
type=PATH msg=audit(1748703340.950:284): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:43:24+0200ee4c51b617bb9146a519bb813862149fd62b/IMG20240627093259-resized-00002-00001.jpg" inode=675201 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=NORMAL cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703340.950:284): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:43:24+0200ee4c51b617bb9146a519bb813862149fd62b/" inode=675199 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703340.950:284): cwd="/home/purism"
type=SYSCALL msg=audit(1748703340.950:284): arch=c00000b7 syscall=56 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae89e2560 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
--
type=SYSCALL msg=audit(1748703340.950:285): arch=c00000b7 syscall=35 success=yes exit=0 a0=ffffffffffffff9c a1=aaaae89e5520 a2=0 a3=0 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.206:286): proctitle="chatty"
type=PATH msg=audit(1748703341.206:286): item=0 name="/home/purism/.local/share/chatty/mms/" inode=261582 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.206:286): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.206:286): arch=c00000b7 syscall=34 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae8840480 a2=1ff a3=0 items=1 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.206:287): proctitle="chatty"
type=PATH msg=audit(1748703341.206:287): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:45:46+02000d5a8e3011da71469a1884a1612815e24d50/mms.smil" inode=675220 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=CREATE cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.206:287): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:45:46+02000d5a8e3011da71469a1884a1612815e24d50/" inode=675200 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.206:287): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.206:287): arch=c00000b7 syscall=56 success=yes exit=25 a0=ffffffffffffff9c a1=aaaae67f8d80 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.206:288): proctitle="chatty"
type=PATH msg=audit(1748703341.206:288): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:45:46+02000d5a8e3011da71469a1884a1612815e24d50/IMG20240627093259-resized-00002-00001.jpg" inode=675214 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=NORMAL cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.206:288): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:45:46+02000d5a8e3011da71469a1884a1612815e24d50/" inode=675200 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.206:288): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.206:288): arch=c00000b7 syscall=56 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae79e80f0 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
--
type=SYSCALL msg=audit(1748703341.206:289): arch=c00000b7 syscall=35 success=yes exit=0 a0=ffffffffffffff9c a1=aaaae7a25e20 a2=0 a3=0 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.386:290): proctitle="chatty"
type=PATH msg=audit(1748703341.386:290): item=0 name="/home/purism/.local/share/chatty/mms/" inode=261582 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.386:290): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.386:290): arch=c00000b7 syscall=34 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae7aedd50 a2=1ff a3=0 items=1 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.386:291): proctitle="chatty"
type=PATH msg=audit(1748703341.386:291): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:41:23+02000e5900bf198ef1447118cf31aa7ff544d1a8/mms.smil" inode=675220 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=CREATE cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.386:291): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:41:23+02000e5900bf198ef1447118cf31aa7ff544d1a8/" inode=675202 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.386:291): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.386:291): arch=c00000b7 syscall=56 success=yes exit=25 a0=ffffffffffffff9c a1=aaaae7aecca0 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.386:292): proctitle="chatty"
type=PATH msg=audit(1748703341.386:292): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:41:23+02000e5900bf198ef1447118cf31aa7ff544d1a8/IMG20240627093259-resized-00002-00001.jpg" inode=675216 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=NORMAL cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.386:292): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T20:41:23+02000e5900bf198ef1447118cf31aa7ff544d1a8/" inode=675202 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.386:292): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.386:292): arch=c00000b7 syscall=56 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae7aedc20 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
--
type=SYSCALL msg=audit(1748703341.386:293): arch=c00000b7 syscall=35 success=yes exit=0 a0=ffffffffffffff9c a1=aaaae83010c0 a2=0 a3=0 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.462:294): proctitle="chatty"
type=PATH msg=audit(1748703341.462:294): item=0 name="/home/purism/.local/share/chatty/mms/" inode=261582 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.462:294): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.462:294): arch=c00000b7 syscall=34 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae7a482f0 a2=1ff a3=0 items=1 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.462:295): proctitle="chatty"
type=PATH msg=audit(1748703341.462:295): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:40:46+0200006f2cd41d62a14614186c817f914cbbefec/mms.smil" inode=675220 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=CREATE cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.462:295): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:40:46+0200006f2cd41d62a14614186c817f914cbbefec/" inode=675215 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.462:295): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.462:295): arch=c00000b7 syscall=56 success=yes exit=25 a0=ffffffffffffff9c a1=aaaae7a70f00 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.462:296): proctitle="chatty"
type=PATH msg=audit(1748703341.462:296): item=1 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:40:46+0200006f2cd41d62a14614186c817f914cbbefec/IMG20240627093259-resized-00002-00001.jpg" inode=675218 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=NORMAL cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.462:296): item=0 name="/home/purism/.local/share/chatty/mms/2025-03-29T21:40:46+0200006f2cd41d62a14614186c817f914cbbefec/" inode=675215 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.462:296): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.462:296): arch=c00000b7 syscall=56 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae8abaf30 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
--
type=SYSCALL msg=audit(1748703341.462:297): arch=c00000b7 syscall=35 success=yes exit=0 a0=ffffffffffffff9c a1=aaaae8321580 a2=0 a3=0 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.546:298): proctitle="chatty"
type=PATH msg=audit(1748703341.546:298): item=0 name="/home/purism/.local/share/chatty/mms/" inode=261582 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.546:298): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.546:298): arch=c00000b7 syscall=34 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae79ce730 a2=1ff a3=0 items=1 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.546:299): proctitle="chatty"
type=PATH msg=audit(1748703341.546:299): item=1 name="/home/purism/.local/share/chatty/mms/2024-06-27T09:34:58+0300b39fb4f917f6114b531845012bc2445aebd3/message-contents.txt" inode=675220 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=CREATE cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.546:299): item=0 name="/home/purism/.local/share/chatty/mms/2024-06-27T09:34:58+0300b39fb4f917f6114b531845012bc2445aebd3/" inode=675217 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.546:299): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.546:299): arch=c00000b7 syscall=56 success=yes exit=25 a0=ffffffffffffff9c a1=aaaae7abedf0 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"
----
time->Sat May 31 17:55:41 2025
type=PROCTITLE msg=audit(1748703341.546:300): proctitle="chatty"
type=PATH msg=audit(1748703341.546:300): item=1 name="/home/purism/.local/share/chatty/mms/2024-06-27T09:34:58+0300b39fb4f917f6114b531845012bc2445aebd3/IMG20240627093259-resized-00002.jpg" inode=675306 dev=fe:00 mode=0100600 ouid=1000 ogid=1000 rdev=00:00 nametype=NORMAL cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=PATH msg=audit(1748703341.546:300): item=0 name="/home/purism/.local/share/chatty/mms/2024-06-27T09:34:58+0300b39fb4f917f6114b531845012bc2445aebd3/" inode=675217 dev=fe:00 mode=040755 ouid=1000 ogid=1000 rdev=00:00 nametype=PARENT cap_fp=0 cap_fi=0 cap_fe=0 cap_fver=0 cap_frootid=0
type=CWD msg=audit(1748703341.546:300): cwd="/home/purism"
type=SYSCALL msg=audit(1748703341.546:300): arch=c00000b7 syscall=56 success=no exit=-17 a0=ffffffffffffff9c a1=aaaae79fb040 a2=c1 a3=180 items=2 ppid=1 pid=2936 auid=1000 uid=1000 gid=1000 euid=1000 suid=1000 fsuid=1000 egid=1000 sgid=1000 fsgid=1000 tty=tty7 ses=1 comm="chatty" exe="/usr/bin/chatty" subj=unconfined key="chatty_mms_watch"

1 Like

It must be some strange queue outside of chatty, but where?
It always comes with new ID, after restarting chatty.

purism@pureos:~$ ./sleeping.sh /home/purism/.purple/chatty/db/chatty-history.db
Searching for: "He is sleeping." in /home/purism/.purple/chatty/db/chatty-history.db

Checking table: accounts
Checking table: files
Checking table: messages
  >> Matches in table 'messages', column 'body':
    28169|Now he is sleeping.
Checking table: mm_messages
Checking table: threads
Checking table: file_metadata
Checking table: message_files
Checking table: mime_type
Checking table: thread_members
Checking table: users
purism@pureos:~$ pkill chatty
purism@pureos:~$ ./sleeping.sh /home/purism/.purple/chatty/db/chatty-history.db
Searching for: "He is sleeping." in /home/purism/.purple/chatty/db/chatty-history.db

Checking table: accounts
Checking table: files
Checking table: messages
  >> Matches in table 'messages', column 'body':
    28169|Now he is sleeping.
Checking table: mm_messages
Checking table: threads
Checking table: file_metadata
Checking table: message_files
Checking table: mime_type
Checking table: thread_members
Checking table: users




purism@pureos:~$ ./delete.sh /home/purism/.purple/chatty/db/chatty-history.db
Deleting from files where url matches...
Deleting from messages where uid matches...
Done.
purism@pureos:~$ ./sleeping.sh /home/purism/.purple/chatty/db/chatty-history.db
Searching for: "He is sleeping." in /home/purism/.purple/chatty/db/chatty-history.db

Checking table: accounts
Checking table: files
Checking table: messages
Checking table: mm_messages
Checking table: threads
Checking table: file_metadata
Checking table: message_files
Checking table: mime_type
Checking table: thread_members
Checking table: users
purism@pureos:~$ chatty &
[1] 2350
purism@pureos:~$ ./sleeping.sh /home/purism/.purple/chatty/db/chatty-history.db
Searching for: "He is sleeping." in /home/purism/.purple/chatty/db/chatty-history.db

Checking table: accounts
Error: database is locked
Checking table: files
Error: database is locked
Checking table: messages
Error: database is locked
Error: database is locked
Error: database is locked
Checking table: mm_messages
Checking table: threads
Checking table: file_metadata
Checking table: message_files
Checking table: mime_type
Checking table: thread_members
Checking table: users
purism@pureos:~$ ./sleeping.sh /home/purism/.purple/chatty/db/chatty-history.db
Searching for: "He is sleeping." in /home/purism/.purple/chatty/db/chatty-history.db

Checking table: accounts
Checking table: files
Checking table: messages
  >> Matches in table 'messages', column 'body':
    28174|Now he is sleeping.
Checking table: mm_messages
Checking table: threads
Checking table: file_metadata
Checking table: message_files
Checking table: mime_type
Checking table: thread_members
Checking table: users
purism@pureos:~$

sleeping.sh:

#!/bin/bash

DB_PATH="$1"
SEARCH_STRING="He is sleeping."

if [[ -z "$DB_PATH" || ! -f "$DB_PATH" ]]; then
    echo "Usage: $0 /path/to/database.db"
    exit 1
fi

echo "Searching for: \"$SEARCH_STRING\" in $DB_PATH"
echo

sqlite3 "$DB_PATH" ".tables" | tr -s ' ' '\n' | grep -v '^$' | while read -r TABLE; do
    echo "Checking table: $TABLE"

    # Get TEXT columns only
    COLUMNS=$(sqlite3 "$DB_PATH" "PRAGMA table_info($TABLE);" | awk -F'|' '$3 ~ /TEXT|VARCHAR|CHAR/ {print $2}')

    for COLUMN in $COLUMNS; do
        QUERY="SELECT rowid, $COLUMN FROM $TABLE WHERE $COLUMN LIKE '%$SEARCH_STRING%';"
        MATCHES=$(sqlite3 "$DB_PATH" "$QUERY")
        if [[ -n "$MATCHES" ]]; then
            echo "  >> Matches in table '$TABLE', column '$COLUMN':"
            echo "$MATCHES" | sed 's/^/    /'
        fi
    done
done

delete.sh

#!/bin/bash

DB="$1"
SEARCH_STRING="Now he is sleeping."

if [ -z "$DB" ]; then
  echo "Usage: $0 /path/to/database.db"
  exit 1
fi

TABLES=$(sqlite3 "$DB" ".tables")

for TABLE in $TABLES; do
  COLUMNS=$(sqlite3 "$DB" "PRAGMA table_info($TABLE);" | cut -d'|' -f2)
  for COL in $COLUMNS; do
    MATCH=$(sqlite3 "$DB" "SELECT COUNT(*) FROM $TABLE WHERE $COL LIKE '%$SEARCH_STRING%';")
    if [ "$MATCH" -gt 0 ]; then
      echo "Deleting from $TABLE where $COL matches..."
      sqlite3 "$DB" "DELETE FROM $TABLE WHERE $COL LIKE '%$SEARCH_STRING%';"
    fi
  done
done

echo "Done."

1 Like

From the sounds of it, the message must be trapped in modem manager or something, and chatty is getting the cue to try and send it. Have you tried reaching out to support@puri.sm for assistance? It may take awhile but they would probably have an idea about what to do.

Another thing to try and figure out if it is the modem is use the kill switch to turn off the modem, reboot, and check if chatty still tries to send it.

1 Like

I got it sorted out.

  1. Deleted all files under /home/purism/.mms
  2. tried to run journal --verify got errors, fixed by deleting the journal with
    2b) sudo journalctl --rotate ; sudo journalctl --vacuum-time=1s
  3. pkill chatty
  4. deleted “bad” messages (previous delete.sh script)
  5. configured mms settings for moi mobile (isp mms settings for finnish operator)
    mkdir -p ~/.config/mms/
    nano ~/.config/mms/settings

pasted the text:

[MMS]
ModemManager=true
APN=mms.moi.fi
MMSC=http://mms.moi.fi
Proxy=185.12.64.5:80

That ip 185.12.64.5 does not seem to have anything to do with moi and also mms.moi.fi is not resolvable. But it works. I don’t know why and how, but it works. MMS works now ok to both directions and there are no more old mms jumping to end of the thread.

4 Likes

I don’t know why I see different setting there now.

Correct settings (I guess ?) are:

[Modem Manager]
CarrierMMSC=http://mmsc.dnafinland.fi
MMS_APN=mms
CarrierMMSProxy=10.1.1.2:8080
DefaultModemNumber=NULL
AutoProcessOnConnection=true
AutoProcessSMSWAP=true

IMSI= use your own
[Settings]
UseDeliveryReports=false
TotalMaxAttachmentSize=1100000
MaxAttachments=25
AutoCreateSMIL=false
ForceCAres=true

1 Like

MMS does not work ootb with your carrier because it uses different APN for mms and data. This is workaround for that Alaraajavamma / apn switcher for mms · GitLab

Getting rid of status files should help you afaik (~/.mms/modemmanager/)

2 Likes