2.13.2-stable+timestamp.2015.12.18.11.00.46 (Running on Unknown, Python 2.7.5)
On Thursday, February 4, 2016 at 7:20:06 AM UTC-8, Richard wrote: > > 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.
