Monthly Archives: January 2015

Technical

Steal User Information from Skype including Chat history

Leave a comment

Many of you know or not but Skype puts all the user information including your chat history, user contact information , whom you called how long you did basically everything about Skype in a folder without any encryption.  Which means any user who finds the file can retrieve all the information with little knowledge in database.  User not only can retrieve all the message history, but also the message which are removed also.

Who can Do?

Basically anyone who has an access to the computer(no need of admin or root user) can steal the data.

To retrieve the data is very easy,  just go to User folder and copy main.db  file

  • Windows : C:\Users\Username\AppData\Roaming\Skype\skype.id

  • Linux: /home/user/.Skype/skypename/

getting main.db file from user computer means 98% of job is done. now all you need is sqlite tool to view the data. sqllite tool is very easy to find  in internet. normally i use https://sqlitestudio.pl/ tool which has GUI and easier to view the data. Just click the tables you like to see data (like profile, contacts, messages etc) and do whatever you want.

How to Protect yourself?

Bear in mind, logging out from Skype doesnt mean your Skype information is deleted from the system.This is big issue and should be fixed from Skype as soon as possible. Till its not fixed via Skype below steps can be done to protect your data.

  • Don’t allow untrusted person to access your computer
  • Don’t login Skype in public computers or untrusted computer, even if you need to make sure you delete the Skype as soon as your job is done.

    C:\Users\Username\AppData\Roaming\Skype\skype.id

Linux, Technical

Installing Jasperserver pro (Evaluation) with Oracle

Leave a comment

Installing Jasperserver pro with Oracle in Evaluation period is bit tricky, because bundle we download from server can only installer with Postgres SQL.

Below steps explain how to install platform independent Jasperserver pro in your system with Oracle repository.

  1. Download the Jaspersoft pro evaluation from here (Lets say we downloaded windows version)download
  2. Install jaspersoft pro in windows machine, by default it will install with Postgres SQL  Install
  3. Once it’s installed with Postgres SQL, now it’s time to rebuild the war file and pointing it to oracle.
    Note:- we tried to reconfigure just configuration files as in other website told but it doesn’t work 100%, you will get some error like invalid characters and some more errors. So please follow below steps for 100% success.
  4. First lets  tweak and fix the path before building ant.
    • Copy the folder %JASEPER_HOME%\apache-tomcat\webapps\jasperserver-pro into %JASPER_HOME%\buildomatic\install_resources\war\jasperserver-pro (create the folder war if it doesn’t exists)
    • Delete the folder %JASER_HOME%\buildomatic\build_conf
  5. Copy and rename the file inside %JASPER_HOME%\buildomatic\sample_conf\oracle_master.properties into %JASPER_HOME%\buildomatic\ and rename the file into default_master.properties
  6. edit the file default_master.properties file tomcat version, location of tomcat(different location than that is in %JASPER_HOME%), connection parameter of oracle, system username and password and jasperserver schema name and password you want to create like as in the attached file default_master.properties
  7. Once you followed everything as per above, its time to build the oracle database repository and war file for oracle.
    • Commands Description
      cd %JASPER_HOME\buildomatic Makes the buildomatic directory your current directory.
      js-ant create-js-db Creates the JasperReports Server repository database.
      js-ant create-sugarcrm-dbjs-ant create-foodmart-db (Optional) Creates the sample databases.
      js-ant load-sugarcrm-dbjs-ant load-foodmart-db (Optional) Loads sample data into the sample databases.
      js-ant init-js-db-projs-ant import-minimal-pro Initializes the jasperserver database, loads core application data. Running js-ant import-minimal-pro is mandatory. The server cannot function without this data.
      js-ant import-sample-data-pro (Optional) Loads the demos that use the sample data.
      js-ant deploy-webapp-pro Configures and deploys the WAR file to Tomcat, JBoss, or Glassfish.

      Reference: Jasperserver Site
      Normally, minimal(excluding optional options) is enough and it makes Jasperserver clean from unnecessary objects being created.

    • Output: – Installation
  8. After following all above steps without any error. its time to install the jasperserver license.
    • Copy %JASPER_HOME%\jasperserver.license to home directory
      Operating System Location
      Linux /home/<user>/  or ~/
      Windows C:\Users\<user>\
      Solaris /export/home/<user> or ~/
      or if you want to put in user defined location then please follow the link
  9. Now run the Tomcat (not the %JASPER_HOME%\tomcat) and everything should be fine

Migrating Jasperserver and oracle repository.

  1. Take a backup and restore oracle schema JASPERSERVER, FOODMART and SUGARCRM(if exists) into destination oracle server.
  2. Copy Jasperserver-pro webapps folder to Application server.
  3. edit the file located in jasperserver-pro webapps folder %TOMCAT%\webapps\jasperserver-pro\META-INF\context.xml file and configure Oracle url, schema name and password for jdbc/jasperserver, jdbc/sugarcrm, jdbc/foodmart
  4. Copy the file jasperserver.license and copy to user home directory as said in above
  5. Start the Tomcat and finished 🙂

If Evaluation period is expired

if evaluation period is expired then install the initially downloaded from jasperserver website with postgres sql in any test machine, which will generate the jasperserver.license and copy that file into existing jasperserver machine.

 

Reference:-

https://community.jaspersoft.com/documentation/jasperreports-server-source-build-guide/v561/additional-buildomatic-information

https://community.jaspersoft.com/questions/813885/how-configure-jasper-server-oracle-11g