GroupWise Mobility Version 11431 WARNING: database "datasync" has a collation version mismatch
To the GMS and django 4.2.6 security issue CVE-2024-53908 KM Doc which Caroline Oest has posted an addition: Thanks to Caroline for the info about the CVE
The following information may appear in GroupWise Mobility version 11431 after installation
WARNING: database "datasync" has a collation version mismatch
DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.38.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE datasync REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
WARNING: database "datasync" has a collation version mismatch
DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.38.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE datasync REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
WARNING: database "datasync" has a collation version mismatch
And other lines with similar messages
Solution as an example:
gms stop
systemctl status postgresql --> postgres shold running
psql -U datasync_user datasync
Password for user datasync_user:
WARNING: database "datasync" has a collation version mismatch
DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.38.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE datasync REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
psql (16.6, server 15.10)
Type "help" for help.
datasync=>
datasync=> \l
List of databases
Name | Owner | Encoding | Locale Provider | Collate | Ctype | ICU Locale | ICU Rules | Access privileges
-----------+---------------+----------+-----------------+-------------+-------------+------------+-----------+-----------------------
datasync | datasync_user | UTF8 | libc | en_US.UTF-8 | en_US.UTF-8 | | |
dsmonitor | datasync_user | UTF8 | libc | en_US.UTF-8 | en_US.UTF-8 | | |
mobility | datasync_user | UTF8 | libc | en_US.UTF-8 | en_US.UTF-8 | | |
postgres | postgres | UTF8 | libc | en_US.UTF-8 | en_US.UTF-8 | | |
template0 | postgres | UTF8 | libc | en_US.UTF-8 | en_US.UTF-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
template1 | postgres | UTF8 | libc | en_US.UTF-8 | en_US.UTF-8 | | | =c/postgres +
| | | | | | | | postgres=CTc/postgres
(6 rows)
datasync=> ALTER DATABASE datasync REFRESH COLLATION VERSION;
NOTICE: changing version from 2.31 to 2.38
ALTER DATABASE
datasync=>
datasync=> ALTER DATABASE dsmonitor REFRESH COLLATION VERSION;
NOTICE: changing version from 2.31 to 2.38
ALTER DATABASE
datasync=>
ALTER DATABASE
datasync=> ALTER DATABASE mobility REFRESH COLLATION VERSION;
NOTICE: changing version from 2.31 to 2.38
ALTER DATABASE
datasync=>
datasync-> \q
psql -U postgres
WARNING: database "postgres" has a collation version mismatch
DETAIL: The database was created using collation version 2.31, but the operating system provides version 2.38.
HINT: Rebuild all objects in this database that use the default collation and run ALTER DATABASE postgres REFRESH COLLATION VERSION, or build PostgreSQL with the right library version.
psql (16.6, server 15.10)
Type "help" for help.
postgres=# ALTER DATABASE postgres REFRESH COLLATION VERSION;
NOTICE: changing version from 2.31 to 2.38
ALTER DATABASE
If the user postgres throws an error during login in the pg_hba.conf
edit pg_hba.conf
# “local” is for Unix domain socket connections only
local all all trust
#local all postgres md5
#local all postgres peer
systemctl restart postgresql
alter database
Later change pg_hba.conf to the original settings
systemctl restart postgresql
gms start
check gms and check sync to phones
As always, if something is wrong here, please let me know about the error
Greetings
George
“You can't teach a person anything, you can only help them to discover it within themselves.” Galileo Galilei