Hello
I am trying to attach a database to asterisk , can anyone help me?
in extconfig.conf sipusers => mysql,general,sip
in res_mysql.conf [general]
dbhost = 192.168.50.125
dbname = asterisk
dbuser = root
dbpass = ahmed
dbport = 3306
dbsock = /tmp/mysql.sock
i created a table in MySql
CREATE TABL
Can you link the howto or other documentation you are following to set this up?
What version of asterisk?
Did you edit extconfig.conf?
Heres a howto for 1.4.x
http://hostseries.com/asterisk-realtime-installation-guide/
On Wed, Jan 27, 2010 at 8:39 AM, ahmed magdy wrote:
> Hello
>
> I need to add
Hello
I need to add sip extensions from my UI so without going through sip.conf so
i created table
CREATE TABLE `sipfriends` (
`name` varchar(40) NOT NULL default '',
`username` varchar(40) default '',
`secret` varchar(40) NOT NULL default '',
`context` varchar(40) NOT NULL default '',
Benny Amorsen writes:
> Asterisk DB is either an SQLite database or a Berkeley database, I
> forget which (did it change?). Either way, 20,000 should be a problem
> for the underlying database.
Should NOT be a problem for the underlying database.
Sorry!
/Benny
__
On Tue, 21 Apr 2009, Doug Lytle wrote:
> Benny Amorsen wrote:
>> Asterisk DB is either an SQLite database or a Berkeley database, I
>>
>
> The last I knew, it was BerkeleyDB.
>
> Doug
>
>
Just to add a few cents, if the object is to store and retrieve a single
value with a single key, Berkeley
On Tue, 21 Apr 2009, Benny Amorsen wrote:
> "Sriram" writes:
>
>> 1. I need to store the CallerId of the PSTN caller with his language
>> preference so that next time he is played the prompt in his language that
>> he chose the first time.What would be better - storing his number in the
>> Asteri
Benny Amorsen wrote:
> Asterisk DB is either an SQLite database or a Berkeley database, I
>
The last I knew, it was BerkeleyDB.
Doug
--
Ben Franklin quote:
"Those who would give up Essential Liberty to purchase a little Temporary
Safety, deserve neither Liberty nor Safety."
__
ures documented
for backup and reload of it.
-Original Message-
From: asterisk-users-boun...@lists.digium.com
[mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Benny Amorsen
Sent: Tuesday, April 21, 2009 11:39 AM
To: Sriram
Cc: asterisk-users@lists.digium.com
Subject: Re:
"Sriram" writes:
> 1. I need to store the CallerId of the PSTN caller with his language
> preference so that next time he is played the prompt in his language that
> he chose the first time.What would be better - storing his number in the
> Asterisk DB and using Dbput and DBget ? or storing it in
i'd use mysql... and i do use mysql for this...
2009/4/21 Sriram
> My setup : Trixbox 2.6.1 & TE410P running well .:
>
> 1. I need to store the CallerId of the PSTN caller with his language
> preference so that next time he is played the prompt in his language that he
> chose the first time.Wha
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Sriram wrote:
>
> 1. I need to store the CallerId of the PSTN caller with his language
> preference so that next time he is played the prompt in his language
> that he chose the first time.What would be better - storing his number
> in the Asterisk DB
My setup : Trixbox 2.6.1 & TE410P running well .:
1. I need to store the CallerId of the PSTN caller with his language preference
so that next time he is played the prompt in his language that he chose the
first time.What would be better - storing his number in the Asterisk DB and
using Dbput a
Tilghman and Jay,
Thanks for the licensing advice. If anyone is interested in replicate,
I'm now ready to distribute it under the GPL.
Regards,
Matthew Roth
InterMedia Marketing Solutions
Software Engineer and Systems Developer
___
-- Bandwidth and
On Thu, May 22, 2008 at 10:05:13AM -0500, Tilghman Lesher wrote:
> > I've never released replicate publicly, because I'm not sure how taking
> > a program like tail and adapting it to a new purpose is handled by the
> > GPL. However, I'm sure someone on this list more knowledgeable than
> > myself
On Wed, May 21, 2008 at 06:02:07PM -0400, Alex Balashov wrote:
> Douglas Garstang wrote:
> > We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> > sometimes dropping CDR's, and they aren't being sent to the database
> > (they ARE in the Master.csv file though). We suspect that whe
Matthew J. Roth wrote:
> Alex Balashov wrote:
>> A program like netcat?
>>
> Alex,
>
> You're not the first person to suggest nc for this purpose. As I
> understand it, it's a TCP/UDP swiss army knife so I'm sure it's up to
> the task. However, in reading the man page, I don't see any trivi
Alex Balashov wrote:
> A program like netcat?
>
Alex,
You're not the first person to suggest nc for this purpose. As I
understand it, it's a TCP/UDP swiss army knife so I'm sure it's up to
the task. However, in reading the man page, I don't see any trivial way
to buffer failed writes and r
A program like netcat?
Matthew J. Roth wrote:
> Douglas Garstang wrote:
>>> Not at all, just offering a workaround. If your master.csv is
>>> complete and correct then it makes sense to use that data unless
>>> someone can identify your problem and offer a fix.
>> Unfortunately, not really feesib
On Thursday 22 May 2008 09:29:24 Matthew J. Roth wrote:
> It operates almost identically to "tail -F" except every new write to
> the file is written over a socket connection. The remote end of the
> connection is responsible for sending back an acknowledgment. If it
> doesn't, replicate will spo
Douglas Garstang wrote:
> >Not at all, just offering a workaround. If your master.csv is
> >complete and correct then it makes sense to use that data unless
> >someone can identify your problem and offer a fix.
>
> Unfortunately, not really feesible. I didn't design the system but we
> are using
Pezhman Lali wrote:
> using odbc+( postgres or mysql) is more stable,
> but at all odbc + postgres is recommended
Really?
--
Alex Balashov
Evariste Systems
Web: http://www.evaristesys.com/
Tel: (+1) (678) 954-0670
Direct : (+1) (678) 954-0671
Mobile : (+1) (706) 338-8599
using odbc+( postgres or mysql) is more stable,
but at all odbc + postgres is recommended
--- Sherwood McGowan <[EMAIL PROTECTED]>
wrote:
> Steve Prior wrote:
> > Tilghman Lesher wrote:
> >
> >> Correct; it's actually a workaround for a bug in
> the MySQL drivers. It was
> >> discovered lo
Steve Prior wrote:
> Tilghman Lesher wrote:
>
>> Correct; it's actually a workaround for a bug in the MySQL drivers. It was
>> discovered long after 1.2 was end-of-lifed.
>>
>>
>
> I got bit by MySQL reconnects on some other software I wrote I think when I
> jumped from MySQL 4.* to 5.*.
On Wednesday 21 May 2008 19:36:11 Steve Prior wrote:
> Tilghman Lesher wrote:
> > Correct; it's actually a workaround for a bug in the MySQL drivers. It
> > was discovered long after 1.2 was end-of-lifed.
>
> I got bit by MySQL reconnects on some other software I wrote I think when I
> jumped from
Tilghman Lesher wrote:
> Correct; it's actually a workaround for a bug in the MySQL drivers. It was
> discovered long after 1.2 was end-of-lifed.
>
I got bit by MySQL reconnects on some other software I wrote I think when I
jumped from MySQL 4.* to 5.*. If memory serves, here is the relevant
On Wednesday 21 May 2008 19:03:25 Douglas Garstang wrote:
> On Wednesday, May 21, 2008 4:39:24 PM, Tilghman Lesher wrote:
> > On Wednesday 21 May 2008 17:02:07 Alex Balashov wrote:
> > > Douglas Garstang wrote:
> > > > We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> > > > somet
Looks like an Asterisk 1.4 option?
- Original Message
From: Tilghman Lesher <[EMAIL PROTECTED]>
To: Asterisk Users Mailing List - Non-Commercial Discussion
Sent: Wednesday, May 21, 2008 4:39:24 PM
Subject: Re: [asterisk-users] Asterisk Database Handling
On Wednesday 21 May 2008
On Wednesday 21 May 2008 17:52:45 Alex Balashov wrote:
> Sherwood McGowan wrote:
> > I personally can tell you I've never had a problem with either the
> > PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
> > say personally how well the ODBC method works. I'll just stick to
On Wednesday 21 May 2008 17:02:07 Alex Balashov wrote:
> Douglas Garstang wrote:
> > We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> > sometimes dropping CDR's, and they aren't being sent to the database
> > (they ARE in the Master.csv file though). We suspect that when the MySQ
Douglas Garstang wrote:
> >I personally can tell you I've never had a problem with either the
> >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
> >say personally how well the ODBC method works. I'll just stick to saying
> >that if you're considering using the cdr_mysql add
Douglas Garstang wrote:
> >I personally can tell you I've never had a problem with either the
> >PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
> >say personally how well the ODBC method works. I'll just stick to saying
> >that if you're considering using the cdr_mysql add
Douglas Garstang wrote:
> >Not at all, just offering a workaround. If your master.csv is
> >complete and correct then it makes sense to use that data unless
> >someone can identify your problem and offer a fix.
>
> Unfortunately, not really feesible. I didn't design the system but we
> are us
On Wed, May 21, 2008 at 7:11 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote:
>>Not at all, just offering a workaround. If your master.csv is
>>complete and correct then it makes sense to use that data unless
>>someone can identify your problem and offer a fix.
>
> Unfortunately, not really feesibl
>Not at all, just offering a workaround. If your master.csv is
>complete and correct then it makes sense to use that data unless
>someone can identify your problem and offer a fix.
Unfortunately, not really feesible. I didn't design the system but we are using
CDR's not only for billing purpose
>I personally can tell you I've never had a problem with either the
>PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
>say personally how well the ODBC method works. I'll just stick to saying
>that if you're considering using the cdr_mysql addon, I would highly
>suggest
Douglas Garstang wrote:
> It's interesting you say that Sherwood. Does your MySQL server have some
> sort of keep alive setting? I suspect this is a general problem that
> would affect any and all Asterisk database connectivity.
I would actually expect it to affect only specific types of databa
On Wed, May 21, 2008 at 7:00 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote:
>>I personally can tell you I've never had a problem with either the
>>PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
>>say personally how well the ODBC method works. I'll just stick to saying
>>t
>I personally can tell you I've never had a problem with either the
>PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
>say personally how well the ODBC method works. I'll just stick to saying
>that if you're considering using the cdr_mysql addon, I would highly
>suggest
Sherwood McGowan wrote:
> I personally can tell you I've never had a problem with either the
> PostgreSQL or MySQL cdr apps themselves losing records. However, I can't
> say personally how well the ODBC method works. I'll just stick to saying
> that if you're considering using the cdr_mysql add
On Wed, May 21, 2008 at 6:42 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote:
>>>
>>> So... surely this must be a general problem with ANY Asterisk module that
>>> uses the database. Do all modules use the same common database code or do
>>> they all use their own? If they all use their own, I guess
TED]>
> To: Asterisk Users Mailing List - Non-Commercial Discussion
>
> Sent: Wednesday, May 21, 2008 3:02:07 PM
> Subject: Re: [asterisk-users] Asterisk Database Handling
>
> Douglas Garstang wrote:
>
> > We are sending CDR's to MySQL via odbc. It seems that A
>>
>> So... surely this must be a general problem with ANY Asterisk module that
>> uses the database. Do all modules use the same common database code or do
>> they all use their own? If they all use their own, I guess idle database
>> connection issues may be fixed in some modules and not others.
>- Original Message
>From: Alex Balashov <[EMAIL PROTECTED]>
>To: Asterisk Users Mailing List - Non-Commercial Discussion
>
>Sent: Wednesday, May 21, 2008 3:30:06 PM
>Subject: Re: [asterisk-users] Asterisk Database Handling
>
>Douglas Garstang wrote
On Wed, May 21, 2008 at 5:37 PM, Douglas Garstang <[EMAIL PROTECTED]> wrote:
> General Asterisk question.
>
> We are sending CDR's to MySQL via odbc. It seems that Asterisk is sometimes
> dropping CDR's, and they aren't being sent to the database (they ARE in the
> Master.csv file though). We suspe
Douglas Garstang wrote:
> I couldn't find one for cdr_mysql.conf.
> We're using odbc anyway. MySQL directly might be an option if it works.
> Don't think we want to modify the server.
Perhaps there's a keepalive option to be set on the UnixODBC DSN, then?
--
Alex Balashov
Evariste Systems
Web
ial Discussion
Sent: Wednesday, May 21, 2008 3:02:07 PM
Subject: Re: [asterisk-users] Asterisk Database Handling
Douglas Garstang wrote:
> We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> sometimes dropping CDR's, and they aren't being sent to the database
>
Sanjay Rajdev wrote:
> I had a similar problem, but in my case we had a custom application that
> was throwing an segmentation exception which was causing Asterisk to
> Restart. And in that case It use to miss the log in database.
> You can determine the same by looking at the UNIQUEID being logg
hursday, May 22, 2008 3:32:07 AM GMT +05:30 Chennai, Kolkata, Mumbai,
New Delhi
Subject: Re: [asterisk-users] Asterisk Database Handling
Douglas Garstang wrote:
> We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> sometimes dropping CDR's, and they aren't
Douglas Garstang wrote:
> We are sending CDR's to MySQL via odbc. It seems that Asterisk is
> sometimes dropping CDR's, and they aren't being sent to the database
> (they ARE in the Master.csv file though). We suspect that when the MySQL
> socket is idle, it gets disconnected, either by the MyS
General Asterisk question.
We are sending CDR's to MySQL via odbc. It seems that Asterisk is sometimes
dropping CDR's, and they aren't being sent to the database (they ARE in the
Master.csv file though). We suspect that when the MySQL socket is idle, it gets
disconnected, either by the MySQL se
ssion
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
rs 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 e
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 fo
- unplug <[EMAIL PROTECTED]> 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
Hi,
Does asterisk will reference to asterisk database in every action
(register, invite, ...)? Can I use ARA to replace asterisk database
totally? How?
___
--Bandwidth and Colocation provided by Easynews.com --
asterisk-users mailing list
To UNSUBSCRI
Why not use mysql?Do something like this: exten => s,1,MYSQL(SELECT * FROM whatever)bpOn 7/13/06,
Tomislav Parčina <[EMAIL PROTECTED]> wrote:
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
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 you
Anyone know is there a limition on size of asterisk database...
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
http://lists.digium.com/mailman/listinfo
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
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 re
Sorry for echo I just wait for a reply :)
I looked at Voip-info but does a GUI is provided to insert datas in
tables ???
Le sam 17/04/2004 à 17:36, Brancaleoni Matteo a écrit :
> I hear some echo there :)
>
> simply, you can define sip friends from a database.
> just create the table, enab
I hear some echo there :)
simply, you can define sip friends from a database.
just create the table, enable SIP_FRIENDS into channels
Makefile and read chan_sip.c how to set
db access (db access data must be into sip.conf)
but, firstofall, you must be familiar with sip.conf
and friends/user/
Hello,
Is it possible to use a database for provisionning sip clients?
CVS provides sip-friends.sql in order to create tables (not database)
what may i do with that tables?
Regards
Harry
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.
Hello,
Is it possible to use a database for provisionning sip clients?
CVS provides sip-friends.sql in order to create tables (not database)
what may i do with that tables?
Regards
Harry
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.
64 matches
Mail list logo
