Hello!
I updated according to the Carbonio documentation,
from Ubuntu 22.04 to 24.04 and from Carbonio to the latest version, the previous one being 24.X.
Everything went well, but in the logs I keep seeing this:
set 10 01:40:08 srv-mail postfix/postscreen[6398]: CONNECT from [172.16.150.3]:56735 to [192.168.255.20]:25
set 10 01:40:08 srv-mail service-discoverd[3236]: 2025-09-10T01:40:08.696-0300 [WARN] agent: Check TCP connection failed: check=service:carbonio-mailbox-db error="dial tcp 127.0.0.1:5432: connect: connection refused"
set 10 01:40:08 srv-mail service-discoverd[3236]: 2025-09-10T01:40:08.696-0300 [WARN] agent: Check is now critical: check=service:carbonio-mailbox-db
set 10 01:40:08 srv-mail service-discoverd[3236]: 2025-09-10T01:40:08.696-0300 [WARN] agent: Check TCP connection failed: check=service:carbonio-ws-collaboration-db error="dial tcp 127.0.0.1:5432: connect: connection refused"
set 10 01:40:08 srv-mail service-discoverd[3236]: 2025-09-10T01:40:08.696-0300 [WARN] agent: Check is now critical: check=service:carbonio-ws-collaboration-db
set 10 01:40:08 srv-mail service-discoverd[3236]: 2025-09-10T01:40:08.698-0300 [WARN] agent: Check is now critical: check=service:carbonio-tasks
set 10 01:40:09 srv-mail carbonio-preview-start.sh[1886]: "[2025-09-10 01:40:09,043] INFO [uvicorn.access.send:473] 127.0.0.1:60622 - "GET /health/live/ HTTP/1.1" 200"
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.460-0300 [WARN] agent: Check TCP connection failed: check=service:carbonio-files-db error="dial tcp 127.0.0.1:5432: connect: connection refused"
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.460-0300 [WARN] agent: Check is now critical: check=service:carbonio-files-db
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.460-0300 [WARN] agent: Check is now critical: check=service:carbonio-files
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.460-0300 [WARN] agent: Check TCP connection failed: check=service:carbonio-message-dispatcher-db error="dial tcp 127.0.0.1:5432: connect: connection refused"
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.460-0300 [WARN] agent: Check is now critical: check=service:carbonio-message-dispatcher-db
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.807-0300 [WARN] agent: Check is now critical: check=live
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.999-0300 [WARN] agent: Check TCP connection failed: check=service:carbonio-docs-connector-db error="dial tcp 127.0.0.1:5432: connect: connection refused"
set 10 01:40:09 srv-mail service-discoverd[3236]: 2025-09-10T01:40:09.999-0300 [WARN] agent: Check is now critical: check=service:carbonio-docs-connector-db
set 10 01:40:10 srv-mail service-discoverd[3236]: 2025-09-10T01:40:10.254-0300 [WARN] agent: Check TCP connection failed: check=service:carbonio-tasks-db error="dial tcp 127.0.0.1:5432: connect: connection refused"
set 10 01:40:10 srv-mail service-discoverd[3236]: 2025-09-10T01:40:10.254-0300 [WARN] agent: Check is now critical: check=service:carbonio-tasks-db
My installation is Simple, and I don't use chat, but video calls are available.
However, from what I've seen, Postgres isn't running normally, so I don't have port 543 running.
Could you help me remove these messages?
More Information:
dpkg -l | grep carbonio | grep db
ii carbonio-appserver-db 4.22.0-1noble amd64 Carbonio Appserver DB Files
ii carbonio-bdb 5.3.28-2noble amd64 The Berkeley DB embedded database system
ii carbonio-docs-connector-db 0.0.3-1ubuntu amd64 Carbonio Docs Connector DB sidecar
ii carbonio-files-db 0.1.7-1ubuntu amd64 Carbonio Files DB sidecar
ii carbonio-mailbox-db 0.2.1-1ubuntu amd64 Carbonio Mailbox DB sidecar
ii carbonio-mariadb 10.5.29-1noble amd64 Fast SQL database server, derived from MySQL
ii carbonio-message-dispatcher-db 0.2.2-1ubuntu amd64 Carbonio Message Dispatcher DB sidecar
ii carbonio-perl-berkeleydb 0.65-2noble amd64 Perl5 Module Supporting LDAP API
ii carbonio-perl-dbd-mysql 4.050-4noble amd64 Perl/CPAN DBD::mysql module for interacting with MySQL via DBD
ii carbonio-perl-dbd-sqlite 1.74-2noble amd64 Self-contained RDBMS in a DBI Driver
ii carbonio-perl-dbi 1.644-2noble amd64 Database independent interface for Perl
ii carbonio-tasks-db 0.0.4-1ubuntu amd64 Carbonio Tasks database sidecar
ii carbonio-ws-collaboration-db 0.2.3-1ubuntu amd64 Carbonio Workstream Collaboration DB sidecar
---
ss -ltnp | grep 21009
LISTEN 0 4096 0.0.0.0:21009 0.0.0.0:* users:(("envoy",pid=4491,fd=49))
LISTEN 0 4096 0.0.0.0:21009 0.0.0.0:* users:(("envoy",pid=4491,fd=48))
LISTEN 0 4096 0.0.0.0:21009 0.0.0.0:* users:(("envoy",pid=4491,fd=47))
LISTEN 0 4096 0.0.0.0:21009 0.0.0.0:* users:(("envoy",pid=4491,fd=46))
LISTEN 0 4096 0.0.0.0:21009 0.0.0.0:* users:(("envoy",pid=4491,fd=45))
LISTEN 0 4096 0.0.0.0:21009 0.0.0.0:* users:(("envoy",pid=4491,fd=44))
----
Regards;
Correction:
I don't use chat, video calls, or tasks.
When I mention port 543, I mean port 5432.
Regards;
Hi there, could you please also be precise with location / file name of the log file.
HI!
Analyzing this problem further, it seems that my Postgres is "half-finished." Looking at another server installed from scratch, I notice that some directories are empty on my upgraded server.
# Other Server, Installed packages:
dpkg -l|grep postgres
ii postgresql-16 16.10-1.pgdg24.04+1 amd64 The World's Most Advanced Open Source Relational Database
ii postgresql-client-16 16.10-1.pgdg24.04+1 amd64 front-end programs for PostgreSQL 16
ii postgresql-client-common 281.pgdg24.04+1 all manager for multiple PostgreSQL client versions
ii postgresql-common 281.pgdg24.04+1 all PostgreSQL database-cluster manager
ii postgresql-common-dev 281.pgdg24.04+1 all extension build tool for multiple PostgreSQL versions
# Another Server I see the Postgres process running:
ps faux|grep postgres
postgres 726 0.1 0.1 222792 30848 ? Ss 12:28 0:06 /usr/lib/postgresql/16/bin/postgres -D /var/lib/postgresql/16/main -c config_file=/etc/postgresql/16/main/postgresql.conf
postgres 765 0.0 0.0 222924 10696 ? Ss 12:28 0:00 \_ postgres: 16/main: checkpointer
postgres 766 0.0 0.0 222948 7240 ? Ss 12:28 0:00 \_ postgres: 16/main: background writer
postgres 768 0.0 0.0 222792 10184 ? Ss 12:28 0:00 \_ postgres: 16/main: walwriter
postgres 769 0.0 0.0 224400 8904 ? Ss 12:28 0:00 \_ postgres: 16/main: autovacuum launcher
postgres 770 0.0 0.0 224372 8136 ? Ss 12:28 0:00 \_ postgres: 16/main: logical replication launcher
postgres 34011 0.0 0.0 224816 13384 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-tasks-db carbonio-tasks-db 127.0.0.1(54072) idle
postgres 34015 0.0 0.0 224816 13384 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-tasks-db carbonio-tasks-db 127.0.0.1(54096) idle
postgres 34039 0.0 0.0 224816 13384 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-tasks-db carbonio-tasks-db 127.0.0.1(50196) idle
postgres 34144 0.0 0.0 224816 13384 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-tasks-db carbonio-tasks-db 127.0.0.1(35880) idle
postgres 34316 0.0 0.0 224816 13384 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-tasks-db carbonio-tasks-db 127.0.0.1(58008) idle
postgres 34325 0.0 0.0 224816 13512 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-files-db carbonio-files-db 127.0.0.1(58058) idle
postgres 34329 0.0 0.0 224816 13384 ? Ss 13:59 0:00 \_ postgres: 16/main: carbonio-tasks-db carbonio-tasks-db 127.0.0.1(58074) idle
postgres 34422 0.0 0.0 224816 13512 ? Ss 14:00 0:00 \_ postgres: 16/main: carbonio-files-db carbonio-files-db 127.0.0.1(44678) idle
postgres 37330 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(37040) idle
postgres 37335 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(37070) idle
postgres 37551 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(34122) idle
postgres 37565 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(34172) idle
postgres 37580 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(34232) idle
postgres 37582 0.0 0.0 224896 15176 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(34262) idle
postgres 37584 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(41880) idle
postgres 37608 0.0 0.0 224896 15304 ? Ss 14:09 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(42048) idle
postgres 37644 0.0 0.0 224896 15304 ? Ss 14:10 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(37772) idle
postgres 37661 0.0 0.0 224896 15304 ? Ss 14:10 0:00 \_ postgres: 16/main: carbonio-ws-collaboration-db carbonio-ws-collaboration-db 127.0.0.1(47026) idle
root 38332 0.0 0.0 6624 2176 pts/1 S+ 14:12 0:00 \_ grep --color=auto postgres
Now on the Server with problems:
# Installed Packages:
dpkg -l|grep postgres
ii postgresql-16 16.10-1.pgdg24.04+1 amd64 The World's Most Advanced Open Source Relational Database
ii postgresql-client-16 16.10-1.pgdg24.04+1 amd64 front-end programs for PostgreSQL 16
ii postgresql-client-common 281.pgdg24.04+1 all manager for multiple PostgreSQL client versions
ii postgresql-common 281.pgdg24.04+1 all PostgreSQL database-cluster manager
ii postgresql-common-dev 281.pgdg24.04+1 all extension build tool for multiple PostgreSQL versions
Not the Postgres process running but the direct shots empty...
ps faux|grep postgres
root 2115729 0.0 0.0 6624 2176 pts/1 S+ 14:12 0:00 | \_ grep --color=auto postgres
root@srv-mail:~# ls -l /var/lib/postgresql/16/main
ls: cannot access '/var/lib/postgresql/16/main': No such file or directory
root@srv-mail:~# ls -l /var/lib/postgresql/16/
ls: cannot access '/var/lib/postgresql/16/': No such file or directory
root@srv-mail:~# ls -l /var/lib/postgresql/
total 0
---
root@srv-mail:~# ls -l /etc/postgresql/16/main/postgresql.conf
ls: cannot access '/etc/postgresql/16/main/postgresql.conf': No such file or directory
root@srv-mail:~# ls -l /etc/postgresql/16/main/
ls: cannot access '/etc/postgresql/16/main/': No such file or directory
root@srv-mail:~# ls -l /etc/postgresql/16/
ls: cannot access '/etc/postgresql/16/': No such file or directory
root@srv-mail:~#
root@srv-mail:~# ls -l /etc/postgresql/
total 0
---
I believe this is what's generating the error, because that's why Postgres won't start...
Any help now with this new information?
Regards;
Hi,
Could you please check with documentation segment regarding OS upgrade to understand if we could find any hints?
OS Upgradation in Documentation
Specially the Phase 1 as PostgreSQL 12 was version mostly used with Ubuntu 22.04LTS. Later we introduced PostgreSQL 16 for all versions of supported OS and informed our users to upgrade the Postgres.
But in general, upgrading OS and Carbonio versions are tricky 🙏
HI!
Thanks for the reply.
But I followed the official documentation to upgrade both Carbonio and the OS.
Follow these steps:
- Update Postgres to 16
- Update Carbonio
- Update the OS from Ubuntu 22 to 24
- Update Carbonio again
Regards;
Hi!
Any ?
Regards;
Hi Carlos, probably not what you want to hear. I see you upgraded Ubuntu and Carbonio and something did go wrong. You say everything seems to be working. Hmm...
Do you use a real Machine or a virtual machine?
Do you have any kind of backup? Carbonio CE does not provide a Backup feature, so it is paramount to have regular backup in place.
Rather than try to do the most likely impossible, to fix the database that is, look into how you can migrate / backup your email and whatever else you might be using.
Then Install Ubuntu 22.04 and Carbonio. Restore email etc. At the moment I think 22.04 is the better option as the systemctl stop / start carbonio* is anything but good. In my experience is does not work and only a reboot will give you a running system. You decide.
Hello!
Thanks for the reply.
I shouldn't be having any problems because I don't use chat/tasks, basically just email and calendar, and everything is working 100%.
It's now impossible to migrate again 😐
Yes, I have backups for accounts and the VM...
But the strange thing is how this happened. I followed the process as instructed (I believe) and updated Postgres before doing both upgrades (System and Carbonio).
Regards;
The reality with Carbonio CE and Zextras as a company, you will not get much help at all.
Thunderbird is a good email client. Create a IMAP account! You can export contact list and calendar. For email I did not see any option to backup but, you can add another account like gmail etc. and then create a subfolder with corresponding subfolders from carbonio. Select ALL email from one folder on carbonio and drag them over to the newly created account to the repective subfolder - this will move (not copy) your email's.
Setup another carbonio vm with exact same setting as your broken one. I have setup carbonio Ce on Ubuntu 22.04 and 24.04. As of now I think Ubuntu 22.04 is the better option.
Once that is done and working you can move things in reverse.
An alternative perhaps. Not test by me.
You might want to look into a 30 trial version of CbPlus found here:
https://www.cbmailplus.com/download-page/
Check out the following on the left:
Trial
Try CbPlus unlimited for a full 30-days period
Once you have it installed on your old Carbonio, try make a backup of all your email accounts you have. Hope it works.
Install CbPlus on new sever and try to restore email accounts you just made a backup of.
You can only try. Good luck.
Hello!
Thank you again for your help!!
But unfortunately, a migration isn't feasible (financially and personally) right now, as it's currently working. I'll see if this is fixed in a future update. That's all I have left for now...
Regards;
