Hi all,

I’m encountering the following issue when I try to connect to the agent interface on otrs :

 - « Panic, user authenticated but no user data can be found in OTRS DB!! Perhaps the user is invalid. »

System is running under debian lenny

OTRS is version 2.4.7

I use Mysql connection

Connection to customer interface is working properly and all data are synced as well.

My config.pm on agent auth is set as follow, I checked from otrs doc and mails from lists.otrs.org but…

#----------------------------------- # Active directory Config

#-- # Active directory declaration

#-----------------------------------

$Self->{'AuthModule'} = 'Kernel::System::Auth::LDAP';

$Self->{'AuthModule::LDAP::Host'} = 'dc.domaine.net';

$Self->{'AuthModule::LDAP::BaseDN'} = 'DC=domaine,DC=net';

$Self->{'AuthModule::LDAP::UID'} = 'sAMAccountName';

#-- #Agent LDAP search account

#------------------------------

$Self->{'AuthModule::LDAP::SearchUserDN'} = 'CN=otrs account,OU=Service Accounts,DC=INCO,DC=NET';

$Self->{'AuthModule::LDAP::SearchUserPw'} = 'password';

    # AuthSyncModule::LDAP::UserSyncMap

    # (map if agent should create/synced from LDAP to DB after successful login)

    $Self->{'AuthSyncModule::LDAP::UserSyncMap'} = {

        # DB -> LDAP

        UserFirstname => 'givenName',

        UserLastname  => 'sn',

        UserEmail     => 'mail',

    };

    # AuthSyncModule::LDAP::UserSyncInitialGroups

    # (sync following group with rw permission after initial create of first agent

    # login)

    $Self->{'AuthSyncModule::LDAP::UserSyncInitialGroups'} = [

        'users',

    ];

When I look at the user.log file, I have an error regarding a table which doesn’t look to exist ?!

Mar 10 05:59:58 neagnet01 OTRS-CGI-10[1026]: [Notice][Kernel::System::Auth::LDAP::Auth] User: jmricciarelli (CN=Ricciarelli\, Jean-Marie (Noumea),OU=Noumea,OU=Users,OU=Goro Operations,DC=INCO,DC=NET) authentication ok (REMOTE_ADDR: 10.xx.xxx.xx).

Mar 10 05:59:58 neagnet01 OTRS-CGI-10[1026]: [Error][Kernel::System::User::UserLookup][Line:680]: Table 'otrs.system_user' doesn't exist, SQL: 'SELECT id FROM system_user  WHERE LOWER(login) = ?'

Mar 10 05:59:58 neagnet01 OTRS-CGI-10[1026]: [Error][Kernel::System::User::UserLookup][Line:680]: Table 'otrs.system_user' doesn't exist, SQL: 'SELECT id FROM system_user  WHERE LOWER(login) = ?'

Mar 10 05:59:58 neagnet01 OTRS-CGI-10[1026]: [Error][Kernel::System::User::GetUserData][Line:172]: Table 'otrs.system_user' doesn't exist, SQL: 'SELECT id, login,  salutation, first_name, last_name, pw, valid_id  FROM system_user WHERE  LOWER(login) = ?'

So, I’m kind of desperated as I do not know what I can do and actually where to look in order to get a solution to my problem…

If you have any idea, please let me know, I will try any idea in order to solve this problem.

For information, I have another OTRS system running perfectly in version 2.2.3 with same type of configuration…

Kind Regards,

___________________________________________
Jm Ricciarelli.
Support IT - Vale Inco NC
(: 00 (687) (23) 5036
*: jean-marie.ricciarelli@valeinco.com