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.
