similar to: Realtime Voicemail Table Column Name Question

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

Hi All, I'm running 1.2.9.1 and have a sip user setup with accountcode=4444 in the context. lab1*CLI> sip show peer 1234 * Name : 1234 Secret : <Set> MD5Secret : <Not set> Context : sip1004 Subscr.Cont. : <Not set> Language : Accountcode : 4444 AMA flags : Unknown CallingPres : Presentation Allowed, Not Screened Callgroup

Hi All, I'm using asterisk 1.2.9.1 and mysql 3.23, asterisk add-ons 1.2.3. All seems to work normally with realtime voicemail, reads vmbox parameters from the db fine. When I try to change the password, asterisk operates normally, "enter new password" ok, "re-enter new password" ok, "password has been changed" There are no entries in the mysql.log setting the

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

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

Here is what happens on startup: Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Static SQL: SELECT category, var_name, var_val, cat_metric FROM settings WHERE filename='voicemail.conf' and commented=0 ORDER BY filename, cat_metric desc, var_metric asc, category, var_name, var_val, id Sep 15 13:23:51 DEBUG[28130] res_config_mysql.c: MySQL RealTime: Everything is fine. Sep

Still a couple of questions...... I did configure extconfig.conf ... ;iaxusers => odbc,asterisk ;iaxpeers => odbc,asterisk ;sipusers => odbc,asterisk sipusers => mysql,asterisk,sip_devices sippeers => mysql,asterisk,sip_devices ;sippeers => odbc,asterisk ;sipregs => odbc,asterisk ;voicemail => odbc,asterisk ;extensions => odbc,asterisk ;meetme => mysql,general

Hi i have installed a new Asterisk server on Fedora. My first server use Asterisk 1.6.x with a MySQL CDR and realtime. I have a small problems, when i configure on the new server, the same information in MySQL, we have a error: [Jun 3 16:27:59] ERROR[3140] res_config_mysql.c: MySQL RealTime: Failed to connect database server SSI on myhost.myserver.com (err 2003). Check debug for more info.

Hi All, Call comes into Asterisk Asterisk answers and Dials SIP Phone SIP phone has call forward enabled to a long distance number Asterisk receives a SIP response 302 "Moved Temporarily" back from phone Asterisk then forwards inbound call to 'Local/number@context' thanks to phone 2 problems with the CDR: 1. intermittent 'bill sec' accuracy, sometimes 0 even when the

> -----Original Message----- > From: JR Richardson [mailto:jmr.richardson@gmail.com] > Sent: Saturday, June 17, 2006 2:30 PM > To: asterisk-users@lists.digium.com; Douglas Garstang > Subject: Voicemail with NFS (working, I think) > > I'm using a stand-alone VM server and exporting the VM files ro for > MWI function only. All my registration servers mount the remote

Hi! I would like to use the realtime extension of Asterisk and got the latest asterisk-addons from CVS. Upon compiling things, I got a couple of error messages from app_addon_mysql... is it me, or are the files in the CVS broken? Thanks, Christoph

Hi all, A week or so down the list, i read that not many people were using realtime on an Asterisk18, so i had this afternoon a go at it... [sorry for the inconveneant line-wraps] First i did: mysql> create database asterisk; mysql> grant all on asterisk.* to 'voipadmin'@'localhost' identified by next i used the info from the wiki: CREATE TABLE `sip_devices` ( `id`

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`

Hi All, Strange issue, recently I started getting a lot of .lock files in the voicemail /INBOX folder preventing proper access to voicemail. I can delete the .lock files and everything is normal. After searching around, I found some SIP lock file stuff but nothing specific to voicemail. Can someone point me in the right direction to resolve this? I'm runnning 1.2.9 on Debian Sarge.

Hi All, Has anyone else noticed that when a sip phone sitting behind a nat registers to asterisk using realtime database, the private IP of the phone is put into the fullcontact field instead of the public contact IP. The database has the correct public IP in the ipaddr field and correct port number in the port field, which is actually what asterisk uses to to contact the device. This

Hi All, I'm running 1.2.9.1 stable. I'm wondering has this patch been applied to stable release or is it still only in CVS. Will this file patch apply correctly to 1.2.9.1 stable? Which file do I patch? I'm guessing app_directory_realtime_1.6.1.patch <http://bugs.digium.com/file_download.php?file_id=4915&type=bug> and config.h.patch

Hi list! I'd like to save all information about calls (CDR) in a MySQL-Database. I created the DB and a user for Asterisk on a separate server, then I configured my cdr_mysql.conf so: [global] hostname=192.168.10.3 dbname=asterisk table=cdr password=MYSECRET user=asterisk port=3306 and my cdr.conf so: [general] enable=yes unanswered = yes safeshutdown=yes [mysql] usegmtime=no

Ok, i tried the suggestion: Instead of: sippuser => resource, database_name, table_name sippeer => resource, database_name, table_name I put in: sippuser => resource, context, table_name sippeer => resource, context, table_name Unfortunately, with the same results. btw i tried both "general" as "default" Besids the commands i tried below, isn't there any

Hi All, Just wanted to share a story: We turned up a new customer yesterday evening, typical situation, Cisco 2600 Router with T1 PRI card pointed to the customer's analog PBX with 2 data T1's linked back to our network. The router PRI was configured as a gateway on our CCM 4, like we've done numerous times in the past. The customer needed LD Authorization codes enabled, got

Hi All, I'm doing some simple paging functions and using the SIPAddHeader cmd. * 1.2 branch. Using it in the extensions.conf file, it works fine: exten => _*2XX,1,SIPAddHeader(Call-Info: sip:\;answer-after=0) in * console: lab2*CLI> -- Executing SIPAddHeader("SIP/204-0818dcd0", "Call-Info: sip:;answer-after=0") in new stack When i put the same cmd in Realtime