I've seen that customer_preferences has been fullfilled at the first "prova" login it seems...
otherwise, in that table are stored (as the name suggests) preferences for the customer. Having not modified nothing on prova, records for him are:

| prova            | UserLoginFailed       | 0                 |
| prova            | UserShowTickets       | 25                |
| prova            | UserRefreshTime       |                   |
| prova            | UserLanguage          | en                |
| prova            | UserShowClosedTickets | 1                 |
| prova            | UserTheme             | Standard          |
| prova            | UserToken             | CISmoxkPZzkpvb7   |
| prova            | UserAuthBackend       |                   |
| prova            | UserLastLogin         | 1267008164        |


On Wed, Feb 24, 2010 at 2:40 PM, Alessandro Cortiana <alessandro.cortiana@inetworking.it> wrote:
ciao Marco,

> The problem with a trial that I made is with the password of the user
> created... (could be solved with the Lost your password? from the
> customer.pl ?)

In my environment there is no password problem.
I can temporarily set a default password and I can instruct the customer to change
the password on first login.

> insert into customer_user
> (login,email,customer_id,first_name,last_name,valid_id,create_time,create_by,change_time,change_by)
> values ('prova', 'prova@prova.it', 'prova', 'p', 'p', 1, sysdate(), 1,
> sysdate(), 1)

I did a test to try to understand what database modifications are made when I
add a customer user.
I found modifications in two tables:
customer_users -> one row
customer_preferences -> many rows

Doing an insert like you propose is enough?
Or I also have to insert entries on the customer_preferences table?

Thanks,
Alessandro Cortiana
---------------------------------------------------------------------
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

NEW! ENTERPRISE SUBSCRIPTION - Get more information NOW!
http://www.otrs.com/en/support/enterprise-subscription/