Forums
Zextras Carbonio
Install & Setup
Upgrading to 24.5.0...
 
Notifications
Clear all

[Solved] Upgrading to 24.5.0 Cannot run script file '/etc/carbonio/message-dispatcher/sql-scripts/migrations//6.0.0.sql'

 
Page 1 / 2
Install & Setup
Last Post by MAX 2 years ago
17 Posts
2 Users
3 Reactions
3,381 Views
RSS
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 06/30/2024 15:44  

Hi all!

I encountered an error while updating. The file is in place, the path is correct, the rights to the file and folder are normal. But I can’t solve the error! Help, who has encountered this!

PGPASSWORD=$DB_ADM_PWD carbonio-message-dispatcher-migration carbonio_adm 127.78.0.10 20000
Checking of database schema... Done. The database needs to be updated!
Updating database... Failed!
Cannot run script file '/etc/carbonio/message-dispatcher/sql-scripts/migrations//6.0.0.sql'


   
Quote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/02/2024 09:09  

I found a solution to this problem on the forum ( https://community.zextras.com/forum/carbonio-setup/fresh-installation-of-carbonio-ce-23-12-0-workstream-collaboration/paged/4/#post-8116 ), but it didn't help me. The error is still there.

curl -s -v  http://127.78.0.4:10000/health  | jq


* Trying 127.78.0.4:10000...
* TCP_NODELAY set
* Connected to 127.78.0.4 (127.78.0.4) port 10000 (#0)
> GET /health HTTP/1.1
> Host: 127.78.0.4:10000
> User-Agent: curl/7.68.0
> Accept: */*
>
* Mark bundle as not supporting multiuse
< HTTP/1.1 200 OK
< Server: Jetty(12.0.8)
< Date: Tue, 02 Jul 2024 07:03:41 GMT
< Content-Type: application/json
< Content-Length: 403
<
{ [403 bytes data]
* Connection #0 to host 127.78.0.4 left intact
{
"isLive": true,
"status": "ok",
"dependencies": [
{
"name": "database",
"isHealthy": true
},
{
"name": "authentication_service",
"isHealthy": true
},
{
"name": "profiling_service",
"isHealthy": true
},
{
"name": "xmpp_server",
"isHealthy": true
},
{
"name": "event_dispatcher",
"isHealthy": true
},
{
"name": "storage_service",
"isHealthy": true
},
{
"name": "previewer_service",
"isHealthy": true
},
{
"name": "videoserver_service",
"isHealthy": true
}
]
}

 

systemctl status carbonio-message-dispatcher-db-sidecar.service


● carbonio-message-dispatcher-db-sidecar.service - Carbonio Message Dispatcher database sidecar
Loaded: loaded (/lib/systemd/system/carbonio-message-dispatcher-db-sidecar.service; enabled; vendor preset: enabled)
Active: active (running) since Mon 2024-07-01 21:44:28 MSK; 12h ago
Docs:  https://docs.zextras.com/ 
Main PID: 2069 (envoy)
Tasks: 24 (limit: 28734)
Memory: 22.8M
CGroup: /system.slice/carbonio-message-dispatcher-db-sidecar.service
└─2069 /usr/bin/envoy --config-path /tmp/envoy-17de2b13379ed4d3-bootstrap.json --disable-hot-restart

   
ReplyQuote
 Sharif
(@sharif)
Reputable Member Admin
Joined: 4 years ago
Posts: 871
07/02/2024 09:41  

@max 

Hi,

Could you please share more details about your system:

  1. systemctl list-units carbonio*
  2. systemctl status service-discover
  3. cat /etc/os-release

Regards,

Sharif


   
MAX reacted
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/02/2024 12:29  

Thanks, @sharif !!!

1. systemctl list-units carbonio*

carbonio-clamav-sidecar.service                                             loaded active running   Carbonio clamav sidecar proxy
  carbonio-clamav-signature-provider-sidecar.service                          loaded active running   NGINX Carbonio ClamAV signature provider sidecar
  carbonio-docs-connector-sidecar.service                                     loaded active running   Carbonio docs connector sidecar proxy
  carbonio-docs-connector.service                                             loaded active running   Carbonio docs connector daemon
  carbonio-docs-editor-sidecar.service                                        loaded active running   Carbonio Docs server sidecar proxy
  carbonio-docs-editor.service                                                loaded active running   Carbonio Docs Server
  carbonio-files-db-sidecar.service                                           loaded active running   Carbonio Files database sidecar
  carbonio-files-sidecar.service                                              loaded active running   Carbonio Files sidecar proxy
  carbonio-files.service                                                      loaded active running   Carbonio Files daemon
  carbonio-mailbox-admin-sidecar.service                                      loaded active running   Carbonio Mailbox Admin proxy sidecar
  carbonio-mailbox-nslookup-sidecar.service                                   loaded active running   Carbonio Mailbox NSLookup proxy sidecar
  carbonio-mailbox-sidecar.service                                            loaded active running   Mailbox carbonio proxy sidecar
  carbonio-message-broker-sidecar.service                                     loaded active running   Carbonio message broker sidecar proxy
  carbonio-message-broker.service                                             loaded active running   Carbonio message broker daemon
  carbonio-message-dispatcher-auth-sidecar.service                            loaded active running   Carbonio Message Dispatcher auth sidecar proxy
  carbonio-message-dispatcher-auth.service                                    loaded active running   Carbonio Message Dispatcher auth daemon
  carbonio-message-dispatcher-db-sidecar.service                              loaded active running   Carbonio Message Dispatcher database sidecar
  carbonio-message-dispatcher-http-sidecar.service                            loaded active running   Carbonio Message Dispatcher HTTP sidecar proxy
  carbonio-message-dispatcher-xmpp-sidecar.service                            loaded active running   Carbonio Message Dispatcher XMPP sidecar proxy
  carbonio-message-dispatcher.service                                         loaded active running   Carbonio Message Dispatcher daemon
  carbonio-mta-sidecar.service                                                loaded active running   Carbonio mta sidecar proxy
  carbonio-preview-sidecar.service                                            loaded active running   Carbonio Preview sidecar proxy
  carbonio-preview.service                                                    loaded active running   Carbonio Preview daemon
  carbonio-prometheus-consul-exporter.service                                 loaded active running   Carbonio Prometheus Consul exporter
  carbonio-prometheus-mysqld-exporter.service                                 loaded active running   Carbonio Prometheus MySQL exporter
  carbonio-prometheus-nginx-exporter.service                                  loaded active running   Carbonio Prometheus NGINX exporter
  carbonio-prometheus-node-exporter.service                                   loaded active running   Carbonio Prometheus Node Exporter
  carbonio-prometheus-openldap-exporter.service                               loaded active running   Carbonio Prometheus OpenLDAP exporter
  carbonio-proxy-sidecar.service                                              loaded active running   NGINX carbonio proxy sidecar
  carbonio-storages-sidecar.service                                           loaded active running   Storages-CE sidecar proxy
  carbonio-storages.service                                                   loaded active running   Carbonio Storages-CE daemon
  carbonio-tasks-db-sidecar.service                                           loaded active running   Carbonio Tasks database sidecar
  carbonio-tasks-sidecar.service                                              loaded active running   Carbonio Tasks sidecar proxy
  carbonio-user-management-sidecar.service                                    loaded active running   Carbonio User Management sidecar proxy
  carbonio-user-management.service                                            loaded active running   Carbonio User Management daemon
  carbonio-videoserver-sidecar.service                                        loaded active running   Carbonio Videoserver sidecar proxy
  carbonio-videoserver.service                                                loaded active running   Zextras Videoserver
  carbonio-ws-collaboration-db-sidecar.service                                loaded active running   Carbonio Workstream Collaboration database sidecar
  carbonio-ws-collaboration-sidecar.service                                   loaded active running   Carbonio Workstream Collaboration sidecar proxy
  carbonio-ws-collaboration.service                                           loaded active running   Carbonio Workstream Collaboration daemon
  carbonio.service                                                            loaded active exited    LSB: Carbonio Services

2. systemctl status service-discover

 systemctl status service-discover
● service-discover.service - Service discover server for Zextras
     Loaded: loaded (/lib/systemd/system/service-discover.service; enabled; vendor preset: enabled)
     Active: active (running) since Mon 2024-07-01 21:44:28 MSK; 15h ago
       Docs:  https://docs.zextras.com/ 
   Main PID: 1809 (consul)
      Tasks: 14 (limit: 28734)
     Memory: 83.5M
     CGroup: /system.slice/service-discover.service
             └─1809 /usr/bin/consul agent -bootstrap-expect 1 -config-dir /etc/zextras/service-discover/ -server -retry-join=mail.exampe.com

июл 02 13:21:12 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:12.219+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:17 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:17.220+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:22 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:22.220+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:27 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:27.221+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:32 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:32.222+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:37 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:37.223+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:42 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:42.224+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:47 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:47.225+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:52 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:52.226+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks
июл 02 13:21:57 mail.exampe.com service-discoverd[1809]: 2024-07-02T13:21:57.227+0300 [WARN]  agent: Check is now critical: check=service:carbonio-tasks

2.1 systemctl status carbonio-tasks

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: inactive (dead) since Tue 2024-07-02 13:24:11 MSK; 1s ago
    Process: 399997 ExecStart=/usr/bin/carbonio-tasks (code=exited, status=0/SUCCESS)
   Main PID: 399997 (code=exited, status=0/SUCCESS)

июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:252)
июл 02 13:24:11 mail.exampe.com carbonio-tasks[399998]:         ... 9 common frames omitted
июл 02 13:24:11 mail.exampe.com systemd[1]: carbonio-tasks.service: Succeeded.

3.  cat /etc/os-release

cat /etc/os-release
NAME="Ubuntu"
VERSION="20.04.6 LTS (Focal Fossa)"
ID=ubuntu
ID_LIKE=debian
PRETTY_NAME="Ubuntu 20.04.6 LTS"
VERSION_ID="20.04"
HOME_URL="https://www.ubuntu.com/"
SUPPORT_URL="https://help.ubuntu.com/"
BUG_REPORT_URL="https://bugs.launchpad.net/ubuntu/"
PRIVACY_POLICY_URL="https://www.ubuntu.com/legal/terms-and-policies/privacy-policy"
VERSION_CODENAME=focal
UBUNTU_CODENAME=focal

   
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/02/2024 13:20  

Found in log carbonio-tasks:

 

июл 02 13:24:09 mail.1090393.ru systemd[1]: Started Carbonio Tasks daemon.
июл 02 13:24:10 mail.1090393.ru carbonio-tasks[399998]: 13:24:10.274 [main] WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config db-username from consul
июл 02 13:24:10 mail.1090393.ru carbonio-tasks[399998]: 13:24:10.282 [main] WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config db-password from consul
июл 02 13:24:10 mail.1090393.ru carbonio-tasks[399998]: 13:24:10.284 [main] WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config db-name from consul
июл 02 13:24:10 mail.1090393.ru carbonio-tasks[399998]: 13:24:10.286 [main] WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-max-pool-size from consul
июл 02 13:24:10 mail.1090393.ru carbonio-tasks[399998]: 13:24:10.288 [main] WARN  c.z.c.t.c.ServiceDiscoverHttpClient - Unable to retrieve the config hikari-min-idle-connections from consul
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: 13:24:11.375 [main] ERROR com.zaxxer.hikari.pool.HikariPool - HikariPool-1 - Exception during pool initialization.
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "carbonio-tasks-db"
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:693)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:203)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:253)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.Driver.makeConnection(Driver.java:434)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.Driver.connect(Driver.java:291)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:252)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:89)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:29)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebean.DatabaseFactory.createInternal(DatabaseFactory.java:136)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebean.DatabaseFactory.create(DatabaseFactory.java:85)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebean.DatabaseFactory.createWithContextClassLoader(DatabaseFactory.java:111)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.DatabaseConnectionManager.getEbeanDatabase(DatabaseConnectionManager.java:46)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.repositories.impl.DbInfoRepositoryEbean.isDatabaseInitialized(DbInfoRepositoryEbean.java:35)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.DatabaseInitializer.initialize(DatabaseInitializer.java:31)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.Boot.main(Boot.java:26)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: 13:24:11.379 [main] ERROR ROOT - Service stopped unexpectedly:
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: java.lang.RuntimeException: Unable to create the database connection! Something went wrong: e.g. database is not reachable, the database does not exist or the database credenti>
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.DatabaseConnectionManager.getEbeanDatabase(DatabaseConnectionManager.java:57)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.repositories.impl.DbInfoRepositoryEbean.isDatabaseInitialized(DbInfoRepositoryEbean.java:35)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.DatabaseInitializer.initialize(DatabaseInitializer.java:31)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.Boot.main(Boot.java:26)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: Caused by: javax.persistence.PersistenceException: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "carbonio-tasks-db"
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:258)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:89)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:29)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebean.DatabaseFactory.createInternal(DatabaseFactory.java:136)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebean.DatabaseFactory.create(DatabaseFactory.java:85)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebean.DatabaseFactory.createWithContextClassLoader(DatabaseFactory.java:111)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zextras.carbonio.tasks.dal.DatabaseConnectionManager.getEbeanDatabase(DatabaseConnectionManager.java:46)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         ... 3 common frames omitted
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: Caused by: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "carbonio-tasks-db"
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.v3.ConnectionFactoryImpl.doAuthentication(ConnectionFactoryImpl.java:693)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:203)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.jdbc.PgConnection.<init>(PgConnection.java:253)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.Driver.makeConnection(Driver.java:434)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at org.postgresql.Driver.connect(Driver.java:291)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:100)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         at io.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:252)
июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]:         ... 9 common frames omitted
июл 02 13:24:11 mail.1090393.ru systemd[1]: carbonio-tasks.service: Succeeded.

   
ReplyQuote
 Sharif
(@sharif)
Reputable Member Admin
Joined: 4 years ago
Posts: 871
07/02/2024 14:22  

@max 

Hi,

The last log says:

июл 02 13:24:11 mail.1090393.ru carbonio-tasks[399998]: org.postgresql.util.PSQLException: FATAL: password authentication failed for user "carbonio-tasks-db"

 

Could you please take at this issue?

 

Regards,

Sharif

 


   
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/03/2024 21:27  

Thanks, @sharif !

It’s not entirely clear to me which direction to go with this. Where can I check what password this user is logging in with? Where can I see the current password for this user? At what stage was it specified during installation, if it was not requested separately?

Can I reinstall the carbonio-tasks package? Will this break other services?


   
ReplyQuote
 Sharif
(@sharif)
Reputable Member Admin
Joined: 4 years ago
Posts: 871
07/04/2024 09:12  

@max 

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


   
ReplyQuote
 Sharif
(@sharif)
Reputable Member Admin
Joined: 4 years ago
Posts: 871
07/04/2024 09:12  

@max 

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


   
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/04/2024 09:51  

Thanks, @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

 


   
ReplyQuote
 Sharif
(@sharif)
Reputable Member Admin
Joined: 4 years ago
Posts: 871
07/04/2024 09:56  

@max 

Hi,

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

Regards,

Sharif


   
MAX reacted
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/04/2024 10:07  

Thanks, @sharif ! It,s true!

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?


   
ReplyQuote
 Sharif
(@sharif)
Reputable Member Admin
Joined: 4 years ago
Posts: 871
07/04/2024 10:13  

@max 

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


   
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/04/2024 13:59  

Yes! Problem is solved!!! Thanks, @sharif !!!!!!!!!


   
ReplyQuote
 MAX
(@max)
Trusted Member
Joined: 3 years ago
Posts: 85
Topic starter 07/04/2024 14:12  

But error in carbonio-task present:

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[1]: Started Carbonio Tasks daemon.
июл 04 14:55:25 mail.example.com carbonio-tasks[1649204]: 14:55:25.198 [main] 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[1649204]: 14:55:25.201 [main] 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[1649204]: 14:55:25.330 [main] WARN  io.ebean.core - DataSource [carbonio-tasks-postgres] has autoCommit defaulting to true!

It,s critical, @sharif ?


   
ReplyQuote
Page 1 / 2
Forum Jump:
  Previous Topic
Next Topic