Annotate

tools/xepchanges.sh @ 13633:6b84d11aa09b

mod_storage_sql: Detect SQLite3 without UPSERT (or SQLCipher 3.x) SQLCipher v3.4.1 (the version in Debian 12) is based on SQLite3 v3.15.2, while UPSERT support was introduced in SQLite3 v3.24.0 This check was not needed before because we v3.24.0 has not been in a version of Debian we support for a long, long time. Note however that SQLCipher databases are not compatible across major versions, upgrading from v3.x to v4.x requires executing a migration. Attempts at making `prosodyctl mod_storage_sql upgrade` perform such a migration has not been successful. Executing the following in the `sqlcipher` tool should do the migration: PRAGMA key = '<key material>'; PRAGMA cipher_migrate;
author Kim Alvefur <zash@zash.se>
date Thu, 23 Jan 2025 19:33:05 +0100
parent 13383:091667bd2f0e
Ignore whitespace changes - Everywhere: Within whitespace: At end of lines:
rev   line source
13383
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
1 #!/bin/sh -eu
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
2
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
3 wget -N https://xmpp.org/extensions/xeplist.xml
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
4 xml2 <xeplist.xml |
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
5 2csv xep-infos/xep number version |
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
6 grep -v ^xxxx,|
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
7 sort -g > xepinfos.csv
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
8
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
9 xml2 < doc/doap.xml |
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
10 2csv -d ' ' xmpp:SupportedXep @rdf:resource xmpp:version |
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
11 sed -r 's/https?:\/\/xmpp\.org\/extensions\/xep-0*([1-9][0-9]*)\.html/\1/' |
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
12 while read -r xep ver ; do
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
13 grep "^$xep," xepinfos.csv | awk -F, "\$2 != \"$ver\" { print (\"XEP-\"\$1\" updated to \"\$2\" from $ver\") }"
091667bd2f0e tools: Add a tool for comparing DOAP to the latest XEP versions
Kim Alvefur <zash@zash.se>
parents:
diff changeset
14 done