Forgot the password to login to egrouware 1.6

bettina 2019-11-28 22:45:22 UTC #1

Hello, I have installed egroupware version 1.6 free, and it does not recognize the password,i don´t know what happens … can you help me please to recover the password or bleach it?regards, Bettina

StefanU 2019-11-29 13:32:12 UTC #2

Hello, Bettina.

Oh, this is very, very old. I started with the version at that time.
But I’m not sure if I still know everything about the version.

But let’s have a look:

You are a normal user or do you also have administrator rights?
Are there other users with administrator rights?
Do you have the access data for the setup?.:
http(s)://your-EGw-address/setup

Do you have root access to the system running EGroupware?

Regards
Stefan

bettina 2019-11-30 03:20:43 UTC #3

Hi, thank you very much for your response. Yes you’re right, it’s a very old version. I intend to move to a newer one but I have not had time yet and now I am just with this problem that I cannot enter. Well I will answer your questions:

I am a normal user and also with administrator privileges
I am the only user with administrator rights
Do you have access data for configuration?
http (s): // your address / configuration of EGw …, I do not understand your question well, I have gone to the link: http: //www.mydomain.com/egroupware/setup/
but I haven’t been able to do anything, I don’t have the key and I don’t know how it’s done
Do you have root access to the system running EGroupware? Yes could enter the cpanel where the egroupware files are hosted,
I hope hear from you as soon as posible,
Regards,
Bettina

RalfBecker 2019-11-30 07:08:12 UTC #4

So you’re own password no longer works, you have no other admin to reset it and you have no access to setup, but root rights on the system.

I that case you first need to use your root rights to get access to setup again:

find out where the header.inc.php file of your EGroupware instance is stored (for a deb/rpm package installation it will be /var/lib/egroupware/header.inc.php, but I don’t know how you installed)
edit that file and change the following two lines:

$GLOBALS['egw_info']['server']['header_admin_password'] = '{plain}secret';

	'config_passwd' => '{plain}secret'

This will reset the setup password to: secret
Please also note the name of $GLOBALS['egw_info']['server']['header_admin_password'] which is usually: admin

Go to setup https://your.domain.org/egroupware/setup/ and log in using the upper login with the username you found (usually admin) and password secret
Click on [Create admin user] button and enter your own username and a new password twice. This will set just the password for your existing user.
Start planning the update

Ralf

bettina 2019-11-30 22:38:16 UTC #5

Hello,
thank you for you reply!
i went to the cpanel , egroupware files and find the header.inc.php file, and also find this 2 lines :

$GLOBALS[‘egw_info’][‘server’][‘header_admin_user’] = ‘beti’;
$GLOBALS[‘egw_info’][‘server’][‘header_admin_password’] = ‘81dc9bdb52d04dc20036dbd8313ed055’;

but i don´t understand well what i have to do ?, I have to completely replace them with the ones you gave me?
what do you mean with " secret " ?
Can you help me please ?
Regards,
Bettina

RalfBecker 2019-12-01 05:34:58 UTC #6

Hi Bettina,

if you google the md5-hash you just posted, you get your setup password: 1234

So instead of modifying the file just use it and continue with step 3.) of my last post.

Don’t forget to change the setup password(s) in header-admin (lower login of setup)!

Ralf

bettina 2019-12-01 22:44:20 UTC #7

Hi,
I tried with …1234 …, but I couldn’t, I got the error: Bad login or password *,
Can you help me please ?
Regards,
Bettina

RalfBecker 2019-12-02 05:36:22 UTC #8

Did you try to login to setup (https://your.domain/egroupware/setup/) or EGroupware with your own user?

The password is for setup.

As your installation is ancient, chances are good your own user also uses a md5-hash. You could try to find it in the egw_accounts table.

Ralf

bettina 2019-12-02 23:22:15 UTC #9

Hi
Now I have followed yours instructions well and I have been able to enter in the setup with username: beti and password 1234, and in step 3 administration accounts, the same administrator user (beti) i have entered a new password twice, I have saved. and I have returned to the beginning of the session …, I have tried but I have not been able to enter …
I do not know what’s happening ??
but I would like to comment you that this problem appears after the host administrator where egroupware is hosted, made a change on servers and asked me to change the DNS, so it was, they was changed and then the problem appeared …, now I see that in the setup there is a part of server configuration, maybe this should be reviewed?
Can you help me please ?
Regards,

RalfBecker 2019-12-03 05:39:59 UTC #10

You gone to regular EGroupware login screen and entered your user beti plus the new password.

What error message did you get?

Ralf

bettina 2019-12-03 12:55:27 UTC #11

Hello Ralf,

The error I get is: Your session could not be verified.
Regards,

Bettina

bettina 2019-12-04 00:30:47 UTC #12

Hello Ralf,

The error I get is: Your session could not be verified.
Regards,

Bettina

RalfBecker 2019-12-04 14:47:37 UTC #13

Ok, that has nothing to do with your password!

It can a couple of things in your php environment:

PHP session extension not available or misconfigured
filesystem full
wrong cookie parameters

Only the filesystem full can happen spontaneously (if you don’t monitore it).
Everything else only happens if someone changes something on your system!

Ralf

bettina 2019-12-04 21:50:10 UTC #14

Hello Ralf,
I have contacted the host administrator, and they ask me what is the name of the egroupware setup database . Can you tell me that ?

Regards,
Bettina

RalfBecker 2019-12-05 18:23:44 UTC #15

Hmm, no idea what they mean with an EGroupware setup database.

Your database name is written in the header.inc.php file, by default it’s egroupware.

I’m sorry to say: you need a competent administrator, or should come eg. into our hosting, were we administrate and update EGroupware for you.

Ralf

bettina 2019-12-07 21:57:45 UTC #16

Hello, excuse me, i wish you clarify me :

I have contacted the administrator of my host, and they tell me that they have currently left the oldest version that supports the server ( the php 5.6 ), however I still cannot log in, is that possible? Does the egroupware 1.6 version require an even older version of php?
Is it possible to migrate all the information I have in version eg 1.6 to a newer one, directly from the Mysql databases?
Thank you in advance for all your answers,
Regards,
Bettina

RalfBecker 2019-12-08 06:48:26 UTC #17

EGroupware 1.6 was released nearly 10 years ago, it required PHP 5.1 and was tested with 5.2.

Sure, that is possible. Thought there is no guarantee, that it works skipping so many versions.

Install a recent 19.1 (requires Docker) and give it a try.

Or try out our hosting, it can import a dump created by setup, to which you have access.

Ralf

bettina 2019-12-09 03:51:14 UTC #18

Hi, could you clarify:

I have tried to pass the address book from eg version 1.6 to version 14 and I have not been able, by importing cvs format, and also using mysql database copy. Could you help me or tell me where I find instructions?
what does docker mean for the installation of eg version 19 ?
Regards,
Bettina

RalfBecker 2019-12-09 05:37:35 UTC #19

In your case, using an old host with PHP 5.6, you should make a backup using setup (upper login) and click on [Database backup], then [Backup now] and download the backup.

Then you need to make a new installation of EGroupware 19.1 following the instructions in the wiki on Github: https://github.com/EGroupware/egroupware/wiki/19.1--Installation-using-egroupware-docker-RPM-DEB-package

Once you have a new empty EGroupware installation, you need to do the following steps:

rsync the files directory (by default /var/lib/egroupware/default/files) to the new installation
login to setup (upper login) restore the backup you made from 1.6 and click on update

You can skip step 1. but that means loosing all files and attachments.

I you want to have a quick test of the update, create a trial in our hosting (https://www.egroupware.org/trial), login with your sysop credentials, go to Admin >> Database backup and restore and restore your 1.6 backup.

Docker is a technology to run Linux container on a host. Docker is the default way of installation for EGroupware 19.1 either through Linux packages (containing docker-compose files) or docker-compose directly.

Ralf

bettina 2019-12-10 12:41:08 UTC #20

hello, I consult again

In my old version of eg 1.6, I had one more application created by programmer especially for me … I can do the same backup and then restore it in the new version eg 19. Can this affect?
Or how would you have to do to import the data of each application or table one by one?
Regards,
Bettina