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
*: [email protected]
---------------------------------------------------------------------
OTRS mailing list: itsm - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/itsm
To unsubscribe: http://lists.otrs.org/mailman/listinfo/itsm
NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/
