Rocket.Chat integration in EGroupware

[RalfBecker]

Installation using EGroupware docker RPM DEB package

[alicia]

Sorry but I need more help.
I have done :
sudo apt install egroupware-docker

Now I have all those containers running :
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
55c0cabf60ab nginx:stable-alpine “/docker-entrypoint.…” 3 hours ago Up 3 hours 127.0.0.1:8080->80/tcp egroupware-nginx
5b271b964b69 phpswoole/swoole:5.0-php8.1-alpine “docker-php-entrypoi…” 3 hours ago Up 3 hours egroupware-push
7315e44b8194 containrrr/watchtower:latest “/watchtower --sched…” 3 hours ago Up 3 hours (healthy) 8080/tcp egroupware-watchtower
70283454efe0 egroupware/egroupware:23.1 “/entrypoint.sh php-…” 3 hours ago Up 3 hours 9000/tcp egroupware
a2e1b9ca10fd mariadb:10.6 “docker-entrypoint.s…” 3 hours ago Up 3 hours 3306/tcp egroupware-db
532a647fe29d quay.io/egroupware/collabora-key:stable “/start-collabora-on…” 3 hours ago Up 3 hours 127.0.0.1:9980->9980/tcp collabora-key
cb4164764167 registry.rocket.chat/rocketchat/rocket.chat:6.4.7 “docker-entrypoint.s…” 2 days ago Up 2 days 0.0.0.0:3000->3000/tcp rocketchat-rocketchat-1
ec06bd65e380 bitnami/mongodb:5.0 “/opt/bitnami/script…” 2 days ago Up 2 days 27017/tcp rocketchat-mongodb-1

And now, how do I access it through a browser?
When I navigate to http(s)://your.host-or-ip/egroupware/setup/ (replacing “your.host-or-ip”) I get a 404

[alicia]

when I looked at the logs for the egroupware container (using docker logs 70283454efe0) this is my I got :

You can log into EGroupware by pointing your browser to http://localhost/egroupware/
Please replace localhost with the appropriate hostname, if you connect remote.

But I when I navigate to it with my server’s IP address, I also get a 404

[StefanU]

And now, how do I access it through a browser?

Installation using EGroupware docker RPM DEB package

or

Where do I find the admin credentials after installation?

When I navigate to http(s)://your.host-or-ip/egroupware/setup/

Why /setup ?

---

But I when I navigate to it with my server’s IP address, I also get a 404

Firewall?
Other websites/Reverse proxy on your server?

Please provide more Information about your serve (installation).

Stefan

[alicia]

Why /setup --> because :

I have egroupware currently running, not in a container, at https://mydomain/egroupware

[StefanU]

I have egroupware currently running, not in a container, at https://mydomain/egroupware

On the same server?

[alicia]

yes, indeed, on the same server. Everybody is using it at the moment so I don’t want to take it down.

[alicia]

I am using Plesk to manage my domains.

I have one domain name mydomain.com, so my current egroupware installation is here :
/var/www/vhosts/mydomain.com/httpdocs/egroupware

ls -la
total 1324
drwxr-xr-x 41 eg_user psacln 4096 nov. 24 14:24 .
drwxr-x— 3 eg_user psaserv 4096 nov. 22 18:23 …
-rw-r–r-- 1 eg_user psacln 659 nov. 22 18:23 about.php
drwxr-xr-x 6 eg_user psacln 4096 nov. 22 18:23 activesync
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 addressbook
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 admin
drwxr-xr-x 10 eg_user psacln 4096 nov. 22 18:23 api
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 bookmarks
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 calendar
drwxr-xr-x 2 eg_user psacln 4096 nov. 22 18:23 chunks
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 collabora
-rw-r–r-- 1 eg_user psacln 4670 nov. 22 18:23 composer.json
-rw-r–r-- 1 eg_user psacln 447731 nov. 22 18:23 composer.lock
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 doc
-rw-r–r-- 1 eg_user psacln 16 nov. 22 18:23 egwgestion_2023-11-17_17-11-43.sql
drwxr-xr-x 3 eg_user psacln 4096 nov. 22 18:23 emailadmin
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 filemanager
drwxr-xr-x 2 eg_user psacln 4096 nov. 22 18:23 files
-rwxr-xr-x 1 eg_user psacln 1242 nov. 22 18:23 groupdav.htaccess
-rw-r–r-- 1 eg_user psacln 1839 nov. 22 18:23 groupdav.php
-rw-r–r-- 1 eg_user psacln 4411 nov. 22 18:23 Gruntfile.js
-rw-r–r-- 1 eg_user psacln 3578 nov. 22 18:28 header.inc.php
-rw-r–r-- 1 eg_user psacln 3536 nov. 22 18:23 header.inc.php.template
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 home
-rw-r–r-- 1 eg_user psacln 1508 nov. 22 18:48 .htaccess
drwxr-xr-x 4 eg_user psacln 4096 nov. 22 18:23 .idea
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 importexport
-rwxr-xr-x 1 eg_user psacln 4540 nov. 22 18:23 index.php
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 infolog
-rwxr-xr-x 1 eg_user psacln 12602 nov. 22 18:23 install-cli.php
drwxr-xr-x 3 eg_user psacln 4096 nov. 22 18:23 jdots
-rw-r–r-- 1 eg_user psacln 5248 nov. 22 18:23 json.php
-rw-r–r-- 1 eg_user psacln 15333 nov. 22 18:23 LICENSE.md
-rwxr-xr-x 1 eg_user psacln 11692 nov. 22 18:23 login.php
-rwxr-xr-x 1 eg_user psacln 2888 nov. 22 18:23 logout.php
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 mail
-rw-r–r-- 1 eg_user psacln 769 nov. 22 18:23 manifest.json
-rwxr-xr-x 1 eg_user psacln 727 nov. 22 18:23 move-images
drwxr-xr-x 10 eg_user psacln 4096 nov. 22 18:23 news_admin
drwxr-xr-x 390 eg_user psacln 12288 nov. 22 18:23 node_modules
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 notifications
drwxr-xr-x 6 eg_user psacln 4096 nov. 22 18:23 openid
-rw-r–r-- 1 eg_user psacln 2177 nov. 22 18:23 package.json
-rw-r–r-- 1 eg_user psacln 547869 nov. 22 18:23 package-lock.json
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 phpbrain
drwxr-xr-x 12 eg_user psacln 4096 nov. 22 18:23 phpgwapi
drwxr-xr-x 11 eg_user psacln 4096 nov. 22 18:23 pixelegg
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 preferences
drwxr-xr-x 7 eg_user psacln 4096 nov. 22 18:23 projectmanager
-rw-r–r-- 1 eg_user psacln 3165 nov. 22 18:23 README.md
-rw-r–r-- 1 eg_user psacln 2244 nov. 22 18:23 redirect.php
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 registration
-rw-r–r-- 1 eg_user psacln 3311 nov. 22 18:23 remote.php
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 resources
drwxr-xr-x 6 eg_user psacln 4096 nov. 24 14:40 rocket.chat
drwxr-xr-x 9 eg_user psacln 4096 nov. 24 15:23 rocketchat
-rw-r–r-- 1 eg_user psacln 6914 nov. 22 18:23 rollup.config.js
drwxr-xr-x 7 eg_user psacln 4096 nov. 22 18:23 saml
-rw-r–r-- 1 eg_user psacln 336 nov. 22 18:23 SECURITY.md
-rw-r–r-- 1 eg_user psacln 442 nov. 22 18:23 service-worker.js
drwxr-xr-x 6 eg_user psacln 4096 nov. 22 18:23 setup
-rw-r–r-- 1 eg_user psacln 1031 nov. 22 18:23 share.php
drwxr-xr-x 9 eg_user psacln 4096 nov. 22 18:23 smallpart
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 status
-rw-r–r-- 1 eg_user psacln 994 nov. 22 18:23 status.php
drwxr-xr-x 6 eg_user psacln 4096 nov. 22 18:23 swoolepush
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 timesheet
drwxr-xr-x 8 eg_user psacln 4096 nov. 22 18:23 tracker
-rw-r–r-- 1 eg_user psacln 3816 nov. 22 18:23 .travis.yml
-rw-r–r-- 1 eg_user psacln 548 nov. 22 18:23 tsconfig.json
-rwxr-xr-x 1 eg_user psacln 4020 nov. 22 18:23 updateGruntfile.php
drwxr-xr-x 46 eg_user psacln 4096 nov. 22 18:23 vendor
-rw-r–r-- 1 eg_user psacln 2918 nov. 22 18:23 webdav.php
-rw-r–r-- 1 eg_user psacln 1581 nov. 22 18:23 web-test-runner.config.mjs

Do I need to delete all this and replace it by the folder egroupware-docker/ ?

[RalfBecker]

Mit Plesk hast Du Dir die mit Abstand komplizierteste Installation ausgesucht

EGroupware läuft ja im Container, d.h. es gibt keine Verzeichnis mit den PHP Dateien wie bei Deiner ersten Installation. Statt dessen musst Du Plesk dazu bringen, die ausgewählte Domain in die (Mehrzahl!) Container zu proxyen. EGroupware liefert dazu für Apache und Nginx entsprechende vHost / Konfig-Files mit, die musst Du “nur” bei Plesk einbinden. Ich verweise mal auf einen anderen Thread:

Installation Egroupware Docker auf V-Server unter Plesk

Ralf

[alicia]

oh my God I don’t speak German I’m sorry x)
I don’t understand anything

[RalfBecker]

Sorry, did not recognize the thread was in English

https://help-egroupware-org.translate.goog/t/rocket-chat-integration-in-egroupware/78035/13?_x_tr_sl=auto&_x_tr_tl=de&_x_tr_hl=en-US&_x_tr_pto=wapp&_x_tr_hist=true

Ralf

[alicia]

that’s our thread but in German…

[alicia]

I did the same as what indicated in you link:

But I still have a

404
Page Not Found
This page either doesn’t exist, or it moved somewhere else.

when I navigate to https://mydomain.com/egroupware

[RalfBecker]

Sure Plesk / Apache is using our config? Check the Apache-config Plesk generated.

I would always check the full URLs first:

• Login-page: https://mydomain.com/egroupware/login.php
• Logo: https://mydomain.com/egroupware/api/templates/default/images/logo.svg

As I wrote before: the installation under Plesk is by far the most complicated one …

Ralf

[alicia]

well everything was working fine before trying to re-install it in a container…

Is there really no way to integrate rocket.chat if egroupware is not running in a container?

[alicia]

Hello! I don’t what happened during the night, now I have this message :

api/src/Egw.php (117)
Database error
Connection with ADOdb::PConnect(db:3306, egroupware, $Password, egroupware) failed.

Maybe you not created a database for EGroupware yet. (999)

Run setup to install or configure EGroupware.

But my database name was always (from header.inc.php):
‘db_host’ => ‘localhost’,
‘db_port’ => ‘3306’,
‘db_name’ => ‘egwgestion2’,

So what is going on here???

[alicia]

I think, for a reason that is completely baffling to me, that now plesk is serving me the egroupware-docker version of ‘egroupware’, but I am facing this issue now and I am stuck again :

EGroupware successful installed

Please note the following user names and passwords:

Setup username: admin
password: ****

EGroupware username: sysop
password: ****

You can log into EGroupware by pointing your browser to http://localhost/egroupware/
Please replace localhost with the appropriate hostname, if you connect remote.

/usr/bin/php8.1 -d memory_limit=-1 /usr/share/egroupware/setup/setup-cli.php --update 'all,admin,01PP9Xn}yexym)sr’
EGroupware API version 23.1.004 found.
EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is not working! mysqli://egroupware:dFJVw5e7y9)xvpOQ@db/egroupware: (11)
/usr/share/egroupware/setup/inc/class.setup_cmd.inc.php (312)

Installation failed --> exiting!

I did deleted all containers and volumes at some point. Maybe that’s the origin of the problem. What should I do to solve it?

[alicia]

All right, so somehow I manage to have egroupware running in containers.

CONTAINER ID   IMAGE                                    COMMAND                  CREATED              STATUS                 PORTS                      NAMES
4a73eb57fd2f   quay.io/egroupware/rocket.chat:stable6   "docker-entrypoint.s…"   4 seconds ago        Up 2 seconds           127.0.0.1:3000->3000/tcp   rocketchat
0643d5db764d   mongo:5.0                                "docker-entrypoint.s…"   About a minute ago   Up About a minute      27017/tcp                  rocketchat-mongo
0a1bdb53c2d5   nginx:stable-alpine                      "/docker-entrypoint.…"   22 hours ago         Up 4 hours             127.0.0.1:8080->80/tcp     egroupware-nginx
e108bbba8917   phpswoole/swoole:5.0-php8.1-alpine       "docker-php-entrypoi…"   22 hours ago         Up 4 hours                                        egroupware-push
5c32929b04cf   egroupware/egroupware:23.1               "/entrypoint.sh php-…"   23 hours ago         Up 2 hours             9000/tcp                   egroupware
a3ff79f7a690   mariadb:10.6                             "docker-entrypoint.s…"   23 hours ago         Up 3 hours             3306/tcp                   egroupware-db
6b0c0e7f541e   containrrr/watchtower:latest             "/watchtower --sched…"   23 hours ago         Up 4 hours (healthy)   8080/tcp                   egroupware-watchtower

So right now I can access egroupware like this 'h++ps://mydomain/egroupware/

I have installed rocketchat like so :

apt update
HTTP_HOST=mydomain apt install egroupware-rocketchat

using the domain name where egroupware is reachable to.

Then the tutorial says :

But when I navigate to https://mydomain/rocketchat, I get

Server Error
404
Page Not Found
This page either doesn’t exist, or it moved somewhere else.

What am I doing wrong now?

[alicia]

Is there nobody to help me please?

[RalfBecker]

But when I navigate to https://mydomain/rocketchat, I get

That’s because quite recently Rocket.Chat stopped supporting to install it under a path prefix and we had to move it to the root of the webserver, as it’s the only place RC supports to be installed.

But we redirect the root (https://example.com/) to EGroupware, so you need to use https://example.com/home

Ralf