Hi Nil,
i am so glad to you that i found it works for me.
Thanks a lot nil...
-Ekram
On 11/01/2010 10:36 PM, Nils Leideck - ITSM wrote:
Hi Ekram,
as said, if the password for an user is empty the user cannot login,
so it is not a security issue for you.
However, to make the password field a mandatory field you need to
*copy* the “CustomerUser” configuration from Kernel/Config/Default.pm
to your Kernel/Config.pm file.
Within the “Map” configuration you can define if a field is mandatory
or if not. This does not change the table of course, but is telling
OTRS to check if the field should have a value before sending the
statement to the database.
On 01.11.2010, at 17:30, Ekram wrote:
but the problem is i gave password. But still shows the same error.
Even i dont want to allow null value since null password in unacceptable.
How can i make the customer user passowrd filed mentadory field , i
mean not optional.
-Ekram
On 11/01/2010 10:24 PM, Nils Leideck - ITSM wrote:
Hi Ekram,
it seems your database table customer_user has been created with
“NOT NULL” for the “pw” column.
In the default OTRS setup, a password is an optional field. If there
is no password given, the user can simply not login.
Please double check your table configuration and change the pw
column to allow NULL values.
On 01.11.2010, at 17:11, Ekram wrote:
I'am having a problem when try to create customer user from admin
panel.
It giving error the following error:
*[Error][Kernel::System::CustomerUser::DB::CustomerUserAdd][Line:601]:
ERROR: null value in column "pw" violates not-null constraint,
SQL: 'INSERT INTO customer_user
*
I found in the customer user creation panel that password in not
taking from the filed.
Please check the attachment. It will clear you.
Is there any customer user configuration needed?
My installation is straight forward using postgres and otrs version
2.4.7
Cheers, Nils
Cheers, Nils
—
Nils Leideck
Senior Consultant
http://webint.cryptonode.de / a Fractal project
---------------------------------------------------------------------
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
