502 Bad Gateway - Database error

[justinz]

I powered up this docker app and get 502 Bad Gateway,

In the log:

# docker restart egroupware
egroupware
# docker logs -f egroupware

EGroupware successful updated
 * Starting periodic command scheduler cron
   ...done.
[30-Jun-2021 04:00:26] NOTICE: fpm is running, pid 1
[30-Jun-2021 04:00:26] NOTICE: ready to handle connections
[30-Jun-2021 04:00:26] NOTICE: systemd monitor interval set to 10000ms
[01-Jul-2021 04:20:01] NOTICE: [pool www] child 49 exited with code 0 after 87575.267016 seconds from start
[01-Jul-2021 04:20:01] NOTICE: [pool www] child 2889 started
[01-Jul-2021 04:25:01] NOTICE: [pool www] child 50 exited with code 0 after 87875.331164 seconds from start
[01-Jul-2021 04:25:01] NOTICE: [pool www] child 2892 started
[01-Jul-2021 04:30:45] NOTICE: [pool www] child 53 exited with code 0 after 88218.874783 seconds from start
[01-Jul-2021 04:30:45] NOTICE: [pool www] child 2895 started
[01-Jul-2021 04:30:46] NOTICE: [pool www] child 51 exited with code 0 after 88219.339383 seconds from start
.....
[07-Jul-2021 02:45:01] NOTICE: [pool www] child 19432 started
/usr/bin/php7.4 -d memory_limit=-1 /usr/share/egroupware/setup/setup-cli.php --update 'all,admin,)MTbcbDERN1Xo4J2'
EGroupware API version 21.1 found.
EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is not working! mysqli://egroupware:()b?Il64Ja)Wa7w=@db/egroupware:

Installation failed --> exiting!

Retrying EGroupware installation in 3 seconds ...
/usr/bin/php7.4 -d memory_limit=-1 /usr/share/egroupware/setup/setup-cli.php --update 'all,admin,-24d]&J=Xs3p&|CP'
EGroupware API version 21.1 found.
EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is not working! mysqli://egroupware:()b?Il64Ja)Wa7w=@db/egroupware:

Installation failed --> exiting!

Retrying EGroupware installation in 3 seconds ...
/usr/bin/php7.4 -d memory_limit=-1 /usr/share/egroupware/setup/setup-cli.php --update 'all,admin,GWlm?kF#gTg(eS|#'
EGroupware API version 21.1 found.
EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is not working! mysqli://egroupware:()b?Il64Ja)Wa7w=@db/egroupware:

Installation failed --> exiting!
....

Does it appear there’s a database corruption?

Any advice??

Thanks,
Justin

[RalfBecker]

Hard to help, with so little information

If it was a new 21.1 installation, MariaDB should be running in a container, as you can confirm by running the command docker ps. That MariaDB instance can be accessed by either docker exec -it egroupware-db bash or /etc/egroupware-docker/mysql.sh. The later calls mysql client with the root password from .env.

If the database is in deed damaged, you need to repair it …

If database is not running, you need to start it with:

cd /etc/egroupware-docker
docker-compose up -d

Logs can be views via docker logs -f egroupware-db

Ralf

[StefanU]

Don’t you have a backup?

A backup of the complete VM and additionally the EGroupware’s own data backup + backup of the files under
/var/lib/egroupware
should already be there.

Stefan

[justinz]

Is there any other way to install eGroupware besides via Docker?

Do these instruction for installing a development version of EG still work with the latest release tags? (I ask because I use composer to maintain other apps and I’m more comfortable with it). If yes, then is it possible to run periodic updates to the codebase and DB schema?

GitHub - EGroupware/egroupware: Web based groupware server written in PHP, forum...

Recently I had setup a Debian VM and installed EG, but within a week I got “502 Bad gateway”. I reported it here, and I all I got was Stefan’s note, but he didn’t say where the backup would be located or how to apply it, just what it would contain:

A backup of the complete VM and additionally the EGroupware’s own data backup + backup of the files under

/var/lib/egroupware

should already be there.

Finally I tracked it down to a failing database, and so I asked “how do I reinitialize the database?”, but I got no response.

After running a few docker-compose commands that were supposed to (recreate? rebuild? reset?) egroupware-docker, I no longer had a working docker.service. Due to this I now cannot apt upgrade my Debian guest, etc etc.

Is eGroupware a LAMP application or Node.JS? Have you considered having a set of PHP or Node requirements, a sample Apache/Node config, and a script to populate a fresh database? I find that using Docker, installing the DB via docker-compose (is that even possible?), and routing through an Nginx reverse proxy, though it may be easy to install initially, lead to an unmaintainable system (at least for me).

Not sure I’m going to rebuild this on Debian, as I’m not confident in the stability. Are there any other setups you recommend? On a NAS – say QNAP – can I run the two depreciated modules Wiki & Knowledge-base simply by checking them out of the repo into /etc/egroupware/ and restarting the container?

Thank you

[StefanU]

but he didn’t say where the backup would be located or how to apply it,

Backup of EGroupware

Stefan

[StefanU]

Are there any other setups you recommend?

No.
There are various options, but none that support all functions and are easy to install. You always need know-how.
And we can/want to support only standard installations (in community support). Anything else is too much effort and offline via forum is not feasible in this area.
In the context of commercial support, more is certainly (technically) possible.
In your case, we (I) cannot reproduce your problem either. The cause lies in your network constellation or your environment.

Stefan

[justinz]

Ok, I totally understand. And I’m sorry if I come off as a squeaky wheel.
I will say that I stumbled upon the instructions to install a development version, and now the architecture of EG is becoming a bit more clear to me. This method allowed me to install without Docker, under Apache (with a redirect to the Nginx proxy(?)), and I got a sense of how the database setup works. I realize that this may side-step some useful features, such as update automation, etc, but at least some the fog of what’s under the hood has cleared. I will probably get back on the mainstream bandwagon at some point. Thank you!

[shri]

EGroupware API version 21.1.001 found.
EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is working, but you don’t have any applications installed (pgsql://egwuser:egwpass@10.0.100.75/egroupware). Use --install to install EGroupware
/usr/share/egroupware/setup/inc/class.setup_cmd.inc.php (314)

Installation failed --> exiting!

Retrying EGroupware installation in 3 seconds …

Please guide

[StefanU]

Hi Shri.

Please create your own topic and describe what your problem is. Without a description there can be no answer/solution.

See also:

How do I report a problem/error correctly?

Stefan

[shri]

I feel that will be duplicate thread because i get the same error when i try to access http://servier ip/egroupware/index.php

I need to run egroupware on ubutu 20.4 with postgresql, egw installed perfectly with mariadb but when i try to change header.inc.php to connect it with postgresql it gives me following error.

there is a suggestion in error to use --install to install egroupware, i am new to docker , can someone guide how can i install egroupware with postgresql?

---

Groupware API version 21.1.001 found.
EGroupware configuration file (header.inc.php) version 1.29 exists and is up to date
Your database is working, but you don’t have any applications installed (pgsql://egwuser:egwpass@10.0.100.75/egroupware). Use --install to install EGroupware
/usr/share/egroupware/setup/inc/class.setup_cmd.inc.php (314)

Installation failed --> exiting!

Retrying EGroupware installation in 3 seconds …

[StefanU]

Once again… Please notice:

How do I report a problem/error correctly?

Stefan

[andrea.soc]

i have similar problem
502 Bad Gateway
and if check the logs with command docker logs -f egroupware

Retrying EGroupware installation in 3 seconds …
/usr/bin/php7.4 -d memory_limit=-1 /usr/share/egroupware/setup/setup-cli.php --setup-cmd-database sub_command=create_db ‘domain=default’ ‘db_type=mysqli’ ‘db_host=localhost’ ‘db_port=3306’ ‘db_name=egroupware’ ‘db_user=egroupware’ ‘db_pass=I>?71mOMj&]0zF=W’ ‘db_root=root’ ‘db_root_pw=bc7c64aaad6256792f4f61ee2113baae’ 'db_grant_host=%'
Can not connect to mysqli database mysql on host localhost:3306 using user root! (ADOdb::Connect(localhost:3306, root, $Password, mysql) failed.)

Installation failed --> exiting!

Installing of EGroupware failed!

i have egw 20.1

but I haven’t launched any egroupware updates
thanks for support!

[StefanU]

And again… Please notice:

How do I report a problem/error correctly?

Stefan