Issue adding a second zone to Cloudstack

2020-03-27 Thread Sean Lair
Hi all,

We are running 4.11.3 with a single zone, that zone is working without issue.  
We are trying to add a second zone to the installation, and everything seems to 
go well, except we are confused on how the SystemVM templates should be handled 
for the new zone.  The new zone has its own secondary storage (NFS).  When 
Cloudstack sees the new Zone, it attempts to provision a Secondary Storage VM.  
However, it is unable to because the SystemVM Template doesn't exist on the new 
secondary storage (NFS).

Are we supposed to pre-populate another copy of the SystemVM Template in the 
additional zone and secondary storage?  Or should cloudstack copy the existing 
SystemVM Template (which is set as cross-zone) to the new zone for us?  Here is 
some detailed information:

MariaDB [cloud]> SELECT id,name,type,cross_zones,state FROM cloud.vm_template 
WHERE name like '%systemvm-kvm%' AND removed IS NULL;
+-+--+-+-+--+
| id  | name | type| cross_zones | state|
+-+--+-+-+--+
| 344 | systemvm-kvm-4.11.3  | SYSTEM  |   1 | Active   |
+-+--+-+-+--+

MariaDB [cloud]> select id,store_id,template_id,install_path, download_state 
from template_store_ref;
+-+--+-+++
| id  | store_id | template_id | install_path   
| download_state |
+-+--+-+++
| 666 |1 | 344 | 
template/tmpl/2/344/182f0a79-1e16-3e53-a6e9-fcffe5f11c3e.qcow2 | 
DOWNLOADED |
| 756 |   16 | 344 | template/tmpl/1/344/   
| DOWNLOADED |
+-+--+-+++

Why in the template_store_ref table did cloudstack add a new row with 
"downloaded" and missing a filename in the "install_path"?


The KVM host cannot mount the template on the new secondary storage, because it 
isn't there yet (should cloudstack be copying that template from the existing 
zone to the new one for us?):
--
2020-03-27 18:51:40,626 ERROR [kvm.storage.LibvirtStorageAdaptor] 
(agentRequest-Handler-2:null) (logid:6b50f03a) Failed to create netfs mount: 
10.102.33.5:/zone2_secondary/template/tmpl/1/344
org.libvirt.LibvirtException: internal error: Child process (/usr/bin/mount 
10.10.33.5:/zone2_secondary/template/tmpl/1/344 
/mnt/b69caab0-4c1e-34b6-94b8-2617ba561e9a -o nodev,nosuid,noexec) unexpected 
exit status 32: mount.nfs: mounting 
10.10.33.5:/zone2__secondary/template/tmpl/1/344 failed, reason given by 
server: No such file or directory
-


Thanks!
Sean


Re: New (to me) issue trying to install management server

2020-03-27 Thread Suresh Kumar Anaparti
Hi Matthew,

What is the timezone set in the management server and in mysql ("SELECT
@@global.time_zone, @@session.time_zone"). The management server is
defaulted to the system timezone. Check if any timezone's set for any users
in user table ("SELECT timezone FROM cloud.user") in the management server.
Also, ensure to populate the time zone info in mysql if not done.

Please share the full stack trace to see the extract point of failure.

Thanks,
Suresh

On Fri, Mar 27, 2020 at 1:07 AM Matthew Smart 
wrote:

> Hey everyone,
>
> So, the server acting as my management server (including the database)
> crashed hard and I am trying to spin up a new one restoring from
> backups. Everything has seemed to go smoothly but now I am getting the
> following error:
>
> InvalidConnectionAttributeException: The server time zone value 'CDT' is
> unrecognized or represents more than one time zone.
>
> My new server is identical to the old one (Cent 7. Mariadb 5.5.64.
> Identical hardware) and in all of my work with jdbc and mysql I have
> never seen this error. I have googled and see that I can fix it by
> adding a timezone entry in my.cnf but I was wondering if this issue is
> indicative of a problem with my restoration of the management server.
>
> So, is there a timezone setting somewhere in cloudstack management that
> I missed? Has anyone else hit this error before? I can provide the full
> stack trace if it is helpful.
>
> Thanks,
>
>
> --
> Matthew Smart
> President
> Smart Software Solutions Inc.
> 108 S Pierre St.
> Pierre, SD 57501
>
> Phone: (605) 280-0383
> Skype: msmart13
> Email: msm...@smartsoftwareinc.com
>
>