[SOLVED] Removing customer users synced from LDAP

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

[SOLVED] Removing customer users synced from LDAP

Post by aph »

In which table are customer users synced from LDAP stored? I would like to delete test users that were synched from LDAP.
Last edited by aph on 17 Jul 2014, 14:48, edited 1 time in total.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Removing customer users synced from LDAP

Post by jojo »

customers are not synced into OTRS tables. It is a life accessing of the LDAP
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Removing customer users synced from LDAP

Post by aph »

While testing, at first I did not apply any group restrictions on customer users, i.e. theoretically anyone in LDAP can log into customer portal. I could then see a list of all LDAP users under 'Customers->Customer User Administration'. In the second phase, I applied a group restriction (i.e. only users from AD group XYZ can log in through customer portal), but still all LDAP users are visible in the list. If LDAP is being accessed live, shouldn't only users from the group XYZ visible? Or am I mixing up things here?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
jojo
Znuny guru
Posts: 15020
Joined: 26 Jan 2007, 14:50
Znuny Version: Git Master
Contact:

Re: Removing customer users synced from LDAP

Post by jojo »

you only configured a limitation for log in, not for CustomerUser
"Production": OTRS™ 8, OTRS™ 7, STORM powered by OTRS
"Testing": ((OTRS Community Edition)) and git Master

Never change Defaults.pm! :: Blog
Professional Services:: http://www.otrs.com :: enjoy@otrs.com
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Removing customer users synced from LDAP

Post by aph »

I see. I seem to have confused the 'customer_user' list from OTRS DB with the 'customer list' that appears under 'Customers->Customer User Administration'. So that means only the users in the restricted AD group will be able to log in through the customer portal, right?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Removing customer users synced from LDAP

Post by crythias »

Take a look at this ... maybe it might help, maybe not.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: Removing customer users synced from LDAP

Post by aph »

Thanks! Makes the picture clear.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked