jeff, thanks alot for your response, i finally get the res_config connected to
the database, but when i dial one of the room extentions i get the below error
in asterisk cli,any ideal of what might be causing this.
[Dec 11 15:00:12] WARNING[41160][C-00000001]: res_config_mysql.c:499
realtime_multi_mysql: MySQL RealTime: Failed to query database: Unknown column
'insecure' in 'where clause'[Dec 11 15:00:12] WARNING[41160][C-00000001]:
res_config_mysql.c:499 realtime_multi_mysql: MySQL RealTime: Failed to query
database: Unknown column 'insecure' in 'where clause'
On Wednesday, December 9, 2015 10:09 PM, Maxim Solodovnik
<solomax...@gmail.com> wrote:
couple of days ago I have updated the instructions with 13.6.0 sources and
menuselect
sudo contrib/scripts/install_prereq install
sudo make menuconfig
Make sure you have selected Add-ons ->
res_config_mysql, Press F12 to save
On Thu, Dec 10, 2015 at 2:01 AM, Jeff Clay <jeff.c...@cyient.com> wrote:
No, sqlite won’t work. You should see “res_config_mysql” as an option under
“Add-ons” when you run “make menuselect” when compiling asterisk. The option is
right underneath “format_mp3”. If the mysql option is greyed out, you will see
the packages that it requires listed at the bottom at “Depends on:” You might
try searching google for a tuturial on installing 13.6.0 on whichever distro
you’re using. From: awotipe oluwaseun [mailto:awotipeoluwas...@yahoo.com]
Sent: Wednesday, December 9, 2015 12:11 PM
To: user@openmeetings.apache.org
Subject: Re: asterisk odbc jeff, i notced that res_config_mysql was not loaded,
when i did modules show, so i decided to upgrade to asterisk 13.6.0, but to my
suprise there no res_config_mysql module in menuconfigselect, instead
res_config_sqlite3 that is there.please advice if can use that, but i know my
database is mysql.thanks On Wednesday, December 9, 2015 11:17 AM, Jeff Clay
<jeff.c...@cyient.com> wrote: Accidentally replied directly. From: Jeff Clay
Sent: Wednesday, December 9, 2015 11:11 AM
To: 'awotipe oluwaseun' <awotipeoluwas...@yahoo.com>
Subject: RE: asterisk odbc Yeah, the instructions on the site are to use ODBC
which isn’t necessary since asterisk has native access to mysql. Make sure that
the file you specified for dbsock actually exists. I’m using centos and the
mysql socket is /var/lib/mysql/mysql.sock. Also, change the highlighted
portions below.
[general];dbhost=127.0.0.1dbname=open306dbuser=rootdbpass=M##tOp#n;dbport=3306dbsock=
/var/lib/mysql/mysqld.sockdbcharset=utf8requirments=warn This change is
necessary because you can’t have two of the same extensions. [rooms]exten =>
_42XX!,1,GotoIf($[${DB_EXISTS(openmeetings/rooms/${EXTEN})}]?ok:notavail)exten
=> _42XX!,n(ok),SET(PIN=${DB(openmeetings/rooms/${EXTEN})})exten =>
_42XX!,n,Set(CONFBRIDGE(user,template)=sip_user)exten =>
_42XX!,n,Set(CONFBRIDGE(user,pin)=${PIN})exten =>
_42XX!,n,Confbridge(${EXTEN},default_bridge,)exten => _42XX!,n,Hangupexten =>
_42XX!,n(notavail),Answer()exten => _42XX!,n,Playback(invalid)exten =>
_42XX!,n,Hangup Your other settings look the same as mine. Be sure that you’re
also configuring red5phone to fully integrate asterisk into the OM rooms.
From: awotipe oluwaseun [mailto:awotipeoluwas...@yahoo.com]
Sent: Wednesday, December 9, 2015 10:58 AM
To: Jeff Clay <jeff.c...@cyient.com>;user@openmeetings.apache.org
Subject: Re: asterisk odbc thanks jeff, below is my configurations, the rsult
that i get is different from what the instruction said.
res_config_mysql.conf[general]dbhost=127.0.0.1dbname=open306dbuser=rootdbpass=M##tOp#ndbport=3306dbsock=
/var/lib/mysql/mysqld.sockdbcharset=utf8requirments=warn
extensions.conf[rooms]exten =>
_42XX!,1,GotoIf($[${DB_EXISTS(openmeetings/rooms/${EXTEN})}]?ok:notavail)exten
=> _42XX!,n(ok),SET(PIN=${DB(openmeetings/rooms/${EXTEN})})exten =>
_42XX!,n,Set(CONFBRIDGE(user,template)=sip_user)exten =>
_42XX!,n,Set(CONFBRIDGE(user,pin)=${PIN})exten =>
_42XX!,n(ok),Confbridge(${EXTEN},default_bridge,)exten => _42XX!,n,Hangupexten
=> _42XX!,n(notavail),Answer()exten => _42XX!,n,Playback(invalid)exten =>
_42XX!,n,Hangup [rooms-originate]exten =>
_42XX!,1,Confbridge(${EXTEN},default_bridge,sip_user)exten => _42XX!,n,Hangup
[rooms-out] [rooms-red5sip]exten =>
_42XX!,1,GotoIf($[${DB_EXISTS(openmeetings/rooms/${EXTEN})}]?ok:notavail)exten
=> _42XX!,n(ok),Confbridge(${EXTEN},default_bridge,red5sip_user)exten =>
_42XX!,n(notavail),Hangup
/opt/red5/webapps/openmeetings/WEB-INF/classes/openmeetings-applicationContext.xml
<!-- Should be uncommented and updated with real values for Asterisk -->
<constructor-arg><value>127.0.0.1</value></constructor-arg>
<constructor-arg><value>5038</value></constructor-arg>
<constructor-arg><value>openmeetings</value></constructor-arg>
<constructor-arg><value>12345</value></constructor-arg> Connected to Asterisk
11.19.0 currently running on openmeetings2 (pid = 54300)openmeetings2*CLI>
database show/dundi/secret :
+2BIS+zVbgEis7lSqNJtAw==;CjuOOOsUgx7+tbp6NblJZw==/dundi/secretexpiry
: 14496817302 results found. thanks On Wednesday, December
9, 2015 10:13 AM, Jeff Clay <jeff.c...@cyient.com> wrote: 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
outhttps://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:awotipeoluwas...@yahoo.com]
Sent: Wednesday, December 9, 2015 10:04 AM
To: user@openmeetings.apache.org
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 <solomax...@gmail.com> wrote: docs are fixed:
http://openmeetings.apache.org/red5sip-integration_3.0.htmlhope I did
everything right :) On Fri, Nov 13, 2015 at 8:53 AM, Maxim Solodovnik
<solomax...@gmail.com> wrote:
Thanks!Will try these settings and will update the steps! On Fri, Nov 13, 2015
at 4:45 AM, Jeff Clay <jeff.c...@cyient.com> 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 = omdbuser = rootdbpass =
MYPASSdbsock = /var/lib/mysql/mysql.sockdbcharset = utf8requirements=warn
From: Maxim Solodovnik [mailto:solomax...@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <user@openmeetings.apache.org>
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 <jeff.c...@cyient.com> 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
--
WBR
Maxim aka solomax
