similar to: Asterisk 1.6 MySQL Realtime fails to connect with working username and password.

Hello All, I manage to configure Asterisk RealTime and now it loads the SIP users/peers from MySQL DB. The table I am using is of A2Billing DB "cc_sip_buddies". Now the only problem I am facing is incoming calls are failing... The ATA which is assigned this DID number is behind NAT and according to Olle's explanations he said "*there's no support for NAT keep-alives

Hi guys. I am facing this problem here, using a2billing. error: 'Access denied for user 'a2billinguser'@'localhost' (using password: YES)' I am following this step by step http://www.asterisk2billing.org/cgi-bin/trac.cgi/wiki/Installation%20Guideand wend i get into the point that i have to Create a2billing database i am getting this message above. I even try to remove the

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

Hi I do have asterisk running in real time I do want to add voicemail to real time. I did follow : http://www.voip-info.org/wiki-Asterisk+RealTime+Voicemail However when I do try to make a voicemail I do get : [Nov 20 12:17:04] NOTICE[16501]: chan_sip.c:5506 process_sdp: No compatible codecs, not accepting this offer! -- Executing [999alijawad at a2billing:1]

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]:

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

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 =

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

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

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

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]:

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

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.

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

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, and using a few pattern matching extensions as well. I can certainly detail all database rows if

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

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

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 :

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:

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`