Customer Authentication againist awbs database
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
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/
participants (2)
-
Ahmet YAZICI -
Gokalp Cakici