https://www.redmine.org/https://www.redmine.org/favicon.ico?16793021292008-03-06T14:44:02ZRedmineRedmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=16622008-03-06T14:44:02ZSergej Jegorov
<ul></ul><p>production.log with debug<br /><pre>
Processing AccountController#login (for 127.0.0.1 at 2008-03-06 16:32:30) [POST]
Session ID: ae7fc8f0fe6b88f73affb24231a03ce0
Parameters: {"action"=>"login", "username"=>"sergio", "controller"=>"account", "password"=>"[FILTERED]", "login"=>"Вход »"}
Setting Columns (0.000977) SHOW FIELDS FROM `settings`
SQL (0.000140) SELECT max(updated_on) AS max_updated_on FROM `settings`
SQL (0.000961) SHOW TABLES
User Columns (0.001709) SHOW FIELDS FROM `users`
SQL (0.001026) SHOW TABLES
Project Columns (0.001378) SHOW FIELDS FROM `projects`
SQL (0.000965) SHOW TABLES
Issue Columns (0.001884) SHOW FIELDS FROM `issues`
SQL (0.000998) SHOW TABLES
SQL (0.000888) SHOW TABLES
SQL (0.000867) SHOW TABLES
AnonymousUser Columns (0.001769) SHOW FIELDS FROM `users`
AnonymousUser Load (0.000196) SELECT * FROM `users` WHERE ( (`users`.`type` = 'AnonymousUser' ) ) LIMIT 1
User Load (0.000712) SELECT * FROM `users` WHERE (login='sergio') LIMIT 1
AuthSource Columns (0.001738) SHOW FIELDS FROM `auth_sources`
AuthSource Load (0.000206) SELECT * FROM `auth_sources` WHERE (`auth_sources`.`id` = 1)
AuthSourceLdap Columns (0.001649) SHOW FIELDS FROM `auth_sources`
Rendering template within layouts/base
Rendering account/login
Setting Load (0.000245) SELECT * FROM `settings` WHERE (`settings`.`name` = 'autologin') LIMIT 1
Setting Load (0.000155) SELECT * FROM `settings` WHERE (`settings`.`name` = 'lost_password') LIMIT 1
Setting Load (0.000173) SELECT * FROM `settings` WHERE (`settings`.`name` = 'app_title') LIMIT 1
Setting Load (0.000142) SELECT * FROM `settings` WHERE (`settings`.`name` = 'ui_theme') LIMIT 1
Setting Load (0.000156) SELECT * FROM `settings` WHERE (`settings`.`name` = 'self_registration') LIMIT 1
Member Columns (0.001340) SHOW FIELDS FROM `members`
SQL (0.000206) SELECT count(DISTINCT `members`.id) AS count_all FROM `members` LEFT OUTER JOIN `projects` ON `projects`.id = `members`.project_id LEFT OUTER JOIN `roles` ON `roles`.id = `members`.role_id WHERE (members.user_id = 2 AND (projects.status=1))
Completed in 0.57083 (1 reqs/sec) | Rendering: 0.07253 (12%) | DB: 0.02354 (4%) | 200 OK [http://redmine.elgama.lt/login]
</pre></p> Redmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=16632008-03-06T14:52:43ZSergej Jegorov
<ul></ul><p>if <code>app/models/auth_source_ldap.rb</code> change revision to <a class="changeset" title="Fixed: LDAP authentication without password may be possible (#714)." href="https://www.redmine.org/projects/redmine/repository/svn/revisions/1169">r1169</a> production.log shows:<br /><pre>
Processing AccountController#login (for 127.0.0.1 at 2008-03-06 16:46:48) [POST]
Session ID: ae7fc8f0fe6b88f73affb24231a03ce0
Parameters: {"action"=>"login", "username"=>"sergio", "controller"=>"account", "password"=>"[FILTERED]", "login"=>"Вход »"}
SQL (0.000190) SELECT max(updated_on) AS max_updated_on FROM `settings`
User Load (0.000760) SELECT * FROM `users` WHERE (login='sergio') LIMIT 1
AuthSource Columns (0.001855) SHOW FIELDS FROM `auth_sources`
AuthSource Load (0.000194) SELECT * FROM `auth_sources` WHERE (`auth_sources`.`id` = 1)
AuthSourceLdap Columns (0.001909) SHOW FIELDS FROM `auth_sources`
DN found for sergio: CN=Sergej Jegorov,CN=Users,DC=elgama,DC=lt
Authentication successful for 'sergio'
SQL (0.000146) BEGIN
User Update (0.001008) UPDATE `users` SET `login` = 'sergio', `hashed_password` = '', `auth_source_id` = 1, `lastname` = 'Jegorov', `status` = 1, `mail_notification` = 0, `type` = NULL, `admin` = 1, `last_login_on` = '2008-03-06 16:46:49', `updated_on` = '2008-03-06 16:46:49', `language` = 'lt', `mail` = 'my@e-mail', `firstname` = 'Sergej', `created_on` = '2008-01-09 21:28:09' WHERE `id` = 6
SQL (0.017064) COMMIT
Redirected to http://redmine.elgama.lt/my/page
Completed in 0.15206 (6 reqs/sec) | DB: 0.02313 (15%) | 302 Found [http://redmine.elgama.lt/login]
</pre></p> Redmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=16672008-03-06T17:02:15ZJean-Philippe Langjp_lang@yahoo.fr
<ul></ul><p>Do you specify a username/password on the LDAP setup screen or do you read it anonymously ?</p> Redmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=16682008-03-06T17:09:29ZSergej Jegorov
<ul></ul><p>We use user/pass on the AD Domain controller (no anonymous). We don't use LDAPS, and "Test connection" link Show sucseeful message.</p> Redmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=16712008-03-06T17:21:28ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>New</i> to <i>Resolved</i></li></ul><p>My fault. Fix is committed in <a class="changeset" title="Fix LDAP authentication (#714, broken by r1194)." href="https://www.redmine.org/projects/redmine/repository/svn/revisions/1199">r1199</a>.</p> Redmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=16722008-03-06T18:35:39ZSergej Jegorov
<ul></ul><p>This is Works fine!</p>
<p>Thank yor very mach.</p> Redmine - Defect #796: Active directory LDAP authentification broken.https://www.redmine.org/issues/796?journal_id=20812008-03-29T23:01:53ZJean-Philippe Langjp_lang@yahoo.fr
<ul><li><strong>Status</strong> changed from <i>Resolved</i> to <i>Closed</i></li><li><strong>Target version</strong> set to <i>0.7</i></li></ul>