1

Topic: iRedMail and Openfire

Based on https://www.murat.ws/openfire-iredmail-yapilandirmasi/, we are able to integrate iRedMail 0.97 to openfire 4.0.3. I know the document is in Turkish but focus on the script statements and SQL commands. Replace jdbcProvider.connectionString', 'jdbc:mysql://localhost:3306/vmail?user=kullanici&password=sifreniz' - with iRedMail.tips vmail and the password.

The trick is once you moved the authentication to vmail database, create an account admin@example.com with the proper password. With that then you can login to http://www.example.com:9090 and login with the credential admin (stored in vmail). Although credential stored in vmail is admin@example.com, the last line in the above documentation is jdbcUserProvider.usernameField', 'local_part' - so it would take the local_part which is admin and allow you to login.

But we are having problems to do openfire 4.2.1, we are trying, but let see what we can get in the next few days.

Related to this is the possibility of using iRedMail Pro REST API to do development work. Openfire has a very nice web admin interface as compare to Prosdy-0.10. By doing the authentication through custom database (vmail), we will lose a lot of useful information such as session, transaction info, we are new to REST API, just wonder that is a good idea to develop application to work with openfire.

For those who are in need of adding XMPP with iRedMail, Zhang had actually helped me in doing it. We are testing it now

----

Spider Email Archiver: On-Premises, lightweight email archiving software developed by iRedMail team. Supports Amazon S3 compatible storage and custom branding.

2

Re: iRedMail and Openfire

I am running on Ubuntu 14.04, mysql 5.5, apache 2.4, openfire 4.0.3, java version 8

3

Re: iRedMail and Openfire

tchangth wrote:

Although credential stored in vmail is admin@example.com, the last line in the above documentation is jdbcUserProvider.usernameField', 'local_part' - so it would take the local_part which is admin and allow you to login.

SQL column "mailbox.local_part" will be removed in upcoming iRedMail release, please don't use it. If you really need username part of the email address, use SQL function like 'SUBSTRING_INDEX()' instead.

If you can show us the user authentication related settings in OpenFire, it will be easier for us to give you some hints.