Login issue 18-11-2015 Creator: Mani Attico

[TalaiaOpenPPMParticipant]

Hello.

I am not able to login in OpenPPM. This is my server:
Ubuntu 14.04.3LTS
Tomcat 7.0.64
java version « 1.7.0_79 »
Java(TM) SE Runtime Environment (build 1.7.0_79-b15)
Java HotSpot(TM) 64-Bit Server VM (build 24.79-b02, mixed mode)
MySQL 5.5.44 in other server (I can connect with a client)

I’ve the MySQL JDBC driver in:
/opt/apache-tomcat-7.0.64/lib/mysql-connector-java-5.1.13-bin.jar

When I deploy the app, it show me the login page. I enter admin:admin, however y get:

Login error
You have entered invalid name and password.

This is the record of catalina.out:

GRAVE: Error inesperado
javax.security.auth.login.LoginException: No se han configurado LoginModules para OpenPPMWeb
    at javax.security.auth.login.LoginContext.init(LoginContext.java:272)
    at javax.security.auth.login.LoginContext.<init>(LoginContext.java:520)
    at org.apache.catalina.realm.JAASRealm.authenticate(JAASRealm.java:415)
    at org.apache.catalina.realm.JAASRealm.authenticate(JAASRealm.java:354)
    at org.apache.catalina.authenticator.FormAuthenticator.authenticate(FormAuthenticator.java:267)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:453)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:956)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:423)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1079)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:625)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:318)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
    at java.lang.Thread.run(Thread.java:745)

I’ve this in openppm.xml (default config):

<WatchedResource>WEB-INF/web.xml</WatchedResource>
    <Realm className="org.apache.catalina.realm.JAASRealm"
        appName="OpenPPMWeb"
        userClassNames="es.sm2.openppm.auth.PlainUserPrincipal"
        roleClassNames="es.sm2.openppm.auth.PlainRolePrincipal"
        useContextClassLoader="true"/>

I’ve run the setenv.sh with the same result

Thank you in advanced.

Regards.

 

 

-Mani Attico (18-11-2015)

Now I get this user lock. It pass 10 minutes and the user is still locked. I restart Tomcat, and is still locked.

Login error
Your account has been blocked. Expire on the date 18/11/2015 08:56:11

How can I fix it?

Thanks

 

 

-Guillermo (18-11-2015)

Hi Mani,

Did you manage to solve the first issue?

For the second one, you can just unlock the user directly in the database. Connect to the database and type:

UPDATE Security SET dateLapsed = NULL

This will unlock all the users. You may filter the sentence so you just unlock the user yo expect to be unlocked.

Regards,
Guillermo.

 

 

-Mani Attico (18-11-2015)

I’d tried that jet, and inserting a past and future date in this field, however it doesn’t work.

I can’t solve the first issue if I can’t login to check 😉

Thank you.

 

 

-Mani Attico (19-11-2015)

OK, I restored the DB and now the account is not locked. Altought I have the original issue (javax.security.auth.login.LoginException: No se han configurado LoginModules para OpenPPMWeb)

 

 

-Mani Attico (19-11-2015)

I fix it by adding openppm’s setenv.sh content to the tomcat’s setenv.sh

[Auteur]

Messages