RSS

Monthly Archives: August 2012

Grant access Mysql DB to any other computer in your LAN


This is very useful post because when you are going to run the application with Centralized DB you have to give the privileges to the other computers to access Single database hosted in your LAN.

So what you need to do is just run the single database in one computer then go to MySQL console and type the following commands


mysql> grant all privileges on *.* to 'root'@'%' identified by 'root_password';

mysql> flush privileges;

By replacing the ‘%’ to any IP address you can grant for the given IP

 
1 Comment

Posted by on August 31, 2012 in mysql

 

Tags: , ,

XACML policy load testing with Jmeter


This will help you to do the load testing on wso2 IS server
Fist follow my article Xacml policy testing with SoapUi

You don’t need to take the soapui here what you have to do is
Download the Jmeter and import this jmeter-project
You can see the Jmeter project as follows

“UserAuthentication” Soap request is used to send the username and password to
authenticate the user

“SOAP/XML-RPC Request” is used to send the XACML request

Run the jmeter script and see the results under ‘view results tree’

Check this jmeter file as well – This is with one time login to the  server and make the cookie and run the xacml  requests

There is another jmeter with Basic oauth headers as follows
The major change is there is no separate request for authorization

 
Leave a comment

Posted by on August 30, 2012 in wso2

 

Tags: , ,

XACML policy testing with soapUi


This blog post will help you to do the XACML testing on Wso2 Identity Server
You need to have wso2 Identity Server(take the binary) and SoapUi

First go to IS_Home/repository/conf/ and open the carbon.xml then find this property

<HideAdminServiceWSDLs>true</HideAdminServiceWSDLs>

and change to

<HideAdminServiceWSDLs>false</HideAdminServiceWSDLs>

to up the Identity Server run the relevant file

In Windows – IS_Home/bin/wso2server.bat
In Linux – IS_Home/bin/wso2server.sh

Assuming there is no any other server running on the local machine
then you can access the management console in
https://localhost:9443/carbon/admin/login.jsp
username – admin
password – admin

go to Administration->Import new Entitlement policy and upload this policy



Open SoapUI and create a new project by using this wsdl URL
https://localhost:9443/services/EntitlementService?wsdl

You will get the project as mentioned bellow then click the “Request 1” under “getDecision”

now clear the request and insert given request bellow


<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:xsd="http://org.apache.axis2/xsd">
 <soapenv:Header/>
 <soapenv:Body>
 <xsd:getDecision>
 <xsd:request><![CDATA[
 <Request xmlns="urn:oasis:names:tc:xacml:2.0:context:schema:os" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
 <Subject>
 <Attribute AttributeId="urn:oasis:names:tc:xacml:1.0:subject:subject-id"
 DataType="http://www.w3.org/2001/XMLSchema#string">
 <AttributeValue>admin</AttributeValue>
 </Attribute>
 <Attribute AttributeId="group"
 DataType="http://www.w3.org/2001/XMLSchema#string">
 <AttributeValue>admin</AttributeValue>
 </Attribute>
 </Subject>
 <Resource>
 <Attribute AttributeId="urn:oasis:names:tc:xacml:1.0:resource:resource-id" DataType="http://www.w3.org/2001/XMLSchema#string">
 <AttributeValue>http://localhost:8280/services/echo/echoString</AttributeValue>
 </Attribute>
 </Resource>
 <Action>
 <Attribute AttributeId="urn:oasis:names:tc:xacml:1.0:action:action-id" DataType="http://www.w3.org/2001/XMLSchema#string">
 <AttributeValue>read</AttributeValue>
 </Attribute>
 </Action>
 </Request>]]></xsd:request>
 </xsd:getDecision>
 </soapenv:Body>
 </soapenv:Envelope>

Before send the request you have to set the authentication properties for the request
as follows
Username- admin
Password -admin

Now send the request and you will get the response as bellow

Now you can upload your own xacml policy and try out

 
3 Comments

Posted by on August 30, 2012 in wso2

 

Tags:

Videos of EJB with netbeans




 
1 Comment

Posted by on August 29, 2012 in java

 

Tags: ,

Share your Twitter update in your facebook wall


This is very simple just go to the following link

1. Go to Twitter

2. Then Log in to your twitter account and go to profile then click the button “post your tweets to Facebook”

3. You will get the popup window – Log in to the facebook and give the permission

4. Now your twitter account connected to the facebook

when you are tweeting its automatically post in your facebook wall

enjoy yourself with twitter

 
Leave a comment

Posted by on August 29, 2012 in Other

 

Tags: ,

Read XL file in Java


This is basic sample class for read the xl sheet in java
Download source with “jxl-2.6.jar” and “users.xls” here

To run this you have to put the “jxl-2.6.jar” in your class path

package mysamples;

import java.io.File;
import java.io.IOException;
import jxl.Cell;
import jxl.Sheet;
import jxl.Workbook;
import jxl.read.biff.BiffException;
/**
*
* @author dinuka
*/
public class ReadXL {
private String inputFile;

public void setInputFile(String inputFile)
{
         this.inputFile = inputFile;
}

public void read() throws IOException
{
       File inputWorkbook = new File(inputFile);
       Workbook w;
       try
{
w = Workbook.getWorkbook(inputWorkbook);
// Get the first sheet
Sheet sheet = w.getSheet(0);

for (int j = 0; j &lt; sheet.getColumns(); j++)
{
    for (int i = 0; i &lt; sheet.getRows(); i++)
    {
         Cell cell = sheet.getCell(j, i);
         System.out.println(cell.getContents());
     }
}
}
catch (BiffException e)
{
      e.printStackTrace();
}
}

public static void main(String[] args) throws IOException
{
       ReadXL test = new ReadXL();
       test.setInputFile("users.xls");
       test.read();
}
}
 
Leave a comment

Posted by on August 29, 2012 in java

 

Tags:

Java with property file


This is a basic property file sample. You can take the source then
do the necessary changes and apply to your code
PropertyFileSample.java

package mysamples;

import java.io.FileInputStream;
import java.io.FileOutputStream;
import java.io.IOException;
import java.util.Properties;

/**
*
* @author dinuka
*/
public class PropertyFileSample {

public static void write() {
Properties prop = new Properties();

try {
    //set the properties value
    prop.setProperty("database", "localhost");
    prop.setProperty("dbuser", "root");
    prop.setProperty("dbpassword", "123");

    //save properties to project root folder
    prop.store(new FileOutputStream("config.properties"), null);

} catch (IOException ex) {
    ex.printStackTrace();
}
}

public static void read() {

Properties prop = new Properties();
try {
       prop.load(new FileInputStream("config.properties"));
       String database = prop.getProperty("database");
       String user = prop.getProperty("dbuser");
       String pw = prop.getProperty("dbpassword");
       System.out.println("Database: " + database);
       System.out.println("DB User: " + user);
       System.out.println("DB User: " + pw);
} catch (Exception e) {
}

}

public static void main(String[] args) {
       PropertyFileSample.write();
       PropertyFileSample.read();
}
}

Output file

#Tue Aug 28 17:33:26 IST 2012
dbpassword=123
database=localhost
dbuser=root
 
1 Comment

Posted by on August 28, 2012 in java

 

Tags:

 
%d bloggers like this: