admin console problem

[dshenkel]

i'm unable login to admin console 2.0.0RC1 after reconfiguring to point to our MySQL database. No queries ever make it to our db which is conferred by the logs. Can somebody point me in the right direction of which configuration to look at? Thank you.

Here's the console log:

Oct 19, 2008 1:21:27 PM org.pentaho.pac.server.JettyServer startServer
INFO: Console Starting
2008-10-19 13:21:27.500::INFO: jetty-6.1.2
2008-10-19 13:21:27.109::INFO: Started SocketConnector @ localhost:8099
2008-10-19 13:22:25.203::WARN: java.lang.SecurityException: Configuration Error
:
Line 1: expected [module class name], found [null]
2008-10-19 13:22:25.219::WARN: AUTH FAILURE: user joe

[dshenkel]

anybody have any suggestions?

can somebody from pentaho team update this wiki which is currently blank - http://wiki.pentaho.com/display/PentahoDoc/Configuring+Security+with+Pentaho+Administration+Console

thank you.

[rmansoor]

This is the guide to installing and configuring pentaho administration console. Please use this

http://wiki.pentaho.com/display/ServerDoc1x/.02+Installing+and+Configuring+the+Pentaho+Administration+Console

[bugg_tb]

isn't admin console, admin/admin? or admin/password (one of the two)

Tom

[pstoellberger]

should be admin/password

-paul

[dshenkel]

i changed my admin configuration to point to our MySQL database. after the change was made admin/password no longer works. admin console should hitting our MySQL database to fetch the password and authorizations, but the logs don't show any queries on the database side. however, pentaho user console works just fine for any user and the reports show up as well. so i'm missing some step in the configuration.... any ideas of what i could be missing?

[dshenkel]

i found the problem... in login.conf the header name should not be 'jdbc' as it is in the wiki but JDBCLoginModule. i also took out the encoding for spaces and put the hibernate config file's name in console.xml which is also absent in the wiki. now i have a different a problem. after i login to the admin console the data is not fetched from db. here's the stack trace:

2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] JspEngine --> /jsp/SchedulerAdmin.jsp
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] ServletPath: /SchedulerAdmin
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] PathInfo: null
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] RealPath: C:\Documents and Settings\Dmitry\Desktop\biserver-ce\tomcat\webapps\pentaho\jsp\SchedulerAdmin.jsp
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] RequestURI: /pentaho//SchedulerAdmin
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] QueryString: schedulerAction=getJobNames&requestedMimeType=text%2Fxml&_TRUST_USER_=admin
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] Request Params:
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] schedulerAction = getJobNames
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] requestedMimeType = text/xml
2008-10-20 11:00:10,999 DEBUG [org.apache.jasper.servlet.JspServlet] _TRUST_USER_ = admin
2008-10-20 11:00:11,077 DEBUG [org.acegisecurity.context.HttpSessionContextIntegrationFilter] SecurityContextHolder now cleared, as request processing completed
2008-10-20 11:00:11,077 DEBUG [org.acegisecurity.context.HttpSessionContextIntegrationFilter] SecurityContextHolder now cleared, as request processing completed
2008-10-20 11:00:11,077 ERROR [org.apache.catalina.core.ContainerBase.[Catalina].[localhost].[/pentaho].[SchedulerAdmin]] Servlet.service() for servlet SchedulerAdmin threw exception
java.lang.NullPointerException
at org.pentaho.platform.scheduler.SchedulerAdminUIComponent.doGetJobNames(SchedulerAdminUIComponent.java:348)
at org.pentaho.platform.scheduler.SchedulerAdminUIComponent.getXmlContent(SchedulerAdminUIComponent.java:184)
at org.pentaho.platform.uifoundation.component.xml.XmlComponent.getContent(XmlComponent.java:52)
at org.apache.jsp.jsp.SchedulerAdmin_jsp._jspService(SchedulerAdmin_jsp.java:93)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)

[dshenkel]

i got it.... the problem seems to be that there's a pentaho-open-admin-console.jar file that get picked up by jetty. this jar has it's own sample configurations for MySQL with hibuser/password at localhost:3306. i guess it's a fall-back config. solution for Windows users would be to add the resource/hibernate folder to the CLASSPATH in startup.bat right after the resource/config which would move the hibernate user defined config ahead of the jar file's configuration. not sure why nobody replied. am i really the only one who faced this problem?

[rmansoor]

This issue with hibernate configuration has been resolved as is in the post RC release. As for the other issue regarding authentication using JDBC. I have update the wiki so please read this wiki doc as it will help you successfully configure administration console to authenticate with JDBC
http://wiki.pentaho.com/display/ServerDoc1x/Configuring+Security+with+Pentaho+Administration+Console

[Roland.Bouman]

solution for Windows users would be to add the resource/hibernate folder to the CLASSPATH in startup.bat right after the resource/config which would move the hibernate user defined config ahead of the jar file's configuration. not sure why nobody replied. am i really the only one who faced this problem?

No I was experiencing the same problem but never looked into it properly. Thanks a lot - your solution works for me.

Roland

[rommie]

i got it.... the problem seems to be that there's a pentaho-open-admin-console.jar file that get picked up by jetty. this jar has it's own sample configurations for MySQL with hibuser/password at localhost:3306. i guess it's a fall-back config. solution for Windows users would be to add the resource/hibernate folder to the CLASSPATH in startup.bat right after the resource/config which would move the hibernate user defined config ahead of the jar file's configuration. not sure why nobody replied. am i really the only one who faced this problem?


Im currently figuring out the same problem with my Linux box connecting to MySQL. And this error still haunting me

2008-11-27 17:59:26.618::WARN: javax.security.auth.login.LoginException: Login Failure: all modules ignored
2008-11-27 17:59:26.619::WARN: AUTH FAILURE: user admin

I also checked your posting in PostgresSQL thread
http://forums.pentaho.org/showthread.php?t=65201

But neither of the two work for me.