Hi all, A little update to my previous mail... The error I get in otrs.log is the following: [Tue Jun 5 17:22:05 2007][Error][Kernel::System::DB::new][172] Can't create a new thread (errno 11); if you are not out of available memory, you can consult the manual for a possible OS-dependent bug The error I showed before is shown to the agent browser:

Can't connect to database! at /opt/otrs/Kernel/System/CustomerUser/DB.pm line 56.

I've doublechecked whether mi OTRS-system can access the MySQL box and there is no problem, it's accesible. Any sugestion? Thanks, Rafa. kekieres@arsystel.com escribió:

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/