Yes it does. Submitted: https://github.com/web2py/web2py/issues/1178
On Wednesday, January 27, 2016 at 3:08:16 PM UTC-8, Massimo Di Pierro wrote:
>
> Are you saying that fixes it? Please submit your patch to git and we will
> improve it if necessary. Thanks.
>
>
> On Tuesday, 26 January 2016 16:45:33 UTC-6, Michael M wrote:
>>
>> Ok, I inadvertently lied.
>>
>> Not everything was the same. Part of my install script is to download
>> the source from the internet of web2py.
>>
>> I switched my DB back to SQLite and and tried a login. Same deal with
>> LDAP/AD login on SQLite was still getting the same issue of two line items
>> in 'db.auth_user'
>>
>> What I did to fix it was.
>>
>> ldap_auth.py ~line 425 added " 'username': username " to the
>> "update_or_insert_values" dictionary
>>
>> update_or_insert_values = {'first_name': store_user_firstname,
>> 'last_name':
>> store_user_lastname,
>> 'email': store_user_mail,
>> 'username': username}
>>
>>
>> ldap_auth.py ~line 429 added " ,'username' " to the fields array
>>
>> fields = ['first_name', 'last_name', 'email','username']
>>
>>
>> I dont know what else to link to. Should I submit a bugfix on Git?
>>
>>
>> On Friday, January 22, 2016 at 5:36:31 PM UTC-8, Michael M wrote:
>>>
>>> I just asked my guys on my DBA team to do a trace. So they ran the
>>> trace while I logged in.
>>>
>>> They sent me this:
>>>
>>> As discussed, We traced application login activity. Following are the
>>> INSERT statements against WEB2PY_OracleProject.AUTH_USER table
>>>
>>>
>>> INSERT INTO auth_user(username,first_name,last_name,registration_id,
>>> reset_password_key,registration_key,email)
>>> VALUES
>>> ('','Michael','Messmer [mmessmer]','','','','[email protected]
>>> <javascript:>')
>>>
>>>
>>> INSERT INTO auth_user(username,first_name,last_name,registration_id,
>>> reset_password_key,registration_key,email)
>>> VALUES
>>> ('mmessmer','mmessmer','','','','','')
>>>
>>>
>>> Module - [email protected] <javascript:> (TNS V1-V3)
>>>
>>> User - WEB2PY_OracleProject
>>>
>>>
>>>
>>> On Thursday, January 21, 2016 at 5:24:36 PM UTC-8, Michael Messmer wrote:
>>>>
>>>> When I use the following on SQLite
>>>>
>>>> manage_groups= True,
>>>> manage_user = True,
>>>>
>>>> 1 entry in would come into db.auth_user
>>>>
>>>> When I transferred to Oracle 11g
>>>> a new user logs in and I get two entries.
>>>>
>>>> 42 Mi Me [mme... mme@... None None None
>>>> None None
>>>> 43 mme None None mme None None None
>>>> mme
>>>>
>>>> Log out and log in again.
>>>> Then I get:
>>>>
>>>> 43 Mi Me [mme... mme@... mme None None
>>>> None mme
>>>>
>>>> So row 43 is now getting updated.
>>>>
>>>> Any thoughts. Again the the only thing that chaged was default SQLite
>>>> to Oracle 11g as the main DB
>>>>
>>>>
>>>> See Context below:
>>>> -------
>>>>
>>>> from gluon.tools import Auth, Crud, Service, PluginManager, prettydate
>>>> auth = Auth(db)
>>>> crud, service, plugins = Crud(db), Service(), PluginManager()
>>>>
>>>>
>>>> ## create all tables needed by auth if not custom tables
>>>> auth.define_tables(username=True, signature=False)
>>>>
>>>> # all we need is login
>>>>
>>>> auth.settings.actions_disabled=['register','change_password','request_reset_password','retrieve_username','profile']
>>>> #auth.settings.login_onvalidation = []
>>>> # you don't have to remember me
>>>> auth.settings.remember_me_form = False
>>>>
>>>> #
>>>> http://www.computerperformance.co.uk/Logon/LDAP_attributes_active_directory.htm
>>>> # ldap authentication and not save password on web2py
>>>> from gluon.contrib.login_methods.ldap_auth import ldap_auth
>>>> auth.settings.login_methods = [ldap_auth(mode='ad',
>>>> manage_groups= True,
>>>> db = db,
>>>> manage_user = True,
>>>> user_firstname_attrib = 'cn:1',
>>>> user_lastname_attrib = 'sn',
>>>> group_member_attrib = 'member',
>>>> group_filterstr = 'objectClass=Group',
>>>> server='somethign.com',
>>>> base_dn='DC=corp,DC=something,DC=com')]
>>>>
>>>>
>>>>
>>>>
--
Resources:
- http://web2py.com
- http://web2py.com/book (Documentation)
- http://github.com/web2py/web2py (Source code)
- https://code.google.com/p/web2py/issues/list (Report Issues)
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
