OpenEMM 6.1 login problem

[ybilas]

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:

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

[argyrism]

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:

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

I have exactly the same problem. I just installed OpenEMM 6.1 under a Centos VPS

[argyrism]

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:

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

I have exactly the same problem. I just installed OpenEMM 6.1 under a Centos VPS

i have spend so much time trying to login to openemm , i just did a new installation and i cannot login , i checked the files cms.properties and emm.properties and the database con its ok, i use the following user/pass , admin/openemm with no success , i have also tried to change the has inside the admin table with no success , the error i get is 2010-10-15 06:42:04,620: ERROR [resin-tcp-connection-*:8080-5] org.agnitas - no company
2010-10-15 06:42:04,620: ERROR [resin-tcp-connection-*:8080-5] org.agnitas - no company
2010-10-15 06:42:04,620: ERROR [resin-tcp-connection-*:8080-5] org.agnitas - no companyID
2010-10-15 06:42:04,620: ERROR [resin-tcp-connection-*:8080-5] org.agnitas - no companyID
2010-10-15 06:42:04,657: WARN [resin-tcp-connection-*:8080-5] org.agnitas - logon: login FAILED User: admin Password-Length: 7
2010-10-15 06:42:04,657: WARN [resin-tcp-connection-*:8080-5] org.agnitas - logon: login FAILED User: admin Password-Length: 7