Hi,

I would request you to reinstall Carbonio CE again instead of fixing it. To have a successful installation:

• Configure hostname

hostnamectl set-hostname mail.example.com

• Configure /etc/hosts

root@mail:~# > /etc/hosts
root@mail:~# echo "127.0.0.1 localhost" >> /etc/hosts
root@mail:~# echo "$(hostname -I) $(hostname -f) $(hostname -s)" >> /etc/hosts
root@mail:~# cat /etc/hosts

• Make sure to disable IPv6 and remove any reference of it from /etc/hosts
• Add Zextras Repository and import GPG key if applicable

Official Carbonio CE Repositories

• Download official script

Official Script Link

• Execute the script, For example, bash <script_name>

Notes:

• Make sure you note following credentials at the end of the installation process:
  • The service-discover password is:
  • The PostgreSQL password (DB_ADM_PWD) is:
• Reboot the server and set zextras password to login first time.

Set zextras password

Regards,

If everything setup properly, you should have output like:

root@mail:~# consul kv get -recurse -token-file="/etc/carbonio/ws-collaboration-db/service-discover/token" | grep -i name
carbonio-ws-collaboration-db/db-name:carbonio-ws-collaboration-db
carbonio-ws-collaboration-db/db-username:carbonio-ws-collaboration-db
root@mail:~#
root@mail:~# consul kv get -recurse -token-file="/etc/carbonio/ws-collaboration-db/service-discover/token" | grep -i pass
carbonio-ws-collaboration-db/db-password:dh4678435jksdjf8435lkhewortpojewr
root@mail:~#

Hi,

try followings:

## To retrieve the name] used in consul
root@mail:~# consul kv get -recurse -token-file="/etc/carbonio/ws-collaboration-db/service-discover/token" | grep -i name

## To retrieve the password stored in consul
root@mail:~# consul kv get -recurse -token-file="/etc/carbonio/ws-collaboration-db/service-discover/token" | grep -i password

## Now set the password
root@mail:~# su - postgres 
postgres@mail:~$ psql 
psql (16.2 (Ubuntu 16.2-1.pgdg22.04+1)) 
Type "help" for help. 

postgres=# 
postgres=# ALTER ROLE "carbonio-ws-collaboration-db" WITH PASSWORD 'xxxxxxxxxxxxxx'; 
ALTER ROLE 
postgres=# exit 

## Now restart services