All gists from swee

swee / Forgejo 14.0.0 SQLite to PostgreSQL

0 likes

0 forks

2 files

Last active 2 weeks ago

Do not change anything in lol, change the SQLITE_DB and DB_* variables in migrate.py

1	import sqlite3
2	import psycopg2
3	import re
4	from datetime import datetime
5
6	# Change these
7	SQLITE_DB = "forgejo.db"
8	DB_NAME = "forgejodb"
9	DB_USER = "forgejo"
10	DB_PASS = "hunter2"

swee / gistfile1.txt

0 likes

0 forks

1 files

Last active 2 weeks ago

1	version - all implicit
2	id, version
3
4	forgejo_version - all implicit
5	id, version
6
7	forgejo_sem_ver - all implicit
8	version
9
10	forgejo_migration - all implicit

swee / gistfile1.txt

0 likes

0 forks

1 files

Last active 2 weeks ago

1	swee @ 󰛳 10.0.0.208  licorice
2	 UwU $ ifconfig eth0
3	eth0: flags=4163<UP,BROADCAST,RUNNING,MULTICAST> mtu 1500
4	inet 10.0.0.160 netmask 255.255.255.0 broadcast 0.0.0.0
5	inet6 fe80::e654:e8ff:fe75:f1be prefixlen 64 scopeid 0x20<link>
6	ether e4:54:e8:75:f1:be txqueuelen 1000 (Ethernet)
7	RX packets 34487631 bytes 19795597723 (18.4 GiB)
8	RX errors 0 dropped 398 overruns 0 frame 0
9	TX packets 50316162 bytes 48600710738 (45.2 GiB)
10	TX errors 0 dropped 5 overruns 0 carrier 0 collisions 0

swee / gistfile1.txt

0 likes

0 forks

1 files

Last active 2 weeks ago

1	root@oreo:~ # jexec thelounge
2	root@thelounge:/ # service thelounge stop
3	Stopping thelounge.
4	Waiting for PIDS: 57109.
5	root@thelounge:/ # su thelounge
6	$ THELOUNGE_HOME="/usr/local/etc/thelounge" thelounge start
7	2026-01-31 19:24:45 [INFO] The Lounge v4.4.3 (Node.js 24.12.0 on freebsd x64)
8	2026-01-31 19:24:45 [INFO] Configuration file: /usr/local/etc/thelounge/config.js
9	2026-01-31 19:24:45 [INFO] Available at http://[::]:9000/ in private mode
10	2026-01-31 19:24:45 [INFO] Package thelouge-theme-infinite v1.0.0 loaded

swee / the_error

0 likes

0 forks

2 files

Last active 2 weeks ago

1	Jan 31 11:04:17 thelounge daemon[80436]: node:internal/process/promises:394 triggerUncaughtException(err, true /* fromPromise */); ^ [Error: SQLITE_ERROR: no such column: "message" - should this be a string literal in single-quotes?] { errno: 1, code: 'SQLITE_ERROR' } Node.js v24.12.0

swee / gistfile1.txt

0 likes

0 forks

1 files

Last active 2 weeks ago

1	root@oreo:~ # du -d 1 -h /usr/jail/thelounge/usr/local/etc/thelounge/logs/
2	1.0G /usr/jail/thelounge/usr/local/etc/thelounge/logs/swee
3	1.1M /usr/jail/thelounge/usr/local/etc/thelounge/logs/baconhair1ty647
4	172K /usr/jail/thelounge/usr/local/etc/thelounge/logs/zwr
5	1.2M /usr/jail/thelounge/usr/local/etc/thelounge/logs/Lai0602
6	148K /usr/jail/thelounge/usr/local/etc/thelounge/logs/DiscreetBow
7	228M /usr/jail/thelounge/usr/local/etc/thelounge/logs/depresst0
8	34M /usr/jail/thelounge/usr/local/etc/thelounge/logs/chip01
9	28K /usr/jail/thelounge/usr/local/etc/thelounge/logs/madinga
10	1.1M /usr/jail/thelounge/usr/local/etc/thelounge/logs/B-41

swee / links to remember

0 likes

0 forks

1 files

Last active 2 weeks ago

https://github.com/matrix-org/complement https://github.com/element-hq/dendrite

swee / gistfile1.txt

0 likes

0 forks

1 files

Last active 2 weeks ago

1	# Device Mountpoint FStype Options Dump Pass#
2	/dev/ada0p2 / ufs rw 1 1
3	/dev/ada0p1 /boot/efi msdosfs rw 2 2
4	/dev/ada0p3 none swap sw 0 0
5	192.168.122.1:/srv/thelounge /usr/local/etc/thelounge/uploads nfs rw 0 0

swee / APKBUILD

0 likes

0 forks

2 files

Last active 2 weeks ago

1	$ abuild rootbld
2	>>> dataurlify: Validating /home/swee/Forks/aports/testing/dataurify/APKBUILD...
3	>>> dataurlify: Cleaning up srcdir
4	>>> dataurlify: Cleaning up pkgdir
5	>>> dataurlify: Cleaning up tmpdir
6	>>> dataurlify: Fetching dataurlify-1.0.tar.gz::https://git.swee.codes/swee/dataurlify/archive/1.0.tar.gz
7	/var/cache/distfiles/dataurlify-1.0.tar.gz: OK
8	>>> dataurlify: Preparing build chroot...
9	WARNING: opening /home/swee/packages//main/x86_64/APKINDEX.tar.gz: No such file or directory
10	WARNING: opening /home/swee/packages//community/x86_64/APKINDEX.tar.gz: No such file or directory

swee / gistfile1.txt

0 likes

0 forks

1 files

Last active 2 weeks ago

1	$ sudo apk list --orphaned
2	WARNING: The indexes contain broken packages which might not function properly.
3	arc-dark-gtk2-20221218-r0 x86_64 {arc-theme} (GPL-3.0-or-later) [installed]
4	qcoro-qt6-0.12.0-r1 x86_64 {qcoro} (MIT) [installed]
5	tree-sitter-tsq-0.19.0-r2 x86_64 {tree-sitter-tsq} (MIT) [installed]
6	xwaylandvideobridge-0.4.0-r1 x86_64 {xwaylandvideobridge} (BSD-3-Clause AND LGPL-2.0-or-later) [installed]
7	$ sudo apk del qcoro-qt6
8	WARNING: The indexes contain broken packages which might not function properly.
9	World updated, but the following packages are not removed due to:
10	qcoro-qt6: plasma-nm powerdevil