Hi all,
I've configured in Kernel/Config.pm to have a Customer database backend
(in my case it will be a MySQL in a different server).
Here you have the related lines (only not comented lines):
$Self->{CustomerUser} = {
Name => 'Database Backend',
Module => 'Kernel::System::CustomerUser::DB',
Params => {
# if you want to use an external database, add the
# required settings
DSN => 'DBI:mysql:database=XXXXX;host=X.X.X.X',
User => 'db_user',
Password => 'db_user_passwd',
Table => 'users_table',
},
# customer uniq id
CustomerKey => 'username',
# customer #
CustomerID => 'email',
# CustomerValid => 'id', #don't have an equivalent in my DB
CustomerUserListFields => ['name','email'],
CustomerUserSearchFields => ['username', 'name', 'email'],
CustomerUserSearchPrefix => '',
CustomerUserSearchSuffix => '*',
CustomerUserSearchListLimit => 250,
CustomerUserPostMasterSearchFields => ['email'],
CustomerUserNameFields => ['name'],
CustomerUserEmailUniqCheck => 1,
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', 'first_name', 1, 1, 'var',
'', 0 ],
[ 'UserLastname', 'Lastname', 'name', 1, 1,
'var', '', 1 ],
[ 'UserLogin', 'Username', 'username', 1, 1,
'var', '', 1 ],
[ 'UserPassword', 'Password', 'password', 0, 0,
'var', '', 1 ],
[ 'UserEmail', 'Email', 'email', 0, 1,
'var', '', 1 ],
[ 'UserPhone', 'Phone', 'telefono', 1, 1,
'var', '', 1 ],
[ 'UserCustomerID', 'CustomerID', 'email', 0, 1, 'var', '', 1 ],
],
# default selections
Selections => {
# UserSalutation => {
# 'Mr.' => 'Mr.',
# 'Mrs.' => 'Mrs.',
# },
},
};
The point is that it has been working for sometime (a couple of days) and
now I get this error in logfile otrs.log:
[error] Can't connect to database! at
/opt/otrs/Kernel/System/CustomerUser/DB.pm line 56.
Does anybody has had some similar problem?
Thanks in advance,
Rafa
_______________________________________________
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/
