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

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

Error using port 587 SSL:
Jun 12 10:02:12 mail postfix/submission/smtpd: SSL_accept error from unknown: -1
Jun 12 10:02:12 mail postfix/submission/smtpd: 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: lost connection after STARTTLS from unknown
Jun 12 10:02:12 mail postfix/submission/smtpd: disconnect from unknown ehlo=1 starttls=0/1 commands=1/2

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

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.

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

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

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 !

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

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

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 Ubuntu 20.04LTS 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. apt clean

4. apt update && apt full-upgrade

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;

apt 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:

apt 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

apt 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

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

apt 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

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

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

apt 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

A reference video link:
Upgradation From Carbonio Ce 23.11.0 to 23.12.0 Workstream Collaboration