search for: res_mysql

Hi Is there any harm in using res_mysql for some things and res_odbc for others? We already use res_mysql for ARA but could do with having CEL logged to MySQL. Thanks in Advance Ish -- Ishfaq Malik Department: VOIP Support Company: Packnet Limited t: +44 (0)845 004 4994 f: +44 (0)161 660 9825 e: ish at pack-net.co.uk w: http://www....

...riends, 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 = asterisk dbuser = asterisk dbpass = xxx dbport = 3306 dbsock = /tmp/mysql.sock But what I want to do is to set "dbhost" in "/etc/asterisk/res_mysql.conf" to point asterisk to a DNS SRV reco...

Hi All. I have export some db parameter in /etc/bashrc as follows ... export DB_NAME=xyz export DB_IP=1x.1x.1x.1x export DB_PWD=dkjfaoi Now, I want use these all environment variable into /etc/asterisk/res_mysql.conf file. Is there any way to do this..?? -- Regards, Chandrakant Solanki -------------- next part -------------- An HTML attachment was scrubbed... URL: <http://lists.digium.com/pipermail/asterisk-users/attachments/20110110/51355245/attachment.htm>

...ig.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 'sipusers' found to engine 'mysql', but the engine is not available My cdr_mysql.conf and res_mysql.conf are: /--- cdr_mysql.conf ---/ [global] hostname = localhost dbname = asteriskcdrdb password = passw0rd user = root table = cdr port = 3306 sock = /var/run/mysqld/mysqld.sock userfield = 1 /--- res_mysql.conf ---/ [general] dbhost = localhost dbname = asteriskrealtime dbuser = root dbpass...

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 res_mysql.conf) res_mysql.conf : [general] dbhost = 127.0.0.1 dbname = MyDBase dbuser = asterisk dbpass = mysecret dbport = 3306 dbsock = /tmp/mysql.sock requi...

Hi, Can Asterisk write to multiple MySQL databases in different machines, at the same time, as a backup scheme? If it does, where can that be configured? In res_mysql.conf file? Does anyone ever made it? Regards, Ricardo. -------------- next part -------------- An HTML attachment was scrubbed... URL: http://lists.digium.com/pipermail/asterisk-users/attachments/20070608/c6a9b40c/attachment.htm

.... I make some tests with Asterisk 1.8.2 in Realtime. But i have one problem, the asterisk don't connect in the base and show this message: [Feb 17 11:18:01] WARNING[19061]: res_config_mysql.c:441 realtime_multi_mysql: MySQL RealTime: Invalid database specified: 'asterisk_teste' (check res_mysql.conf) I checked the asterisk config file (res_mysql.conf) and the configuration is ok. My configuration of table and extconfig.conf is the same of the version 1.6.0. The cdr use the same base, same user/pass, and his save the registers ok. This is happening to the queues, queues_members, muscio...

hi,all when i upgrade from 1.4.28 to 1.6.2.1, i can't connect to mysql database anymore, error as follow: [Jan 25 15:38:25] WARNING[3003]: res_config_mysql.c:325 realtime_mysql: MySQL RealTime: Invalid database specified: asterisk (check res_mysql.conf) the content of res_mysql.conf is: http://www.pastebin.org/81966 i've try command " mysql -uroot -proot" ,i can connect to mysql successfully. Could you tell me what's wrong with me ? -- Best regards, Sucan

This is a problem with extconfig.conf - not your res_ or cdr_ ones. In your case - extconfig.conf probably contained something like 'sippeers => mysql,MyDBase,sippeers'. The 'problem' is that the middle parameter is no longer for the database name - it is for the context in res_mysql.conf. So, the above now becomes 'sippeers => mysql,general,sippeers'. Give that a go... Cheers Andy -----Original Message----- From: asterisk-users-bounces at lists.digium.com [mailto:asterisk-users-bounces at lists.digium.com] On Behalf Of Jonas Kellens Sent: 08 September 2010 15:4...

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 localhost configured for mya2billing at localhost, port 3306 with username a2billinguser. mya2billing co...

...update. Check the debug log for possible SQL related entries. Command 'realtime update sipusers set SET port = 4343 WHERE name = 00000277611' failed. [May 18 18:47:16] WARNING[16718]: res_config_mysql.c:559 update_mysql: MySQL RealTime: Invalid database specified: 'asterisk' (check res_mysql.conf) kc3054*CLI> ==> here the system talkes about _another_ config file! <== So which file should i configure: A) res_config_mysql.conf B) res_odbc.conf C) res_mysql.conf But even when i put my credentials in all three of them, still no show! DB check: mysql -h localhost -u voipadmin -...

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

...inal Message ----- From: Matthew Boehm To: Asterisk Users Mailing List - Non-Commercial Discussion Sent: Friday, December 10, 2004 10:02 AM Subject: Re: [Asterisk-Users] MySQL Post your extconfig.conf. Do you have /usr/lib/asterisk/modules/res_config_mysql.so installed? Do you have /etc/asterisk/res_mysql.conf? -Matthew ----- Original Message ----- From: "Bill" <admin@vci.net> To: "Asterisk Users Mailing List - Non-Commercial Discussion" <asterisk-users@lists.digium.com> Sent: Friday, December 10, 2004 8:14 AM Subject: Re: [Asterisk-Users] MySQL > Matthew,...

...user is not found/doesn't exist. If I log in with a user in the voicemail.conf file it works correctly. Any suggestions? Thanks, Michael extconfig.conf: [settings] ;uncomment to load queues.conf via the db engine. ;queues.conf => odbc voicemail => mysql,tenant_new, voicemail_users res_mysql.conf: [general] dbhost = localhost dbname = tenant dbuser = yyyy dbpass = xxxxx ;dbport = 3306 ;dbsock = /tmp/mysql.sock cdr_mysql.conf: [global] hostname=localhost dbname=tenant_new table=cdr password=xxxxx user=yyyy port=3306 sock=/tmp/mysql.sock userfield=1 v...

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 [mysql2] dsn => MySQL-asterisk username => myuser password => mypass pre-...

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'...

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) Verbosity is at least 3 -- Remote UNIX connection ubuntu*CLI> module reload res_config_mysql.so -- Reloading module 'res_co...

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 create the table we need: NOTE: You can use any table name you wish, just make sure the table na...

...still no luck. Using mysql on a seperate server, asterisk actually sees the database and can poll the table "realtime load sipusers" at the cli but asterisk realtime engine is no pulling the user info. I'm using 1.2.4 stable and have the database info in sip.conf, extconfig.conf and res_mysql.conf. Can anyone using mysql send me sample configs and some insight to getting this going? Thanks. JR