OpenFire using the Custom user table

OpenFire using custom user tables-Nomousewch's column-Blog channel-csdn.net

In recent projects using OpenFire server to implement message push function, if you use the OpenFire comes with the user table, need to maintain two user tables, not very convenient, if OpenFire can directly use the existing System User table is more convenient, In fact OpenFire has taken this into account for us, and we just need to do some configuration.

• Principle

Research the source of the next openfire, found that the key to achieve this point is the application of data provider, in short, it is necessary in the program to use persistent data (such as user name, department name, which can be stored in the database, can also be stored in the XML file or LDAP directory service, a provider as a unified interface to obtain data, for different data sources (can be different tables of the database, but also can be NoSQL, XML and other data sources) corresponding implementation, such as the Authprovider interface (responsible for user authentication), it has two different implementations Defaultauthprovider and Jdbcauthprovider
, the former is the default OpenFire table, while the latter is based on our custom data table, we configure the default Defaultauthprovider to Jdbcauthprovider, and add some configuration text, you can switch the data source.

• Specific configuration

Go to OpenFire Management Console-server-Service Manager-System Properties

Add the following key-value pairs, or update the data table directly in the database

[SQL]View Plaincopyprint?

2. --Set the JDBC Connection mode
4. Insert  into Ofproperty (NAME, PropValue)
6. Values (' jdbcprovider.connectionstring ',
10. ' JDBC:ORACLE:THIN:@10.35.246.178:1521:ORCL ');
12. Insert  into Ofproperty (NAME, PropValue)
14. Values (' Jdbcprovider.driver ', ' Oracle.jdbc.driver.OracleDriver ');
18. --Set Administrator account
20. Insert  into Ofproperty (NAME, PropValue)
22. Values (' Admin.authorizedjids ', ' [email protected] ');
26. --Custom user authentication
28. Insert  into Ofproperty (NAME, PropValue)
30. Values (' Jdbcauthprovider.useconnectionprovider ', ' true ');
32. Insert  into Ofproperty (NAME, PropValue)
34. Values (' Jdbcauthprovider.passwordsql ', ' select ''123456 'as pwd from
38. T_sys_user T where t.code=? ');
40. Insert  into Ofproperty (NAME, PropValue)
42. Values (' Jdbcauthprovider.passwordtype ', ' Plain ');
46. --Custom user management
48. Insert  into Ofproperty (NAME, PropValue)
50. Values (' jdbcuserprovider.alluserssql ', 'select code from T_sys_user
54. T ');
56. Insert  into Ofproperty (NAME, PropValue)
58. Values (' Jdbcuserprovider.namefield ', ' name ');
60. Insert  into Ofproperty (NAME, PropValue)
62. Values (' jdbcuserprovider.searchsql ', 'select code from T_sys_user t
66. where code=? ');
68. Insert  into Ofproperty (NAME, PropValue)
70. Values (' Jdbcuserprovider.useconnectionprovider ', ' true ');
72. Insert  into Ofproperty (NAME, PropValue)
74. Values (' Jdbcuserprovider.emailfield ', ' email ');
76. Insert  into Ofproperty (NAME, PropValue)
78. Values (' jdbcuserprovider.usercountsql ', 'select Count(*) from
82. T_sys_user t ');
84. Insert  into Ofproperty (NAME, PropValue)
86. Values (' jdbcuserprovider.loadusersql ', 'select T.name, T.email,t.code
90. from T_sys_user t where t.code=? ');
92. Insert  into Ofproperty (NAME, PropValue)
94. Values (' Jdbcuserprovider.usernamefield ', ' Code ');
98. --Use a different data source
100. Update Ofproperty Set
104. propvalue=' Org.jivesoftware.openfire.user.JDBCUserProvider '
106. where NAME=' Provider.user.className ';
108. Update Ofproperty Set
112. propvalue=' Org.jivesoftware.openfire.auth.JDBCAuthProvider '
114. where NAME=' Provider.auth.className ';
116. commit;

--Set the JDBC Connection mode insert into Ofproperty (NAME, PropValue) VALUES (' jdbcprovider.connectionstring ', ' jdbc:oracle:thin:@ 10.35.246.178:1521:orcl '); insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcprovider.driver ', ' Oracle.jdbc.driver.OracleDriver ');--Set Administrator account insert into Ofproperty (NAME, PropValue) VALUES (' Admin.authorizedjids ', ' [email protected] ');--Custom user authentication insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcauthprovider.useconnectionprovider ', ' true '); insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcauthprovider.passwordsql ', ' select ' 123456 ' as pwd from T_sys_user t where t.code=? '); Insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcauthprovider.passwordtype ', ' Plain ');--Custom user management insert INTO Ofproperty (NAME, PropValue) VALUES (' Jdbcuserprovider.alluserssql ', ' Select code from T_sys_user t '); INSERT into Ofproperty (name, PropValue) VALUES (' Jdbcuserprovider.namefield ', ' name '); insert into Ofproperty (name, PropValue) VALUES (' Jdbcuserprovider.searchsql ', ' Select code from T_sys_uSer t where code=? '); Insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcuserprovider.useconnectionprovider ', ' true '); Ofproperty (name, PropValue) VALUES (' Jdbcuserprovider.emailfield ', ' email '); insert into Ofproperty (name, PropValue) VALUES (' Jdbcuserprovider.usercountsql ', ' SELECT count (*) from T_sys_user t ') and insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcuserprovider.loadusersql ', ' select T.name,t.email,t.code from T_sys_user t where t.code=? '); Insert into Ofproperty (NAME, PropValue) VALUES (' Jdbcuserprovider.usernamefield ', ' Code ');--use a different data source update Ofproperty Set propvalue= ' Org.jivesoftware.openfire.user.JDBCUserProvider ' where name= ' provider.user.className '; update Ofproperty set propvalue= ' Org.jivesoftware.openfire.auth.JDBCAuthProvider ' where name= ' provider.auth.className '; Commit

Only partial authentication and user management related configurations are used here, more configuration is required to view the source code to obtain

OpenFire using the Custom user table