RocketChat setup (again ...)

[prodesk]

Still trying to get rocketchat login from egroupware to work. With a fresh installation everything works fine but when I load the database backup from the previous installation, login stops working. The problem should therefore be in the database data.
I noticed, while installing rocketchat, the error message (see image) but I can’t solve it.
I followed the instructions regarding root login without password in the install instructions.
NOTE: The database is on another server, not the same where the egroupware is running.
Any idea how to fix?

thanks in advance

pier

[RalfBecker]

when I load the database backup from the previous installation, login stops working

That is to be expected, as the created OAuth credentials are overwritten by your backup.

One way to deal with that, if you have no data in Rocket.Chat yet, is to trigger a RC reinstall, either by purging egroupware-rocketchat, or manually calling:

cd /etc/egroupware-rocketchat
HTTP_HOST=egw.example.org ./install-rocketchat.sh

If you database is not running in a container as it’s the default for a 20.1 installation, you need to create a ~/.my.cnf file with root password AND in your case the host:

[client]
host = other.host
user = root
password = secret
database = egroupware

Test if you can access the database by simply typing mysql without any parameter.

Ralf

[prodesk]

Hi Ralf
Thanks for the reply.
This way it seems to work !!! …except for 2 details

1. The variable with the database name is not taken into account. Testing with “mysql” the connection works, but starting the procedure manually the default database name (egroupware) is taken. I changed the database name in the install-rocketchat.sh file and what works !!!
2. The procedure does not seem to end. Something remains pending (see figure)
   
   
   
   A message appears after a long time (see figure)
   
   
3. By accessing egroupware, the message in the figure appears.
   
   

I’ve tried uninstalling and reinstalling rocketchat several times but nothing changes.
Any other ideas?

PS Today I was able to load the databases of the old installation on the new one after having disabled the openid and rochetchat modules from egroupware/setup. Then I re-enabled them and performed the rocketchat installation and it seems that in this way, on the new installation, I can get back all my data and rocketchat working. What do you think about it ? Can this also be corrected?

Thanks for your help

Pier

[RalfBecker]

The variable with the database name is not taken into account. Testing with “mysql” the connection works, but starting the procedure manually the default database name (egroupware) is taken. I changed the database name in the install-rocketchat.sh file and what works !!!

What variable are you talking about? From /etc/egroupware-docker/docker-compose*.yml

The procedure does not seem to end. Something remains pending (see figure)

hang this after rocket setup.JPG1218x120 8.61 KB

A message appears after a long time (see figure)

That’s a tail of the log, so you can watch Rocket.Chat starting. You have to quit it with Ctrl-C.

By accessing egroupware, the message in the figure appears.

error pos rc install.JPG

I’ve seen that once, somehow the key-pair used by OpenID Connect app is broken, you can delete it (in /var/lib/egroupware/default/files/openid/) and it will be generated again, thought all JWT token are obviously no longer valid.

Ralf

[prodesk]

Hi Ralf. Finally after years of trying Rocketchat works !!!
Basically I have followed your instructions on uninstalling, installing and deleting the keys as per your last message and now everything works perfectly.
I’m really happy ! My installation is now complete.
Thank you !!!
the correction regarding the database I make it in the file /etc/egroupware-rocketchat/install-rocketchat.sh and the variable that I correct (in my case) is EGW_DB_NAME from egroupware to egw_new (in my case …)

Thanks again for your help !!!
(PS soon I will do a new review on linked in related to project management)