Forum GLPI-Project

mastarain

Member

Registered: 2010-07-23

Posts: 3

Can't log in

Hi, all.

I really need your help, cause somehow I broke company's glpi and I can't fix it.

So, we had problems with LDAP connection, and every user, who tryed to log in, see this message

"Can not connect to LDAP directory. TLS/SSL failure for mx.blabla.ru: SSL negotiation failed".

So I went in properties using login and pass "glpi:glpi" and changed LDAP connection settings. Especially I created new account to connect to LDAP and it connected fine. But when I logged off and tried to log using some user account it said - "Wrong login or password". Then I tried to login using "glpi:glpi" and it doesn't work also!..

So I thought that somehow LDAP authentification became enabled to glpi (which I thought was local) account.

I went to PHPmyAdmin and looked through table "glpi_users". I found interesting fields "id_auth" and "auth_method". I guess it means what method do account use to log in - LDAP or local.

PLEASE HELP? Can somebody tell me what values Account "Glpi" has in "glpi_users" table? Especially id_auth and auth_method.

Maybe anyone know how to log in into glpi locally?

I really need your help. Thanks in advance.

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Can't log in

For a local account, id_auth is -1 (with ldap it's the id of glpi_auth_ldap)
and auth_method is 1
and password_md5 mustn't be empty

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

mastarain

Member

Registered: 2010-07-23

Posts: 3

Re: Can't log in

Thanks for answer, but still doesn't work.

It goes - wrong login or password. When password_md5 is not empty should I enter anything at password field?
Can I create admin local account like glpi just by myself in phpmyadmin?

This is how tables users and ldap_auth look like (I hope it helps) :

Table glpi_users -

ID:2
name: glpi
password: glpi
password_md5: 14c34743f39eeff10ca944e1340cf492
email:
phone:
phone2:
mobile:
realname:
firstname:NULL
location:0
tracking_order:1
language:ru_RU
list_limit:50
active:1
comments:NULL
id_auth:-1
auth_method:1
deleted:0
FK_profiles:0
FK_entities:0

glpi_auth_ldap table -

ID: 1
name: connect1
ldap_host: %%%
ldap_basedn: %%%
ldap_rootdn: %%%
ldap_pass: connect1
lpad_port:389
ldap_condition:
ldap_login:connect1
ldap_use_tls:0
ldap_field_group:users
ldap_group_condition:
ldap_search_for_groups:0
ldap_field_group_member:memberof
use_dn:0
timezone:0
ldap_opt_deref:0

everything else is empty. %%% means I didn't wanna show it, but it worked fine.

please help.

Last edited by mastarain (2010-07-24 08:53:13)

yllen

GLPI-DEV

From: Sillery (51)

Registered: 2008-01-14

Posts: 15,278

Re: Can't log in

name: glpi
password: glpi
password_md5: 14c34743f39eeff10ca944e1340cf492

In my database, the field password is empty
and password_md5 is not the same. Have you change it ?

---

CentOS 6.5 - CentOS 7.x
PHP 5.6 - PHP 7.x - MySQL 5.6  - MariaDB 10.2 + APC + oOPcache
GLPI from 0.72 to dev version
Certifiée ITIL (ITV2F, ITILF, ITILOSA)

itadmin@romsons.com

Member

Registered: 2019-07-22

Posts: 3

Re: Can't log in

i am installing fresh copy glpi 9.2.4 and successfully created all user after fwedays days nobody can login errro comes on screen login again what happen can any one help me out