Diameter

I have to test the diameter application and its commands , i have tried with open source tool seagull for unbuntu for testing .Initially i have downloaded the source package and tried to compile but unfortunatly i coundnt succeed to make that work in ubuntu and it works for windows if you want test the diameter applicaiton using windows environment it works. Seagull open source testing tool http://gull.sourceforge.net/

Some Billing tutorial sites

Hi folks this post is exclusive about the sites posting the telecommunication billing information so that will be very useful to easily get more information about the telecomm domain. Some sites: http://www.billingworld.com/ http://www.billingoss.com/telecom-billing.htm

Sendmail with attachment to multiple recepients i.e Mutiple TO Address

 #!/usr/bin/ksh

# Address used to be A@B.com,B@C.com,D@E.com
/usr/sbin/sendmail $EMAIL1,$EMAIL2,$EMAIL3 << END_MAIL
From:
To: $EMAIL1,$EMAIL2,$EMAIL3
Subject: HI

$MSG


Regards,

`uuencode ${DIR}/attachment.gz  changedfilename.gz 2>/dev/null`

END_MAIL

exit 0

Hibernet tutorials

Hibernet tutorial for the beginners

Hibernet vedio tutorials
click here for Hibernet tutorial

CAMEL

Visit the below site for basic understanding of camel application
http://www.3g4g.co.uk/Tutorial/ZG/zg_camel.html

RFC

 RFC's : Go through the link published below.

1.FTP: http://www.ietf.org/rfc/rfc0959.txts

Send Email from Command line Using ssmtp in linux

SSmtp command line email configuration:

Excellent Video tutorial to send mail from command prompt using ssmtp in linux environment
http://www.youtube.com/watch?v=QT-6NbjqjDM

Sendmail configuration:

Follow the below steps:

The SMART_HOST macro allows you to specify the host that should relay all outgoing mail that you are unable to deliver directly, and the mail transport protocol to use to talk to it.

Open your configuration file:# vi /etc/mail/sendmail.mc

Append or modify macro that read as follows :define(`SMART_HOST',`smtp.net4india.com')Replace smtp.net4india.com with your actual smtp server address.

If line contains word, dnl remove the dnl word. Regenerate a new sendmail.cf config file with m4 command:# m4 /etc/mail/sendmail.mc > /etc/mail/sendmail.cf


Restart sendmail service:# /etc/init.d/sendmail restart





Ksh script for sending the mail with the attachment


i have written the script which is used to sql query and retrieve the values and generate the  .csv file and mail the .csv using senmail utility

#!/usr/bin/ksh

#### Set the Path################################
export ORACLE_HOME=/usr/lib/oracle/xe/app/oracle/product/10.2.0/server
export PATH=$PATH:$ORACLE_HOME/bin

###### N out report format####################
N_Report=N_`date +%y_%m_%d_%H_%M_%S`

##### sql report for n#########oracle Express edition SID=xe###############
sqlplus -s Username/password@SID<
SET FEEDBACK OFF;
SET ECHO OFF;
SET COLSEP '';
SET PAGESIZE 0;
SET LINESIZE 300;

-- header not needed
spool /home/usr/${N_Report}.csv

select * from tablename ;

spool off

commit;
quit;
!

Dir_N=/home/usr/${N_Report}.csv

(uuencode $Dir_N $N_Report.csv ; echo "N Report") | mail -s "N report" -t xyz@xyz.com

please post your comments if any one needs more clarity for the above.