Error with Customer Database backend

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
participants (1)
-
kekieres@arsystel.com