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.
[EMAIL PROTECTED] 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/
>
_______________________________________________
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/
