Upgrade 4.16.1 to 4.17 fails on db schema

[Matheus Fontes]

Hi,
We are trying to upgrade 4.16.1 to 4.17 but it fails on db schema upgrade.
When script tries to create procedure it fails.

DROP PROCEDURE IF EXISTS `cloud`.`ADD_GUEST_OS_AND_HYPERVISOR_MAPPING`;
CREATE PROCEDURE `cloud`.`ADD_GUEST_OS_AND_HYPERVISOR_MAPPING` (
IN guest_os_category_id bigint(20) unsigned,
IN guest_os_display_name VARCHAR(255),
IN guest_os_hypervisor_hypervisor_type VARCHAR(32),
IN guest_os_hypervisor_hypervisor_version VARCHAR(32),
IN guest_os_hypervisor_guest_os_name VARCHAR(255)
)
BEGIN
INSERT  INTO cloud.guest_os (uuid, category_id, display_name, created)
SELECT  UUID(), guest_os_category_id, guest_os_display_name, now()
FROMDUAL
WHERE   not exists( SELECT  1
 FROMcloud.guest_os
 WHERE   cloud.guest_os.category_id = guest_os_category_id
   AND cloud.guest_os.display_name = 
guest_os_display_name)

;   INSERT  INTO cloud.guest_os_hypervisor (uuid, hypervisor_type, 
hypervisor_version, guest_os_name, guest_os_id, created)
 SELECT UUID(), guest_os_hypervisor_hypervisor_type, 
guest_os_hypervisor_hypervisor_version, guest_os_hypervisor_guest_os_name, 
guest_os.id, now()
 FROM   cloud.guest_os
 WHERE  guest_os.category_id = guest_os_category_id
   AND  guest_os.display_name = guest_os_display_name
   AND  NOT EXISTS (SELECT  1
  FROMcloud.guest_os_hypervisor as hypervisor
  WHERE   hypervisor_type = 
guest_os_hypervisor_hypervisor_type
AND hypervisor_version = 
guest_os_hypervisor_hypervisor_version
AND hypervisor.guest_os_id = guest_os.id
AND hypervisor.guest_os_name = 
guest_os_hypervisor_guest_os_name)
;END;

I tried to run it manually and same error occurs.

mysql> CREATE PROCEDURE `cloud`.`ADD_GUEST_OS_AND_HYPERVISOR_MAPPING` (
-> IN guest_os_category_id bigint(20) unsigned,
-> IN guest_os_display_name VARCHAR(255),
-> IN guest_os_hypervisor_hypervisor_type VARCHAR(32),
-> IN guest_os_hypervisor_hypervisor_version VARCHAR(32),
-> IN guest_os_hypervisor_guest_os_name VARCHAR(255)
-> )
-> BEGIN
-> INSERT  INTO cloud.guest_os (uuid, category_id, display_name, created)
-> SELECT UUID(), guest_os_category_id, guest_os_display_name, now()
-> FROMDUAL
-> WHERE not exists( SELECT  1
->  FROMcloud.guest_os
->  WHERE   cloud.guest_os.category_id = 
guest_os_category_id
->AND cloud.guest_os.display_name = 
guest_os_display_name)
->
-> ;INSERT  INTO cloud.guest_os_hypervisor (uuid, hypervisor_type, 
hypervisor_version, guest_os_name, guest_os_id, created)
ERROR 1064 (42000): 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 15
->  SELECT UUID(), guest_os_hypervisor_hypervisor_type, 
guest_os_hypervisor_hypervisor_version, guest_os_hypervisor_guest_os_name, 
guest_os.id, now()
->  FROM cloud.guest_os
->  WHERE guest_os.category_id = guest_os_category_id
->AND guest_os.display_name = guest_os_display_name
->AND NOT EXISTS (SELECT  1
->   FROMcloud.guest_os_hypervisor as hypervisor
->   WHERE   hypervisor_type = 
guest_os_hypervisor_hypervisor_type
-> AND hypervisor_version = 
guest_os_hypervisor_hypervisor_version
-> AND hypervisor.guest_os_id = guest_os.id
-> AND hypervisor.guest_os_name = 
guest_os_hypervisor_guest_os_name)
-> ;END;
ERROR 1054 (42S22): Unknown column 'guest_os_hypervisor_hypervisor_type' in 
'field list'
ERROR 1064 (42000): 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 'END' 
at line 1


** Mysql version 8.0

Re: Usage service issue on Ubuntu

[Vivek Kumar]

Hello Wei, 

Any suggestion on below issue ?

Vivek Kumar
Sr. Manager - Cloud & DevOps
TechOps | Indiqus Technologies

vivek.ku...@indiqus.com 
www.indiqus.com 




> On 22-Jul-2022, at 1:52 PM, Vivek Kumar  wrote:
> 
> Hello Wei, 
> 
> Thanks for the response..! Please find the content below - 
> 
> 
> 
> 
> 
> 
> http://jakarta.apache.org/log4j/ 
> " debug="false">
> 
>
>
>
> 
>
>   
>   
> 
>   
>  
>   
>
> 
>
>
>
> 
>
> class="org.apache.log4j.rolling.RollingFileAppender">
>   
>   
>   
>  value="/var/log/cloudstack/usage/usage.log.%d{-MM-dd}{GMT}.gz"/>
>  value="/var/log/cloudstack/usage/usage.log"/>
>   
> 
>   
>  
>   
>
> 
>
>
>
> 
>
>  
>
> 
>
>
>   
>
> 
>
>   
>
> 
>
>  
>
> 
>
>
>
> 
>
>   
>   
>   
>
> 
> 
> 
> 
> Vivek Kumar
> Sr. Manager - Cloud & DevOps
> TechOps | Indiqus Technologies
> 
> vivek.ku...@indiqus.com 
>   www.indiqus.com 
> 
> 
> 
> 
>> On 22-Jul-2022, at 1:47 PM, Wei ZHOU > > wrote:
>> 
>> Hi Vivek,
>> 
>> Can you share the log4j conf file `/etc/cloudstack/usage/log4j-cloud.xml` ?
>> 
>> -Wei
>> 
>> On Fri, 22 Jul 2022 at 08:31, Vivek Kumar > >
>> wrote:
>> 
>>> Hello Folks,
>>> 
>>> Can anyone help me on this ?
>>> 
>>> 
>>> Vivek Kumar
>>> Sr. Manager - Cloud & DevOps
>>> TechOps | Indiqus Technologies
>>> 
>>> vivek.ku...@indiqus.com  
>>> >
>>>www.indiqus.com  >> >
>>> 
>>> 
>>> 
>>> 
 On 14-Jul-2022, at 12:41 PM, Vivek Kumar >>> >
>>> wrote:
 
 Hello Folks,
 We have deployed cloudstack 4.16.1 on ubuntu OS. Management service is
>>> working fine but getting error with cloudstack-usage. This is a clean new
>>> installation. Can someone help me out ? Pasting the details below -
 
 
 
 root@SPRPVTCLDACS02:~# systemctl status cloudstack-usage
 ● cloudstack-usage.service - CloudStack Usage Server
 Loaded: loaded (/lib/systemd/system/cloudstack-usage.service;
>>> enabled; vendor preset: enabled)
 Active: activating (auto-restart) (Result: exit-code) since Thu
>>> 2022-07-14 11:17:16 IST; 3s ago
   Docs: http://www.cloudstack.org/  
 >
Process: 294817 ExecStart=/bin/sh -ec /usr/bin/java
>>> -Dpid=${JAVA_PID} $JAVA_OPTS $JAVA_DEBUG -cp $CLASSPATH $JAVA_CLASS
>>> (code=exited, status=1/FAILURE)
   Main PID: 294817 (code=exited, status=1/FAILURE)
 
 Jul 14 11:17:27 SPRPVTCLDACS02 systemd[1]: cloudstack-usage.service:
>>> Scheduled restart job, restart counter is at 4970.
 Jul 14 11:17:27 SPRPVTCLDACS02 systemd[1]: Stopped CloudStack Usage
>>> Server.
 Jul 14 11:17:27 SPRPVTCLDACS02 systemd[1]: Started CloudStack Usage
>>> Server.
 Jul 14 11:17:27 SPRPVTCLDACS02 sh[294878]: log4j:WARN No appenders could
>>> be found for logger (com.cloud.utils.LogUtils).
 Jul 14 11:17:27 SPRPVTCLDACS02 sh[294878]: log4j:WARN Please initialize
>>> the log4j system properly.
 Jul 14 11:17:27 SPRPVTCLDACS02 sh[294878]: log4j:WARN See
>>> http://logging.apache.org/log4j/1.2/faq.html#noconfig 
>>>  <
>>> http://logging.apache.org/log4j/1.2/faq.html#noconfig 
>>> > for more info.
 Jul 14 11:17:28 SPRPVTCLDACS02 sh[294878]: SLF4J: Failed to load class
>>> "org.slf4j.impl.StaticLoggerBinder".
 Jul 14 11:17:28 SPRPVTCLDACS02 sh[294878]: SLF4J: Defaulting to
>>> no-operation (NOP) logger implementation
 Jul 14 11:17:28 SPRPVTCLDACS02 sh[294878]: SLF4J: See
>>> http://www.slf4j.org/codes.html#StaticLoggerBinder 
>>>  <
>>> http://www.slf4j.org/codes.html#StaticLoggerBinder 
>>> > for further details.
 Jul 14 11:17:30 SPRPVTCLDACS02 sh[294878]: WARNING: An illegal
>>> reflective access operation has occurred
 Jul 14 11:17:30 SPRPVTCLDACS02 sh[294878]: WARNING: Illegal reflective
>>> access by net.sf.cglib.core.ReflectUtils$1
>>> (file:/usr/share/cloudstack-usage/lib/cglib-nodep-3.3.0.jar) to me>
 Jul 14 11:17:30 SPRPVTCLDACS02 sh[294878]: WARNING: Please consider
>>> reporting this to the maintainers of net.sf.cglib.core.ReflectUtils$1
 Jul 14 11:17:30 SPRPVTCLDACS02 sh[294878]: WARNING: Use
>>> --illegal-access=warn to enable warnings

Re: Permission Denied on Domain Controller on Internal LoadBalancer

[Wei ZHOU]

Hi Ricardo,

Can you create a github issue to describe how to reproduce the issue ?
Thanks
https://github.com/apache/cloudstack/issues

-Wei



On Wed, 27 Jul 2022 at 20:21, Ricardo Pertuz 
wrote:

> Thanks Wei,
>
> Passing projectid same result, not so sure when you say "add the domain
> admin to the project ", we want to make it available for any user on the
> platform on demand.
>
> Regards,
>
> Ricardo P
>
> On 27/07/22, 12:51 PM, "Wei ZHOU"  wrote:
>
> Hi,
>
> Does the network belong to a project ? If so, please pass projectid or
> add
> the domain admin to the project.
>
> -Wei
>
> On Wednesday, 27 July 2022, Ricardo Pertuz 
> wrote:
>
> > Hi,
> >
> > Here the logs (I changed some sensitive info)
> >
> > Apilog
> > *
> > 2022-07-27 11:34:57,218 INFO  [a.c.c.a.ApiServer]
> (qtp2109798150-1192:ctx-de4123f6
> > ctx-f93ec0cc ctx-8c0287a4) (logid:b8e0600b) (userId=4 accountId=4
> > sessionId=null) 192.168.xxx.xxx -- GET algorithm=source&apiKey=
> > GoHebItTOdSc4zf5NcwxDxRo&command=createLoadBalancer&
> > description=lb01&instanceport=8080&name=lb01&networkid=
> > 498611f9--4030-aa10-e7d7ad062d1a&response=json&scheme=Internal&
> > sourceipaddressnetworkid=498611f9-cd93-4030-aa10-
> > e7d7ad062d1a&sourceport=8080&signature=gB%2BseI8Ku7ZCN9drw 531
> Unable to
> > use network with id= 498611f9--4030-aa10-e7d7ad062d1a, permission
> > denied
> >
> > Management-server
> > *
> > 2022-07-27 11:34:57,198 DEBUG [c.c.a.ApiServlet]
> (qtp2109798150-1192:ctx-de4123f6)
> > (logid:b8e0600b) ===START===  192.168.xx.xx-- GET
> algorithm=source&apiKey=GoHebItTOdSc4zf5NcwxDxR
> > &command=createLoadBalancer&description=lb01&instanceport=
> > 8080&name=lb01&networkid=498611f9--4030-aa10-
> > e7d7ad062d1a&response=json&scheme=Internal&sourceipaddressnetworkid=
> > 498611f9-xxx-4030-aa10-e7d7ad062d1a&sourceport=8080&signature=gB%
> > 2BseI8Ku7ZCN9drw3Lxqdo%2Bj8k%3D
> > 2022-07-27 11:34:57,201 DEBUG [c.c.a.ApiServer]
> (qtp2109798150-1192:ctx-de4123f6
> > ctx-f93ec0cc) (logid:b8e0600b) CIDRs from which account
> > 'Acct[c5aac4a3--43a9-8117-eb2fa34fdca5-cocentrodemo1control]' is
> > allowed to perform API calls: 0.0.0.0/0,::/0
> > 2022-07-27 11:34:57,205 DEBUG [o.a.c.a.BaseCmd]
> (qtp2109798150-1192:ctx-de4123f6
> > ctx-f93ec0cc ctx-8c0287a4) (logid:b8e0600b) Ignoring paremeter
> fordisplay
> > as the caller is not authorized to pass it in
> > 2022-07-27 11:34:57,207 DEBUG [c.c.u.AccountManagerImpl]
> > (qtp2109798150-1192:ctx-de4123f6 ctx-f93ec0cc ctx-8c0287a4)
> > (logid:b8e0600b) Access to Acct[39efe918-df79-45ec-b8f0-
> > 302c6d44dfa9-PrjAcct-624349294c0efe30d9ec0fd6-3] granted to
> > Acct[026a2cc9--447a-9bf3-6a749fae743a-demo1control] by
> DomainChecker
> > 2022-07-27 11:34:57,209 DEBUG [o.a.c.a.BaseCmd]
> (qtp2109798150-1192:ctx-de4123f6
> > ctx-f93ec0cc ctx-8c0287a4) (logid:b8e0600b) Ignoring paremeter
> fordisplay
> > as the caller is not authorized to pass it in
> > 2022-07-27 11:34:57,217 INFO  [c.c.a.ApiServer]
> (qtp2109798150-1192:ctx-de4123f6
> > ctx-f93ec0cc ctx-8c0287a4) (logid:b8e0600b) PermissionDenied: Unable
> to use
> > network with id= 498611f9--4030-aa10-e7d7ad062d1a, permission
> denied
> > on objs: []
> > 2022-07-27 11:34:57,218 DEBUG [c.c.a.ApiServlet]
> (qtp2109798150-1192:ctx-de4123f6
> > ctx-f93ec0cc ctx-8c0287a4) (logid:b8e0600b) ===END===  192.168. ===
> > 192.168.xx.xx -- GET  algorithm=source&apiKey=
> > GoHebItTOdSc4zf5NcwxDxRo5v1FeY&command=createLoadBalancer&
> > description=lb01&instanceport=8080&name=lb01&networkid=
> > 498611f9-xxx-4030-aa10-e7d7ad062d1a&response=json&scheme=Internal&
> > sourceipaddressnetworkid=498611f9--4030-aa10-
> >
> e7d7ad062d1a&sourceport=8080&signature=gB%2BseI8Ku7ZCN9drw3Lxqdo%2Bj8k%3D
> > 2022-07-27 11:34:57,566 DEBUG [c.c.a.m.AgentManagerImpl]
> > (AgentManager-Handler-12:null) (logid:) SeqA 47-30512: Processing Seq
> > 47-30512:  { Cmd , MgmtId: -1, via: 47, Ver: v1, Flags: 11,
> > [{"com.cloud.agent.api.ConsoleProxyLoadReportCommand"
> > :{"_proxyVmId":"7557","_loadInfo":"{
> >   "connections": []
> >
> >
> > On 27/07/22, 10:07 AM, "Wei ZHOU"  wrote:
> >
> > Hi Ricardo,
> >
> > Could you share more logs ?
> >
> > -Wei
> >
> > On Wed, 27 Jul 2022 at 17:04, Ricardo Pertuz <
> ricardo.per...@kuasar.co
> > >
> > wrote:
> >
> > > Hi Wei,
> > >
> > > Tried using domainid, account and accountid and all these 3
> together,
> > > still the same error, “Error: (HTTP 531, error code 4365)
> Unable to
> > use
> > > network with id= 498611f9--4030-aa10-e7d7ad062d1a,
> permission
> > denied”
> > >
> > > Regards,
> > >
> > 

Re: Changing the connecting hosts when using Ceph as primary

[Wei ZHOU]

Great, thanks for sharing Sven !

-Wei

On Thu, 28 Jul 2022 at 14:00, Sven Barczyk 
wrote:

> I solved the problem:
>
> Cloudstack creates virsh pools during the initializing of
> cloudstack-agents.
> These Pools are hard defined until you release your hosts.
> So if you want the change the settings like in my case, you have to edit
> the pools with virsh pool-edit   and restart libvirtd.
> These step have to been made on every host in your cluster with the Ceph
> RBD config.
>
> After that you need to migrate the VMs, which triggers an recreate of the
> virsh-template.
>
> best regards
> Sven
>
> On 2022/07/27 08:22:03 Sven Barczyk wrote:
> > Hello everyone,
> >
> >
> >
> > i caught myself beeing stupid.
> > While deploying my cluster, I've decided to use my mon1.ceph to be the
> main
> > RBD Host which leads now to the problem, that a restart of mon1 will be
> > hell.
> >
> > In despite, i changed the host to a round-robin dns (changed by sql ),
> which
> > is the suggested method of the documentation and thought all new
> Instances
> > will be deployed with this new host from the database.
> > But no , still uses the mon1.ceph while deploying new instances (checked
> > with virsh dumpxml on my hosts), instead of the new set host, mons.ceph
> > which round-robins through all my mons.
> >
> > Restart of Cloudstack-management did not help.
> >
> > Is there anyone who could give me an hint where this rbd hosts might be
> > hardcoded in the cloudstack-config ?
> >
> >
> >
> > Best regards,
> > Sven
> >
> >
> >
> >
>

RE: Changing the connecting hosts when using Ceph as primary

[Sven Barczyk]

I solved the problem:

Cloudstack creates virsh pools during the initializing of cloudstack-agents.
These Pools are hard defined until you release your hosts.
So if you want the change the settings like in my case, you have to edit the
pools with virsh pool-edit   and restart libvirtd.
These step have to been made on every host in your cluster with the Ceph RBD
config.

After that you need to migrate the VMs, which triggers an recreate of the
virsh-template.

best regards
Sven



On 2022/07/27 08:22:03 Sven Barczyk wrote: 
> Hello everyone, 
> 
>  
> 
> i caught myself beeing stupid. 
> While deploying my cluster, I've decided to use my mon1.ceph to be the
main 
> RBD Host which leads now to the problem, that a restart of mon1 will be 
> hell. 
> 
> In despite, i changed the host to a round-robin dns (changed by sql ),
which 
> is the suggested method of the documentation and thought all new Instances

> will be deployed with this new host from the database. 
> But no , still uses the mon1.ceph while deploying new instances (checked 
> with virsh dumpxml on my hosts), instead of the new set host, mons.ceph 
> which round-robins through all my mons. 
> 
> Restart of Cloudstack-management did not help. 
> 
> Is there anyone who could give me an hint where this rbd hosts might be 
> hardcoded in the cloudstack-config ? 
> 
>  
> 
> Best regards, 
> Sven 
> 
> 
> 
> 



smime.p7s
Description: S/MIME cryptographic signature

Re: Unable to login to GUI onto second management server

[Harikrishna Patnala]

Hi Andrei,

Can you please also try the below steps? I'm just making sure all pointers are 
to the new management server only.

  1.  Keep only the new management server IP in the host configuration.
  2.  Stop the old management server
  3.  Restart the new management server

Thanks,
Harikrishna

From: Andrei Mikhailovsky 
Sent: Wednesday, July 27, 2022 6:45 PM
To: Harikrishna Patnala 
Cc: users 
Subject: Re: Unable to login to GUI onto second management server

Hi Harikrishna,

I have added the new management server IP address into the host configuration 
from the gui. It now shows:

hostThe ip address of management server. This can also accept comma 
separated addresses.Advanced
192.168.169.13,192.168.169.21


After that I've started the new management server and unfortunately, I still 
have the same issue.

I have also noticed that after starting the new management server, the table 
mshost has been updated to reflect the server status as Up.:


|  4 | 115129173025114 | 1658099918669 | ais-cloudhost13.csprdc.arhont.com | 
98405826-0861-11ea-a1da-8003fe80 | Up| 4.16.1.0 | 127.0.0.1  |  
   9090 | 2022-07-27 13:10:05 | NULL|   0 |
|  5 | 165004275141402 | 1658927302926 | ais-compute1.cloud.arhont.com | 
0d1522a5-5d08-46af-b59c-b577aa22e9bb | Up| 4.16.1.0 | 192.168.169.21 |  
   9090 | 2022-07-27 13:08:32 | NULL|   0 |

Anything else I should try?

Thanks

Andrei


From: "Harikrishna Patnala" 
To: "Andrei Mikhailovsky" , "users" 

Sent: Wednesday, 27 July, 2022 07:21:24
Subject: Re: Unable to login to GUI onto second management server
Hi Andrei,

If the purpose of the second management server is about migration please ignore 
the previous reply.

You have the right pointer to the procedure and I hope you have followed it.

Please try to provide the following information.

  1.  Is the old management server also in the 4.16.1 version?
  2.  Which database.properties file you have changed to point to the new 
database ?
  3.  Can you check the database table "configuration", what is the value for 
the configuration with the name "host", is it your new MS host address ?
  4.  Also, check the "mshost" table in the database if it is pointing to the 
new management server.

Regards,
Harikrishna






From: Andrei Mikhailovsky 
Sent: Monday, July 25, 2022 7:46 PM
To: users 
Cc: Harikrishna Patnala 
Subject: Re: Unable to login to GUI onto second management server


Hi Harikrishna,

Having read the links that you've sent I am not sure that my issues are 
related. Perhaps I should have explained my current set up / intensions a bit 
more. My main reasons for adding the multiple management servers is not to 
provide the HA / load balancing, but rather to migrate the current management 
server from old hardware to the new one. I was referring to the post sent by 
Andrija Panic 
(https://www.mail-archive.com/users@cloudstack.apache.org/msg32889.html) where 
Andrija has suggested that one should install the second management server, 
connect it to the database, move the database to a new server and change the 
database properties to point the new management server to the new db.

In my tests, I have installed the second management server without any 
proxy/load balancing and I tried to connect and authenticate directly to the IP 
address of the second management server. I've tried it with the primary 
management server switched on and off, but I still have the same issues. If I 
am connecting directly to the new management server IP, I don't see how having 
nginx proxy settings changes would fix my issue. Also, I have not seen anything 
in the documentation that explicitly requires having a proxy if you install the 
second management server.

Why do you think my issue relates to CORS?

Andrei




 

- Original Message -
> From: "Harikrishna Patnala" 
> To: "users" 
> Sent: Wednesday, 20 July, 2022 05:10:13
> Subject: Re: Unable to login to GUI onto second management server

> Hi Andrei,
>
> This looks to me like a CORS issue.
>
> Have you set up any load balancer for these management servers. There is a
> section
> http://docs.cloudstack.apache.org/en/4.16.1.0/adminguide/reliability.html#management-server-load-balancing
> which you need to configure so that you will not face issues with HA and 
> agents
> later on.
>
>
> You may need to consider setting cookies like below.
>
> If you are using nginx, try with  "proxy_cookie_path / "/; Secure;
> SameSite=None;";" and a similar thing should work haproxy too.
>
> I got this reference from a previous discussion on a PR
> https://github.com/apache/cloudstack-primate/pull/898#issuecomment-760227366,
> please refer to it if it helps solve your problem.
>
>
> Regards,
> Harikrishna
> 
> From: Andrei Mikhailovsky 
> Sent: Tuesday, July 19, 2022 4:06 PM
> To: users 
> Subject: Re: Unab

RE: CPVM VNC clipboard character mapping

[Gary Dixon]

Hi

This is still an issue - The VM is set to UK keyboard in the settings.
Specifically, it is an issue with the CPVM vnc clipboard functionality that is 
mapping the UK keyboard to US
I can type in an open document on the VM with no issues and characters typed on 
a UK keyboard are correctly mapped- but if I use the vnc clipboard  UK 
character keys such as #, @, " , £ etc are mapped incorrectly when pasted into 
the document and are converted to the us equivalent keys.

BR
Gary



Gary Dixon
Technical Consultant
T:  0161 537 4980
W: www.quadris.co.uk
The information contained in this e-mail from Quadris may be confidential and 
privileged for the private use of the named recipient.  The contents of this 
e-mail may not necessarily represent the official views of Quadris.  If you 
have received this information in error you must not copy, distribute or take 
any action or reliance on its contents.  Please destroy any hard copies and 
delete this message.
-Original Message-
From: Pearl d'Silva 
Sent: 27 July 2022 17:56
To: users@cloudstack.apache.org
Subject: Re: CPVM VNC clipboard character mapping

Hi Gary,

Can you please check the specific VM's settings - specifically the keyboard 
setting. If it is pointing to 'us' change it to 'uk'. This would however 
require you to first shutdown the VM.

Regards,
Pearl

From: Gary Dixon 
Sent: Wednesday, July 27, 2022 8:42 PM
To: users@cloudstack.apache.org 
Subject: FW: CPVM VNC clipboard character mapping


Hi



Has anyone seen this behaviour before ?





Gary Dixon​
Technical Consultant
T:  0161 537 4980
W: 
https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.quadris.co.uk%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7C98842a457bc641ee5ea008da6ff1043f%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C637945378205522033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=uq%2FCEsvaOm2GDykMV8J8Ew0uowlc3AePR5wJnoniV%2Fs%3D&reserved=0
[cid:image144474.png@F5DAB9C0.A4AE5009]
The information contained in this e-mail from Quadris may be confidential and 
privileged for the private use of the named recipient.  The contents of this 
e-mail may not necessarily represent the official views of Quadris.  If you 
have received this information in error you must not copy, distribute or take 
any action or reliance on its contents.  Please destroy any hard copies and 
delete this message.

From: Gary Dixon 
Sent: 26 July 2022 08:57
To: users@cloudstack.apache.org
Subject: CPVM VNC clipboard character mapping



Hi everyone



I’m sure this must have been raised before but I am struggling to find any 
recent documentation for this issue.



We have ACS 4.15.2 on Ubuntu 20.04 for mgmt. and KVM hosts and I am seeing an 
issue where if I use the console proxy VNC viewer on any of my Windows based 
instances – certain characters are mapped incorrectly



For example if I put the following characters into the clipboard :



“@|



And then ‘send’ them into a notepad file on the guest – they map to the 
following characters :

@”#



However if I type the characters directly into the open notepad file on the 
guest – they do type correctly.

So it appears that the console proxy VNC viewer clipboard is translating the 
characters as ‘US’ keyboard rather than ‘UK’ keyboard.



I have been reading this thread about CPVM non US keyboard support but it seems 
out of date now : 
https://eur01.safelinks.protection.outlook.com/?url=https%3A%2F%2Fcwiki.apache.org%2Fconfluence%2Fdisplay%2FCLOUDSTACK%2FSupport%2Bfor%2Bnon-US%2Bkeyboards%2Bin%2BConsole%2BProxy&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7C98842a457bc641ee5ea008da6ff1043f%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0%7C637945378205522033%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=iHUyeJRtae3KFo2L6V0IaZAkgNm8GXXXOZWVuGY7zgE%3D&reserved=0



I’m sure there will be a straight forward fix for this issue – as at the mment 
we have to be careful about what characters we use in passwords – etc as they 
currently are pasting incorrectly using the vnc viewer clipboard.



Any advice would be greatly appreciated



BR



Gary Dixon​​

Technical Consultant

T:  0161 537 4980

W: 
https://eur01.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.quadris.co.uk%2F&data=05%7C01%7CGary.Dixon%40quadris.co.uk%7C98842a457bc641ee5ea008da6ff1043f%7Cf1d6abf3d3b44894ae16db0fb93a96a2%7C0%7C0