Hashing method for encryptedPassword in jiveUser

Openfire Openfire Support
1

looking at the database schema for jiveuser

mysql> describe jiveUser;

*----

*–

+–+-+

+-----+

Field

Type

Null

Key

Default

Extra

*----

*–

+–+-+

+-----+

username

varchar(64)

PRI

password

varchar(32)

YES

NULL

encryptedPassword

varchar(255)

YES

NULL

name

varchar(100)

YES

NULL

email

varchar(100)

YES

NULL

creationDate

varchar(15)

MUL

modificationDate

varchar(15)

*----

*–

+–+-+

+-----+

7 rows in set (0.00 sec)

Can anyone tell me what the format for saving encryptedPassword. It does not look like MD5.

I have created a script that goes out to our call center application and creates users in the database. I want to deploy spark and need the final piece to determine how to has a plain text password as the encrypted one in JIVEuser.

thanks

~ron

2

Hi Ron,

you may want to use the User Service Plugin to create users in the Openfire database.

Openfire also allows you to connect to an external database for user authentication.

If you really want to implement the password encryption within your script you may want to download the Openfire source code and look at the implementation details but I guess that you need more than a simple script to encrypt the passwords. It’'s not a hash like MD5 or SHA but encrypted as Openfire supports digest authentication which requires that Openfire can decrypt it to get the plain text password.

LG