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.durde...@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.durde...@medunigraz.at', 'deleted': False, 'create_time':
datetime.datetime(2016, 6, 6, 12, 43, 29, 93290), 'type': 'private', 'name':
u'marija.durde...@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.djurdje...@medunigraz.at
Email: marija.djurdje...@klinikum-graz.at
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/
