[otrs] Customer Authentication againist awbs database

[Gokalp Cakici]

Is there any developer or forum guru caring about this issue ?

Gokalp Cakici

Ahmet YAZICI wrote:
> 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/