Openfire Integration - Instant Messaging Server for your vBulletin Users

[Sebijk]

A very easy and simple add-on.

This add-on registrate vBulletin registrations automatically to the Openfire Server. So you can own a Instant Messaging Server (based on Jabber) for your vBulletin Users. The solution here is realized with the User Service Plugin for Openfire . But there are many other Integrate solutions with Openfire. Openfire supports the LDAP authentication, too.

The only problem of this integration solution: Existing vBulletin users must manually registering to the Openfire server, but a import script is included

Requirements:
vBulletin 3.7 (3.6 and 3.5 are not tested)
Openfire (http://www.igniterealtime.org/projects/openfire/index.jsp)
User Service plugin for Openfire (http://www.igniterealtime.org/projects/openfire/plugins/userservice.jar)

Recommend Products: Enhanced Jabber-Integration (https://vborg.vbsupport.ru/showthread.php?t=179114)

Examples and Screenshots: https://vborg.vbsupport.ru/showpost.php?p=1626636&postcount=4

Version History:


1.0.0 Beta 3
* fopen is no longer required
* Import script included
* A install instruction included

1.0.0 Beta 2
* Fix a important Bug with Password registration

1.0.0 Beta 1
* First Version


IMPORTANT FOR IMPORT EXISTING USERS TO OPENFIRE, IF YOUR USING THE IMPORT SCRIPT: It is recommended to make a backup of Openfire database and vBulletin database. This Import script has tested only with a low number of users. If anybody will improve the import script, you can make this :). If you want to test in "local" area, please comment out the line with "vbmail".

Use the import script with your own risk

If you get timouts of the import process, make sure safe_mode is temporary disabled and set max_execution_time temporary to 50000.

After import, reset the php settings.

If you need my help for the import process, donate 30 EUR / $45 and send me a email with
your FTP and MySQL Account-Details. Create a vBulletin Adminaccount for me.
I will make then the import process.

[GoTTi]

so what does this do??? it doesnt use the vb user tables so the users need to register on a seperate site in order to be linked up using a messenger client?

im not understanding this. do u have a demo site or some screen shots for us?

[Sebijk]

Hello,

Openfire use the own table, not the vBulletin User Table. You can use a Jabber Client or the offical Openfire Clients Spark (http://www.igniterealtime.org/projects/spark/index.jsp) (Program) and SparkWeb (http://www.igniterealtime.org/projects/sparkweb/index.jsp) (Webclient). I can make some screenshots for this.

[Sebijk]

So, some examples:

1. I register at a normal vBulletin Forum with this Add-on:

87118

Now I get a verify email for my vBulletin Account. After I'm verify my vBulletin Account, the Forum send my Registration Data to the Openfire Server (without the vBulletin Password).

I get a seperat email with my Openfire Account details with a seperat Password:

87119

Now I'm registered at my Forum and my Openfire Server.


Example with meebo:

I going to meebo.com and click more networks. Under Jabber I give my Openfire Account details:

87120

So Im Log In to Meebo and add a Google Talk User:

87121

I have make a dirty @ on the Screenshots because I dont like spambots.

More examples cooming soon.

[Alfa1]

More examples cooming soon.
That would be great. Please explain more.

[ShawneyJ]

ok so we download
"openfire_3_6_0a.tar.gz Works on most Unix variants, no Java JRE"
and install to our forum server?? atm i can find a install folder...
we register where to get a Secret Key?
where does "User Service plugin for Openfire" go?
no offense but there is some instructions needed here or have i missed something?
sorry i have never heard about Openfire till this thread so im new to this one.
mmmm maybe i wait as its in beta stage or maybe i just move on and forget it as it
Not Supported.

[Sebijk]

Hello,

Go to Server Settings -> User Service. Here you can create a secret key. The Openfire Settings are located in https://example.com:9091.

The Install Instructions for Openfire: http://www.igniterealtime.org/builds/openfire/docs/latest/documentation/install-guide.html

[Alfa1]

The only problem of this integration solution: Existing vBulletin users must manually registering to the Openfire server.
Do you have a solution for this?

[Sebijk]

I can only make a import script to import the existing vBulletin Users to the Openfire user table (with User Service Plugin, because Openfire use a another Password encryption) and the vBulletin Passwords cannot imported.

[Alfa1]

Would LDAP authentication make it possible to have integration, without the need for members to register with the Openfire server.

[Sebijk]

Yes, the LDAP Authentication is better. Here a LDAP Modification for vBulletin: https://vborg.vbsupport.ru/showthread.php?t=145188

But I don't know much about LDAP, so I can't help you with this.

[Alfa1]

Yes, I know the LDAP mod, but I would only be able to implement it for Jabber integration, if I would have a step by step manual that I could follow. I am not knowledgeable about LDAP at all.

[Sebijk]

IMPORTANT: It is recommended to make a backup of Openfire database and vBulletin database. This Import script has tested only with a low number of users. If anybody will improve the import script, you can make this :). If you want to test in "local" area, please comment out the line with "vbmail".

Use the script with your own risk

After import, the users get a email with the Jabber Account Details.

Place the file in your vBulletin Root Directory.

[abrecher]

Interesting mod, I wish someone would come up with a "total solution" for VB Instant messaging between members already.

[Sebijk]

New Version 1.0.3 is out. fopen is no longer required :).

[kleinschwanz]

has anyone tested the converter script on a larger group of members already and how did it work out?

[Sebijk]

The import scripts read all vb users, send the username and email to the Openfire Server, generate a new password for Openfire users and the user get a email with the Openfire Account Details.

Before you run the import script, make sure you have first the openfire integration product installed and configured the openfire integration settings.

[Neo_obs]

Question... How can I fix it so that
A) it only sends emails out to those who said yes to admin emails. I believe I fixed this by adding where query to the options field
B) Stores their temp password in plaintext in the database and I have successfully figured this out.
C) fixes the spaces, characters issue by adding periods instead? It turns out it needs to replace all the "%" in the htmlspecialcharacters into "/" Or can you figure out a way that spaces are changed into periods?

[ZeroHour]

BTW one thing to note, this will expose your members email addresses to all who connect to your jabber server by default in its current form. Certain clients can pull this information.

[Sebijk]

C) fixes the spaces, characters issue by adding periods instead? It turns out it needs to replace all the "%" in the htmlspecialcharacters into "/" Or can you figure out a way that spaces are changed into periods?

Do you mean this?

$variable = ereg_replace("%", "/", $variable);

[Alfa1]

BTW one thing to note, this will expose your members email addresses to all who connect to your jabber server by default in its current form. Certain clients can pull this information.
That is a very unwanted problem. Sebijk; do you have any idea how to fix this?

[edermix]

Forum example??

[Neo_obs]

BTW one thing to note, this will expose your members email addresses to all who connect to your jabber server by default in its current form. Certain clients can pull this information.

It doesn't for me. I have made it so you can't search people by email. I did this by going under server settings -> Search Service Properties -> and unchecked email as a searchable field

[ZeroHour]

It doesn't for me. I have made it so you can't search people by email. I did this by going under server settings -> Search Service Properties -> and unchecked email as a searchable field

Our tester was using Kopete and they could search for a username and the email address would be returned along with the results. Changing the server setting did not prevent the email being returned for a username search.

[Sebijk]

Our tester was using Kopete and they could search for a username and the email address would be returned along with the results. Changing the server setting did not prevent the email being returned for a username search.

This is a problem with the Search Service Plugin from Openfire. It searchs only Name, JID and E-Mail Address, that cannot changed by User. And it can show all members by searching with *. I recommend to disable or delete this. Im looking for a Alternative.

If you want use the search service Plugin and you will not visible Member E-Mail Address, change in Plugin the line:

$sendjabber_register = file_get_contents("https://".$vbulletin->options['openfire_host'].":9091/plugins/userService/userservice?type=add&secret=".$vbulletin->options['openfire_secretkey']."&username=".utf8_encode(rawurlencode($userinfo['username']))."&password=".utf8_encode(rawurlencode($openfire_password))."&email=".utf8_encode(rawurlencode($userinfo['email'])));

to: $sendjabber_register = file_get_contents("https://".$vbulletin->options['openfire_host'].":9091/plugins/userService/userservice?type=add&secret=".$vbulletin->options['openfire_secretkey']."&username=".utf8_encode(rawurlencode($userinfo['username']))."&password=".utf8_encode(rawurlencode($openfire_password)));

But you cannot after use some Plugins, that a E-Mail Address is required, example the Pass Service Plugin, that recover the password, if a Jabber User forget the password.

Forum example??

http://www.simsforum.de/vbulletin/

[ZeroHour]

Interesting, that may cure the part that imports the email address but users should note that notifications stating account details for the chat server wont work (just a fyi for them)
The search plugin I think is not the only possible way. I believe that if you view the profile of a user you may be able to see it too.

[Sebijk]

Or use this Plugin: http://www.igniterealtime.org/community/docs/DOC-1170. That update the Openfire User List for the Search Plugin, if the User has changed the Jabber Profile (vCard).

[luxmail]

Great hack, installed, any ideea how to check if the user is allready in Openfire DB, because i have a openfire db who works also with an email service

[Sebijk]

Great hack, installed, any ideea how to check if the user is allready in Openfire DB, because i have a openfire db who works also with an email service

If a User is already in Openfire DB, the imported user (or the new forum member) will be skipped. But the problem is, the not imported User receive a email with invalid Openfire Account Details. The user can ignore this mail.

[mmoore5553]

so anyone actually using this mod ? can they tlel us now it is working and the email actually displayed ?

[Alfa1]

Sebijk, do you have any idea about my question above?
And is it possible to use openfire, while hiding the email addresses of the member base?

[Sebijk]

<a href="https://vborg.vbsupport.ru/showpost.php?p=1650560&postcount=25" target="_blank">https://vborg.vbsupport.ru/showp...0&postcount=25</a>

And I didn't found a Alternative Search Plugin for Openfire yet.

[ZeroHour]

Right I am thinking I will post my recompiled version of openfire that fixes this issue with emails and sign ups. I will see what I can do and I will make a new addon (as my way is a lot different and does more tbh)

[Sebijk]

Right I am thinking I will post my recompiled version of openfire that fixes this issue with emails and sign ups. I will see what I can do and I will make a new addon (as my way is a lot different and does more tbh)

Any new news of your Openfire Version?

[kenzacm]

im using vBulletin with joomla integrated using JFusion.

joomla creates the VB account when someone signs up to mecial.

would this mod still work?

[Sebijk]

Possibility it wouldn't work. It needs a custom mod for this.

[jklimczak]

will this work on vb4

[Sebijk]

not tested, but i think yes, because the mod requires no template edits (or adds new templates).

[irtehun]

Is it possible to have a version of this plugin for Vbulletin 4.0?

[sasank]

Is it possible to have a version of this plugin for Vbulletin 4.0?

i would like to know the same

[Sebijk]

see my message, i think it should work on vB 4.0.

[naisho]

Installed on version 4.2.0 PL3 and works perfectly. Thank you!

The conversion tool is very handy to populate openfire database with existing vbulletin members. I adapted it to suit my needs (modifying the query) as I didn't want to create openfire account for all members.

The openfire user service plugin can now handle groups as well, so that when you automatically add members, you can assign them to openfire existing groups.

http://www.igniterealtime.org/projects/openfire/plugins/userservice/readme.html