Auto-registration and database session issue
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/
participants (1)
-
Durdevic, Marija