Docs and Files do not appear to work correctly after a clean install. - Install & Setup

RE: Docs and Files do not appear to work correctly after a clean install.

Synchro — Thu, 16 Nov 2023 23:27:26 +0000

@max_s I found a solution!

As I suspected it is down to issues with the RHEL packages for Carbonio CE.
What got me on the right path was seeing this: https://docs.zextras.com/carbonio-ce/html/release/upgrade.html#failed-installation-of-carbonio-docs-editor

What happens is that harfbuzz is installed from the distro repos by default (or because it is a dependency of anaconda), and due to the harfbuzz-icu package not correctly being marked as a replacement for the harfbuzz package, there's some API/ABI conflicts with the document editor and preview applications when both packages are installed at the same time..

With Carbonio 23.11.0 creating documents works now, however editing them doesn't without a fix.

To fix:

as ZExtras user:

zmcontrol stop

as root:

dnf reinstall harfbuzz-icu --allowerasing
dnf reinstall carbonio-docs-editor
read -s -p "Insert Password of DB Admin:" DB_ADM_PWD
PGPASSWORD=$DB_ADM_PWD carbonio-files-db-bootstrap carbonio_adm 127.0.0.1
pending-setups -a
reboot

Additionally, due to some missing documentation in the install instructions for RHEL..

Make sure when updating you install carbonio-tasks-ce, carbonio-tasks-db, carbonio-tasks-ui right after you run dnf update, to get all of the new features.

So far this has fixed the document editor for me, but I suspect this will continue to happen to new installs of Carbonio CE unless the harfbuzz-icu package is updated to remove harfbuzz if installed.

Let me know if this fixes this for you as well! Cheers.

RE: Docs and Files do not appear to work correctly after a clean install.

tatodc — Sun, 12 Nov 2023 00:30:46 +0000

@synchro I had kind of the same issue. Found that systemctl status carbonio-* had some errors on the nginx and in docs. I have modified the /etc/hosts file to had my hostname on the 127.0.0.1 line.

After a reboot everything started working fine

RE: Docs and Files do not appear to work correctly after a clean install.

anahuac — Fri, 10 Nov 2023 23:29:31 +0000

So... that's a quite odd log right there:

org.postgresql.util.PSQLException: Connection to 127.78.0.2:20000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.

From where is it getting this IP 127.78.0.2 from?

That's not a LXC container is it?

Maybe it came from /etc/hosts?

BTW all my Carbonio's servers are Ubuntu 20.04 and it's working flawless so far.

So I have to confess I'm kinda clueless about what is causing this.

RE: Docs and Files do not appear to work correctly after a clean install.

Synchro — Fri, 10 Nov 2023 23:19:01 +0000

Unfortunately not @max_s

@anahuac I was pretty careful about setting Carbonio up and did not forget to configure the PGSQL database or the rest of the components with pending-setups. Using Ubuntu in this case isn't feasible, we run Rocky/RHEL exclusively in this environment. I found some more logs and the interesting thing to me is seeing this IP address referenced: 127.78.0.2.

Is there a way to check what IP the files component is configured with after it was configured? I never typed in or specified that IP address so I have no idea where it is getting it from..

For example here is a snippet from files.log in /var/log/carbonio/files:

org.postgresql.util.PSQLException: Connection to 127.78.0.2:20000 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections.
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:342)
at org.postgresql.core.ConnectionFactory.openConnection(ConnectionFactory.java:54)
at org.postgresql.jdbc.PgConnection.(PgConnection.java:263)
at org.postgresql.Driver.makeConnection(Driver.java:443)
at org.postgresql.Driver.connect(Driver.java:297)
at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138)
at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:359)
at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:201)
at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:470)
at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561)
at com.zaxxer.hikari.pool.HikariPool.(HikariPool.java:100)
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112)
at io.ebeaninternal.server.core.DefaultContainer.checkDataSource(DefaultContainer.java:252)
at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:89)
at io.ebeaninternal.server.core.DefaultContainer.createServer(DefaultContainer.java:29)
at io.ebean.DatabaseFactory.createInternal(DatabaseFactory.java:136)
at io.ebean.DatabaseFactory.create(DatabaseFactory.java:85)
at io.ebean.DatabaseFactory.createWithContextClassLoader(DatabaseFactory.java:111)
at com.zextras.carbonio.files.dal.EbeanDatabaseManager.start(EbeanDatabaseManager.java:269)
at com.zextras.carbonio.files.Boot.boot(Boot.java:52)
at com.zextras.carbonio.files.Boot.main(Boot.java:33)
Caused by: java.net.ConnectException: Connection refused
at java.base/sun.nio.ch.Net.pollConnect(Native Method)
at java.base/sun.nio.ch.Net.pollConnectNow(Net.java:672)
at java.base/sun.nio.ch.NioSocketImpl.timedFinishConnect(NioSocketImpl.java:547)
at java.base/sun.nio.ch.NioSocketImpl.connect(NioSocketImpl.java:602)
at java.base/java.net.SocksSocketImpl.connect(SocksSocketImpl.java:327)
at java.base/java.net.Socket.connect(Socket.java:633)
at org.postgresql.core.PGStream.createSocket(PGStream.java:243)
at org.postgresql.core.PGStream.(PGStream.java:98)
at org.postgresql.core.v3.ConnectionFactoryImpl.tryConnect(ConnectionFactoryImpl.java:132)
at org.postgresql.core.v3.ConnectionFactoryImpl.openConnectionImpl(ConnectionFactoryImpl.java:258

RE: Docs and Files do not appear to work correctly after a clean install.

Max_S — Fri, 10 Nov 2023 14:51:20 +0000

Hi @synchro,

Did you solved the problem? I am having the same problem. I cannot create folders because the New Folder is grayed out. Also when uploading a file I see a red exclamation behind the filename in Uploads but nowhere I can get some info about why it is not working.

I changed the permissions like @anahuac suggested in a other thread.

chown carbonio-storages: /opt/zextras/carbonio-storages

RE: Docs and Files do not appear to work correctly after a clean install.

anahuac — Fri, 03 Nov 2023 12:21:12 +0000

Hello there.... so in my experience 99.9% os the time this issue is related with some missing step in Installation process.

Some Zimbra admins do not look closely to those extra steps at the beginning like install and setup PostgreSQL and the ones at the end like pending-setups -a, just because there is no such steps on Zimbra.

So my suggestion is start fresh, from scratch, using Ubuntu 20.04 and me super extra careful to do ALL installation steps.

We have been installing Carbonio many times now without any trouble.

Regards

Docs and Files do not appear to work correctly after a clean install.

Synchro — Fri, 03 Nov 2023 00:47:15 +0000

Hello, I have been testing out features as I'm in the process of migrating to Carbonio from Zimbra OSE, I have noticed that I am unable to create files in the Files web UI, and additionally if I upload a file and attempt to edit the file, I get a blank page. File previews are also nonfunctional.

The annoying part is that I am not seeing any information as to what is happening in any of the logs in

/var/logs/carbonio

Has anyone else seen this particular issue? I'd love to have a working document server as this would give some of my clients features they've been looking for.

I'm currently using Carbonio CE 23.10.0 ( I have noticed that Community Edition is not in the version tag anymore..)