I'd like to be able to add additional fields to the the Asterisk database. I'm using Mysql for most of my data lookup and manipulation, and it seems to work pretty well. In keeping with what I know how to do, it would be very handy to be able to insert say a "call forward number" into a customer record. That way, I could automatically route calls to extensions to a forwarded number. Any suggestions on how this can be done?
On Fri, 2004-05-28 at 16:10, Ed Devine wrote:> I'd like to be able to add additional fields to the the Asterisk > database. I'm using Mysql for most of my data lookup and manipulation, > and it seems to work pretty well. In keeping with what I know how to do, > it would be very handy to be able to insert say a "call forward number" > into a customer record. That way, I could automatically route calls to > extensions to a forwarded number. Any suggestions on how this can be > done?http://voip-info.org/wiki-Asterisk+configuration+from+database I use method 2 to #include sections into my user configs & dialplan I complement this with app_dbodbc to do lookups in my dial macro: http://voip-info.org/wiki-Asterisk+app_dbodbc Dial macro then ensures that users' original voicemail is accessed if the fwd'd extension is busy. F
Anyone know is there a limition on size of asterisk database...
Hi list! I'm planning do use LookupCIDName application. TO use it I need to input CID data to internal asterisk DB. Question is, how much data can I store to Asterisk DB? Is there any maximum? Does outing to much (how much is too much?) data in DB effects work of * in any way? Please share your experience. -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)495148 Mob.: +385(91)1212148 SIP: tomo@pbx.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr
> Why not use mysql? > Do something like this: exten => s,1,MYSQL(SELECT * FROM whatever)If Asterisk database can handle large amount of data, I would prefer it because of stability and speed. If Asterisk database can't handle that then I'll have to use MYSQL (or MSSQL which I prefer because I already store CDR to MSSQL). With internal database I have code like this. exten => _1XX,1,LookupCIDName exten => _1XX,n,Dial(SIP/${EXTEN},30,wt) How will it look like with mysql? Like this? exten => s,1,MYSQL(SELECT * FROM whatever) exten => s,n,Dial(SIP/${EXTEN},30,wt) -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)495148 Mob.: +385(91)1212148 SIP: tomo@pbx.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr
In article <200607140339.29813.rushowr@phreaker.net>, rushowr@phreaker.net says...> It would look like this: > > exten => s,1,MYSQL(Connect dbcxnid HOST USER PASS DB) > exten => s,n,MYSQL(Query resultid ${cbcxnid} SELECT\ \*\ FROM\ whatever) > exten => s,n,MYSQL(Fetch fetchid ${resultid} VAR1\ VAR2\ VAR3\) > exten => s,n,MYSQL(Clear ${resultid}) > exten => s,n,MYSQL(Disconnect ${dbcxnid}) > > That's a general idea...check the voip-info wiki (asterisk cmd MYSQL)Thank you. I'll try to make it work. But I still didn't receive answer about Asterisk internal database. How much data is safe to put there? -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)495148 Mob.: +385(91)1212148 SIP: tomo@pbx.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr
In article <44B7B225.80900@drdos.info>, support@drdos.info says...> Rushowr wrote: > > I'm not personally sure, but if I recall correctly, the astDB is cleared > > whenever the Asterisk server is stopped... > > > This is not correct.Hi Doug, Where can I find information's about maximum data that I can store in internal * database? -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)495148 Mob.: +385(91)1212148 SIP: tomo@pbx.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr
In article <44BB5D32.2090109@drdos.info>, support@drdos.info says...> > Where can I find information's about maximum data that I can store in internal * database? > > According to the Wiki: > > "The Asterisk database uses version 1 of the Berkley DB" > > So, you'd need to look up the information on the Berkeley website, to > find it's limitations.Hi Doug! Thank you for this information. -- Tomislav Par?ina Lama Computers Split Stinice 12, 21000 Split Tel.: +385(21)495148 Mob.: +385(91)1212148 SIP: tomo@pbx.lama.hr e-mail: tparcina#lama.hr http://www.lama.hr
Hi, Does asterisk will reference to asterisk database in every action (register, invite, ...)? Can I use ARA to replace asterisk database totally? How?
----- unplug <maillisting@gmail.com> wrote:> Does asterisk will reference to asterisk database in every action > (register, invite, ...)? Can I use ARA to replace asterisk database > totally? How?The Asterisk database is not accessed on every single SIP message. Information about registrations is stored there, though. There is currently no way to replace the internal Asterisk database. -- Russell Bryant Software Developer Digium, Inc.
As I see in ast DB, there are register information about every UA (external IP, port and internal IP, port in NAT mode). In ARA, there is only external IP, port stored. In such case, when there is a call coming to an UA, asterisk will look for the ARA to get the external IP,port and then look for ast DB to get the internal ip, port of the UA in NAT mode to construct a channel. Am I right? On 7/21/06, Russell Bryant <russell@digium.com> wrote:> > > The Asterisk database is not accessed on every single SIP message. Information about registrations is stored there, though. > > There is currently no way to replace the internal Asterisk database. > > -- > Russell Bryant > Software Developer > Digium, Inc. > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users >
When you find out, let us know, because it isn't documented anywhere! We had to drop ARA because it's behaviour was very unpredictable. -----Original Message----- From: unplug [mailto:maillisting@gmail.com] Sent: Thu 7/20/2006 7:49 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Cc: Subject: Re: [asterisk-users] asterisk database As I see in ast DB, there are register information about every UA (external IP, port and internal IP, port in NAT mode). In ARA, there is only external IP, port stored. In such case, when there is a call coming to an UA, asterisk will look for the ARA to get the external IP,port and then look for ast DB to get the internal ip, port of the UA in NAT mode to construct a channel. Am I right? On 7/21/06, Russell Bryant <russell@digium.com> wrote: > > > The Asterisk database is not accessed on every single SIP message. Information about registrations is stored there, though. > > There is currently no way to replace the internal Asterisk database. > > -- > Russell Bryant > Software Developer > Digium, Inc. > > _______________________________________________ > --Bandwidth and Colocation provided by Easynews.com -- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users > _______________________________________________ --Bandwidth and Colocation provided by Easynews.com -- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users