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.
