new agent create through database

[kalyana1315]

Hi

how to create new agent through otrs database back-end . we are facing problem password value other this all are updating working fine.


any one help me. OTRS database user table how update though manually.

[reneeb]

You shouldn't work on the database yourself! There's a script in the $OTRS_HOME/bin/ directory that can be used to create agents.

[kalyana1315]

You shouldn't work on the database yourself! There's a script in the $OTRS_HOME/bin/ directory that can be used to create agents.

that one working fine. but we are try update through database. how to storing password in otrs database use table?

[RStraub]

The goal is to create users without using plain text passwords?

[reneeb]

how to storing password in otrs database use table?

Check what algorithm is used to store the passwords (in Kernel/Config.pm or Kernel/Config/Defaults.pm or check the code in Kernel/System/Auth/DB.pm). Then you have to create the password using the same algorithm and set the result in the database...

[jojo]

don't write to the OTRS database. Never

Use the scripts provided.

[RStraub]

At some point you're going to need the password - or you let the user hash it and send you the hash.
From our default (3.3.5) installation without changes to the password hashing, you'd get the proper hash via:
mysql> select sha2('NewPassword',256);

[kalyana1315]

The goal is to create users without using plain text passwords?

The goal is to create users using plain text passwords

[jojo]

as I said, use the provided script. Not a direct database action

[crythias]

The goal is to create users using plain text passwords

bin/otrs.AddUser.pl
otrs.AddUser.pl [-f firstname] [-l lastname] [-p password] [-g groupname]... [-e email] username
if you define -g with a valid group name then the user will be added that group
you can define multiple groups line this: "-g admin -g users"

Code: Select all

bin/otrs.AddUser.pl -f John -l Doe -p MySecr3t -g admin -e john.doe@example.com jdoe

[kalyana1315]

The goal is to create users using plain text passwords

bin/otrs.AddUser.pl
otrs.AddUser.pl [-f firstname] [-l lastname] [-p password] [-g groupname]... [-e email] username
if you define -g with a valid group name then the user will be added that group
you can define multiple groups line this: "-g admin -g users"

Code: Select all

bin/otrs.AddUser.pl -f John -l Doe -p MySecr3t -g admin -e john.doe@example.com jdoe

hi crythias,

otrs.AddUser.pl working fine . we are trying database back end updated all new agent creating that means sql query . facing problem only password value update. table user pw values having encrypted .

how can update pw valuse useing sql query ?

[crythias]

how can update pw valuse useing sql query ?

Read this entire thread again until you understand that your question should not be answerable.

If you require plain text passwords, use your own backend authentication table. You can do whatever you want with that.

[reneeb]

You can use a config option to tell otrs that the passwords are plain text. Then you can do a plain "UPDATE users SET password = ....". But plain text passwords are a #fail. When someone hacks your OTRS he/she can get access to all accounts and you know that many people reuse their passwords for several services...

[jojo]

using a direct database query will always screw up caching

[kalyana1315]

using a direct database query will always screw up caching

any option updating sql query User table pw values default encrypted values.
or
how to do decrypt otrs user table password using sql query

database:

pw.JPG

[kalyana1315]

how can update pw valuse useing sql query ?

Read this entire thread again until you understand that your question should not be answerable.

If you require plain text passwords, use your own backend authentication table. You can do whatever you want with that.

Hi crythias,


we are trying to OTRS user table username and password use some other database(same logins using ) problem facing only pw encrypting . any update regards pw how to decrypt in OTRS and matching username and password.

[crythias]

we are trying to OTRS user table username and password use some other database(same logins using ) problem facing only pw encrypting . any update regards pw how to decrypt in OTRS and matching username and password.

have otrs query your other database for authentication.

[jojo]

you can not decrypt passwords

[kalyana1315]

you can not decrypt passwords

how is storing database values OTRS user table username and password.

front end Add Agent option enter password is plan text but database storing encrypted password.

we are trying finding encrypted code otrs perl program ?

any one know about encrypted update me file name or path.

[jojo]

It seems that you have no understanding on password mechanisms in general. Passwords can not be decrypted. On login 2 hashes will be compared (the saved one, and the one computed with the given password of the user).

Read and understand all answers to the thread carefully.