Hi!
I’d like to integrate openfire into an exisiting social community website. The website uses postgresql (8.4 or soon 9.0) as it’s db backend. We’d like to give users the ability to login using their username + password and send messages to each other. All other stuff (adding contacts, etc.) should be done through the website as it is now and should be forbidden by the im client.
So to get started, I installed openfire with postgresql and it’s working good so far. But as soon as I try to rename the ofuser table to ofuser_old and create a view like (create view ofuser select * from ofuser_old) all logins don’t work anymore. So because this simple test fails, I wonder what I’m doing wrong and what’s the best way to integrate it in an existing project/ database?
Thanks,
Corin