On 27/09/13 17:47, Phibee Network Operation Center wrote:
Hello,
I am looking to know if it is possible to modify the SQL query that is
on Realtime sip accounts.
I want multiple servers use the same sql table, so getting an extra
"server" field to indicate that the data is valid on the X ser
Hello,
I am looking to know if it is possible to modify the SQL query that is
on Realtime sip accounts.
I want multiple servers use the same sql table, so getting an extra
"server" field to indicate that the data is valid on the X server
is this possible?
thank you in advance
jerome
--
__
On Wednesday 06 April 2011 14:53:00 Hans Witvliet wrote:
> I'm going to have a go with realtime mysql.
> Just wondering, most examples i came across while googling, was with 1.6
> systems.
>
> So any drastic changes with 1.8.3, table-layout? other pitfalls?
This isn't a pitfall that comes with th
On Wed, Apr 6, 2011 at 2:59 PM, Hans Witvliet wrote:
[snip]
> I think i have to stick with mysql, as info is coming from other
> applications, but perhaps some of the other code can be tweaked.
> mysql is nice (lots of tiny programs writen for it), but i'm not
> religious attached to it ;-)
I
On Wed, 2011-04-06 at 13:57 -0700, Jonathan Thurman wrote:
> On 11-04-06 03:53 PM, Hans Witvliet wrote:
> >>
> >> I'm going to have a go with realtime mysql.
> >> Just wondering, most examples i came across while googling, was with 1.6
> >> systems.
> >>
> >> So any drastic changes with 1.8.3, tabl
On 11-04-06 03:53 PM, Hans Witvliet wrote:
>>
>> I'm going to have a go with realtime mysql.
>> Just wondering, most examples i came across while googling, was with 1.6
>> systems.
>>
>> So any drastic changes with 1.8.3, table-layout? other pitfalls?
The tables migrate just fine, but you can upda
On 11-04-06 03:53 PM, Hans Witvliet wrote:
I'm going to have a go with realtime mysql.
Just wondering, most examples i came across while googling, was with 1.6
systems.
So any drastic changes with 1.8.3, table-layout? other pitfalls?
I suggest using res_odbc, it has better support. Aside from
Hi,
I'm going to have a go with realtime mysql.
Just wondering, most examples i came across while googling, was with 1.6
systems.
So any drastic changes with 1.8.3, table-layout? other pitfalls?
hw
--
_
-- Bandwidth and Coloca
2011/2/17 Ishfaq Malik
> On Thu, 2011-02-17 at 11:28 -0200, Rodrigo Lang wrote:
> > Hi to all.
> >
> > I make some tests with Asterisk 1.8.2 in Realtime. But i have one
> > problem, the asterisk don't connect in the base and show this message:
> >
> > [Feb 17 11:18:01] WARNING[19061]: res_config_
On Thu, 2011-02-17 at 11:28 -0200, Rodrigo Lang wrote:
> Hi to all.
>
> I make some tests with Asterisk 1.8.2 in Realtime. But i have one
> problem, the asterisk don't connect in the base and show this message:
>
> [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441
> realtime_multi_mysql: M
Hi to all.
I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem,
the asterisk don't connect in the base and show this message:
[Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441
realtime_multi_mysql: MySQL RealTime: Invalid database specified:
'asterisk_teste' (check re
JR Richardson wrote:
>> On Monday 28 December 2009 23:49:13 Tilghman Lesher wrote:
>>
>>> On Monday 28 December 2009 18:09:15 JR Richardson wrote:
>>>
I turned on console debug to see the actual mysql queries and to my
surprise and concern, I see every query for an extension p
> On Monday 28 December 2009 23:49:13 Tilghman Lesher wrote:
>> On Monday 28 December 2009 18:09:15 JR Richardson wrote:
>> > I turned on console debug to see the actual mysql queries and to my
>> > surprise and concern, I see every query for an extension priority
>> > repeated 3 or more times prio
On Monday 28 December 2009 23:49:13 Tilghman Lesher wrote:
> On Monday 28 December 2009 18:09:15 JR Richardson wrote:
> > I turned on console debug to see the actual mysql queries and to my
> > surprise and concern, I see every query for an extension priority
> > repeated 3 or more times prior to d
On Monday 28 December 2009 18:09:15 JR Richardson wrote:
> I turned on console debug to see the actual mysql queries and to my
> surprise and concern, I see every query for an extension priority
> repeated 3 or more times prior to dialplan execution. For instance my
> first dialplan activity is al
Hi All,
I'm testing some realtime extension apps with Asterisk 1.4.28 and
addons 1.4.10 using res_mysql. Localhost database is 5.0.32 with
Debian Etch. The apps are working fine all syntax is proper, using
Set with (REALTIME) function, Set with (CUT) function, calling a Macro
with s extensions,
Two things:
1. Set the context
2. Set the port
> Hi,
>
> I am using Realtime for sip configuration.
> When there is an INVITE which arrives at asterisk
> asterisk makes the following selects:
> Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651
> mysql_reconnect: MySQL RealTime: Everything is f
Hi,
I am using Realtime for sip configuration.
When there is an INVITE which arrives at asterisk
asterisk makes the following selects:
Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect:
MySQL RealTime: Everything is fine.
[Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 r
Hi:
Iam using Fedora core 5 .
Thanks in advance;
> Date: Mon, 29 Oct 2007 10:23:28 +0530> From:
[EMAIL PROTECTED]> To: asterisk-users@lists.digium.com> Subject: Re:
[asterisk-users] Realtime Mysql error>> On 10/27/07, wassim darwish> wrote
search , firewall, and confiration the software. the configuration the user
is bad ???
use asterisk2billing it is good
On 10/28/07, ram <[EMAIL PROTECTED]> wrote:
>
>
>
> On 10/27/07, wassim darwish <[EMAIL PROTECTED]> wrote:
> >
> >
> > Hi:
> > Iam using an asterisk server with astcc ,iam facin
On 10/27/07, wassim darwish <[EMAIL PROTECTED]> wrote:
>
>
> Hi:
> Iam using an asterisk server with astcc ,iam facing a problem with astcc
> that when the call is hangup sometimes astcc doesnt calculate the call cost
> and the call time and without writing the call status on cdrs table .
> I tri
Hi:
Iam using an asterisk server with astcc ,iam facing a problem with astcc that
when the call is hangup sometimes astcc doesnt calculate the call cost and the
call time and without writing the call status on cdrs table .
I tried to run this command "realtime mysql status" on the asterisk con
Hi All,
I'm testing different ways to implement a LCR/OCN tabe to shift calls
to multiple carriers for better rates. I'm using realtime mysql
database access, asterisk 1.2.9.1 with mysql 3.23.
Scenario 1:
I send outgoing calls with with a Goto statement into the context with
the realtime switch
You can have a MySQL Cluster.
- Original Message -
From: "David Thomas" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
Sent: Wednesday, December 13, 2006 8:36 PM
Subject: Re: [asterisk-users] Realtime +Mysql +Failover
On 12/13/06, Rob Schall <[EMAIL PROTECTED]> wrote:
Hoping someone out there has run into this or has some ideas for us.
We currently have asterisk set up with Realtime (using mysql) for its
extensions,sip and voicemail files.
The problem we are trying to solve, is one of a failover mechanism. W
Hoping someone out there has run into this or has some ideas for us.
We currently have asterisk set up with Realtime (using mysql) for its
extensions,sip and voicemail files.
The problem we are trying to solve, is one of a failover mechanism. What
if our mysql server went down.
Can Realtime be s
If i am not mistaken, you need to have another IAX user tables to store all the iax users. HEre is some example http://www.voip-info.org/wiki/view/Asterisk+RealTime+IAX
good luck!On 8/9/06, Shaun <[EMAIL PROTECTED]> wrote:
I'm attempting to setup asterisk running real-time with mysql. Right now Ic
I'm attempting to setup asterisk running real-time with mysql. Right now I
can get asterisk to start and run but a show dialplan shows basically
nothing other than parking extensions. I'm watching the full log also for
debug messages and I can see that asterisk is connecting to mysql with out
al Discussion
Subject: Re: [Asterisk-Users] Realtime + MYSQL
Timur,
Thank you for your response, I realize my mistake.
I didn't understand that the table structures were different for the
static component of real time as apposed to the actual real time part.
Thank you again for your assista
Timur,
Thank you for your response, I realize my mistake.
I didn't understand that the table structures were different for the
static component of real time as apposed to the actual real time part.
Thank you again for your assistance.
Nathan.
Timur V. Elzhov wrote:
On Thu, Aug 11, 2005 at
Rollin,
My real-time works fine, Nathan was the
original poster o this message. I simply added the table structure for real-time
voicemail J
Damon,
You may be querying the wrong table, because the following fields in your
Select statement do not exit
in the table, voicemail_us
Timur V. Elzhov wrote:
So the correct line in extconfig.conf must be
voicemail => mysql,asterisk,voicemail_users
Yes, Timur is correct. By stating that you want to bind "voicemail.conf"
you mean you want to store the config file itself. This is not what you
are looking for. Change the l
Damon,
You may be querying the wrong table, because the following fields in your Select statement do not exit
in the table, voicemail_users, that you created:
category,
var_name,
var_val,
cat_metric,
filename,
commented
Every item mentioned in a Select query must ex
On Thu, Aug 11, 2005 at 09:20:36AM -0400, Nathan Alberti wrote:
> I'm having a few issues with the MySQL realtime configuration in
> CVS-HEAD. I tested it initially with realtime extensions (realtime_ext
> => mysql,asterisk,extensions) and a realtime switch in extensions.conf
> and that works f
> I'm having a few issues with the MySQL realtime configuration in
> CVS-HEAD. I tested it initially with realtime extensions (realtime_ext
> => mysql,asterisk,extensions) and a realtime switch in extensions.conf
> and that works fine, So I though I'd go back and test a static
> configuration map
I'm having a few issues with the MySQL realtime configuration in
CVS-HEAD. I tested it initially with realtime extensions (realtime_ext
=> mysql,asterisk,extensions) and a realtime switch in extensions.conf
and that works fine, So I though I'd go back and test a static
configuration mapping.
om: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Tuesday, April 05, 2005 1:26 PM
To: Matt Schulte
Subject: RE: [Asterisk-Users] Realtime mysql problem?
Quoting Matt Schulte <[EMAIL PROTECTED]>:
> Ok,
>
> rtcachefriends=yes seemed to have fixed my problem(s). With both SIP
> and I
ur help though,
this has seemed to address the issue :-)
Matt
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
Sent: Monday, April 04, 2005 10:59 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime mysql problem?
ld be appreciated as I'm in the process of setting
up SER + Asterisk.
Regards
Cameron
- Original Message -
From: "Matt Schulte" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
Sent: Tuesday, April 05, 2005 1:01 AM
Subject: RE: [As
Matt Schulte wrote:
Now, this has been answered many, many, many times...in fact..I
believe Olle answered this in his "Welcome to Asterisk" post he sent out
over the weekend.
Hmm, into my mailbox it did not come, ...
___
Asterisk-Users mail
Matt Schulte wrote:
>>Now, this has been answered many, many, many times...in fact..I
> believe Olle answered this in his "Welcome to Asterisk" post he sent
> out over the weekend.
>
> AAHH my bad, I should have asked *when* it will go stable.. ;-)
When it will go stable is anybodys guess,
>Now, this has been answered many, many, many times...in fact..I
believe Olle answered this in his "Welcome to Asterisk" post he sent out
over the weekend.
AAHH my bad, I should have asked *when* it will go stable.. ;-)
___
Asterisk-Users maili
Matt Schulte wrote:
>>> do you have any clue when realtime will get added to stable?
>
>>It won't.
> why not?
Now, this has been answered many, many, many times...in fact..I believe
Olle answered this in his "Welcome to Asterisk" post he sent out over the
weekend.
To summarize: The st
>> do you have any clue when realtime will get added to stable?
>It won't.
why not?
>> Not to mention since
>> realtime doesn't support qualify= and NAT mode must be manually set,
>Have you been using RTC? (RealTime Cache) It fixes the NAT/MWI
problem.
I haven't tried this yet becau
can you send me a dump from SQL for this account?
I have it working both ways,
W
- Original Message -
From: "Matt Schulte" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
Sent: Monday, April 04, 2005 9:34 AM
Subject: RE: [Aste
> do you have any clue when realtime will get added to stable?
It won't.
> Not to mention since
> realtime doesn't support qualify= and NAT mode must be manually set,
Have you been using RTC? (RealTime Cache) It fixes the NAT/MWI problem.
-Matthew
___
April 04, 2005 8:26 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime mysql problem?
What is your problem with IAX in realtime? I have it working (finally).
Wojtek
- Original Message -
From: "Matt Schulte" <[EMAIL PROTECTED]&g
What is your problem with IAX in realtime? I have it working (finally).
Wojtek
- Original Message -
From: "Matt Schulte" <[EMAIL PROTECTED]>
To: "Asterisk Users Mailing List - Non-Commercial Discussion"
Sent: Monday, April 04, 2005 9:01 AM
Subject: RE: [Aste
- Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote:
> How do you toggle the realtime "cache"?
Check in the configs/iax.conf.sample file of a recent CVS download
and it should be in there.
> If there were too many fields
> in
Matt Schulte wrote:
> How do you toggle the realtime "cache"?
Check in the configs/iax.conf.sample file of a recent CVS download and
it should be in there.
> If there were too many fields
> in the table, could you foresee this being a problem?
No, because I have lots of extra company spe
imho) to get on Fedora.. Will let
you know unless you have any other ideas.. Thanks much for your help.
Matt
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 29, 2005 9:50 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject
Matt Schulte wrote:
> Ok, that was straight from the wiki. Still does not work, I tried it
> from the iax.conf, etc files and it works just fine. I even tried
> terminating/placing calls on the same server with realtime and it
> works fine. Is realtime broken? Is there anything else I can test
> w
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
Sent: Monday, March 28, 2005 8:46 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote
Matt Schulte wrote:
> ++---+-+--+---+--+--
> ---+---+-
> Here goes it's going to be messy :-) I followed the directions off the
> wiki. This *should* work just fine right? I built the table according
> to the directions
++---+-+--+---+--+--
---+---+-
Here goes it's going to be messy :-) I followed the directions off the
wiki. This *should* work just fine right? I built the table according to
the directions, every field is varchar thou
Matt Schulte wrote:
> Flatfile meaning iax.conf? Yes..
Sounds like a data problem to me. Paste your iaxpeers/iaxusers table schema
and iax.conf section that is relevant to the phone.
-Matthew
___
Asterisk-Users mailing list
Asterisk-Users@lists.digium
Flatfile meaning iax.conf? Yes..
-Original Message-
From: Matthew Boehm [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 24, 2005 8:49 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Realtime mysql problem?
Matt Schulte wrote:
> Mar 24
Matt Schulte wrote:
> Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2'
(cause 3)
Doesn't seem like a RealTime issue to me. Did you add that user into the
flatfile and test that way?
-Matthew
___
Asterisk-Users mailing list
Asteri
All, I get this whenever trying to dial to a peer when the peer
registered to another server. I'm basically trying to use realtime to
check for the peer and dial it.
Mar 24 09:16:47 VERBOSE[4527]: -- Executing Dial("SIP/brak-f69f",
"IAX2/brak-test/107") in new stack
Mar 24 09:16:47 DEBUG[4527]
Hi after patching with
http://bugs.digium.com/bug_view_page.php?bug_id=0002613
I got this error when I start Asterisk - any clue ?
[res_config_mysql.so]Nov 27 13:22:46 WARNING[15909]: loader.c:318
ast_load_resource: No load_module in module
/usr/lib/asterisk/modules/res_config_mysql.so
Nov 27
60 matches
Mail list logo