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

[Sergey Safarov]

Think in your case required to adjust freeswitch variables in source code
and compile FreeSwitch.
Think any "c" developer can do it.

Or write request for freeswitch team support.
consulting at freeswitch.org


вт, 24 янв. 2017 г. в 13:53, Shaun Stokes <shaun.stokes at itec-support.co.uk>:

> 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.
> ______________________________________________________________________
>
> _________________________________________________________________________
> Professional FreeSWITCH Consulting Services:
> consulting at freeswitch.org
> http://www.freeswitchsolutions.com
>
> Official FreeSWITCH Sites
> http://www.freeswitch.org
> http://confluence.freeswitch.org
> http://www.cluecon.com
>
> FreeSWITCH-users mailing list
> FreeSWITCH-users at lists.freeswitch.org
> http://lists.freeswitch.org/mailman/listinfo/freeswitch-users
> UNSUBSCRIBE:http://lists.freeswitch.org/mailman/options/freeswitch-users
> http://www.freeswitch.org
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.freeswitch.org/pipermail/freeswitch-users/attachments/20170124/e4973be4/attachment.html