Openfire Server + Atmail Email server

Openfire Openfire Support
1

Dear Openfire Team and users,

Im trying to setup a user integration betwen atmail database and Openfire database

I read some posts like this http://www.igniterealtime.org/community/message/161843#30551

but after few hours of trying i give it up

When openfire server starts i got the setup screen, he ask for language, database server bla bla bla

I have a backup configuration and when i use it ev its good

Im running Openfire on Debian 4.0

cand be a problem because username its user@domain.com ? from the Atmail database ?

<setup>true</setup>

<jdbcProvider>

<driver>com.mysql.jdbc.Driver</driver>

<connectionString>jdbc:mysql://localhost/atmail?user=root&password=somepas s</connectionString>

</jdbcProvider>

<provider>

<auth>

<className>org.jivesoftware.openfire.auth.JDBCAuthProvider</className&g t;

</auth>

<user>

<className>org.jivesoftware.openfire.user.JDBCUserProvider</className&g t;

</user>

</provider>

<jdbcAuthProvider>

<passwordSQL>SELECT Password FROM UserSession WHERE Account=?</passwordSQL>

<passwordType>md5</passwordType>

</jdbcAuthProvider>

<jdbcUserProvider>

<loadUserSQL>SELECT CONCAT(FirstName,’ ',LastName),OtherEmail FROM Users WHERE Account=?</loadUserSQL>

<userCountSQL>SELECT COUNT(*) FROM Users</userCountSQL>

<allUsersSQL>SELECT Account FROM Users</allUsersSQL>

<searchSQL>SELECT Account FROM Users WHERE</searchSQL>

<usernameField>Account</usernameField>

<nameField>CONCAT(FirstName,’ ',LastName)</nameField>

<emailField>OtherEmail</emailField>

</jdbcUserProvider>

Atmail database its atmail

table Users contain : Account ( wich its the username to login in email service ), OtherEmail , FirstName, LastName and many more

table userSession contain : Account , and Password (using md5 ) , LastLogin etc

Ive checked the mysql query via phpmyadmin and ev its ok with the sintax

Any ideea …

Thank you in advance for your help !!!

Best Regards

2

Hi,

if you store your user as "foo@example.com" in the external database one will likely need to use "foo@example.com" as the username and still “example.com” as the domain name which would result in a JID like "foo@example.com@example.com" while the first “@” would need encoded as \30 or something like this.

You may want to change one account from "foo@example.com" to “foo” and verify that the login works with it.

You could also try an external HSQLDB as it is very easy to setup and change, see http://www.igniterealtime.org/community/thread/30321?start=15.

LG

3

Thank you for support, but is not working, when i restart openfire server , i got the install procedure

http://www.igniterealtime.org/community/message/161843#30551

i have same configuration database like here, same tables same columns

Now im triyng directly to add new users to Openfire database without integration of a new database

Ive opened this thread

http://www.igniterealtime.org/community/thread/31066