T.38 Fax Relay MGCP VG224 2851 and CUCM7.1.3

Working samples below. Location had issues with incoming while utilizing Fax Pass-through. Converted to T.38 Fax Relay and customer could then make neither in nor outbound faxes. After converting to T.38 Fax Relay had to remove mgcp modem passthrough voip redundancy.

Works great now.

2851 MGCP with PRI to PSTN snippet:

voice service voip
fax protocol t38 ls-redundancy 0 hs-redundancy 0 fallback cisco

!
ccm-manager fallback-mgcp
ccm-manager redundant-host 10.10.10.5
ccm-manager mgcp
ccm-manager fax protocol cisco
ccm-manager music-on-hold
ccm-manager config server 10.10.10.5
ccm-manager config
!
mgcp
mgcp call-agent 10.10.10.6 2427 service-type mgcp version 0.1
mgcp dtmf-relay voip codec all mode out-of-band
mgcp rtp unreachable timeout 1000 action notify
mgcp modem passthrough voip mode nse
mgcp package-capability rtp-package
mgcp package-capability sst-package
mgcp package-capability pre-package
mgcp default-package fxr-package
no mgcp package-capability res-package
no mgcp timer receive-rtcp
mgcp timer net-cont-test 3000
mgcp sdp simple
mgcp fax t38 ecm
no mgcp explicit hookstate
mgcp fax t38 gateway force
mgcp rtp payload-type g726r16 static
mgcp bind control source-interface GigabitEthernet0/0.10
mgcp bind media source-interface GigabitEthernet0/0.10
mgcp behavior g729-variants static-pt
!
mgcp profile default

VG224 MGCP snippet:

voice service voip
fax protocol t38 ls-redundancy 0 hs-redundancy 0 fallback cisco
!
ccm-manager redundant-host 10.10.10.5
ccm-manager mgcp
no ccm-manager fax protocol cisco
ccm-manager music-on-hold
ccm-manager config server 10.10.10.5
ccm-manager config
!
mgcp
mgcp call-agent 10.10.10.6 2427 service-type mgcp version 0.1
mgcp dtmf-relay voip codec all mode out-of-band
mgcp rtp unreachable timeout 1000 action notify
mgcp modem passthrough voip mode nse
mgcp package-capability rtp-package
mgcp package-capability sst-package
mgcp default-package fxr-package
no mgcp package-capability res-package
no mgcp timer receive-rtcp
mgcp timer net-cont-test 3000
mgcp sdp simple
mgcp fax t38 ecm
no mgcp explicit hookstate
mgcp fax t38 gateway force
mgcp rtp payload-type g726r16 static
!
mgcp profile default
!

Verify what MS-SQL version is running

Ultimately found at http://support.microsoft.com/default.aspx?scid=kb;en-us;q321185, here's how to identify what MS-SQL server version and service pack are running.

For example, executing the following in Query Analyzer:

SELECT SERVERPROPERTY('productversion'), SERVERPROPERTY ('productlevel'), SERVERPROPERTY ('edition')

returns

| 8.00.2282 | SP4 | Standard Edition |

This reflects SQL 2000 SP4.

Elegance

Elegance = Functionality / Complexity

Excel VBA convert character in string to position in alpahabet

If for some reason you need to convert a string of characters to their corresponding position in the alphabet, here's a dirty little sample of how to do it. The sub below takes the text in B6 and converts each character to a corresponding alphabetic position (i.e. A = 1, B = 2, etc.). It then goes so far as to add the associated integers and plops the sum in B7.

This was motivated by "attitude" equalling 100, while "hard work" only equals 98.

Have fun.

Sub mySub()

myString = UCase(Range("B6").Text)
myAlphabet = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
myValue = 0

For i = 0 To Len(myString) - 1

myStringChar = Mid(myString, i + 1, 1)

For j = 1 To 26

myChar = Mid(myAlphabet, j, 1)
myVal = Replace(myStringChar, myChar, j)
If IsNumeric(myVal) Then

myValue = myValue + CInt(myVal)
Exit For

End If

Next j

Next i

Range("B7").Value = myValue

End Sub

NETSH, DHCP and reservation options

Creating reservations in a Windows DHCP server is not difficult and each reservation can provide unique options to the associated host. Unfortunately, creating each reservation and then modifying the options from default can be time consuming and error prone.

You can use NETSH to display, add, modify and delete DHCP scopes, options, reservations and options unique to the reservations without a GUI.

The reservedoptionvalue is poorly documented but is your key. I would suggest creating a single accurate reservation via the GUI and then using NETSH dump dhcp > filename.txt to verify the command format on your server version.

For reference, or for those that don't have a server to validate against, here are some NETSH commands and associated notes:

# Add Scope 10.1.0.0 on server at 10.1.1.1

Dhcp Server 10.1.1.1 add scope 10.1.0.0 255.255.0.0 "Voice" "Voice DHCP"
Dhcp Server 10.1.1.1 Scope 10.1.0.0 set state 1

# Add IP range to the Scope 10.1.0.0 on Server 10.1.1.1

Dhcp Server 10.1.1.1 Scope 10.1.0.0 Add iprange 10.1.1.100 10.1.10.254

# Add router at 10.1.254.254 and TFTP Servers at 10.1.1.2 and 10.1.1.1 to the 10.1.0.0 scope on server 10.1.1.1

Dhcp Server 10.1.1.1 Scope 10.1.0.0 set optionvalue 3 IPADDRESS "10.1.254.254"
Dhcp Server 10.1.1.1 Scope 10.1.0.0 set optionvalue 150 IPADDRESS "10.1.1.2" "10.1.1.1"

# Add a reservation to the scope with IP 10.1.9.1 and MAC 001122334455
# Add a TFTP Servers at 10.1.1.12 and 10.1.1.11 to the 10.1.9.1 reservation
# Add a Router at 10.1.254.254 to the 10.1.9.1 reservation

Dhcp Server 10.1.1.1 Scope 10.1.0.0 Add reservedip 10.1.9.1 001122334455 "SEP001122334455" "Test" "DHCP"
Dhcp Server 10.1.1.1 Scope 10.1.0.0 set reservedoptionvalue 10.1.9.1 150 IPADDRESS "10.1.1.12" "10.180.1.11"
Dhcp Server 10.1.1.1 Scope 10.1.0.0 set reservedoptionvalue 10.1.9.1 3 IPADDRESS "10.1.254.254"