So i installed the latest version of openfire and everything seems to have worked fine. I now need to integrate openfire with my current database of users.
If have a client table and a client details table 1-1 relationship.
The problem i’m having is firstly i cannot log into administrator account anymore.
I add this like documentation says
…
joe, jane
but when i try to log into console on port 9090, it converts that to simply
not sure why it disappears. also i am not sure if it actually is connecting to my database as my logs are showing nothing in the logs directory.
Can anyone help please !
<?xml version="1.0" encoding="UTF-8"?>
myadminuser
9090
9091
en
<!-- Network settings. By default, Openfire will bind to all network interfaces.
Alternatively, you can specify a specific network interfaces that the server
will listen on. For example, 127.0.0.1. This setting is generally only useful
on multi-homed servers. -->
<!--
–>
org.jivesoftware.openfire.auth.JDBCAuthProvider
org.jivesoftware.openfire.user.JDBCUserProvider
com.mysql.jdbc.Driver
[mysqljdbcurl/I[schema]?user=user&password=password
SELECT password FROM order.client WHERE username=?
plain
select c.username, cd.email from order.client c, order.client_details cd where c.username=?
SELECT COUNT(*) FROM order.client
SELECT username FROM order.client
select c.username, cd.email from order.client c, order.client_details cd where
c.username
cd.client_name
cd.email
org.jivesoftware.database.DefaultConnectionProvider
com.mysql.jdbc.Driver
[mysqlurl]openfireschema
username
password
select 1
true
true
5
25
1.0
true