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