Search this site

GB Advisors, Inc.

PR: +1 (787) 708-6734
US: +1 (786) 272-2370

Tech Blog

Subscribe to posts

Oracle APEX Listener / Apache Reverse Proxy Configuration

posted Dec 2, 2011 12:57 PM by Alexander Guedez   [ updated Dec 2, 2011 1:00 PM ]

Many people are interested in how to configure the Oracle APEX listener and Apache in a reverse proxy architecture utilizing AJP. This configuration has resulted to be very efficient (Free) compared to the other Weblogic (Costly) alternative configurations. Below you will find a diagram with what we want to accomplish. 



Assumptions:

First we make sure our system is updated. As root:

# yum update


Install Apache httpd if its not already installed. As root:

# yum install httpd


Configure the httpd service to run reverse proxy with the APEX Listener

First make a backup of the httpd configuration file, as root:

# cp /etc/httpd/conf/httpd.conf  /etc/httpd/conf/httpd.conf.original


 Modify your httpd.conf file to add the reverse proxy calls from and to the Apex Listener. As root user:

# vi /etc/httpd/conf/httpd.conf


Add at the end of the file httpd.conf:


ProxyRequests Off

<Proxy *>
Order deny,allow
Allow from all
</Proxy>

ProxyPreserveHost On

ProxyPass /apex ajp://localhost:8009/apex
ProxyPassReverse /apex ajp://localhost:8009/apex
ProxyPass /i ajp://localhost:8009/i
ProxyPassReverse /i ajp://localhost:8009/i



Restart the httpd service for the changes to take place. As root:

# service httpd restart


Download the latest Oracle Apex Listener version:



Unzip the Apex Listener compressed file in /oracle/listener . As oracle user:

# unzip apex_listener.zip


The first time you run the Apex Listener you must run in the command prompt without the "&" at the end. The reason is that the configuration requires the administrator to assign a user and password to the Listener Admin and Manager. As oracle user:

# java -Dapex.home=/oracle/listener/apex -Dapex.images=/oracle/apex/images -Dapex.ajp=8009 -Dapex.erase -jar /oracle/listener/apex.war


(Optional) The subsequent times you run the Apex listener you can use "&". For example:

# java -Dapex.home=/oracle/listener/apex -Dapex.images=/oracle/apex/images -Dapex.ajp=8009 -Dapex.erase -jar /oracle/listener/apex.war &


The first time you log in you need to go to the listener configuration website and add the connection information for your database and APEX_PUBLIC_USER user account:

http://localhost/apex/listenerConfigure


Enjoy your new Apex using your reverse proxy configuration!!!

Install Opencart on CentOS 6

posted Nov 25, 2011 10:32 PM by Alexander Guedez   [ updated Dec 1, 2011 9:38 AM ]


Update the operating system before:

# yum update

Install packeges required to run your OpenCart:

# yum install httpd mysql mysql-server php php-mysql php-gd php-curl php-pecl-zip system-config-firewall* unzip

Configure Mysql for Opencart:

# service mysqld start

# /usr/bin/mysqladmin -u root password 'new-password'
# /usr/bin/mysqladmin -u root -h localhost password 'new-password'

# /usr/bin/mysql_secure_installation

# chkconfig mysql on

Create Opencart Database:

# mysql -u root -p 
# mysql> create database opencartdb;
# mysql> grant all on opencartdb.* to 'opencart' identified by 'p@$$w0rD';
# mysql> flush privileges;

Configure Apache Webserver:

# service httpd start
# chkconfig httpd on

Download and install Opencart:

# cd /var/www/html
# wget http://opencart.googlecode.com/files/opencart_v1.5.1.3.1.zip
# unzip opencart_v1.5.1.3.1.zip
# mv upload/ store/

Configure Opencart based on the previous configurations

http://localhost/store/

Remove the Installation directory:

# rm -Rf /var/www/html/store/install/

Enjoy your new Online Store!! 


How to Perform Manual Audits on Non-networked Machines with Numara Track-It! 9, 10, 10.5

posted Nov 23, 2011 10:06 AM by Alejandro Araujo   [ updated Nov 23, 2011 10:08 AM ]

It is  possible to manually audit machines that are not connected to the network, and manually merge this data into the Numara Track-It! Server.

This is how you do it:

In the Track-It! Server, locate the file \Program Files\Numara Software\Numara Track-It!\Track-It! Server\ audit.exe.  Copy it into the machine that needs to be audited, and run it. (It's running parameter may be configured in the Track-It! Administration Console:

  • Tools – Admin Console – Inventory – Audit Execution
  • Tools – Admin Console – Inventory – User Interaction

Upon execution, the audit wizard will run, and the data will be collected. When it's done, a folder named "Data" is written to the machine's desktop. Within that folder is an xml file with the audit's data.

You can then take this XLM file and drop it into the server's "\Program Files\Numara Software\Numara Track-It!\Track-It! Server\Data"   directory.

Once you do that, you can run the merge audit data command within Track-It!, and the data from the unconnected audited machine will be incorporated into the inventory.

Simple Security - Changing SSH Default Port

posted Nov 15, 2011 8:54 PM by Alexander Guedez   [ updated Dec 1, 2011 9:38 AM ]





After installing an Internet Linux Server, one of the easiest ways to secure it and avoid making it a target of automatic attacks from bots its changing the default administration ports, like for example SSH. 


First make a copy of the SSH configuration file:

# cp /etc/ssh/sshd_config /etc/ssh/sshd_config.original

As root edit the SSH config file:

# vi /etc/ssh/sshd_config

Around line 12 in the file you'll find the Port number; change this to a different higher port that is not being used, for example: 24332. Save the new configuration.

Port 24332

Restart the service for the new port to be used:

# service sshd restart

Important Note: Check for firewall ports. By restarting the service the current connection will not be disconnected. Make sure you are able to connect to the new port before disconnecting. 

Enjoy and always think security.


Oracle XE 11g, Oracle APEX upgrade and APEX Listener Installation

posted Nov 13, 2011 6:57 PM by Alexander Guedez   [ updated Dec 2, 2011 1:05 PM ]

Previously download and unzip the necessary software's:

After having CentOS 5+ installed and configured for our Oracle APEX make sure you have the following packages installed:

# yum install binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver sendmail bc java

Install Oracle XE 11g:

# rpm -ivh oracle-xe-11.2.0-1.0.x86_64.rpm

After installation configure Oracle XE 11g:

# /etc/init.d/oracle-xe configure

Install the latest version of Oracle APEX into your Oracle XE 11g. From the APEX software installation directory where apexins.sql is located:

# . /u01/app/oracle/product/11.2.0/xe/bin/oracle_env.sh
# sqlplus / as sysdba

SQL> @apexins SYSAUX SYSAUX TEMP /i/ 

Change the ADMIN password for Oracle APEX INTERNAL workspace:

# sqlplus / as sysdba

SQL> @apxchpwd

Modify APEX_PULBIC_USER account in the database:

# sqlplus / as sysdba

SQL> ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
SQL> ALTER USER APEX_PUBLIC_USER IDENTIFIED BY new_password;

Run the Oracle Listener from the uncompressed directory:

# java -Dapex.home=/oracle/listener/apex -Dapex.images=/oracle/apex/images -Dapex.port=8585 -Dapex.erase -jar /oracle/listener/apex.war 

Go to the listener configuration website and add the connection information for your database and APEX_PUBLIC_USER user account:

http://localhost:8585/apex/listenerConfigure


After having configured the APEX Listener you can connect to Oracle APEX:

http://localhost:8585/apex/



Additional commands and links that will help you uninstall and reconfigure your system


Find the Oracle-xe rpm installed:

# rpm -qa | grep -i ora

Remove the Oracle-xe rpm from CentOS:

# rpm -e oracle-xe-11.2.0-1.0

Configure and Administer the Oracle Listener:

http://localhost:8585/apex/listenerConfigure
http://localhost:8585/apex/listenerAdmin

For the listener to run in AJP instead of HTTP run the following:

# java -Dapex.home=/oracle/listener/apex -Dapex.images=/oracle/apex/images -Dapex.ajp=8009 -Dapex.erase -jar /oracle/listener/apex.war 


Need more Info?



Installing Oracle 10g XE on 64 bit CentOS Linux

posted Sep 24, 2011 10:39 PM by Alexander Guedez   [ updated Dec 1, 2011 9:40 AM ]


This paper describes how to install Oracle 10g XE on Linux 64 bit.



1). First you must run an update of your entire system.


# yum update

2). Install additional 64 bit packages.


# yum install binutils compat-db control-center gcc gcc-c++ glibc glibc-common gnome-libs libstdc++ libstdc++-devel make pdksh sysstat xscreensaver sendmail bc

3). Install 32 bit packages


# yum install libaio compat-libstdc++-296

4). Install Security Packages


# yum install system-config-security*

5). Install Oracle XE


# rpm -ivh oracle-xe-univ-10.2.0.1-1.0.i386.rpm

6.) Configure Oracle XE and done!


# /etc/init.d/oracle-xe configure



1-6 of 6

Sign in|Report Abuse|Print Page|Remove Access|Powered By Google Sites