APEX Listener 1.2 with JBOSS7.0.2 (Jboss7)

Posted by mcgjboss Jan 9, 2012

APEX with JBOSS 7:

Well, I spent 3 days to get this going. It is not pretty but it works and I am sharing all the mess I had to go through to make it work.

1- Download JDK 7 from here - http://www.oracle.com/technetwork/java/javase/downloads/index.html

2- Download JBOSS 7 from here http://www.jboss.org/jbossas/downloads/

I downloaded 7.0.2 final

3- unzip JDK 7 and asign th eunzipped directorya s JAVA_HOME and add to the path. For me:

export JAVA_HOME=/home/oracle/jdk1.7.0_01

export PATH=$JAVA_HOME/bin:$PATH

4- unzip the jboss and assign this as JBOSS_HOME. for me it is:

JBOSS_HOME=/home/oracle/jboss702

(Please do not start the jboss yet)

5- Please copy the images for APEX as defined in step 4 here - http://apexdplsepg.blogspot.com/2011/12/install-upgrade.html

6- Untar the images from step5 to $JBOSS_HOME/standalone/deployments. for me it is:

/home/oracle/jboss702/standalone/deployments

7- Download the APEX listener and extract the apex.war from here -

http://www.oracle.com/technetwork/developer-tools/apex-listener/downloads/index.html

8- Please do this as indicated below - Very important steps below.

cd $JBOSS_HOME/standalone/deployments

mkdir apex.war

cd apex.war

jar -xvf /homne/oracle/dwnld/apex/apex.war

(Please note that I downloaded and unzipped the APEX listener at /home/oracle/dwnld/apex location)

mkdir /home/oracle/aptmp

cd /home/oracle/aptmp

jar -xvf $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/lib/apex.jar

cd META-INF

vi oracle.dbtools.rt.services

delete the following line from it:

oracle.dbtools.rt.uri.WarURIResolver

save and exit

now repackage this as:

cd ../ to go to /home/oracle/aptmp

jar -cvf /home/oracle/apex.jar *

(This will create apex.jar in the /home/oracle direvctory)

rm -f $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/lib/apex.jar

cp apex.jar $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/lib/

cd $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF

vi adminTemplate.html

Replace all scripts to /i/scripts. This is because for some reason when JBOSS deploys the apex.war there is no directory access inside the apex.war and I did not want to put a lot of time to find out as where this permission is set. I look arounf in the web.xml and others but could not find it. However i.war is accessible for other APEX images so I decided to do this way.

Mine looks like:

amghost3:Oracle ->> grep scripts adminTemplate.html

cd ../ (One step up to /home/oracle/jboss702/standalone/deployments/apex.war)

cp -R scripts ../i.war/

now cd $JBOSS_HOME/bin

edit the jboss-admin.sh and change the last line as:

eval \"$JAVA\" $JAVA_OPTS -jar \"$JBOSS_HOME/jboss-modules.jar\" -logmodule "org.jboss.logmanager" -

mp \"$JBOSS_HOME/modules\" org.jboss.as.cli '--connect controller=amghost3.cup.com:9009 "$@"'

(Please note that I decided to run the web server on 8008 port and 9009 and 9008 for Admin. console)

vi standalone.conf

change the JAVA_OPTS. Mine is:

if [ "x$JAVA_OPTS" = "x" ]; then

JAVA_OPTS="-Xms64m -Xmx512m -XX:MaxPermSize=256m -Djava.net.preferIPv4Stack=true -Dorg.jboss.resolver.warning=true -Dsun.rmi.dgc.client.gcInterval=3600000 -Dsun.rmi.dgc.server.gcInterval=3600000"

JAVA_OPTS="$JAVA_OPTS -Djboss.modules.system.pkgs=$JBOSS_MODULES_SYSTEM_PKGS -Djava.awt.headless=true -Dapex.home=/home/oracle/apex -Dapex.images=/home/oracle/jboss702/standalone/deployments/i.war"

(Please note that the reason I pu the apex variables here is because when we do the listenerConfigure - it will create the conf file in /tmp/apex - so to make it appropriate I did this)

now cd to $JBOSS_HOME/standalone/configuration and edit teh standalone.xml file. Please note the following changes. These changes are to have HTTP/1.1 in UTF-8 format and Admin and Manager Roles and users for APEX.

Just below </extension at the top of the file add following:

<system-properties>

</system-properties>

then I changed the Admin console port and locked them to use the username as:

<native-interface interface="management" port="9009" security-realm="PropertiesMgmtSecurityRealm"/>

<http-interface interface="management" port="9008" security-realm="PropertiesMgmtSecurityRealm"/>

Now look for the security-domain where other is mentioned change it as :

<security-domains>

<security-domain name="other" cache-type="default">

<login-module code="UsersRoles" flag="required"/>

</authentication>

</security-domain>

<security-domain name="form-auth" cache-type="default">

<login-module code="UsersRoles" flag="required">

<module-option name="usersProperties" value="users.properties"/>

<module-option name="rolesProperties" value="roles.properties"/>

</login-module>

</authentication>

</security-domain>

</security-domains>

Now at the interfaces change the 127.0.0.1 to the name like:

<inet-address value="${jboss.bind.address.management:amghost3.cup.com}"/>

</interface>

<inet-address value="${jboss.bind.address:amghost3.cup.com}"/>

</interface>

</interfaces>

and the right beneath it the web port:

<socket-binding name="http" port="8008"/>

Now create followin 2 files "users.properties" and "roles.properties" as:

amghost3:Oracle ->> more users.properties

#Format: username=password

#

adminlsn=jboss7

mnglsn=jboss7

amghost3:Oracle ->> more roles.properties

adminlsn=Admin

adminlsn.Roles=Admin

mnglsn=Manager

mnglsn.Roles=Manager

Now edit the mgmt-users.properties and uncomment the admin as:

admin=jboss7

Now remove the xmpparser from $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/lib as:

rm -f $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/lib/xmlparserv2-11.2.0.jar

Oh Well - Bear with me - couple more steps ---

Now start the JBOSS as cd $JBOSS_HOME/bin

./standalone.sh

Now cd $JBOSS_HOME/standalone/deployments

touch i.war.dodeploy

wait until you see "i.war.deployed"

Now touch apex.war.dodeploy

Now wait until it says apex.war.deployed

Now the magic part :

http://<host>:8008/apex/listenerConfigure

and after inputs above you will end up at:

Now shutdown the JBOSS and do following:

amghost3:Oracle ->> cd /home/oracle/apex

amghost3:Oracle ->> ls

apex-config.xml bdb

vi apex-config.xml

and remove following line from the top of the fikle:

<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

save and exit

Now copy users.properties and roles.properties from $JBOSS_HOME/standalone/configuration to $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/classes

(we will have to make this directory)

amghost3:Oracle ->> mkdir $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/classes

amghost3:Oracle ->> pwd

/home/oracle/jboss702/standalone/configuration

amghost3:Oracle ->> cp users.properties $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF/

amghost3:Oracle ->> cp roles.properties $JBOSS_HOME/standalone/deployments/apex.war/WEB-INF

amghost3:Oracle ->> pwd

/home/oracle/jboss702/standalone/deployments/apex.war/WEB-INF/classes

amghost3:Oracle ->> ls

roles.properties users.properties

amghost3Oracle ->>

Now start the jboss agin and test the listenerAdmin tio verify the last puzle of user and roles:

cd $JBOSS_HOME/bin

./standalone.sh

and Wallah !! it works ..

It should work on Jboss 7.1 as well but if it does not then please comment and I will try tp see what need to be fixed !!

Happy sharing !!

JBOSS Error UsersRolesLoginModule.login Missing users.properties file

Posted by mcgjboss Jan 9, 2012

Error:

18:32:48,113 ERROR [org.jboss.security.authentication.JBossCachedAuthenticationManager] (http-ebiz3.cup.hp.com-16.89.84.96-8008-1) Login failure: javax.security.auth.login.LoginException: Missing users.properties file.

at org.jboss.security.auth.spi.UsersRolesLoginModule.login(UsersRolesLoginModule.java:150) [picketbox-4.0.1.jar:4.0.1]

Explanation:

It suggests that the security domain "UsersRoles" in Jboss7 is enabled in standalone.xml and files "users.properties" and "roles.properties" are referenced in this file. However an application that is deployed cannot locate these files.

The files generally are in $JBOSS_HOME/standalone/configuration for standalone implementation. However individual application are looking for these files in $JBOSS_HOME/standalone/deployments/<application>/WEB-INF/classes directory. In my case it was:

/home/oracle/jboss702/standalone/deployments/m.war

I did not have the classes directory at the above location neither did my application was unexploded - so I do not have any directory structure either.

Solution:

I have 2 options:

Options 1:

Unzar my application and then create directory classes and copy files from configuration dorectoru to this directory and test.

Option 2:

I do exactly as in option 2. However re-jar them to have an application as m.war rather than a directory as m.war.

Repackage as "jar -cvf *"

Unpackage as "jar -xvf m.war"

In either way it will work..

URIEncoding in JBOSS7

Posted by mcgjboss Jan 9, 2012

Old Jboss type style like following in Jboss7 is no more and you will have to add in system properties:

Old way: <Connector name="http" ... URIEncoding="UTF-8" useBodyEncodingForURI="true"/>

This can be edited in standalone.xml file to take effect in old way

New Way:

In Jboss7 there are 2 methods by which you can add these:

Method 1:

Using the jboss-admin.sh adn updating the system-property like:

[standalone@amghost3.cup.com:9009 /]

/system-property=org.apache.catalina.connector.URI_ENCODING:add(value="UTF-8")

{"outcome" => "success"}

[standalone@amghost3.cup.com:9009 /]

/system-property=org.apache.catalina.connector.USE_BODY_ENCODING_FOR_QUERY_STRING:add(value="true")

{"outcome" => "success"}

[standalone@amghost3.cup.com:9009 /]

Verify these property by:

[standalone@amghost3.cup.com:9009 /] /system-property=org.apache.catalina.connector.URI_ENCODING:read-resource

{

"outcome" => "success",

"result" => {"value" => "UTF-8"}

}

[standalone@amghost3.cup.com:9009 /]

[standalone@amghost3.cup.com:9009 /] /system-property=org.apache.catalina.connector.USE_BODY_ENCODING_FOR_QUERY_STRING:read-resource

{

"outcome" => "success",

"result" => {"value" => "true"}

}

[standalone@amghost3.cup.com:9009 /]

Method 2:

cd $JBOSS_HOME/standalone/configuration

vi standalone.xml ad add the following lines just below the </extensions>

<system-properties>

<property name="org.apache.catalina.connector.USE_BODY_ENCODING_FOR_QUERY_STRING" value="tru

e"/>

</system-properties>

Hope this Helps.

JBOSS7 Oracle Data Source and Test

Posted by mcgjboss Jan 9, 2012

In this post I am going to discuss the Oracle data connection pool (JNDI Pool) and testing of that connection.

There are 2 ways that you can have oracle driver known to Jboss.

Option 1:

You take ojdbc6.jar from Oracle 11g Home/jdbc/lib and deploy it from JBOSS admin console (http://<host>:9990) This is default port. However if you have changed it then use that port.

After loging in you will see deployment - the navigation path is:

Profile -->Deployments -->Manage Deployments Then on right side pane click "Add" on top right. Now select the ojdbc6.jar and deploy. Please see the screen shot below and check the red circles for navigation.

After the deployment - it need to be enabled. See below:

Now add the data source like:

I put SOADS for name and JNDI name both.

Option2:

This is manual option and involves editing the standalone.xml and making directory etc. Please see below:

1- Cd $JBOSS_HOME/modules/com

2- Mkdir –p oracle/ojdbc6/main/

3- Cd $JBOSS_HOME/modules/com/oracle/ojdbc6/main

4- Cp $ORACLE_HOME/jdbc/lib/ojdbc6.jar . – Please note that the ORACLE_HOME here is the oracle database 11g home and this can be on a separate machine. Please copy this jar file however way you want (Scp , ftp etc etc..)

5- From current directory i.e $JBOSS_HOME/modules/com/oracle/ojdbc6/main and

Vi module.xml

<module xmlns="urn:jboss:module:1.0" name="com.oracle.ojdbc6">

<resources>

<resource-root path="ojdbc6.jar"/>

</resources>

<dependencies>

<module name="javax.api"/>

</dependencies>

</module>

--- Save and exit

6- Cd $JBOSS_HOME/standalone/configuration

Edit the standalone.xml to add following – first in the datasources and then in the drivers section – below the h2 datasource

*********datasources section *****************

<datasource jndi-name="AdmDS" pool-name="OracleDS" enabled="true" use-java-context="true" jta="true">

<connection-url>jdbc:oracle:thin:@kbrsp400.corp.kbr.com:1570:UPKSTG</connection-url>

<driver>oracle</driver>

<pool>

<prefill>true</prefill>

<use-strict-min>false</use-strict-min>

</pool>

<security>

<user-name>ARISBP</user-name>

<password>arisbp11gstg</password>

</security>

<validation>

<validate-on-match>false</validate-on-match>

<background-validation>false</background-validation>

<useFastFail>false</useFastFail>

</validation>

<statement />

</datasource>

********Ends datasources section

*****Drivers section **************

<driver name="oracle" module="com.oracle.ojdbc6">

<xa-datasource-class>oracle.jdbc.OracleDriver</xa-datasource-class>

</driver>

********Ends drivers section*********

7- Test the datasource from command line as:

Cd $JBOSS_HOME/bin

./jboss-admin.sh

[disconnected /] connect amghost3.cup.com

Connected to standalone controller at amghost3.cup.com:9999

[standalone@ amghost3.cup.com:9999 /] /subsystem=datasources/data-source=SOADS:test-connection-in-pool

{

"outcome" => "success",

"result" => [true]

}

[standalone@ amghost3.cup.comm:9999 /]

Test with JSP and for above Data Source:

To test this is what I did. I created a directory "test.war" in $JBOSS_HOME/standalone/deployments and underneath it created WEB-INF directory and lib directory and copied ojdbc6.jar there. This is the listing of the directory:

drwxr-xr-x oracle/dba 0 2011-12-09 10:05:34 test.war/

-rw-r--r-- oracle/dba 1054 2011-12-08 10:28:03 test.war/sql.jsp

drwxr-xr-x oracle/dba 0 2011-11-30 21:04:24 test.war/WEB-INF/

drwxr-xr-x oracle/dba 0 2011-11-30 21:57:01 test.war/WEB-INF/lib/

-rw-r--r-- oracle/dba 2111220 2011-11-30 20:05:59 test.war/WEB-INF/lib/ojdbc6.jar

-rw-r--r-- oracle/dba 783 2011-11-30 18:09:37 test.war/ver.jsp

-rw-r--r-- oracle/dba 1629 2011-12-08 13:22:36 test.war/plsql1.jsp

-rw-r--r-- oracle/dba 837 2011-12-02 19:46:30 test.war/test.jsp

After I am done with my scripting and all the setup as above, I went to $JBOSS_HOME/standalone/deployments and issued following command:

touch test.war.dodeploy

This made my test application deployed in Jboss7 and now I am ready for testing.

Here are screen shots of my testing.

sql.jsp:

test.jsp:

ver.jsp:

plsql1.jsp:

Please note that the packages in Oracle that do not have an out variable cannot be displayed in JSP. For example hellotest package that prints hellotest and dbms_output.put_line that prinsta whatever line or text you want to print. These examplesa do not have any column name associated with them and since JSP prints out them with column index - they cannot be found and will run into "Invalid column Index" issues. However you can still execute them but do not print the output to browser. At least this is my experience and not saying that this is how exactly they behave.

The scripts are:

test.jsp:
<%@page contentType="text/html"

import="java.util.*,

javax.naming.*,

javax.sql.DataSource,

java.sql.*"%>

<html>

<p><font size="6">This is the result from:"select 'YES' YES from dual":

<%

DataSource cname = null;

Connection cont = null;

PreparedStatement stmt = null;

InitialContext ctx;

try {

ctx = new InitialContext();

cname = (DataSource)ctx.lookup("SOADS");

cont = cname.getConnection();

stmt = cont.prepareStatement("select BANNER from SYS.V_$VERSION");

ResultSet sr = stmt.executeQuery();

while (sr.next()) {

out.println("<br> " +sr.getString(1));

}

sr.close();

stmt.close();

}catch(Exception excep){

out.println("Exception Encountered " +excep);

}finally{

if(cont != null){

cont.close();

}

} %></font></p>

</body>

</html>
sql.jsp:

<%@page contentType="text/html"

import="java.util.*,

javax.naming.*,

javax.sql.DataSource,

java.sql.*,

java.io.*,

oracle.jdbc.*,

oracle.jdbc.driver.*,

oracle.jdbc.pool.*,

oracle.sql.*"%>

<html>

<body>

<p><font size="3">This is the result from:"PLSQL Execution ...":

<%

DataSource cname = null;

Connection cont = null;

CallableStatement stmt = null;

String oraclProc = (" begin ? :=change.test(?); end;");

InitialContext ctx;

try {

ctx = new InitialContext();

cname = (DataSource)ctx.lookup("SOADS");

cont = cname.getConnection();

stmt = cont.prepareCall(oraclProc);

stmt.registerOutParameter(1,Types.VARCHAR);

stmt.setString(2, "Yummy");

stmt.execute();

out.println(stmt.getString(1));

stmt.close();

}catch(Exception excep){

System.out.println("Exception Encountered " +excep);

out.println("<br>"+"Exception Encountered " +excep);

}

finally{

if(cont != null){

cont.close();

}

if(stmt != null){

stmt.close();

}

} %></font></p>

</body>

</html>

plsql1.jsp:
<%@page contentType="text/html"

import="java.util.*,

javax.naming.*,

javax.sql.DataSource,

java.sql.*,

java.io.*,

oracle.jdbc.*,

oracle.jdbc.driver.*,

oracle.jdbc.pool.*,

oracle.sql.*"%>

<html>

<body >

<p>This is the result from:"PLSQL Execution ...":

<%

ResultSet ors;

DataSource cname = null;

Connection cont = null;

Statement stmt = null;

String oraquery = ("select owner,name,type from v$db_object_cache where kept='YES' order by

owner");

InitialContext ctx;

try {

ctx = new InitialContext();

cname = (DataSource)ctx.lookup("SOADS");

cont = cname.getConnection();

stmt = cont.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_READ_ONLY);

out.println("\nExecuting query: " + oraquery );

out.println("\n");

out.println("OWNER"+"<HTML>	"+"NAME"+"<HTML>	"+"<HTML>	"+"<HTML>	"+"<HTML>&#0

9;"+"<HTML>	"+"<HTML>	"+"<HTML>	"+"TYPE");

out.println("--------------------------------------------------------------------------");

ors = stmt.executeQuery(oraquery);

while (ors.next()) {

out.println(ors.getString(1) +"<HTML>	"+"<HTML>	"+ ors.getString(2) +"<

HTML>	" +"<HTML>	"+"<HTML>	"+ ors.getString(3));

}

stmt.close();

}catch(Exception excep){

System.out.println("Exception Encountered " +excep);

out.println("<br>"+"Exception Encountered " +excep);

}

finally{

if(cont != null){

cont.close();

}

if(stmt != null){

stmt.close();

}

} %></font></p>

</pre>

</body>

</html>

ver.jsp:
<%@page contentType="text/html"

import="java.util.*,

javax.naming.*,

javax.sql.DataSource,

java.sql.*,

oracle.jdbc.*,

oracle.sql.*"%>

<%

DataSource cname = null;

Connection cont = null;

InitialContext ctx;

try {

ctx = new InitialContext();

cname = (DataSource)ctx.lookup("SOADS");

cont = cname.getConnection();

// Create Oracle DatabaseMetaData object

DatabaseMetaData meta = cont.getMetaData();

// gets driver info:

System.out.println("JDBC driver version is " + meta.getDriverVersion());

out.println("<br> "+"JDBC driver version is " + meta.getDriverVersion());

}

catch(Exception excep){

out.println("Exception Encountered " +excep);

}

finally{

if(cont != null){

cont.close();

}

%>

Hope this Helps.

Enabling the Users and Roles in JBOSS7 and Adding Admin Console Restriction

Posted by mcgjboss Jan 9, 2012

In this post I will discuss that how you can have users and roles enabled in Jboss version 7.0.2.

There are 2 steps:

Step1: You need to edit the standalone.xml file and add following in the security-domain section:

<login-module code="UsersRoles" flag="required" />

</authentication>

</security-domain>

<security-domain name="form-auth" cache-type="default">

<login-module code="UsersRoles" flag="required">

<module-option name="usersProperties" value="users.properties"/>

<module-option name="rolesProperties" value="roles.properties"/>

</login-module>

</authentication>

This will enable the form authentication from the browser in Jboss.

Step2: Create the users and roles file and put them in $JBOSS_HOME/standalone/configuration directory and in the WEB-INF/classes directory of the application deployed. Mine looks like:

users.properties:

#Format: username=password

#

adminlsn=jboss7

mnglsn=jboss7

roles.properties:

adminlsn=Admin

adminlsn.Roles=Admin

mnglsn=Manager

mnglsn.Roles=Manager

Adding Restriction to Admin Console:

By default the Admin Console is not protected with access control. You can enable the restriction while logging into the admin console from the native and http interfaces.

edit the standalone.xml file where admin ports are mentioned in the management-interface section and change them as:

<management-interfaces>

<native-interface interface="management" port="9009" security-realm="PropertiesMgmtSecurityRealm"/>

<http-interface interface="management" port="9008" security-realm="PropertiesMgmtSecurityRealm"/>

</management-interfaces>

Now edit the "mgmt-users.properties" file in $JBOSS_HOME/standalone/configuration directory to look like:

#Format: username=password

#

#admin=admin

admin=jboss7

JBossDeveloper

Mukesh Ghildiyal's Blog

APEX Listener 1.2 with JBOSS7.0.2 (Jboss7)

JBOSS Error UsersRolesLoginModule.login Missing users.properties file

URIEncoding in JBOSS7

JBOSS7 Oracle Data Source and Test

Enabling the Users and Roles in JBOSS7 and Adding Admin Console Restriction

Actions

Filter Blog