This Confluence has been LDAP enabled, if you are an ASF Committer, please use your LDAP Credentials to login. Any problems file an INFRA jira ticket please.

Child pages
  • Useful Tips and Tricks

Versions Compared


  • This line was added.
  • This line was removed.
  • Formatting was changed.


For seeing this one must enable the general query log of mysql

mysql> show variableslike '%log%';mysql> set global general_log=ON;


 The default location of the general query log on most distributions is /var/run/mysqld/mysqld.log


1. fdisk /dev/sd*
2. press"n" ->"p" ->"w" to write changes
3. mkfs.ext3 /dev/sd*1
4. mount /dev/sd*1 <targetDir>


18.  How to Enable HTTPS for CloudStack Web Interface?

Refer the documented information @


       API  request  should be like  "http://localhost:8096/client/?command=deployVirtualMachine&serviceofferingid=1&templateid=202&zoneid=1&userdata=Y3VzdG9tZXJWTQ%3D%3D

20.  How to add Rhel5 repo?


21.  How can I allocate a specific IP when I create an instance

1. Edit the vm ip in /var/run/cloud/<vm-name>.log file in host and  restart the vm. This should update the security group rules in host.


1.Access VM console
2. Run lspci


24.  How to redirect SQL query results to a file ?


1. Access SSVM from Hypervisor and run /usr/local/cloud/systemvm/
2. Or open /var/log/cloud/cloud.out for errors.  IF there are connectivity issues then open /var/cache/cloud/cmdline/ and check Management server IP.
3. Change it to new Management server IP
4. Stop and start cloud server (/etc/init.d/cloud stop then /etc/init.d/cloud start ) . Check cloud.out log .
4. @ CPVM also perform step 2 , 3 & 4
5. Now template download/View console will work with no issues.


27. How to install VMWare tools on a guest VM?


a.  .cd vmware-tools-distrib

b. ./


28:How to install Xen tools on a guest VM?


[root@xenserver]# cd /mnt
[root@xenserver]# ls
[root@xenserver]# mkdir xs-tools
[root@xenserver]# mount /dev/xvdd /mnt/xs-tools/
mount: block device /dev/xvdd is write-protected, mounting read-only
[root@xenserver]# cd /mnt/xs-tools/Linux/
[root@xenserver]# bash