Displaying 20 results from an estimated 1000 matches similar to: "how to connect to a remote PostgreSQL database from R on mac osx"
2010 May 21
2
Using unix socket to connect with database
Hello,
I am using asterisk realtime with a postgresql database on the same server.
In res_pgsql.conf I have specified
[general]
dbhost=localhost
dbport=5432
dbname=asteriskdb
dbuser=psql
dbsock=/tmp/.s.PGSQL.5432
Since both asterisk and db are on same server, I would like asterisk
to connect to db using the local unix socket. However asterisk is not
using the local unix socket to connect to
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:
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
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
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 =
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 =
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]
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
2006 Mar 07
7
res_mysql.conf & DNS SRV lookup
Hi friends,
I am using Real Time Asterisk Architecture where I have put the
Sip users/peers and extensions defining the dialplan in tables in
a mysql database.
Currently, asterisk points to my single database server as configured:
------------------------------------------
/etc/asterisk/res_mysql.conf
------------------------------------------
[general]
dbhost = xxx
dbname =
2007 May 22
3
rspec_on_rails'' spec:doc and dry runs
In rspec_on_rails, the spec:doc task uses --dry-run, which doesn''t
jive well with rspec''s ability to write docs for you.
For example, I use the rspec_expectation_matchers plugin from
spicycode.com (scanned for a name, didn''t find one =), and end up
writing specs like:
it { @ticket.should validate_presence_of(:name) }
Which results in specdocs such as:
Ticket
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
2005 Jun 02
1
Asterisk RealTime Voicemail Not Working
I am trying to configure RealTime Voicemail with MySQL. I downloaded
compiled and installed the CVS HEAD for asterisk, and for
asterisk-addons. MySQL seems to be loading correctly (the cdr table
is recording incoming calls). But the RealTime Voicemail doesn't seem
to be checking the database table for the voicemail users. When
trying to login to voicemailMain if I use a user in the
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
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
2010 Jan 12
1
Problem logs queue_log-mysql
Hello!
I'm trying to registers events of queues in /var/log/asterisk/queue_log and Mysql database .I have configured realtime queue_log on MySQL and works well, but /var/log/asterisk/queue_log file is empty, since you're not registering events of queues.
Removing extconfig.conf configurations (queue_log => mysql,general), /var/log/asterisk/queue_log works well, events logs on
2005 Jan 13
1
asterisk realtime msql
Hi there
asterisk goes to 90% cpu usage when trying to authenticate a sip friend using realtime mysql, no other message does appear at cli and asterisk hungs;
here some info:
*CLI> realtime load sipfriends name 104
Jan 13 11:52:21 DEBUG[8928]: res_config_mysql.c:109 realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM sipfriends WHERE name = '104'
Jan 13 11:52:21 DEBUG[8928]:
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 11
5
Realtime + MYSQL
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.
I used the table structure from the asterisk guru postgres howto to
create something
2006 Dec 13
2
Realtime +Mysql +Failover
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 set up with a secondary mysql server to get its data
from. We can set up mysql to sync with its fellow