[Sticky] Upgradation From Carbonio CE 23.11.0 to 23.12.0 Workstream Collaboration

i find this problem in the process:

After spending the day testing and testing and testing I can now say that it works but requires some care on the steps above and some extra ones to make also Meeting work properly. I'll let the why to devs to answer, all I can tell you is how to make it work.

carbonio-message-dispatcher-migration

This one is the tricky one. If it fails you must wait like 5 minutes and try again. There is something running in background that takes that time to be done and allow it to run successfully.

So, insist running it till it works:

PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000

 Once that one is done follow all the rest of the tutorial above. It will work.

Meeting

This is just an awesome feature that is just there and doesn't work out of the box, but just because you need to do two minor setups. Credits to Elio Junior from Brazil for figure this out, TYVM!. So...

1 - Edit /etc/janus/janus.jcfg file, look for nat_1_1_mapping and change it with your external IP;

2 - You must allow or redirect all range of ports 20000-40000 on UDP protocol on your Firewall.

Ending

Reboot the whole server... and when it's back, when all services are up and running... restart this services:

systemctl enable carbonio-tasks
systemctl enable carbonio-videoserver
systemctl restart carbonio-prometheus-nginx-exporter

Wait another minute or two and give it a try.

Telegram: https://t.me/CarbonioMail

@aizen 

Could you please save the value again just before executing the below mentioned PGPASSWORD command:

read -s -p "Password:" DB_ADM_PWD

Then execute:

PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000

I noticed, somehow the value does not reflect properly if set long before. 
Please try this and let us know!

Thanks,

Sharif

Hi Guys,

I have prepared a draft of the upgradation from Carbonio CE 23.11.0 to Carbonio CE 23.12.0 workstream collaboration in step by step format. BTW all the information is available in the documentation (docs.zextras.com); I just summed it up for you.

Simplified version of steps: For RHEL8 Single Server

You can always check with official documentation for updated information.
Upgradation Documentation.

*** A surprise lurks within the post. 

1. Take backup - Take Backup - Take Backup

2. Stop Services

3. dnf clean all

4. dnf upgrade --allowerasing

5. Bootstrap existing DB

PGPASSWORD=(DB_Password created during installation) carbonio-files-db-bootstrap carbonio_adm 127.0.0.1

If you have carbonio-tasks installed during 23.11.0, then bootstrap tasks db in this step

PGPASSWORD=(DB_Password created during installation) carbonio-tasks-db-bootstrap carbonio_adm 127.0.0.1

But it you did not install carbonio-tasks earlier then, we will do it later.

6. reboot

7. restart all services

8. Install additional packages:

Install carbonio-tasks if not done before;

dnf install carbonio-tasks-db carbonio-tasks-ce carbonio-tasks-ui
pending-setups -a
PGPASSWORD=(DB_Password created during installation) carbonio-files-db-bootstrap carbonio_adm 127.0.0.1

9. Workstream Collaboration Setup:

dnf install carbonio-message-dispatcher-db -y
pending-setups -a
PGPASSWORD=(DB_Password created during installation) carbonio-message-dispatcher-db-bootstrap carbonio_adm 127.0.0.1

dnf install carbonio-message-dispatcher -y
pending-setups -a
PGPASSWORD=(DB_Password created during installation) carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000

dnf install carbonio-message-broker -y
pending-setups -a

dnf install carbonio-ws-collaboration-db -y
pending-setups -a
PGPASSWORD=(DB_Password created during installation) carbonio-ws-collaboration-db-bootstrap carbonio_adm 127.0.0.1

dnf install carbonio-ws-collaboration-ce -y
pending-setups -a

dnf install carbonio-videoserver-ce -y
pending-setups -a

dnf install carbonio-ws-collaboration-ui -y
su - zextras -c "carbonio prov mc default carbonioFeatureChatsEnabled TRUE"

10. Restart Services:

systemctl enable carbonio-tasks
systemctl restart carbonio-tasks

systemctl enable carbonio-videoserver
systemctl restart carbonio-videoserver

systemctl restart carbonio-prometheus-nginx-exporter.service

su - zextras -c "zmcontrol restart"

11. Check status of services:

su - zextras -c "zmcontrol -v"
su - zextras -c "zmcontrol restart"
su - zextras -c "zmcontrol status"
systemctl list-units carbonio*

12. Restart the server and restart mentioned services as per the order shown below:

reboot now

systemctl restart carbonio-message-broker
systemctl restart carbonio-videoserver
systemctl restart carbonio-ws-collaboration
systemctl restart carbonio-prometheus-nginx-exporter.service

And that's it !

strangely all the PGPASSWORD command needs another user, because carbonio_adm is unknown  as user for PG I have to utilise carbonio-files-adm instead. When does this change ?

As a new Carbonio admin I have some questions about step 2 and 7 for Ubuntu 20.04 single server.

What is "services" and "all services"? zmcontrol stop? And what about the systemctl services? As an old Zimbra admin I am not used to running this command.

How do I know if I have Carbonio-tasks installed? Do I need Carbonio-tasks? And if I just want email, contacts and calender do I need to install the Workstream collaboration?

Sorry for all the questions but it is not that simple if you are not working full time with Carbonio.

Thanks

//Sigtrap

@sigrtap

Posted by: @sigtrap

↑

What is "services" and "all services"? zmcontrol stop? And what about the systemctl services? As an old Zimbra admin I am not used to running this command.

I think the single-server installatin has changes, what does "all services" refer to? If you mean "you can check that all Carbonio CE services are running, by using" I mean servies managed by systemctl, so all carbonio-* units.

Posted by: @sigtrap

↑

How do I know if I have Carbonio-tasks installed? Do I need Carbonio-tasks? And if I just want email, contacts and calender do I need to install the Workstream collaboration?

* You can check if Tasks is installed using either the package manager and see if packages carbonio-tasks-ce carbonio-tasks-db carbonio-tasks-ui are installed or you can check the output of systemctl status carbonio-tasks.service

* You do not need WSC if you do not want chats & video calls

Hi All,

anyone have same problem with me? regarding SSL Connection from SQL?

Error using  port 465.:
Jun 12 09:59:52 mail postfix/smtps/smtpd[1057024]: connect from unknown[103.109.195.38]
Jun 12 09:59:52 mail postfix/smtps/smtpd[1057024]: SSL_accept error from unknown[103.109.195.38]: lost connection
Jun 12 09:59:52 mail postfix/smtps/smtpd[1057024]: lost connection after CONNECT from unknown[103.109.195.38]
Jun 12 09:59:52 mail postfix/smtps/smtpd[1057024]: disconnect from unknown[103.109.195.38] commands=0/0

Error using port 587 SSL:
Jun 12 10:02:12 mail postfix/submission/smtpd[1061318]: SSL_accept error from unknown[182.253.20.148]: -1
Jun 12 10:02:12 mail postfix/submission/smtpd[1061318]: warning: TLS library problem: error:14209102:SSL routines:tls_early_post_process_client_hello:unsupported protocol:ssl/statem/statem_srvr.c:1685:
Jun 12 10:02:12 mail postfix/submission/smtpd[1061318]: lost connection after STARTTLS from unknown[182.253.20.148]
Jun 12 10:02:12 mail postfix/submission/smtpd[1061318]: disconnect from unknown[182.253.20.148] ehlo=1 starttls=0/1 commands=1/2

Error Using Port 587 without SSL:
Jun 12 10:04:38 mail postfix/submission/smtpd[1061318]: NOQUEUE: reject: RCPT from unknown[182.253.20.148]: 554 5.7.1 : Client host rejected: Access denied; from= to= proto=ESMTP helo=
Jun 12 10:04:38 mail postfix/submission/smtpd[1061318]: lost connection after RCPT from unknown[182.253.20.148]