Hi Douglas,
That seems to be the issue, you will need to add a store to the zone. You can do that either via UI / command line. On the UI, there is the "Add Secondary Storage" button, provide the zone, the server IP/name, and the path (in your case, /export/secondary). Thanks, Pearl ________________________________ From: DL <douglasl...@gmail.com> Sent: Monday, September 20, 2021 10:16 AM To: users@cloudstack.apache.org <users@cloudstack.apache.org> Subject: Re: Problem with Templates/ISO @Pearl I can go to the Infrastructure -> Secondary Storage tab. However, nothing is there. @Harikrishna Thank you also for getting back to me! Here is what I found related to the error in the log: 2021-09-20 00:27:12,093 DEBUG [c.c.a.ApiServlet] (qtp1136768342-20:ctx-d9bd1f44) (logid:a56ace1d) ===START=== 172.16.10.2 -- GET listall=true&templatefilter=all&showunique=true&page=1&pagesize=20&command=listTemplates&response=json 2021-09-20 00:27:12,097 DEBUG [c.c.a.ApiServer] (qtp1136768342-20:ctx-d9bd1f44 ctx-931ef03f) (logid:a56ace1d) CIDRs from which account 'Acct[2e801633-1977-11ec-98da-5254005ad990-admin]' is allowed to perform API calls: 0.0.0.0/0,::/0 2021-09-20 00:27:12,110 ERROR [c.c.a.ApiServer] (qtp1136768342-20:ctx-d9bd1f44 ctx-931ef03f) (logid:a56ace1d) unhandled exception executing api command: [Ljava.lang.String;@421e6f13 com.cloud.utils.exception.CloudRuntimeException: DB Exception on: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT template_store_ref.id, template_store_ref.store_id, template_store_ref.template_id, template_store_ref.store_role, template_store_ref.created, template_store_ref.last_updated, template_store_ref.download_pct, template_store_ref.size, template_store_ref.physical_size, template_store_ref.download_state, template_store_ref.local_path, template_store_ref.error_str, template_store_ref.job_id, template_store_ref.install_path, template_store_ref.url, template_store_ref.download_url, template_store_ref.download_url_created, template_store_ref.is_copy, template_store_ref.destroyed, template_store_ref.update_count, template_store_ref.updated, template_store_ref.state, template_store_ref.ref_cnt FROM template_store_ref WHERE template_store_ref.template_id = 3 AND template_store_ref.download_state != 'BYPASSED' AND template_store_ref.destroyed = 0 AND template_store_ref.store_id IN ) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:423) at com.cloud.utils.db.GenericDaoBase.searchIncludingRemoved(GenericDaoBase.java:359) at com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:348) at com.cloud.utils.db.GenericDaoBase.search(GenericDaoBase.java:1308) at org.apache.cloudstack.storage.image.db.TemplateDataStoreDaoImpl.listByTemplateNotBypassed(TemplateDataStoreDaoImpl.java:431) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at com.sun.proxy.$Proxy79.listByTemplateNotBypassed(Unknown Source) at com.cloud.api.query.dao.TemplateJoinDaoImpl.newTemplateResponse(TemplateJoinDaoImpl.java:165) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.base/java.lang.reflect.Method.invoke(Method.java:566) at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) at com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) at com.sun.proxy.$Proxy308.newTemplateResponse(Unknown Source) at com.cloud.api.ApiDBUtils.newTemplateResponse(ApiDBUtils.java:2022) at com.cloud.api.query.ViewResponseHelper.createTemplateResponse(ViewResponseHelper.java:590) at com.cloud.api.query.QueryManagerImpl.listTemplates(QueryManagerImpl.java:3336) at org.apache.cloudstack.api.command.user.template.ListTemplatesCmd.execute(ListTemplatesCmd.java:180) at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:156) at com.cloud.api.ApiServer.queueCommand(ApiServer.java:764) at com.cloud.api.ApiServer.handleRequest(ApiServer.java:588) at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:321) at com.cloud.api.ApiServlet$1.run(ApiServlet.java:134) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:55) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:102) at org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:52) at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:131) at com.cloud.api.ApiServlet.doGet(ApiServlet.java:93) at javax.servlet.http.HttpServlet.service(HttpServlet.java:645) at javax.servlet.http.HttpServlet.service(HttpServlet.java:750) at org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1443) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:791) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:602) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) at org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1435) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) at org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1350) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) at org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:766) at org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) at org.eclipse.jetty.server.Server.handle(Server.java:516) at org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:388) at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:633) at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:380) at org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273) at org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171) at org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129) at org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:773) at org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:905) at java.base/java.lang.Thread.run(Thread.java:829) Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1 at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122) ... 87 more 2021-09-20 00:27:12,122 DEBUG [c.c.a.ApiServlet] (qtp1136768342-20:ctx-d9bd1f44 ctx-931ef03f) (logid:a56ace1d) ===END=== 172.16.10.2 -- GET listall=true&templatefilter=all&showunique=true&page=1&pagesize=20&command=listTemplates&response=json Could you help me to pinpoint what I may have done wrong? On Mon, Sep 20, 2021 at 12:38 AM Harikrishna Patnala < harikrishna.patn...@shapeblue.com> wrote: > Sorry, logs at /var/log/cloudstack/management/management-server.log > ________________________________ > From: Harikrishna Patnala <harikrishna.patn...@shapeblue.com> > Sent: Monday, September 20, 2021 10:04 AM > To: users@cloudstack.apache.org <users@cloudstack.apache.org> > Subject: Re: Problem with Templates/ISO > > > Hi Douglas, > > Firstly, welcome to CloudStack. > > This looks to me like DB changes did not apply properly during > installation. Did you observe any issues in the logs during the management > server installation or start. > > You can check the logs at > /usr/share/cloudstack/management/management-server.log and see the exact > reason for DB sql exception when you perform the list templates operation. > > As mentioned already there is no change in the system VM template from > 4.15.1 to 4.15.2 > > Regards, > Harikrishna > ________________________________ > From: DL <douglasl...@gmail.com> > Sent: Monday, September 20, 2021 9:38 AM > To: users@cloudstack.apache.org <users@cloudstack.apache.org> > Subject: Problem with Templates/ISO > > Hello there, > > I am a new CloutStack user and a new user on this mailing list. After > following the Quick Installation Guide, I ended up with empty Template/ISOs > when I attempted to create a VM instance. > > If I go to Images/Templates, I got 500 Internal Server Error: > > Request Failed (530) > DB Exception on: com.mysql.cj.jdbc.ClientPreparedStatement: SELECT > template_store_ref.id, template_store_ref.store_id, > template_store_ref.template_id, template_store_ref.store_role, > template_store_ref.created, template_store_ref.last_updated, > template_store_ref.download_pct, template_store_ref.size, > template_store_ref.physical_size, template_store_ref.download_state, > template_store_ref.local_path, template_store_ref.error_str, > template_store_ref.job_id, template_store_ref.install_path, > template_store_ref.url, template_store_ref.download_url, > template_store_ref.download_url_created, template_store_ref.is_copy, > template_store_ref.destroyed, template_store_ref.update_count, > template_store_ref.updated, template_store_ref.state, > template_store_ref.ref_cnt FROM template_store_ref WHERE > template_store_ref.template_id = 3 AND template_store_ref.download_state != > 'BYPASSED' AND template_store_ref.destroyed = 0 AND > template_store_ref.store_id IN ) > > Could someone help me fix this issue? > > The quick installation guide I followed says it is for 4.15.2.0 > installation. However, in the System Template Setup section, this command: > """ > > /usr/share/cloudstack-common/scripts/storage/secondary/cloud-install-sys-tmplt > -m /export/secondary -u > > https://download.cloudstack.org/systemvm/4.15/systemvmtemplate-4.15.1-kvm.qcow2.bz2 > -h > <https://download.cloudstack.org/systemvm/4.15/systemvmtemplate-4.15.1-kvm.qcow2.bz2-h> > kvm -F > """ > seems to suggest that the process will download template vms for the > 4.15.1.0 version? > > Could this be the reason? Does anyone have an idea about when the Template > for the 4.15.2.0 version will be available? > > Best regards, > Douglas