<div dir="ltr">res_mysql connecting to a MySQL database. Is that what you're asking? It's all MySQL.</div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Nov 19, 2014 at 8:43 AM, Matthew Jordan <span dir="ltr"><<a href="mailto:mjordan@digium.com" target="_blank">mjordan@digium.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div class="HOEnZb"><div class="h5">On Wed, Nov 19, 2014 at 8:30 AM, Jayson Baker <<a href="mailto:jayson@spectrasurf.com">jayson@spectrasurf.com</a>> wrote:<br>
> It was originally varchar(50) and contained mailbox@context -- but that<br>
> didn't work, so we tried changing it to bigint(10). It's been changed back<br>
> and does contain varchar(50) with mailbox@context now.<br>
><br>
> Everything else seems to be working properly, yes.<br>
><br>
> Here's one entry from our realtime table (MySQL):<br>
><br>
> INSERT INTO `` (`id`, `name`, `username`, `secret`, `callerid`, `context`,<br>
> `mailbox`, `mwi`, `host`, `setvar`, `nat`, `type`, `accountcode`,<br>
> `amaflags`, `call-limit`, `callgroup`, `cancallforward`, `canreinvite`,<br>
> `defaultip`, `dtmfmode`, `fromuser`, `fromdomain`, `insecure`, `language`,<br>
> `md5secret`, `deny`, `permit`, `mask`, `musiconhold`, `pickupgroup`,<br>
> `qualify`, `regexten`, `restrictcid`, `rtpholdtimeout`, `rtptimeout`,<br>
> `disallow`, `allow`, `parkinglot`, `fullcontact`, `ipaddr`, `port`,<br>
> `regserver`, `regseconds`, `lastms`, `defaultuser`, `subscribecontext`,<br>
> `useragent`, `limitonpeers`) VALUES (96, '7191111111', '7191111111',<br>
> '000000000000000000000000', NULL, 'outbound', '7191111111@default', NULL,<br>
> 'dynamic', NULL, 'yes', 'friend', NULL, NULL, 2, NULL, 'yes', 'no', NULL,<br>
> NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,<br>
> NULL, NULL, NULL, NULL, 'all', 'ulaw', NULL,<br>
> '<a href="http://sip:7191111111@10.105.14.7:5060" target="_blank">sip:7191111111@10.105.14.7:5060</a>', '10.105.14.7', 5060, NULL, 1416407370, 6,<br>
> '<a href="tel:7196868170" value="+17196868170">7196868170</a>', NULL, 'Linksys/SPA2102-5.2.10', NULL);<br>
><br>
> And then what "sip show peer 7191111111" shows:<br>
><br>
> *CLI> sip show peer 7196868100<br>
><br>
> * Name : 7191111111<br>
> Description :<br>
> Realtime peer: Yes, cached<br>
> Secret : <Set><br>
> MD5Secret : <Not set><br>
> Remote Secret: <Not set><br>
> Context : outbound<br>
> Record On feature : automon<br>
> Record Off feature : automon<br>
> Subscr.Cont. : <Not set><br>
> Language :<br>
> Tonezone : <Not set><br>
> AMA flags : Unknown<br>
> Transfer mode: open<br>
> CallingPres : Presentation Allowed, Not Screened<br>
> Callgroup :<br>
> Pickupgroup :<br>
> Named Callgr :<br>
> Nam. Pickupgr:<br>
> MOH Suggest :<br>
> Mailbox :<br>
> VM Extension : *98<br>
> LastMsgsSent : 32767/65535<br>
> Call limit : 2<br>
> Max forwards : 0<br>
> Dynamic : Yes<br>
> Callerid : "" <><br>
> MaxCallBR : 384 kbps<br>
> Expire : 53<br>
> Insecure : no<br>
> Force rport : Yes<br>
> Symmetric RTP: Yes<br>
> ACL : No<br>
> DirectMedACL : No<br>
> T.38 support : No<br>
> T.38 EC mode : Unknown<br>
> T.38 MaxDtgrm: 4294967295<br>
> DirectMedia : No<br>
> PromiscRedir : No<br>
> User=Phone : No<br>
> Video Support: No<br>
> Text Support : No<br>
> Ign SDP ver : No<br>
> Trust RPID : Yes<br>
> Send RPID : Yes<br>
> Path support : No<br>
> Path : N/A<br>
> TrustIDOutbnd: Legacy<br>
> Subscriptions: Yes<br>
> Overlap dial : Yes<br>
> DTMFmode : rfc2833<br>
> Timer T1 : 500<br>
> Timer B : 32000<br>
> ToHost :<br>
> Addr->IP : (null)<br>
> Defaddr->IP : (null)<br>
> Prim.Transp. : UDP<br>
> Allowed.Trsp : UDP<br>
> Reg. exten :<br>
> Def. Username: 7191111111<br>
> SIP Options : (none)<br>
> Codecs : (ulaw)<br>
> Auto-Framing : No<br>
> Status : UNKNOWN<br>
> Useragent : Linksys/SPA2102-5.2.10<br>
> Reg. Contact : <a href="http://sip:7191111111@10.106.1.17:5060" target="_blank">sip:7191111111@10.106.1.17:5060</a><br>
> Qualify Freq : 60000 ms<br>
> Keepalive : 0 ms<br>
> Sess-Timers : Accept<br>
> Sess-Refresh : uas<br>
> Sess-Expires : 1800 secs<br>
> Min-Sess : 90 secs<br>
> RTP Engine : asterisk<br>
> Parkinglot :<br>
> Use Reason : No<br>
> Encryption : No<br>
><br>
<br>
</div></div>Which realtime backend are you using? (MySQL can be interfaced to with<br>
a variety of backends)<br>
<div class="HOEnZb"><div class="h5"><br>
<br>
--<br>
Matthew Jordan<br>
Digium, Inc. | Engineering Manager<br>
445 Jan Davis Drive NW - Huntsville, AL 35806 - USA<br>
Check us out at: <a href="http://digium.com" target="_blank">http://digium.com</a> & <a href="http://asterisk.org" target="_blank">http://asterisk.org</a><br>
<br>
--<br>
_____________________________________________________________________<br>
-- Bandwidth and Colocation Provided by <a href="http://www.api-digital.com" target="_blank">http://www.api-digital.com</a> --<br>
New to Asterisk? Join us for a live introductory webinar every Thurs:<br>
<a href="http://www.asterisk.org/hello" target="_blank">http://www.asterisk.org/hello</a><br>
<br>
asterisk-users mailing list<br>
To UNSUBSCRIBE or update options visit:<br>
<a href="http://lists.digium.com/mailman/listinfo/asterisk-users" target="_blank">http://lists.digium.com/mailman/listinfo/asterisk-users</a><br>
</div></div></blockquote></div><br></div>