Displaying 20 results from an estimated 2000 matches similar to: "Mysql and SIP real time configuration..."
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
2009 Dec 11
2
sip realtime question
Hi everybody,
First of all i am sorry my English :)
i want to configure my asterisk server as a sip server that stores sip users in the mysql database connecting directly over odbc driver. My odbc configuration works as below
[root at ao042 asterisk]# isql -v asterisk
+---------------------------------------+
| Connected! |
| |
|
2005 Aug 18
1
asterisk with odbc
hello
i am trying to use res_odbc for sipuser. my connection
is working. i have checked using isql. even cdr_odbc
is working but i hav problem in res_odbc. i have
created user in sip_buddies table but asterisk is no
getting user from this sip_buddies table.
/etc/asterisk/extconfig.conf
[settings]
sipusers=>odbc,asterisk,sip_buddies
sippeers=>odbc,asterisk,sip_buddies
2010 Jun 08
6
reloading realtime sip peers
Hello,
I noticed that changes to realtime sip peers are not applied until a
'reload'. A 'sip reload' does not make any changes to realtime sip peers.
When changing for instance the mailbox-parameter in the realtime
sip_buddies table, the change is not applied with a 'sip reload'.
For every change there is a complete 'reload' necessary.
Why does a 'sip
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:
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 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.
2010 Aug 03
1
sip.conf register in realtime DB
Hello list,
scrambling different pieces of info together I've come with the following :
I want to have my "register =>" statements in a MySQL-database, so I've
made the following table.
table ast_config :
id 1
cat_metric 0
var_metric 0
commented 0
filename sip.conf
category general
var_name register
var_val username:password at sip.provider.net
In ext_config
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': ==
2005 Jun 28
2
Asterisk Realtime and ODBC
Hello all!
My basic problem is that we haven't been able to get realtime to use ODBC to
store configuration data. Here are the details:
We've installed Asterisk on a CentOS machine as follows:
1. Downloaded, compiled, and installed FreeTDS 0.63
2. Downloaded, compiled, and installed unixODBC 2.2.11
3. Downloaded, compiled, and installed Asterisk, Asterisk-Addons, and Zaptel
from CVS
2009 Oct 31
2
Asterisk, Realtime and specify MySQL Table Name ?
Hi
actually, i test a new Asterisk Server and i want add Mysql Realtime SIP.
I read on the wiki:
===================================================
Database Config
put the following in res_mysql.conf
[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = myuser
dbpass = mypass
dbport = 3306
Values in sip.conf or iax.conf like in older versions of * are no longer
used.
Database Table
Lets
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 09
1
usage of each field
Hi all,
From the web, I can find a table scheme of sipusers for ARA using.
However, I can't find any meaning of each field, especially for the
field regserver which is new in the table. Can any tell me more
detail about the usage of each field?
CREATE TABLE `sip_buddies` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`host` varchar(31) NOT NULL
2009 Jul 17
1
Realtime difference sipusers sippeers
Hi,
I would have expected that peers of type friend ( for example an
SIP-phone) registring at Asterisk will be searched in sipusers.
But the peers will be searched in sippeers.
May be sombody can explain the difference?
Asterisk 1.4
thanks
Thomas
2006 Oct 30
0
Realtime trouble with contex
Hello, Asterisk.
I am currently using Asterisk (asterisk-1.2.13) and asterisk-addons-1.2.3_1
on FreeBSD 6.1-RELEASE-p10
So, after setup asterisk for realtime extension:
res_mysql.conf:
[general]
dbhost = 127.0.0.1
dbname = asterisk
dbuser = asterisk
dbpass = asterisk
dbport = 3306
dbsock = /tmp/mysql.sock
res_odbc.conf:
[mysql]
enabled => yes
dsn => asterisk
username => asterisk
2014 Apr 16
1
DAHDI loading issue on Asterisk
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 Aug 23
1
asterisk+realtime
hello
i m using asterisk-1.0.9. i want to connect to db
through odbc. isql is working. but asterisk is not
getting user information from this table. can any one
pls check this
/etc/asterisk/extconfig.conf
[settings]
sipusers => odbc,mysql1,sip_buddies
sippeers => odbc,mysql1,sip_buddies
sip.conf => odbc,mysql1,sip_buddies
sipfriends => odbc,mysql1,sip_buddies
2005 Aug 23
0
asterisk problem with ODBC
hello
i m using asterisk-1.0.9. i want to connect to db
through odbc. isql is working. but asterisk is not
getting user information from this table. can any one
pls check this
odbc connection is working properly is there some
thing required
/etc/asterisk/extconfig.conf
[settings]
sipusers => odbc,mysql1,sip_buddies
sippeers => odbc,mysql1,sip_buddies
sip.conf =>
2013 Mar 05
1
multiple sipusers tables
Hi,
I have 2 databases DBNAME1 and DBNAME2. In each database I have a table called sipusers (so DBNAME1.sipusers and DBNAME2.sipusers).
Can I use both sipusers tables in Asterisk RealTime?
Something like this:
/etc/asterisk/extconfig.conf:
[settings]
sipusers => odbc,DBNAME1,sipusers
sippeers => odbc,DBNAME1,sipusers
sipusers => odbc,DBNAME2,sipusers
sippeers =>