Hello, the service won't start carbonio-ws-collaboration, there is an error in the log: org.postgresql.util.PSQLException: IMPORTANT: User "carbonio-ws-collaboration-db" failed authentication (password), Please tell me how to fix it!
@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(((
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.