I have succesfully installed a standalone installation of Openfire using mysql backend on a windows 2003 server, and have tested successfully the use of Spark with a couple of accounts. Even the gateway functionality to MSN and othe existing clients works fine. My challenge is to integrate user accounts with an existing CMS system (e107)
I have had a look at the very basic documentation that hasn’t helped me to attempt using the existing e107 user/password database with Openfire!
Openfire database schema (native) is on a database called openfire (logically!)
My CMS user database is in a database called thepilotclub on the same mysql server
user names and passwords are stored in a table called e107_user on DB thepilotclub (fields are user_loginname and user_password respectively)
Could someone please provide me with a template openfire.xml to use this alternative user management and authentication schema? I simply tried lots of variations and could never get it to work! Do I have to define another database connection? My existing openfire.xml has a database profile section titled <defaultprovider> yet the documentation indicates that I should be using <provider>! Do I need both a <defaultprovider> and a <provider> section.
Apologies if my request is not intuitive! I have over 650 users in the existing CMS system, and I’d love nothing more than to be able allow my users to use Openfire with their usernames and passwords from the existing system - and not ask them to create yet another account and password combination just for the IM system
Thanks very much in advance for any guidance and tips or template openfire.xml’s that you share!
Longwood, FL, USA