
Hello, I'm trying to integrate otrs with awbs (www.awbs.com ) customer database. I've manually edited Kernel/Config.pm and added following lines $Self->{'Customer::AuthModule'} = 'Kernel::System::CustomerAuth::DB'; $Self->{'Customer::AuthModule::DB::Table'} = 'users'; $Self->{'Customer::AuthModule::DB::CustomerKey'} = 'username'; $Self->{'Customer::AuthModule::DB::CustomerPassword'} = 'password'; $Self->{'Customer::AuthModule::DB::CryptType'} = 'plain'; $Self->{'Customer::AuthModule::DB::DSN'} = "DBI:mysql:database=awbs;host=10.0.0.2"; $Self->{'Customer::AuthModule::DB::User'} = "root"; $Self->{'Customer::AuthModule::DB::Password'} = "mypass"; and when i try to call customer.pl otrs says "Got no MainObject! at /opt/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 84." If I copy users table to otrs db and then disable DNS,User,Password (last 3 lines of my code) it works but when i try to login /var/log/messages says Jul 26 16:50:35 manager OTRS-CGI-10[24107]: [Notice][Kernel::System::CustomerAuth::DB::Auth] CustomerUser: sysmaster authentification ok (REMOTE_ADDR: 88.250.85.216). Jul 26 16:50:35 manager OTRS-CGI-10[24107]: [Error][Kernel::System::CustomerUser::DB::CustomerUserDataGet][Line:275]: Unknown column 'username' in 'field list', SQL: 'SELECT salutation, first_name, last_name, login, pw, email, customer_id, comments, valid_id, username FROM customer_user WHERE LOWER(username) = LOWER('sysmaster')' Jul 26 16:50:35 manager OTRS-CGI-10[24107]: [Error][Kernel::System::CustomerUser::DB::CustomerUserDataGet][Line:275]: Unknown column 'username' in 'field list', SQL: 'SELECT salutation, first_name, last_name, login, pw, email, customer_id, comments, valid_id, username FROM customer_user WHERE LOWER(username) = LOWER('sysmaster')' How can i solve these problems? Thanks