1.先來看一個普通的數據源配置文件
- <?xml version="1.0" encoding="UTF-8"?>
- <datasources>
- <local-tx-datasource>
-
- <jndi-name>MySqlDS</jndi-name>
-
- <use-java-context>false</use-java-context>
- <connection-url>jdbc:mysql://10.16.175.137:3306/test</connection-url>
-
- <driver-class>com.mysql.jdbc.Driver</driver-class>
-
- <user-name>root</user-name>
-
- <password>123456</password>
- <exception-sorter-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter </exception-sorter-class-name>
- <metadata>
- <type-mapping>mySQL</type-mapping>
- </metadata>
- </local-tx-datasource>
- </datasources>
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<!-- jndi名字 -->
<jndi-name>MySqlDS</jndi-name>
<!--URL地址 -->
<use-java-context>false</use-java-context>
<connection-url>jdbc:mysql://10.16.175.137:3306/test</connection-url>
<!-- 驅動 -->
<driver-class>com.mysql.jdbc.Driver</driver-class>
<!-- 用戶名 -->
<user-name>root</user-name>
<!-- 密碼 -->
<password>123456</password>
<exception-sorter-class-name> org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter </exception-sorter-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
看一下這個文件,里面用戶名與密碼都是以明文方式存儲的,這樣子對系統的安全而言帶來了極大的威協。所以我們要為我們這個明文的密碼加一下密,這就是本文的目的.
2.說到密碼加密,這里我們用到了JBoss下的一個類org.jboss.resource.security.SedureIdentityLoginModule,看看我們該如何用它來幫我們的密碼加密。
先看個配置數據源的例子(mysql-ds.xml)
- <?xml version="1.0" encoding="UTF-8"?>
- <datasources>
- <local-tx-datasource>
- <jndi-name>MySqlDS</jndi-name>
- <use-java-context>false</use-java-context>
- <connection-url>jdbc:mysql://192.168.1.91:3306/atteam</connection-url>
- <driver-class>com.mysql.jdbc.Driver</driver-class>
-
- <security-domain>EncryptDBPassword</security-domain>
- <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
- <metadata>
- <type-mapping>mySQL</type-mapping>
- </metadata>
- </local-tx-datasource>
- </datasources>
<?xml version="1.0" encoding="UTF-8"?>
<datasources>
<local-tx-datasource>
<jndi-name>MySqlDS</jndi-name>
<use-java-context>false</use-java-context>
<connection-url>jdbc:mysql://192.168.1.91:3306/atteam</connection-url>
<driver-class>com.mysql.jdbc.Driver</driver-class>
<!--這里不用寫上你的用戶名與密碼了,我們可以在login-config.xml里做點手腳,就OK了 -->
<security-domain>EncryptDBPassword</security-domain>
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
<metadata>
<type-mapping>mySQL</type-mapping>
</metadata>
</local-tx-datasource>
</datasources>
接著我們修改server\default\conf\login-config.xml文件,加上下面這一段配置文件
- <application-policy name="EncryptDBPassword">
-
- <authentication>
- <login-module code="org.jboss.resource.security.SecureIdentityLoginModule" flag="required">
-
- <module-option name="username">test</module-option>
-
- <module-option name="password">64c5fd2979a86168</module-option>
-
- <module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
- </login-module>
- </authentication>
- </application-policy>
<application-policy name="EncryptDBPassword">
<!--這里的name應該是你在配置數據源時寫的security-domain里的字符串-->
<authentication>
<login-module code="org.jboss.resource.security.SecureIdentityLoginModule" flag="required">
<!-- 數據庫的用戶名 -->
<module-option name="username">test</module-option>
<!--數據庫的密碼,不過是加密過的了 -->
<module-option name="password">64c5fd2979a86168</module-option>
<!-- 注意name等于你的數據源的jndi-name,這里是MySqlDS -->
<module-option name="managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS</module-option>
</login-module>
</authentication>
</application-policy>
3.補充一下,這個加密的密碼是哪來的
- java -cp "D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\lib\jboss-jmx.jar;D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\lib\jboss-common.jar;D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\server\default\lib\jboss-jca.jar;D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\server\default\lib\jbosssx.jar" org.jboss.resource.security.SecureIdentityLoginModule 123456 Encoded password: 64c5fd2979a86168
java -cp "D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\lib\jboss-jmx.jar;D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\lib\jboss-common.jar;D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\server\default\lib\jboss-jca.jar;D:\TDdownload\jboss-4.2.0.CR1\jboss-4.2.0.CR1\server\default\lib\jbosssx.jar" org.jboss.resource.security.SecureIdentityLoginModule 123456 Encoded password: 64c5fd2979a86168
寫上你自己的路徑和你要加密的密碼就行了,我這里要加密的密碼是123456,加密過之后就是64c5fd2979a86168