[SOLVED] Customer users ldap

Moderator: crythias

Post Reply
SuperDOS
Znuny newbie
Posts: 93
Joined: 17 Apr 2012, 16:16
Znuny Version: 6.0.3
Real Name: A!

[SOLVED] Customer users ldap

Post by SuperDOS »

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.
Last edited by SuperDOS on 06 Jul 2015, 16:16, edited 1 time in total.
EXG133
Znuny expert
Posts: 217
Joined: 06 Aug 2012, 18:12
Znuny Version: 3.1.7 & 4.04

Re: Customer users ldap

Post by EXG133 »

OTRS queries the DB source for all information when you use LDAP.
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Customer users ldap

Post by crythias »

EXG133 wrote:OTRS queries the DB source for all information when you use 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.
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
EXG133
Znuny expert
Posts: 217
Joined: 06 Aug 2012, 18:12
Znuny Version: 3.1.7 & 4.04

Re: Customer users ldap

Post by EXG133 »

Of course you're right! I don't know how I ended up with my first reply, it should have been "LDAP source"..
SuperDOS
Znuny newbie
Posts: 93
Joined: 17 Apr 2012, 16:16
Znuny Version: 6.0.3
Real Name: A!

Re: Customer users ldap

Post by SuperDOS »

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.
Post Reply