July 2018 – Records And Memorys

July 29, 2018July 29, 2018

How to install and config vsftpd in centos 6

install

yum install vsfptd -y

1	yum install vsfptd -y

edit conf file

sudo nano /etc/vsftpd/vsftpd.conf

1	sudo nano /etc/vsftpd/vsftpd.conf

change below items to :

anonymous_enable=NO
local_enable=YES
local_umask=022
connect_from_port_20=NO
chroot_local_user=YES

anonymous_enable=NO

local_enable=YES

local_umask=022

connect_from_port_20=NO

chroot_local_user=YES

start ftp service

service vsftpd start

1	service vsftpd start

try to connect this ftp server , open browser and type :

ftp://IP of ftp server

1	ftp://IP of ftp server

get a reply of

your connection to this site is not private

1	your connection to this site is not private

then request I input username and password , I tried using root and the password for root, but that didn’t work.

July 24, 2018October 15, 2018

emulate CDRCatch to catch VMS txt CDR

Part 1 learn and compile exsisting

In MyExcel.cs , find a reference to

using Excel = Microsoft.Office.Interop.Excel;

1	using Excel = Microsoft.Office.Interop.Excel;

If really need this component ?

solution is :

Now this program can be compiled , When it is normally running on server 24 , the interface is this form :

Part 2 How to simulate a run-time environment

First , install filezilla server in local machine , set username , pwd ,and home folder
Second , create a sql server DB for test , here is all needed script

CreateDBSQL

Then , config connection string in catcher program
Create Catcher_VMS.cs for VMS cdr format
final the program can run normally .

Part 3 Code analyze

Catcher_InsertThread.cs only duty for insert cdr into db , cdr is come from

if (!m_CDRPool.TryDequeue(out cdr))

1	if (!m_CDRPool.TryDequeue(out cdr))

But , where m_CDRPool was EnQueue ? in Catcher.cs ‘s Worker() function , processcdr function do it .

Part 4 VMS side cdr format

here is the zip file : 20180718160119_09

in this file , exist such column of CDR :

com_id = 0 
ref_no = 'eb5fe71d-0644-46b6-bb1a-df431d3d7ea3-a363'    Y
in_call_time = '2018-07-18 15:59:41.961'       Y
out_call_time = '2018-07-18 15:59:42.010'
alert_time = '2018-07-18 15:59:42.022'
answer_time = '2018-07-18 15:59:47.047'       Y
release_time = '2018-07-18 16:01:19.055'      Y
call_type = '4' 
op_id = 'WHCTEST(IN)'             Y
b_pin = 'c2c_ws'                   
r_pin = 'c2c_ws' 
prov_id = '84' 
prov_area_code = ''
status_code = 408                  Y
cause_code = 102                   Y
error_code = 0
max_talk_len = 86400
talk_len = 92                          Y
exact_call_len = 98                    Y
first_disc = 'O'
final_release = 1 
called = '55556011234567'                Y
caller = '852446913'                     Y
to_called = '55556011234567'             Y
mod_called = '55556011234567'             Y
mod_caller = '852446913'                  Y
out_called = '332996011234567'            Y
out_caller = '852446913'                 Y
c_rpp_prof_name = ''
p_rpp_prof_name = ''
route_prof_name = ''
rm_area_code = ''
route_plan_name = '' 
period_plan = ''
a_call_hd = '2C3AA624'
a_sgn_call_id = '92494-19872@103.244.191.198'
a_node_id = 82
a_ptime = 20
a_codec = 0
a_loc_addr = '103.244.191.198'            Y
a_loc_port = 6000
a_rem_addr = '103.244.191.198'            Y
a_rem_port = 6001
a_is_answer = 1
a_rx_bytes = 0
a_rx_packets = 0 
b_call_hd = 'F01AF44D' 
b_sgn_call_id = 'ac7e8611-fa4b-494a-b303-9b9f5e1f5195-0xF01AF44D'
b_node_id = 84
b_ptime = 20
b_codec = 0
b_loc_addr = '103.244.191.198'
b_loc_port = 6001
b_rem_addr = '103.244.191.198'
b_rem_port = 6000
b_is_answer = 1
b_rx_bytes = 0
b_rx_packets = 0
upd_user = 'SWITCH'
upd_prog = 'SWITCH'
upd_date = getdate()
reserved1 = 'ALEG()IPS(103.244.191.198:5030)PVL(84)' 
reserved2 = 'BLEG()IPS(103.244.191.198:5090)'

com_id = 0

ref_no = 'eb5fe71d-0644-46b6-bb1a-df431d3d7ea3-a363' Y

in_call_time = '2018-07-18 15:59:41.961' Y

out_call_time = '2018-07-18 15:59:42.010'

alert_time = '2018-07-18 15:59:42.022'

answer_time = '2018-07-18 15:59:47.047' Y

release_time = '2018-07-18 16:01:19.055' Y

call_type = '4'

op_id = 'WHCTEST(IN)' Y

b_pin = 'c2c_ws'

r_pin = 'c2c_ws'

prov_id = '84'

prov_area_code = ''

status_code = 408 Y

cause_code = 102 Y

error_code = 0

max_talk_len = 86400

talk_len = 92 Y

exact_call_len = 98 Y

first_disc = 'O'

final_release = 1

called = '55556011234567' Y

caller = '852446913' Y

to_called = '55556011234567' Y

mod_called = '55556011234567' Y

mod_caller = '852446913' Y

out_called = '332996011234567' Y

out_caller = '852446913' Y

c_rpp_prof_name = ''

p_rpp_prof_name = ''

route_prof_name = ''

rm_area_code = ''

route_plan_name = ''

period_plan = ''

a_call_hd = '2C3AA624'

a_sgn_call_id = '92494-19872@103.244.191.198'

a_node_id = 82

a_ptime = 20

a_codec = 0

a_loc_addr = '103.244.191.198' Y

a_loc_port = 6000

a_rem_addr = '103.244.191.198' Y

a_rem_port = 6001

a_is_answer = 1

a_rx_bytes = 0

a_rx_packets = 0

b_call_hd = 'F01AF44D'

b_sgn_call_id = 'ac7e8611-fa4b-494a-b303-9b9f5e1f5195-0xF01AF44D'

b_node_id = 84

b_ptime = 20

b_codec = 0

b_loc_addr = '103.244.191.198'

b_loc_port = 6001

b_rem_addr = '103.244.191.198'

b_rem_port = 6000

b_is_answer = 1

b_rx_bytes = 0

b_rx_packets = 0

upd_user = 'SWITCH'

upd_prog = 'SWITCH'

upd_date = getdate()

reserved1 = 'ALEG()IPS(103.244.191.198:5030)PVL(84)'

reserved2 = 'BLEG()IPS(103.244.191.198:5090)'

next , look at how SH ‘s catcher deal with CDR file , it is in this function

Catcher_misc.cs ‘s

void ProcessCDR(int CDRID, string folder, string filename, int start_position, ref int end_position, ref int raw_cdr, ref int valid_cdr, ref int proc_cdr, ref int bad_cdr)

1	void ProcessCDR(int CDRID, string folder, string filename, int start_position, ref int end_position, ref int raw_cdr, ref int valid_cdr, ref int proc_cdr, ref int bad_cdr)

Part 5 Q&A

what CatcherName,CDRID,SwitchID mean ?

CatcherName is the name of catcherlist .

Switch mean each FTP server , it include

        public int DetailID;
        public string SwitchID;
        public string HostName;
        public string IPAddr;
        public string FTPUser;         // FTP indentify
        public string FTPPwd;
        public int FTPUsePassive;
        public string CDRFormatID;     // for this switch ,use which format
        public string CDRPath;      //cdr file store path
        public string Extension;    //what cdr file extension , txt or else
        public string CatcherID;    //correspond catch ID
        public string FilterID;     
        public double AlarmErrRate;   
        public string Email;
        public int CheckFTPInterval;
        public DateTime StartDate;
        public int Active;
        public int insert_thread;
        public int pool_size;

public int DetailID;

public string SwitchID;

public string HostName;

public string IPAddr;

public string FTPUser; // FTP indentify

public string FTPPwd;

public int FTPUsePassive;

public string CDRFormatID; // for this switch ,use which format

public string CDRPath; //cdr file store path

public string Extension; //what cdr file extension , txt or else

public string CatcherID; //correspond catch ID

public string FilterID;

public double AlarmErrRate;

public string Email;

public int CheckFTPInterval;

public DateTime StartDate;

public int Active;

public int insert_thread;

public int pool_size;

it is defined in Catch.cs ‘s worker function

int CDRID = 0;

1	int CDRID = 0;

and assigned from store procedure :

DBCommands.sp_Catcher_CreateFile(CatcherList.CatcherName, mConfig.SwitchID, mConfig.CDRPath, file.name, file_date, file_size, download_from, downloaded_size, DateTime.Now, speed, ref CDRID))

1	DBCommands.sp_Catcher_CreateFile(CatcherList.CatcherName, mConfig.SwitchID, mConfig.CDRPath, file.name, file_date, file_size, download_from, downloaded_size, DateTime.Now, speed, ref CDRID))

How to create a test FTP server on win 10
what is the purpose of catcher ‘s filter ?

Part 6 DB

CreateDBSQL

Appendix

Visual studio : expand all code —> Ctrl + M + P , Unexpand all code —> Ctrl + M + O
How to delete split container control : click the control , then press escape , then press delete key .
How to convert yyyy-MM-dd HH:mm:ss fff to datetime

cdr.SetupTime = DateTime.ParseExact(ss[64], "yyyy-MM-dd HH:mm:ss.fff", null);

1	cdr.SetupTime = DateTime.ParseExact(ss[64], "yyyy-MM-dd HH:mm:ss.fff", null);

See Also

TODO

———————————————– 2018-8-15

关闭窗口前提示：否则线程泄露

窗口版本号，日期

程序图标

VMS format 读到 go 的时候，跳过，不报错

设置连接串的地方

rateplan, help , about 去掉

右边2个listview设置固定时间刷新 — 10 分钟

Settings

local ftp server login : liuyang , piercing

July 19, 2018July 19, 2018

Use remote version override local existing one

git fetch --all

git fetch --all

git reset --hard origin/master

1	git reset --hard origin/master

reference from :

https://stackoverflow.com/questions/1125968/how-do-i-force-git-pull-to-overwrite-local-files

July 3, 2018July 18, 2018

Do not forget

2018-7-3 5:00PM

Yasser ask for CSL side prompt , i find in cctb1 host and send to him

file location is : cctb1 host ‘s C:\TelcoBridges\toolpack\setup\promptFiles , file name begin with CSL.

After check , yasser said it is sintel prompt for temp tesing , and he will ask CSL prompts for launching .

2018-7-3 9:00PM

salinda said SG site some tasks which should running on 0:00AM not working

after check , i find these tasks have stopped at 2018-6-27

so run this

select id,lastRunTime,nextRunTime from timeScheduler where nextRunTime > '2018-6-26' and nextRunTime < '2018-7-1'  order by nextRunTime

update timeScheduler set nextRunTime = '2018-7-4 00:02:00'
where nextRunTime > '2018-6-26' and nextRunTime < '2018-7-1'

select id,lastRunTime,nextRunTime from timeScheduler where nextRunTime > '2018-6-26' and nextRunTime < '2018-7-1' order by nextRunTime

update timeScheduler set nextRunTime = '2018-7-4 00:02:00'

where nextRunTime > '2018-6-26' and nextRunTime < '2018-7-1'

to re-enable them .

2018-7-4

CSL side have start to make UAT test , lam said yesterday them make a test call which A number is 639175883234 , but I do not find it in cctb1 ‘s log .

success config Globe—>csl reeidd callflow and success make a call talk to Kelvin

TODO: make call income from VMS199 also can call to csl (DONE)

2018-7-11

make sheypei ‘s change request

2018-7-18

ma’shao’fang will arrive today 9:00PM

July 3, 2018July 3, 2018

Asterisk v13 AMI Q&A

how to define AMI recv which event ?

in /etc/asterisk/manager.conf

change : read = cdr (prior request is : in cdr_manager.conf , set enabled = yes in the general section )

only read cdr event mean do not include such as :

Event: Newexten

Event: Newstate

Event: DialEnd …..

if want to check these event , the form should be : read = call,cdr

- Why in dispatched cdr event , duration not same with dest dialplan duration ?

Event: Cdr
Privilege: cdr,all
AccountCode:
Source: 85222930114
Destination: 100
DestinationContext: autodialer
CallerID: "" <85222930114>
Channel: SIP/astToCCTB1-00000b84
DestinationChannel:
LastApplication: Wait
LastData: 20
StartTime: 2018-07-03 14:23:23
AnswerTime: 2018-07-03 14:23:23
EndTime: 2018-07-03 14:23:50
Duration: 27
BillableSeconds: 27
Disposition: ANSWERED
AMAFlags: DOCUMENTATION
UniqueID: 1530598986.4924
UserField:

Event: Cdr

Privilege: cdr,all

AccountCode:

Source: 85222930114

Destination: 100

DestinationContext: autodialer

CallerID: "" <85222930114>

Channel: SIP/astToCCTB1-00000b84

DestinationChannel:

LastApplication: Wait

LastData: 20

StartTime: 2018-07-03 14:23:23

AnswerTime: 2018-07-03 14:23:23

EndTime: 2018-07-03 14:23:50

Duration: 27

BillableSeconds: 27

Disposition: ANSWERED

AMAFlags: DOCUMENTATION

UniqueID: 1530598986.4924

UserField:

in dest asterisk extensions.conf , I set :

exten => _631xxxxxxx,1,Wait(1)
exten => _631xxxxxxx,2,Answer()
exten => _631xxxxxxx,n,Wait(30)
;exten => _631xxxxxxx,n,Wait(${RAND(5,10)})
;exten => _631xxxxxxx,n,Playback(/var/lib/asterisk/sounds/CallTooMuch)
exten => _631xxxxxxx,n,Hangup()

exten => _631xxxxxxx,1,Wait(1)

exten => _631xxxxxxx,2,Answer()

exten => _631xxxxxxx,n,Wait(30)

;exten => _631xxxxxxx,n,Wait(${RAND(5,10)})

;exten => _631xxxxxxx,n,Playback(/var/lib/asterisk/sounds/CallTooMuch)

exten => _631xxxxxxx,n,Hangup()

So all the calls ‘s duration should be 30 sec , why the example is 27 sec ?

temp conclusion : Duration and BillableSeconds in Cdr event is not correct .

190 ‘s outgoing call why use “autodialer” dialplan ???

Because

                OriginateAction oc = new OriginateAction();
                oc.Async = true;         //very important

                oc.Context = @"autodialer";
                oc.Priority = "1";
                //oc.Channel = @"sip/astToTB/" + (initBNumber + i).ToString();

                initBNumber = initBNumber + 1;

                oc.Channel = @"sip/astToCCTB1/" + initBNumber.ToString();

                initANumber = initANumber + 1;

                if (initANumber >= 85222940000)
                {
                    initANumber = 85222930000;
                }


                oc.CallerId = initANumber.ToString();
                oc.Exten = "100";
                oc.Timeout = ORIGINATE_TIMEOUT;

OriginateAction oc = new OriginateAction();

oc.Async = true; //very important

oc.Context = @"autodialer";

oc.Priority = "1";

//oc.Channel = @"sip/astToTB/" + (initBNumber + i).ToString();

initBNumber = initBNumber + 1;

oc.Channel = @"sip/astToCCTB1/" + initBNumber.ToString();

initANumber = initANumber + 1;

if (initANumber >= 85222940000)

{

initANumber = 85222930000;

}

oc.CallerId = initANumber.ToString();

oc.Exten = "100";

oc.Timeout = ORIGINATE_TIMEOUT;