You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@openmeetings.apache.org by "Chamberland, Martin" <Ma...@fadq.qc.ca> on 2017/11/02 15:18:32 UTC

LDAP question (same user multiple time)

Hi there,

We just finished install OpenMeetings 3.3.0 and it's connect to our AD 2016 (ldap).
The problem we see is that everytime a new user connect, it create again and again.

I remember there is a parameter somewhere to correct this issue but i can't find it in 3.3.0

Is that in the ldap.cfg file or in the web-interface ?

Thank's

Martin C.



Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
Sorry Martin for lowercasing your name :(

On Fri, Nov 3, 2017 at 12:22 PM, Maxim Solodovnik <so...@gmail.com> wrote:
> Hello martin,
>
> According to the code Users should not be duplicated login will be
> unique for given LDAP server
> Maybe you can share you LDAP config (masking sensitive information)
> and show content of om_user DB table with duplicate entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin
> <Ma...@fadq.qc.ca> wrote:
>> Hi there,
>>
>>
>>
>> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD 2016
>> (ldap).
>>
>> The problem we see is that everytime a new user connect, it create again and
>> again.
>>
>>
>>
>> I remember there is a parameter somewhere to correct this issue but i can’t
>> find it in 3.3.0
>>
>>
>>
>> Is that in the ldap.cfg file or in the web-interface ?
>>
>>
>>
>> Thank’s
>>
>>
>>
>> Martin C.
>>
>>
>>
>>
>
>
>
> --
> WBR
> Maxim aka solomax



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
I think Alvaro must include some detail about the flash installation on the page 2 (section 5).
Maybe just mention that this section is for client only. (just my 2 cents).

De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 7 novembre 2017 07:55
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I have tested 4.0.x version
LDAP related code is almost the same for 3.3.x and 4.0.x branches (there were no LDAP issues for a long time .... )

On Tue, Nov 7, 2017 at 7:45 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Maxim,

When you are saying « most recent version », is that 4.x ?
Or latest version of 3.3.x ? (which is ?)

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 4 novembre 2017 11:14
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello Martin,

just have tested using following steps:

1) set up LDAP integration
2) login as LDAP user test
3) logout
4) login as admin
5) add right 'Admin'
6) Save
7) login as LDAP user test
Result: user is able to login, has Admin rights, there is no duplicated users

So everything seems to work as expected
Maybe some additional steps need to be performed?

PS I have tested most recent version


On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
As usual Maxim, thank’s for your quick reply.  It’s really appreciate !

Have a good night !

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 14:02

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I see,
It should be easier :)
Will try to check LDAP tomorrow and will let you know

On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
It’s not a upgrade.  We installed  it from scratch.


-          Install OM  3.3.x  or 4.x

-          Connect to  AD 2016 (ldap)

-          Modify to use SSL (5543)

-          Use it ☺


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:59

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:55

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
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



--
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
Of course, if the problem still happen here with 4.0, i will ask you how to get those details information for troubleshoot.

De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 7 novembre 2017 07:58
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I case the issue will be reproducible please provide as detailed as possible :)

On Tue, Nov 7, 2017 at 7:56 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Ok thank’s

I think it’s time to install a 4.0 here. Let see…

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 7 novembre 2017 07:55
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I have tested 4.0.x version
LDAP related code is almost the same for 3.3.x and 4.0.x branches (there were no LDAP issues for a long time .... )

On Tue, Nov 7, 2017 at 7:45 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Maxim,

When you are saying « most recent version », is that 4.x ?
Or latest version of 3.3.x ? (which is ?)

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 4 novembre 2017 11:14
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello Martin,

just have tested using following steps:

1) set up LDAP integration
2) login as LDAP user test
3) logout
4) login as admin
5) add right 'Admin'
6) Save
7) login as LDAP user test
Result: user is able to login, has Admin rights, there is no duplicated users

So everything seems to work as expected
Maybe some additional steps need to be performed?

PS I have tested most recent version


On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
As usual Maxim, thank’s for your quick reply.  It’s really appreciate !

Have a good night !

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 14:02

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I see,
It should be easier :)
Will try to check LDAP tomorrow and will let you know

On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
It’s not a upgrade.  We installed  it from scratch.


-          Install OM  3.3.x  or 4.x

-          Connect to  AD 2016 (ldap)

-          Modify to use SSL (5543)

-          Use it ☺


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:59

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:55

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
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



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
I case the issue will be reproducible please provide as detailed as
possible :)

On Tue, Nov 7, 2017 at 7:56 PM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> Ok thank’s
>
>
>
> I think it’s time to install a 4.0 here. Let see…
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 7 novembre 2017 07:55
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> I have tested 4.0.x version
>
> LDAP related code is almost the same for 3.3.x and 4.0.x branches (there
> were no LDAP issues for a long time .... )
>
>
>
> On Tue, Nov 7, 2017 at 7:45 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Maxim,
>
>
>
> When you are saying « most recent version », is that 4.x ?
>
> Or latest version of 3.3.x ? (which is ?)
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 4 novembre 2017 11:14
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> Hello Martin,
>
>
>
> just have tested using following steps:
>
>
>
> 1) set up LDAP integration
>
> 2) login as LDAP user test
>
> 3) logout
>
> 4) login as admin
>
> 5) add right 'Admin'
>
> 6) Save
>
> 7) login as LDAP user test
>
> Result: user is able to login, has Admin rights, there is no duplicated
> users
>
>
>
> So everything seems to work as expected
>
> Maybe some additional steps need to be performed?
>
>
>
> PS I have tested most recent version
>
>
>
>
>
> On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> As usual Maxim, thank’s for your quick reply.  It’s really appreciate !
>
>
>
> Have a good night !
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 14:02
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> I see,
>
> It should be easier :)
>
> Will try to check LDAP tomorrow and will let you know
>
>
>
> On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> It’s not a upgrade.  We installed  it from scratch.
>
>
>
> -          Install OM  3.3.x  or 4.x
>
> -          Connect to  AD 2016 (ldap)
>
> -          Modify to use SSL (5543)
>
> -          Use it J
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:59
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> 1.2.x -- cool :)))
>
>
>
> I would recommend to move to 4.0.0, IMHO it is more user friendly
>
> Please let me know if you will have any upgrade issues
>
>
>
> On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> No problem, have a good night.
>
>
>
> By the way, we are in process of upgrade our 1.2.x openmeeting version to
> new one
>
>
>
> Should we install 3.3.x  or straight move to  4.x ?
>
>
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:55
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> The issue is definitely caused by login == NULL
>
>
>
> will try to double check with your steps (tomorrow most probably, too late
> here :( )
>
>
>
> On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> MariaDB [open330]> select id, login, type, firstname, lastname from
> open330.om_user;
>
> +----+--------+------+----------------+--------------------+
>
> | id | login  | type | firstname      | lastname           |
>
> +----+--------+------+----------------+--------------------+
>
> |  1 | admin  | user | Admini         | Strateur           |
>
> |  2 | tech   | user | Support        | Informatique       |
>
> |  3 | usager | user | Stephane       | Genest             |
>
> |  4 | NULL   | ldap | Jean-François  | Néron              |
>
> |  5 | NULL   | ldap | usager         | formation_cours003 |
>
> |  6 | NULL   | ldap | usager         | formation_cours002 |
>
> |  7 | NULL   | ldap | usager         | formation_cours003 |
>
> |  8 | NULL   | ldap | usager         | formation_cours004 |
>
> |  9 | NULL   | ldap | Stéphane       | Genest             |
>
> | 10 | NULL   | ldap | Stéphane       | Genest             |
>
> | 11 | NULL   | ldap | Stéphane       | Genest             |
>
> | 12 | NULL   | ldap | Stéphane       | Genest             |
>
> | 13 | NULL   | ldap | Stéphane       | Genest             |
>
> | 14 | NULL   | ldap | Stéphane       | Genest             |
>
> | 15 | NULL   | ldap | Stéphane       | Genest             |
>
> | 16 | NULL   | ldap | Stéphane       | Genest             |
>
> | 17 | NULL   | ldap | Stéphane       | Genest             |
>
> | 18 | NULL   | ldap | Martin         | Chamberland        |
>
> | 19 | NULL   | ldap | Stéphane       | Genest             |
>
> | 20 | NULL   | ldap | Stéphane       | Genest             |
>
> | 21 | NULL   | ldap | Stéphane       | Genest             |
>
> | 22 | NULL   | ldap | Martin         | Chamberland        |
>
> | 23 | NULL   | ldap | Stéphane       | Genest             |
>
> | 24 | NULL   | ldap | Martin         | Chamberland        |
>
> | 25 | NULL   | ldap | Stéphane       | Genest             |
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:35
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> cat you perform following select in your DB:
>
>
>
> select id, login, type, firstname, lastname from openmeetings.om_user
>
>
>
> filter by your particular user
>
>
>
> I guess so simple change shouldn't break everything
>
>
>
> On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> 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
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
Ok thank’s

I think it’s time to install a 4.0 here. Let see…

De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 7 novembre 2017 07:55
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I have tested 4.0.x version
LDAP related code is almost the same for 3.3.x and 4.0.x branches (there were no LDAP issues for a long time .... )

On Tue, Nov 7, 2017 at 7:45 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Maxim,

When you are saying « most recent version », is that 4.x ?
Or latest version of 3.3.x ? (which is ?)

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 4 novembre 2017 11:14
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello Martin,

just have tested using following steps:

1) set up LDAP integration
2) login as LDAP user test
3) logout
4) login as admin
5) add right 'Admin'
6) Save
7) login as LDAP user test
Result: user is able to login, has Admin rights, there is no duplicated users

So everything seems to work as expected
Maybe some additional steps need to be performed?

PS I have tested most recent version


On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
As usual Maxim, thank’s for your quick reply.  It’s really appreciate !

Have a good night !

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 14:02

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I see,
It should be easier :)
Will try to check LDAP tomorrow and will let you know

On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
It’s not a upgrade.  We installed  it from scratch.


-          Install OM  3.3.x  or 4.x

-          Connect to  AD 2016 (ldap)

-          Modify to use SSL (5543)

-          Use it ☺


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:59

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:55

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
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



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
I have tested 4.0.x version
LDAP related code is almost the same for 3.3.x and 4.0.x branches (there
were no LDAP issues for a long time .... )

On Tue, Nov 7, 2017 at 7:45 PM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> Maxim,
>
>
>
> When you are saying « most recent version », is that 4.x ?
>
> Or latest version of 3.3.x ? (which is ?)
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 4 novembre 2017 11:14
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> Hello Martin,
>
>
>
> just have tested using following steps:
>
>
>
> 1) set up LDAP integration
>
> 2) login as LDAP user test
>
> 3) logout
>
> 4) login as admin
>
> 5) add right 'Admin'
>
> 6) Save
>
> 7) login as LDAP user test
>
> Result: user is able to login, has Admin rights, there is no duplicated
> users
>
>
>
> So everything seems to work as expected
>
> Maybe some additional steps need to be performed?
>
>
>
> PS I have tested most recent version
>
>
>
>
>
> On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> As usual Maxim, thank’s for your quick reply.  It’s really appreciate !
>
>
>
> Have a good night !
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 14:02
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> I see,
>
> It should be easier :)
>
> Will try to check LDAP tomorrow and will let you know
>
>
>
> On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> It’s not a upgrade.  We installed  it from scratch.
>
>
>
> -          Install OM  3.3.x  or 4.x
>
> -          Connect to  AD 2016 (ldap)
>
> -          Modify to use SSL (5543)
>
> -          Use it J
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:59
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> 1.2.x -- cool :)))
>
>
>
> I would recommend to move to 4.0.0, IMHO it is more user friendly
>
> Please let me know if you will have any upgrade issues
>
>
>
> On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> No problem, have a good night.
>
>
>
> By the way, we are in process of upgrade our 1.2.x openmeeting version to
> new one
>
>
>
> Should we install 3.3.x  or straight move to  4.x ?
>
>
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:55
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> The issue is definitely caused by login == NULL
>
>
>
> will try to double check with your steps (tomorrow most probably, too late
> here :( )
>
>
>
> On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> MariaDB [open330]> select id, login, type, firstname, lastname from
> open330.om_user;
>
> +----+--------+------+----------------+--------------------+
>
> | id | login  | type | firstname      | lastname           |
>
> +----+--------+------+----------------+--------------------+
>
> |  1 | admin  | user | Admini         | Strateur           |
>
> |  2 | tech   | user | Support        | Informatique       |
>
> |  3 | usager | user | Stephane       | Genest             |
>
> |  4 | NULL   | ldap | Jean-François  | Néron              |
>
> |  5 | NULL   | ldap | usager         | formation_cours003 |
>
> |  6 | NULL   | ldap | usager         | formation_cours002 |
>
> |  7 | NULL   | ldap | usager         | formation_cours003 |
>
> |  8 | NULL   | ldap | usager         | formation_cours004 |
>
> |  9 | NULL   | ldap | Stéphane       | Genest             |
>
> | 10 | NULL   | ldap | Stéphane       | Genest             |
>
> | 11 | NULL   | ldap | Stéphane       | Genest             |
>
> | 12 | NULL   | ldap | Stéphane       | Genest             |
>
> | 13 | NULL   | ldap | Stéphane       | Genest             |
>
> | 14 | NULL   | ldap | Stéphane       | Genest             |
>
> | 15 | NULL   | ldap | Stéphane       | Genest             |
>
> | 16 | NULL   | ldap | Stéphane       | Genest             |
>
> | 17 | NULL   | ldap | Stéphane       | Genest             |
>
> | 18 | NULL   | ldap | Martin         | Chamberland        |
>
> | 19 | NULL   | ldap | Stéphane       | Genest             |
>
> | 20 | NULL   | ldap | Stéphane       | Genest             |
>
> | 21 | NULL   | ldap | Stéphane       | Genest             |
>
> | 22 | NULL   | ldap | Martin         | Chamberland        |
>
> | 23 | NULL   | ldap | Stéphane       | Genest             |
>
> | 24 | NULL   | ldap | Martin         | Chamberland        |
>
> | 25 | NULL   | ldap | Stéphane       | Genest             |
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:35
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> cat you perform following select in your DB:
>
>
>
> select id, login, type, firstname, lastname from openmeetings.om_user
>
>
>
> filter by your particular user
>
>
>
> I guess so simple change shouldn't break everything
>
>
>
> On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> 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
>



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
Maxim,

When you are saying « most recent version », is that 4.x ?
Or latest version of 3.3.x ? (which is ?)

De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 4 novembre 2017 11:14
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello Martin,

just have tested using following steps:

1) set up LDAP integration
2) login as LDAP user test
3) logout
4) login as admin
5) add right 'Admin'
6) Save
7) login as LDAP user test
Result: user is able to login, has Admin rights, there is no duplicated users

So everything seems to work as expected
Maybe some additional steps need to be performed?

PS I have tested most recent version


On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
As usual Maxim, thank’s for your quick reply.  It’s really appreciate !

Have a good night !

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 14:02

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I see,
It should be easier :)
Will try to check LDAP tomorrow and will let you know

On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
It’s not a upgrade.  We installed  it from scratch.


-          Install OM  3.3.x  or 4.x

-          Connect to  AD 2016 (ldap)

-          Modify to use SSL (5543)

-          Use it ☺


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:59

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:55

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
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: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
Hello Martin,

just have tested using following steps:

1) set up LDAP integration
2) login as LDAP user test
3) logout
4) login as admin
5) add right 'Admin'
6) Save
7) login as LDAP user test
Result: user is able to login, has Admin rights, there is no duplicated
users

So everything seems to work as expected
Maybe some additional steps need to be performed?

PS I have tested most recent version


On Sat, Nov 4, 2017 at 1:03 AM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> As usual Maxim, thank’s for your quick reply.  It’s really appreciate !
>
>
>
> Have a good night !
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 14:02
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> I see,
>
> It should be easier :)
>
> Will try to check LDAP tomorrow and will let you know
>
>
>
> On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> It’s not a upgrade.  We installed  it from scratch.
>
>
>
> -          Install OM  3.3.x  or 4.x
>
> -          Connect to  AD 2016 (ldap)
>
> -          Modify to use SSL (5543)
>
> -          Use it J
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:59
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> 1.2.x -- cool :)))
>
>
>
> I would recommend to move to 4.0.0, IMHO it is more user friendly
>
> Please let me know if you will have any upgrade issues
>
>
>
> On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> No problem, have a good night.
>
>
>
> By the way, we are in process of upgrade our 1.2.x openmeeting version to
> new one
>
>
>
> Should we install 3.3.x  or straight move to  4.x ?
>
>
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:55
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> The issue is definitely caused by login == NULL
>
>
>
> will try to double check with your steps (tomorrow most probably, too late
> here :( )
>
>
>
> On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> MariaDB [open330]> select id, login, type, firstname, lastname from
> open330.om_user;
>
> +----+--------+------+----------------+--------------------+
>
> | id | login  | type | firstname      | lastname           |
>
> +----+--------+------+----------------+--------------------+
>
> |  1 | admin  | user | Admini         | Strateur           |
>
> |  2 | tech   | user | Support        | Informatique       |
>
> |  3 | usager | user | Stephane       | Genest             |
>
> |  4 | NULL   | ldap | Jean-François  | Néron              |
>
> |  5 | NULL   | ldap | usager         | formation_cours003 |
>
> |  6 | NULL   | ldap | usager         | formation_cours002 |
>
> |  7 | NULL   | ldap | usager         | formation_cours003 |
>
> |  8 | NULL   | ldap | usager         | formation_cours004 |
>
> |  9 | NULL   | ldap | Stéphane       | Genest             |
>
> | 10 | NULL   | ldap | Stéphane       | Genest             |
>
> | 11 | NULL   | ldap | Stéphane       | Genest             |
>
> | 12 | NULL   | ldap | Stéphane       | Genest             |
>
> | 13 | NULL   | ldap | Stéphane       | Genest             |
>
> | 14 | NULL   | ldap | Stéphane       | Genest             |
>
> | 15 | NULL   | ldap | Stéphane       | Genest             |
>
> | 16 | NULL   | ldap | Stéphane       | Genest             |
>
> | 17 | NULL   | ldap | Stéphane       | Genest             |
>
> | 18 | NULL   | ldap | Martin         | Chamberland        |
>
> | 19 | NULL   | ldap | Stéphane       | Genest             |
>
> | 20 | NULL   | ldap | Stéphane       | Genest             |
>
> | 21 | NULL   | ldap | Stéphane       | Genest             |
>
> | 22 | NULL   | ldap | Martin         | Chamberland        |
>
> | 23 | NULL   | ldap | Stéphane       | Genest             |
>
> | 24 | NULL   | ldap | Martin         | Chamberland        |
>
> | 25 | NULL   | ldap | Stéphane       | Genest             |
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:35
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> cat you perform following select in your DB:
>
>
>
> select id, login, type, firstname, lastname from openmeetings.om_user
>
>
>
> filter by your particular user
>
>
>
> I guess so simple change shouldn't break everything
>
>
>
> On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> 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: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
As usual Maxim, thank’s for your quick reply.  It’s really appreciate !

Have a good night !

De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 3 novembre 2017 14:02
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

I see,
It should be easier :)
Will try to check LDAP tomorrow and will let you know

On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
It’s not a upgrade.  We installed  it from scratch.


-          Install OM  3.3.x  or 4.x

-          Connect to  AD 2016 (ldap)

-          Modify to use SSL (5543)

-          Use it ☺


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:59

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:55

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
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: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
I see,
It should be easier :)
Will try to check LDAP tomorrow and will let you know

On Sat, Nov 4, 2017 at 1:00 AM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> It’s not a upgrade.  We installed  it from scratch.
>
>
>
> -          Install OM  3.3.x  or 4.x
>
> -          Connect to  AD 2016 (ldap)
>
> -          Modify to use SSL (5543)
>
> -          Use it J
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:59
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> 1.2.x -- cool :)))
>
>
>
> I would recommend to move to 4.0.0, IMHO it is more user friendly
>
> Please let me know if you will have any upgrade issues
>
>
>
> On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> No problem, have a good night.
>
>
>
> By the way, we are in process of upgrade our 1.2.x openmeeting version to
> new one
>
>
>
> Should we install 3.3.x  or straight move to  4.x ?
>
>
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:55
>
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> The issue is definitely caused by login == NULL
>
>
>
> will try to double check with your steps (tomorrow most probably, too late
> here :( )
>
>
>
> On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> MariaDB [open330]> select id, login, type, firstname, lastname from
> open330.om_user;
>
> +----+--------+------+----------------+--------------------+
>
> | id | login  | type | firstname      | lastname           |
>
> +----+--------+------+----------------+--------------------+
>
> |  1 | admin  | user | Admini         | Strateur           |
>
> |  2 | tech   | user | Support        | Informatique       |
>
> |  3 | usager | user | Stephane       | Genest             |
>
> |  4 | NULL   | ldap | Jean-François  | Néron              |
>
> |  5 | NULL   | ldap | usager         | formation_cours003 |
>
> |  6 | NULL   | ldap | usager         | formation_cours002 |
>
> |  7 | NULL   | ldap | usager         | formation_cours003 |
>
> |  8 | NULL   | ldap | usager         | formation_cours004 |
>
> |  9 | NULL   | ldap | Stéphane       | Genest             |
>
> | 10 | NULL   | ldap | Stéphane       | Genest             |
>
> | 11 | NULL   | ldap | Stéphane       | Genest             |
>
> | 12 | NULL   | ldap | Stéphane       | Genest             |
>
> | 13 | NULL   | ldap | Stéphane       | Genest             |
>
> | 14 | NULL   | ldap | Stéphane       | Genest             |
>
> | 15 | NULL   | ldap | Stéphane       | Genest             |
>
> | 16 | NULL   | ldap | Stéphane       | Genest             |
>
> | 17 | NULL   | ldap | Stéphane       | Genest             |
>
> | 18 | NULL   | ldap | Martin         | Chamberland        |
>
> | 19 | NULL   | ldap | Stéphane       | Genest             |
>
> | 20 | NULL   | ldap | Stéphane       | Genest             |
>
> | 21 | NULL   | ldap | Stéphane       | Genest             |
>
> | 22 | NULL   | ldap | Martin         | Chamberland        |
>
> | 23 | NULL   | ldap | Stéphane       | Genest             |
>
> | 24 | NULL   | ldap | Martin         | Chamberland        |
>
> | 25 | NULL   | ldap | Stéphane       | Genest             |
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:35
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> cat you perform following select in your DB:
>
>
>
> select id, login, type, firstname, lastname from openmeetings.om_user
>
>
>
> filter by your particular user
>
>
>
> I guess so simple change shouldn't break everything
>
>
>
> On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> 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: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
It’s not a upgrade.  We installed  it from scratch.


-          Install OM  3.3.x  or 4.x

-          Connect to  AD 2016 (ldap)

-          Modify to use SSL (5543)

-          Use it ☺


De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 3 novembre 2017 13:59
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:55

À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
1.2.x -- cool :)))

I would recommend to move to 4.0.0, IMHO it is more user friendly
Please let me know if you will have any upgrade issues

On Sat, Nov 4, 2017 at 12:56 AM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> No problem, have a good night.
>
>
>
> By the way, we are in process of upgrade our 1.2.x openmeeting version to
> new one
>
>
>
> Should we install 3.3.x  or straight move to  4.x ?
>
>
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:55
>
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> The issue is definitely caused by login == NULL
>
>
>
> will try to double check with your steps (tomorrow most probably, too late
> here :( )
>
>
>
> On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> MariaDB [open330]> select id, login, type, firstname, lastname from
> open330.om_user;
>
> +----+--------+------+----------------+--------------------+
>
> | id | login  | type | firstname      | lastname           |
>
> +----+--------+------+----------------+--------------------+
>
> |  1 | admin  | user | Admini         | Strateur           |
>
> |  2 | tech   | user | Support        | Informatique       |
>
> |  3 | usager | user | Stephane       | Genest             |
>
> |  4 | NULL   | ldap | Jean-François  | Néron              |
>
> |  5 | NULL   | ldap | usager         | formation_cours003 |
>
> |  6 | NULL   | ldap | usager         | formation_cours002 |
>
> |  7 | NULL   | ldap | usager         | formation_cours003 |
>
> |  8 | NULL   | ldap | usager         | formation_cours004 |
>
> |  9 | NULL   | ldap | Stéphane       | Genest             |
>
> | 10 | NULL   | ldap | Stéphane       | Genest             |
>
> | 11 | NULL   | ldap | Stéphane       | Genest             |
>
> | 12 | NULL   | ldap | Stéphane       | Genest             |
>
> | 13 | NULL   | ldap | Stéphane       | Genest             |
>
> | 14 | NULL   | ldap | Stéphane       | Genest             |
>
> | 15 | NULL   | ldap | Stéphane       | Genest             |
>
> | 16 | NULL   | ldap | Stéphane       | Genest             |
>
> | 17 | NULL   | ldap | Stéphane       | Genest             |
>
> | 18 | NULL   | ldap | Martin         | Chamberland        |
>
> | 19 | NULL   | ldap | Stéphane       | Genest             |
>
> | 20 | NULL   | ldap | Stéphane       | Genest             |
>
> | 21 | NULL   | ldap | Stéphane       | Genest             |
>
> | 22 | NULL   | ldap | Martin         | Chamberland        |
>
> | 23 | NULL   | ldap | Stéphane       | Genest             |
>
> | 24 | NULL   | ldap | Martin         | Chamberland        |
>
> | 25 | NULL   | ldap | Stéphane       | Genest             |
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:35
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> cat you perform following select in your DB:
>
>
>
> select id, login, type, firstname, lastname from openmeetings.om_user
>
>
>
> filter by your particular user
>
>
>
> I guess so simple change shouldn't break everything
>
>
>
> On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
No problem, have a good night.

By the way, we are in process of upgrade our 1.2.x openmeeting version to new one

Should we install 3.3.x  or straight move to  4.x ?



De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 3 novembre 2017 13:55
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
The issue is definitely caused by login == NULL

will try to double check with your steps (tomorrow most probably, too late
here :( )

On Sat, Nov 4, 2017 at 12:52 AM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> MariaDB [open330]> select id, login, type, firstname, lastname from
> open330.om_user;
>
> +----+--------+------+----------------+--------------------+
>
> | id | login  | type | firstname      | lastname           |
>
> +----+--------+------+----------------+--------------------+
>
> |  1 | admin  | user | Admini         | Strateur           |
>
> |  2 | tech   | user | Support        | Informatique       |
>
> |  3 | usager | user | Stephane       | Genest             |
>
> |  4 | NULL   | ldap | Jean-François  | Néron              |
>
> |  5 | NULL   | ldap | usager         | formation_cours003 |
>
> |  6 | NULL   | ldap | usager         | formation_cours002 |
>
> |  7 | NULL   | ldap | usager         | formation_cours003 |
>
> |  8 | NULL   | ldap | usager         | formation_cours004 |
>
> |  9 | NULL   | ldap | Stéphane       | Genest             |
>
> | 10 | NULL   | ldap | Stéphane       | Genest             |
>
> | 11 | NULL   | ldap | Stéphane       | Genest             |
>
> | 12 | NULL   | ldap | Stéphane       | Genest             |
>
> | 13 | NULL   | ldap | Stéphane       | Genest             |
>
> | 14 | NULL   | ldap | Stéphane       | Genest             |
>
> | 15 | NULL   | ldap | Stéphane       | Genest             |
>
> | 16 | NULL   | ldap | Stéphane       | Genest             |
>
> | 17 | NULL   | ldap | Stéphane       | Genest             |
>
> | 18 | NULL   | ldap | Martin         | Chamberland        |
>
> | 19 | NULL   | ldap | Stéphane       | Genest             |
>
> | 20 | NULL   | ldap | Stéphane       | Genest             |
>
> | 21 | NULL   | ldap | Stéphane       | Genest             |
>
> | 22 | NULL   | ldap | Martin         | Chamberland        |
>
> | 23 | NULL   | ldap | Stéphane       | Genest             |
>
> | 24 | NULL   | ldap | Martin         | Chamberland        |
>
> | 25 | NULL   | ldap | Stéphane       | Genest             |
>
>
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 13:35
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> cat you perform following select in your DB:
>
>
>
> select id, login, type, firstname, lastname from openmeetings.om_user
>
>
>
> filter by your particular user
>
>
>
> I guess so simple change shouldn't break everything
>
>
>
> On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
MariaDB [open330]> select id, login, type, firstname, lastname from open330.om_user;
+----+--------+------+----------------+--------------------+
| id | login  | type | firstname      | lastname           |
+----+--------+------+----------------+--------------------+
|  1 | admin  | user | Admini         | Strateur           |
|  2 | tech   | user | Support        | Informatique       |
|  3 | usager | user | Stephane       | Genest             |
|  4 | NULL   | ldap | Jean-François  | Néron              |
|  5 | NULL   | ldap | usager         | formation_cours003 |
|  6 | NULL   | ldap | usager         | formation_cours002 |
|  7 | NULL   | ldap | usager         | formation_cours003 |
|  8 | NULL   | ldap | usager         | formation_cours004 |
|  9 | NULL   | ldap | Stéphane       | Genest             |
| 10 | NULL   | ldap | Stéphane       | Genest             |
| 11 | NULL   | ldap | Stéphane       | Genest             |
| 12 | NULL   | ldap | Stéphane       | Genest             |
| 13 | NULL   | ldap | Stéphane       | Genest             |
| 14 | NULL   | ldap | Stéphane       | Genest             |
| 15 | NULL   | ldap | Stéphane       | Genest             |
| 16 | NULL   | ldap | Stéphane       | Genest             |
| 17 | NULL   | ldap | Stéphane       | Genest             |
| 18 | NULL   | ldap | Martin         | Chamberland        |
| 19 | NULL   | ldap | Stéphane       | Genest             |
| 20 | NULL   | ldap | Stéphane       | Genest             |
| 21 | NULL   | ldap | Stéphane       | Genest             |
| 22 | NULL   | ldap | Martin         | Chamberland        |
| 23 | NULL   | ldap | Stéphane       | Genest             |
| 24 | NULL   | ldap | Martin         | Chamberland        |
| 25 | NULL   | ldap | Stéphane       | Genest             |


De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 3 novembre 2017 13:35
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
cat you perform following select in your DB:

select id, login, type, firstname, lastname from openmeetings.om_user

filter by your particular user

I guess so simple change shouldn't break everything

On Sat, Nov 4, 2017 at 12:03 AM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> The problem we are facing is simple.
>
> Suppose a new user connect to the OP platform.  I change this user to be
> ADMIN. (for administration purpose).
>
>
>
> The next time he will connect, a new user will be create with the same
> LOGIN,  but then he won’t be ADMIN, because it’s a brand new one L
>
>
>
> *De :* Maxim Solodovnik [mailto:solomax666@gmail.com]
> *Envoyé :* 3 novembre 2017 12:28
> *À :* Openmeetings user-list
> *Objet :* Re: LDAP question (same user multiple time)
>
>
>
> really weird ...
>
> All your duplicated users has no login ....
>
>
>
> I'm curios how is this possible ....
>
>
>
> On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
>
> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
>
>
>
>
>
> --
>
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
The problem we are facing is simple.
Suppose a new user connect to the OP platform.  I change this user to be ADMIN. (for administration purpose).

The next time he will connect, a new user will be create with the same LOGIN,  but then he won’t be ADMIN, because it’s a brand new one ☹

De : Maxim Solodovnik [mailto:solomax666@gmail.com]
Envoyé : 3 novembre 2017 12:28
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com<ma...@gmail.com>]
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca>> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
WBR
Maxim aka solomax



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
really weird ...
All your duplicated users has no login ....

I'm curios how is this possible ....

On Fri, Nov 3, 2017 at 8:16 PM, Chamberland, Martin <
Martin.Chamberland@fadq.qc.ca> wrote:

> Here a screenshot of the same user.
>
> Everytime it connect, a new one is create and there is now LOGIN name.
>
> I'm still trying to find how to post MariaDB information.
>
> -----Message d'origine-----
> De : Maxim Solodovnik [mailto:solomax666@gmail.com]
> Envoyé : 3 novembre 2017 01:22
> À : Openmeetings user-list
> Objet : Re: LDAP question (same user multiple time)
>
> Hello martin,
>
> According to the code Users should not be duplicated login will be unique
> for given LDAP server Maybe you can share you LDAP config (masking
> sensitive information) and show content of om_user DB table with duplicate
> entries?
>
> On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <
> Martin.Chamberland@fadq.qc.ca> wrote:
> > Hi there,
> >
> >
> >
> > We just finished install OpenMeetings 3.3.0 and it’s connect to our AD
> > 2016 (ldap).
> >
> > The problem we see is that everytime a new user connect, it create
> > again and again.
> >
> >
> >
> > I remember there is a parameter somewhere to correct this issue but i
> > can’t find it in 3.3.0
> >
> >
> >
> > Is that in the ldap.cfg file or in the web-interface ?
> >
> >
> >
> > Thank’s
> >
> >
> >
> > Martin C.
> >
> >
> >
> >
>
>
>
> --
> WBR
> Maxim aka solomax
>



-- 
WBR
Maxim aka solomax

RE: LDAP question (same user multiple time)

Posted by "Chamberland, Martin" <Ma...@fadq.qc.ca>.
Here a screenshot of the same user.

Everytime it connect, a new one is create and there is now LOGIN name.

I'm still trying to find how to post MariaDB information.

-----Message d'origine-----
De : Maxim Solodovnik [mailto:solomax666@gmail.com] 
Envoyé : 3 novembre 2017 01:22
À : Openmeetings user-list
Objet : Re: LDAP question (same user multiple time)

Hello martin,

According to the code Users should not be duplicated login will be unique for given LDAP server Maybe you can share you LDAP config (masking sensitive information) and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin <Ma...@fadq.qc.ca> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD 
> 2016 (ldap).
>
> The problem we see is that everytime a new user connect, it create 
> again and again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i 
> can’t find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



--
WBR
Maxim aka solomax

Re: LDAP question (same user multiple time)

Posted by Maxim Solodovnik <so...@gmail.com>.
Hello martin,

According to the code Users should not be duplicated login will be
unique for given LDAP server
Maybe you can share you LDAP config (masking sensitive information)
and show content of om_user DB table with duplicate entries?

On Thu, Nov 2, 2017 at 10:18 PM, Chamberland, Martin
<Ma...@fadq.qc.ca> wrote:
> Hi there,
>
>
>
> We just finished install OpenMeetings 3.3.0 and it’s connect to our AD 2016
> (ldap).
>
> The problem we see is that everytime a new user connect, it create again and
> again.
>
>
>
> I remember there is a parameter somewhere to correct this issue but i can’t
> find it in 3.3.0
>
>
>
> Is that in the ldap.cfg file or in the web-interface ?
>
>
>
> Thank’s
>
>
>
> Martin C.
>
>
>
>



-- 
WBR
Maxim aka solomax