blogs.sun.comを動かしているroller webloggerをSun Java System Application Server 7で一応動かすことができました。Securityの設定などなどまだ精査すべきところがありますが、とりあえずの動かすためにはということで情報公開です。と・・・ここまで書いて重大なことに気づきました、xmlやzip, jarなどのファイルをアップロードできない。うーん。どうしよう。また改めてtipsきちんと書きます。残念。
I tried to write how to install roller weblogger to App server7, but I found I could not upload xml, zip and jar files to blogs.sun.com. Ummm... I'll try to write install tips again soon.
step-1. Download MySQL and JDBC driver
Download MySQL 4.1, and MySQL Connector/J from www.mysql.org.Install MySQL 4.1 and configure DB with installation manual of Roller.
step-2. Library
Copy jar of MySQL Connector/J and jar file for JDBC Security Realm modified for Roller to
/lib . And add those to classpath. (Admin GUI->server1->JVM setting->Path Setting->Classpath suffix.)
C:/Sun/jstudio_04Q4/AppServer7/lib/jdbcsecurity.jar
C:/Sun/jstudio_04Q4/AppServer7/lib/mysql-connector-java-3.0.15-ga-bin.jar
step-3. Create JDBC Connection Pool
| JNDI Name | MySQL41, Datasource |
| Classname | com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource |
| Properties | |
| serverName | localhost |
| port | 3306 |
| user | scott |
| password | tiger |
| databaseName | roller |
step-4. Create JDBC resource
| JNDI Name | jdbc/rollerdb |
| Pool Name | MySQL41 |
| JNDI Name | jdbc/rollerdb |
step-5. Jdbc realm
Add jdbc realm and change it as default realm. And then restart app server.
| Name | jdbc |
| class name | samples.security.jdbcrealm.JDBCRealm |
| Properties | |
| dbusername | scott |
| dbpasswd | tiger |
| dbdrivername | com.mysql.jdbc.Driver |
| dburl | jdbc:mysql://localhost:3306/roller?autoReconnect=true |
| usertable | rolleruser |
| roletable | userrole |
| usernamecol | username |
| userpasswdcol | passphrase |
| usergroupcol | rolename |
| jaas-context | jdbcRealm |
| userpasswdcol | passphrase |
step-6. Add sun-web.xml into WEB-INF
Add this xml file to roller/WEB-INF directory. And then create roller.war.
step-7. add security permission in domains\domain1\server1\config
this is not appropriate configuration
// Core server classes get all permissions by default
grant codeBase "file:${com.sun.aas.installRoot}/-" {
permission java.security.AllPermission;
};
step-7. Deploy roller.war to SJS AS7 from Admin GUI and restart.