You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by Jeff Clay <Je...@cyient.com> on 2015/09/29 19:56:26 UTC
asterisk odbc
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.
Re: asterisk odbc
Posted by awotipe oluwaseun <aw...@yahoo.com>.
hi, thanks for all your fixed and information regarding OM, like i said in my previous mail ,when i issue realtime mysql status on asterisk CLI, it returns that asterisk connected via the socket provided in res_config_mysql.conf (see below)
realtime mysql statusgeneral connected to open306 on socket file /var/run/mysqld/mysqld.sock with username root for 15 minutes.however, when i issue database show, i did not get any result as similar to the instruction , If you do not receive an output with that resembles openmeetings/rooms/400## where “##” will equal the extension assigned when you created your roommys res_config_mysql
[general]dbhost=127.0.0.1dbname=open306dbuser=rootdbpass=dbport=3306dbsock= /var/run/mysqld/mysqld.sockdbcharset=utf8requirments=warn
my asterisk profile in the OM from "/opt/red5/webapps/openmeetings/WEB-INF/classes/openmeetings-applicationContext.xml" looks like this <!-- 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>
my question is that is the the db name openmeetings mentioned in extentions.conf as below
exten => _400X!,1,GotoIf($[${DB_EXISTS(openmeetings/rooms/${EXTEN})}]?ok:notavail)exten => _400X!,n(ok),SET(PIN=${DB(openmeetings/rooms/${EXTEN})}) is the same as the asterisk profile or the DB name used when OM is installed.secondly do i need to create a db for asterisk with tables rooms (but i understand that there is already tables for asterisk in the OM database)
third question, how do i get to call into the meetings, is it by dialling extention via a regular sip phone which is same network as OM server or by any other means.please i dpend on your understanding if i need to move forward with this project.thanks
On Sunday, December 13, 2015 1:48 AM, Maxim Solodovnik <so...@gmail.com> wrote:
OM is not using "insecure" column, it uses encrypted password onlyyou can manually add this column if it is necessary for you
On Sat, Dec 12, 2015 at 3:12 AM, awotipe oluwaseun <aw...@yahoo.com> wrote:
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 <so...@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 <Je...@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:awotipeoluwaseun@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 <Je...@cyient.com> wrote: Accidentally replied directly. From: Jeff Clay
Sent: Wednesday, December 9, 2015 11:11 AM
To: 'awotipe oluwaseun' <aw...@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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:58 AM
To: Jeff Clay <Je...@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 <Je...@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:awotipeoluwaseun@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 <so...@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 <so...@gmail.com> wrote:
Thanks!Will try these settings and will update the steps! On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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:solomax666@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
--
WBR
Maxim aka solomax
Re: asterisk odbc
Posted by Gangadhar Kadam <ga...@indictranstech.com>.
On Tue, Dec 22, 2015 at 5:42 PM, Maxim Solodovnik <so...@gmail.com>
wrote:
>
> ---------- Forwarded message ----------
> From: Maxim Solodovnik <so...@gmail.com>
> Date: Tue, Dec 22, 2015 at 6:12 PM
> Subject: Re: asterisk odbc
> To: Awotipe Oluwaseun <aw...@yahoo.com>
>
>
> Actually it depends on how you set up your Asterisk
> during our tests (couple of years ago) we were able to call to to the room
> using both soft phone and mobile phone
>
> On Tue, Dec 22, 2015 at 1:15 AM, Awotipe Oluwaseun <
> awotipeoluwaseun@yahoo.com> wrote:
>
>> Hi,
>> To call into a meeting in OM, do I need to call via VoIP application or
>> just dia extensions given in diaplan on just regular phone.
>> Sorry for my dump question.
>>
>> oluwaseun
>> On Dec 13, 2015 1:48 AM, Maxim Solodovnik <so...@gmail.com> wrote:
>>
>> OM is not using "insecure" column, it uses encrypted password only
>> you can manually add this column if it is necessary for you
>>
>> On Sat, Dec 12, 2015 at 3:12 AM, awotipe oluwaseun <
>> awotipeoluwaseun@yahoo.com> wrote:
>>
>> 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 <
>> solomax666@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 <Je...@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:awotipeoluwaseun@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 <Je...@cyient.com>
>> wrote:
>>
>>
>> Accidentally replied directly.
>>
>>
>> *From:* Jeff Clay
>> *Sent:* Wednesday, December 9, 2015 11:11 AM
>> *To:* 'awotipe oluwaseun' <aw...@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.1
>> dbname=open306
>> dbuser=root
>> dbpass=M##tOp#n
>> ;dbport=3306
>> dbsock= /var/lib/mysql/mysqld.sock
>> dbcharset=utf8
>> requirments=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,Hangup
>> exten => _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:awotipeoluwaseun@yahoo.com
>> <aw...@yahoo.com>]
>> *Sent:* Wednesday, December 9, 2015 10:58 AM
>> *To:* Jeff Clay <Je...@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.1
>> dbname=open306
>> dbuser=root
>> dbpass=M##tOp#n
>> dbport=3306
>> dbsock= /var/lib/mysql/mysqld.sock
>> dbcharset=utf8
>> requirments=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,Hangup
>> exten => _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 : 1449681730
>> 2 results found.
>>
>>
>> thanks
>>
>> On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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 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:awotipeoluwaseun@yahoo.com
>> <aw...@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 <
>> solomax666@gmail.com> 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 <so...@gmail.com>
>> wrote:
>>
>> Thanks!
>> Will try these settings and will update the steps!
>>
>> On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
>> dbuser = root
>> dbpass = MYPASS
>> dbsock = /var/lib/mysql/mysql.sock
>> dbcharset = utf8
>> requirements=warn
>>
>>
>>
>> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
>> *Sent:* Tuesday, September 29, 2015 3:27 PM
>> *To:* Openmeetings user-list <us...@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 <Je...@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
>>
>>
>>
>>
>>
>> --
>> WBR
>> Maxim aka solomax
>>
>>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
> --
> WBR
> Maxim aka solomax
>
--
Thanks & Regards,
Gangadhar
*Gangadhar Kadam*
Team Leader
New Indictrans Technologies Pvt. Ltd. - Pune
Office: +91-20-65700800 | Mobile: +91-9960066444
Linkedin:-https://www.linkedin.com/in/gangadharkadam
www.indictranstech.com | Lat: 18.501994 Lon: 73.79766
This e-mail has arrived in your e-mail Inbox from New Indictrans
Technologies Private Limited, Pune. Please do visit
http://www.indictranstech.com/ to know more about New Indictrans Private
Limited. This email is not spam. We follow 'US Unsolicited Electronic Mail
Act of 2000', which states that an e-mail cannot be considered SPAM if it
contains contact/removal information, which this e-mail does. This e-mail
may contain proprietary and confidential information and is sent for the
intended recipient(s) only. If, by an addressing or transmission error,
this mail has been misdirected to you, you are requested to delete this
mail immediately. You are also hereby notified that any use, any form of
reproduction, dissemination, copying, disclosure, modification,
distribution and/or publication of this e-mail message, contents or it's
attachment(s) other than by its intended recipient(s) is strictly
prohibited. Any opinions expressed in this email are those of the
individual and not necessarily of the organisation. Before opening
attachment(s), please scan the attachment for viruses.". In case & if you
do not wish to receive e-mail (the way you have received it today for what
so ever cause or reasons) in near future? Reply back to this email saying
"Remove e-mail ID". Within two working days your ID will be removed.
Fwd: asterisk odbc
Posted by Maxim Solodovnik <so...@gmail.com>.
---------- Forwarded message ----------
From: Maxim Solodovnik <so...@gmail.com>
Date: Tue, Dec 22, 2015 at 6:12 PM
Subject: Re: asterisk odbc
To: Awotipe Oluwaseun <aw...@yahoo.com>
Actually it depends on how you set up your Asterisk
during our tests (couple of years ago) we were able to call to to the room
using both soft phone and mobile phone
On Tue, Dec 22, 2015 at 1:15 AM, Awotipe Oluwaseun <
awotipeoluwaseun@yahoo.com> wrote:
> Hi,
> To call into a meeting in OM, do I need to call via VoIP application or
> just dia extensions given in diaplan on just regular phone.
> Sorry for my dump question.
>
> oluwaseun
> On Dec 13, 2015 1:48 AM, Maxim Solodovnik <so...@gmail.com> wrote:
>
> OM is not using "insecure" column, it uses encrypted password only
> you can manually add this column if it is necessary for you
>
> On Sat, Dec 12, 2015 at 3:12 AM, awotipe oluwaseun <
> awotipeoluwaseun@yahoo.com> wrote:
>
> 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 <
> solomax666@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 <Je...@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:awotipeoluwaseun@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 <Je...@cyient.com>
> wrote:
>
>
> Accidentally replied directly.
>
>
> *From:* Jeff Clay
> *Sent:* Wednesday, December 9, 2015 11:11 AM
> *To:* 'awotipe oluwaseun' <aw...@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.1
> dbname=open306
> dbuser=root
> dbpass=M##tOp#n
> ;dbport=3306
> dbsock= /var/lib/mysql/mysqld.sock
> dbcharset=utf8
> requirments=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,Hangup
> exten => _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:awotipeoluwaseun@yahoo.com
> <aw...@yahoo.com>]
> *Sent:* Wednesday, December 9, 2015 10:58 AM
> *To:* Jeff Clay <Je...@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.1
> dbname=open306
> dbuser=root
> dbpass=M##tOp#n
> dbport=3306
> dbsock= /var/lib/mysql/mysqld.sock
> dbcharset=utf8
> requirments=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,Hangup
> exten => _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 : 1449681730
> 2 results found.
>
>
> thanks
>
> On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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 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:awotipeoluwaseun@yahoo.com
> <aw...@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 <
> solomax666@gmail.com> 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 <so...@gmail.com>
> wrote:
>
> Thanks!
> Will try these settings and will update the steps!
>
> On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
> dbuser = root
> dbpass = MYPASS
> dbsock = /var/lib/mysql/mysql.sock
> dbcharset = utf8
> requirements=warn
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Tuesday, September 29, 2015 3:27 PM
> *To:* Openmeetings user-list <us...@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 <Je...@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
>
>
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
--
WBR
Maxim aka solomax
--
WBR
Maxim aka solomax
Re: asterisk odbc
Posted by Maxim Solodovnik <so...@gmail.com>.
OM is not using "insecure" column, it uses encrypted password only
you can manually add this column if it is necessary for you
On Sat, Dec 12, 2015 at 3:12 AM, awotipe oluwaseun <
awotipeoluwaseun@yahoo.com> wrote:
> 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 <
> solomax666@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 <Je...@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:awotipeoluwaseun@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 <Je...@cyient.com>
> wrote:
>
>
> Accidentally replied directly.
>
>
> *From:* Jeff Clay
> *Sent:* Wednesday, December 9, 2015 11:11 AM
> *To:* 'awotipe oluwaseun' <aw...@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.1
> dbname=open306
> dbuser=root
> dbpass=M##tOp#n
> ;dbport=3306
> dbsock= /var/lib/mysql/mysqld.sock
> dbcharset=utf8
> requirments=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,Hangup
> exten => _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:awotipeoluwaseun@yahoo.com
> <aw...@yahoo.com>]
> *Sent:* Wednesday, December 9, 2015 10:58 AM
> *To:* Jeff Clay <Je...@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.1
> dbname=open306
> dbuser=root
> dbpass=M##tOp#n
> dbport=3306
> dbsock= /var/lib/mysql/mysqld.sock
> dbcharset=utf8
> requirments=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,Hangup
> exten => _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 : 1449681730
> 2 results found.
>
>
> thanks
>
> On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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 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:awotipeoluwaseun@yahoo.com
> <aw...@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 <
> solomax666@gmail.com> 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 <so...@gmail.com>
> wrote:
>
> Thanks!
> Will try these settings and will update the steps!
>
> On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
> dbuser = root
> dbpass = MYPASS
> dbsock = /var/lib/mysql/mysql.sock
> dbcharset = utf8
> requirements=warn
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Tuesday, September 29, 2015 3:27 PM
> *To:* Openmeetings user-list <us...@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 <Je...@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
>
>
>
--
WBR
Maxim aka solomax
Re: asterisk odbc
Posted by awotipe oluwaseun <aw...@yahoo.com>.
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 <so...@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 <Je...@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:awotipeoluwaseun@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 <Je...@cyient.com> wrote: Accidentally replied directly. From: Jeff Clay
Sent: Wednesday, December 9, 2015 11:11 AM
To: 'awotipe oluwaseun' <aw...@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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:58 AM
To: Jeff Clay <Je...@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 <Je...@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:awotipeoluwaseun@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 <so...@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 <so...@gmail.com> wrote:
Thanks!Will try these settings and will update the steps! On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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:solomax666@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <Je...@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:awotipeoluwaseun@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 <Je...@cyient.com>
> wrote:
>
>
>
>
>
> Accidentally replied directly.
>
>
>
>
>
> *From:* Jeff Clay
> *Sent:* Wednesday, December 9, 2015 11:11 AM
> *To:* 'awotipe oluwaseun' <aw...@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.1
>
> dbname=open306
>
> dbuser=root
>
> dbpass=M##tOp#n
>
> ;dbport=3306
>
> dbsock= /var/lib/mysql/mysqld.sock
>
> dbcharset=utf8
>
> requirments=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,Hangup
>
> exten => _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:awotipeoluwaseun@yahoo.com
> <aw...@yahoo.com>]
> *Sent:* Wednesday, December 9, 2015 10:58 AM
> *To:* Jeff Clay <Je...@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.1
>
> dbname=open306
>
> dbuser=root
>
> dbpass=M##tOp#n
>
> dbport=3306
>
> dbsock= /var/lib/mysql/mysqld.sock
>
> dbcharset=utf8
>
> requirments=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,Hangup
>
> exten => _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 : 1449681730
>
> 2 results found.
>
>
>
>
>
> thanks
>
>
>
> On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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 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:awotipeoluwaseun@yahoo.com
> <aw...@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 <
> solomax666@gmail.com> 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 <so...@gmail.com>
> wrote:
>
> Thanks!
>
> Will try these settings and will update the steps!
>
>
>
> On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
>
> dbuser = root
>
> dbpass = MYPASS
>
> dbsock = /var/lib/mysql/mysql.sock
>
> dbcharset = utf8
>
> requirements=warn
>
>
>
>
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Tuesday, September 29, 2015 3:27 PM
> *To:* Openmeetings user-list <us...@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 <Je...@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
RE: asterisk odbc
Posted by Jeff Clay <Je...@cyient.com>.
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:awotipeoluwaseun@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 <Je...@cyient.com>> wrote:
Accidentally replied directly.
From: Jeff Clay
Sent: Wednesday, December 9, 2015 11:11 AM
To: 'awotipe oluwaseun' <aw...@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.1
dbname=open306
dbuser=root
dbpass=M##tOp#n
;dbport=3306
dbsock= /var/lib/mysql/mysqld.sock
dbcharset=utf8
requirments=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,Hangup
exten => _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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:58 AM
To: Jeff Clay <Je...@cyient.com>>; user@openmeetings.apache.org<ma...@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.1
dbname=open306
dbuser=root
dbpass=M##tOp#n
dbport=3306
dbsock= /var/lib/mysql/mysqld.sock
dbcharset=utf8
requirments=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,Hangup
exten => _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 : 1449681730
2 results found.
thanks
On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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 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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:04 AM
To: user@openmeetings.apache.org<ma...@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 <so...@gmail.com>> 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 <so...@gmail.com>> wrote:
Thanks!
Will try these settings and will update the steps!
On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
dbuser = root
dbpass = MYPASS
dbsock = /var/lib/mysql/mysql.sock
dbcharset = utf8
requirements=warn
From: Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by awotipe oluwaseun <aw...@yahoo.com>.
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 <Je...@cyient.com> wrote:
#yiv4713364340 #yiv4713364340 -- _filtered #yiv4713364340 {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;} _filtered #yiv4713364340 {panose-1:2 4 5 3 5 4 6 3 2 4;} _filtered #yiv4713364340 {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv4713364340 #yiv4713364340 p.yiv4713364340MsoNormal, #yiv4713364340 li.yiv4713364340MsoNormal, #yiv4713364340 div.yiv4713364340MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4713364340 a:link, #yiv4713364340 span.yiv4713364340MsoHyperlink {color:blue;text-decoration:underline;}#yiv4713364340 a:visited, #yiv4713364340 span.yiv4713364340MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv4713364340 p.yiv4713364340msonormal, #yiv4713364340 li.yiv4713364340msonormal, #yiv4713364340 div.yiv4713364340msonormal {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4713364340 p.yiv4713364340msochpdefault, #yiv4713364340 li.yiv4713364340msochpdefault, #yiv4713364340 div.yiv4713364340msochpdefault {margin-right:0in;margin-left:0in;font-size:12.0pt;}#yiv4713364340 p.yiv4713364340msonormal1, #yiv4713364340 li.yiv4713364340msonormal1, #yiv4713364340 div.yiv4713364340msonormal1 {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4713364340 p.yiv4713364340msochpdefault1, #yiv4713364340 li.yiv4713364340msochpdefault1, #yiv4713364340 div.yiv4713364340msochpdefault1 {margin-right:0in;margin-left:0in;font-size:10.0pt;}#yiv4713364340 span.yiv4713364340msohyperlink {}#yiv4713364340 span.yiv4713364340msohyperlinkfollowed {}#yiv4713364340 span.yiv4713364340emailstyle17 {}#yiv4713364340 span.yiv4713364340msohyperlink1 {color:blue;text-decoration:underline;}#yiv4713364340 span.yiv4713364340msohyperlinkfollowed1 {color:purple;text-decoration:underline;}#yiv4713364340 span.yiv4713364340emailstyle171 {color:#1F497D;}#yiv4713364340 span.yiv4713364340EmailStyle27 {color:#1F497D;}#yiv4713364340 span.yiv4713364340EmailStyle28 {color:#1F497D;}#yiv4713364340 .yiv4713364340MsoChpDefault {font-size:10.0pt;} _filtered #yiv4713364340 {margin:1.0in 1.0in 1.0in 1.0in;}#yiv4713364340 div.yiv4713364340WordSection1 {}#yiv4713364340 Accidentally replied directly. From: Jeff Clay
Sent: Wednesday, December 9, 2015 11:11 AM
To: 'awotipe oluwaseun' <aw...@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.1 dbname=open306 dbuser=root dbpass=M##tOp#n ;dbport=3306 dbsock= /var/lib/mysql/mysqld.sock dbcharset=utf8 requirments=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,Hangup exten => _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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:58 AM
To: Jeff Clay <Je...@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.1 dbname=open306 dbuser=root dbpass=M##tOp#n dbport=3306 dbsock= /var/lib/mysql/mysqld.sock dbcharset=utf8 requirments=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,Hangup exten => _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 : 1449681730 2 results found. thanks On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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:awotipeoluwaseun@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 <so...@gmail.com> 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 <so...@gmail.com> wrote:
Thanks! Will try these settings and will update the steps! On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om dbuser = root dbpass = MYPASS dbsock = /var/lib/mysql/mysql.sock dbcharset = utf8 requirements=warn From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
FW: asterisk odbc
Posted by Jeff Clay <Je...@cyient.com>.
Accidentally replied directly.
From: Jeff Clay
Sent: Wednesday, December 9, 2015 11:11 AM
To: 'awotipe oluwaseun' <aw...@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.1
dbname=open306
dbuser=root
dbpass=M##tOp#n
;dbport=3306
dbsock= /var/lib/mysql/mysqld.sock
dbcharset=utf8
requirments=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,Hangup
exten => _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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:58 AM
To: Jeff Clay <Je...@cyient.com>>; user@openmeetings.apache.org<ma...@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.1
dbname=open306
dbuser=root
dbpass=M##tOp#n
dbport=3306
dbsock= /var/lib/mysql/mysqld.sock
dbcharset=utf8
requirments=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,Hangup
exten => _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 : 1449681730
2 results found.
thanks
On Wednesday, December 9, 2015 10:13 AM, Jeff Clay <Je...@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 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:awotipeoluwaseun@yahoo.com]
Sent: Wednesday, December 9, 2015 10:04 AM
To: user@openmeetings.apache.org<ma...@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 <so...@gmail.com>> 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 <so...@gmail.com>> wrote:
Thanks!
Will try these settings and will update the steps!
On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
dbuser = root
dbpass = MYPASS
dbsock = /var/lib/mysql/mysql.sock
dbcharset = utf8
requirements=warn
From: Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by awotipe oluwaseun <aw...@yahoo.com>.
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 <Je...@cyient.com> wrote:
#yiv4118439187 -- filtered {font-family:Helvetica;panose-1:2 11 6 4 2 2 2 2 2 4;}#yiv4118439187 filtered {panose-1:2 4 5 3 5 4 6 3 2 4;}#yiv4118439187 filtered {font-family:Calibri;panose-1:2 15 5 2 2 2 4 3 2 4;}#yiv4118439187 p.yiv4118439187MsoNormal, #yiv4118439187 li.yiv4118439187MsoNormal, #yiv4118439187 div.yiv4118439187MsoNormal {margin:0in;margin-bottom:.0001pt;font-size:12.0pt;}#yiv4118439187 a:link, #yiv4118439187 span.yiv4118439187MsoHyperlink {color:blue;text-decoration:underline;}#yiv4118439187 a:visited, #yiv4118439187 span.yiv4118439187MsoHyperlinkFollowed {color:purple;text-decoration:underline;}#yiv4118439187 span.yiv4118439187EmailStyle17 {color:#1F497D;}#yiv4118439187 .yiv4118439187MsoChpDefault {font-size:10.0pt;}#yiv4118439187 filtered {margin:1.0in 1.0in 1.0in 1.0in;}#yiv4118439187 div.yiv4118439187WordSection1 {}#yiv4118439187 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:awotipeoluwaseun@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 <so...@gmail.com> 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 <so...@gmail.com> wrote:
Thanks! Will try these settings and will update the steps! On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om dbuser = root dbpass = MYPASS dbsock = /var/lib/mysql/mysql.sock dbcharset = utf8 requirements=warn From: Maxim Solodovnik [mailto:solomax666@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
RE: asterisk odbc
Posted by Jeff Clay <Je...@cyient.com>.
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:awotipeoluwaseun@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 <so...@gmail.com>> 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 <so...@gmail.com>> wrote:
Thanks!
Will try these settings and will update the steps!
On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
dbuser = root
dbpass = MYPASS
dbsock = /var/lib/mysql/mysql.sock
dbcharset = utf8
requirements=warn
From: Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by awotipe oluwaseun <aw...@yahoo.com>.
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 <so...@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 <so...@gmail.com> wrote:
Thanks!Will try these settings and will update the steps!
On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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:solomax666@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <so...@gmail.com>
wrote:
> Thanks!
> Will try these settings and will update the steps!
>
> On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
>>
>> dbuser = root
>>
>> dbpass = MYPASS
>>
>> dbsock = /var/lib/mysql/mysql.sock
>>
>> dbcharset = utf8
>>
>> requirements=warn
>>
>>
>>
>>
>>
>>
>>
>> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
>> *Sent:* Tuesday, September 29, 2015 3:27 PM
>> *To:* Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by Maxim Solodovnik <so...@gmail.com>.
Thanks!
Will try these settings and will update the steps!
On Fri, Nov 13, 2015 at 4:45 AM, Jeff Clay <Je...@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 = om
>
> dbuser = root
>
> dbpass = MYPASS
>
> dbsock = /var/lib/mysql/mysql.sock
>
> dbcharset = utf8
>
> requirements=warn
>
>
>
>
>
>
>
> *From:* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Sent:* Tuesday, September 29, 2015 3:27 PM
> *To:* Openmeetings user-list <us...@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 <Je...@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
RE: asterisk odbc
Posted by Jeff Clay <Je...@cyient.com>.
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:solomax666@gmail.com]
Sent: Tuesday, September 29, 2015 3:27 PM
To: Openmeetings user-list <us...@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 <Je...@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
Re: asterisk odbc
Posted by Maxim Solodovnik <so...@gmail.com>.
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 <Je...@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