The pgcrypto extension is needed for user password validation.
Run the following command in the Trip database:
$ psql trip CREATE EXTENSION pgcrypto;
This is also executed when running trip-server with the
--upgrade option.
There is a new table to handle user sessions. It is created after
running trip-server with the --upgrade option.
The Blowfish algorithm appears to have been changed in PostgreSQL 13. The following SQL will update old style encrypted passwords to work in PostgreSQL 13.
UPDATE usertable SET password = '$2a' || SUBSTRING(password, 4, 57) WHERE password NOT LIKE '$2a%';
This is also executed when running trip-server with the
--upgrade option.