Displaying 20 results from an estimated 2000 matches similar to: "Asterisk, Realtime and specify MySQL Table Name ?"
2007 Sep 26
4
Asterisk realtime error
Hi! I am proving Asterisk 1.2.24 in realtime with MySQL 5.0.27 using Idefisk
softphones. I followed the steps of "how to" of voip-org but always have
this error:
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime: Failed to query database. Check debug for more info.
Sep 25 20:29:07 WARNING[12000]: res_config_mysql.c:360 update_mysql: MySQL
RealTime:
2010 Feb 22
2
Problems with SIP realtime
I have followed the instructions on voip-info.org for Realtime SIP
peers, but I get this notice :
[Feb 22 20:05:32] NOTICE[15298]: chan_sip.c:15889
handle_request_register: Registration from
'<sip:testsip at 192.168.1.150;transport=UDP>' failed for '192.168.1.105' -
No matching peer found
The CLI shows :
[Feb 22 19:58:23] == Parsing
2005 Aug 24
2
RealTime ignoringswitch=>Realtime/context@re altime_ext
Thanks John, You are my savior. This is such a great relief. Apparently
realtime will not use either '127.0.0.1' or 'localhost' to connect to the
database. I had to use the actual IP address attached to the NIC before it
worked.
My OS is Debian just a note and Asterisk HEAD from August 20, 2005
Details below for those who might be swimming in the same pool with me.
2005 Aug 23
2
RealTime ignoringswitch=>Realtime/context@realti me_ext
I am using the current HEAD of asterisk and for asterisk-addons. I have been
trying to setup realtime mysql voicemail but no sucess. I keep getting this
error below. The necessary modules are loaded, res_config_mysql.so ...
Any pointers will help. Thanks
mail*CLI> realtime mysql status
Aug 24 00:56:50 ERROR[963]: res_config_mysql.c:596 mysql_reconnect: MySQL
RealTime: Failed to connect
2007 Mar 01
5
Asterisk Realtime
Could someone provide some steps for troubleshooting Realtime? I can't see
any signs that it's working. I followed and double-checked a few different
guides around the net, but haven't been able to figure it out.
-------------- next part --------------
An HTML attachment was scrubbed...
URL:
2006 May 14
1
Getting Realtime running (1.2.7.1)
I've got my res_mysql.conf stating:
[general]
dbhost = 127.0.0.1
dbname = switchref
dbuser = asteriskuser
dbpass = xxxxxxx
dbport = 3306
and my extconfig.conf stating:
sipusers => mysql,switchref,sip_buddies
sippeers => mysql,switchref,sip_buddies
When Asterisk starts, and I show peers and show users, I don't see anything
that is in the database. When looking at the traffic
2005 May 04
4
Problem with realtime SIP
Hi Guys,
We have just set up Asterisk (CVS Head) for a realtime enviorment using
MySQL & Asterisk Addons.
I have populated the "sip_buddies" table with the same information that
is came from our sip.conf, however registration seems to fail for the
softphone we have set up.
Does anyone have any idea as to what I should be looking for here? I'm
not getting any error messages
2007 Aug 20
4
Realtime Queue Members
Does anybody have realtime queue members working? Not the queues
themselves, just the members. I have realtime working for voicemail and
sippeers, but I can't get queue members to work. Here is what I have:
res_mysql.conf:
[general]
dbhost = 127.0.0.1
dbname = ASTERISK
dbuser = myuser
dbpass = mypass
dbport = 3306
dbsock = /tmp/mysql.sock
queues.conf:
[general]
2005 Oct 13
1
TDM04b to SIP extension not ringing (sip to sipworks fine) - resolved but why?
>All,
>I have a TDm04b card an 8 SIP extensions. Calls come into the TDM and
>are answerd by the auto attendant. When an extensions is entered I see
>the Dial(SIP/100) on the console but the phone never rings...
>I can pick up any extension and call 100 and it rings just fin>e and they
>answer and everthing is fine. All 8 extensions can dial 9 for an analog line
>and call
2005 Mar 15
6
Realtime config
Having problems getting realtime working, I'm trying to use odbc for all
of this. I've got Fedora 3 and have been fighting with odbc for a day
now. I think I got it working correctly, however I can't seem to get the
realtime portion working. In asterisk 'odbc show' shows it connected, I
see it on my (odbc) mysql server connected and all, it connects and just
idles. So, without
2007 May 23
1
Asterisk Realtime problem
Hi,
I have installed asterisk-1.4.4 and asterisk-addon-1.4.1.
I followed every step to configure RealTime but something is not working
properly; the warning that I am geting is:
WARNING[32709]: config.c:1229 find_engine: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
WARNING[1359]: config.c:1229 find_engine: Realtime mapping for
2011 Mar 07
2
Asterisk 1.6 MySQL Realtime fails to connect with working username and password.
Okay, so here's the configuration I have for MySQL Realtime (Asterisk
version 1.6.2.17):
In /etc/asterisk/extconfig.conf:
sipusers => mysql,mya2billing,cc_sip_buddies
In /etc/asterisk/res_mysql.conf:
[mya2billing]
dbhost = localhost
dbname = mya2billing
dbuser = a2billinguser
dbpass = REDACTED
dbport = 3306
And here's the error messages I get:
voip2*CLI> realtime mysql status
2004 Dec 14
3
Realtime problem
I'm having trouble with the Realtime setup. I've followed the instructions on
voip-info using odbc but I get this message during asterisk boot:
Parsing '/etc/asterisk/sip.conf': Not found (No such file or directory)
Dec 14 16:11:37 NOTICE[8868]: chan_sip.c:8462 reload_config: Unable to load
config sip.conf, SIP disabled
== Registered channel type 'SIP' (Session
2008 Mar 07
3
Asterisk Realtime and SIP configuration
Dear all
I'm writing to the list for help as a last resort. I've exhausted all
other options, so please forgive me. I've lurked here for years but
never actually posted.
I'm trying to get Asterisk Realtime SIP configuration working, but it
refuses to do so. I have all the necessary configuration in place,
Asterisk makes a connection to the database, which can be verified with
2005 Feb 13
1
Mysql and SIP real time configuration...
2006 Mar 02
1
Sip Realtime Configs Samples with MySQL
Guys,
I'm having a hellava time getting realtime to work, focused on sipusers right now, followed the wiki and other examples but still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database
2004 Dec 12
3
Problems getting Asterisk Realtime to work
I have installed the CVS Head as of 12/12/04, as well
as the asterisk-addons to ensure that
/usr/lib/asterisk/modules/res_config_mysql.so exists.
I have configured the following (after building a new
DB with the appropriate SQL examples, with mods to
drop the invalid keys, on the Wiki):
- /etc/asterisk/res_mysql.conf
[general]
dbhost = 127.0.0.1
dbname = my_db
dbuser = my_uname
dbpass =
2009 Oct 08
1
Realtime static does not work in 1.6.1 or 1.6.2
Starting with Asterisk 1.2 I have always used realtime static to load
my extensions.conf into Asterisk. It worked perfectly up to version
1.6.0.X but starting from 1.6.1.X and upwards it simply does nothing. I
can see that the extensions.conf file is mapped to the database:
== Parsing '/etc/asterisk/asterisk.conf': == Found
== Parsing '/etc/asterisk/extconfig.conf': ==
2004 Dec 30
1
RealTime Drivers Connectivity Error
Hello *'s,
i am using Realtime Sip drivers but its not working here is my configs:
extconfig.conf
[settings]
; Realtime configuration engine
;
; maps a particular family of realtime
; configuration to a given database driver,
; database and table (or uses the name of
; the family if the table is not specified
;
sipfriends => mysql,asterisk,sip_friends
res_mysql.conf
[general]
dbhost =
2010 Sep 08
1
Upgrade from 1.4 to 1.6 : problems with realtime mysql
Hello,
in asterisk 1.4.30 all realtime configurations go well.
In asterisk 1.6.2.11 the following appears on CLI :
[Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
MySQL RealTime: Invalid database specified: MyDBase (check res_mysql.conf)
[Sep 8 16:43:43] WARNING[1843]: res_config_mysql.c:325 realtime_mysql:
MySQL RealTime: Invalid database specified: MyDBase (check