Many thanks for you help!

I don't think so. Check if the tasks feature is working or not?

Regards,

Sharif

systemctl status carbonio-tasks
● carbonio-tasks.service - Carbonio Tasks daemon
     Loaded: loaded (/lib/systemd/system/carbonio-tasks.service; enabled; vendor preset: enabled)
    Drop-In: /etc/systemd/system/carbonio-tasks.service.d
             └─override.conf
     Active: active (running) since Thu 2024-07-04 14:55:24 MSK; 13min ago
   Main PID: 1649203 (carbonio-tasks)
      Tasks: 63 (limit: 28734)
     Memory: 296.4M
     CGroup: /system.slice/carbonio-tasks.service
             ├─1649203 /bin/bash /usr/bin/carbonio-tasks
             └─1649204 /opt/zextras/common/bin/java -Djava.net.preferIPv4Stack=true -Xmx1024m -Xms1024m -DTASKS_LOG_LEVEL=warn -jar /usr/share/carbonio/carbonio-tasks.jar

июл 04 14:55:24 mail.example.com systemd: Started Carbonio Tasks daemon.
июл 04 14:55:25 mail.example.com carbonio-tasks: 14:55:25.198  WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-max-pool-size from consul
июл 04 14:55:25 mail.example.com carbonio-tasks: 14:55:25.201  WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-min-idle-connections from consul
июл 04 14:55:25 mail.example.com carbonio-tasks: 14:55:25.330  WARN  io.ebean.core - DataSource  has autoCommit defaulting to true!

It,s critical, @sharif ?

Make sure you have installed:

• carbonio-tasks-ce
• carbonio-tasks-db

If these packages are installed, then ensure there are no pending-setups left.

Only then execute:

PGPASSWORD=$DB_ADM_PWD carbonio-tasks-db-bootstrap carbonio_adm 127.0.0.1

Rather using $DB_ADM_PWD variable use the password directly.

Regards,

Sharif

Should I initialize the carbinio-tasks database?

PGPASSWORD=$DB_ADM_PWD carbonio-tasks-db-bootstrap carbonio_adm 127.0.0.1

Or do I need to reinstall carbonio-tasks?

Hi,

It's okay. It happens with all of us 😁

Regards,

Sharif

Thanks for your help. I saw that on another server with Carbonio CE 24.1.0 the situation with carbonio-task is exactly the same. This means that this problem appeared when updating to 24.1.0. And I did not check the correct operation of the services after the update. My mistake.

Now, when following your recommendations, I saw that the user was not in the database.

ERROR:  role "carbonio-tasks-db" does not exist

Hi,

Please try this and let us know how it goes.

• Retrieve the Tasks-db password stored in the consul:

root@mail:/etc/carbonio# consul kv get -recurse -token-file="/etc/carbonio/tasks-db/service-discover/token"

You will get output like:

carbonio-tasks/db-name:carbonio-tasks-db
carbonio-tasks/db-password:6fc4da311cfef23cd59436df74vf5693
carbonio-tasks/db-username:carbonio-tasks-db

• Now login into postgres and set the same password for the carbonio-tasks-db:

root@mail:/etc/carbonio# su - postgres
postgres@mail:~$ psql
psql (16.3 (Ubuntu 16.3-1.pgdg22.04+1))
Type "help" for help.

postgres=# ALTER ROLE "carbonio-tasks-db" WITH PASSWORD '6fc4da311cfef23cd59436df74vf5693';
ALTER ROLE
postgres=#
postgres=# exit
postgres@mail:~$ exit
logout
root@mail:/etc/carbonio#

•  Now restart services as follows:

root@mail:~# systemctl restart service-discover
root@mail:~# systemctl restart postgresql@16-main.service
root@mail:~# systemctl restart carbonio-tasks

Regards,

Sharif

Hi,

Please try this and let us know how it goes.

• Retrieve the Tasks-db password stored in the consul:

root@mail:/etc/carbonio# consul kv get -recurse -token-file="/etc/carbonio/tasks-db/service-discover/token"

You will get output like:

carbonio-tasks/db-name:carbonio-tasks-db
carbonio-tasks/db-password:6fc4da311cfef23cd59436df74vf5693
carbonio-tasks/db-username:carbonio-tasks-db

• Now login into postgres and set the same password for the carbonio-tasks-db:

root@mail:/etc/carbonio# su - postgres
postgres@mail:~$ psql
psql (16.3 (Ubuntu 16.3-1.pgdg22.04+1))
Type "help" for help.

postgres=# ALTER ROLE "carbonio-tasks-db" WITH PASSWORD '6fc4da311cfef23cd59436df74vf5693';
ALTER ROLE
postgres=#
postgres=# exit
postgres@mail:~$ exit
logout
root@mail:/etc/carbonio#

•  Now restart services as follows:

root@mail:~# systemctl restart service-discover
root@mail:~# systemctl restart postgresql@16-main.service
root@mail:~# systemctl restart carbonio-files

Regards,

Sharif