For example, it was desirable to change canreinvite to directmedia and a couple other things.
Code:
CREATE VIEW `cc_sip_buddies_custom` AS select `cc_sip_buddies`.`id` AS `id`,`cc_sip_buddies`.`id_cc_card` AS `id_cc_card`,`cc_sip_buddies`.`name` AS `name`,`cc_sip_buddies`.`accountcode` AS `accountcode`,`cc_sip_buddies`.`regexten` AS `regexten`,`cc_sip_buddies`.`amaflags` AS `amaflags`,`cc_sip_buddies`.`callgroup` AS `callgroup`,`cc_sip_buddies`.`callerid` AS `callerid`,`cc_sip_buddies`.`cid_number` AS `cid_number`,`cc_sip_buddies`.`canreinvite` AS `directmedia`,`cc_sip_buddies`.`context` AS `context`,`cc_sip_buddies`.`defaultip` AS `DEFAULTip`,`cc_sip_buddies`.`dtmfmode` AS `dtmfmode`,`cc_sip_buddies`.`fromuser` AS `fromuser`,`cc_sip_buddies`.`fromdomain` AS `fromdomain`,`cc_sip_buddies`.`host` AS `host`,`cc_sip_buddies`.`insecure` AS `insecure`,`cc_sip_buddies`.`language` AS `language`,`cc_sip_buddies`.`mailbox` AS `mailbox`,`cc_sip_buddies`.`md5secret` AS `md5secret`,`cc_sip_buddies`.`nat` AS `nat`,`cc_sip_buddies`.`deny` AS `deny`,`cc_sip_buddies`.`permit` AS `permit`,`cc_sip_buddies`.`mask` AS `mask`,`cc_sip_buddies`.`pickupgroup` AS `pickupgroup`,`cc_sip_buddies`.`port` AS `port`,`cc_sip_buddies`.`qualify` AS `qualify`,`cc_sip_buddies`.`restrictcid` AS `restrictcid`,`cc_sip_buddies`.`rtptimeout` AS `rtptimeout`,`cc_sip_buddies`.`rtpholdtimeout` AS `rtpholdtimeout`,`cc_sip_buddies`.`secret` AS `secret`,`cc_sip_buddies`.`type` AS `type`,`cc_sip_buddies`.`name` AS `defaultuser`,`cc_sip_buddies`.`disallow` AS `disallow`,`cc_sip_buddies`.`allow` AS `allow`,`cc_sip_buddies`.`musicclass` AS `musicclass`,`cc_sip_buddies`.`mohsuggest` AS `mohsuggest`,`cc_sip_buddies`.`regseconds` AS `regseconds`,`cc_sip_buddies`.`ipaddr` AS `ipaddr`,`cc_sip_buddies`.`cancallforward` AS `cancallforward`,`cc_sip_buddies`.`fullcontact` AS `fullcontact`,`cc_sip_buddies`.`setvar` AS `setvar`,`cc_sip_buddies`.`lastms` AS `lastms` from `cc_sip_buddies`;
You can try this to see if it works for you.
I create this view, according to this query, and then I reload asterisk.. but no change, still showing the same error message as before:
[Oct 1 01:34:25] ERROR[1807]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("", "(null)", ...): ai_family not supported
[Oct 1 01:34:25] WARNING[1807]: acl.c:579 resolve_first: Unable to lookup ''
[Oct 1 01:34:27] ERROR[1807]: netsock2.c:263 ast_sockaddr_resolve: getaddrinfo("", "(null)", ...): ai_family not supported
[Oct 1 01:34:27] WARNING[1807]: acl.c:579 resolve_first: Unable to lookup ''