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]')
>>
>>
>> INSERT INTO auth_user(username,first_name,last_name,registration_id,
>> reset_password_key,registration_key,email)
>> VALUES
>> ('mmessmer','mmessmer','','','','','')
>>
>>
>> Module - [email protected] (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.
