You are not logged in.
Pages: 1
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.
Offline
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)
Offline
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)
Offline
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)
Offline
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
Offline
Pages: 1