Discussion
Betreff: Re: [asterisk-users] asterisk mysql contacts
On Wed, 17 Jan 2018 09:26:28 -0700
John Kiniston wrote:
> use func_odbc, create a new function that does a lookup.
>
> [CALLERID]
> prefix=LOOKUP
> dsn=MyDB
> readsql=SELECT CALLERID from MyNames where CallerIdN
On Wed, 17 Jan 2018 09:26:28 -0700
John Kiniston wrote:
> use func_odbc, create a new function that does a lookup.
>
> [CALLERID]
> prefix=LOOKUP
> dsn=MyDB
> readsql=SELECT CALLERID from MyNames where CallerIdNum =
> '${SQL_ESC(${ARG1})}'
>
> exten => s,n,Set(CALLERID(NAME)=LOOKUP_CALLERID(${C
use func_odbc, create a new function that does a lookup.
[CALLERID]
prefix=LOOKUP
dsn=MyDB
readsql=SELECT CALLERID from MyNames where CallerIdNum =
'${SQL_ESC(${ARG1})}'
exten => s,n,Set(CALLERID(NAME)=LOOKUP_CALLERID(${CALLERID(NUM)}))
On Wed, Jan 17, 2018 at 6:16 AM, Atux Atux wrote:
> Hi.
On Wed, Jan 17, 2018 at 03:16:04PM +0200, Atux Atux wrote:
[asterisk dialplan mysql]
> I would like to ask if there is a way to implement this easily in my
> dialplan, please.
The answer is: yes
If you'd search for "asterisk dialplan mysql", you'get something like
https://www.voip-info.org/wiki/v
Hi. i have an asterisk 11 installation that i run in my soho environment.
My system has mysql to store all the cdrs.
I would like make use of the mysql and store numbers and names. eg
+4922123456789 "Atux Null". So when the +4922123456789 calls in my system
the name "Atux Null" will pop up next to
On 23 Jun 2009, at 11:18, jonas kellens wrote:
> What do I define as amaflags in my sip.conf ??
>
> Can I leave it to be amaflags=billing ? What use of defining it as
> billing or documentation when the number of columns are pre-defined ?
Eh? amaflags just sets a field in the database called
What do I define as amaflags in my sip.conf ??
Can I leave it to be amaflags=billing ? What use of defining it as
billing or documentation when the number of columns are pre-defined ?
Jonas.
On Tue, 2009-06-23 at 10:39 +0100, Ishfaq Malik wrote:
> There's a couple of columns you can write to i
There's a couple of columns you can write to in the table, most notably
accountcode and userfield. There is more info here.
http://www.voip-info.org/wiki/index.php?page=Asterisk+func+cdr
I'm not sure about defining additional columns and writing to them
through the dialplan but I don't think yo
Thanks for your reply. I saw that info also on voip-info.org.
I was wondering if I could define other columns, like those used for
billing (as defined in my sip.conf).
Jonas.
On Tue, 2009-06-23 at 09:22 +0100, Ishfaq Malik wrote:
> Hi
>
> The calldate column is the date and time of the call,
Hi
The calldate column is the date and time of the call, here's the
definition of the cdr table
CREATE TABLE `cdr` (
`calldate` datetime NOT NULL default '-00-00 00:00:00',
`clid` varchar(80) NOT NULL default '',
`src` varchar(80) NOT NULL default '',
`dst` varchar(80) NOT NULL default '',
`
[Jun 22 17:51:48] ERROR[13726]: cdr_addon_mysql.c:249 mysql_log:
mysql_cdr: Failed to insert into database: (1054) Unknown column
'calldate' in 'field list' == Spawn extension
I have the following columns (for billing) :
accountcode src dst dcontextclidchannel
dstchannel
jonas kellens escribió:
On Thu, 2009-06-18 at 11:52 -0500, Tilghman Lesher wrote:
In modules.conf: noload => cdr_csv.so
Are there other modules I need to load or unload ??
asterisk*CLI> module show like cdr
Module
Description Use Co
On Thu, 2009-06-18 at 11:52 -0500, Tilghman Lesher wrote:
>
> In modules.conf: noload => cdr_csv.so
>
Are there other modules I need to load or unload ??
asterisk*CLI> module show like cdr
Module Description
Use Count
cdr_addon_mysql.so MySQL CDR Backend
On Thursday 18 June 2009 10:08:44 jonas kellens wrote:
> There are some things that are not that clear to me :
>
> When I want to write CDR-info to an external MySQL-DB
>
> - do I need to install the asterisk-addons prior to installing Asterisk
> or after having installed Asterisk ??
After. Addon
There are some things that are not that clear to me :
When I want to write CDR-info to an external MySQL-DB
- do I need to install the asterisk-addons prior to installing Asterisk
or after having installed Asterisk ??
- How do I tell Asterisk not to write CDR-info to the Master.csv file
but into
Thank you for your reply Sir
i tried inserting ResetCDR(w) almost everywhere but i still end up with
this on the cdr:
FromTo:
500 100-CHANUNAVAIL
This is my current setting hat produces that CDR:
exten => 100,1,Macro(dial-ext-cf|SIP/${EXTEN}|vm-100|moh-100)
exten => 100,2,Goto(100-${D
You can use the ResetCDR() application with the w flag in it after you get
the unavailable, busy or etc message from the callee. It will store the cdr
of that call and after forwarding to mobile, that cdr will be dumped again.
On Wed, Sep 24, 2008 at 8:26 AM, Nhadie <[EMAIL PROTECTED]> wrote:
> h
hi,
i'm using this macro to dial an extension and forward to a mobile if
unavailable,busy or noanswer
exten => 100,1,Macro(dial-ext|SIP/${EXTEN}|vm-100|moh-100)
exten => 100,2,Goto(100-${DIALSTATUS}|1)
exten => 100-BUSY,1,Macro(dialout-local-mobile|91234567)
exten => 100-BUSY,2,Voicemail([EMAIL
On Fri, Jun 01, 2007 at 10:26:59AM -0700, Douglas Garstang wrote:
> Speaking of SQLite, is there an Asterisk SQLite command?
Trunk has cdr_sqlite, cdr_sqlite3 and res_config_sqlite (huh? still
sqlite2? hmmm). But I understand that many people would like to see
sqlite3 better used.
E.g.: instead
Speaking of SQLite, is there an Asterisk SQLite command?
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Tzafrir
Cohen
Sent: Friday, June 01, 2007 9:41 AM
To: asterisk-users@lists.digium.com
Subject: Re: [asterisk-users] asterisk mysql support
On Fri
On Fri, Jun 01, 2007 at 10:37:07AM -0500, Diego Quintana Cruz wrote:
> Hi all,
>
> I've just realized that my asterisk isn't storing cdr inputs in mysql.
> cdr_mysql.conf is well configured and I don't know what else should i
> configure.
The module was indeed not there. Building it. Thanks for
PROTECTED] On Behalf Of Diego Quintana
Cruz
Sent: Friday, June 01, 2007 11:37 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: [asterisk-users] asterisk mysql support
Hi all,
I've just realized that my asterisk isn't storing cdr inputs in mysql.
cdr_mysql.co
Hi all,
I've just realized that my asterisk isn't storing cdr inputs in mysql.
cdr_mysql.conf is well configured and I don't know what else should i configure.
I'm using Xorcom's packages, "cdr status" shows:
voip*CLI> cdr status
CDR logging: enabled
CDR mode: simple
CDR registered backend: csv
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Abdul wrote:
> Hi all,
>
> I am using MySQL for mysql_cdr. I have very strange issue, while destination
> is ringing and caller disconnect the phone without any conversation, i can
> see in cdr of mysql the duration is starting and for this customer
Hi all,I am using MySQL for mysql_cdr. I have very strange issue, while destination is ringing and caller disconnect the phone without any conversation, i can see in cdr of mysql the duration is starting and for this customer are charged without any calls.Any can suggest me how i can stop this issu
Hi all,
I am using MySQL query inside my extentions.conf. i
have more than 200 agents using the same extentions
and i can see in each request asterisk try to connect
mysql.
My question is, Is there any way to make only one
connection for all users who is using the same
extentions.
Here is my ex
Dennis Gilmore wrote:
ok a little back round on runlevels.
Linux allows for up to 10 runlevels, 0-9, but usually only some of these are
defined by default. Runlevel 0 is defined as ``system halt''. Runlevel 1 is
defined as ``single user mode''. Runlevel 6 is defined as ``system reboot''.
O
Once upon a time Sunday 20 November 2005 8:39 pm, Matt Riddell wrote:
> Eric Bishop wrote:
> > Hi All,
> >
> > I am running Asterisk (1.0.9.) on CentOS 4 with CDR recording being
> > output to MySQL. However whenever the system boots up after a reboot I
> > am needing to manually restart Asterisk b
Once upon a time Sunday 20 November 2005 10:38 pm, JP Carballo wrote:
> JP Carballo wrote:
> > Eric Bishop wrote:
> >> I have:
> >>
> >> [EMAIL PROTECTED] ~]# chkconfig --list | grep mysql
> >> mysqld 0:off 1:off 2:off 3:on4:off 5:off 6:off
> >> [EMAIL PROTECTED] ~]# chkconfi
> Well that didn't work. When I rebooted MySQL didn't start at all
The level doesn't set _when_ something starts, just _if_ something
starts. Some daemons should start in single user mode, some not. Some
others should only start when in GUI mode, others not, etc. This is what
level controls. W
Well that didn't work. When I rebooted MySQL didn't start at allOn 11/21/05, JP Carballo <[EMAIL PROTECTED]
> wrote:JP Carballo wrote:> Eric Bishop wrote:>>> I have:
[EMAIL PROTECTED] ~]# chkconfig --list | grep mysql>>
mysqld 0:off
1:off 2:off
3:on4:off 5:off 6:off>
JP Carballo wrote:
Eric Bishop wrote:
I have:
[EMAIL PROTECTED] ~]# chkconfig --list | grep mysql
mysqld 0:off 1:off 2:off 3:on4:off 5:off 6:off
[EMAIL PROTECTED] ~]# chkconfig --list | grep asterisk
asterisk0:off 1:off 2:on3:on4:on5:on6:off
Eric Bishop wrote:
I have:
[EMAIL PROTECTED] ~]# chkconfig --list | grep mysql
mysqld 0:off 1:off 2:off 3:on4:off 5:off 6:off
[EMAIL PROTECTED] ~]# chkconfig --list | grep asterisk
asterisk0:off 1:off 2:on3:on4:on5:on6:off
What would you sugge
I have:
[EMAIL PROTECTED] ~]# chkconfig --list | grep mysql
mysqld
0:off 1:off 2:off
3:on 4:off 5:off 6:off
[EMAIL PROTECTED] ~]# chkconfig --list | grep asterisk
asterisk 0:off
1:off 2:on 3:on
4:on 5:on 6:off
What would you suggest I do?
On 11/21/05,
Eric Bishop wrote:
> Hi All,
>
> I am running Asterisk (1.0.9.) on CentOS 4 with CDR recording being
> output to MySQL. However whenever the system boots up after a reboot I
> am needing to manually restart Asterisk because MySQL is after Asterisk
> in the service startup sequence and I get
>
> E
Hi All,
I am running Asterisk (1.0.9.) on CentOS 4 with CDR recording being
output to MySQL. However whenever the system boots up after a reboot I
am needing to manually restart Asterisk because MySQL is after Asterisk
in the service startup sequence and I get
ERROR[3367]: Failed to connect to m
In ReiserFS3, the performance loss for a directory containing 10's of
thousands of files is negligible. I've personally had directories with
70,000+ files in them, and the performance has been stellar. Most
traditional unix file systems break down around 5k-10k files, but I'd
trust ReiserFS w
On Mon, 2005-03-07 at 13:30 -0800, beonice wrote:
> --- Colin Anderson <[EMAIL PROTECTED]>
> wrote:
> The problem I suspect will arise is the number of
> inodes allowed by the file system. I don't know the
> exact size of the typical inode-max, but this will
> also presumably become an issue when t
Steven Critchfield wrote:
On Mon, 2005-03-07 at 16:06 -0500, Eric wrote:
Hi Vinko,
MySQL blobs will store binary data, so you should be OK there. I'd
focus on whether or not storing the data in a variable is a good idea.
Typically, with any programming language, it's good practice to
keep varia
--- Steven Critchfield <[EMAIL PROTECTED]> wrote:
> On Mon, 2005-03-07 at 13:30 -0800, beonice wrote:
> >
... snip ...
> > Would it help to split the db off to a separate
> server
> > (that should reduce the CPU load on the asterisk
> > server)?
> >
> > Any other alternatives? Anyone verifi
On Mon, 2005-03-07 at 13:30 -0800, beonice wrote:
> --- Colin Anderson <[EMAIL PROTECTED]>
> wrote:
> > IMO, use filesystem for files. Use DB for DB. Put a
> > pointer in a field to
> > the file. Your DB will love you for it.
>
> The problem I suspect will arise is the number of
> inodes allowed
On Mon, 2005-03-07 at 16:06 -0500, Eric wrote:
> Hi Vinko,
>
> MySQL blobs will store binary data, so you should be OK there. I'd
> focus on whether or not storing the data in a variable is a good idea.
> Typically, with any programming language, it's good practice to
> keep variable lengths shor
--- Colin Anderson <[EMAIL PROTECTED]>
wrote:
> >Has anyone had production experience using * w/
> MySQL Blobs to store sound
> files? The >application I am working on requires
> all user data resides in a
> database. I am currently >reading/writing the
> files to disk via a phpagi
> scripts bu
Hi Vinko,
MySQL blobs will store binary data, so you should be OK there. I'd
focus on whether or not storing the data in a variable is a good idea.
Typically, with any programming language, it's good practice to
keep variable lengths short so you aren't passing the variable itself
between functio
Checkout CVS. There is now support for storing voicemail sound files in DB
with ODBC.
-Matthew
- Original Message -
From: <[EMAIL PROTECTED]>
To:
Sent: Monday, March 07, 2005 2:05 PM
Subject: [Asterisk-Users] Asterisk & MySQL Blobs
> Hello Folks,
>
> Has an
>Has anyone had production experience using * w/ MySQL Blobs to store sound
files? The >application I am working on requires all user data resides in a
database. I am currently >reading/writing the files to disk via a phpagi
scripts but I would love to read the blob into a> variable in the dial
Hello Folks,
Has anyone had production experience using * w/ MySQL Blobs
to store sound files? The
application I am working on requires all user data resides in a database. I am currently reading/writing the files
to disk via a phpagi scripts but I would love to read
the blob into a
ew
>
> - Original Message -
> From: "beonice" <[EMAIL PROTECTED]>
> To: "Asterisk Users Mailing List - Non-Commercial
> Discussion"
>
> Sent: Friday, February 11, 2005 10:36 AM
> Subject: [Asterisk-Users] Asterisk-MySQL: Not
> loading voice
--- Matthew Boehm <[EMAIL PROTECTED]> wrote:
> What version of asterisk?
>
> -Matthew
>
Asterisk CVS-v1-0-12/12/04-15:58:29 built by
[EMAIL PROTECTED] on a i686 running WhiteBox
Enterprise Linux
By the way, I _have_ created an ast_config db and the
content of my ast_config table is:
++---
What version of asterisk?
-Matthew
- Original Message -
From: "beonice" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
Sent: Friday, February 11, 2005 10:36 AM
Subject: [Asterisk-Users] Asterisk-MySQL: Not loading voicemail
Folks,
I'm trying to get Asterisk to load my voicemail
configuration from MySQL. I've followed the
instructions at:
http://www.voip-info.org/wiki-Asterisk+voicemail+database
I restarted Asterisk, but no luck: the voicemail.conf
does not get updated. I started with a sample
voicemail.conf that I
Hi,
I have in one Asterisk box different numbers, all are coming
thru the T1.
We need to know exactly the CallerID (whose calling I have
it) and witch number was called.
I take a look on cdr module and I didn’t find that
information. I think I’m not the only one with this problem L
A
om: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Carlos Chavez
Sent: Thursday, August 26, 2004 7:39 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Asterisk mysql database
On Thu, 26 Aug 2004 18:29:29 -0400, Jeremy Kenney wrote
> I
On Thu, 26 Aug 2004 18:29:29 -0400, Jeremy Kenney wrote
> I would like to configure asterisk to run complete out of mysql everything
> from extensions to voicemail has this been implemented yet and how
> kind of problems have their been
>
There are several ways to do it, but no easy one. I
I would like to configure asterisk to run complete out of mysql everything
from extensions to voicemail has this been implemented yet and how kind of
problems have their been
___
Asterisk-Users mailing list
[EMAIL PROTECTED]
http://lists.digium.com/mailm
Joao Carlos Moura wrote:
I need to develop an web interface to include clients automatically in
Asterisk. So, to make this possible I need
that all my peers and exten being at a database (Mysql).
Where do I find doc´s regarded for it?
Thank you very much,
J Moura
I think MySQL friends is probab
Fax: (309) 213-3500
E-Mail: [EMAIL PROTECTED]
Customer Service: (877) 976-0711
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of
> Joao Carlos Moura
> Sent: Monday, March 15, 2004 11:53 AM
> To: [EMAIL PROTECTED]
> Subject: [Aste
I need to develop an web interface to include clients automatically in
Asterisk. So, to make this possible I need
that all my peers and exten being at a database (Mysql).
Where do I find doc´s regarded for it?
Thank you very much,
J Moura
___
Asterisk-U
58 matches
Mail list logo
