Unable to use Carbonio Files

One more detail that might help: when I run: lsof -i -P -n | grep LISTEN:

postgres    1142                 postgres    6u  IPv4   21934      0t0  TCP 127.0.0.1:5435 (LISTEN)

I notice that the postgres port is not matching the one returned by the PGPASSWORD=$DB_ADM_PWD carbonio-files-db-bootstrap carbonio_adm 127.0.0.1 command in the previous post. Could that be the error?

Wow! The lack of support on this forum is pretty sad. Nothing? Crickets??

@myriad 

Could you please check what port your postgres is configured to listen:

grep ^port /etc/postgresql/16/main/postgresql.conf

and 

sudo -u postgres psql -c "SHOW port;"

Postgres should listen to the default 5432 port.

@sharif Thanks for replying Sharif.  I am using Postgresql 17 and the response I am getting is:

grep ^port /etc/postgresql/17/main/postgresql.conf
port = 5435

 sudo -u postgres psql -c "SHOW port;"
 port
------
 5435
(1 row)

@myriad 

Hi,

Ah. That is the cause of the issue.

I would recommend you not to use Postgresql 17 as only Postgresql 16 is tested and supported by Zextras. Also internal components are going to communicate with Postgresql on port 5432. 

You can change the port from 5435 to 5432 and restart Postgresql service to check if that works.

But I would recommend you stick to the officially supported version of Postgresql.

Ahh. I guess that when I upgraded Carbonio the Ubuntu apt also upgraded Postgresql at the same time! Two questions:  How do I revert back to 16 and should I try changing the 17 version to port 5432 first - will Carbonio still work correctly?

Everything works when I change the port in pgres 17 except the files service:

● carbonio-files.service - Carbonio Files daemon
     Loaded: loaded (/lib/systemd/system/carbonio-files.service; enabled; vendor preset: enable>
    Drop-In: /etc/systemd/system/carbonio-files.service.d
             └─override.conf
     Active: activating (auto-restart) (Result: exit-code) since Thu 2025-10-16 07:31:40 EDT; 1>
    Process: 14980 ExecStart=/usr/bin/carbonio-files (code=exited, status=1/FAILURE)
   Main PID: 14980 (code=exited, status=1/FAILURE)
        CPU: 2.384s

@myriad 

Unfortunately, PostgreSQL does not support downgrading from a higher major version to a lower one. We cannot simply downgrade 17 to 16 .Doing so would risk data corruption and system instability.

Also, just out of concern; changing port may work for now but it would always be uncertain during each upgrade whether everything will be fine or not.

It would be better to have a new server and then migrate the data.

Well that will be my last resort. I tried to reset the db-files password with no luck:

root@mail:~# consul kv get -recurse -token-file="/etc/carbonio/files-db/service-discover/token"
carbonio-files/db-name:carbonio-files-db
carbonio-files/db-password:a0c006dxxxxxx51a6b2724367827535a
carbonio-files/db-username:carbonio-files-db
carbonio-files/page-token-secret-key:SefbU6w1V7sgfzGbl4zhaOSrdag8iU/HyT5G/+sUOww=
root@mail:~# su - postgres
postgres@mail:~$ psql
psql (17.5 (Ubuntu 17.5-1.pgdg22.04+1))
Type "help" for help.

postgres=# ALTER ROLE "carbonio-files-db" WITH PASSWORD 'a0c006dxxxxxx51a6b2724367827535a';
ERROR:  role "carbonio-files-db" does not exist

 Any thoughts?

@myriad 

Try checking why it could not find the carbonio-files-db: 

sudo -u postgres psql -c "\l"

@sharif Thanks for sticking with me through this, I appreciate it. Here is the result:

sudo -u postgres psql -c "\l"

                                                     List of databases
   Name    |  Owner   | Encoding | Locale Provider |   Collate   |    Ctype    | Locale | ICU Rules |   Access privileges
-----------+----------+----------+-----------------+-------------+-------------+--------+-----------+-----------------------
 postgres  | postgres | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8 |        |    |
 template0 | postgres | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8 |        |           | =c/postgres          +
           |          |          |                 |             |             |        |           | postgres=CTc/postgres
 template1 | postgres | UTF8     | libc            | en_US.UTF-8 | en_US.UTF-8 |        |           | =c/postgres          +
           |          |          |                 |             |             |        |           | postgres=CTc/postgres
(3 rows)