Original Message:
Sent: 02-26-2024 07:22
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka,
Thanks for your immediate response.
As per your suggestion, I have checked the access for "hibuser" account and access was not there.
Contacted respected team and got access, started server again and now I am getting some different type of exception which I am unaware of.
NOTE : We are using Community Edition of Pentaho Server and we use the kar file provided by you as we were not able to build it due to maven dependency errors. Also In the document it is mentioned like based on the kar file a configuration file pentaho.saml.cfg will get created, but it didn't gets created for me . So we took it from github : pentaho-engineering-samples/Samples_for_Extending_Pentaho/Reference Implementations/Security/SAML 2.0/pentaho-saml/src/main/resources/cfg/pentaho.saml.cfg at 9.4 · pentaho/pentaho-engineering-samples · GitHub
Basically does kar is compatible or supports CE server ?
Kindly find the attached logs and kar details and help me in any possible way please.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-23-2024 06:57
From: Petr Prochazka
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
HI @Praveen Shibu,
this is interesting exception:
2024-02-23 01:14:53,413 ERROR [org.hibernate.tool.hbm2ddl.SchemaUpdate] could not get database metadatajava.sql.SQLException: Access denied for user 'hibuser'@'127.0.0.1' (using password: YES) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:965) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3933) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3869) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:864) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.MysqlIO.proceedHandshakeWithPluggableAuthentication(MysqlIO.java:1707) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1217) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2220) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2015) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:768) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.48.jar:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?] at java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[?:?] at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:385) ~[mysql-connector-java-5.1.48.jar:?] at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:323) ~[mysql-connector-java-5.1.48.jar:?] at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) ~[tomcat-jdbc-8.5.27.jar:?] at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) ~[tomcat-jdbc-8.5.27.jar:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) ~[tomcat-jdbc-8.5.27.jar:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) ~[tomcat-jdbc-8.5.27.jar:?] at org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) ~[tomcat-jdbc-8.5.27.jar:?] at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) ~[tomcat-jdbc-8.5.27.jar:?] at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:92) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.tool.hbm2ddl.SuppliedConnectionProviderConnectionHelper.prepare(SuppliedConnectionProviderConnectionHelper.java:51) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.tool.hbm2ddl.SchemaUpdate.execute(SchemaUpdate.java:168) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:375) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1872) ~[hibernate-core-3.6.9.Final.jar:3.6.9.Final] at org.pentaho.platform.repository.hibernate.HibernateUtil.initialize(HibernateUtil.java:171) ~[pentaho-platform-repository-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.repository.hibernate.HibernateUtil.<clinit>(HibernateUtil.java:92) ~[pentaho-platform-repository-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.cdf.environment.configurations.PentahoHibernanteConfigurations.getConfiguration(PentahoHibernanteConfigurations.java:30) ~[?:?] at org.pentaho.cdf.utils.PluginHibernateUtil.initialize(PluginHibernateUtil.java:58) ~[?:?] at org.pentaho.cdf.storage.StorageEngine.<clinit>(StorageEngine.java:39) ~[?:?] at org.pentaho.cdf.storage.StorageApi.<init>(StorageApi.java:46) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[?:?] at jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[?:?] at java.lang.reflect.Constructor.newInstance(Constructor.java:490) ~[?:?] at org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:212) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:87) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:1310) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1216) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:571) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:531) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:335) ~[spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) [spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:333) [spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:208) [spring-beans-5.3.3.jar:5.3.3] at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:944) [spring-beans-5.3.3.jar:5.3.3] at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:923) [spring-context-5.3.3.jar:5.3.3] at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:588) [spring-context-5.3.3.jar:5.3.3] at org.pentaho.platform.plugin.services.pluginmgr.PentahoSystemPluginManager.reload(PentahoSystemPluginManager.java:292) [pentaho-platform-extensions-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.plugin.services.pluginmgr.PentahoSystemPluginManager.reload(PentahoSystemPluginManager.java:182) [pentaho-platform-extensions-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.plugin.services.pluginmgr.PluginAdapter.startup(PluginAdapter.java:43) [pentaho-platform-extensions-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:476) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem$2.call(PentahoSystem.java:467) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:446) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:467) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.access$000(PentahoSystem.java:87) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:398) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem$1.call(PentahoSystem.java:395) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.runAsSystem(PentahoSystem.java:446) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.notifySystemListenersOfStartup(PentahoSystem.java:395) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:365) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.engine.core.system.PentahoSystem.init(PentahoSystem.java:251) [pentaho-platform-core-9.4.0.0-343.jar:9.4.0.0-343] at org.pentaho.platform.web.http.context.SolutionContextListener.contextInitialized(SolutionContextListener.java:159) [pentaho-platform-extensions-9.4.0.0-343.jar:9.4.0.0-343] at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4768) [catalina.jar:9.0.65] at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5230) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.65] at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:726) [catalina.jar:9.0.65] at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:698) [catalina.jar:9.0.65] at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:696) [catalina.jar:9.0.65] at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1185) [catalina.jar:9.0.65] at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1933) [catalina.jar:9.0.65] at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.65] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:118) [?:?] at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1095) [catalina.jar:9.0.65] at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:477) [catalina.jar:9.0.65] at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1618) [catalina.jar:9.0.65] at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:319) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.fireLifecycleEvent(LifecycleBase.java:123) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.setStateInternal(LifecycleBase.java:423) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.setState(LifecycleBase.java:366) [catalina.jar:9.0.65] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:946) [catalina.jar:9.0.65] at org.apache.catalina.core.StandardHost.startInternal(StandardHost.java:835) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.65] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1396) [catalina.jar:9.0.65] at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1386) [catalina.jar:9.0.65] at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?] at org.apache.tomcat.util.threads.InlineExecutorService.execute(InlineExecutorService.java:75) [tomcat-util.jar:9.0.65] at java.util.concurrent.AbstractExecutorService.submit(AbstractExecutorService.java:140) [?:?] at org.apache.catalina.core.ContainerBase.startInternal(ContainerBase.java:919) [catalina.jar:9.0.65] at org.apache.catalina.core.StandardEngine.startInternal(StandardEngine.java:265) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.65] at org.apache.catalina.core.StandardService.startInternal(StandardService.java:432) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.65] at org.apache.catalina.core.StandardServer.startInternal(StandardServer.java:930) [catalina.jar:9.0.65] at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:183) [catalina.jar:9.0.65] at org.apache.catalina.startup.Catalina.start(Catalina.java:772) [catalina.jar:9.0.65] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?] at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?] at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?] at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?] at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:345) [bootstrap.jar:9.0.65]
This can be problem, that Spring context is not startup correctly. Check access of account hibuser to MySQL DB.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 02-23-2024 06:41
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka ,
Please find the attached files pentaho.log, localhost.log and for the catalina.log the file size is much higher(73GB) so couldn't able to upload the whole file , we copied some part of the trace and attached the same. Kindly find the attachments below .
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-22-2024 06:04
From: Petr Prochazka
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi Praveen,
there are two things which can raise this exception. Bad configuration or kar is not compatible with CE server.
But could you provide clean logs after start? Timestamps in log are strange. And pls attach catalina.log and pentaho.log too.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 02-22-2024 00:56
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka,
Could you please help me with the exception trace. Any help would be greatly appreciated.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-20-2024 07:46
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka,
Kindly find the below attachment for the full stack trace of exception.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-20-2024 06:25
From: Petr Prochazka
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
HI @Praveen Shibu,
pls provide full stack trace of exception.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 02-20-2024 03:08
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka,
After getting the kar file from you, we have followed the remaining steps for implementing OKTA in pentaho server from the link ( https://github.com/pentaho/pentaho-engineering-samples/blob/9.4/Samples_for_Extending_Pentaho/Reference%20Implementations/Security/SAML%202.0/documentation/Activating_SAML_sample_in_BA_server.pdf )
After completing all the steps, when we try to start the server now getting an exception "BeanCreationException error from the file applicationContext-spring-security-saml.xml" . I have attached the exception server logs as well as the applicationContext saml file which we got from the github.
applicationContext saml file github path : Samples_for_Extending_Pentaho/Reference Implementations/Security/SAML 2.0/documentation/resources/applicationContext-spring-security-saml.xml
Kindly find the details and it would be very helpful if we can get any help or solution.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-08-2024 01:18
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka,
Thanks for the immediate reply as well as the kar file. I will try to implement the same in my project and let you know about the status.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-07-2024 02:25
From: Petr Prochazka
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi Preveen,
if you don't have required artifacts from remote repository, it's not possible. But I build SAML sample from Github repository. Artifacts find as attachment.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 02-07-2024 01:13
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Petr Prochazka
Thanks for the reply. I was trying to build a kar file for Pentaho server okta authentication, as per the document based on the Github path pentaho-engineering-samples/Samples_for_Extending_Pentaho/Reference Implementations/Security/SAML 2.0/documentation/SAML2 Pentaho BA Server Best Practices.pdf at master · pentaho/pentaho-engineering-samples · GitHub .
The official repo site https://repo.orl.eng.hitachivantara.com/ has some issues, i was not able to build the kar file because of the above-mentioned license-helper-maven-plugin issue , it would be more helpful if you provide us a kar file or is there any way to build a kar file without any issue.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
Original Message:
Sent: 02-06-2024 06:36
From: Petr Prochazka
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi @Praveen Shibu
Nexus repository manger was shutdown. Official repo site is https://repo.orl.eng.hitachivantara.com/. And as you said, license expired. I don't known if it's a bug or intentional. You are not first with this problem.
------------------------------
Petr Prochazka
Systems Engineer
P.V.A. systems s.r.o.
Original Message:
Sent: 02-06-2024 00:56
From: Praveen Shibu
Subject: Issue while downloading Maven License Helper Plugin: code 503 from server: Service Unavailable
Hi,
I have tried to download maven license plugin for Pentaho from url : https://nexus.pentaho.org/content/groups/omni/org/pentaho/maven/plugins/license-helper-maven-plugin/1.26/license-helper-maven-plugin-1.26.jar
but the page is not available and got error "503 Service Unavailable".
From this community discussion, someone mentioned like maven license plugin is moved to new url : https://repo.orl.eng.hitachivantara.com/ui/native/pnt-mvn/org/pentaho/maven/plugins/license-helper-maven-plugin/1.26/
but page is not loading with error message "Something went wrong" and seems like the page license is expired.
Attaching screenshots below.
I need help to resolve this asap. Any help would be appreciated.
------------------------------
Praveen Shibu
Others
Guidehouse Pvt Ltd
------------------------------