No login possible

Use this forum for all other questions regarding OpenEMM

Moderator: moderator

ManfredCC
Posts: 21
Joined: Sat Oct 22, 2011 7:46 pm

No login possible

Post 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!
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: No login possible

Post by maschoff »

Did you check log file catalina.out?
OpenEMM Maintainer
ManfredCC
Posts: 21
Joined: Sat Oct 22, 2011 7:46 pm

Re: No login possible

Post 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)
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: No login possible

Post 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;
OpenEMM Maintainer
ManfredCC
Posts: 21
Joined: Sat Oct 22, 2011 7:46 pm

Re: No login possible

Post by ManfredCC »

That was it...

THANK YOU SOOOO MUCH!

BR Manfred
Post Reply