I’m new to openfire. and want to write a webbase users registration page for openfire. I don’t know java and want to write a simple webbase user registration in php (which I’m comfortable with) that can be integrated with our other staffs in our company.
I’ve read that we can add users directly to the database somewher in forum. When I tried to add a row in ofUser table, the new user didn’t showed up in admin page and the client could not login with the new user. Ive search a little bit, but could not find anything.
sorry for disturbing you. But I found where the problem is. the now() function return a string with the format like this, “2009-10-20 09:0” , but the strangly the time is a string with format like this: 001256015562778. So I change the query and that works.
I have a dbout regaring this, actually in the ofUser table the encryptedPassword field has been in ecrypted format, which encryption are u using to attain this?
In the query you have given it just passes a null field.
can you still tell me what is the encryption algorithm used in ofUser table for encrypted password and is there any way I can break it I need to with my other applications
The password in my sql query is unencrypted. If you set the user.usePlainPassword to true. You can force openfire to not use encryption for password. OP will work with mix database too. So if you have some passwords encrypted and others unencrypted, OP will work without any problem.The problem with that plug-in is that you can’t authenticate users against it, So it is not working for me. I’ve aslo open another thread for this but no one have answered to till now.
The encryption algorithem is blowfish. OP uses a key to generate a random seed, with that seed it generates the encrypted password. This is why if same password is used twice, you get two different encrypted string. they also add the seeds to the encrypted string, to be able to dycrypt it. But I could not find out how the seed is added to the string to be able to dycrypt it.