Hello Michael, Which version of web2py are you using and which version of python interpreter??
Thanks Richard Le mardi 2 février 2016 10:46:02 UTC-5, Michael Messmer a écrit : > > 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]') >>>> >>>> >>>> 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.
