Notifications
Clear all
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'
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
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
This post was modified 2 days ago 3 times by MAX
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.
07/02/2024 14:22
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
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?