CustomerGroup LDAP permissions

Hello, I wanted the list to know what I did to CustomerGroup.pm, It seems some others ran into issues while using LDAP and assigning default groups. Since I have multiple Customer Companies, I needed something to work. I modified CustomerGroup.pm adding line 213, 214 and changing $Param{UserID} to $CusomterIDsql. The only thing you have to do now is add the email address (@domain.tld) and permissions to the group id in the table "group_customer_user". # if it's activ, return just the permitted groups my $SQL = "SELECT g.id, g.name, gu.permission_key, gu.permission_value, gu.user_id " . " FROM " . " groups g, group_customer_user gu" . " WHERE " . " g.valid_id IN ( ${\(join ', ', $Self->{ValidObject}->ValidIDsGet())} ) AND " . " g.id = gu.group_id AND " . " gu.permission_value = 1 AND " . " gu.permission_key IN ('" . $Self->{DBObject}->Quote( $Param{Type} ) . "', 'rw') " . " AND "; if ( $Param{UserID} ) { my $CustomerIDsql = $Param{UserID}; $CustomerIDsql =~ s/^[a-zA-Z0-9._%+-]+//; $SQL .= " gu.user_id = '" . $Self->{DBObject}->Quote( $CustomerIDsql ) . "'"; } else { $SQL .= " gu.group_id = " . $Self->{DBObject}->Quote( $Param{GroupID} ) . ""; } -- Kyle Anderson
participants (1)
-
Kyle Anderson