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
_______________________________________________
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
Support or consulting for your OTRS system?
=> http://www.otrs.com/