[Freeswitch-users] mod_callcenter hitting 255 varchar limit on contact field in agent table using sofia_contact

[Shaun Stokes]

Hi All,

We are using sofia_contact to send calls to agents in mod_callcenter and we are hitting a 255 character limit on the agent contact with-in the FreeSWITCH backend DB. Unfortunately there's no way for us to reduce the string used for the agent contact since we need to include arguments for fail_on_single_reject, pickup and a few variables which otherwise wouldn't get passed.

We use multiple registrations per extension, currently sofia_contact is the only way for us to correctly route to all registrations simultaneously with fail_on_single_reject.

We've resolved this in our environment using the following process.

sudo service freeswitch stop

#### Modify the File: /freeswitch/mod/mod_callcenter.so

## HEX Address 00012250 ->

# Replace:
ANSI: 255
Hex
Col 7: 32
Col 8: 35
Col 9: 35

# With:
ANSI: 510
HEX
Col 7: 35
Col 8: 31
Col 9: 30

The full ANSI line is (if the address is different): contact VARCHAR(255),
To be replaced with: contact VARCHAR(510),

####

Delete callcenter.db
Drop Agents Table

sudo service freeswitch start
sudo fs_cli
reload mod_callcenter


I'd like to propose the 'contact' varchar field is increased to 510 for the 'agent' table in the source code 'mod_callcenter.so', or is there a better way of doing this?

Thanks,
Shaun
[http://www.itec-support.co.uk/wp-content/uploads/2016/07/email_logo.jpg]
Shaun Stokes - Infrastructure Analyst

T :     01453 700713
E :     shaun.stokes at itec-support.co.uk
W :     www.itec-support.co.uk

Registered Address :- ITEC Support, Suite 2 Prospect House, Bath Road, Stroud, Gloucestershire GL5 3QF
Company No. 06908001

CONFIDENTIALITY NOTICE
This communication and the information it contains are intended for the person or organisation to which it is addressed. Its contents are confidential and may be protected in law. Unauthorised use, copying or disclosure of any of it may be unlawful. If you are not the intended recipient, please contact us immediately.
The contents of any attachments in this e-mail may contain software viruses, which could damage your own computer system. While ITEC Support has taken every reasonable precaution to minimise this risk, we cannot accept liability for any damage which you sustain as a result of software viruses. You should carry out your own virus checking procedure before opening any attachment.

______________________________________________________________________
This message has been checked for all known viruses by  MessageLabs Virus Scanning Service.
______________________________________________________________________