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)=(marija.durdevic@medunigraz.at) 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 marija.durdevic@medunigraz.at', 'deleted': False, 'create_time': datetime.datetime(2016, 6, 6, 12, 43, 29, 93290), 'type': 'private', 'name': u'marija.durdevic@medunigraz.at'}]

[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: marija.djurdjevic@medunigraz.at

Email: marija.djurdjevic@klinikum-graz.at

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