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
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
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 amagdy.ibra...@gmail.com wrote:
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
-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 and
i'd use mysql... and i do use mysql for this...
2009/4/21 Sriram d_r_sri...@hotmail.com
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
Sriram d_r_sri...@hotmail.com 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 ?
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: [asterisk-users
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.
On Tue, 21 Apr 2009, Benny Amorsen wrote:
Sriram d_r_sri...@hotmail.com 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
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 DB is
Benny Amorsen benny+use...@amorsen.dk 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
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
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 long after 1.2
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
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 CDR's
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 spool
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 feesible. I
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
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 trivial way
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 when the
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 can
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
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 MySQL
: Thursday, 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 being sent
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 logged
@lists.digium.com
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
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
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 suspect
- Original Message
From: Alex Balashov [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Wednesday, May 21, 2008 3:30:06 PM
Subject: Re: [asterisk-users] Asterisk Database Handling
Douglas Garstang wrote:
I couldn't
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. If it's
-Commercial Discussion
asterisk-users@lists.digium.com
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
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 idle
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 addon,
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 it
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
that if
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 database
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 it
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 purposes,
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 feesible. I
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
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 addon, I
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 addon, I
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 MySQL
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 saying
Looks like an Asterisk 1.4 option?
- Original Message
From: Tilghman Lesher [EMAIL PROTECTED]
To: Asterisk Users Mailing List - Non-Commercial Discussion
asterisk-users@lists.digium.com
Sent: Wednesday, May 21, 2008 4:39:24 PM
Subject: Re: [asterisk-users] Asterisk Database Handling
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
sometimes dropping
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: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 MySQL
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.*. If memory
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
:
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
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
- 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 is
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
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
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
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:
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
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
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]
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
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, enable
63 matches
Mail list logo