KanServer - Revision history

JuliaLongtin: /* Postgres 17 + DocumentDB */

2026-01-12T00:26:09Z

Postgres 17 + DocumentDB

← Older revision		Revision as of 00:26, 12 January 2026
Line 25:		Line 25:
	Edit /etc/postgresql/17/main/postgresql.conf		Edit /etc/postgresql/17/main/postgresql.conf
	* set '''shared_preload_libraries = 'pg_cron, pg_documentdb, pg_documentdb_core''''		* set '''shared_preload_libraries = 'pg_cron, pg_documentdb, pg_documentdb_core''''


			edit /etc/postgresql/17/main/pg_hba.conf
			* replace '''scram-sha-256'' with '''trust''' on the '''host'' lines for '''127.0.0.1/32''' and '''::1/128'''

	sudo service postgresql restart		sudo service postgresql restart

2026-01-12T00:14:51Z

FerretDB

← Older revision		Revision as of 00:14, 12 January 2026
Line 33:		Line 33:
	rm /tmp/ferretdb-amd64-linux.deb		rm /tmp/ferretdb-amd64-linux.deb

	edit your /etc/systemd/system/~~ferritdb~~.service file		edit your /etc/systemd/system/ferretdb.service file
	* Add your username/password pair to the following line:		* Add your username/password pair to the following line:
	'''Environment="FERRETDB_POSTGRESQL_URL=postgres://ferret:<DB_PASSWORD_GOES_HERE>@127.0.0.1:5432/postgres"'''		'''Environment="FERRETDB_POSTGRESQL_URL=postgres://ferret:<DB_PASSWORD_GOES_HERE>@127.0.0.1:5432/postgres"'''

2026-01-12T00:13:43Z

Postgres 17 + DocumentDB

← Older revision		Revision as of 00:13, 12 January 2026
Line 19:		Line 19:

	sudo bash -c 'curl -fsSL https://repo.pigsty.io/pig \| bash'		sudo bash -c 'curl -fsSL https://repo.pigsty.io/pig \| bash'
	pig repo add ~~all~~ -u		pig repo add pgsql -u
	pig ext install pg17		pig ext install pg17
	pig ext install documentdb		pig ext install documentdb

2026-01-11T23:00:26Z

WeKan

← Older revision		Revision as of 23:00, 11 January 2026
Line 12:		Line 12:
	sudo npm -g install @mapbox/node-pre-gyp		sudo npm -g install @mapbox/node-pre-gyp
	sudo npm -g install meteor@2.14 --unsafe-perm		sudo npm -g install meteor@2.14 --unsafe-perm
	export PATH=$PATH:~~/home/demo~~/.meteor		export PATH=$PATH:$HOME/.meteor
	meteor npm install production		meteor npm install production
	meteor build .build --directory --platforms=web.browser		meteor build .build --directory --platforms=web.browser

2026-01-11T22:59:32Z

Launching WeKan

← Older revision		Revision as of 22:59, 11 January 2026
Line 58:		Line 58:

	== Launching WeKan ==		== Launching WeKan ==
	export PATH=$PATH:~~/home/demo~~/.meteor		export PATH=$PATH:$HOME/.meteor
	cd ~/wekan		cd ~/wekan
	MONGO_URL=mongodb://ferret:<DB_PASSWORD_GOES_HERE>@127.0.0.1:27017/wekan WRITABLE_PATH=.. WITH_API=true RICHER_CARD_COMMENT_EDITOR=false ROOT_URL=https://kan.faikvm.com meteor run --exclude-archs web.browser.legacy,web.cordova --port 8080 2>&1 \| tee ../wekan-log.`date +%s`.txt		MONGO_URL=mongodb://ferret:<DB_PASSWORD_GOES_HERE>@127.0.0.1:27017/wekan WRITABLE_PATH=.. WITH_API=true RICHER_CARD_COMMENT_EDITOR=false ROOT_URL=https://kan.faikvm.com meteor run --exclude-archs web.browser.legacy,web.cordova --port 8080 2>&1 \| tee ../wekan-log.`date +%s`.txt

2026-01-11T22:57:37Z

FerretDB

← Older revision		Revision as of 22:57, 11 January 2026
Line 31:		Line 31:
	curl -L https://github.com/FerretDB/FerretDB/releases/download/v2.7.0/ferretdb-amd64-linux.deb -o /tmp/ferretdb-amd64-linux.deb		curl -L https://github.com/FerretDB/FerretDB/releases/download/v2.7.0/ferretdb-amd64-linux.deb -o /tmp/ferretdb-amd64-linux.deb
	sudo dpkg -i /tmp/ferretdb-amd64-linux.deb		sudo dpkg -i /tmp/ferretdb-amd64-linux.deb
			rm /tmp/ferretdb-amd64-linux.deb

	edit your /etc/systemd/system/ferritdb.service file		edit your /etc/systemd/system/ferritdb.service file

2026-01-11T22:56:40Z

Initializing the Database

← Older revision		Revision as of 22:56, 11 January 2026
Line 42:		Line 42:
	su -		su -
	su - postgres		su - postgres
			psql
	CREATE ROLE ferret WITH PASSWORD '<DB_PASSWORD_GOES_HERE>';		CREATE ROLE ferret WITH PASSWORD '<DB_PASSWORD_GOES_HERE>';
	CREATE DATABASE ferretdb;		CREATE DATABASE ferretdb;

2026-01-11T22:04:46Z

Initializing the Database

← Older revision		Revision as of 22:04, 11 January 2026
Line 42:		Line 42:
	su -		su -
	su - postgres		su - postgres
	CREATE ROLE ferret WITH PASSWORD '<~~PASSWORD_GOES_HERE~~>';		CREATE ROLE ferret WITH PASSWORD '<DB_PASSWORD_GOES_HERE>';
	CREATE DATABASE ferretdb;		CREATE DATABASE ferretdb;
	GRANT ALL PRIVILEGES ON DATABASE ferretdb TO ferret;		GRANT ALL PRIVILEGES ON DATABASE ferretdb TO ferret;

2026-01-11T22:03:24Z

FerretDB

← Older revision		Revision as of 22:03, 11 January 2026
Line 31:		Line 31:
	curl -L https://github.com/FerretDB/FerretDB/releases/download/v2.7.0/ferretdb-amd64-linux.deb -o /tmp/ferretdb-amd64-linux.deb		curl -L https://github.com/FerretDB/FerretDB/releases/download/v2.7.0/ferretdb-amd64-linux.deb -o /tmp/ferretdb-amd64-linux.deb
	sudo dpkg -i /tmp/ferretdb-amd64-linux.deb		sudo dpkg -i /tmp/ferretdb-amd64-linux.deb

			edit your /etc/systemd/system/ferritdb.service file
			* Add your username/password pair to the following line:
			'''Environment="FERRETDB_POSTGRESQL_URL=postgres://ferret:<DB_PASSWORD_GOES_HERE>@127.0.0.1:5432/postgres"'''

	sudo systemctl enable ferretdb.service		sudo systemctl enable ferretdb.service
	sudo service ferretdb start		sudo service ferretdb start

2026-01-11T21:08:23Z

Initializing the Database

← Older revision		Revision as of 21:08, 11 January 2026
Line 45:		Line 45:
	GRANT USAGE ON SCHEMA documentdb_core to ferret;		GRANT USAGE ON SCHEMA documentdb_core to ferret;
	GRANT USAGE ON SCHEMA documentdb_api_internal to ferret;		GRANT USAGE ON SCHEMA documentdb_api_internal to ferret;
			GRANT USAGE ON SCHEMA documentdb_api_catalog to ferret;
			GRANT INSERT ON TABLE documentdb_api_catalog.collections to ferret;
			GRANT ALL ON SCHEMA documentdb_data to ferret;
			GRANT documentdb_admin_role to ferret;

	== Launching WeKan ==		== Launching WeKan ==