Adding more fields to the table users / user_preferences with an LDAP integration

older
Agents logged in to OTRS Dashboard

Olivier Macchioni

23 Sep 2013 23 Sep '13

3:18 p.m.

Hello dear list, I'm using an LDAP integration for the AuthSyncModule For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP. I tried adding it to AuthSyncModule::LDAP::UserSyncMap: $Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', }; But this field is not synchronized (I somehow expected it to show up in user_preferences). What's the recommended way to do this? Thanks, Olivier

Show replies by date

Gerald Young

23 Sep 23 Sep

3:33 p.m.

New subject: Adding more fields to the table users / user_preferences with an LDAP integration

AuthSync doesn't handle additional fields. On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...

Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Olivier Macchioni

1 Oct 1 Oct

9:18 a.m.

Thank you Gerald, For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP -> DB. Olivier On Sep 23, 2013, at 17:33, Gerald Young wrote:

...

AuthSync doesn't handle additional fields.

On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni wrote: Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Bogdan Iosif

9:21 a.m.

New subject: Adding more fields to the table users / user_preferences with an LDAP integration

Hi, If you want, please share it. Thanks, Bogdan On Tue, Oct 1, 2013 at 12:18 PM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...

Thank you Gerald,

For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP -> DB.

Olivier

On Sep 23, 2013, at 17:33, Gerald Young wrote:

AuthSync doesn't handle additional fields.

On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Gerald Young

12:05 p.m.

New subject: Adding more fields to the table users / user_preferences with an LDAP integration

http://forums.otterhub.org/viewtopic.php?f=60&t=19936 On Tue, Oct 1, 2013 at 5:21 AM, Bogdan Iosif wrote:

...

Hi,

If you want, please share it.

Thanks, Bogdan

On Tue, Oct 1, 2013 at 12:18 PM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Thank you Gerald,

For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP -> DB.

Olivier

On Sep 23, 2013, at 17:33, Gerald Young wrote:

AuthSync doesn't handle additional fields.

On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Bogdan Iosif

12:15 p.m.

New subject: Adding more fields to the table users / user_preferences with an LDAP integration

Thanks but I meant the "simple Perl script to do this synchronization LDAP -> DB" On Tue, Oct 1, 2013 at 3:05 PM, Gerald Young wrote:

...

http://forums.otterhub.org/viewtopic.php?f=60&t=19936

On Tue, Oct 1, 2013 at 5:21 AM, Bogdan Iosif wrote:

...
Hi,

If you want, please share it.

Thanks, Bogdan

On Tue, Oct 1, 2013 at 12:18 PM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Thank you Gerald,

For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP -> DB.

Olivier

On Sep 23, 2013, at 17:33, Gerald Young wrote:

AuthSync doesn't handle additional fields.

On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Gerald Young

12:27 p.m.

New subject: Adding more fields to the table users / user_preferences with an LDAP integration

There's a sample in scripts/tools/sync-ldap2db.pl On Tue, Oct 1, 2013 at 8:15 AM, Bogdan Iosif wrote:

...

Thanks but I meant the "simple Perl script to do this synchronization LDAP -> DB"

On Tue, Oct 1, 2013 at 3:05 PM, Gerald Young wrote:

...
http://forums.otterhub.org/viewtopic.php?f=60&t=19936

On Tue, Oct 1, 2013 at 5:21 AM, Bogdan Iosif wrote:

...
Hi,

If you want, please share it.

Thanks, Bogdan

On Tue, Oct 1, 2013 at 12:18 PM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Thank you Gerald,

For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP -> DB.

Olivier

On Sep 23, 2013, at 17:33, Gerald Young wrote:

AuthSync doesn't handle additional fields.

On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

Bogdan Iosif

12:39 p.m.

New subject: Adding more fields to the table users / user_preferences with an LDAP integration

Good to know. Thanks. On Tue, Oct 1, 2013 at 3:27 PM, Gerald Young wrote:

...

There's a sample in scripts/tools/sync-ldap2db.pl

On Tue, Oct 1, 2013 at 8:15 AM, Bogdan Iosif wrote:

...
Thanks but I meant the "simple Perl script to do this synchronization LDAP -> DB"

On Tue, Oct 1, 2013 at 3:05 PM, Gerald Young wrote:

...
http://forums.otterhub.org/viewtopic.php?f=60&t=19936

On Tue, Oct 1, 2013 at 5:21 AM, Bogdan Iosif wrote:

...
Hi,

If you want, please share it.

Thanks, Bogdan

On Tue, Oct 1, 2013 at 12:18 PM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Thank you Gerald,

For what it's worth, I've implemented a simple Perl script to do this synchronization LDAP -> DB.

Olivier

On Sep 23, 2013, at 17:33, Gerald Young wrote:

AuthSync doesn't handle additional fields.

On Mon, Sep 23, 2013 at 11:18 AM, Olivier Macchioni < olivier.macchioni@wingo.ch> wrote:

...
Hello dear list,

I'm using an LDAP integration for the AuthSyncModule

For reporting reasons, I'd like to add one more information in OTRS - the Agent's "departmentNumber", which is of course stored in LDAP.

I tried adding it to AuthSyncModule::LDAP::UserSyncMap:

$Self->{'AuthSyncModule::LDAP::UserSyncMap'} = { # DB -> LDAP UserFirstname => 'givenName', UserLastname => 'sn', UserEmail => 'mail', UserGroup => 'departmentNumber', };

But this field is not synchronized (I somehow expected it to show up in user_preferences).

What's the recommended way to do this?

Thanks,

Olivier --------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs

4308

Age (days ago)

4316

Last active (days ago)

List overview

Download

7 comments

3 participants

participants (3)

Bogdan Iosif
Gerald Young
Olivier Macchioni