OpenEMM 6.1 login problem
Posted: Wed Sep 22, 2010 10:21 pm
I'm getting "Wrong username/password or account temporarily locked" error when trying to login to OpenEMM. It happens for different user names (including admin) but there's no definite pattern as to when it happens. I may successfully login from one PC multiple times w/o problem, but may not be able to login from another PC not even once.
I wonder if this has anything to do with this new auto-lock feature. Is there any way to disable it? I changed max_login_fails to 10 and login_block_time to 5 in the company_tbl table, but it didn't make any difference. Any clues anyone? Appreciate any help.
This is what appears in the openemm_stdout.log:
I wonder if this has anything to do with this new auto-lock feature. Is there any way to disable it? I changed max_login_fails to 10 and login_block_time to 5 in the company_tbl table, but it didn't make any difference. Any clues anyone? Appreciate any help.
This is what appears in the openemm_stdout.log:
Code: Select all
2010-09-22 16:43:55,147: INFO [resin-tcp-connection-*:8080-3] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
Hibernate: select admin0_.admin_id as admin1_2_, admin0_.username as username2_, admin0_.pwd_hash as pwd3_2_, admin0_.company_id as company4_2_, admin0_.fullname as fullname2_, admin0_.admin_lang as admin6_2_, admin0_.admin_country as admin7_2_, admin0_.admin_lang_variant as admin8_2_, admin0_.admin_timezone as admin9_2_, admin0_.default_import_profile_id as default10_2_, admin0_.creation_date as creation11_2_, admin0_.admin_group_id as admin12_2_, admin0_.layout_id as layout13_2_, admin0_.preferred_list_size as preferred14_2_ from admin_tbl admin0_ where admin0_.username=? and pwd_hash=?
2010-09-22 16:43:55,149: INFO [resin-tcp-connection-*:8080-3] org.hibernate.dialect.Dialect - Using dialect: org.hibernate.dialect.MySQLDialect
2010-09-22 16:43:55,149: ERROR [resin-tcp-connection-*:8080-3] org.agnitas - no company
2010-09-22 16:43:55,149: ERROR [resin-tcp-connection-*:8080-3] org.agnitas - no company
2010-09-22 16:43:55,149: ERROR [resin-tcp-connection-*:8080-3] org.agnitas - no companyID
2010-09-22 16:43:55,149: ERROR [resin-tcp-connection-*:8080-3] org.agnitas - no companyID
2010-09-22 16:43:55,152: WARN [resin-tcp-connection-*:8080-3] org.agnitas - logon: login FAILED User: XXX Password-Length: 6
2010-09-22 16:43:55,152: WARN [resin-tcp-connection-*:8080-3] org.agnitas - logon: login FAILED User: XXX Password-Length: 6
Hibernate: select emmlayout0_.layout_id as layout1_6_, emmlayout0_.company_id as company2_6_, emmlayout0_.header_url as header3_6_, emmlayout0_.footer_url as footer4_6_, emmlayout0_.base_url as base5_6_, emmlayout0_.normal_color as normal6_6_, emmlayout0_.highlight_color as highlight7_6_ from emm_layout_tbl emmlayout0_ where emmlayout0_.company_id=0 and emmlayout0_.layout_id=?
2010-09-22 16:45:53,947: INFO [resin-tcp-connection-*:8080-5] org.agnitas - validate: action 0