Home :: Projects :: ProjectPier Project :: ProjectPier :: Issues

LDAP Authentication

By darkstructures - Posted on February 15th, 2009
Project:ProjectPier
Version:0.8.5.0-Beta1
Component:Code
Category:feature request
Priority:normal
Assigned:Unassigned
Status:closed - fixed
Description

This patch adds optional LDAP authentication on a per user basis. The LDAP connection settings are set using the configuration section. You should be able to authenticate against Active Directory. TLS is supported.

AttachmentSize
LDAP.patch12.67 KB
#1
Submitted by dave.waters on Tue, 06/16/2009 - 18:40.

Can you provide additional information? I have the patches loaded, but cannot figure out the correct configuration - trying to authenticate against Active Directory 2003.

I am guessing I have incorrect formatting for either the LDAP domain or the user account - can you provide an example?

Thanks.

#2
Submitted by jwill417 on Mon, 08/24/2009 - 12:24.

every time I try to install this patch it screws up the implementation of ProjectPier. to install i'm following the patch install instructions within the development part of this site... is there some secret with installing this patch that I may not be aware of?

#3
Submitted by pietje on Thu, 01/07/2010 - 16:46.

Did you add the column "use_LDAP" (of type tinyint(1) unsigned) to the pp_users table?

#4
Submitted by darkstructures on Wed, 03/10/2010 - 18:39.

Yes, reference this change in the patch file

Index: /trunk/public/install/installation/templates/sql/mysql_schema.php
===================================================================
--- /trunk/public/install/installation/templates/sql/mysql_schema.php (revision 2)
+++ /trunk/public/install/installation/templates/sql/mysql_schema.php (revision 11)
@@ -390,4 +390,5 @@
`is_admin` tinyint(1) unsigned default NULL,
`auto_assign` tinyint(1) unsigned NOT NULL default '0',
+ `use_LDAP` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`id`),
UNIQUE KEY `username` (`username`),

#5
Submitted by reeboblue on Thu, 09/16/2010 - 23:24.

Hi all, stumbled upon ProjectPier for my IT organization and it seems like a perfect fit. I want to use LDAP authentication so my users can login with their existing AD username and password but I cannot get this patch to install. After I patch using LDAP.patch I do not see any new "LDAP" section in the "Configuration" area in ProjectPier. Am I missing something? I did add the use_LDAP column as mentioned in other posts....

If someone could summarize the steps for this newbie, it would be helpful :).

Any help would be appreciated!!!

Cheers,
-Chris

#6
Submitted by phpfreak on Mon, 09/20/2010 - 12:37.

Chris,

I checked the patch. It should show 3 new options in the Configuration dialog. Which language are you using? You can also update the table pp_config_options. Update statements below.

For every user you can configure whether or not to use LDAP (the pages list users, edit/add user show this).
--
Note: Replace pp_ with your table prefix. Enter the correct values for your environment after value= .

update pp_config_options set value='ldap host' where category_name='general' and name = 'ldap_host';
update pp_config_options set value='ldap domain' where category_name='general' and name = 'ldap_domain';
update pp_config_options set value='no|tls' where category_name='general' and name = 'ldap_secure_connection';

#7
Submitted by phpfreak on Tue, 10/26/2010 - 21:06.
Version:0.8.0.3» 0.8.5.0-Beta1
Status:patch - code needs review» closed - fixed

Accepted into 0.8.6.