Hi,
I use ldap as our source for customer users.
When doing this the table customer_user in the database remains empty.
Does otrs store the ldap users in some temp table or does it query the AD every time you need a user?
What I'm trying to achiveve is a sql query that fetches the ticket and the customer user complete info (first/last name, phone etc).
But since the table is empty I only get a userid which is stored in the ticket table.
[SOLVED] Customer users ldap
Moderator: crythias
[SOLVED] Customer users ldap
Last edited by SuperDOS on 06 Jul 2015, 16:16, edited 1 time in total.
Re: Customer users ldap
OTRS queries the DB source for all information when you use LDAP.
-
- Moderator
- Posts: 10169
- Joined: 04 May 2010, 18:38
- Znuny Version: 5.0.x
- Location: SouthWest Florida, USA
- Contact:
Re: Customer users ldap
Actually, OTRS queries the sources that are defined. By default, that's DB, but if Customer (authentication) and CustomerUser (demographics) are pointing to a different source (LDAP), then that source "wins". OTRS does not sync customer data to DB.EXG133 wrote:OTRS queries the DB source for all information when you use LDAP.
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
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
Re: Customer users ldap
Of course you're right! I don't know how I ended up with my first reply, it should have been "LDAP source"..
Re: Customer users ldap
Thanks for clarifying, I've added a ldap query to fetch the customer user information and get the ticket information from the DB via a SQL query.