Total Pageviews

Wednesday, February 29, 2012

Configure Centos(5.5) as Mail server

1)Configure host name lookup.
---------------
192.168.0.4 mail.yourdomain mail
127.0.0.1 localhost.localdomain localhost
::1 localhost6.localdomain6 localhost6
---------------

2)Install system-switch-mail
---------------
yum install system-switch-mail
---------------
and configure MTA as postfix

3)Install and setup Postfix SMTP server.

-----------------
yum install postfix*
Edit '/etc/postfix/main.cf' and enter they following details.

inet_interfaces = all
mydestination = $myhostname, localhost.$mydomain, localhost, $mydomain
home_mailbox = Maildir/

After doing this, restart postfix

/etc/init.d/postfix restart

/sbin/chkconfig postfix on

4)Install and setup Dovecot POP3 and IMAP server.
yum install dovecot*

Edit /etc/dovecot.conf' and enter the following entries.

protocols = pop3 pop3s imap imaps
mail_location = maildir:~/Maildir/
pop3_uidl_format = %08Xu%08Xv
imap_client_workarounds = delay-newmail outlook-idle netscape-eoh
pop3_client_workarounds = outlook-no-nuls oe-ns-eoh


After doing this, restart dovecot

/etc/init.d/dovecot restart

/sbin/chkconfig dovecot on

5)Install and setup SquirrelMail WebMail.

yum install squirrelmail*

From a Terminal window, type in /usr/share/squirrelmail/config/conf.pl and press Enter. This will launch the SquirrelMail Configuration utility.

Type in D and press Enter to select the Set pre-defined settings for specific IMAP servers menu. Type in dovecot and press Enter.

6) Relay Mails via gmail.

Installed postfix and removed sendmail:

# yum install postfix
# yum remove sendmail

Install openssl and openssl-perl are installed so we can generate certificates and create SSL connections to GMail

# yum install openssl openssl-perl

Create a Certificate Authority (if you don’t already have one):

# cd /etc/pki/tls/misc
# ./CA.pl -newca

You will be prompted for the file name (just hit Enter). Then you will be asked for a PEM pass phrase, which you need to remember. You can fill out the Country Name, State or Province Name, Locality Name, Organization Name, and Organizational Unit Name to your liking (or take the defaults). You need to remember the Organization Name (if you changed it) as it must match one in a key we create later. For the Common Name, fill in “CA” (without quotes). Take defaults for everything else and when prompted to enter the pass phrase you need to enter the same one you did above.

Create a client key that is sent to GMail to start the SSL encryption:

# cd /etc/pki/tls
# mkdir gmail_relay
# cd gmail_relay
# openssl genrsa -out server.key 1024
# openssl req -new -key server.key -out server.csr
# openssl ca -out server.pem -infiles server.csr

Add the following to the bottom of the file /etc/postfix/main.cf

#### GMail SSL SMTP Relay
relayhost = [smtp.gmail.com]:587

#auth
smtp_sasl_auth_enable=yes
smtp_sasl_password_maps = hash:/etc/postfix/sasl_passwd

#tls
smtp_use_tls = yes
smtp_sasl_security_options = noanonymous
smtp_sasl_tls_security_options = noanonymous
smtp_tls_note_starttls_offer = yes
tls_random_source = dev:/dev/urandom
smtp_tls_scert_verifydepth = 5
smtp_tls_key_file=/etc/pki/tls/gmail_relay/server.key
smtp_tls_cert_file=/etc/pki/tls/gmail_relay/server.pem
smtpd_tls_ask_ccert = yes
smtpd_tls_req_ccert =no
smtp_tls_enforce_peername = no

Create /etc/postfix/sasl_passwd file with your GMail login credentials that looks like below:

gmail-smtp.l.google.com user@gmail.com:password
smtp.gmail.com user@gmail.com:password

Create /etc/postfix/sasl_passwd.db file using the following command.
postmap hash:/etc/postfix/sasl_passwd

/etc/init.d/postfix restart

7) Fetch mails from gmail using fetchmail.

# vi /home/user/.fetchmailrc

Put a cron to download mails every minute.
#crontab -e
*/1 * * * * user fetchmail -k &> /dev/null

8) Login to webmail and check mails :)

Monday, February 6, 2012

Installing Oracle Developer 6i release 2 on Fedora 10(d2k6irelease2.tar)

Steps to install forms6i in Linux.

1)Download the following files.

a) d2k6irelease2.tar

http://download.oracle.com/otn/linux/forms/d2k6irelease2.tar

b) openmotif-2.1.30-4_MLI.i386.rpm
and openmotif-devel-2.1.30-4_MLI.i386.rpm

ftp://ftp.pbone.net/mirror/ftp.gwdg.de/pub/linux/misc/metrolink/openmotif/2.1.30-4/openmotif-2.1.30-4_MLI.i386.rpm

ftp://ftp.pbone.net/mirror/ftp.gwdg.de/pub/linux/misc/metrolink/openmotif/2.1.30-4/openmotif-devel-2.1.30-4_MLI.i386.rpm


2)Create an user “oradev” and group “dba”

#groupadd dba
#useradd oradev -g dba
#psswd oradev
(Enter the passwork you wish to give here)


3) Copy d2k6irelease2.tar file to “/home/oradev/” and extract it.
#cp -r /home/youruser/Download/d2k6irelease2.tar /home/oradev/
#tar -xvf d2k6irelease2.tar

4)If /etc/oratab already exist, please rename it.
#mv /etc/oratab /etc/oratab.bck

5) Check whether these libraries exist in /usr/X11R6/lib
# locate libX11.so
# locate libX11.so
# locate libXext.so
# locate libXmu.so
# locate libXp.so
# locate libXpm.so
# locate libXt.so
# locate libXtst.so
#locate libXm.a
# locate libXt.a
# locate libX11.a

If these libraries are not install or installed in another location, please install it and create and symbolic link to /usr/X11R6/lib/
# ln -s /usr/lib/libXmu.so /usr/X11R6/lib/

6)change the directory to /home/oradev/orainst/, the installation should start from this folder. Execute the following command to start installation.
#cd /home/oradev/orainst/
#./orainst

7)This will show a GUI for installing Forms6i

a) Select the installation method:Default Install

b)Select the Installer activity: Install, Upgrade, or De-Install Software

c) Select the Installer option: Install New Product - Do Not Create DB Objects

d) Environment Variables :Confirm, change, or enter values for the environment variables
set ORACLE_BASE:as /home/oradev/app and ORACLE_HOME=/home/oradev/app/oracle/product/8.0.5

e) Software Asset Manager : Oracle Forms Server and Forms and Oracle Reports Server and Reports.
To Select these 2 option, keep the curser to the position Oracle Forms Server and Forms and press enter, move down the curser to Oracle Reports Server and Reports and press enter. After doing this press letter 'r' and then press letter 'i'.

f) Please enter the directory where the X-Windows libraries : /usr/X11R6/lib/

g)Please enter the directory where the MOTIF library (libXm.a) is located: /usr/X11R6/lib/

h) GUI choice : check all items:

i)In the Component Selection (for Forms), select all the items except the first:

[] Form Server for Web deployment

[X] Motif Bitmapped Interface

[X] Designer and Generater Executables

[X] Character Mode Interface

Click on OK.



j)In the Component Selection (for Reports), select all the items except the first:

[] Reports Multitier Server for Web deployment

[X] Motif Bitmapped Interface

[X] Report Designer and Converter Executables

[X] Character Mode Interface

Click on OK.


8)After installation correct the tnsnames.ora file.

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.246)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = PLSExtProc)
)
)



orcl=
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)

9)Set environment parameters correctly. Add these entries to .bash_profile file.

export PATH=/usr/lib/qt-3.3/bin:/usr/kerberos/bin:/usr/lib/ccache:/usr/local/bin:
/usr/bin:/bin:/usr/local/sbin:/usr/sbin:/sbin:/home/oradev/bin:/home/oradev/app/oracle/product/8.0.5/bin

export ORACLE_HOME=/home/oradev/app/oracle/product/8.0.5

export LD_LIBRARY_PATH=${ORACLE_HOME}/lib:/usr/X11R6/lib:
/home/oradev/app/oracle/product/8.0.5/network/jre11/lib/linux/native_threads:/usr/lib/jvm/java-1.6.0-openjdk-1.6.0.0/jre/lib/i386

export ORACLE_TERM=vt220

10) To open the file from linux PC, please browse the binary path f60runm. Now onwards you can open the fmx file without any issue