asterisk users - Mar 2005 - Feedback on CBMySql, MeetMe2 and web interface

I've had 50+ people download the web components, and other
than reports of compile issues, I have not heard if this
collection has worked for anyone.

I do plan to keep updating the * applications and the web
pages, but I have almost meet all of our internal requirements
and wonder if anyone else is finding it usefull.

My focus has been and will likely stay on the user interface,
since I have the apps doing most of what we want and need.

About a week ago I uploaded a new tar.gz of the web interface
that added sort and page breaks to the Update/Delete conference
listings.  My next update will integrate the participants caller
ID into the Monitor component, but that is my last planned
non-bug fix update.  If there is something else the wbe interface
should provide, I would love to hear about it.

If no one has been able to make it work, well that would be good
feedback too.

Dan

Hi Dan,

This sorta works for me.  The only thing that doesn't work is the actual
admin functions (changing mode of users from Listen to Listen and Talk,
or Kicking users).

I can see whose in the conferece and see if they are a user or admin though.

kRis

Dan Austin wrote:
> I've had 50+ people download the web components, and other
> than reports of compile issues, I have not heard if this
> collection has worked for anyone.
> 
> I do plan to keep updating the * applications and the web
> pages, but I have almost meet all of our internal requirements
> and wonder if anyone else is finding it usefull.
> 
> My focus has been and will likely stay on the user interface,
> since I have the apps doing most of what we want and need.
> 
> About a week ago I uploaded a new tar.gz of the web interface
> that added sort and page breaks to the Update/Delete conference
> listings.  My next update will integrate the participants caller
> ID into the Monitor component, but that is my last planned
> non-bug fix update.  If there is something else the wbe interface
> should provide, I would love to hear about it.
> 
> If no one has been able to make it work, well that would be good
> feedback too.
> 
> Dan
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
>

Just a guess, but you are using Postgres?  When I started
working on/with the MeetMe2 gui I saw the same problem, found
in the archives that others were seeing it and that using MySQL
just worked.

I tested with Postgres and confirmed that sql updates were not
being written back to the database, but queries worked fine.
It might be a permissions problem or a malformed query.  Fixing
it is next on my list, since I think I want to use a few of
the more advanced Postgres features to extend the functionality
of the interface.

Dan 

-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Kris
Edwards
Sent: Tuesday, March 22, 2005 2:07 PM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Feedback on CBMySql, MeetMe2 and web
interface

Hi Dan,

This sorta works for me.  The only thing that doesn't work is the actual
admin functions (changing mode of users from Listen to Listen and Talk,
or Kicking users).

I can see whose in the conferece and see if they are a user or admin
though.

kRis

Dan Austin wrote:
> I've had 50+ people download the web components, and other
> than reports of compile issues, I have not heard if this
> collection has worked for anyone.
> 
> I do plan to keep updating the * applications and the web
> pages, but I have almost meet all of our internal requirements
> and wonder if anyone else is finding it usefull.
> 
> My focus has been and will likely stay on the user interface,
> since I have the apps doing most of what we want and need.
> 
> About a week ago I uploaded a new tar.gz of the web interface
> that added sort and page breaks to the Update/Delete conference
> listings.  My next update will integrate the participants caller
> ID into the Monitor component, but that is my last planned
> non-bug fix update.  If there is something else the wbe interface
> should provide, I would love to hear about it.
> 
> If no one has been able to make it work, well that would be good
> feedback too.
> 
> Dan
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

The warnings are semi-bogus, since the dbtype can be
either MySQL or Postgress.

Beyond the fact that the warnings refer to Postgres when
using MySQL, it appears that these config Options are not
set.

portsequencedbtable

Dan
-----Original Message-----
From: asterisk-users-bounces@lists.digium.com
[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Kris
Edwards
Sent: Wednesday, March 23, 2005 12:47 AM
To: Asterisk Users Mailing List - Non-Commercial Discussion
Subject: Re: [Asterisk-Users] Feedback on CBMySql, MeetMe2 and web
interface

Actually I'm using mysql.  I couldn't get it to compile w/o the pq libs
though so I had to install postgress.  It's connecting to mysql, but I
do get this stuff in the console:

Mar 23 03:43:16 WARNING[6356]: app_meetme2.c:1426 get_db_params:
PostgreSQL database port not specified.  Using default 5432.
Mar 23 03:43:16 WARNING[6356]: app_meetme2.c:1441 get_db_params:
PostgreSQL database table not specified.  Using default meetme_user.
Mar 23 03:43:16 WARNING[6356]: app_meetme2.c:1456 get_db_params:
PostgreSQL database sequence not specified.  Using default
id_meetme_user.
Mar 23 03:43:16 WARNING[6356]: config_old.c:39 ast_destroy: ast_destroy
is deprecated, use ast_config_destroy instead!
 [app_cbmysql.so] => (Conference Bridge MySQL)


Kris

Dan Austin wrote:
> Just a guess, but you are using Postgres?  When I started
> working on/with the MeetMe2 gui I saw the same problem, found
> in the archives that others were seeing it and that using MySQL
> just worked.
> 
> I tested with Postgres and confirmed that sql updates were not
> being written back to the database, but queries worked fine.
> It might be a permissions problem or a malformed query.  Fixing
> it is next on my list, since I think I want to use a few of
> the more advanced Postgres features to extend the functionality
> of the interface.
> 
> Dan 
> 
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Kris
> Edwards
> Sent: Tuesday, March 22, 2005 2:07 PM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] Feedback on CBMySql, MeetMe2 and web
> interface
> 
> Hi Dan,
> 
> This sorta works for me.  The only thing that doesn't work is the
actual
> admin functions (changing mode of users from Listen to Listen and
Talk,
> or Kicking users).
> 
> I can see whose in the conferece and see if they are a user or admin
> though.
> 
> kRis
> 
> Dan Austin wrote:
> 
>>I've had 50+ people download the web components, and other
>>than reports of compile issues, I have not heard if this
>>collection has worked for anyone.
>>
>>I do plan to keep updating the * applications and the web
>>pages, but I have almost meet all of our internal requirements
>>and wonder if anyone else is finding it usefull.
>>
>>My focus has been and will likely stay on the user interface,
>>since I have the apps doing most of what we want and need.
>>
>>About a week ago I uploaded a new tar.gz of the web interface
>>that added sort and page breaks to the Update/Delete conference
>>listings.  My next update will integrate the participants caller
>>ID into the Monitor component, but that is my last planned
>>non-bug fix update.  If there is something else the wbe interface
>>should provide, I would love to hear about it.
>>
>>If no one has been able to make it work, well that would be good
>>feedback too.
>>
>>Dan
>>_______________________________________________
>>Asterisk-Users mailing list
>>Asterisk-Users@lists.digium.com
>>http://lists.digium.com/mailman/listinfo/asterisk-users
>>To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

> Where's everybody else??  Those 50+ downloaders must be a lot smarter
> than me :D  I didn't have port or dbtable set because I'm using the
> defaults (I'm also using the mysql socket) and I thought sequence was
an
> exclusive postgres setting.  I've put in the info (minus sequence) in
an
> effort to enable the admin functionality.
The version of MeetMe2 I started with had support for both MySQL and
Postgress, but clearly was designed for Postgres.  I need to update
the configuration loading process to take that into account.  The
sequence_id is for Postgres only, but the config loader does not know
that.  It should also consider the different default port/socket for
MySQL.  In any case the warnings can be ignored.
> In all fairness, I don't know how to use this functionality from
within
> the conference, so I can't say that it is the fault of the Web UI.  I
> can get the Admin flag to work (which I can see in the Web UI) and I
can
> get the listen only flag to work (which I can also see in the Web UI).
> If I press the * key to try to access the admin menu I get a
continuous
> loop of the "enter the conference number you wish to join, followed by
> the # key".  If I'm a user and try to access the user menu with *,
I
get
> "enter the channel number".  So, I don't think the problem is
> necessarily with the web ui :)
You are right, it is not related to the web ui.  I have not modified
or tested the admin menu options in MeetMe2.  I suspect it is related
to how I have been using the D|d options to trick the application to
create conference rooms without manually adding them to meetme2.conf.
When I return to my office I will add that to the list of things to
work on.

Dan

Dan Austin wrote:
> The warnings are semi-bogus, since the dbtype can be
> either MySQL or Postgress.
> 
> Beyond the fact that the warnings refer to Postgres when
> using MySQL, it appears that these config Options are not
> set.
> 
> port> sequence> dbtable> 
> 
> Dan
> -----Original Message-----
> From: asterisk-users-bounces@lists.digium.com
> [mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Kris
> Edwards
> Sent: Wednesday, March 23, 2005 12:47 AM
> To: Asterisk Users Mailing List - Non-Commercial Discussion
> Subject: Re: [Asterisk-Users] Feedback on CBMySql, MeetMe2 and web
> interface
> 
> Actually I'm using mysql.  I couldn't get it to compile w/o the pq
libs
> though so I had to install postgress.  It's connecting to mysql, but I
> do get this stuff in the console:
> 
> Mar 23 03:43:16 WARNING[6356]: app_meetme2.c:1426 get_db_params:
> PostgreSQL database port not specified.  Using default 5432.
> Mar 23 03:43:16 WARNING[6356]: app_meetme2.c:1441 get_db_params:
> PostgreSQL database table not specified.  Using default meetme_user.
> Mar 23 03:43:16 WARNING[6356]: app_meetme2.c:1456 get_db_params:
> PostgreSQL database sequence not specified.  Using default
> id_meetme_user.
> Mar 23 03:43:16 WARNING[6356]: config_old.c:39 ast_destroy:
ast_destroy
> is deprecated, use ast_config_destroy instead!
>  [app_cbmysql.so] => (Conference Bridge MySQL)
> 
> 
> Kris
> 
> Dan Austin wrote:
> 
>>Just a guess, but you are using Postgres?  When I started
>>working on/with the MeetMe2 gui I saw the same problem, found
>>in the archives that others were seeing it and that using MySQL
>>just worked.
>>
>>I tested with Postgres and confirmed that sql updates were not
>>being written back to the database, but queries worked fine.
>>It might be a permissions problem or a malformed query.  Fixing
>>it is next on my list, since I think I want to use a few of
>>the more advanced Postgres features to extend the functionality
>>of the interface.
>>
>>Dan 
>>
>>-----Original Message-----
>>From: asterisk-users-bounces@lists.digium.com
>>[mailto:asterisk-users-bounces@lists.digium.com] On Behalf Of Kris
>>Edwards
>>Sent: Tuesday, March 22, 2005 2:07 PM
>>To: Asterisk Users Mailing List - Non-Commercial Discussion
>>Subject: Re: [Asterisk-Users] Feedback on CBMySql, MeetMe2 and web
>>interface
>>
>>Hi Dan,
>>
>>This sorta works for me.  The only thing that doesn't work is the
> 
> actual
> 
>>admin functions (changing mode of users from Listen to Listen and
> 
> Talk,
> 
>>or Kicking users).
>>
>>I can see whose in the conferece and see if they are a user or admin
>>though.
>>
>>kRis
>>
>>Dan Austin wrote:
>>
>>
>>>I've had 50+ people download the web components, and other
>>>than reports of compile issues, I have not heard if this
>>>collection has worked for anyone.
>>>
>>>I do plan to keep updating the * applications and the web
>>>pages, but I have almost meet all of our internal requirements
>>>and wonder if anyone else is finding it usefull.
>>>
>>>My focus has been and will likely stay on the user interface,
>>>since I have the apps doing most of what we want and need.
>>>
>>>About a week ago I uploaded a new tar.gz of the web interface
>>>that added sort and page breaks to the Update/Delete conference
>>>listings.  My next update will integrate the participants caller
>>>ID into the Monitor component, but that is my last planned
>>>non-bug fix update.  If there is something else the wbe interface
>>>should provide, I would love to hear about it.
>>>
>>>If no one has been able to make it work, well that would be good
>>>feedback too.
>>>
>>>Dan
>>>_______________________________________________
>>>Asterisk-Users mailing list
>>>Asterisk-Users@lists.digium.com
>>>http://lists.digium.com/mailman/listinfo/asterisk-users
>>>To UNSUBSCRIBE or update options visit:
>>>  http://lists.digium.com/mailman/listinfo/asterisk-users
>>>
>>
>>
>>_______________________________________________
>>Asterisk-Users mailing list
>>Asterisk-Users@lists.digium.com
>>http://lists.digium.com/mailman/listinfo/asterisk-users
>>To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>_______________________________________________
>>Asterisk-Users mailing list
>>Asterisk-Users@lists.digium.com
>>http://lists.digium.com/mailman/listinfo/asterisk-users
>>To UNSUBSCRIBE or update options visit:
>>   http://lists.digium.com/mailman/listinfo/asterisk-users
>>
> 
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users@lists.digium.com
> http://lists.digium.com/mailman/listinfo/asterisk-users
> To UNSUBSCRIBE or update options visit:
>    http://lists.digium.com/mailman/listinfo/asterisk-users
> 
_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users