Excellent, glad you both got it sorted. Regards, Dag Sonstebo Cloud Architect ShapeBlue
On 02/04/2018, 00:00, "Olivier GUIN" <[email protected]> wrote: Hi Dag, Ok it's ok with 5.5.56. and new fresh install CentOS 7 I install CS 4.10 to work fine with hostbill not 4.11 .. another problem ! I ok now Thank's for all Olivier Le 31/03/2018 à 16:15, Lotic Lists a écrit : > Hi Dag. > > > > You are right, the problem is the mysql version, with 5.5.56 works fine > > > > Thanks > > Marcelo. > > > > From: Dag Sonstebo <[email protected]> > Sent: quarta-feira, 28 de março de 2018 16:10 > To: [email protected] > Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance ! > > > > Hi Olivier, > > > > I’ve just spun the same environment as you have up in the lab, using CentOS7 management, XS6.5SP1 hypervisors, advanced zone and installing from http://cloudstack.apt-get.eu/centos/7/4.11/ , and I can’t reproduce the issues you are seeing. > > The only difference in my environment is the MariaDB version – and I suspect this may be your problem. > > > > [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/yum.repos.d/cloudstack.repo | grep http > > baseurl=http://cloudstack.apt-get.eu/centos/7/4.11/ > > > > [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# cat /etc/redhat-release > > CentOS Linux release 7.4.1708 (Core) > > > > [root@ref-trl-418-x-cs411-dsonstebo-mgmt1 ~]# mysql --version > > mysql Ver 15.1 Distrib 5.5.56-MariaDB, for Linux (x86_64) using readline 5.1 <<<< My lab version > > mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using readline 5.1 <<<<<< Your version > > > >> SELECT * FROM cloud.version > > > + ------- + ------------ + ------------ + --------- + > > | id | version | updated | step | > > + ------- + ------------ + ------------ + --------- + > > | 1 | 4.0.0 | 2018-03-28 18:44:26 | Complete | > > | 2 | 4.1.0 | 2018-03-28 18:44:49 | Complete | > > ….. > > | 21 | 4.9.3.0 | 2018-03-28 18:45:02 | Complete | > > | 22 | 4.10.0.0 | 2018-03-28 18:45:03 | Complete | > > | 23 | 4.11.0.0 | 2018-03-28 18:45:03 | Complete | > > > >> SELECT * FROM cloud.host_view > > > ******************** 1. row ********************* > > id: 1 > > uuid: df4cbefc-3dc1-4f41-ac7e-723920808114 > > name: ref-trl-418-x-cs411-dsonstebo-xs1 > > status: Up > > disconnected: > > type: Routing > > private_ip_address: removed > > version: 4.11.0.0 > > hypervisor_type: XenServer > > hypervisor_version: 6.5.0 > > 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 > > last_ping: 1486584835 > > created: 2018-03-28 18:52:06 > > removed: > > resource_state: Enabled > > mgmt_server_id: 7393350059856 > > cpu_sockets: 3 > > cpus: 3 > > speed: 1994 > > ram: 7427139712 > > cluster_id: 1 > > cluster_uuid: 30cb6537-8d6e-4a42-965c-b50c30262a55 > > cluster_name: p1-c1 > > cluster_type: CloudManaged > > data_center_id: 1 > > data_center_uuid: 407346a2-4ee3-4fa2-b17f-37f1fa1150df > > data_center_name: ref-trl-418-x-cs411-dsonstebo > > data_center_type: Advanced > > pod_id: 1 > > pod_uuid: 68481e39-9427-486f-a983-71b36737fae4 > > pod_name: Pod1 > > tag: GPU > > guest_os_category_id: > > guest_os_category_uuid: > > guest_os_category_name: > > memory_used_capacity: 536870912 > > memory_reserved_capacity: 0 > > cpu_used_capacity: 500 > > cpu_reserved_capacity: 0 > > job_id: > > job_uuid: > > job_status: > > job_account_id: > > oobm_enabled: > > oobm_power_state: > > ha_enabled: > > ha_state: > > ha_provider: > > annotation: > > last_annotated: > > username: > > ******************** 2. row ********************* > > > > > > Regards, > > Dag Sonstebo > > Cloud Architect > > ShapeBlue > > > > [email protected] <mailto:[email protected]> > www.shapeblue.com <http://www.shapeblue.com> > @shapeblue > > > > > From: Olivier GUIN <[email protected] <mailto:[email protected]> > > Reply-To: "[email protected] <mailto:[email protected]> " <[email protected] <mailto:[email protected]> >, "[email protected] <mailto:[email protected]> " <[email protected] <mailto:[email protected]> > > Date: Wednesday, 28 March 2018 at 15:35 > To: "[email protected] <mailto:[email protected]> " <[email protected] <mailto:[email protected]> > > Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance ! > > > > Hi, > > It's new install, CS 4.11 on CentOS7, I've mariadb cluster > > I use my script https://cloudbox.wayscom.com/index.php/s/FHCwWt35fGZk0gD > > [root@crtl-1 opt]# mysql --version > mysql Ver 15.1 Distrib 10.0.34-MariaDB, for Linux (x86_64) using readline 5.1 > [root@crtl-1 opt]# cat /etc/redhat-release > CentOS Linux release 7.4.1708 (Core) > > My cloudstack.repo : > [cloudstack] > name=cloudstack > baseurl=http://cloudstack.apt-get.eu/centos/$releasever/4.11/ > enabled=1 > gpgcheck=0 > > For the query, returns nothing ! also with cloudstack-management restart ... > I deleted the view and restart the request the view is well created but still nothing in it! > > Regards, > Olivier > > Le 28/03/2018 à 11:08, Dag Sonstebo a écrit : > > Olivier / all, > > > > The view looks odd – can you give us some background – is this a new installation + what repo did you use? > > > > Checking an installation from our own repo I have the following – can you run the query and see if this returns anything? > > > > CREATE > > ALGORITHM = UNDEFINED > > DEFINER = `cloud`@`%` > > SQL SECURITY DEFINER > > VIEW `cloud`.`host_view` AS > > SELECT > > `cloud`.`host`.`id` AS `id`, > > `cloud`.`host`.`uuid` AS `uuid`, > > `cloud`.`host`.`name` AS `name`, > > `cloud`.`host`.`status` AS `status`, > > `cloud`.`host`.`disconnected` AS `disconnected`, > > `cloud`.`host`.`type` AS `type`, > > `cloud`.`host`.`private_ip_address` AS `private_ip_address`, > > `cloud`.`host`.`version` AS `version`, > > `cloud`.`host`.`hypervisor_type` AS `hypervisor_type`, > > `cloud`.`host`.`hypervisor_version` AS `hypervisor_version`, > > `cloud`.`host`.`capabilities` AS `capabilities`, > > `cloud`.`host`.`last_ping` AS `last_ping`, > > `cloud`.`host`.`created` AS `created`, > > `cloud`.`host`.`removed` AS `removed`, > > `cloud`.`host`.`resource_state` AS `resource_state`, > > `cloud`.`host`.`mgmt_server_id` AS `mgmt_server_id`, > > `cloud`.`host`.`cpu_sockets` AS `cpu_sockets`, > > `cloud`.`host`.`cpus` AS `cpus`, > > `cloud`.`host`.`speed` AS `speed`, > > `cloud`.`host`.`ram` AS `ram`, > > `cloud`.`cluster`.`id` AS `cluster_id`, > > `cloud`.`cluster`.`uuid` AS `cluster_uuid`, > > `cloud`.`cluster`.`name` AS `cluster_name`, > > `cloud`.`cluster`.`cluster_type` AS `cluster_type`, > > `cloud`.`data_center`.`id` AS `data_center_id`, > > `cloud`.`data_center`.`uuid` AS `data_center_uuid`, > > `cloud`.`data_center`.`name` AS `data_center_name`, > > `cloud`.`data_center`.`networktype` AS `data_center_type`, > > `cloud`.`host_pod_ref`.`id` AS `pod_id`, > > `cloud`.`host_pod_ref`.`uuid` AS `pod_uuid`, > > `cloud`.`host_pod_ref`.`name` AS `pod_name`, > > `cloud`.`host_tags`.`tag` AS `tag`, > > `cloud`.`guest_os_category`.`id` AS `guest_os_category_id`, > > `cloud`.`guest_os_category`.`uuid` AS `guest_os_category_uuid`, > > `cloud`.`guest_os_category`.`name` AS `guest_os_category_name`, > > `mem_caps`.`used_capacity` AS `memory_used_capacity`, > > `mem_caps`.`reserved_capacity` AS `memory_reserved_capacity`, > > `cpu_caps`.`used_capacity` AS `cpu_used_capacity`, > > `cpu_caps`.`reserved_capacity` AS `cpu_reserved_capacity`, > > `cloud`.`async_job`.`id` AS `job_id`, > > `cloud`.`async_job`.`uuid` AS `job_uuid`, > > `cloud`.`async_job`.`job_status` AS `job_status`, > > `cloud`.`async_job`.`account_id` AS `job_account_id`, > > `cloud`.`oobm`.`enabled` AS `oobm_enabled`, > > `cloud`.`oobm`.`power_state` AS `oobm_power_state`, > > `cloud`.`ha_config`.`enabled` AS `ha_enabled`, > > `cloud`.`ha_config`.`ha_state` AS `ha_state`, > > `cloud`.`ha_config`.`provider` AS `ha_provider`, > > `last_annotation_view`.`annotation` AS `annotation`, > > `last_annotation_view`.`created` AS `last_annotated`, > > `cloud`.`user`.`username` AS `username` > > FROM > > (((((((((((((`cloud`.`host` > > LEFT JOIN `cloud`.`cluster` ON ((`cloud`.`host`.`cluster_id` = `cloud`.`cluster`.`id`))) > > LEFT JOIN `cloud`.`data_center` ON ((`cloud`.`host`.`data_center_id` = `cloud`.`data_center`.`id`))) > > LEFT JOIN `cloud`.`host_pod_ref` ON ((`cloud`.`host`.`pod_id` = `cloud`.`host_pod_ref`.`id`))) > > LEFT JOIN `cloud`.`host_details` ON (((`cloud`.`host`.`id` = `cloud`.`host_details`.`host_id`) > > AND (`cloud`.`host_details`.`name` = 'guest.os.category.id')))) > > LEFT JOIN `cloud`.`guest_os_category` ON ((`cloud`.`guest_os_category`.`id` = CAST(`cloud`.`host_details`.`value` AS UNSIGNED)))) > > LEFT JOIN `cloud`.`host_tags` ON ((`cloud`.`host_tags`.`host_id` = `cloud`.`host`.`id`))) > > LEFT JOIN `cloud`.`op_host_capacity` `mem_caps` ON (((`cloud`.`host`.`id` = `mem_caps`.`host_id`) > > AND (`mem_caps`.`capacity_type` = 0)))) > > LEFT JOIN `cloud`.`op_host_capacity` `cpu_caps` ON (((`cloud`.`host`.`id` = `cpu_caps`.`host_id`) > > AND (`cpu_caps`.`capacity_type` = 1)))) > > LEFT JOIN `cloud`.`async_job` ON (((`cloud`.`async_job`.`instance_id` = `cloud`.`host`.`id`) > > AND (`cloud`.`async_job`.`instance_type` = 'Host') > > AND (`cloud`.`async_job`.`job_status` = 0)))) > > LEFT JOIN `cloud`.`oobm` ON ((`cloud`.`oobm`.`host_id` = `cloud`.`host`.`id`))) > > LEFT JOIN `cloud`.`ha_config` ON (((`cloud`.`ha_config`.`resource_id` = `cloud`.`host`.`id`) > > AND (`cloud`.`ha_config`.`resource_type` = 'Host')))) > > LEFT JOIN `cloud`.`last_annotation_view` ON ((`last_annotation_view`.`entity_uuid` = `cloud`.`host`.`uuid`))) > > LEFT JOIN `cloud`.`user` ON ((`cloud`.`user`.`uuid` = `last_annotation_view`.`user_uuid`))) > > > > Regards, > > Dag Sonstebo > > Cloud Architect > > ShapeBlue > > > > <mailto:[email protected]> [email protected] > <http://www.shapeblue.com> www.shapeblue.com > @shapeblue > > > > > From: Olivier GUIN <mailto:[email protected]> <[email protected]> > Reply-To: <mailto:[email protected]> "[email protected]" <mailto:[email protected]> <[email protected]>, <mailto:[email protected]> "[email protected]" <mailto:[email protected]> <[email protected]> > Date: Wednesday, 28 March 2018 at 14:44 > To: <mailto:[email protected]> "[email protected]" <mailto:[email protected]> <[email protected]> > Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance ! > > > > Hi, > CS 411 (Centos7) fresh install advanced zone, xen65 > > No solution ? > Look this link : https://cloudbox.wayscom.com/index.php/s/B6dET2yUxYYf8ac > > It's a video to show this problem ! > > Regards, > Olivier > > Le 28/03/2018 à 09:06, Lotic Lists a écrit : > > Same error when creating new advanced zone on fresh install, stage “Adding Hosts” > > > > Regards > > Lotic > > > > From: Daznis <mailto:[email protected]> <[email protected]> > Sent: quarta-feira, 28 de março de 2018 06:50 > To: [email protected] <mailto:[email protected]> ; [email protected] <mailto:[email protected]> > Subject: Re: CS 4.11 : Erreor : status Index: 0, Size: 0 When Migrate instance ! > > > > Hi, > > > > > > I have reported the same error a while back. I just stopped at host view having no hosts displayed. > > > > > > > [email protected] www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue > On Tue, Mar 27, 2018 at 6:45 PM, Olivier GUIN <[email protected] > <mailto:[email protected]> <mailto:[email protected]> > <mailto:[email protected]> > wrote: > > Hi, > > Only this table host_view is empty : > > I saw : > (`host_details`.`name` = 'guest.os.category.id <http://guest.os.category.id> <http://guest.os.category.id> ') It's strange no correspondance ! > > //------------------- > select `host`.`id` AS `id`,`host`.`uuid` AS `uuid`,`host`.`name` AS `name`,`host`.`status` AS `status`,`host`.`disconnected` AS `disconnected`,`host`.`type` AS `type`,`host`.`private_ip_address` AS `private_ip_address`,`host`.`version` AS `version`,`host`.`hypervisor_type` AS `hypervisor_type`,`host`.`hypervisor_version` AS `hypervisor_version`,`host`.`capabilities` AS `capabilities`,`host`.`last_ping` AS `last_ping`,`host`.`created` AS `created`,`host`.`removed` AS `removed`,`host`.`resource_state` AS `resource_state`,`host`.`mgmt_server_id` AS `mgmt_server_id`,`host`.`cpu_sockets` AS `cpu_sockets`,`host`.`cpus` AS `cpus`,`host`.`speed` AS `speed`,`host`.`ram` AS `ram`,`cluster`.`id` AS `cluster_id`,`cluster`.`uuid` AS `cluster_uuid`,`cluster`.`name` AS `cluster_name`,`cluster`.`cluster_type` AS `cluster_type`,`data_center`.`id` AS `data_center_id`,`data_center`.`uuid` AS `data_center_uuid`,`data_center`.`name` AS `data_center_name`,`data_center`.`networktype` AS `data_center_type`,`host_pod_ref`.`id` AS `pod_id`,`host_pod_ref`.`uuid` AS `pod_uuid`,`host_pod_ref`.`name` AS `pod_name`,`host_tags`.`tag` AS `tag`,`guest_os_category`.`id` AS `guest_os_category_id`,`guest_os_category`.`uuid` AS `guest_os_category_uuid`,`guest_os_category`.`name` AS `guest_os_category_name`,`mem_caps`.`used_capacity` AS `memory_used_capacity`,`mem_caps`.`reserved_capacity` AS `memory_reserved_capacity`,`cpu_caps`.`used_capacity` AS `cpu_used_capacity`,`cpu_caps`.`reserved_capacity` AS `cpu_reserved_capacity`,`async_job`.`id` AS `job_id`,`async_job`.`uuid` AS `job_uuid`,`async_job`.`job_status` AS `job_status`,`async_job`.`account_id` AS `job_account_id`,`oobm`.`enabled` AS `oobm_enabled`,`oobm`.`power_state` AS `oobm_power_state`,`ha_config`.`enabled` AS `ha_enabled`,`ha_config`.`ha_state` AS `ha_state`,`ha_config`.`provider` AS `ha_provider`,`last_annotation_view`.`annotation` AS `annotation`,`last_annotation_view`.`created` AS `last_annotated`,`user`.`username` AS `username` from (((((((((((((`host` left join `cluster` on((`host`.`cluster_id` = `cluster`.`id`))) left join `data_center` on((`host`.`data_center_id` = `data_center`.`id`))) left join `host_pod_ref` on((`host`.`pod_id` = `host_pod_ref`.`id`))) left join `host_details` on(((`host`.`id` = `host_details`.`host_id`) and (`host_details`.`name` = 'guest.os.category.id <http://guest.os.category.id> <http://guest.os.category.id> ')))) left join `guest_os_category` on((`guest_os_category`.`id` = cast(`host_details`.`value` as unsigned)))) left join `host_tags` on((`host_tags`.`host_id` = `host`.`id`))) left join `op_host_capacity` `mem_caps` on(((`host`.`id` = `mem_caps`.`host_id`) and (`mem_caps`.`capacity_type` = 0)))) left join `op_host_capacity` `cpu_caps` on(((`host`.`id` = `cpu_caps`.`host_id`) and (`cpu_caps`.`capacity_type` = 1)))) left join `async_job` on(((`async_job`.`instance_id` = `host`.`id`) and (`async_job`.`instance_type` = 'Host') and (`async_job`.`job_status` = 0)))) left join `oobm` on((`oobm`.`host_id` = `host`.`id`))) left join `ha_config` on(((`ha_config`.`resource_id` = `host`.`id`) and (`ha_config`.`resource_type` = 'Host')))) left join `last_annotation_view` on((`last_annotation_view`.`entity_uuid` = `host`.`uuid`))) left join `user` on((`user`.`uuid` = `last_annotation_view`.`user_uuid`))) > //----------------------- > > Regards, > Olivier > > > > Le 27/03/2018 à 11:32, Dag Sonstebo a écrit : > > Hi Olivier, > > Have your views populated at all? Can you give us the output of the following mysql query: > > show full tables in cloud where table_type like 'VIEW'; > > > Regards, > Dag Sonstebo > Cloud Architect > ShapeBlue > > On 27/03/2018, 15:06, "Olivier GUIN" <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> <[email protected]> wrote: > > Hello, > I have multiple display issues with my new installation of Cloudstack 4.11. > I can not display the list of hosts! nor their processors! > I can not display the list of systemvms (the cursor searches in a loop!) > > And when I want to migrate an instance on a new hosts I have the error > below: > Index 0, Size 0 > Probably because I have no record in the table. (host_view) > And I have this error message: > / WARN: Received unknown parameters for command listHosts. Unknown > parameters: listall / > And display systemvm: > / WARN: Received unknown parameters for command listSystemVms. Unknown > parameters: listall / > > http://ibb.co/kPWWN7 > > http://ibb.co/mrC2vS > > Can you help me ! > > Regards, > > Olivier GUIN > > > -- > Olivier GUIN > > Mail : [email protected] <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> > > > > > [email protected] <mailto:[email protected]> <mailto:[email protected]> <mailto:[email protected]> > www.shapeblue.com <http://www.shapeblue.com> <http://www.shapeblue.com> <http://www.shapeblue.com> > 53 Chandos Place, Covent Garden, London WC2N <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g> <https://maps.google.com/?q=53+Chandos+Place,+Covent+Garden,+London++WC2N&entry=gmail&source=g> 4HSUK > @shapeblue > > > > > >
