carbonio-ws-collaboration.service status=1/FAILURE

@anplusnin2

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

@sharif When I run these commands "consul kv get -recurse …" I get empty output(((

@anplusnin2 

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:~#

@sharif Sorry, I don't have the same conclusion as you.

General conclusion:
xxxxxxx@mail:~$ sudo consul kv get -recurse -token-file="/etc/carbonio/ws-collaboration-db/service-discover/token"
carbonio-ws-collaboration/broker/automatic-recovery-enabled:true
carbonio-ws-collaboration/broker/connection-timeout-in-milli:60000
carbonio-ws-collaboration/broker/network-recovery-interval:30000
carbonio-ws-collaboration/broker/requested-heartbeat-in-sec:60
carbonio-ws-collaboration/broker/topology-recovery-enabled:false
carbonio-ws-collaboration/broker/virtual-host:/
carbonio-ws-collaboration/configs/can-see-message-reads:true
carbonio-ws-collaboration/configs/can-see-users-presence:true
carbonio-ws-collaboration/configs/can-use-virtual-background:true
carbonio-ws-collaboration/configs/can-video-call:true
carbonio-ws-collaboration/configs/delete-message-time-limit-in-minutes:10
carbonio-ws-collaboration/configs/edit-message-time-limit-in-minutes:10
carbonio-ws-collaboration/configs/max-group-members:128
carbonio-ws-collaboration/configs/max-room-image-size-in-kb:512
carbonio-ws-collaboration/configs/max-user-image-size-in-kb:512
carbonio-ws-collaboration/hikari/idle-timeout:10000
carbonio-ws-collaboration/hikari/leak-detection-threshold:5000
carbonio-ws-collaboration/hikari/max-lifetime:600000
carbonio-ws-collaboration/hikari/max-pool-size:10
carbonio-ws-collaboration/hikari/min-pool-size:10
carbonio-ws-collaboration/server/max-queue-requests:2048
carbonio-ws-collaboration/server/max-threads:2048
carbonio-ws-collaboration/server/min-threads:8

I must have missed something during setup. Please tell me how to set it up again.

@anplusnin2 

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,