[otrs] Login from outside
Hi, I managed to make otrs use the same customer database as my e-commerce site does. I was wondering what would be the best way to make the user logged in otrs once it logs in the e-commerce site. I'm mentioning that i use sites like xyz.co.uk, xyz.de for localization and the otrs is located at support.xyz.com (might be some troubles with cookies). Thanks in advance, Alexandru Palade. begin:vcard fn:Alexandru Palade n:Palade;Alexandru org:ThinkUP Design;Development email;internet:[EMAIL PROTECTED] title:Senior Programmer tel;fax:(+40)234.519.117 tel;cell:(+40)744.792.007 url:http://www.thinkupdesign.ro version:2.1 end:vcard ___ 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/
Re: [otrs] Adding customer backend
Thank you Lars, worked great!
Lars Jørgensen wrote:
> Hi Alexandru.
>
> There's an error in the documentation.
>
> It says
>
> CustomerKey = 'mail',
>
> It should be
>
> CustomerKey => 'mail',
>
> I experienced the same problem as you. Took some time to figure out :-)
>
>
> Lars
>
>
>
> ____
>
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
> Alexandru Palade
> Sent: Monday, February 18, 2008 10:18 PM
> To: otrs@otrs.org
> Subject: [otrs] Adding customer backend
>
>
> Hi,
>
>
> I'm trying to make a simple customer backend. After browsing through
> documentation I modified the Config.pm file to read:
>
>
>
> # CustomerUser
> # (customer user database backend and settings)
> $Self->{CustomerUser} =
> {
> Name => 'Customer Backend',
> Module => 'Kernel::System::CustomerUser::DB',
> Params =>
> {
> # if you want to use an external database, add the
> # required settings
>DSN => 'DBI:Pg:dbname=xxx;host=/var/run/postgresql',
>User => 'xxx',
>Password => 'xxx',
>Table => 'customer',
> },
> # customer uniq id
> CustomerKey = 'mail',
> # customer #
> CustomerID = 'ID',
> #CustomerValid = 'ID',
> CustomerUserListFields => ['firstName', 'middleName',
> 'lastName', 'mail'],
> CustomerUserSearchFields => ['mail', 'lastName', 'firstName',
> 'ID'],
> CustomerUserSearchPrefix => '',
> CustomerUserSearchSuffix => '*',
> CustomerUserSearchListLimit => 250,
> CustomerUserPostMasterSearchFields => ['mail'],
> CustomerUserNameFields => ['firstName', 'middleName',
> 'lastName'],
> CustomerUserEmailUniqCheck => 1,
> ## show now own tickets in customer panel, CompanyTickets
> #CustomerUserExcludePrimaryCustomerID => 0,
> ## generate auto logins
> #AutoLoginCreation => 0,
> #AutoLoginCreationPrefix => 'auto',
> ## admin can change customer preferences
> #AdminSetPreferences => 1,
> ## just a read only source
> #ReadOnly => 1,
> Map => [
> # note: Login, Email and CustomerID needed!
> # var, frontend, storage, shown (1=always,2=lite),
> required, storage-type, http-link, readonly
> #[ 'UserSalutation', 'Salutation', 'salutation', 1, 0,
> 'var', '', 0 ],
> [ 'UserFirstname', 'Firstname', 'firstName', 1, 1,
> 'var', '', 0 ],
> [ 'UserLastname', 'Lastname', 'lastName', 1, 1,
> 'var', '', 0 ],
> [ 'UserLogin', 'Username', 'mail', 1, 1,
> 'var', '', 0 ],
> [ 'UserPassword', 'Password', 'pass', 0, 1,
> 'var', '', 0 ],
> [ 'UserEmail', 'Email', 'mail', 0, 1,
> 'var', '', 0 ],
> #[ 'UserEmail', 'Email', 'email', 1, 1,
> #
> 'var','$Env{"CGIHandle"}?Action=AgentTicketCompose&ResponseID=1&TicketID=$Data{"TicketID"}&ArticleID=$Data{"ArticleID"}',
> 0 ],
> [ 'UserCustomerID', 'CustomerID', 'ID', 0, 1, 'var', '', 0
> ],
> #[ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0,
> 'var', '', 0 ],
> # [ 'UserComment', 'Comment', 'comments',1, 0,
> 'var', '', 0 ],
>
[otrs] Adding customer backend
Hi,
I'm trying to make a simple customer backend. After browsing through
documentation I modified the Config.pm file to read:
# CustomerUser
# (customer user database backend and settings)
$Self->{CustomerUser} =
{
Name => 'Customer Backend',
Module => 'Kernel::System::CustomerUser::DB',
Params =>
{
# if you want to use an external database, add the
# required settings
DSN => 'DBI:Pg:dbname=xxx;host=/var/run/postgresql',
User => 'xxx',
Password => 'xxx',
Table => 'customer',
},
# customer uniq id
CustomerKey = 'mail',
# customer #
CustomerID = 'ID',
#CustomerValid = 'ID',
CustomerUserListFields => ['firstName', 'middleName',
'lastName', 'mail'],
CustomerUserSearchFields => ['mail', 'lastName',
'firstName', 'ID'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['mail'],
CustomerUserNameFields => ['firstName', 'middleName',
'lastName'],
CustomerUserEmailUniqCheck => 1,
# # show now own tickets in customer panel, CompanyTickets
# CustomerUserExcludePrimaryCustomerID => 0,
# # generate auto logins
# AutoLoginCreation => 0,
# AutoLoginCreationPrefix => 'auto',
# # admin can change customer preferences
# AdminSetPreferences => 1,
# # just a read only source
# ReadOnly => 1,
Map => [
# note: Login, Email and CustomerID needed!
# var, frontend, storage, shown (1=always,2=lite),
required, storage-type, http-link, readonly
#[ 'UserSalutation', 'Salutation', 'salutation', 1, 0,
'var', '', 0 ],
[ 'UserFirstname', 'Firstname', 'firstName', 1, 1,
'var', '', 0 ],
[ 'UserLastname', 'Lastname', 'lastName', 1, 1,
'var', '', 0 ],
[ 'UserLogin', 'Username', 'mail', 1, 1,
'var', '', 0 ],
[ 'UserPassword', 'Password', 'pass', 0, 1,
'var', '', 0 ],
[ 'UserEmail', 'Email', 'mail', 0, 1,
'var', '', 0 ],
# [ 'UserEmail', 'Email', 'email', 1, 1,
#
'var','$Env{"CGIHandle"}?Action=""
0 ],
[ 'UserCustomerID', 'CustomerID', 'ID', 0, 1, 'var', '', 0
],
# [ 'UserCustomerIDs', 'CustomerIDs', 'customer_ids', 1, 0,
'var', '', 0 ],
# [ 'UserComment', 'Comment', 'comments', 1, 0,
'var', '', 0 ],
[ 'ValidID', 'Valid', 'ID', 0, 1, 'int', '',
0 ],
]
};
...
The rest of lines before and after this are just the default
configuration.
However, when I try to access the index page i get:
Internal Server Error
The server encountered an internal error or
misconfiguration and was unable to complete
your request.
Please contact the server administrator, [EMAIL PROTECTED] and inform
them of the time the error occurred,
and anything you might have done that may have
caused the error.
More information about this error may be available
in the server error log.
Additionally, a 500 Internal Server Error
error was encountered while trying to use an ErrorDocument to handle
the request.
Any help is appreciated. Thank you in advance,
Alexandru Palade.
begin:vcard
fn:Alexandru Palade
n:Palade;Alexandru
org:ThinkUP Design;Development
email;internet:[EMAIL PROTECTED]
title:Senior Programmer
tel;fax:(+40)234.519.117
tel;cell:(+40)744.792.007
url:http://www.thinkupdesign.ro
version:2.1
end:vcard
___
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/
[otrs] User database
Hi, I would like to integrate OTRS to my e-commerce website and I was wondering if there is any easy way to make OTRS work with my user database. I have browsed the manual but didn't find anything related. Any suggestion would help me a lot. Thanks in advance, Alexandru Palade. begin:vcard fn:Alexandru Palade n:Palade;Alexandru org:ThinkUP Design;Development email;internet:[EMAIL PROTECTED] title:Senior Programmer tel;fax:(+40)234.519.117 tel;cell:(+40)744.792.007 url:http://www.thinkupdesign.ro version:2.1 end:vcard ___ 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/
