OSDir


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: CS 4.11 : Error display fresh install


Hi Olivier,


Can you ensure that host_view is created? If not run the CREATE view from here:

https://github.com/apache/cloudstack/blob/4.11/engine/schema/resources/META-INF/db/schema-41000to41100.sql#L158

After that please report if you're able to see any hosts?


Can you share details of your management server host (distro, version etc) and if you performed any in-place upgrade? Also share output of:

find /usr/share/cloudstack-management/ | grep schema



- Rohit



rohit.yadav@xxxxxxxxxxxxx 
www.shapeblue.com

@shapeblue

  

  


From: Olivier GUIN <olivier.guin@xxxxxxxxxxxx>
Sent: Monday, March 26, 2018 4:01:09 PM
To: users@xxxxxxxxxxxxxxxxxxxxx
Subject: Re: CS 4.11 : Error display fresh install
 
Hi Rohit,

Answers is blue !
My host_view is empty !

Regards,
Olivier

Le 26/03/2018 à 04:05, Rohit Yadav a écrit :
Olivier,


Can you share the sql outputs of:


use cloud;

select * from version;
MariaDB [cloud]> select * from version;
+----+----------+---------------------+----------+
| id | version  | updated             | step     |
+----+----------+---------------------+----------+
|  4 | 4.0.0    | 2018-03-24 10:50:03 | Complete |
|  6 | 4.1.0    | 2018-03-24 13:52:43 | Complete |
|  8 | 4.2.0    | 2018-03-24 13:54:04 | Complete |
| 10 | 4.2.1    | 2018-03-24 13:54:04 | Complete |
| 12 | 4.3.0    | 2018-03-24 13:54:38 | Complete |
| 14 | 4.4.0    | 2018-03-24 13:57:10 | Complete |
| 16 | 4.4.1    | 2018-03-24 13:57:11 | Complete |
| 18 | 4.4.2    | 2018-03-24 13:57:11 | Complete |
| 20 | 4.5.0    | 2018-03-24 13:57:19 | Complete |
| 22 | 4.5.1    | 2018-03-24 13:57:19 | Complete |
| 24 | 4.5.2    | 2018-03-24 13:57:19 | Complete |
| 26 | 4.6.0    | 2018-03-24 13:57:21 | Complete |
| 28 | 4.6.1    | 2018-03-24 13:57:21 | Complete |
| 30 | 4.7.0    | 2018-03-24 13:57:24 | Complete |
| 32 | 4.7.1    | 2018-03-24 13:57:24 | Complete |
| 34 | 4.8.0    | 2018-03-24 13:57:25 | Complete |
| 36 | 4.8.1    | 2018-03-24 13:57:25 | Complete |
| 38 | 4.9.0    | 2018-03-24 13:57:27 | Complete |
| 42 | 4.9.1.0  | 2018-03-24 13:57:29 | Complete |
| 44 | 4.9.2.0  | 2018-03-24 13:57:29 | Complete |
| 46 | 4.9.3.0  | 2018-03-24 13:57:29 | Complete |
| 48 | 4.10.0.0 | 2018-03-24 13:57:38 | Complete |
| 50 | 4.11.0.0 | 2018-03-24 13:57:46 | Complete |
+----+----------+---------------------+----------+
23 rows in set (0.00 sec)


select * from host\G;
MariaDB [cloud]> select * from host\G;
*************************** 1. row ***************************
                   id: 4
                 name: cc-1.wayscom.com
                 uuid: 8b94bdb7-ac5d-4fa2-81be-df1869248e7c
               status: Up
                 type: Routing
   private_ip_address: 172.16.11.11
      private_netmask: 255.255.255.0
  private_mac_address: e4:1f:13:b9:cc:5c
   storage_ip_address: 172.16.6.11
      storage_netmask: 255.255.255.0
  storage_mac_address: fe:ff:ff:ff:ff:ff
 storage_ip_address_2: NULL
storage_mac_address_2: NULL
    storage_netmask_2: NULL
           cluster_id: 4
    public_ip_address: 172.16.11.11
       public_netmask: 255.255.255.0
   public_mac_address: e4:1f:13:b9:cc:5c
           proxy_port: NULL
       data_center_id: 4
               pod_id: 4
          cpu_sockets: 2
                 cpus: 16
                speed: 2400
                  url: iqn.2016-12.com.example:09bd3e90
              fs_type: NULL
      hypervisor_type: XenServer
   hypervisor_version: 6.5.0
                  ram: 62269760512
             resource: com.cloud.hypervisor.xenserver.resource.XenServer650Resource
              version: 4.11.0.0
               parent: NULL
           total_size: NULL
         capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
                 guid: b2bdaefb-f347-43f9-af9f-d5c2cf561c9c
            available: 1
                setup: 1
          dom0_memory: 0
            last_ping: 1486231189
       mgmt_server_id: 52228986878
         disconnected: NULL
              created: 2018-03-24 14:16:33
              removed: NULL
         update_count: 2
       resource_state: Enabled
                owner: NULL
          lastUpdated: NULL
         engine_state: Disabled
*************************** 2. row ***************************
                   id: 8
                 name: v-1-VM
                 uuid: 8f92a79b-31cf-426a-846d-5fc16ee3862d
               status: Up
                 type: ConsoleProxy
   private_ip_address: 172.16.11.189
      private_netmask: 255.255.255.0
  private_mac_address: 1e:00:1b:00:00:28
   storage_ip_address: 172.16.11.189
      storage_netmask: 255.255.255.0
  storage_mac_address: 1e:00:1b:00:00:28
 storage_ip_address_2: NULL
storage_mac_address_2: NULL
    storage_netmask_2: NULL
           cluster_id: NULL
    public_ip_address: 200.13.142.250
       public_netmask: 255.255.255.0
   public_mac_address: 1e:00:31:00:01:5f
           proxy_port: NULL
       data_center_id: 4
               pod_id: 4
          cpu_sockets: NULL
                 cpus: NULL
                speed: NULL
                  url: NoIqn
              fs_type: NULL
      hypervisor_type: NULL
   hypervisor_version: NULL
                  ram: 0
             resource: NULL
              version: 4.11.0.0
               parent: NULL
           total_size: NULL
         capabilities: NULL
                 guid: Proxy.1-ConsoleProxyResource
            available: 1
                setup: 0
          dom0_memory: 0
            last_ping: 1486251184
       mgmt_server_id: 52228986878
         disconnected: NULL
              created: 2018-03-24 19:53:26
              removed: NULL
         update_count: 4
       resource_state: Enabled
                owner: NULL
          lastUpdated: NULL
         engine_state: Disabled
*************************** 3. row ***************************
                   id: 10
                 name: s-2-VM
                 uuid: cb300873-edd5-4e9b-96c8-0c4ea9d5d98b
               status: Up
                 type: SecondaryStorageVM
   private_ip_address: 172.16.11.247
      private_netmask: 255.255.255.0
  private_mac_address: 1e:00:eb:00:00:62
   storage_ip_address: 172.16.11.247
      storage_netmask: 255.255.255.0
  storage_mac_address: 1e:00:eb:00:00:62
 storage_ip_address_2: NULL
storage_mac_address_2: NULL
    storage_netmask_2: NULL
           cluster_id: NULL
    public_ip_address: 200.13.142.249
       public_netmask: 255.255.255.0
   public_mac_address: 1e:00:6c:00:01:5e
           proxy_port: NULL
       data_center_id: 4
               pod_id: 4
          cpu_sockets: NULL
                 cpus: NULL
                speed: NULL
                  url: NoIqn
              fs_type: NULL
      hypervisor_type: NULL
   hypervisor_version: NULL
                  ram: 0
             resource: NULL
              version: 4.11.0.0
               parent: NULL
           total_size: NULL
         capabilities: NULL
                 guid: s-2-VM-NfsSecondaryStorageResource
            available: 1
                setup: 0
          dom0_memory: 0
            last_ping: 1486251184
       mgmt_server_id: 52228986878
         disconnected: NULL
              created: 2018-03-24 19:53:26
              removed: NULL
         update_count: 5
       resource_state: Enabled
                owner: NULL
          lastUpdated: NULL
         engine_state: Disabled
*************************** 4. row ***************************
                   id: 12
                 name: cc-2.wayscom.com
                 uuid: 7eb627cb-6902-48ea-bf26-2da9d1dc2c62
               status: Up
                 type: Routing
   private_ip_address: 172.16.11.12
      private_netmask: 255.255.255.0
  private_mac_address: e4:1f:13:65:b8:6c
   storage_ip_address: 172.16.6.12
      storage_netmask: 255.255.255.0
  storage_mac_address: fe:ff:ff:ff:ff:ff
 storage_ip_address_2: NULL
storage_mac_address_2: NULL
    storage_netmask_2: NULL
           cluster_id: 4
    public_ip_address: 172.16.11.12
       public_netmask: 255.255.255.0
   public_mac_address: e4:1f:13:65:b8:6c
           proxy_port: NULL
       data_center_id: 4
               pod_id: 4
          cpu_sockets: 2
                 cpus: 16
                speed: 2400
                  url: iqn.2016-12.com.example:ed240080
              fs_type: NULL
      hypervisor_type: XenServer
   hypervisor_version: 6.5.0
                  ram: 62269760512
             resource: com.cloud.hypervisor.xenserver.resource.XenServer650Resource
              version: 4.11.0.0
               parent: NULL
           total_size: NULL
         capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
                 guid: 0742b01b-6d3d-45e0-9e04-f0a745423cb7
            available: 1
                setup: 1
          dom0_memory: 0
            last_ping: 1486251408
       mgmt_server_id: 52228986878
         disconnected: NULL
              created: 2018-03-24 20:01:39
              removed: NULL
         update_count: 2
       resource_state: Enabled
                owner: NULL
          lastUpdated: NULL
         engine_state: Disabled
*************************** 5. row ***************************
                   id: 14
                 name: cc-3.wayscom.com
                 uuid: 5f535608-00c6-463f-8d81-f4a1acc0b9ef
               status: Up
                 type: Routing
   private_ip_address: 172.16.11.13
      private_netmask: 255.255.255.0
  private_mac_address: e4:1f:13:b9:c5:5c
   storage_ip_address: 172.16.6.13
      storage_netmask: 255.255.255.0
  storage_mac_address: fe:ff:ff:ff:ff:ff
 storage_ip_address_2: NULL
storage_mac_address_2: NULL
    storage_netmask_2: NULL
           cluster_id: 4
    public_ip_address: 172.16.11.13
       public_netmask: 255.255.255.0
   public_mac_address: e4:1f:13:b9:c5:5c
           proxy_port: NULL
       data_center_id: 4
               pod_id: 4
          cpu_sockets: 2
                 cpus: 16
                speed: 2400
                  url: iqn.2016-12.com.example:82e5ed47
              fs_type: NULL
      hypervisor_type: XenServer
   hypervisor_version: 6.5.0
                  ram: 62269760512
             resource: com.cloud.hypervisor.xenserver.resource.XenServer650Resource
              version: 4.11.0.0
               parent: NULL
           total_size: NULL
         capabilities: xen-3.0-x86_64 , xen-3.0-x86_32p , hvm-3.0-x86_32 , hvm-3.0-x86_32p , hvm-3.0-x86_64
                 guid: 02366d72-c176-4d7e-bd25-b047c50befab
            available: 1
                setup: 1
          dom0_memory: 0
            last_ping: 1486252482
       mgmt_server_id: 52228986878
         disconnected: NULL
              created: 2018-03-24 20:19:58
              removed: NULL
         update_count: 2
       resource_state: Enabled
                owner: NULL
          lastUpdated: NULL
         engine_state: Disabled
5 rows in set (0.00 sec)

ERROR: No query specified

select * from host_view\G;
MariaDB [cloud]> select * from host_view\G;
Empty set (0.00 sec)

ERROR: No query specified


- Rohit

<https://cloudstack.apache.org>



________________________________
From: Olivier GUIN <olivier.guin@xxxxxxxxxxxx>
Sent: Sunday, March 25, 2018 7:21:42 PM
To: users@xxxxxxxxxxxxxxxxxxxxx; Rohit Yadav
Subject: Re: CS 4.11 : Error display fresh install


Hi,

If I use cloudmonkey command :
list systemvms    it's ok I list system vms but nothing in the screen ( https://ibb.co/mRgjn7 )

2018-03-25 10:47:54,780 WARN  [c.c.a.d.ParamGenericValidationWorker] (qtp1796488937-12:ctx-d2edf121 ctx-affc5cb7) (logid:72647810) Received unknown parameters for command listSystemVms. Unknown parameters : listall


list hosts it no ok  ( http://ibb.co/bzgpLS and http://ibb.co/gio5S7 )

2018-03-25 10:46:15,507 WARN  [c.c.a.d.ParamGenericValidationWorker] (qtp1796488937-12:ctx-e85184d6 ctx-94259fe4) (logid:2ddeeb7a) Received unknown parameters for command listHosts. Unknown parameters : listall

Olivier


Le 22/03/2018 à 03:32, Rohit Yadav a écrit :

Hi Olivier,


Can you try listing hosts using a CLI, such as cloudmonkey and see if it returns anything? (try with listall=true option in the cli).


When you go to 'hosts' page in the UI, with chrome/firefox devtools option what URL is being requested and does it return anything in the response?


- Rohit

<https://cloudstack.apache.org><https://cloudstack.apache.org>



________________________________
From: Olivier GUIN <olivier.guin@xxxxxxxxxxxx><mailto:olivier.guin@xxxxxxxxxxxx>
Sent: Thursday, March 22, 2018 3:16:44 AM
To: users@xxxxxxxxxxxxxxxxxxxxx<mailto:users@xxxxxxxxxxxxxxxxxxxxx>
Subject: CS 4.11 : Error display fresh install

Hello,

I juste install fresh CS 4.11

Manager CentOS 7
Cloudstack 4.11 from repo
Host Xen 6.5
Secondary and primary are under nfs for the moment

when I display 'Infrastructure' I have 3 Hosts, 2  SystemVMs 0 Virtual
Routers

But When I go to Hosts I have only this message : 'No data to show'
But When I go to System VMs I have nothing only 'sablier' !

Do you know this problem?
Best regards,
Olivier

rohit.yadav@xxxxxxxxxxxxx<mailto:rohit.yadav@xxxxxxxxxxxxx>
www.shapeblue.com<http://www.shapeblue.com>
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue






rohit.yadav@xxxxxxxxxxxxx 
www.shapeblue.com
53 Chandos Place, Covent Garden, London  WC2N 4HSUK
@shapeblue
  
 



--

--

ARI
AS Informatique
Olivier GUIN
Direction
Tel. :   05 94 31 02 44
Fax :   09 76 41 08 39
Mail :  olivier.guin@xxxxxxxxxxxx
Site :  www.ariasnet.com