3.2 Database Changes

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.

3.2.1 Session Table

There is a new table to handle user sessions. It is created after running trip-server with the --upgrade option.

3.2.2 Passwords

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.