Displaying 20 results from an estimated 1000 matches similar to: "asterisk realtime msql"
2004 Nov 30
1
realTime configuration help needed
Hello all,
I recently noticed the realTime effort
and must say it is a nice idea!
I would appreciate any help to get it running ..
I downloaded the code & patches and succefully patched my asterisk
(CVS-HEAD-11/29/04-12).
- created a DB called asterisk, and a table sip using the schema
supplied at
http://bugs.digium.com/bug_view_page.php?bug_id=0002613.
- entered an entry:
insert into
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 Nov 20
1
Realtime - mysql query gives wrong results??
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 realtime_mysql:
MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE name =
'tzl'
[Nov
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
2005 Mar 24
1
realtime - unable to find key
ok so my table looks like this...
REATE TABLE `sip` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(80) NOT NULL default '',
`accountcode` varchar(20) default NULL,
`amaflags` varchar(7) default NULL,
`callgroup` varchar(10) default NULL,
`callerid` varchar(80) default NULL,
`canreinvite` char(3) default 'yes',
`context` varchar(80) default NULL,
`defaultip`
2006 Jan 11
1
Better solution to mysql reconnect timeout
vmail*CLI> realtime mysql status
Jan 11 09:53:04 ERROR[3597]: res_config_mysql.c:623 mysql_reconnect: MySQL
RealTime: Failed to reconnect. Check debug for more info.
vmail*CLI> realtime mysql status
Connected to asterisk_vm@tritonvoice.com, port 3306 with username voicemail
for 1 days, 5 hours, 32 minutes, 7 seconds.
vmail*CLI> realtime mysql status
Connected to
2015 May 22
1
Problem with realtime mysql I can't seem to resolve
Hello
I have already several Asterisk servers running with similar
configuration, but now I stumble into a problem.
I have mysql configuration res_config_mysql.conf :
[MyAsteriskDB]
dbhost = 127.0.0.1
dbname = MyAsteriskDB
dbuser = astadmin
dbpass = mysecret
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
requirements=warn ; or createclose or createchar
Realtime seems to be loaded :
2007 Aug 06
1
CDR/MySQL basic config
Hi,
I'm trying to add mysql CDR onto a vanilla Asterisk 1.2 install. The
add-ons pack has been installed for a while, so now I'm trying to add
the Mysql config.
I've created a mysql database, added the grants for a user acces, and
can run a mysql -u asteriskcdruser -p and can connect to the database.
I've been using this as a guide:
2008 Jan 31
0
Realtime device update weirdness
Hello,
We use Asterisk Realtime for our billing software. 200+ installations of Asterisk with Realtime, but I see this for the first time.
Asterisk 1.4.17, Addons 1.4.5, No patches, no NAT - just plain simple installation.
With debug I can see:
[Jan 30 22:38:21] DEBUG[27885]: res_config_mysql.c:662 mysql_reconnect: MySQL RealTime: Everything is fine.
[Jan 30 22:38:21] DEBUG[27885]:
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
2007 Oct 26
1
Realtime Mysql error
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 console and that what i've got:
[Oct 27 01:05:32] ERROR[2607]: res_config_mysql.c:637
2005 May 13
2
Asterisk extensions from Mysql
Hello
I was just stuck around as to how I configure my Asterisk to access
extensions from Mysql. I have made all the necessary changes in the
extconfig.conf, the extensions.conf, res_mysql.conf,
res_config_odbc.conf,res_odbc.conf as they have mentioned on the site
www.voip-info.org <http://www.voip-info.org/> .
But still I am getting the error as
May 13
2009 May 03
2
Asterisk not starting up due to database problems
When I try and start asterisk I get the following, however I have commented out the data the connections in res_mysql.conf and res_pgsql.conf. I am not sure therefore why I am getting these errors. Do I have to change something else to turn this off?
Thanks
Asterisk 1.4.21.2~dfsg-3, Copyright (C) 1999 - 2008 Digium, Inc. and others.
Created by Mark Spencer <markster at digium.com>
Asterisk
2007 Jun 03
0
Strange problem with channel allocation
Hello I just settup a realtime mysql table for sip_peers. All peers
(friends) is autenticateing but when i want to initiate a call between them
i got the following error. Someone have some ideea? Thank you.
---<Cut Here>---
pbx*CLI>console dial 1014
== Console is full duplex
-- Executing [1014@default:1] Dial("OSS/dsp", "SIP/1014|40|t") in new
stack
2007 Jan 15
0
Asterisk Realtime and MD5 authentication
Hi,
I've troubles with setting up Asterisk Realtime and MD5 authentication.
With clear text passwords everything is working fine.
-- Registered SIP 'edwin' at 10.0.0.37 port 5060 expires 600
-- Saved useragent "Cisco-CP7940G/8.0" for peer edwin
[2007-01-15 10:18:12] DEBUG[28528]: res_config_mysql.c:651 mysql_reconnect:
MySQL RealTime: Everything is fine.
2004 Jul 21
1
chan_capi-0.3.4b and asterisk last cvs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hi
i've installed asterisk by last cvs and i note
res_parking.c
is not anymore there; chan_capi-0.3.4b INSTALL file require:
in /etc/asterisk/modules.conf insert the line:
load => res_parking.so
load => chan_capi.so
running asterisk i get:
[app_capiCD.so]Jul 21 15:32:26 WARNING[1076988448]: loader.c:242 ast_load_resource:
2004 Aug 04
1
capturing a call
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Ddoes it feasible with * to capture a call? when arrives a call, floor bells
ring and everyone can hear them in the company, then everyone can answer
'capturing' the call
m.
- --
Maurizio Marini GSM +39-335-8259739
Work: +39-0721-855285 Fax +39-0721-859609
Home: +39-0721-950396 IAXTel: (700) 350-1234
-----BEGIN PGP SIGNATURE-----
Version:
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:
2005 Aug 24
1
RealTime ignoringswitch=>Realtime/context@realtime_ext
I am getting this error when reload my asterisk
"cdr_addon_mysql.c:264 my_load_module: Unable to load config for mysql
CDR's: cdr_mysql.conf"
I don't have res_mysql.conf in /etc/asterisk/. I have res_odbc.conf
which is attached
Res_odbc.conf
==============
;;; odbc setup file
[mysql1]
dsn => MySQL-asterisk
username => myuser
password => mypass
pre-connect => yes
2019 Jun 30
2
Dovecot/MSQL issue
Hello, I'm trying to work through an issue that cropped up on a server I've
been working on and haven't found a very good workaround.
Dovecot is operating in a jailed environment.
The configuration in dovecot-sql.conf.ext has been set appropriately with
the host=127.0.0.1 (which works from a jailed environment) and when dovecot
attempts to auth it appears to perform a reverse dns