Ubuntu 24.04 Community Edition Manual Installation - broken and cannot proceed

Hi there, I wonder why you did not use the installation script provided.

Of importance, I think, is the preliminary steps:

https://docs.zextras.com/carbonio-ce/html/install/preliminary.html

And the script:

https://docs.zextras.com/carbonio-ce/html/install/scenarios/single-server-scenario.html

Sorry I am not much else of help.

Posted by: @iamout

↑

Hi there, I wonder why you did not use the installation script provided.

Of importance, I think, is the preliminary steps:

<a href=" removed link " target="_blank" rel="noopener"> removed link

And the script:

<a href=" removed link " target="_blank" rel="noopener"> removed link

 

Sorry I am not much else of help.

 

 

1. Because the manual steps are documented and I wanted as much control over how the system was being set up as possible. Why have them documented if they're not "okay" to follow?

2. I followed all the preliminary steps already. I outlined that I "followed the Manual Installation steps to the letter (the official documentation)" in the first line of my post.

3. I really was hoping to have specific feedback on where I could have missed something, instead of just being told to run the script, and read the documentation again, without being specific.

I appreciate you taking the time to chime in, but this doesn't tell me why it "broke" at the step it did.

Help in this forum is not instant and it takes sometime days to week(s) for an answer. It is what it is. I use Zimbra as my main email server.

Have installed Carbonio CE a few times using the script when I first started and it did not go well and wasted 2-3 days. I was very frustrated. It actually was the Fan made script, can be found on the forum as well.

You could also join Anahuac @ Telegram - can also be found doing a search. He also has a script for installation.

Well, it is up to you. A script installation might be the short answer.

Posted by: @iamout

↑

Help in this forum is not instant and it takes sometime days to week(s) for an answer. It is what it is. I use Zimbra as my main email server.

Have installed Carbonio CE a few times using the script when I first started and it did not go well and wasted 2-3 days. I was very frustrated. It actually was the Fan made script, can be found on the forum as well.

You could also join Anahuac @ Telegram - can also be found doing a search. He also has a script for installation.

Well, it is up to you. A script installation might be the short answer.

I would rather work on solutions on the public form so that search engines can index the content, and it can help other people. That and I really don't want to install yet another chat app for a single purpose and make yet another account for said thing. Help will come whenever it does, and come what may.

Alright, not to worry. Have you tried again to install Carbonio CE?

When I run 

sudo pending-setups -a

Everything is OK - until I get to 

Config entry written: service-defaults/carbonio-message-dispatcher-auth
Config entry written: service-intentions/carbonio-message-dispatcher-auth
Config entry written: service-defaults/carbonio-message-dispatcher-http
Config entry written: service-intentions/carbonio-message-dispatcher-http
Config entry written: service-defaults/carbonio-message-dispatcher-xmpp
Config entry written: service-intentions/carbonio-message-dispatcher-xmpp
Carbonio Message Dispatcher database password not found.
Please install carbonio-message-dispatcher-db and run carbonio-message-dispatcher-db-bootstrap command.
Script for Message Dispatcher terminated with error
Setup script failed, keeping it

The weird thing is when I run this to setup the database password:-

sudo PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-db-bootstrap carbonio_adm 127.0.0.1

I enter the carbonio_adm password that I know is correct but it comes back with error:-

Password for user carbonio_adm: 
Check postgres connection: psql: FATAL ERROR (exit code 2).
(see EXIT STATUS section in psql man documentation)

I then go to manually reset  the password like this:-

sudo -u postgres psql
ALTER USER carbonio_adm WITH PASSWORD 'xxxxxxx';

and then run this again:-

sudo PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-db-bootstrap carbonio_adm 127.0.0.1

it comes back and is OK:-

Database: 127.0.0.1:5432 user carbonio_adm
Password for user carbonio_adm: 
Check postgres connection: OK
Password for user carbonio_adm: 
Current version is: .
Database already initialized! Quitting

Now when I run this again:-

sudo pending-setups -a

I get the same error:-

Config entry written: service-defaults/carbonio-message-dispatcher-auth
Config entry written: service-intentions/carbonio-message-dispatcher-auth
Config entry written: service-defaults/carbonio-message-dispatcher-http
Config entry written: service-intentions/carbonio-message-dispatcher-http
Config entry written: service-defaults/carbonio-message-dispatcher-xmpp
Config entry written: service-intentions/carbonio-message-dispatcher-xmpp
Carbonio Message Dispatcher database password not found.
Please install carbonio-message-dispatcher-db and run carbonio-message-dispatcher-db-bootstrap command.
Script for Message Dispatcher terminated with error
Setup script failed, keeping it

so it would appear that at some point when the script pending-setups -a is being run the database account for carbonio_adm is being deleted or reset. 

When I run 

sudo pending-setups -a

Everything is OK - until I get to 

Config entry written: service-defaults/carbonio-message-dispatcher-auth
Config entry written: service-intentions/carbonio-message-dispatcher-auth
Config entry written: service-defaults/carbonio-message-dispatcher-http
Config entry written: service-intentions/carbonio-message-dispatcher-http
Config entry written: service-defaults/carbonio-message-dispatcher-xmpp
Config entry written: service-intentions/carbonio-message-dispatcher-xmpp
Carbonio Message Dispatcher database password not found.
Please install carbonio-message-dispatcher-db and run carbonio-message-dispatcher-db-bootstrap command.
Script for Message Dispatcher terminated with error
Setup script failed, keeping it

The weird thing is when I run this to setup the database password:-

sudo PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-db-bootstrap carbonio_adm 127.0.0.1

I enter the carbonio_adm password that I know is correct but it comes back with error:-

Password for user carbonio_adm: 
Check postgres connection: psql: FATAL ERROR (exit code 2).
(see EXIT STATUS section in psql man documentation)

I then go to manually reset  the password like this:-

sudo -u postgres psql
ALTER USER carbonio_adm WITH PASSWORD 'xxxxxxx';

and then run this again:-

sudo PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-db-bootstrap carbonio_adm 127.0.0.1

it comes back and is OK:-

Database: 127.0.0.1:5432 user carbonio_adm
Password for user carbonio_adm: 
Check postgres connection: OK
Password for user carbonio_adm: 
Current version is: .
Database already initialized! Quitting

Now when I run this again:-

sudo pending-setups -a

I get the same error:-

Config entry written: service-defaults/carbonio-message-dispatcher-auth
Config entry written: service-intentions/carbonio-message-dispatcher-auth
Config entry written: service-defaults/carbonio-message-dispatcher-http
Config entry written: service-intentions/carbonio-message-dispatcher-http
Config entry written: service-defaults/carbonio-message-dispatcher-xmpp
Config entry written: service-intentions/carbonio-message-dispatcher-xmpp
Carbonio Message Dispatcher database password not found.
Please install carbonio-message-dispatcher-db and run carbonio-message-dispatcher-db-bootstrap command.
Script for Message Dispatcher terminated with error
Setup script failed, keeping it

so it would appear that at some point when the script pending-setups -a is being run the database account for carbonio_adm is being deleted or reset. 

I then run just this particular script:-

sudo sh /etc/zextras/pending-setups.d/carbonio-message-dispatcher.sh

and try having the /usr/bin/ before the script like:-

sudo PGPASSWORD=$DB_ADM_PWD /usr/bin/carbonio-message-dispatcher-db-bootstrap carbonio_adm 127.0.0.1

I get success:-

Database: 127.0.0.1:5432 user carbonio_adm
Password for user carbonio_adm: 
Check postgres connection: OK
Password for user carbonio_adm: 
Current version is: .
Database already initialized! Quitting

Interestingly - Current version is . - should it show something else?

when I run this again:-

sudo sh /etc/zextras/pending-setups.d/carbonio-message-dispatcher.sh

I get the same error. 

ID:           37291f10-ad9e-e953-b6bc-48a282472b14
Name:         carbonio-message-dispatcher-policy
Description:  Carbonio Message Dispatcher policy for service and sidecar proxy
Datacenters:  
Rules:
{
  "key_prefix": [
    {
      "carbonio-message-dispatcher/": {
        "policy": "write"
      },
      "carbonio-message-dispatcher-db/": {
        "policy": "read"
      }
    }
  ],
  "node_prefix": [
    {
      "": {
        "policy": "read"
      }
    }
  ],
  "service": [
    {
      "carbonio-message-dispatcher-xmpp": {
        "policy": "write"
      },
      "carbonio-message-dispatcher-http": {
        "policy": "write"
      },
      "carbonio-message-dispatcher-auth": {
        "policy": "write"
      },
      "carbonio-message-dispatcher-http-sidecar-proxy": {
        "policy": "write"
      },
      "carbonio-message-dispatcher-xmpp-sidecar-proxy": {
        "policy": "write"
      },
      "carbonio-message-dispatcher-auth-sidecar-proxy": {
        "policy": "write"
      }
    }
  ]
}

Config entry written: service-defaults/carbonio-message-dispatcher-auth
Config entry written: service-intentions/carbonio-message-dispatcher-auth
Config entry written: service-defaults/carbonio-message-dispatcher-http
Config entry written: service-intentions/carbonio-message-dispatcher-http
Config entry written: service-defaults/carbonio-message-dispatcher-xmpp
Config entry written: service-intentions/carbonio-message-dispatcher-xmpp
Carbonio Message Dispatcher database password not found.
Please install carbonio-message-dispatcher-db and run carbonio-message-dispatcher-db-bootstrap command.
Script for Message Dispatcher terminated with error

I was eventually able to fix the issue by running these two line:-

consul kv put carbonio/message-dispatcher/db-password "$NEW_PWD"
consul kv put carbonio-message-dispatcher/db-password "$NEW_PWD"

change $NEW_PWD with the password that you are using. 

don't run the above as root; just run as your normal user

and then 

sudo pending-setups -a

I did go into the database to manually create the databases/tables too in case they hadn't been created 

sudo -u postgres psql

# 2. Inside psql — paste these 4 lines exactly
CREATE USER carbonio_message_dispatcher WITH ENCRYPTED PASSWORD 'TempStrongPass123!';
CREATE DATABASE carbonio_message_dispatcher_db OWNER carbonio_message_dispatcher;
GRANT ALL PRIVILEGES ON DATABASE carbonio_message_dispatcher_db TO carbonio_message_dispatcher;
\c carbonio_message_dispatcher_db
GRANT ALL ON SCHEMA public TO carbonio_message_dispatcher;

# 3. Exit psql
\q