Upgrade to version 21-error-please reply

[bettina]

on version 21 I clicked the upgrade button on setup page to continue with the upgrade myself, but nothing happens, it returns to the home page of the setup.

can you help me please ?

[RalfBecker]

Hmm the upgrade 20.1 to 21.1 should be no problem.

It must be something in you environment. Have you checked the error-log of your webserver?

Other possibility is to create a trial in our hosting, upload your backup and see if the update works there, I’m pretty sure.

Ralf

[bettina]

Hi, thanks for your response. First, I’ll see the error log on the webserver. Where is it?

[RalfBecker]

For a standard container installation, that’s easy to say.

For a non-standard installation it depends, is it a Linux distro you control, or installed in some shared hoster?
In the later case you have to ask or look at the documentation of your hoster?
On a Linux distro it depends on the web-server you use:

• Apache: /var/log/apache2 or for RedHead based distros /var/log/httpd
• Nginx: /var/log/nginx
• …

Also makes sense to check the PHP version you use. EGroupware 21.1 requires PHP 7.3+ and supports with the latest maintenance release up to the current PHP 8.1. If you install some of the deprecated apps (eg. Knowledge Base) you can not use PHP 8.x!

Ralf

Ralf

[bettina]

Hello Ralf, recapitulating and summarizing I comment:

1. In February 2020 I installed version 20 of egroupware. The egroupware application is found within the scripts included in the cpanel of my hosting account. That is, the scripts, is a Softaculous application that includes Egroupware, which allows easy installation, backups, restore them, and update versions. I was able to import the contacts from my previous version and that is the version I have been using until now.
2. I start to see some errors and on 6/Jul/22 I decide to update to version 21 myself.I did the update, but I didn’t finish it with the setup, table update, directly enter the login with the admin user and pass password, and some errors immediately appeared that didn’t let me do anything (screenshot 1). I consulted with the support of my hosting account and, they suggested me to update my hosting plan to a more complete and better one.
3. and so it was on Jul 8, 2022, I changed the hosting plan, then I restored the version 20 backup (I went to the setup and it shows that the installation is fine, I sent screenshot 2) and I did it again the update to version 21 of egroupware, and this is the time when I want to finish the installation from the setup and I can’t (screenshot 3), and this is the problem for which I am consulting you now.
4. I am attaching a file with the error log of the egroupware application that was sent to me by the support of my hosting account, which I was seeing from March 2022 to July 7, 2022 (because this is very big, I only send you the last 3 days, from July 5 to July 7, 22) and I did the update on the 8th and 12th of July .
   Also from the support of my hosting account they made it clear to me that it is a Linux server shared with other users.
5. I hope I have been clear and you can help me to finish the update to version v 21, and login it.
   Anything else you need, don’t hesitate to ask me.
   Regards,
   Bettina
   
   
   
   
   
   
   
   
   
   error_log-5jul022.txt (2.1 MB)

[RalfBecker]

The error with not existing table egw_addressbook_shared, means you missed to run the 21.1 update (via setup, if you do everything manual), which creates that table.

Ralf

[bettina]

Hello ,
Sorry but i do not understand,
-Where did you read that error?
-Did you see my last message until the end? I now have the problem that the update button in the setup does not execute, and I cannot finish the update? why ? how is it solved?
Bettina

[RalfBecker]

Where did you read that error?

In your first screenshot.

Not sure how you got that screenshot, if the button does not execute.

If the button does nothing, look at the network tab of the developer tools of your browser: it should show the submitted form and the result / HTTP Status of the webserver, if you have no access to the error-log.

Ralf

[bettina]

Hi Ralf,
1-I first go to the setup (capture 1), I click on login, this takes me to the next page (capture 2), I click on the update button, and it returns to the previous page (capture 3), that is what it does, that’s why I say it doesn’t execute.
2- I’m sending you screenshots of the developer tool, I’m not sure if that’s what you want to see…(screenshots 4 and 5)
3- error-log, why you say that I can’t see it? I don’t know where it is?
4- I sent you the error log file that the support of my hosting account sent me, that is all there is and it arrives until July 7, 2022, could you see it?
Regards,
Bettina

[RalfBecker]

1-I first go to the setup (capture 1), I click on login, this takes me to the next page (capture 2), I click on the update button, and it returns to the previous page (capture 3), that is what it does, that’s why I say it doesn’t execute.

So you click un [Upgrade] and you are immediately on the login page again, that is very different from what I understood so far.

It means one of two possible things:
a) your browser does not accept the session cookie (can also be a wrong server-time)
b) you don’t have PHP’s session extension enabled

You need to clear up the above with your hosters support!

4- I sent you the error log file that the support of my hosting account sent me, that is all there is and it arrives until July 7, 2022, could you see it?

I missed the uploaded error_log, sorry.

What I see immediately in the log:
PHP Warning: fopen(): https:// wrapper is disabled in the server configuration by allow_url_fopen=0

allow_url_fopen must be enabled for EGroupware: you need to talk to your hosters support.

Anyway, shared or managed hosts are a very bad fit for EGroupware, our recommendation is to get a small root-server and install EGroupware via our Linux packages, which internally use docker-compose. That saves you all the above problems.

Ralf

[bettina]

Hi Ralph,
ok I’m going to ask all that you says with the hosting support, but previously I ask you :

1. In the error log you can see that it is New York time, and I am in Argentina, perhaps I have misconfigured the egroupware. How can i change this now? where is it changed in the database?
   Regards,
   Bettina

[RalfBecker]

EGroupware uses two timezones:

• user-timezone in the user preferences, which can be different for each user
• server-timezone, which need to match the content of your database and otherwise does not matter. In new (container-)installations it defaults to UTC.

I would not start changing anything here, until you can see your content again / log into EGroupware and eg. after a migration you see wrong times.

Ralf

[bettina]

Hello Ralf, I tell you that:

1. From my host’s support, I have been informed that in response to your request, the [allow_url_fopen] directive has been enabled.
2. then I have tried again to complete the installation and the problem continues the same
   Can you help me with something else?
   Regards,
   Bettina H.

[RalfBecker]

Have you checked the server-time is correct, as it looks like a session problem …

If your host is publicly available and you share the setup credentials with me (per PM please!), I can have a quick look, why you are thrown out immediately.

If that fails, only thing I can offer: you buy some support and give me access to the machine, so I can have a closer look.

Other option is to use the recommended installation way on a Linux root server, or our SAAS hosting …

Ralf

[bettina]

Hi Ralph,
I tell you that I have been able to perform a new installation of egroupware, from the cpanel scripts of my hosting.

1. Everything has been installed automatically and ok, I send you capture -setup.
2. But when I go to login the first time, after registering username and password (Admin-Pass), I cannot enter, it asks me …"Requires 2-factor authentication … " (send capture -login)
   Can you help me with this error?
   Once I enter this new installation I will see if I can import the information and data that I had in the previous one.
   Regards,
   Bettina H.
   
   

[RalfBecker]

I believe that enabled 2 factor authentication is a cpanel problem, thought it’s easy to fix: use setup to install your latest backup, that will overwrite also the 2FA config.

Thought the cpanel installation gives you not a full EGroupware installation, as the Linux package installation does, because it lacks the push server!

Ralf

[bettina]

Hi Ralph,
I tell you that I continue the same without being able to enter the new installation of egroupware v 21,

1. I have consulted the hosting support for 2-factor authentication and they replied that they cannot do anything about it, and they tell me to consult you. How to disable this function in the database?
2. Regarding the option to restore a backup from the setup, can you tell me step by step how to do it?
3. like you said that it is a login problem, for my part I have been looking at my browser settings, I have disabled 2-step authentication, I have deleted cookies, and I have allowed cookies… But everything is almost the same.
   It does not allow me to enter and you can see what I sent you on the screenshot. Can you test on your computer if it does the same?
4. I send you a screenshot of the setup, can you tell me if everything is ok? , and where and how can i change de login password ?
   Regards,
   Bettina H
   
   
   
   
   

[RalfBecker]

How to disable this function 2FA in the database?

DELETE FROM egw_config WHERE config_name='2fa_required'

Regarding the option to restore a backup from the setup, can you tell me step by step how to do it?

When you are about to install, there is a button [Install] and below is a file upload, use that to upload your backup (EGroupware Database Backup, not MySQL dump!).

I send you a screenshot of the setup, can you tell me if everything is ok? , and where and how can i change de login password ?

The passwords you set in header-admin (Heade and Configuration password) are for Setup, upper login. They are not for EGroupware itself!

If you do a new, manual installation, your database contains no user, you have to create a first administrative user in Setup using the button [Create admin account].

The problems you have are caused by your installation method!
Please follow our advice about the a recommend installation, it saves everyone a lot of trouble.

Ralf

[bettina]

Hi Ralph,

• Authentication in 2 steps: in an attached file I send you a screenshot of the file that has been deleted by the support of my hosting account. However, I still have not been able to access the link:
  www.arcolenargentina.com/egroup22
  If you want, I could tell you how to access the cpanel to check the database.
• Regarding restoring the backup, the restore button does not work, that is, the page returns to the previous page, the same thing happens as with the update database button
  You can check this in the link :
  www.arcolenargentina.com/egroup2020/setup
• I appreciate your suggestion for another type of installation in linux or another plan, but at the moment I couldn’t.
• Tell me if you can help me with something more than a good result, I am very grateful to you.
  Regards,
  Bettina H
  

[RalfBecker]

If you still get the 2FA error, without having the 2fa_required configuration, then you set up a 2nd factor, eg. time based one time password / Google authenticator.

You can either disable all 2FA:

REPLACE INTO egw_config (config_app,config_name,config_value) VALUES ('phpgwapi', '2fa_required', 'disabled')

Or you can deleted the 2nd factors:

DELETE FROM egw_ea_credentials WHERE cred_type=32

If you want support above asking questions here, you have to buy a support budget!

We can not give you a software free of charge and not charge for support!

Ralf