Re: Settngs for Sip Manager

2021-08-26 Thread Maxim Solodovnik
On Thu, 26 Aug 2021 at 21:03, Yah's Global Kingdom 
wrote:

> Maxim, even if my openmeetings database is open504, this needs to be set
> to openmeetings?
>

Yes
This is NOT MySQL OM DB
This is Asterisk internal key-value DB :)


>
> On Tue, Aug 24, 2021 at 11:09 PM Maxim Solodovnik 
> wrote:
>
>>
>>
>> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom 
>> wrote:
>>
>>> Hi Maxim,
>>>
>>> Thanks for responding:
>>> What I am getting is invalid extension,  when I run asterisk -rx
>>> database show, I don't see anything from openmeetings
>>>
>>> meetings*CLI> database show
>>> /SIP/Registry/horace  : 1.1.1.1:49952
>>> :60:horace:sip:horace@1.1.1.1.1
>>> :49952;transport=UDP;rinstance=fd20fb9e9a736274
>>> /SIP/Registry/horacecell  : 172.58.69.178:45874
>>> :60:horacecell:sip:horacecell@172.58.69.178:45874
>>> ;transport=UDP;rinstance=d0bae988fae57944
>>> /dundi/secret :
>>> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
>>> /dundi/secretexpiry   : 1629852193
>>>
>>> /pbx/UUID :
>>> 7dd6882b-8da9-4099-a6a7-3012970c94ca
>>> 5 results found.
>>>
>>> I am confused by these two lines in the Extensions.conf:
>>> exten =>
>>> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
>>> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>>>
>>
>> Well
>> I'm not sure why do you have such portion of config :(
>>
>> "reference" config looks like
>> https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions
>>
>> `openmeetings/rooms/` is NOT DB table but some internal Asterisk
>> key-value DB
>> so `open504/rooms` looks wrong here
>> It should be `openmeetings/rooms`
>>
>>
>>
>>>
>>> 1.  in the database open504 I don't find a table named rooms, the table
>>> name in the database is room.
>>> 2.   I don't know why it is not registering the open504 database with
>>> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
>>> (just me thinking)
>>>
>>> meetings*CLI>
>>> Tables_in_open504  |
>>> ++
>>> | address|
>>> | appointment|
>>> | chat   |
>>> | conference_log |
>>> | configuration  |
>>> | email_queue|
>>> | extra_menu |
>>> | file_log   |
>>> | group_user |
>>> | invitation |
>>> | ldapconfig |
>>> | meeting_member |
>>> | menu_group |
>>> | oauth_mapping  |
>>> | oauth_server   |
>>> | om_calendar|
>>> | om_file|
>>> | om_group   |
>>> | om_user|
>>> | om_user_right  |
>>> | private_message|
>>> | private_message_folder |
>>> | recording_chunk|
>>> | room   |
>>> | room_file  |
>>> | room_group |
>>> | room_hide_element  |
>>> | room_moderator |
>>> | room_poll  |
>>> | room_poll_answer   |
>>> | sessiondata|
>>> | sipusers   |
>>> | soaplogin  |
>>> | user_contact   |
>>> ++
>>> 34 rows in set (0.00 sec)
>>>
>>>
>>>
>>> +--+--+--+-+-++
>>> | Field| Type | Null | Key | Default | Extra
>>>  |
>>>
>>> +--+--+--+-+-++
>>> | id   | bigint(20)   | NO   | PRI | NULL|
>>> auto_increment |
>>> | deleted  | bit(1)   | NO   | | NULL|
>>>  |
>>> | inserted | datetime | YES  | | NULL|
>>>  |
>>> | updated  | datetime | YES  | | NULL|
>>>  |
>>> | allow_recording  | bit(1)   | NO   | | NULL|
>>>  |
>>> | allow_user_questions | bit(1)   | NO   | | NULL|
>>>  |
>>> | appointment  | bit(1)   | NO   | | NULL|
>>>  |
>>> | audio_only   | bit(1)   | NO   | | NULL|
>>>  |
>>> | capacity | bigint(20)   | YES  | | NULL|
>>>  |
>>> | chat_moderated   | bit(1)   | NO   | | NULL|
>>>  |
>>> | chat_opened  | bit(1)   | NO   | | NULL|
>>>  |
>>> | closed   | bit(1)   | NO   | | NULL|
>>>  |
>>> | comment  | text | YES  | | NULL|
>>>  |
>>> | confno   | varchar(255) | YES  | | NULL|
>>>  |
>>> | demo_room| bit(1)   | NO   | | NULL|
>>>  |
>>> | demo_time| int(11)  | YES  | | NULL|
>>>  |
>>> | external_id  | varchar(255) | YES  | | NULL|
>>>  |
>>> | files_opened | bit(1)   | NO   | | NULL|
>>>  |
>>> | ispublic | bit(1)  

Re: Settngs for Sip Manager

2021-08-26 Thread Yah's Global Kingdom
Maxim, even if my openmeetings database is open504, this needs to be set to
openmeetings?

On Tue, Aug 24, 2021 at 11:09 PM Maxim Solodovnik 
wrote:

>
>
> On Wed, 25 Aug 2021 at 09:38, Yah's Global Kingdom 
> wrote:
>
>> Hi Maxim,
>>
>> Thanks for responding:
>> What I am getting is invalid extension,  when I run asterisk -rx database
>> show, I don't see anything from openmeetings
>>
>> meetings*CLI> database show
>> /SIP/Registry/horace  : 1.1.1.1:49952
>> :60:horace:sip:horace@1.1.1.1.1
>> :49952;transport=UDP;rinstance=fd20fb9e9a736274
>> /SIP/Registry/horacecell  : 172.58.69.178:45874
>> :60:horacecell:sip:horacecell@172.58.69.178:45874
>> ;transport=UDP;rinstance=d0bae988fae57944
>> /dundi/secret :
>> Bk1zG+mtsgGrpKsMJw09EA==;wS1dMgw+F1jfle4crmWRAA==
>> /dundi/secretexpiry   : 1629852193
>>
>> /pbx/UUID :
>> 7dd6882b-8da9-4099-a6a7-3012970c94ca
>> 5 results found.
>>
>> I am confused by these two lines in the Extensions.conf:
>> exten =>
>> _400X!,1,GotoIf($[${DB_EXISTS(open504/rooms/${EXTEN})}]?ok:notavail)
>> exten => _400X!,n(ok),SET(PIN=${DB(open504/rooms/${EXTEN})})
>>
>
> Well
> I'm not sure why do you have such portion of config :(
>
> "reference" config looks like
> https://openmeetings.apache.org/AsteriskIntegration.html#configure-extensions
>
> `openmeetings/rooms/` is NOT DB table but some internal Asterisk
> key-value DB
> so `open504/rooms` looks wrong here
> It should be `openmeetings/rooms`
>
>
>
>>
>> 1.  in the database open504 I don't find a table named rooms, the table
>> name in the database is room.
>> 2.   I don't know why it is not registering the open504 database with
>> Asterisk,  I am thinking the transport Agent is suppose to do that somehow,
>> (just me thinking)
>>
>> meetings*CLI>
>> Tables_in_open504  |
>> ++
>> | address|
>> | appointment|
>> | chat   |
>> | conference_log |
>> | configuration  |
>> | email_queue|
>> | extra_menu |
>> | file_log   |
>> | group_user |
>> | invitation |
>> | ldapconfig |
>> | meeting_member |
>> | menu_group |
>> | oauth_mapping  |
>> | oauth_server   |
>> | om_calendar|
>> | om_file|
>> | om_group   |
>> | om_user|
>> | om_user_right  |
>> | private_message|
>> | private_message_folder |
>> | recording_chunk|
>> | room   |
>> | room_file  |
>> | room_group |
>> | room_hide_element  |
>> | room_moderator |
>> | room_poll  |
>> | room_poll_answer   |
>> | sessiondata|
>> | sipusers   |
>> | soaplogin  |
>> | user_contact   |
>> ++
>> 34 rows in set (0.00 sec)
>>
>>
>>
>> +--+--+--+-+-++
>> | Field| Type | Null | Key | Default | Extra
>>  |
>>
>> +--+--+--+-+-++
>> | id   | bigint(20)   | NO   | PRI | NULL|
>> auto_increment |
>> | deleted  | bit(1)   | NO   | | NULL|
>>  |
>> | inserted | datetime | YES  | | NULL|
>>  |
>> | updated  | datetime | YES  | | NULL|
>>  |
>> | allow_recording  | bit(1)   | NO   | | NULL|
>>  |
>> | allow_user_questions | bit(1)   | NO   | | NULL|
>>  |
>> | appointment  | bit(1)   | NO   | | NULL|
>>  |
>> | audio_only   | bit(1)   | NO   | | NULL|
>>  |
>> | capacity | bigint(20)   | YES  | | NULL|
>>  |
>> | chat_moderated   | bit(1)   | NO   | | NULL|
>>  |
>> | chat_opened  | bit(1)   | NO   | | NULL|
>>  |
>> | closed   | bit(1)   | NO   | | NULL|
>>  |
>> | comment  | text | YES  | | NULL|
>>  |
>> | confno   | varchar(255) | YES  | | NULL|
>>  |
>> | demo_room| bit(1)   | NO   | | NULL|
>>  |
>> | demo_time| int(11)  | YES  | | NULL|
>>  |
>> | external_id  | varchar(255) | YES  | | NULL|
>>  |
>> | files_opened | bit(1)   | NO   | | NULL|
>>  |
>> | ispublic | bit(1)   | NO   | | NULL|
>>  |
>> | moderated| bit(1)   | NO   | | NULL|
>>  |
>> | name | varchar(255) | YES  | MUL | NULL|
>>  |
>> | owner_id | bigint(20)   | YES  | | NULL|
>>  |
>> | pin 

Re: Testing OM 7.0.0 #.....

2021-08-26 Thread Alvaro
## OM 7.0.0 #14

Server: Ubuntu 18.04 - OM 7.0.0 #14

Server: Ubuntu 21.04 - OM 7.0.0 #14

Client: OSx 11.5.2 - Safari 14.1.2 - Firefox 91.0 - Chrome_Chromium 92.0.415 - 
Yandex

Client: Ubuntu 18.04 - Firefox 91.0 - Chrome 92.0.415

 ...no issues found.


-



On Fri, 13 Aug 2021 11:47:50 +0200
Alvaro  wrote:

> # OM 7.0.0 #13
> 
>  Server: Ubuntu 18.04 - OM 7.0.0 #13
> 
>  Client: OSx 11.5.2 - Safari 14.1.2 - Firefox 91.0 - Chrome_Chromium 92.0.415
> 
>  Client: Ubuntu 18.04 - Firefox 91.0 - Chrome 92.0.415
> 
>  ...no issues found.
> 
> 
> ---
> 
> 
> On Wed, 11 Aug 2021 12:54:47 +0200
> Alvaro  wrote:
> 
> > # OM 7.0.0 #12
> > 
> >  Server: Ubuntu 18.04 - OM 7.0.0 #12
> > 
> >  Client: OSx 11.5.2 - Safari 14.1.2 - Firefox 90.0.2 - Chrome_Chromium 92
> > 
> >  Client: Ubuntu 18.04 - Firefox 90.0.2 - Chrome 92
> > 
> >  ...no issues found.
> > 
> > 
> > ..
> > 
> > 
> > On Thu, 5 Aug 2021 17:56:14 +0200
> > Alvaro  wrote:
> > 
> > > It would be good if a user does the test and not
> > > finds errors, just expose it on
> > > first send the mail to this thread,
> > > so that the successive tests about the different
> > > snapshots are next to each other and so you can
> > > clearly see the differences between the snapshots.
> > > 
> > > Only if errors were found then, the second user
> > > would expose it succinctly in this thread and open
> > > a jira exposing the error in its entirety.
> > > 
> > > Thank you.
> > > 
> > > 
> > > .
> > > 
> > > 
> > > On Thu, 5 Aug 2021 14:45:57 +0300
> > > Ali Alhaidary  wrote:
> > > 
> > > > # OM 7.0.0 #10
> > > > 
> > > > Server: Ubuntu 18.04 - OM 7.0.0 #10
> > > > 
> > > > Client: OSx 11.5.1 - Sefari 14.1.2 - Firefox 90.0.2
> > > > 
> > > > Client: Ubuntu 18.04 - Firefox 90.0.2
> > > > 
> > > > ...no errors found.
> > > > 
> > > > On 8/5/21 12:24 PM, Alvaro wrote:
> > > > > Hello,
> > > > >
> > > > > This thread is only to show the results of testing
> > > > > the successive snapshots of OM 7.0.0.
> > > > >
> > > > > 
> > > > >
> > > > > # OM 7.0.0 #10
> > > > >
> > > > > Server: Ubuntu 18.04 - OM 7.0.0 #10
> > > > >
> > > > > Client: OSx 11.5.1 - Sefari 14.1.2 - Firefox 90 - Chrome_Chromium 92
> > > > >
> > > > > Client: Ubuntu 18.04 - Firefox 90 - Chrome 92
> > > > >
> > > > > ...no errors found.
> > > > >
> > > > > 
> > > > >
> > > > >   
> > > > >
> > > > >
> > > > >
> > > 
> > > 
> > > -- 
> > > 
> > 
> > 
> > -- 
> > 
> 
> 
> -- 
> 


-- 



Re: Registering on behalf of users - no confirmation email

2021-08-26 Thread Ali Alhaidary


On 8/26/21 8:46 AM, Maxim Solodovnik wrote:

I would call it: security issue :)
IMO such destructive action like purging user should be very much 
secured 
Admins periodically review user list and remove old, not fully 
registered or not verified users.  Also, a user needs to remove his 
contact information if the application keeps interacting with him by 
email for example, however, OM does not do that.


On Thu, 26 Aug 2021 at 12:44, Lee But > wrote:


Isn't there a way to send an ID key in the invitation email that
can automatically remove the record that matches the key. Or,
match the email address?

On Thu, Aug 26, 2021 at 5:36 AM Maxim Solodovnik
mailto:solomax...@gmail.com>> wrote:



On Thu, 26 Aug 2021 at 12:18, Lee But
mailto:leesenglishless...@gmail.com>> wrote:

Hello Maxim,

The  is just to point to the website
that openmeetings is on so that the user can recognise it.
Example, Maxim Solodonvik at www.openmeetings.apache.org
 has invited you to
join their online meeting room(s).
Perhaps, it would be better if the admin could create an
'organisation name' and have that in the invitation instead.

The , would point directly to a page to change the
password and complete registration.


Well
Actually both URLs will be
https://om.alteametasoft.com/openmeetings/signin

This is why I'm asking :)


What I mean by 'deregister' is to remove the information
that the admin created: names, password and email address.
That may not be clear.

I suppose it could read, 'If you have received this
invitation in error or do not wish to join the meeting
room(s), please _click here_ to deregister your
information shown in this email.'


As I wrote before
this is impossible without successful login
which impossible without "change the password and complete
registration"
So the footer looks useless to me :(



On Thu, Aug 26, 2021 at 4:59 AM Maxim Solodovnik
mailto:solomax...@gmail.com>> wrote:

Thanks for the templates :)

I'll do the following:

1) will create the key
`send.invite.to.user.created.by.admin`
2) will use "Formal version" to create the template
(you can modify it any time as described here
https://openmeetings.apache.org/EditTemplates.html
)

Couple of questions:
1) why do we need both "" and
""?
2) why do we need this "If you have received this
invitation in error, please _click here_ to
deregister." footer? the only way to de-register is to
complete registration then to delete themselves 


On Wed, 25 Aug 2021 at 20:39, Ali Alhaidary
mailto:ali.alhaid...@the5stars.org>> wrote:

Nice :-)

Ali

On 8/25/21 3:07 PM, Lee But wrote:

Hello Maxim,

Here are two templates. One is formal, the other
informal. I think it would be useful for admins
to view default templates and create their own
invitations as well.
possible keys could be:

send.formal.invite.to.user.created.by.admin
send.casual.invite.to.user.created.by.admin
send.custom.invite.to.user.created.by.admin

In the examples below, the name order could be
swapped according to the language being used.

*
Formal version

*

Dear  ,

  at
 has invited you to join
their online meeting room(s).

To complete your registration and use the
room(s), please visit the link below and create a
strong password.



Your username for logging in is .

Thank you for joining our meeting rooms.

Best regards,

 


If you have received this invitation in error,
please _click here_ to deregister.



*
Casual version

*

Hi  ,