The database in res_config_mysql.conf is supposed to be the mysql database of OM. The database mentioned in the extensions.conf file is actually referring the local astdb which is an internal database used by asterisk. Check out https://wiki.asterisk.org/wiki/display/AST/Asterisk+Internal+Database for more information on the astdb. Make sure that “dbname” in res_config_mysql.conf is the same name as you used for OM installation.
From: awotipe oluwaseun [mailto:[email protected]] Sent: Wednesday, December 9, 2015 10:04 AM To: [email protected] Subject: Re: asterisk odbc hi maxim, thanks for the fix but there is still one questions that need to be answered, the database mentioned in the line below in next line is the same metioned in /etc/asterisk/res_config_mysql.conf _400X!,1,GotoIf($[${DB_EXISTS(openmeetings/rooms/${EXTEN})}]?ok:notavail) the rreson is that most new OM release does have Database name after version which does not work for me even after i changed the name in res_config_mysql.conf. please pardone me if i am asking silly question. thanks On Tuesday, December 8, 2015 2:55 AM, Maxim Solodovnik <[email protected]<mailto:[email protected]>> wrote: docs are fixed: http://openmeetings.apache.org/red5sip-integration_3.0.html hope I did everything right :) On Fri, Nov 13, 2015 at 8:53 AM, Maxim Solodovnik <[email protected]<mailto:[email protected]>> wrote: Thanks! Will try these settings and will update the steps! On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <[email protected]<mailto:[email protected]>> wrote: The settings below are confirmed working. No need to mess with ODBC or anything. This tells asterisk to find its sip users in the db. /etc/asterisk/extconfig.conf [settings] sippeers => mysql,general,sipusers /etc/asterisk/res_config_mysql.conf [general] dbname = om dbuser = root dbpass = MYPASS dbsock = /var/lib/mysql/mysql.sock dbcharset = utf8 requirements=warn From: Maxim Solodovnik [mailto:[email protected]<mailto:[email protected]>] Sent: Tuesday, September 29, 2015 3:27 PM To: Openmeetings user-list <[email protected]<mailto:[email protected]>> Subject: Re: asterisk odbc it is necessary to make asterisk to use OM DB, please propose doc change in case you know how to simplify it :) On Tue, Sep 29, 2015 at 11:56 PM, Jeff Clay <[email protected]<mailto:[email protected]>> wrote: Is the purpose of setting up the ODBC settings only to accomplish realtime sip in the mysql database? Asterisk has several realtime drivers already built-in (including mysql) which don’t require near as much configuration. ________________________________ DISCLAIMER: This email may contain confidential information and is intended only for the use of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you are hereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it or attached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at Cyient and delete the original message. -- WBR Maxim aka solomax -- WBR Maxim aka solomax -- WBR Maxim aka solomax
