Re: [otrs] Error with Customer Database backend

5 Jun 2007

      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/

Re: [otrs] Error with Customer Database backend

kekieres＠arsystel.com