search

oVirt / ovirt-engine

The oVirt Engine virtualization manager
Other
512 stars 268 forks source link

ovirt-engine webadmin cann't open, error select * from gettagsbyparent_id() #2

Closed digoal closed 8 years ago

digoal commented 10 years ago

When i enter ovirt-engine URL, the url cann't open, and see some error : root cause

javax.ejb.EJBException: org.springframework.jdbc.BadSqlGrammarException: PreparedStatementCallback; bad SQL grammar [select * from gettagsbyparent_id()]; nested exception is org.postgresql.util.PSQLException: ERROR: function gettagsbyparent_id() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 org.jboss.as.ejb3.tx.CMTTxInterceptor.handleExceptionInOurTx(CMTTxInterceptor.java:166) org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230) org.jboss.as.ejb3.tx.CMTTxInterceptor.requiresNew(CMTTxInterceptor.java:333) org.jboss.as.ejb3.tx.SingletonLifecycleCMTTxInterceptor.processInvocation(SingletonLifecycleCMTTxInterceptor.java:56) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) org.jboss.as.ee.component.BasicComponent.constructComponentInstance(BasicComponent.java:161) org.jboss.as.ee.component.BasicComponent.createInstance(BasicComponent.java:85) org.jboss.as.ejb3.component.singleton.SingletonComponent.getComponentInstance(SingletonComponent.java:116) org.jboss.as.ejb3.component.singleton.SingletonComponentInstanceAssociationInterceptor.processInvocation(SingletonComponentInstanceAssociationInterceptor.java:48) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInNoTx(CMTTxInterceptor.java:211) org.jboss.as.ejb3.tx.CMTTxInterceptor.supports(CMTTxInterceptor.java:363) org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:194) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:173) org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) org.ovirt.engine.core.common.interfaces.BackendLocal$$$view9.runPublicQuery(Unknown Source) org.ovirt.engine.core.WelcomeServlet.doGet(WelcomeServlet.java:82) javax.servlet.http.HttpServlet.service(HttpServlet.java:734) javax.servlet.http.HttpServlet.service(HttpServlet.java:847) org.ovirt.engine.core.branding.BrandingFilter.doFilter(BrandingFilter.java:72) org.ovirt.engine.core.utils.servlet.LocaleFilter.doFilter(LocaleFilter.java:64) root cause

and in database no this function, it's only has an one parameter function. ovirt=# \df gettagsbyparent_id List of functions Schema | Name | Result data type | Argument data types | Type
--------+--------------------+------------------+---------------------+-------- ovirt | gettagsbyparent_id | SETOF tags | v_parent_id uuid | normal (1 row) It's a bug?

digoal commented 10 years ago

i use ovirt-engine 3.4 repo , and use yum install in CentOS 6.5 x64.

digoal commented 10 years ago

engine-setup [root@176 ~]# engine-setup [ INFO ] Stage: Initializing [ INFO ] Stage: Environment setup Configuration files: ['/etc/ovirt-engine-setup.conf.d/10-packaging.conf'] Log file: /var/log/ovirt-engine/setup/ovirt-engine-setup-20140804113942-mpzka3.log Version: otopi-1.2.2 (otopi-1.2.2-1.el6) [ INFO ] Stage: Environment packages setup [ INFO ] Stage: Programs detection [ INFO ] Stage: Environment setup [ INFO ] Stage: Environment customization

      --== PRODUCT OPTIONS ==--

      Configure Reports on this host (Yes, No) [Yes]: 
      Configure Data Warehouse on this host (Yes, No) [Yes]: 

      --== PACKAGES ==--

[ INFO ] Checking for product updates... Setup has found updates for some packages, do you wish to update them now? (Yes, No) [Yes]: [ INFO ] Checking for an update for Setup...

      --== NETWORK CONFIGURATION ==--

      Host fully qualified DNS name of this server [176.sky-mobi.com]: 
      Setup can automatically configure the firewall on this system.
      Note: automatic configuration of the firewall may overwrite current settings.
      Do you want Setup to configure the firewall? (Yes, No) [Yes]: No

      --== DATABASE CONFIGURATION ==--

      Where is the Engine database located? (Local, Remote) [Local]: Remote

      ATTENTION

      Manual action required.
      Please create database for ovirt-engine use. Use the following commands as an example:

      create role engine with login encrypted password 'engine';
      create database engine owner engine
       template template0
       encoding 'UTF8' lc_collate 'en_US.UTF-8'
       lc_ctype 'en_US.UTF-8';

      Make sure that database can be accessed remotely.

      Engine database host [localhost]: 127.0.0.1
      Engine database port [5432]: 
      Engine database secured connection (Yes, No) [No]: 
      Engine database name [engine]: ovirt
      Engine database user [engine]: ovirt
      Engine database password: 
      Where is the DWH database located? (Local, Remote) [Local]: Remote

      ATTENTION

      Manual action required.
      Please create database for ovirt-engine use. Use the following commands as an example:

      create role ovirt_engine_history with login encrypted password 'ovirt_engine_history';
      create database ovirt_engine_history owner ovirt_engine_history
       template template0
       encoding 'UTF8' lc_collate 'en_US.UTF-8'
       lc_ctype 'en_US.UTF-8';

      Make sure that database can be accessed remotely.

      DWH database host [localhost]: 127.0.0.1  
      DWH database port [5432]:   
      DWH database secured connection (Yes, No) [No]: 
      DWH database name [ovirt_engine_history]: ovirt_eh
      DWH database user [ovirt_engine_history]: ovirt
      DWH database password: 
      Where is the Reports database located? (Local, Remote) [Local]: Remote 

      ATTENTION

      Manual action required.
      Please create database for ovirt-engine use. Use the following commands as an example:

      create role ovirt_engine_reports with login encrypted password 'ovirt_engine_reports';
      create database ovirt_engine_reports owner ovirt_engine_reports
       template template0
       encoding 'UTF8' lc_collate 'en_US.UTF-8'
       lc_ctype 'en_US.UTF-8';

      Make sure that database can be accessed remotely.

      Reports database host [localhost]: 127.0.0.1
      Reports database port [5432]: 
      Reports database secured connection (Yes, No) [No]: 
      Reports database name [ovirt_engine_reports]: ovirt_er
      Reports database user [ovirt_engine_reports]: ovirt
      Reports database password: 

      --== OVIRT ENGINE CONFIGURATION ==--

      Application mode (Both, Virt, Gluster) [Both]: 
      Default storage type: (NFS, FC, ISCSI, POSIXFS, GLUSTERFS) [NFS]: 
      Engine admin password: 
      Confirm engine admin password:

[WARNING] Password is weak: it does not contain enough DIFFERENT characters Use weak password? (Yes, No) [No]: Yes

      --== PKI CONFIGURATION ==--

      Organization name for certificate [sky-mobi.com]: 

      --== APACHE CONFIGURATION ==--

      Setup can configure apache to use SSL using a certificate issued from the internal CA.
      Do you wish Setup to configure that, or prefer to perform that manually? (Automatic, Manual) [Automatic]: 
      Setup can configure the default page of the web server to present the application home page. This may conflict with existing applications.
      Do you wish to set the application as the default page of the web server? (Yes, No) [Yes]: No

      --== SYSTEM CONFIGURATION ==--

      Configure WebSocket Proxy on this machine? (Yes, No) [Yes]: No
      Configure an NFS share on this server to be used as an ISO Domain? (Yes, No) [Yes]: No

      --== MISC CONFIGURATION ==--

      Reports power users password: 
      Confirm Reports power users password:

[WARNING] Password is weak: it does not contain enough DIFFERENT characters Use weak password? (Yes, No) [No]: Yes

      --== END OF CONFIGURATION ==--

[ INFO ] Stage: Setup validation

      --== CONFIGURATION PREVIEW ==--

      Engine database name                    : ovirt
      Engine database secured connection      : False
      Engine database host                    : 127.0.0.1
      Engine database user name               : ovirt
      Engine database host name validation    : False
      Engine database port                    : 5432
      PKI organization                        : sky-mobi.com
      Application mode                        : both
      Update Firewall                         : False
      Configure WebSocket Proxy               : False
      Host FQDN                               : 176.sky-mobi.com
      Datacenter storage type                 : nfs
      Configure local Engine database         : False
      Set application as default page         : False
      Configure Apache SSL                    : True
      Upgrade packages                        : True
      DWH installation                        : True
      DWH database name                       : ovirt_eh
      DWH database secured connection         : False
      DWH database host                       : 127.0.0.1
      DWH database user name                  : ovirt
      DWH database host name validation       : False
      DWH database port                       : 5432
      Reports installation                    : True
      Reports database name                   : ovirt_er
      Reports database secured connection     : False
      Reports database host                   : 127.0.0.1
      Reports database user name              : ovirt
      Reports database host name validation   : False
      Reports database port                   : 5432

      Please confirm installation settings (OK, Cancel) [OK]:

[ INFO ] Stage: Transaction setup [ INFO ] Stopping engine service [ INFO ] Stopping websocket-proxy service [ INFO ] Stage: Misc configuration [ INFO ] Stage: Package installation [ INFO ] Yum Status: Downloading Packages [ INFO ] Yum Download/Verify: dom4j-1.6.1-13.jpp6.noarch [ INFO ] Yum Download/Verify: isorelax-0.1-0.20041111.7.jpp6.noarch [ INFO ] Yum Download/Verify: jakarta-commons-collections-3.2.1-3.4.el6.noarch [ INFO ] Yum Download/Verify: java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64 [ INFO ] Yum Download/Verify: 1:java_cup-0.10k-5.el6.x86_64 [ INFO ] Yum Download/Verify: jaxen-1.1.3-1.jpp6.noarch [ INFO ] Yum Download/Verify: jdom-1.1.1-4.jpp6.noarch [ INFO ] Yum Download/Verify: libart_lgpl-2.3.20-5.1.el6.x86_64 [ INFO ] Yum Download/Verify: libgcj-4.4.7-4.el6.x86_64 [ INFO ] Yum Download/Verify: msv-1.2-0.20050722.7.jpp6.noarch [ INFO ] Yum Download/Verify: msv-xsdlib-1.2-0.20050722.7.jpp6.noarch [ INFO ] Yum Download/Verify: ovirt-engine-dwh-3.4.3-1.el6.noarch [ INFO ] Yum Download/Verify: postgresql-jdbc-8.4.701-8.el6.noarch [ INFO ] Yum Download/Verify: relaxngDatatype-1.0-4.jpp6.noarch [ INFO ] Yum Download/Verify: servicemix-specs-1.7.0-5.jpp6.noarch [ INFO ] Yum Download/Verify: sinjdoc-0.5-9.1.el6.x86_64 [ INFO ] Yum Download/Verify: tomcat5-servlet-2.4-api-5.5.35-1.jpp6.noarch [ INFO ] Yum Download/Verify: ws-jaxme-0.5.1-11.jpp6.noarch [ INFO ] Yum Download/Verify: xalan-j2-2.7.1-8.jbossorg_1.jpp6.noarch [ INFO ] Yum Download/Verify: xerces-j2-2.7.1-12.6.el6_0.x86_64 [ INFO ] Yum Download/Verify: xml-commons-1.3.04-10.jpp6.noarch [ INFO ] Yum Download/Verify: xml-commons-apis-1.3.04-3.6.el6.x86_64 [ INFO ] Yum Download/Verify: xml-commons-jaxp-1.2-apis-1.3.04-10.jpp6.noarch [ INFO ] Yum Download/Verify: xml-commons-resolver11-1.3.04-10.jpp6.noarch [ INFO ] Yum Download/Verify: xom-1.2.6-2.jpp6.noarch [ INFO ] Yum Download/Verify: xpp2-2.1.10-7.jpp6.noarch [ INFO ] Yum Download/Verify: xpp3-1.1.4-2.jpp6.noarch [ INFO ] Yum Download/Verify: zip-3.0-1.el6.x86_64 [ INFO ] Yum Status: Check Package Signatures

      Please confirm Confirm use of GPG Key userid=JPackage Project (JPP Official Keys) <jpackage@zarb.org> hexkeyid=C431416D [yes/no]:

yes [ INFO ] Yum Status: Running Test Transaction [ INFO ] Yum Status: Running Transaction [ INFO ] Yum install: 1/28: relaxngDatatype-1.0-4.jpp6.noarch [ INFO ] Yum install: 2/28: servicemix-specs-1.7.0-5.jpp6.noarch [ INFO ] Yum install: 3/28: xml-commons-1.3.04-10.jpp6.noarch [ INFO ] Yum install: 4/28: xml-commons-jaxp-1.2-apis-1.3.04-10.jpp6.noarch [ INFO ] Yum install: 5/28: libart_lgpl-2.3.20-5.1.el6.x86_64 [ INFO ] Yum install: 6/28: tomcat5-servlet-2.4-api-5.5.35-1.jpp6.noarch [ INFO ] Yum install: 7/28: xpp3-1.1.4-2.jpp6.noarch [ INFO ] Yum install: 8/28: zip-3.0-1.el6.x86_64 [ INFO ] Yum install: 9/28: libgcj-4.4.7-4.el6.x86_64 [ INFO ] Yum install: 10/28: java-1.5.0-gcj-1.5.0.0-29.1.el6.x86_64 [ INFO ] Yum install: 11/28: 1:java_cup-0.10k-5.el6.x86_64 [ INFO ] Yum install: 12/28: sinjdoc-0.5-9.1.el6.x86_64 [ INFO ] Yum install: 13/28: xml-commons-apis-1.3.04-3.6.el6.x86_64 [ INFO ] Yum install: 14/28: xml-commons-resolver11-1.3.04-10.jpp6.noarch [ INFO ] Yum install: 15/28: xerces-j2-2.7.1-12.6.el6_0.x86_64 [ INFO ] Yum install: 16/28: xalan-j2-2.7.1-8.jbossorg_1.jpp6.noarch [ INFO ] Yum install: 17/28: isorelax-0.1-0.20041111.7.jpp6.noarch [ INFO ] Yum install: 18/28: msv-1.2-0.20050722.7.jpp6.noarch [ INFO ] Yum install: 19/28: msv-xsdlib-1.2-0.20050722.7.jpp6.noarch [ INFO ] Yum install: 20/28: xom-1.2.6-2.jpp6.noarch [ INFO ] Yum install: 21/28: ws-jaxme-0.5.1-11.jpp6.noarch [ INFO ] Yum install: 22/28: xpp2-2.1.10-7.jpp6.noarch [ INFO ] Yum install: 23/28: jdom-1.1.1-4.jpp6.noarch [ INFO ] Yum install: 24/28: jaxen-1.1.3-1.jpp6.noarch [ INFO ] Yum install: 25/28: dom4j-1.6.1-13.jpp6.noarch [ INFO ] Yum install: 26/28: postgresql-jdbc-8.4.701-8.el6.noarch [ INFO ] Yum install: 27/28: jakarta-commons-collections-3.2.1-3.4.el6.noarch [ INFO ] Yum install: 28/28: ovirt-engine-dwh-3.4.3-1.el6.noarch [ INFO ] Yum Verify: 1/28: msv-xsdlib.noarch 0:1.2-0.20050722.7.jpp6 - u [ INFO ] Yum Verify: 2/28: sinjdoc.x86_64 0:0.5-9.1.el6 - u [ INFO ] Yum Verify: 3/28: xml-commons-jaxp-1.2-apis.noarch 0:1.3.04-10.jpp6 - u [ INFO ] Yum Verify: 4/28: java_cup.x86_64 1:0.10k-5.el6 - u [ INFO ] Yum Verify: 5/28: jakarta-commons-collections.noarch 0:3.2.1-3.4.el6 - u [ INFO ] Yum Verify: 6/28: xml-commons-resolver11.noarch 0:1.3.04-10.jpp6 - u [ INFO ] Yum Verify: 7/28: zip.x86_64 0:3.0-1.el6 - u [ INFO ] Yum Verify: 8/28: postgresql-jdbc.noarch 0:8.4.701-8.el6 - u [ INFO ] Yum Verify: 9/28: ovirt-engine-dwh.noarch 0:3.4.3-1.el6 - u [ INFO ] Yum Verify: 10/28: xerces-j2.x86_64 0:2.7.1-12.6.el6_0 - u [ INFO ] Yum Verify: 11/28: xml-commons.noarch 0:1.3.04-10.jpp6 - u [ INFO ] Yum Verify: 12/28: servicemix-specs.noarch 0:1.7.0-5.jpp6 - u [ INFO ] Yum Verify: 13/28: dom4j.noarch 0:1.6.1-13.jpp6 - u [ INFO ] Yum Verify: 14/28: java-1.5.0-gcj.x86_64 0:1.5.0.0-29.1.el6 - u [ INFO ] Yum Verify: 15/28: msv.noarch 0:1.2-0.20050722.7.jpp6 - u [ INFO ] Yum Verify: 16/28: xpp3.noarch 0:1.1.4-2.jpp6 - u [ INFO ] Yum Verify: 17/28: xom.noarch 0:1.2.6-2.jpp6 - u [ INFO ] Yum Verify: 18/28: tomcat5-servlet-2.4-api.noarch 0:5.5.35-1.jpp6 - u [ INFO ] Yum Verify: 19/28: jaxen.noarch 0:1.1.3-1.jpp6 - u [ INFO ] Yum Verify: 20/28: isorelax.noarch 0:0.1-0.20041111.7.jpp6 - u [ INFO ] Yum Verify: 21/28: xml-commons-apis.x86_64 0:1.3.04-3.6.el6 - u [ INFO ] Yum Verify: 22/28: xpp2.noarch 0:2.1.10-7.jpp6 - u [ INFO ] Yum Verify: 23/28: xalan-j2.noarch 0:2.7.1-8.jbossorg_1.jpp6 - u [ INFO ] Yum Verify: 24/28: relaxngDatatype.noarch 0:1.0-4.jpp6 - u [ INFO ] Yum Verify: 25/28: libgcj.x86_64 0:4.4.7-4.el6 - u [ INFO ] Yum Verify: 26/28: ws-jaxme.noarch 0:0.5.1-11.jpp6 - u [ INFO ] Yum Verify: 27/28: jdom.noarch 0:1.1.1-4.jpp6 - u [ INFO ] Yum Verify: 28/28: libart_lgpl.x86_64 0:2.3.20-5.1.el6 - u [ INFO ] Stage: Misc configuration [ INFO ] Creating Engine database schema [ INFO ] Creating CA [ INFO ] Creating/refreshing DWH database schema [ INFO ] Deploying Jasper [ INFO ] Importing data into Jasper [ INFO ] Configuring Jasper Java resources [ INFO ] Configuring Jasper Database resources [ INFO ] Customizing Jasper [ INFO ] Customizing Jasper metadata [ INFO ] Generating post install configuration file '/etc/ovirt-engine-setup.conf.d/20-setup-ovirt-post.conf' [ INFO ] Stage: Transaction commit [ INFO ] Stage: Closing up

      --== SUMMARY ==--

      SSH fingerprint: 0C:6C:3B:C9:62:22:DF:6C:29:C2:0E:95:17:B5:EC:3E
      Internal CA 54:25:1C:F8:62:50:A3:30:B2:5F:C9:9C:FF:E3:6E:14:02:26:49:38
      Web access is enabled at:
          http://176.sky-mobi.com:80/ovirt-engine
          https://176.sky-mobi.com:443/ovirt-engine
      Please use the user "admin" and password specified in order to login
      In order to configure firewalld, copy the files from
          /etc/ovirt-engine/firewalld to /etc/firewalld/services
          and execute the following commands:
          firewall-cmd -service ovirt-https
          firewall-cmd -service ovirt-http
      The following network ports should be opened:
          tcp:443
          tcp:80
      An example of the required configuration for iptables can be found at:
          /etc/ovirt-engine/iptables.example

      --== END OF SUMMARY ==--

[ INFO ] Starting engine service [ INFO ] Restarting httpd [ INFO ] Starting dwh service [ INFO ] Stage: Clean up Log file is located at /var/log/ovirt-engine/setup/ovirt-engine-setup-20140804113942-mpzka3.log [ INFO ] Generating answer file '/var/lib/ovirt-engine/setup/answers/20140804120034-setup.conf' [ INFO ] Stage: Pre-termination [ INFO ] Stage: Termination [ INFO ] Execution of setup completed successfully

digoal commented 10 years ago

install : yum localinstall -y http://plain.resources.ovirt.org/pub/yum-repo/ovirt-release34.rpm yum install -y ovirt-engine ovirt-engine-reports

digoal commented 10 years ago

When i use public schema, no error. but when use ovirt schema , this error issue.

david-caro commented 8 years ago

If this is still an issue, please create a bug at https://bugzilla.redhat.com/enter_bug.cgi?product=ovirt-engine, as this tracker is not really active. Note that you might want to change the product if it's not correct.