Activity for Tarun Chopra
-
Tarun Chopra posted a comment on discussion Help
Thanks much Tomas. I was able to get fresh DB going and it worked for Oracle. Quite possible it could be the way I was accessing DB. I may go towards MySQL to get this going given that Oracle may have issues going forward. Question: Does following look like good plan for Oracle to MySQL switch or am I missing it big time 1) Shutdown Existing App server 2) Export Oracle into dump file 3) Build new environment with fresh MySQL DB connection 4) Shutdown new App Server 5) Import Oracle dump into MySQL...
-
Hey Tomas I double checked and DB looks good. Infact, using same credentials and SQL provided with in EJBCA (create-tables-ejbca-oracle.sql) I was able to create whole schema with no error. Would appreciate if you could share more sign on a) datasource using Oracle driver, exact syntax b) standard.xml update for oracle driver c) database.properties for database.driver Is there a place where I can look for Docker image using Oracle? BTW, can we use docker with external Oracle Database? that would...
-
Thx Tomas again! I am making progress in troubleshooting but still no luck. So, I was able to drop all tables, clean recycle bin. Tried again, and still gives Ora error of either table does not exist. I dropped again, picked up Schema creating SQL from how-to and created DB from fresh. It did pass the DB errors but it ended up doing another error - 10.180.151.234 16:18:42,157 ERROR [org.jboss.as.controller.management-operation] (DeploymentScanner-threads - 2) JBAS014612: Operation ("deploy") failed...
-
Appreciate you looking into this, please review and give me further pointers: here is server.log from another attempt. worked with Database person and he confirmed there are no locks, cleard/dropped all tables and elevated access to highest level for the Schema updated/sym linked driver to ojdbc7.jar, it shows driver 12.1 version now vs old 11.1 now) don't see 39 tables that used to create earlier. it only creates 11 tables. i do see Ora error this time but thats just saying cannot create table.
-
Appreciate you looking into this, please review and give me further pointers: here is server.log from another attempt. worked with Database person and he confirmed there are no locks, cleard/dropped all tables and elevated access to highest level for the Schema updated/sym linked driver to ojdbc7.jar, it shows driver 12.1 version now vs old 11.1 now) don't see 39 tables that used to create earlier. it only creates 11 tables. i do see Ora error this time but thats just saying cannot create table.
-
Thanks much to look into this Tomas here is server.log. i changed DB to SERVER_FQDN will post more information later as well as i am trying to try few things.
-
Appreciate you looking into this, please review and give me further pointers: here is server.log from another attempt. worked with Database person and he confirmed there are no locks, cleard/dropped all tables and elevated access to highest level for the Schema updated/sym linked driver to ojdbc7.jar, it shows driver 12.1 version now vs old 11.1 now) don't see 39 tables that used to create earlier. it only creates 11 tables. i do see Ora error this time but thats just saying cannot create table....
-
thx how is the configuration in standard.xml for driver? the issue is that it driver works but app server dies so it is some optimization that is required in app to DB channel On Mon, Sep 21, 2020, 22:25 Tomas Gustavsson anatom@users.sourceforge.net wrote: The most/only important is "database.name=oracle". Oracle is a very common database used in production environments, so it is certain that it works. EJBCA giving error for ant deploy or install https://sourceforge.net/p/ejbca/discussion/123123/thread/f7cbf035cf/?limit=50#0e23...
-
I tried mysql-server and it worked out fine after few hiccups. I was able to to get to EJBCA web page. So this tells me that it is some issue with Oracle connection/driver/DB itself. I tried few more options still no luck 1) Reached out to someone to explore DB health and as per him DB checks out fine. Don't see connection error or any other sort of locks. I drop all tables before i try a fresh install and it does create them during deploy option as well when i try to start App server. just FYI 2)...
-
thx i have updated post to follow other post On Fri, Sep 18, 2020 at 7:55 AM "Markus Kilås" netmackan@users.sourceforge.net wrote: Hi Tarun, This looks like a multipost of https://sourceforge.net/p/signserver/discussion/668766/thread/462445893b/#68a1 . Please use only one channel. See comment there. Cheers, Markus Unable to "install or deploy" using Oracle OJDBC (driver works though) https://sourceforge.net/p/signserver/discussion/668765/thread/d9e94508ba/?limit=25#beb7 Sent from sourceforge.net...
-
updating post to follow other post https://sourceforge.net/p/ejbca/discussion/123123/thread/f7cbf035cf/
-
thx Tomas i see tables getting populated in DB but thats pretty much it. any more pointer please as what else to check in Oracle DB? for MySQL, I tried adding following to in database.properties but no luck mysql://localhost:3306/ejbca?autoReconnect=true&useSSL=false thx again! On Fri, Sep 18, 2020, 01:41 Tomas Gustavsson anatom@users.sourceforge.net wrote: In the MySQL case, you have TLS errors as indicated by the error message. Follow the instructions hinted to in the MySQL error message. For your...
-
On a separate note, I am also trying MySQL in case if this figure outs to be DB issue. As of now, it is stuck with following ERROR 16:15:54,754 INFO [org.jboss.as] (Controller Boot Thread) JBAS015874: JBoss EAP 6.4.0.GA (AS 7.5.0.Final-redhat-21) started in 196ms - Started 162 of 200 services (58 services are lazy, passive or on-demand) 16:15:54,855 ERROR [stderr] (JCA PoolFiller) Thu Sep 17 16:15:54 PDT 2020 WARN: Establishing SSL connection without server's identity verification is not recommended....
-
Thanks much to look into this Tomas here is server.log. i changed DB to SERVER_FQDN will post more information later as well as i am trying to try few things. 09:04:14,480 INFO [org.jboss.modules] (main) JBoss Modules version 1.3.6.Final-redhat-1 09:04:14,725 INFO [org.jboss.msc] (main) JBoss MSC version 1.1.5.Final-redhat-1 09:04:14,788 INFO [org.jboss.as] (MSC service thread 1-6) JBAS015899: JBoss EAP 6.4.0.GA (AS 7.5.0.Final-redhat-21) starting 09:04:14,794 DEBUG [org.jboss.as.config] (MSC service...
-
Thx Tomas for replying! if you could look into my wildfly error below? For EAP7, I will dig more to see my options. is it a paid product?
-
I also tried wildfly 14 as documented on website, that gives following: ant -> /usr/share/ant ejbca -> /apps/ejbca_ce_6_15_2_6/ java -> /apps/jdk1.8.0_261/ jboss -> /apps/wildfly-14.0.1.Final/ ant -q build and deployear : works however, install still gives following error on app server console - 15:47:09,089 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.server.DeployerChainAddHandler$FinalRuntimeStepHandler@149846fb for operation...
-
deploy is successful and i see database also getting tables populated but it makes JBOSS instance unstable and instance dies after time out. (EAR rolled back once it times out) initial WARN/ERROR messages on JBOSS console are 10:16:51,205 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 46) JBAS010153: Node identifier property is set to the default value. Please make sure it is unique. 10:35:53,070 WARN [org.jboss.as.txn] (ServerService Thread Pool -- 46) JBAS010153: Node identifier property...
-
Anyone seen these version working together? ant -> /apps/apache-ant-1.9.15/ ejbca -> /apps/ejbca_ce_6_15_2_6/ java -> /apps/jdk1.8.0_261/ jboss -> /apps/jboss-eap-6.4/ It gives error on "deploy" (JBAS014777: Services which failed to start: service jboss.deployment.unit."ejbca.ear".INSTALL) Or this error on "install " [java] Error: CLI could not contact EJBCA instance. Either your application server is not up and running, EJBCA has not been deployed successfully, or some firewall rule is blocking...
-
Anyone seen these version working together? ant -> /apps/apache-ant-1.9.15/ ejbca -> /apps/ejbca_ce_6_15_2_6/ java -> /apps/jdk1.8.0_261/ jboss -> /apps/jboss-eap-6.4/ It gives error on "deploy" (JBAS014777: Services which failed to start: service jboss.deployment.unit."ejbca.ear".INSTALL) Or this error on "install " [java] Error: CLI could not contact EJBCA instance. Either your application server is not up and running, EJBCA has not been deployed successfully, or some firewall rule is blocking...
-
Anyone seen these version working together? ant -> /apps/apache-ant-1.9.15/ ejbca -> /apps/ejbca_ce_6_15_2_6/ java -> /apps/jdk1.8.0_261/ jboss -> /apps/jboss-eap-6.4/ It gives error on "deploy" (JBAS014777: Services which failed to start: service jboss.deployment.unit."ejbca.ear".INSTALL) Or this error on "install " [java] Error: CLI could not contact EJBCA instance. Either your application server is not up and running, EJBCA has not been deployed successfully, or some firewall rule is blocking...
1