Auto-registration and database session issue

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Auto-registration and database session issue

Durdevic, Marija

Dear all,

 

I am using LDAP authentication and auto registration options.  LDAP authentication passed successfully, but I got error message during auto-registration process:

 

 

  File "/home/galaxy/galaxy/.venv/local/lib/python2.7/site-packages/sqlalchemy/engine/default.py", line 450, in do_execute

    cursor.execute(statement, parameters)

sqlalchemy.exc.IntegrityError: (psycopg2.IntegrityError) duplicate key value violates unique constraint "ix_role_name"

DETAIL:  Key (name)=([hidden email]) already exists.

[SQL: 'INSERT INTO role (create_time, update_time, name, description, type, deleted) VALUES (%(create_time)s, %(update_time)s, %(name)s, %(description)s, %(type)s, %(deleted)s) RETURNING role.id'] [parameters: {'update_time': datetime.datetime(2016, 6, 6, 12, 43, 29, 93304), 'description': u'Private Role for [hidden email]', 'deleted': False, 'create_time': datetime.datetime(2016, 6, 6, 12, 43, 29, 93290), 'type': 'private', 'name': u'[hidden email]'}]

[pid: 22823|app: 0|req: 2/2] 10.17.16.180 () {54 vars in 1129 bytes} [Mon Jun  6 14:43:29 2016] POST /user/login?use_panels=False => generated 0 bytes in 74 msecs (HTTP/1.1 500) 1 headers in 63 bytes (0 switches on core 1)

 

 

After that, user appear in database and I am able to login. Anyhow, I would like to solve this issue and to register without errors.

 

I tried to debug Galaxy code…  It looks like that problem is somewhere with sessions…

 

Script:

 

Lib/galaxy/security/__init__.py

 

Function:

 

create_private_user_role( self, user )

 

In this line:

self.sa_session.flush()

 

Anny suggestion what can be wrong?

 

Thanks in advance,

Marija

 

 

Mag. Marija Đurđević

Core Facility Computational Bioanalytics

 

Medical University of Graz

Center for Medical Research

Stiftingtalstraße 24, A-8010 Graz

Austria

 

Phone: +43 316/385-73024

Fax:+43 316/385-73009

 

Email: [hidden email]

Email: [hidden email]

 

Web: https://zmf.medunigraz.at/

 


___________________________________________________________
Please keep all replies on the list by using "reply all"
in your mail client.  To manage your subscriptions to this
and other Galaxy lists, please use the interface at:
  https://lists.galaxyproject.org/

To search Galaxy mailing lists use the unified search at:
  http://galaxyproject.org/search/mailinglists/