ProForm 5.0 White Centrex Technické informace

p Mizu Softswitch Administrator’s Guide VoIP Server documentation Mizu Server is a software soft switch solution running on Microsoft Windows p

5.67. How to setup a new virtual server instance ...

tb_invoice_entries: Id: autoincrement database primary key Invoiceid: foreign key to tb_invoices datum: record insert date description: product descr

Chargecards can be generated from Billing -> Pincodes CallingCards: There is a special user type called “callingcards” but any usual user can act

Iongate www.iongate.com iTransact RediCharge HTML www.itransact.com LinkPoint www.linkpoint.com Merchant Anywhere www.merchantanywhere.com Merchant Pa

Sterling www.sterlingpayment.com SurePay / YourPay www.surepay.com TransFirst eLink www.transfirst.com TrustCommerce www.trustcommerce.com USA ePay w

4.5.12. Promotions • First X seconds are free You might create packets when the first few seconds are not billied. Just use the “Free amount” option

4.5.13. Notes Call forward billing: 2 cdr record will be generated. A->B and B->C Call forward from IVR: one cdr will be generated. Whether we

0-no filter: allow all numbers 1-allow blacklist „sure” level: 0,1 and 2 (tb_blacklist) 2- allow blacklist „sure” level: 0 and 1 3-allow o

The “chargecode” string in the message will be replaced with a valid code if found. You can introduce delays by inserting ‘#’ characters i

Status Filter: Existing lines: List only current running channels. (this doesn’t mean that the channel is workable. We list all channels who have rep

Active and not used: Working simcard without calls on it Monitor: simcards grouped on gsm channels. You may detect missing “holes” very easily by scro

5.100. How to rewrite caller/called numbers ...

Packet: the type of the SIM Card TodaySpeachLength: the number of active minutes on the current simcard since 00:00 ThisMonthSpeachLength: the number

AllCallCount: all call attempts on the simcard until now AllWrongCalls: all wrong calls on the simcard until now (speech length below the predefined v

4.6.5. SIMCards Same as “GSM Channels”. See section 4.2.2 The first field will show the status of the simcard (Monitor). The most frequently used val

Note: dialing, ringing and call ending messages may not be shown in the monitor depending from the gsm gateway configuration. If the “sendallstatus”

4.6.11. SIM Bank In the SIM Bank form you can monitor the sim flying activity. 4.7. Other -MManage 4.7.1. Configurations Global system configuration

The following config settings are defined: Category Key Description CallCenter allowdbcalls Allow calls from database in MAgent CallCenter allowm

CallCenter maxrecalltrycount max attemt of REcalls for a client CallCenter mobileratio_08_12 percent of mobile calls in the specified period [1-100] c

license CAN_hash323 default license (will have no effect if you change it here) license CAN_hassimbank default license (will have no effect if you cha

licensecfg hassip modules to load (has effect only if not prohibited by builtin license restriction) licensecfg maxallusers limitations (has effect on

settings checkcallerids wich calls are to be checked on the selfcheck thread (useful if you have wrong traffic senders) settings checkcputime if cputi

1. Introduction About This document provides an overall technical description of Mizu VoIP platform. For non technical user guides please check out

settings dbmaint_backupdbdir database backup directory settings dbmaint_backupdbnetworkdir database backup directory path (if the database engine is l

settings faxsuffix fax sender configuration (email to fax server) settings faxuser fax sender configuration (email to fax server) settings filelogleve

settings maxpriceperminute will alarm if providerprice is bigger settings maxrecdiff recorded voice stereo sync in msec settings maxrecdiff2 recorded

settings ppriority 0=low settings removetrailinghash remove # when routing settings restartatnight set to true if you want a reset every night setting

settings voicebackupdir where to store a backup of recorded conversations settings weekendispeak peaktime settings for billing and routing settings we

SimPlatform gkrstifnotconnected restart the gk if not connected SimPlatform gsmgwport port for the gsm gateways SimPlatform gsminccalled forward incom

SIPSettings CanAcceptLocalIp Can call from 127.0.0.1 SipSettings cancutsipnumbers packet dialplan for sipnumbers SipSettings canmove 0=not allowed Sip

SipSettings maxstatchangepermin max allowed enduser status changes/60 sec (slower if exceed) SIPSettings MAXSUBSMSGCOUNT max subsequent messages befor

SipSettings supportlist privacy SIPSettings traceep1 user id SIPSettings traceep2 user id SipSettings udpkeepalive send keepalive messages SIPSettings

4.7.4. Test Call H323 test calls can be done here. 4.7.5. Rfile system Upload/download files from gateways. 4.7.6. Rdesktop Use this form to login d

1.2. Features

4.7.9. Phone Numbers Numbers allocated by authorities. You may add new endusers with telnumbers set to a free number from this database. Don’t forgot

o Ring a phone number o Restart the VoIP service o Restart the SQL service o Reboot the server 4.8. Gateway Configuration Skip this section if yo

simcard3= Simchange settings explanation: format: simchange1= 2004.03.05/13:00:00 - 2004.03.07/13:00:00 - 8936302403070132426 (from date - to date)

onlyg72x=1 //useserver if false, then don't connect to the simserver. will save cdr records to file. may be limited due to licensing options uses

record=0 //what kind of logs to send to server (1-5) tracetoserver=1 //process priority priority=1 //ModemControllPort used only with hw 1.0 controlpo

//wrong call criteria wrongcallmaxduration=30 //call duration limit in sec (defaults to 3 hour -10800 sec) callimit=10800 //max time to wait for ring

faststart=1 //used for debug purposes ringtime=6000 //desktop access desktoppwd= //if set, then will try to autologin loginpwd= //if we want to play a

nosmsread=0 //socket read/write timeout and system checks operations modifier. default=4 timeoutmultiplier=4 //backup server address serverip2= //rout

inccalls=1 //file to play when requesting number to call on dtmf (when incalls is 4). "please enter phone number to forward call" playdtmfre

MAXPCRESTARTIVAL= //max time to wait for watchdog reset. defaults to 1000*60*20 msec MUSTRECEIVEOKIVAL= 4.8.5. Other settings //at commands sent onl

1.2.1. Hosting  MS-SQL backend (Express or Full versions)  Ethernet 10/100/1000 Base-T  Static IP, PPPoE (DSL or cable modem), DialUpISDN,VPN 

3. When incalls is set to 2 -call will be forwarded to the number specified by the “forwardnum“ option in the GSM network. -the simcards must support

Each simcards can have it’s own GSM engine (in other gsm gateway the engines are used by more simcards) GSM Cell Lock Because Mizu GSM Gateways use on

For advanced gateways and servers the following port ports must be forwarded also: -TCP: 1720 (default h323 GK signaling) -UDP: 5060 (default SI

4.9.3. Scripts Every campaign can have different operator instructions. These instructions can be defined in this form. For every step (question) the

id: autoincrement PK questionid: answer belongs to this question ordernum: display order answer: the answer text alias: will be stored as answer (usu

set the datainputtype to “Run” specify application name and parameters in the “Command” field. keywords can be used as part of command. the following

Any character that does not appear in the preceding table can appear in the first part of the mask as a literal character. Literal characters must be

all script answers (including data input) will be saved to tb_ccscript_processing list answers will be separated by semicolon ; grid answer will be s

-Next Client: force jump to next client (will hang-up the current call if any) -Recall: set client for later recall -Reject: will set the rejected fla

Note: call record must reach a completition question to be valid in quota calculations 4.9.6. Presentations Used to store the different presentation l

 CLIP/CLIR  DTMF generation  Call-Forward on out-of-service  Codec transcoding  Advanced statistics support  NAT traversal of signaling 

-City (string) -Age (number) -Passport (0 if unknown, 1 if no or 2 if yes) -Married (0 if unknown, 1 if no or 2 if yes) -Sex (0 if unknown, 1 if no

comment: any comment (can be filled by operators) randorder: deprecated numstatus: wich number is present. 0=both are missing,1=only landline,2=only

callbackivr: play special messgae (callback.wav) if no operator found or ring timeout expired callbackhandling: 0=dropp calls, 1=forward to the same U

4.9.11. Predictive dialer To restrict the operator wait times, the calls can be prepared on the server side and dropped to operators when they are wai

- Waituntillconnected: if set to false, than will dropp started call when no more operator waiting (no more "No free operator on predective"

2. By specifying a callbacknumber and setting the callbackhandling option. 3. Handling by the IVR 4. Make incoming campaigns Incoming callers (cli

other=add to the specified campaign (campaign id) Handlingincoming: 0=not handled 1=allow to search the current campaingn for the incomig number

scriptquestions => tb_ccscripts scriptanswers => tb_ccscript_answers quota(s) => tb_ccquotas The following keywords are defined: -all datab

storedani dtmfstoredtrimmed opname currdatetime currdate currdatetimesql currtime currweekday curryear currmonth currday currhour currmin currsec call

currency centname disccausetextex otherpartyname otherpartydisplayname otherpartyfullname Embedding controls in texts: Basic: Keyword embedded in sq

 RFC 3428 Session Initiation Protocol (SIP) Extension for Instant Messaging  RFC 1889 RTP: A Transport for Real-Time Applications  RFC 2190 RT

4.10.2. Manual Call Simple VoIP client window where the operator are free to make calls to any number

4.10.3. Calls from database Call to any client presented in the central database. 4.10.4. Automatic calls Will handle calls automatically if the oper

4.11.1. Call Rerouting Failed calls (error code, no answer) will be rerouted automatically to the next device according to routing preferences. 4.11.2

Usually In-Band DTMF are supported by any vendors in endpoint devices but will not be parsed on IVR servers because of high computation requirements

4.11.7. Call Transfer -The standard sip calltransfer protocol is supported (REFER, replaces methods) using the transfer button on sip phones, but bec

4.11.9. Call Waiting and queuing Call waiting scenarios are supported. Need to be implemented in UA to work. Group hunting and queuing are implemented

The exact location will be: serverftpvoice\databasename\currentday\voice.xxx A separate backup can be created in the directory specified by the “voice

For skill based callcenters you can use the “Forward to Group” or the “Forward to SQL” actions. Voicemail can be implemented by the “record” actions.

 fromport  rtprecport  callertype  callstate  cc_clientid  cc_ccid Technical description: On routing if calleduser.ivrid > 0 than set

iscallback  1=act based on anumberhandling (default - connect to the ivr if not authenticated as enduser, otherwise callback immediately)  2=con

• Packet saver technology 1.2.4. IP Centrex  Call Forward All/Busy/No Answer  Caller ID  RingGrouops  Call Return  Call Waiting  Call

-CallingCardAuthentication: (Will check the pincode in the database). On success go to next item, on fail play a prompt to try again -Play File: P

The billed user will be the logged in user. The p2p command has 3 parameters. A number, B number and IVR id (optional). 2 CDR records are generated fo

SMS messages billing can be specified by selecting SMS as the service type on the Price setup form. The “smstime” is set to 60 sec by default. If no p

general username password number1, number2 pincode number number pincode b (pincode based authentication. the A number will be called back) general

Pragma: no-cache Accept: Referer: 99.99.99.99 Content-Length: 157 Content-Type: application/x-www-form-urlencoded api_id=3144985&from=3611111111&

-initiate payments -endusers: recharge -endusers: setup call forwarding -endusers: initiate phone to phone calls and callbacks -enduser: send SMS -end

Then this top resellers can login on the web interface and create their own billing and add sub resellers and/or child endusers. Reseller can create a

Credit from the reseller account is deducted when he add credit for the users (create new users with some default credit, increase user credit, genera

1. The reseller can generate PIN codes regardless of the balance in the account. When a call is made, both the end user and the reseller are charged.

4.12.9. Mobile dialers With the “all in one” platform the mizutech support will send your own mobile client build (hardcoded with your server address

 Statistic generation: customer statistics, operator statistics, call related statistics, work time statistics, campaign statistics  Campaign crea

minstayonce: minimum time to stay (not fly) at once maxstayonce: maximum time to stay (not fly) at once minflydeep: minimum gateway count to fly troug

flyto=ip/engine/simpos/simid //template flyto=local/local/2/999999 //local simpos flyto=local/2/2/99999999 //other engine flyto=1.1.1.1/2/3/99999999

To enable h323-SIP conversion the runsipproxy global config values must be set to true. Local and LAN IP’s should be also enabled. These are can be en

1. replace the atarongk file with the _dbg version 2. change the "sipcommand" global config option to "vsip -vvvvvvvv -l siplog.dat&

-strong but slower encryption mode (when usequickencryption is false) Encryption can be enabled/disabled with the “useencryption” global configuratio

Checkmaxlines = 0 ? Checkmaxlinetb=0 ? Maxsessionspeechlen= 1000UL * 60UL * 60UL * 6UL Ringtimeout=120 MAXEPCOUNTTRESHOLD=30000 MAXSUBSMSGCOUNT=99999

Set the udptunnelsamesock congig option to at least 1. (udptunnelsamesock = 0; //0=no,1=if received so, 2=yes). This will tunnel only encrypted sessio

5.4. How can I make test calls? 1. simply right click on a channel (“Simcards” form) and select the “Test call” option 2. or use one of the voip clien

a) Restart the server. b) Call the administrator. 5.9. Calls in „routing” status 1. If all calls are in routing status, then restart the gatewa

5.15. Too many wrong calls on a simpacket (low ASR/ACL) 1. Check disconnect reasons 2. Check if gateway is working ok (another type of simcards on tha

 Automatic capacity rebalancing Remote Linked Servers  Automatic channel management  Number portability support  User authentication by usern

3. No calls Check gw,sim and packet priority Check the routing table 4. Wrong statistics (ASR/ACL) Check disconnect reasons Check if simcard is not bl

5.28. How to restart the server service MManage->Administration->Server Console->Connect and send the „servicerst” command 5.29. How to res

1. Start GWTest and switch to the preffered channel/simpos 2. „login” with: AT+CPIN=xxxx (where xxxx is the original pin code) 3. Disable pin code re

5.41. How to set up basic billing? On the “Price Setup” form add a new “Invoice and statistics” entry. Then you can add packets to it, which will defi

5.47. H323 signaling problems Check your firewalls. Check Gateway Configuration: onlyg7x, connectwithmedia, enableh245tuneling, faststart. 5.48. How t

3. If the caller is blocked (e.g. DOS attack protection), then call will be silently dropped 4. Caller authorization (by source IP address, username/p

simchange4= 6/00:00:00 - 7/24:00:00 - 8936302403070132426 (Saturday and Sunday) there is a priority order from top to bottom (simchange1, simcha

For simcards you can setup the VAT value in the Packet options (“VAT” editbox). If you set the “convertsimcredittonovat” global configuration options

5.63. Abbreviations ASR: average success ratio (percent of the connected calls) ACD: average call duration. The same as ACL (ACD: Automatic Call Distr

-local DID number: normal access numbers. Usually you will have separate DID numbers for different regions to minimize enduser costs -callback: DID o

1. Introduction ...

 Invoice generation in different formats, PDF generation, email scheduler and invoice printing  Complete call rating & accounting services for

2. Open the printer “Options” Form This can be achieved -when you save invoices as PDF first time or -from Start Menu -> Programs -> PDF Crea

16. allocate numbers in the mainserver for the new virtserver instance (callback numbers) 17. start the new virtual server 18. make a testcall 19. che

MAXALLUSERS: to restrict the total number of users and devices (including endusers,gateways, etc) Devices behind this limit will be disabled (calls

5.71. Redirect or forward sessions to other domains Routing to other domain can be restricted by the “fwdtootherdomains” global config setting. This

The defined commission percent will be calculated for the profit or for the enduserprice. This behavior can be set by the “salescomissionfromprofit”

SU1=unknown SS1=trying (scan success 1: the last status was: trying) -2 SS2=progress (scan success 2: the last status was: progress) -3 SS

nameX=MyPlugin cmdX=MyPlugin.exe X is a number starting from 0 to MAXPLUGINCOUNT The MManage will pass the database access parameters in the comm

 specificip, specificaddr //any ip or ip:port Examples: to restrict the target address for a sipuser you don’t allow local and lan ip: private

prefixrewritestr: the original prefix prefixrewritefrom: keep from prefixrewriteto: inserted string for example to handle the hungarian roaming prefix

-don’t install any virus scanner (it is meaningless) -choose a strong password for your OS accounts (especially for the Administrator account) -choose

 Backup Gatekeeper capability  Gatekeeper clustering support (neighbors, parent/child, alternates) 1.2.11. VoIP-GSM GSM components are not includ

-passwords are stored in clear text in the user table by default to ease the support (md5 checksum option is also available). Make sure that your data

Full Cone NAT A full cone NAT is a solution, where all requests from the same internal IP address and port are mapped to the same external IP addres

5.91. How to change the database username/password The auto installer will use the “sa” username with “srEgtknj34f” password by default. Install the

Increase REGISTERIVAL,upperexpire, userofflinemin, upperexpiremin Set allowforkforsignaling to 0 Set usertpmutex to false Set allowlogloss to 2 Increa

SetCfgStr("settings","priorityboost","false"); SetCfgStr("settings","wrongnumcache","10

5.94. How to remove the 3 digit techprefix system wide setting This might be required for old server versions (before 2009) to convert to the latest d

For unified pricing you can use the “smsprice” and the “smstime”. (in this case all sms messages will be billed with the same price, regardless of the

(select id from tb_groups where name = 'testgroup'), 1, id from tb_users where username like '%111%' --select users from this gro

If the techprefix is „-2”, then the original techprefix will be inserted in cdr record (but not forwarded). If the techprefix is empty, then only the

For more control over the A number you can use the prefix rules form or manually edit the v_check_pxrules stored procedure. Prefixed can be also use

 SIM server interworking  GSM cell selection and locking  DTMF send/receive  CLI restriction  SIM Rerouting  Locking to a given gsm cell 

-this relationship can be analyzed using the “Ownerships” form -make sure that you have a public reseller price listing (enduser costs) -reseller will

- set the " allowanonymouscaller" global config option to "true" - set the " allowanonymoususers " global config option

Window Server - Binding Web Interface to port 80 when IIS is running By default IIS listens on all IP addresses on port 80, assigned to a PC. So what

1 channel bandwidth: 40 kbits = 13 GB / month 10 channel bandwidth: 400 kbits = 130 GB / month 100 channel: 4 mbits = 1300 GB / month (1.3 TB) 10

The mizuupdate.txt will be checked in the following circumstances: If the AUTOUPDATEMODE is set to 1 (rare checks, this is the default setting): -at l

Make sure that your paypal account is “verified” before switching to production. For this you might have to send some documents to PayPal like your Dr

Currency: paypal currency Transactionid: unique id for all transactions Stage: 0=unknown,1=started,2=notification received,4=verified and applied,5=f

Set the “haslinkedaccounts” global config option to “true” for this to work. 5.107. Server clustering You can setup multiple servers with one (cluste

avg(case when b.realduration > 0 then b.realduration else null end) as 'ACD (sec)' FROM tb_cdrs b WITH(NOLOCK) WHERE b.datum >= :fro

else null end ) as 'QUALITY (0 = worst,10=best)' FROM tb_cdrs b WITH(NOLOCK) WHERE b.datum >= GETDATE()-1 and b.realduration > 0 GR

 License management  Distributed absolute fault tolerant system  External system supervisor service (email and sms alerts, watchdog can restart

5.109. How to obtain geolocation and advanced call quality statistics 1. Import GeoInfo database with MManage -> Tools menu -> Server setup -&g

i.srvlosspercent < 13 and i.clientlosspercent < 13 and i.totallosspercent < 13 and (i.srvlost < i.srvsent/6) ) then 8 when realdura

( (i.srvsent >= 0 and i.srvsent < i.srvrec/10) or (i.srvrec >= 0 and i.srvrec < i.srvsent/10) or i.srvlosspercent > 50 or i.clien

CAST(mstr.physical_name AS VARCHAR(72)) AS 'File', stats.num_of_reads, stats.num_of_bytes_read/1000000 as &

In the mizuserver.ini leave the [database] settings as the main mizuserver.ini and change the [webportal] settings as follows: mainportalreseller=RES

from trace12 group by applicationname order by sum(cpu) desc select sum(duration), applicationname from trace12 group by applicationname order by s

5.115. Pricing speedup If you have (or will plan to add) many prefix entries for multiple billing packets than you should consider to change to the i

-00, 0 and + prefixes are not allowed in the billing (this should be avoided anyway) -instead of * you should use -1 In this mode the _int version o

peaktimebegin or peaktimebegintr: peaktime start hour. Default is 9. peaktimeend or peaktimeendtr: peaktime end hour. Default is 19. weekendispeak: tr

,'RA MANAGER') order by batch_duration desc declare @spid int , @stmt_start int , @stmt_end int , @sql_hand

 Billing module  Balance module  Real Time Capacity check  Ability to insert queries directly into the database  Blacklist filtering  Self

OPEN DBCursor; DECLARE @DBName VARCHAR(200) = ''; FETCH NEXT FROM DBCursor INTO @DBName; WHILE @@FETCH_STATUS = 0 BEGIN DECLAR

http://blogs.msdn.com/b/ntdebugging/archive/2007/07/05/desktop-heap-part-2.aspx 5.121. How to rewrite SMS number prefix Create a stored procedure na

5.124. Enable session-timer With session timers (RFC 4028) you can prevent orphaned sessions (hung calls). Session timers are not enforced by default

12: can’t add resellers 30: normal rights (default) 40: increased rights 60: full rights 5.126. Server ini file The database connection settings are

You just have to upload the prices. To charge only connected calls, you have to apply the billing packet for B-leg only. You can set this option on t

The Mizu Soft switch (Server) is the “brain” of the system. Depending on your needs, you can connect as many gateways as you want. The soft switch is

2.1.10. Watchdog service This NT service can automatically detect critical service problems and restart the VoIP server, the SQL database or the OS.

2.1.16. Other components server service: the brain of the system H323 GK: standard H323 gatekeeper SIP Server: sip stack HTTP interface: enduser/resel

You can give the VPC for any of your partners. The partners can login to the VPC with the username and password configured in the “Users and Devices”

3.2. Gateway quick setup Skip this chapter if you are not using VoIP-GSM gateways. In order to get a working system, here is a checklist which may he

2.1.14. Self-check and reporting ...

8. Set up the simcards. You can add simcards manually, but it’s easier to wait for them to register. Then you only have to modify its packets, owners

-and many others Since all data is stored in the SQL database, you have to protect only your database (the program directory can be recreated anytime

dbmaint_backuplevel: 0=no backups,1=daily,2=daily,monthly,weekly,3=hourly,daily,monthly,weekly,4=keep lots of files dbmaint_backupdbdir: local path (

3.5.6. Saving recorded voice Serverftpvoice: where to store recorded audio Serverftpdailydir: set to true to create separate directory for recorded v

if the backup server fails (the server behind the main server, with private ip) -connect to the main server with the remote desktop "root" a

At Source/ Database select the database that you want to back up. At Backup type select either full for full type of backup or differential, fo

Once the time and frequency of a given schedule is set the tasks from the left side of the window can be dragged and dropped in the field under t

Fee backup & FTP tools (for one single database): http://sqlbackupandftp.com/download/ http://www.sqlbackupmaster.com/download Script for SQL b

-Help files -Uninstall.exe -Other files (depending of your install package configuration, OS version, etc) When properly installed, you are ready to

Almost all tasks are done by selecting an item from the left side of the main form. For detailed descriptions please read below. In the Menu you ca

4.2.7. Capacity Check ...

From the File Menu you can save, print or export the selected form. Usual database operations are performed from the Edit Menu. In the Favorites Menu

Other datasources wich can be accessed by ADO or ODBC. 4.2. Monitoring 4.2.1. Current Calls

Currently running calls are listed here. Calls terminated on Mizu Gateways are displayed in separate list from other directions. You can filter the li

CDRC: call attempt count SL: speech length (duration in minutes) ASR: average success ratio (percent) ACL, ACD: average call length, average call du

You can make reports based on the following fields: -CDRC: number of calls -SL: speech length (all call duration) -ASR: the number of successfully a

-ASRB: average success ration, but here the “success” means a minimum amount of duration. Configurable in Settings Menu -> Thresholds Box -ACT: ave

Partner/Day: group by partner and day Partner/Hour: group by partner and hour Partner/Minute: : group by partner and minute Called Country: : group by

The most common reason codes are the followings: -SIP, Bye: normal SIP close code -SIP, CANCEL: the call was canceled by the caller (not connected ca

gwrestart restart the gateway process pcrestart restart the gateway (hardware) 4.2.10. Server Monitor Will connect to the server logport. The trace

4.1.12. Analyze You will get detailed system analysis in this module. Thus you can see through the system by only one mouse click. Malfunctions are c

4.5.2. Price List ...

Callenddate: first disconnect code or CANCEL/BYE received or sent Connectdate: first 200 OK received or ACK for 200 OK sent Connecttime: time elapsed

Mark (marker): for special CDR records: EMAIL (e-mail), SMS (sms), FAX (fax calls), FAIL (failowered), RER (rerouted), FWD (forwarded), TRANS (transf

Rtpsent and rtprec is 0 when media routing has failed (if we don’t route the media, or the terminating endpoint don’t send media info to us, the syste

If you need both to accept and sent traffic to another server (carrier) then you have to add it both as traffic sender and SIP server. Open the “User

 groups  For more flexibility you might use direct SQL queries against the “tb_users” table. You can list the users with the following filters: -

11: isdngw, (parentid is the gatewayowner) 12: sms, fax,email gateway 14: support users (can operate with MManage, has ftp account) 15: admin users (c

ShortTelnumber: sip short telnumber (for example if several users has the same BelongsToCompany field) DisplayName: how the user will be displayed. Ca

Postpaid: if the user will prepaid or postpaid PaymentMode: Check (0), Bank Tranfer (1), Cash (2), Else (3) ContractNumber: contract for end-users All

3= route rtp if both behind nat 4= route rtp if caller is behind nat 5= route rtp if called is behind nat 6= route rtp if any endpoint is behind nat

CurrCallCount: current running calls (usable for traffic senders) enablefakegw: if we don’t have capacity, we can route h323 calls to a fake gateway

4.7.10. To-do ...

autopriority: set by server. If the gateway is wrong, then we lower the priority until this time absolutepriority: if we set it greater then for other

Denyaddr: because the server will try to send the sip messages to all possibile addresses, sometime it will missroute. With this setting you can restr

selecting only one code. If set, than only one codec will be left in the sdp (plus the dtmf codecs). This will help, when the server answer to

Default users: Owner mycompany: template for owner

GsmGw LOCAL_GW: used for advanced gateways. IP=127.0.0.1 GsmGw NOGW: used when no route found. IP=1.2.3.4, isfake=1,realgw=0 GsmGw FBACKUPGW: used to

Password: sip password used in authentification CallerNumber: usually the same as username. If left as blank, then the server use the actual caller us

banned. For example if there are too much meaningless or not authenticated request from an IP address (probably the attacker), than that IP address wi

The server can authenticate the user based on the following methods:  ANI/CLI authentication: if the CLI is known and this method is allowed. A numb

When using the pin field based authentication, make sure that user has valid pin codes set in this field (when the users are automatically generated,

callmaxwait: max waittime allowed for operators between calls (for administrative purposes) enforcestrongauth: enforce authorization and strong passwo

4.10.5. Automatic software upgrades ...

4.4.3. Normalize numbers By default the server will "normalize" all numbers. This means that it will clean the numbers from garbage charact

normalizenumbers: how to normalize 0=no,1=basic,2=normal,3=more (hu/ro),4=extra default is 2 normalizecallednumbersnec: NEC normalisation (National D

country: country (2 chars) iec1,iec2,iec3: international escape codes countryprefix: default country prefix (country code) prefix1,prefix2,prefix3: na

More settings: forcedcallernidentity: user and global setting //0=no,1=default checks (best num; default),2=dbusername,3=dbsipnumber,4=b

user setting replace client->callernumber (controlled by config.identityrwmode) //config.identityrwmode = 2; //0=no rewrite, 1=basic, 2=con

global config option used only for callforward //config.replacecalleronforward = 9; //0=no (default),1=yes,2=yes with username as callername, 3=

4.4.6. Prefix rules You should instead use the “Rules” form mentioned above. You can rewrite prefixes before they arrive to the routing by entering y

Input parameters: @calledat TINYINT, /*1=first check, 2=after authentication, 3=before routing out, 4=after routing out*/ @protocoll TINYINT, /*0=SIP

sql help: sql tutorial: http://www.w3schools.com/SQL/sql_intro.asp stored procedures: http://msdn.microsoft.com/en-us/library/aa174792(SQL.80).a

4.4.8. Blacklisting List the blacklisted numbers on the selected time interval and direction. This query will generate high server load. Use it only i

4.12.12. Encryption and tunneling ...

In Caller Prefix, you can place only one prefix. Tech prefix can be empty string, asterisk (*) or 3 digit length number. Called prefix can be one pref

Routing Configurations Try to set up all routing rules and prioritizations using this form. Try to avoid prioritizations by gateways, simpackets or c

Caller “CanDial” setting is set to false Caller tb_users.enabledprefixes not match (‘*’ allow all numbers) Check if other traffic sender has the same

Called gateway and simcard absolutepriority Positive routing priority (deprioritze simpackets with negative routing priority -these are “emergency pac

Technical description: Call arrive from traffic sender or enduser via SIP or H323 Check if MAXCCALS restriction reached (licensing option). Drop if ye

To activate BRS based routing, the “brs_lcr” global configuration option have to be changed to 4 or 5. Then the routing will check both the pricing an

Fields have the following meanings: -Id: database identifier. Auto increment -Gateway: gateway id (called) -Direction: called prefix -QualityPercent

-MinPrice, MaxPrice: min-max prices/minute. set it to a very wrong price to that direction and the max value to a very good one. Calculate it with co

GatewayID: called gateway or sipproxy Direction: called direction (prefix) MaxSubsFail: if we get more wrong calls than MaxSubsFail we failover to the

Note: failowering will occur with increased thresholds (more slowly) if the priority between the routing directions (SIP servers) is more than 100. 4.

5.33. How to disable PIN request on GSM gateways ...

tb_portednumbers: id: autoincrement database primary key number: original (normalized) called (B) number providerpx: new prefix (for example instead o

Field descriptions: Title: the name of the invoice group

Schedule: how often the report will be generated DueIn: allowed time for payment in day (used only if the report is an invoice) Status: billing status

These directions will be checked in priority order on routing and billing ValidSince, ValidUntill: the pricelist may be applied only after a specifie

The following prices are calculated: -enduser cost: used for invoicing for costumers -provider cost: cost that needs to be paid for service operators

Money Precision: how many floating point digit would you like in money fields. Completion date: defaults to the end of filling period if not modified

Lastbilled: last time when the it was invoiced Description: any comment here 4.5.4. Currency Conversion You can set currency in 3 places: 1. -native

You can generate random prepaid codes here. Prepaid account can be charged over the website or by ivr: Website operation: -user authentication (tb_us

2: Peak 3: Offpeak 4: Weekday 5: Weekend 6: Offpeak and weekend 7: Evening 8: Night 9: Holiday 10: All times 11: Other Times (Rest) example: v_getpric

The following fields are defined: ID: autoincrement database primary key Type: 0=All or Recreate (technical) 1=Report 2=Proform 3=Advance 4=Invoice 5