Saturday, December 25, 2010

How to setup a Web server inside campus.

Prerequisite  : Broadband/Leased internet line , Web server , Static IP and Basic UTM box .

Here I am using Fortigate
Step 1 : Change Web admin port of fortigate from 80 to any other port.

Step 2 : Create new Virtual IP which points to internal web server

Step 3 : Add new policy like below .

Now you access your webserver like http://225.21.251.21

If you like to have domain name for your web server.Purchase one from domainname registrar like rediff.com.And change its A record to your static IP. Now you can access your web server with a domain name. Ex : www.testserver.com

Monday, December 13, 2010

Dummy table dual problem.

This is what happened to my dual synonym in my testing database.I had dropped dual synonym after that I created a synonym using x$dual.

The real problem started now. I cant drop a table or synonym.

Non admin user login had received  following error.

SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level. 

ORA-00980: synonym translation is no longer valid


Solution :

Create public synonym for sys.dual .This only solve this problem.But for that I need to drop the already created synonym.





But this is what happened.

SQL> drop public synonym dual  force;
drop public synonym dual force
*

ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00980: synonym translation is no longer valid

So I created dual synonym in all users including default schemas.

    connect sys/mypass as sysdba;
    create view x_$dual as select * from x$dual ;
    grant select on x_$dual to public;
    connect my_schema_owner/mypassword;
    create synonym DUAL for sys.x_$dual ;

After that I could able to drop tables and synonyms.

So don't drop dual table table or public synonym of dual table.

Monday, November 1, 2010

SSL-VPN using UTM (Fortigate)

Access your private network from public network using fortigate VPN (Simplifed document)
Step 1: Allocate private ip addresses for your VPN access from public network
 Step 2: Configure SSL-VPN
 3. VPN Portal creation - Web mode access . Create portal in your VPN box and access your internal network using the portal.

4. Create username  to access VPN from public network 
 5. Create user group which should have SSL-VPN access to already created portal.
7. Now create firewall policy
    In this policy Public network can access Internal network using VPN portal and VPN user group.

Configuration completed.

Extra configuration for Tunnel Mode access
8. Add new policy for Tunnel Mode
9. Add static route to send reply from internal network to VPN clients