Page 1 of 1

No login possible

Posted: Mon May 21, 2012 8:55 pm
by ManfredCC
Trying to log in results in

"Ein allgemeiner Fehler ist aufgetreten. Bitte prüfen Sie Ihre Eingaben."

Password and username are for sure the right ones!

Please help!

Re: No login possible

Posted: Mon May 21, 2012 9:41 pm
by maschoff
Did you check log file catalina.out?

Re: No login possible

Posted: Tue May 22, 2012 8:04 am
by ManfredCC
catalina.out says...


May 22, 2012 8:54:20 AM org.apache.catalina.core.AprLifecycleListener init
INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: /opt/openemm/jdk1.6.0_26/jre/lib/i386/client:/opt/openemm/jdk1.6.0_26/jre/lib/i386:/opt/openemm/jdk1.6.0_26/jre/../lib/i386:/usr/java/packages/lib/i386:/lib:/usr/lib
May 22, 2012 8:54:21 AM org.apache.coyote.http11.Http11Protocol init
INFO: Initializing Coyote HTTP/1.1 on http-8080
May 22, 2012 8:54:21 AM org.apache.catalina.startup.Catalina load
INFO: Initialization processed in 1013 ms
May 22, 2012 8:54:21 AM org.apache.catalina.core.StandardService start
INFO: Starting service Catalina
May 22, 2012 8:54:21 AM org.apache.catalina.core.StandardEngine start
INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
May 22, 2012 8:54:23 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
2012-05-22 08:54:25,279: WARN [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm-2011/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
May 22, 2012 8:54:26 AM org.apache.catalina.startup.HostConfig deployDirectory
INFO: Deploying web application directory openemm
May 22, 2012 8:54:26 AM org.apache.catalina.core.ApplicationContext log
INFO: Initializing Spring root WebApplicationContext
2012-05-22 08:54:28,452: WARN [main] net.sf.ehcache.config.Configurator - No configuration found. Configuring ehcache from ehcache-failsafe.xml found in the classpath: jar:file:/home/openemm-2011/webapps/openemm/WEB-INF/lib/ehcache-1.1.jar!/ehcache-failsafe.xml
May 22, 2012 8:54:29 AM org.apache.coyote.http11.Http11Protocol start
INFO: Starting Coyote HTTP/1.1 on http-8080
May 22, 2012 8:54:29 AM org.apache.jk.common.ChannelSocket init
INFO: JK: ajp13 listening on /0.0.0.0:8009
May 22, 2012 8:54:29 AM org.apache.jk.server.JkMain start
INFO: Jk running ID=0 time=0/13 config=null
May 22, 2012 8:54:29 AM org.apache.catalina.startup.Catalina start
INFO: Server startup in 8334 ms
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=?
Hibernate: select company0_.company_id as company1_1_0_, company0_.creator_company_id as creator2_1_0_, company0_.shortname as shortname1_0_, company0_.description as descript4_1_0_, company0_.xor_key as xor5_1_0_, company0_.rdir_domain as rdir6_1_0_, company0_.mailloop_domain as mailloop7_1_0_, company0_.status as status1_0_, company0_.mailtracking as mailtrac9_1_0_, company0_.max_login_fails as max10_1_0_, company0_.login_block_time as login11_1_0_, company0_.uid_version as uid12_1_0_ from company_tbl company0_ where company0_.company_id=?
Hibernate: select admingroup0_.admin_group_id as admin1_4_0_, admingroup0_.company_id as company2_4_0_, admingroup0_.shortname as shortname4_0_, admingroup0_.description as descript4_4_0_ from admin_group_tbl admingroup0_ where admingroup0_.admin_group_id=?
Hibernate: select adminpermi0_.admin_id as admin1_0_, adminpermi0_.security_token as security2_0_ from admin_permission_tbl adminpermi0_ where adminpermi0_.admin_id=?
Hibernate: select grouppermi0_.admin_group_id as admin1_0_, grouppermi0_.security_token as security2_0_ from admin_group_permission_tbl grouppermi0_ where grouppermi0_.admin_group_id=?
2012-05-22 08:57:16,547: ERROR [http-8080-1] org.agnitas - execute: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT count(ip_address), ifnull(timestampdiff(second, max(ifnull(creation_date, 0)), now()),0) FROM login_track_tbl WHERE ip_address = ? AND login_status = 20 AND creation_date > ( SELECT ifnull(max(creation_date), 0) FROM login_track_tbl WHERE ip_address = ? AND login_status = 10)]; SQL state [HY000]; error code [145]; Table './openemm/login_track_tbl' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './openemm/login_track_tbl' is marked as crashed and should be repaired
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
org.agnitas.dao.impl.LoginTrackDaoImpl.getFailedLoginData(LoginTrackDaoImpl.java:101)
org.agnitas.web.LogonAction.isIPLogonBlocked(LogonAction.java:336)
org.agnitas.web.LogonAction.logon(LogonAction.java:287)
org.agnitas.web.LogonAction.execute(LogonAction.java:107)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

2012-05-22 08:57:16,609: WARN [http-8080-1] org.apache.struts.util.PropertyMessageResources - Resource messages_de_DE.properties Not Found.
2012-05-22 08:57:16,613: WARN [http-8080-1] org.apache.struts.util.PropertyMessageResources - Resource messages_en_US.properties Not Found.
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=?
Hibernate: select company0_.company_id as company1_1_0_, company0_.creator_company_id as creator2_1_0_, company0_.shortname as shortname1_0_, company0_.description as descript4_1_0_, company0_.xor_key as xor5_1_0_, company0_.rdir_domain as rdir6_1_0_, company0_.mailloop_domain as mailloop7_1_0_, company0_.status as status1_0_, company0_.mailtracking as mailtrac9_1_0_, company0_.max_login_fails as max10_1_0_, company0_.login_block_time as login11_1_0_, company0_.uid_version as uid12_1_0_ from company_tbl company0_ where company0_.company_id=?
Hibernate: select admingroup0_.admin_group_id as admin1_4_0_, admingroup0_.company_id as company2_4_0_, admingroup0_.shortname as shortname4_0_, admingroup0_.description as descript4_4_0_ from admin_group_tbl admingroup0_ where admingroup0_.admin_group_id=?
Hibernate: select adminpermi0_.admin_id as admin1_0_, adminpermi0_.security_token as security2_0_ from admin_permission_tbl adminpermi0_ where adminpermi0_.admin_id=?
Hibernate: select grouppermi0_.admin_group_id as admin1_0_, grouppermi0_.security_token as security2_0_ from admin_group_permission_tbl grouppermi0_ where grouppermi0_.admin_group_id=?
2012-05-22 08:57:38,328: ERROR [http-8080-1] org.agnitas - execute: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT count(ip_address), ifnull(timestampdiff(second, max(ifnull(creation_date, 0)), now()),0) FROM login_track_tbl WHERE ip_address = ? AND login_status = 20 AND creation_date > ( SELECT ifnull(max(creation_date), 0) FROM login_track_tbl WHERE ip_address = ? AND login_status = 10)]; SQL state [HY000]; error code [145]; Table './openemm/login_track_tbl' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './openemm/login_track_tbl' is marked as crashed and should be repaired
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
org.agnitas.dao.impl.LoginTrackDaoImpl.getFailedLoginData(LoginTrackDaoImpl.java:101)
org.agnitas.web.LogonAction.isIPLogonBlocked(LogonAction.java:336)
org.agnitas.web.LogonAction.logon(LogonAction.java:287)
org.agnitas.web.LogonAction.execute(LogonAction.java:107)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

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=?
Hibernate: select company0_.company_id as company1_1_0_, company0_.creator_company_id as creator2_1_0_, company0_.shortname as shortname1_0_, company0_.description as descript4_1_0_, company0_.xor_key as xor5_1_0_, company0_.rdir_domain as rdir6_1_0_, company0_.mailloop_domain as mailloop7_1_0_, company0_.status as status1_0_, company0_.mailtracking as mailtrac9_1_0_, company0_.max_login_fails as max10_1_0_, company0_.login_block_time as login11_1_0_, company0_.uid_version as uid12_1_0_ from company_tbl company0_ where company0_.company_id=?
Hibernate: select admingroup0_.admin_group_id as admin1_4_0_, admingroup0_.company_id as company2_4_0_, admingroup0_.shortname as shortname4_0_, admingroup0_.description as descript4_4_0_ from admin_group_tbl admingroup0_ where admingroup0_.admin_group_id=?
Hibernate: select adminpermi0_.admin_id as admin1_0_, adminpermi0_.security_token as security2_0_ from admin_permission_tbl adminpermi0_ where adminpermi0_.admin_id=?
Hibernate: select grouppermi0_.admin_group_id as admin1_0_, grouppermi0_.security_token as security2_0_ from admin_group_permission_tbl grouppermi0_ where grouppermi0_.admin_group_id=?
2012-05-22 08:58:18,106: ERROR [http-8080-1] org.agnitas - execute: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT count(ip_address), ifnull(timestampdiff(second, max(ifnull(creation_date, 0)), now()),0) FROM login_track_tbl WHERE ip_address = ? AND login_status = 20 AND creation_date > ( SELECT ifnull(max(creation_date), 0) FROM login_track_tbl WHERE ip_address = ? AND login_status = 10)]; SQL state [HY000]; error code [145]; Table './openemm/login_track_tbl' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table './openemm/login_track_tbl' is marked as crashed and should be repaired
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:641)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:670)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:678)
org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:710)
org.agnitas.dao.impl.LoginTrackDaoImpl.getFailedLoginData(LoginTrackDaoImpl.java:101)
org.agnitas.web.LogonAction.isIPLogonBlocked(LogonAction.java:336)
org.agnitas.web.LogonAction.logon(LogonAction.java:287)
org.agnitas.web.LogonAction.execute(LogonAction.java:107)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)

Re: No login possible

Posted: Tue May 22, 2012 8:19 am
by maschoff
Your login_track_tbl (contains all login tries to track failed logins, used for login block) seems to be corrupt. You could stop OpenEMM, drop the table and create a new one with

Code: Select all

DROP TABLE IF EXISTS `login_track_tbl`;
SET @saved_cs_client     = @@character_set_client;
SET character_set_client = utf8;
CREATE TABLE `login_track_tbl` (
  `login_track_id` int(11) NOT NULL auto_increment,
  `ip_address` varchar(20) collate utf8_unicode_ci default NULL,
  `creation_date` timestamp NOT NULL default CURRENT_TIMESTAMP,
  `login_status` int(11) default NULL,
  `username` varchar(50) collate utf8_unicode_ci default NULL,
  PRIMARY KEY  (`login_track_id`),
  KEY `logtrck$ip_cdate_stat$idx` (`ip_address`,`creation_date`,`login_status`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
SET character_set_client = @saved_cs_client;

Re: No login possible

Posted: Tue May 22, 2012 8:55 pm
by ManfredCC
That was it...

THANK YOU SOOOO MUCH!

BR Manfred