similar to: extensions in mysql

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

Hi all, I have a problem with using remote MySQL database server with two Asterisk (1.4.17) servers. PhoneA registers with Asterisk#1 using realtime into MySQL on remote server and everything is working fine and when I call Phone A from Phone B (also registered with Asterisk#1) call is established. Problem is when I call PhoneA (which is registered with Asterisk#1) from PhoneC (which is

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

Voicemail.conf in MySQL is not functioning where I get the following error from Asterisk messages log file: CLI debug output is as follows: Executing VoiceMailMain2("SIP/2205-3df0", "") in new stack -- Playing 'vm-login' -- Playing 'vm-password' -- Incorrect password '1234' for user '0' (context = <any>) -- Playing

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

Dear friends, Asterisk's voicemail functions work fine for me, but I am having difficulty storing the voice messages inside mysql. My real-time CDR recording works so I assume the odbc connection is fine. The voicemail.conf I have is : [general] format = wav attach = yes dbuser=root dbpass=sqlpass dbhost=localhost dbname=asterisk odbcstorage=asterisk odbctable=voicemessages Asterisk shows

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

First of all, you can probably go online before you convert all passwords. You can modify your query in dovecot-sql.conf.ext to something like the following: SELECT IF(crypt_pass IS NULL OR crypt_pass='', CONCAT('{PLAIN}',plain_pass), crypt_pass) as password FROM mailuser .. This is assuming that: * for incoming users, you have a plain_pass column containing just the plaintext

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 =

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

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

Hi all, I have been trying to get my asterisk (v1.2.10) to lookup voicemail config data from my mysql database as opposed to voicemail.conf + sip.conf for my users. Users register with SER and get passed through to asterisk when they dial out. I followed the instructions as per http://www.voip-info.org/wiki/view/Asterisk+voicemail+database so basically I have 1) Build asterisk-addons-1.2.5 and

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.

You do need to complete the query. Don't just replace your query with the one I wrote. You have to have a WHERE clause, and you might need to return other fields. Keep the password query you had before, just replace the 'password' column with "IF( ... ) as password" The query as you have it now simply returns all the passwords for all the users, because you don't have a

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

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

Thought I'd post this, see if anyone has experienced this...I am using Asterisk 1.6 from the SVN branch and Asterisk-addons 1.6 from the SVN branch. Mysql is running and I've connected using the information that is in res_mysql.conf but when I try to check the realtime status I get the following: Connected to Asterisk SVN-branch-1.6.0-r117183 currently running on ubuntu (pid = 31371)

The author of CBMysql mentioned in his readme that it would be better if MeetMe read everything directly from the database. I was bored so I put this together in a few hours. This patch will allow app_meetme to dynamically lookup conference numbers and pins in a database (MySQL). This allows for easy creation of web-based conference administration. INSTRUCTIONS: Apply the patch. Create a new

Hi, 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

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