qemu-kvm tweaking (CloudStack-2.2.14)

2013-10-02 Thread Vladimir Melnik
Dear colleagues,

Has anybody managed to set/change parameters of qemu-kvm for certain
instance before it launches?
For example, if I want to add the 3rd drive or to emulate some different
model of the NIC and so on...
Are there any working hacks for that?

Thanks!

-- 
V.Melnik



Re: Choosing VMWare SCSI Controller Type

2013-10-02 Thread Chris Sciarrino
Hi Sean,

I have tried this in 4.1.1 and 4.2. I have tried the HDD adapter type in
the register template screen like you also suggested but that did not have
an effect.

Unless I am mistaken, I think that option will set the disk type to ide or
scsi and not change the actual controller type that the scsi disk uses.


Thanks,

Chris


On Wed, Oct 2, 2013 at 5:16 AM, Sean Hamilton s...@seanhamilton.co.ukwrote:

 Hey Chris,

 What version of CS are you running? I've seen a bug in the Register
 Template screen. If you select the location for the template it should
 open up more options, one of which is the HDD adapter type.

 Let me know how it goes.


 On 2 October 2013 05:12, Chris Sciarrino chris.sciarr...@gmail.com
 wrote:

  Hi,
 
  I am having an issue where my vmware templates are being deployed with
 the
  lsi parallel scsi controller type which is causing them to blue screen.
 Is
  there any way to choose which scsi controller type it will be deployed
  with? Or is there any other way to make it deploy the lsi sas controller?
 
 
  Thanks,
 
  Chris
 



4.2.0 Install guide, section 4.4.2 RPM Repo

2013-10-02 Thread Old, Curtis

Has anyone thought of updating the section 4.4.2 on the yum repo from:


[cloudstack]
name=cloudstack
baseurl=http://cloudstack.apt-get.eu/rhel/4.1/
enabled=1
gpgcheck=0

To

[cloudstack]
name=cloudstack
baseurl=http://cloudstack.apt-get.eu/rhel/4.2/
enabled=1
gpgcheck=0


After I changed it I see:

[root@lab2-mgt-cloud-1 ~]# yum list cloud*
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
 * base: mirror.nexcess.net
 * extras: mirror.es.its.nyu.edu
 * updates: mirror.trouble-free.net
cloudstack  
 | 1.1 kB 00:00
cloudstack/primary  
 | 2.6 kB 00:00
cloudstack  
7/7
Available Packages
cloudstack-agent.x86_64   4.2.0-1.el6   
  cloudstack
cloudstack-awsapi.x86_64  4.2.0-1.el6   
  cloudstack
cloudstack-baremetal-agent.x86_64 4.2.0-1.el6   
  cloudstack
cloudstack-cli.x86_64 4.2.0-1.el6   
  cloudstack
cloudstack-common.x86_64  4.2.0-1.el6   
  cloudstack
cloudstack-management.x86_64  4.2.0-1.el6   
  cloudstack
cloudstack-usage.x86_64   4.2.0-1.el6   
  cloudstack

Just a thought, and sorry if this has been brought up already :-)

Curtis Old
Neustar, Inc. / Neustarlabs / Senior Research Engineer
46000 Center Oak Plaza Sterling, VA 20166
Office: +1.571.434.5384 Mobile: +1.540.532.2230 / 
curtis@neustar.bizmailto:curtis@neustar.biz  / 
www.neustar.bizhttp://www.neustar.biz/

The information contained in this e-mail message is intended only for the use 
of the recipient(s) named above and may contain confidential and/or privileged 
information. If you are not the intended recipient you have received this 
e-mail message in error and any review, dissemination, distribution, or copying 
of this message is strictly prohibited. If you have received this communication 
in error, please notify us immediately and delete the original message.


Re: migration fails when iso is attached to running vm

2013-10-02 Thread Travis Graham
Hello Valery,

That is expected. You'll need to always unmount ISO files from a VM before 
migrating.

Travis

On Oct 2, 2013, at 5:26 AM, Valery Ciareszka valery.teres...@gmail.com wrote:

 Hi all.
 I am testing CS 4.2+KVM and when I try to migrate running VM I get
 following error:
 
 jobresult:
 errorcode = 530
 errortext = Failed to migrate vm
 jobresultcode = 530
 jobresulttype = object
 jobstatus = 2
 
 According to the logs, vm fails to migrate due to secondary storage is not
 mounted on the node this vm is trying to migrate to:
 
 2013-10-02 09:15:19,124 ERROR [cloud.vm.VirtualMachineManagerImpl]
 (Job-Executor-16:job-1573 = [ 7b3332b4-dcfa-4a82-847f-d3f6159e65c0 ])
 Unable to migrate due to cannot open file
 '/mnt/ae12c83d-5bc2-3bdb-9a83-f181209879c5/225-2-78686e44-457d-34e2-afb6-926583401caf.iso':
 No such file or directory
 
 If I detach iso from vm, migration works correctly.
 
 Is this expected behaviour or should I report a bug ?
 
 -- 
 Regards,
 Valery
 
 http://protocol.by/slayer



Migrating/managing secondary storages

2013-10-02 Thread mailinglists
Hi everyone.

 I have a CS 4.2 and 4 secondary NFS storages (s1, s2, s3, s4). I'd like
to migrate everything (all the templates, snapshots,…) from s1 and s2 to s3
and s4 and then shutdown s1  s2. Is there a way to do it via GUI? 

The only instructions I found are to stop CloudStack, copy everything from
one secondary storage to another change the references to that secondary
storage in the database to the new secondary storage and restart
cloudstack.

Any first hand experiences/advices on how to do it, what to look out for?

Best regards,

F.



Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Indra Pramana
Dear all,

I tried to simulate upgrading the database from Cloudstack 4.1.1 to 4.2.0
on my test environment and getting below error message:

MySQLSyntaxErrorException: Access denied; you need (at least one of) the
SUPER privilege(s) for this operation

Anyone can advise what super privilege is required? The database worked
fine on 4.1.1 prior to the upgrade.

Below is more logs from the management-server.log:


2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
`cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
`cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
`cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
VIEW `cloud`.`user_view` AS select  user.id,
user.uuid, user.username, user.password,
user.firstname, user.lastname, user.email,
user.state, user.api_key, user.secret_key,
user.created, user.removed, user.timezone,
user.registration_token, user.is_registered,
user.incorrect_login_attempts, user.default,
account.idaccount_id, account.uuid account_uuid,
account.account_name
account_name, account.type account_type,
domain.iddomain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`user` inner
join `cloud`.`account` ON user.account_id = account.id
inner join `cloud`.`domain` ON account.domain_id = domain.id
left join `cloud`.`async_job` ON async_job.instance_id =
user.id
and async_job.instance_type = 'User' and async_job.job_status =
0
2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error
executing: ALTER VIEW `cloud`.`user_view` AS select
user.id,
user.uuid, user.username, user.password,
user.firstname, user.lastname, user.email,
user.state, user.api_key, user.secret_key,
user.created, user.removed, user.timezone,
user.registration_token, user.is_registered,
user.incorrect_login_attempts, user.default,
account.idaccount_id, account.uuid account_uuid,
account.account_name
account_name, account.type account_type,
domain.iddomain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`user` inner
join `cloud`.`account` ON user.account_id = account.id
inner join `cloud`.`domain` ON account.domain_id = domain.id
left join `cloud`.`async_job` ON async_job.instance_id =
user.id
and async_job.instance_type = 'User' and async_job.job_status =
0
2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
you need (at least one of) the SUPER privilege(s) for this operation
2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) Unable to execute upgrade script:
/usr/share/cloudstack-management/setup/db/schema-410to420.sql
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
you need (at least one of) the SUPER privilege(s) for this operation
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:201)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)
at
com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
at
com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
at java.util.TimerThread.mainLoop(Timer.java:534)
at java.util.TimerThread.run(Timer.java:484)
2013-10-02 20:33:06,011 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) Unable to upgrade the database
com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql
at
com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:210)
at
com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
at
com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)

Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Rafael Weingartner
Interesting errors, just by any change are you using the database on Amazon
RDS?


2013/10/2 Indra Pramana in...@sg.or.id

 Dear all,

 I tried to simulate upgrading the database from Cloudstack 4.1.1 to 4.2.0
 on my test environment and getting below error message:

 MySQLSyntaxErrorException: Access denied; you need (at least one of) the
 SUPER privilege(s) for this operation

 Anyone can advise what super privilege is required? The database worked
 fine on 4.1.1 prior to the upgrade.

 Below is more logs from the management-server.log:

 
 2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
 `cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2)
 2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
 `cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
 2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null) UPDATE
 `cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
 2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null) ALTER
 VIEW `cloud`.`user_view` AS select  user.id,
 user.uuid, user.username, user.password,
 user.firstname, user.lastname, user.email,
 user.state, user.api_key, user.secret_key,
 user.created, user.removed, user.timezone,
 user.registration_token, user.is_registered,
 user.incorrect_login_attempts, user.default,
 account.idaccount_id, account.uuid account_uuid,
 account.account_name
 account_name, account.type account_type,
 domain.iddomain_id, domain.uuid domain_uuid,
 domain.name domain_name, domain.path domain_path,
 async_job.id job_id, async_job.uuid job_uuid,
 async_job.job_status job_status, async_job.account_id
 job_account_id from `cloud`.`user` inner
 join `cloud`.`account` ON user.account_id = account.id
 inner join `cloud`.`domain` ON account.domain_id = domain.id
 left join `cloud`.`async_job` ON async_job.instance_id =
 user.id
 and async_job.instance_type = 'User' and async_job.job_status =
 0
 2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null) Error
 executing: ALTER VIEW `cloud`.`user_view` AS select
 user.id,
 user.uuid, user.username, user.password,
 user.firstname, user.lastname, user.email,
 user.state, user.api_key, user.secret_key,
 user.created, user.removed, user.timezone,
 user.registration_token, user.is_registered,
 user.incorrect_login_attempts, user.default,
 account.idaccount_id, account.uuid account_uuid,
 account.account_name
 account_name, account.type account_type,
 domain.iddomain_id, domain.uuid domain_uuid,
 domain.name domain_name, domain.path domain_path,
 async_job.id job_id, async_job.uuid job_uuid,
 async_job.job_status job_status, async_job.account_id
 job_account_id from `cloud`.`user` inner
 join `cloud`.`account` ON user.account_id = account.id
 inner join `cloud`.`domain` ON account.domain_id = domain.id
 left join `cloud`.`async_job` ON async_job.instance_id =
 user.id
 and async_job.instance_type = 'User' and async_job.job_status =
 0
 2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
 you need (at least one of) the SUPER privilege(s) for this operation
 2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
 (Timer-1:null) Unable to execute upgrade script:
 /usr/share/cloudstack-management/setup/db/schema-410to420.sql
 com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
 you need (at least one of) the SUPER privilege(s) for this operation
 at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
 at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
 at

 com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:201)
 at

 com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
 at

 com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)
 at

 com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90)
 at
 com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:54)
 at java.util.TimerThread.mainLoop(Timer.java:534)
 at java.util.TimerThread.run(Timer.java:484)
 2013-10-02 20:33:06,011 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
 (Timer-1:null) Unable to upgrade the database
 com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade
 script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql
 at

 

Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Indra Pramana
Hi Rafael,

What I did is just to setup a new CloudStack 4.1.1 on a test VM, restore
the dump backup of our production database into the test environment, and
try to upgrade to 4.2.0.

Could it be because the database was taken from a different environment?
However, I tested accessing the GUI of the test environment after the dump
restore and I can access it, prior to the upgrade.

Looking forward to your reply, thank you.

Cheers.




On Wed, Oct 2, 2013 at 8:42 PM, Rafael Weingartner 
rafaelweingart...@gmail.com wrote:

 Interesting errors, just by any change are you using the database on Amazon
 RDS?


 2013/10/2 Indra Pramana in...@sg.or.id

  Dear all,
 
  I tried to simulate upgrading the database from Cloudstack 4.1.1 to 4.2.0
  on my test environment and getting below error message:
 
  MySQLSyntaxErrorException: Access denied; you need (at least one of) the
  SUPER privilege(s) for this operation
 
  Anyone can advise what super privilege is required? The database worked
  fine on 4.1.1 prior to the upgrade.
 
  Below is more logs from the management-server.log:
 
  
  2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
 UPDATE
  `cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2)
  2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
 UPDATE
  `cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
  2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
 UPDATE
  `cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
  2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
 ALTER
  VIEW `cloud`.`user_view` AS select  user.id,
  user.uuid, user.username, user.password,
  user.firstname, user.lastname, user.email,
  user.state, user.api_key, user.secret_key,
  user.created, user.removed, user.timezone,
  user.registration_token, user.is_registered,
  user.incorrect_login_attempts, user.default,
  account.idaccount_id, account.uuid account_uuid,
  account.account_name
  account_name, account.type account_type,
  domain.iddomain_id, domain.uuid domain_uuid,
  domain.name domain_name, domain.path domain_path,
  async_job.id job_id, async_job.uuid job_uuid,
  async_job.job_status job_status, async_job.account_id
  job_account_id from `cloud`.`user` inner
  join `cloud`.`account` ON user.account_id = account.id
  inner join `cloud`.`domain` ON account.domain_id = domain.id
  left join `cloud`.`async_job` ON async_job.instance_id =
  user.id
  and async_job.instance_type = 'User' and
 async_job.job_status =
  0
  2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
 Error
  executing: ALTER VIEW `cloud`.`user_view` AS select
  user.id,
  user.uuid, user.username, user.password,
  user.firstname, user.lastname, user.email,
  user.state, user.api_key, user.secret_key,
  user.created, user.removed, user.timezone,
  user.registration_token, user.is_registered,
  user.incorrect_login_attempts, user.default,
  account.idaccount_id, account.uuid account_uuid,
  account.account_name
  account_name, account.type account_type,
  domain.iddomain_id, domain.uuid domain_uuid,
  domain.name domain_name, domain.path domain_path,
  async_job.id job_id, async_job.uuid job_uuid,
  async_job.job_status job_status, async_job.account_id
  job_account_id from `cloud`.`user` inner
  join `cloud`.`account` ON user.account_id = account.id
  inner join `cloud`.`domain` ON account.domain_id = domain.id
  left join `cloud`.`async_job` ON async_job.instance_id =
  user.id
  and async_job.instance_type = 'User' and
 async_job.job_status =
  0
  2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
  you need (at least one of) the SUPER privilege(s) for this operation
  2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
  (Timer-1:null) Unable to execute upgrade script:
  /usr/share/cloudstack-management/setup/db/schema-410to420.sql
  com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access denied;
  you need (at least one of) the SUPER privilege(s) for this operation
  at
 com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
  at
 com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
  at
 
 
 com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:201)
  at
 
 
 com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:262)
  at
 
 
 com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:391)
 

Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Indra Pramana
Hi Rafael,

May I know how did you resolve the problem? Do we need to manually grant
super privilege to an account, e.g. 'cloud'@'%'?

Looking forward to your reply, thank you.

Cheers.



On Wed, Oct 2, 2013 at 8:56 PM, Rafael Weingartner 
rafaelweingart...@gmail.com wrote:

 I had the exactly same problem when I was backing up my CS database on a
 Amazon RDS.
 There was a problem with some DEFINER command generated by the mysqldump.


 2013/10/2 Indra Pramana in...@sg.or.id

  Hi Rafael,
 
  What I did is just to setup a new CloudStack 4.1.1 on a test VM, restore
  the dump backup of our production database into the test environment, and
  try to upgrade to 4.2.0.
 
  Could it be because the database was taken from a different environment?
  However, I tested accessing the GUI of the test environment after the
 dump
  restore and I can access it, prior to the upgrade.
 
  Looking forward to your reply, thank you.
 
  Cheers.
 
 
 
 
  On Wed, Oct 2, 2013 at 8:42 PM, Rafael Weingartner 
  rafaelweingart...@gmail.com wrote:
 
   Interesting errors, just by any change are you using the database on
  Amazon
   RDS?
  
  
   2013/10/2 Indra Pramana in...@sg.or.id
  
Dear all,
   
I tried to simulate upgrading the database from Cloudstack 4.1.1 to
  4.2.0
on my test environment and getting below error message:
   
MySQLSyntaxErrorException: Access denied; you need (at least one of)
  the
SUPER privilege(s) for this operation
   
Anyone can advise what super privilege is required? The database
 worked
fine on 4.1.1 prior to the upgrade.
   
Below is more logs from the management-server.log:
   

2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
   UPDATE
`cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
   UPDATE
`cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
   UPDATE
`cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
   ALTER
VIEW `cloud`.`user_view` AS select  user.id,
user.uuid, user.username, user.password,
user.firstname, user.lastname, user.email,
user.state, user.api_key, user.secret_key,
user.created, user.removed, user.timezone,
user.registration_token, user.is_registered,
user.incorrect_login_attempts, user.default,
account.idaccount_id, account.uuid account_uuid,
account.account_name
account_name, account.type account_type,
domain.iddomain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`user` inner
join `cloud`.`account` ON user.account_id = account.id
inner join `cloud`.`domain` ON account.domain_id = domain.id
left join `cloud`.`async_job` ON async_job.instance_id =
user.id
and async_job.instance_type = 'User' and
   async_job.job_status =
0
2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
   Error
executing: ALTER VIEW `cloud`.`user_view` AS select
user.id,
user.uuid, user.username, user.password,
user.firstname, user.lastname, user.email,
user.state, user.api_key, user.secret_key,
user.created, user.removed, user.timezone,
user.registration_token, user.is_registered,
user.incorrect_login_attempts, user.default,
account.idaccount_id, account.uuid account_uuid,
account.account_name
account_name, account.type account_type,
domain.iddomain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,
async_job.id job_id, async_job.uuid job_uuid,
async_job.job_status job_status, async_job.account_id
job_account_id from `cloud`.`user` inner
join `cloud`.`account` ON user.account_id = account.id
inner join `cloud`.`domain` ON account.domain_id = domain.id
left join `cloud`.`async_job` ON async_job.instance_id =
user.id
and async_job.instance_type = 'User' and
   async_job.job_status =
0
2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access
  denied;
you need (at least one of) the SUPER privilege(s) for this operation
2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
(Timer-1:null) Unable to execute 

Re: dreaded 'there is no secondary storage vm for ...'

2013-10-02 Thread sebgoa

On Oct 2, 2013, at 2:25 PM, Geoff Higginbottom 
geoff.higginbot...@shapeblue.com wrote:

 Sebastien,
 
 If the web server hosting the template is on the same network as the 
 management server, you need to configure  the following global setting with 
 the IP range
 
 secstorage.allowed.internal.sites
 

I did that thanks, but my secondary storage is not mounted in the ssvm.

I can mount it by hand, the ssvm is up, yet I get:

 There is no secondary storage VM for secondary storage host 
 nfs://192.168.38.100/export/secondary


-sebastien

 
 
 Regards
 
 Geoff Higginbottom
 
 D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581
 
 geoff.higginbot...@shapeblue.com
 
 -Original Message-
 From: sebgoa [mailto:run...@gmail.com]
 Sent: 02 October 2013 13:06
 To: users@cloudstack.apache.org
 Subject: dreaded 'there is no secondary storage vm for ...'
 
 HI,
 
 I am setting up basic zone. I have one mgt, one hypervisor (KVM, Ubuntu 
 12.04), I am on ACS 4.1.1
 
 Everything seems fine, the ssvm starts, I can log into it. Everything is on a 
 private network without outside connectivity.
 
 I am serving a template from that private network.
 From the ssvm I can ping the mgt server and the hypervisor, I can also mount 
 the secondary storage by hand.
 
 However it does not get mounted automatically and when I try to register the 
 template I get the dreaded:
 
 2013-10-02 05:00:13,407 DEBUG [cloud.api.ApiServlet] (catalina-exec-20:null) 
 ===START===  172.16.153.1 -- GET  
 command=registerTemplateresponse=jsonsessionkey=ErhEwVpkdKXC3br3zZUoAyaFY7E%3Dname=totodisplayText=totourl=http%3A%2F%2F192.168.38.100%3A80%2Ftinylinux.qcow2zoneid=-1format=QCOW2isextractable=falsepasswordEnabled=falseosTypeId=278f54ca-29d1-11e3-9b24-000c290705d2hypervisor=KVMispublic=trueisfeatured=true_=1380715213357
 2013-10-02 05:00:13,452 WARN  [storage.download.DownloadMonitorImpl] 
 (catalina-exec-20:null) There is no secondary storage VM for secondary 
 storage host nfs://192.168.38.100/export/secondary
 
 I am at a loss on this one..
 
 -sebastien
 This email and any attachments to it may be confidential and are intended 
 solely for the use of the individual to whom it is addressed. Any views or 
 opinions expressed are solely those of the author and do not necessarily 
 represent those of Shape Blue Ltd or related companies. If you are not the 
 intended recipient of this email, you must neither take any action based upon 
 its contents, nor copy or show it to anyone. Please contact the sender if you 
 believe you have received this email in error. Shape Blue Ltd is a company 
 incorporated in England  Wales. ShapeBlue Services India LLP is a company 
 incorporated in India and is operated under license from Shape Blue Ltd. 
 Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is 
 operated under license from Shape Blue Ltd. ShapeBlue is a registered 
 trademark.



Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Rafael Weingartner
Could you log in to the database with the user you are using to execute the
upgrade and use the command show grants;
and post me the results?


2013/10/2 Indra Pramana in...@sg.or.id

 Hi Rafael,

 I believe the upgrade script is run by 'cloud' user, correct? By default
 full permission to the 'cloud' user has been given, and I even added
 'super' privilege to the cloud user but the problem still persists.

 May I know how to change the DEFINER statement? Which statement you are
 referring to?

 Looking forward to your reply, thank you.

 Cheers.


 On Wed, Oct 2, 2013 at 9:13 PM, Rafael Weingartner 
 rafaelweingart...@gmail.com wrote:

  Well, I was getting this error because I was using an Amazon RDS
 database,
  and there the users, even the master do not have super privileges. So, I
  could not create a table logged with a user (e.g. root) and using
  DEFINER=cloud@'%'.
 
  But, since you have full access to the database, I do believe that you
 just
  need to give grant permission to the user you are using to run the
 queries,
  or simple try to change the DEFINER statement to something like:
  DEFINER=CURRENT_USER
 
 
  2013/10/2 Indra Pramana in...@sg.or.id
 
   Hi Rafael,
  
   May I know how did you resolve the problem? Do we need to manually
 grant
   super privilege to an account, e.g. 'cloud'@'%'?
  
   Looking forward to your reply, thank you.
  
   Cheers.
  
  
  
   On Wed, Oct 2, 2013 at 8:56 PM, Rafael Weingartner 
   rafaelweingart...@gmail.com wrote:
  
I had the exactly same problem when I was backing up my CS database
 on
  a
Amazon RDS.
There was a problem with some DEFINER command generated by the
  mysqldump.
   
   
2013/10/2 Indra Pramana in...@sg.or.id
   
 Hi Rafael,

 What I did is just to setup a new CloudStack 4.1.1 on a test VM,
   restore
 the dump backup of our production database into the test
 environment,
   and
 try to upgrade to 4.2.0.

 Could it be because the database was taken from a different
   environment?
 However, I tested accessing the GUI of the test environment after
 the
dump
 restore and I can access it, prior to the upgrade.

 Looking forward to your reply, thank you.

 Cheers.




 On Wed, Oct 2, 2013 at 8:42 PM, Rafael Weingartner 
 rafaelweingart...@gmail.com wrote:

  Interesting errors, just by any change are you using the database
  on
 Amazon
  RDS?
 
 
  2013/10/2 Indra Pramana in...@sg.or.id
 
   Dear all,
  
   I tried to simulate upgrading the database from Cloudstack
 4.1.1
  to
 4.2.0
   on my test environment and getting below error message:
  
   MySQLSyntaxErrorException: Access denied; you need (at least
 one
   of)
 the
   SUPER privilege(s) for this operation
  
   Anyone can advise what super privilege is required? The
 database
worked
   fine on 4.1.1 prior to the upgrade.
  
   Below is more logs from the management-server.log:
  
   
   2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner]
   (Timer-1:null)
  UPDATE
   `cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN
   (1,2)
   2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner]
   (Timer-1:null)
  UPDATE
   `cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
   2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner]
   (Timer-1:null)
  UPDATE
   `cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
   2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner]
   (Timer-1:null)
  ALTER
   VIEW `cloud`.`user_view` AS select  user.id,
   user.uuid, user.username, user.password,
   user.firstname, user.lastname, user.email,
   user.state, user.api_key, user.secret_key,
   user.created, user.removed, user.timezone,
   user.registration_token, user.is_registered,
   user.incorrect_login_attempts, user.default,
   account.idaccount_id, account.uuid account_uuid,
   account.account_name
   account_name, account.type account_type,
   domain.iddomain_id, domain.uuid domain_uuid,
   domain.name domain_name, domain.path domain_path,
   async_job.id job_id, async_job.uuid job_uuid,
   async_job.job_status job_status, async_job.account_id
   job_account_id from `cloud`.`user`
 inner
   join `cloud`.`account` ON user.account_id = account.id
   inner join `cloud`.`domain` ON account.domain_id =
   domain.id
   left join `cloud`.`async_job` ON async_job.instance_id
 =
   user.id
   and async_job.instance_type = 'User' and
  async_job.job_status =
   0
   2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner]
   (Timer-1:null)
  Error
   executing: 

Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Rafael Weingartner
I had the exactly same problem when I was backing up my CS database on a
Amazon RDS.
There was a problem with some DEFINER command generated by the mysqldump.


2013/10/2 Indra Pramana in...@sg.or.id

 Hi Rafael,

 What I did is just to setup a new CloudStack 4.1.1 on a test VM, restore
 the dump backup of our production database into the test environment, and
 try to upgrade to 4.2.0.

 Could it be because the database was taken from a different environment?
 However, I tested accessing the GUI of the test environment after the dump
 restore and I can access it, prior to the upgrade.

 Looking forward to your reply, thank you.

 Cheers.




 On Wed, Oct 2, 2013 at 8:42 PM, Rafael Weingartner 
 rafaelweingart...@gmail.com wrote:

  Interesting errors, just by any change are you using the database on
 Amazon
  RDS?
 
 
  2013/10/2 Indra Pramana in...@sg.or.id
 
   Dear all,
  
   I tried to simulate upgrading the database from Cloudstack 4.1.1 to
 4.2.0
   on my test environment and getting below error message:
  
   MySQLSyntaxErrorException: Access denied; you need (at least one of)
 the
   SUPER privilege(s) for this operation
  
   Anyone can advise what super privilege is required? The database worked
   fine on 4.1.1 prior to the upgrade.
  
   Below is more logs from the management-server.log:
  
   
   2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
  UPDATE
   `cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id IN (1,2)
   2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
  UPDATE
   `cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
   2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
  UPDATE
   `cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN (1,2)
   2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner] (Timer-1:null)
  ALTER
   VIEW `cloud`.`user_view` AS select  user.id,
   user.uuid, user.username, user.password,
   user.firstname, user.lastname, user.email,
   user.state, user.api_key, user.secret_key,
   user.created, user.removed, user.timezone,
   user.registration_token, user.is_registered,
   user.incorrect_login_attempts, user.default,
   account.idaccount_id, account.uuid account_uuid,
   account.account_name
   account_name, account.type account_type,
   domain.iddomain_id, domain.uuid domain_uuid,
   domain.name domain_name, domain.path domain_path,
   async_job.id job_id, async_job.uuid job_uuid,
   async_job.job_status job_status, async_job.account_id
   job_account_id from `cloud`.`user` inner
   join `cloud`.`account` ON user.account_id = account.id
   inner join `cloud`.`domain` ON account.domain_id = domain.id
   left join `cloud`.`async_job` ON async_job.instance_id =
   user.id
   and async_job.instance_type = 'User' and
  async_job.job_status =
   0
   2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
  Error
   executing: ALTER VIEW `cloud`.`user_view` AS select
   user.id,
   user.uuid, user.username, user.password,
   user.firstname, user.lastname, user.email,
   user.state, user.api_key, user.secret_key,
   user.created, user.removed, user.timezone,
   user.registration_token, user.is_registered,
   user.incorrect_login_attempts, user.default,
   account.idaccount_id, account.uuid account_uuid,
   account.account_name
   account_name, account.type account_type,
   domain.iddomain_id, domain.uuid domain_uuid,
   domain.name domain_name, domain.path domain_path,
   async_job.id job_id, async_job.uuid job_uuid,
   async_job.job_status job_status, async_job.account_id
   job_account_id from `cloud`.`user` inner
   join `cloud`.`account` ON user.account_id = account.id
   inner join `cloud`.`domain` ON account.domain_id = domain.id
   left join `cloud`.`async_job` ON async_job.instance_id =
   user.id
   and async_job.instance_type = 'User' and
  async_job.job_status =
   0
   2013-10-02 20:33:06,007 ERROR [utils.db.ScriptRunner] (Timer-1:null)
   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access
 denied;
   you need (at least one of) the SUPER privilege(s) for this operation
   2013-10-02 20:33:06,009 ERROR [cloud.upgrade.DatabaseUpgradeChecker]
   (Timer-1:null) Unable to execute upgrade script:
   /usr/share/cloudstack-management/setup/db/schema-410to420.sql
   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Access
 denied;
   you need (at least one of) the SUPER privilege(s) for this operation
   at
  com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
   at
  com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
  

Re: dreaded 'there is no secondary storage vm for ...'

2013-10-02 Thread sebgoa

On Oct 2, 2013, at 3:28 PM, Geoff Higginbottom 
geoff.higginbot...@shapeblue.com wrote:

 Did you by chance configure the 'Storage' network when you created the Zone
 

Found the issue, the host IP of the mgt server was wrong ( I have two 
interfaces) and the ssvm was on private network.
Fixed that and the templates are downloading, but it's stuck at 99% in the 
UI….hunting that one now 

 Regards
 
 Geoff Higginbottom
 
 D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581
 
 geoff.higginbot...@shapeblue.com
 
 -Original Message-
 From: sebgoa [mailto:run...@gmail.com]
 Sent: 02 October 2013 14:13
 To: users@cloudstack.apache.org
 Subject: Re: dreaded 'there is no secondary storage vm for ...'
 
 
 On Oct 2, 2013, at 2:25 PM, Geoff Higginbottom 
 geoff.higginbot...@shapeblue.com wrote:
 
 Sebastien,
 
 If the web server hosting the template is on the same network as the 
 management server, you need to configure  the following global setting with 
 the IP range
 
 secstorage.allowed.internal.sites
 
 
 I did that thanks, but my secondary storage is not mounted in the ssvm.
 
 I can mount it by hand, the ssvm is up, yet I get:
 
 There is no secondary storage VM for secondary storage host 
 nfs://192.168.38.100/export/secondary
 
 
 -sebastien
 
 
 
 Regards
 
 Geoff Higginbottom
 
 D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581
 
 geoff.higginbot...@shapeblue.com
 
 -Original Message-
 From: sebgoa [mailto:run...@gmail.com]
 Sent: 02 October 2013 13:06
 To: users@cloudstack.apache.org
 Subject: dreaded 'there is no secondary storage vm for ...'
 
 HI,
 
 I am setting up basic zone. I have one mgt, one hypervisor (KVM, Ubuntu 
 12.04), I am on ACS 4.1.1
 
 Everything seems fine, the ssvm starts, I can log into it. Everything is on 
 a private network without outside connectivity.
 
 I am serving a template from that private network.
 From the ssvm I can ping the mgt server and the hypervisor, I can also mount 
 the secondary storage by hand.
 
 However it does not get mounted automatically and when I try to register the 
 template I get the dreaded:
 
 2013-10-02 05:00:13,407 DEBUG [cloud.api.ApiServlet] (catalina-exec-20:null) 
 ===START===  172.16.153.1 -- GET  
 command=registerTemplateresponse=jsonsessionkey=ErhEwVpkdKXC3br3zZUoAyaFY7E%3Dname=totodisplayText=totourl=http%3A%2F%2F192.168.38.100%3A80%2Ftinylinux.qcow2zoneid=-1format=QCOW2isextractable=falsepasswordEnabled=falseosTypeId=278f54ca-29d1-11e3-9b24-000c290705d2hypervisor=KVMispublic=trueisfeatured=true_=1380715213357
 2013-10-02 05:00:13,452 WARN  [storage.download.DownloadMonitorImpl] 
 (catalina-exec-20:null) There is no secondary storage VM for secondary 
 storage host nfs://192.168.38.100/export/secondary
 
 I am at a loss on this one..
 
 -sebastien
 This email and any attachments to it may be confidential and are intended 
 solely for the use of the individual to whom it is addressed. Any views or 
 opinions expressed are solely those of the author and do not necessarily 
 represent those of Shape Blue Ltd or related companies. If you are not the 
 intended recipient of this email, you must neither take any action based 
 upon its contents, nor copy or show it to anyone. Please contact the sender 
 if you believe you have received this email in error. Shape Blue Ltd is a 
 company incorporated in England  Wales. ShapeBlue Services India LLP is a 
 company incorporated in India and is operated under license from Shape Blue 
 Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil 
 and is operated under license from Shape Blue Ltd. ShapeBlue is a registered 
 trademark.
 
 This email and any attachments to it may be confidential and are intended 
 solely for the use of the individual to whom it is addressed. Any views or 
 opinions expressed are solely those of the author and do not necessarily 
 represent those of Shape Blue Ltd or related companies. If you are not the 
 intended recipient of this email, you must neither take any action based upon 
 its contents, nor copy or show it to anyone. Please contact the sender if you 
 believe you have received this email in error. Shape Blue Ltd is a company 
 incorporated in England  Wales. ShapeBlue Services India LLP is a company 
 incorporated in India and is operated under license from Shape Blue Ltd. 
 Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is 
 operated under license from Shape Blue Ltd. ShapeBlue is a registered 
 trademark.



Re: [ANNOUNCE] Apache CloudStack 4.2.0 Released

2013-10-02 Thread Dean Kamali
Indra,

I have downloaded new system vm and registered it, it didn't make much
difference, usage logs is overwriting management logs and all hypervisors
are in disconnected state.

So, I guess this upgrade wasn't tested properly on Ubuntu unfortunately.

Dean






On Wed, Oct 2, 2013 at 4:00 AM, benoit lair kurushi4...@gmail.com wrote:

 Very great Job all of you !! I'm very excited to be able to use the new
 version of cloudstack 4.2 !!
 There were several weeks (months ?) that i was expecting features such load
 balancing betweens vpc tiers.
 Now it's done !!
 I have upgraded my preproduction environment from cs 4.1 to cs 4.2 and all
 is clear, the upgrade worked nice !!
 I use mgmt server with centos 6.3 with xcp and xenserver 6.2 hypervisors
 and it rocks a lot !!

 Very nice work guys !! Now i can prepare my future production environment

 Best regards,

 Benoit


 2013/10/2 Kirk Kosinski kirkkosin...@gmail.com

  I filed a bug for the error when running cloudstack-sysvmadm on Ubuntu.
 
  https://issues.apache.org/jira/browse/CLOUDSTACK-4778
 
  Best regards,
  Kirk
 
  On 10/01/2013 10:09 PM, Indra Pramana wrote:
   Hi Dean,
  
   I encountered exactly the same error message when running the
   cloudstack-sysvmadm script. I am also using Ubuntu but using KVM
   hypervisor. Some things to check:
  
   1. Have you registered the system VM template for 4.2 prior to the
  upgrade?
   If not yet, you need to register the template first.
   2. After upgrading both the management server and the hypervisor hosts,
  log
   in to the GUI and ensure that the hosts are up, before performing the
   cloudstack-sysvmadm script.
  
   Thank you.
  
  
  
   On Wed, Oct 2, 2013 at 12:56 AM, Dean Kamali dean.kam...@gmail.com
  wrote:
  
   update:
   I'm using Ubuntu on my management server, and currently all of my
   hypervisors are in disconnected state, I have also noticed that usage
   server log is overwriting management logs
  
   I must say ouch!
  
   D
  
  
   On Tue, Oct 1, 2013 at 12:31 PM, Dean Kamali dean.kam...@gmail.com
   wrote:
  
   Thanks Travis
  
   Any one have tried to upgrade?
  
   I followed upgrade process from 4.1.1 to 4.2 (xenserver) is running
 on
   all
   of my hyperviroues
  
   However when I try and run  cloudstack-sysvmadm to stop then start
 all
   running SSVMs, Console Proxies, and Virtual Routers
  
   I get the following:
  
   /usr/bin/cloudstack-sysvmadm: line 21: /etc/rc.d/init.d/functions: No
   such
   file or directory
  
   Stopping and starting 1 secondary storage vm(s)...
   ERROR: Failed to stop secondary storage vm with id 5
  
   Done stopping and starting secondary storage vm(s)
  
   Stopping and starting 1 console proxy vm(s)...
   ERROR: Failed to stop console proxy vm with id 19
  
   Done stopping and starting console proxy vm(s) .
  
   Stopping and starting 6 running routing vm(s)...
   ERROR: Failed to restart domainRouter with id 13
  
   ERROR: Failed to restart domainRouter with id 112
  
   ERROR: Failed to restart domainRouter with id 108
  
   ERROR: Failed to restart domainRouter with id 94
  
   ERROR: Failed to restart domainRouter with id 120
  
   ERROR: Failed to restart domainRouter with id 83
  
   Done restarting router(s).
  
   Any ideas?
  
  
  
   On Tue, Oct 1, 2013 at 12:06 PM, Travis Graham tgra...@tgraham.us
   wrote:
  
   Hey Dean,
  
   I've had the same problem this morning. It's actually from the old
  docs
   site being cached. You'll want to clear your cache or use a
 different
   browser.
  
   Here's a direct link:
  
  
  
  
 
 http://cloudstack.apache.org/docs/en-US/Apache_CloudStack/4.2.0/html/Release_Notes/index.html
  
   Travis
  
   On Oct 1, 2013, at 11:50 AM, Dean Kamali dean.kam...@gmail.com
  wrote:
  
   Thank you, I'm very excited, where can we find the release notes?
  they
   are
   not on http://cloudstack.apache.org/docs/en-US/index.html yet!
  
   I'm actually more interested in upgrade notes for xenserver from
  4.1.1
  
   Thanks again
  
  
   On Tue, Oct 1, 2013 at 10:11 AM, Animesh anim...@apache.org
 wrote:
  
  
   The Apache CloudStack project is excited to announce the
   4.2 feature release of the CloudStack cloud orchestration
 platform.
   This
   is the
   next feature release of the 4.0 branch which first released on
   November 6,
   2012
   with the 4.1 release on June 5. This is the second major release
  from
   Apache
   CloudStack since its graduation from the Apache Incubator on March
   20th.
  
   This release represents over six months of work from the
   Apache CloudStack community with 57 new and 29 improved features
   being
   provided. Many new features incorporate contributions from major
   corporations
   and support for industry standards. New integrated support of the
   Cisco UCS
   compute chassis, SolidFire storage arrays, and the S3 storage
   protocol
   are
   just
   a few of the features available in this release.
  
   ## Documentation
   The 4.2 release 

[SOLVED] Re: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

2013-10-02 Thread Indra Pramana
Hi Rafael,

I managed to resolve the problem by removing all the DEFINER statements
from the dump .sql file.

sed '/^\/\*\!50013 DEFINER/d' cloudstack-backup-2013100201-fix.sql 
cloudstack-backup-2013100201-fix-without-definer.sql

I then restored the cloudstack-backup-2013100201-fix-without-definer.sql
into the database and the upgrade works.

Thank you for your help.

Cheers.



On Wed, Oct 2, 2013 at 9:38 PM, Rafael Weingartner 
rafaelweingart...@gmail.com wrote:

 Could you log in to the database with the user you are using to execute the
 upgrade and use the command show grants;
 and post me the results?


 2013/10/2 Indra Pramana in...@sg.or.id

  Hi Rafael,
 
  I believe the upgrade script is run by 'cloud' user, correct? By default
  full permission to the 'cloud' user has been given, and I even added
  'super' privilege to the cloud user but the problem still persists.
 
  May I know how to change the DEFINER statement? Which statement you are
  referring to?
 
  Looking forward to your reply, thank you.
 
  Cheers.
 
 
  On Wed, Oct 2, 2013 at 9:13 PM, Rafael Weingartner 
  rafaelweingart...@gmail.com wrote:
 
   Well, I was getting this error because I was using an Amazon RDS
  database,
   and there the users, even the master do not have super privileges. So,
 I
   could not create a table logged with a user (e.g. root) and using
   DEFINER=cloud@'%'.
  
   But, since you have full access to the database, I do believe that you
  just
   need to give grant permission to the user you are using to run the
  queries,
   or simple try to change the DEFINER statement to something like:
   DEFINER=CURRENT_USER
  
  
   2013/10/2 Indra Pramana in...@sg.or.id
  
Hi Rafael,
   
May I know how did you resolve the problem? Do we need to manually
  grant
super privilege to an account, e.g. 'cloud'@'%'?
   
Looking forward to your reply, thank you.
   
Cheers.
   
   
   
On Wed, Oct 2, 2013 at 8:56 PM, Rafael Weingartner 
rafaelweingart...@gmail.com wrote:
   
 I had the exactly same problem when I was backing up my CS database
  on
   a
 Amazon RDS.
 There was a problem with some DEFINER command generated by the
   mysqldump.


 2013/10/2 Indra Pramana in...@sg.or.id

  Hi Rafael,
 
  What I did is just to setup a new CloudStack 4.1.1 on a test VM,
restore
  the dump backup of our production database into the test
  environment,
and
  try to upgrade to 4.2.0.
 
  Could it be because the database was taken from a different
environment?
  However, I tested accessing the GUI of the test environment after
  the
 dump
  restore and I can access it, prior to the upgrade.
 
  Looking forward to your reply, thank you.
 
  Cheers.
 
 
 
 
  On Wed, Oct 2, 2013 at 8:42 PM, Rafael Weingartner 
  rafaelweingart...@gmail.com wrote:
 
   Interesting errors, just by any change are you using the
 database
   on
  Amazon
   RDS?
  
  
   2013/10/2 Indra Pramana in...@sg.or.id
  
Dear all,
   
I tried to simulate upgrading the database from Cloudstack
  4.1.1
   to
  4.2.0
on my test environment and getting below error message:
   
MySQLSyntaxErrorException: Access denied; you need (at least
  one
of)
  the
SUPER privilege(s) for this operation
   
Anyone can advise what super privilege is required? The
  database
 worked
fine on 4.1.1 prior to the upgrade.
   
Below is more logs from the management-server.log:
   

2013-10-02 20:33:05,876 DEBUG [utils.db.ScriptRunner]
(Timer-1:null)
   UPDATE
`cloud`.`account` SET `cloud`.`account`.`default`=1 WHERE id
 IN
(1,2)
2013-10-02 20:33:05,913 DEBUG [utils.db.ScriptRunner]
(Timer-1:null)
   UPDATE
`cloud_usage`.`account` SET `default`=1 WHERE id IN (1,2)
2013-10-02 20:33:05,914 DEBUG [utils.db.ScriptRunner]
(Timer-1:null)
   UPDATE
`cloud`.`user` SET `cloud`.`user`.`default`=1 WHERE id IN
 (1,2)
2013-10-02 20:33:05,915 DEBUG [utils.db.ScriptRunner]
(Timer-1:null)
   ALTER
VIEW `cloud`.`user_view` AS select  user.id,
user.uuid, user.username, user.password,
user.firstname, user.lastname, user.email,
user.state, user.api_key, user.secret_key,
user.created, user.removed, user.timezone,
user.registration_token, user.is_registered,
user.incorrect_login_attempts, user.default,
account.idaccount_id, account.uuid account_uuid,
account.account_name
account_name, account.type account_type,
domain.iddomain_id, domain.uuid domain_uuid,
domain.name domain_name, domain.path domain_path,

Re: Unable to create instance after upgrading to CloudStack 4.2.0

2013-10-02 Thread Indra Pramana
Hi Wei Zhou,

Thank you for your e-mail.

May I know where is this script ConfigurationServerImpl located? Can we
run this script manually?

Is there a way we can run the script so that it will insert the records
without having to check for any conditions?

Looking forward to your reply, thank you.

Cheers.




On Wed, Oct 2, 2013 at 4:26 PM, Wei ZHOU ustcweiz...@gmail.com wrote:

 ConfigurationServerImpl will insert missing records to resource_count table
 at management server startup.
 It is strange you meet some issues others do not meet.


 2013/10/2 Indra Pramana in...@sg.or.id

  Dear Animesh, Sanjay and all,
 
  Latest test that I and Abhinav done earlier this morning:
 
  - Abhinav tested upgrade from 4.1.1 to 4.2.0 on his lab and he noticed
 that
  the additional resource_count types (total 4 of them: cpu, memory,
  primary_storage and secondary_storage) were added automatically during DB
  schema upgrade.
 
  Excerpts from his management-server.log file:
 
  
  2013-10-01 23:56:46,318 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) resource_count table has records missing for some
  domains...going to insert them
  2013-10-01 23:56:46,339 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type cpu for domain id=1
  2013-10-01 23:56:46,341 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type memory for domain id=1
  2013-10-01 23:56:46,349 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type primary_storage for
 domain
  id=1
  2013-10-01 23:56:46,351 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type secondary_storage for
  domain id=1
  2013-10-01 23:56:46,362 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) resource_count table has records missing for some
  accounts...going to insert them
  2013-10-01 23:56:46,372 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type cpu for account id=1
  2013-10-01 23:56:46,379 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type memory for account id=1
  2013-10-01 23:56:46,381 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type primary_storage for
 account
  id=1
  2013-10-01 23:56:46,388 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type secondary_storage for
  account id=1
  2013-10-01 23:56:46,418 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type cpu for account id=2
  2013-10-01 23:56:46,420 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type memory for account id=2
  2013-10-01 23:56:46,428 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type primary_storage for
 account
  id=2
  2013-10-01 23:56:46,429 DEBUG [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Inserting resource count of type secondary_storage for
  account id=2
  2013-10-01 23:56:46,439 INFO  [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) Processing updateSSLKeyStore
  2013-10-01 23:56:46,499 INFO  [cloud.server.ConfigurationServerImpl]
  (Timer-2:null) SSL keystore located at
  /etc/cloudstack/management/cloud.keystore
  
 
  However, I didn't have the above during the DB schema upgrade.
 
  May I know which process triggers the above situation and leads to the
  additional records to be inserted? Tried to go through the
  /usr/share/cloudstack-management/setup/db/schema-410to420.sql script and
  cannot find the above.
 
  Any reason why my upgrade didn't trigger the insertion of the additional
  records?
 
  Urgently looking forward to your reply, thank you.
 
  Cheers.
 
 
 
 
  On Wed, Oct 2, 2013 at 3:43 AM, Animesh Chaturvedi 
  animesh.chaturv...@citrix.com wrote:
 
   Copying Sanjay
  
   Animesh
  
-Original Message-
From: Indra Pramana [mailto:in...@sg.or.id]
Sent: Tuesday, October 01, 2013 11:06 AM
To: d...@cloudstack.apache.org; users@cloudstack.apache.org
Subject: Re: Unable to create instance after upgrading to CloudStack
4.2.0
   
Dear all,
   
Further investigation reveals that there might be some issues with
 the
schema upgrade. When we check the resource_count table for the
 account
ID:
   
mysql select * from resource_count where account_id=2;
+++---+---+---+
| id | account_id | domain_id | type  | count |
+++---+---+---+
| 17 |  2 |  NULL | user_vm   |30 |
| 18 |  2 |  NULL | public_ip | 4 |
| 19 |  2 |  NULL | volume|40 |
| 20 |  2 |  NULL | snapshot  | 1 |
| 21 |  2 |  NULL | template  |40 |
| 22 |  2 |   

Re: GPG key expired

2013-10-02 Thread David Nalley
Hi Markus.

That repository is maintained by Wido den Hollander - and I just spoke with
him on IRC and he indicates that he has updated the key located there. Let
us know if you have any other problems.

--David


On Wed, Oct 2, 2013 at 5:39 AM, Dietsch, Markus m.diet...@mid.de wrote:

   Hi list,

 ** **

 the gpg key of http://cloudstack.apt-get.eu/release.asc seems to be
 expired:

 ** **

 apt-key list

 /etc/apt/trusted.gpg

 

 pub   2048R/86C278E3 2012-09-07 [expired: 2013-09-07]

 uid  Apache CloudStack cloudstack-...@apache.org

 ** **

 After updating the sources.list I always get the following error:

 ** **

 W: GPG error: http://cloudstack.apt-get.eu precise Release: The following
 signatures were invalid: KEYEXPIRED 1378559179 KEYEXPIRED 1378559179
 KEYEXPIRED 1378559179

 ** **

 Can you please provide a new key?

 ** **

 Sorry for writing directly but I don’t want to subcribe to the list but
 only report this issue.

 ** **

 Thanks in advance and cheers,

 ** **

 Markus

 ** **

 [image:
 http://www.mid.de/fileadmin/templates/mid_v2/images/MID_Logo_RGB_80_40.jpg]
 

 Markus Dietsch, Administrator
 MID GmbH | Kressengartenstr. 10 | 90402 Nürnberg | Germany
 phone: +49 911 96836-433 | fax: +49 911 96836-100
 email: m.diet...@mid.de | www.mid.de http://mid.de/

 Sitz des Unternehmens/Registered Office: Nürnberg
 Handelsregister/Commercial Register: Amtsgericht Nürnberg HRB Nr. 21108
 Vorsitzender Geschäftsführer/CEO: Bertram Geck
 Geschäftsführer/Management Board: Andreas Ditze, Jürgen Leuschel, Jochen
 Seemann

 ** **

 ** **

  http://mid.de/insight
 *

 *

 http://www.insight2013.dehttp://www.mid.de/produkte/innovator-for-business-analysts/bpmn-tool-download.html

 Sichern Sie sich schon jetzt Ihren Frühbuchervorteil für die Insight 
 2013http://mid.de/insightund erleben Sie einen Tag zu den Themen BPMN, SOA, 
 Process Optimization,
 Big Data, BI, Innovation uvm.. Wir freuen uns auf Sie!



cannot delete primary storage

2013-10-02 Thread Len Bellemore
Hi Guys,

I've got an iSCSI-based Primary Storage pool that I am unable to delete.  I'm 
running XenServer 6.1 and have created the storage pool via the PreSetup option 
in CS.

I've had other pools set up exactly the same way and they have removed without 
problems.

When I try to delete the pool (via the GUI or the API) the state of the storage 
pool goes to Removed and throws an error:

errorcode530/errorcodecserrorcode/cserrorcodeerrortextFailed to 
finish storage pool removal. The storage pool will not be used but cleanup is 
needed/errortext/deletestoragepoolresponse

Anyone seen this before?

thanks

Len



IMPORTANT NOTICE. This electronic message contains information from Control 
Circle Ltd, which may be privileged or confidential. The information is 
intended for use only by the individual(s) or entity named above. If you are 
not the intended recipient, be aware that any disclosure, copying, distribution 
or use of the contents of this information is strictly prohibited. If you have 
received this electronic message in error, please notify me by telephone or 
email (to the number or email address above) immediately. Activity and use of 
the ControlCircle e-mail system is monitored to secure its effective operation 
and for other lawful business purposes. Communications using this system will 
also be monitored and may be recorded to secure effective operation and for 
other lawful business purposes


Re: dreaded 'there is no secondary storage vm for ...'

2013-10-02 Thread sebgoa

On Oct 2, 2013, at 3:43 PM, sebgoa run...@gmail.com wrote:

 
 On Oct 2, 2013, at 3:28 PM, Geoff Higginbottom 
 geoff.higginbot...@shapeblue.com wrote:
 
 Did you by chance configure the 'Storage' network when you created the Zone
 
 
 Found the issue, the host IP of the mgt server was wrong ( I have two 
 interfaces) and the ssvm was on private network.
 Fixed that and the templates are downloading, but it's stuck at 99% in the 
 UI….hunting that one now 

It works fine if I register an ISO, but for a qcow2 image (KVM hypervisor), the 
download happens and completes (file totally downloaded on systemvm mounted 
secondary storage), but the percentage completion of the download on the UI is 
stuck 99%, 84%, 67%….

Any idea why the mgt server would not think that the template has finished 
downloading ?


 
 Regards
 
 Geoff Higginbottom
 
 D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581
 
 geoff.higginbot...@shapeblue.com
 
 -Original Message-
 From: sebgoa [mailto:run...@gmail.com]
 Sent: 02 October 2013 14:13
 To: users@cloudstack.apache.org
 Subject: Re: dreaded 'there is no secondary storage vm for ...'
 
 
 On Oct 2, 2013, at 2:25 PM, Geoff Higginbottom 
 geoff.higginbot...@shapeblue.com wrote:
 
 Sebastien,
 
 If the web server hosting the template is on the same network as the 
 management server, you need to configure  the following global setting with 
 the IP range
 
 secstorage.allowed.internal.sites
 
 
 I did that thanks, but my secondary storage is not mounted in the ssvm.
 
 I can mount it by hand, the ssvm is up, yet I get:
 
 There is no secondary storage VM for secondary storage host 
 nfs://192.168.38.100/export/secondary
 
 
 -sebastien
 
 
 
 Regards
 
 Geoff Higginbottom
 
 D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581
 
 geoff.higginbot...@shapeblue.com
 
 -Original Message-
 From: sebgoa [mailto:run...@gmail.com]
 Sent: 02 October 2013 13:06
 To: users@cloudstack.apache.org
 Subject: dreaded 'there is no secondary storage vm for ...'
 
 HI,
 
 I am setting up basic zone. I have one mgt, one hypervisor (KVM, Ubuntu 
 12.04), I am on ACS 4.1.1
 
 Everything seems fine, the ssvm starts, I can log into it. Everything is on 
 a private network without outside connectivity.
 
 I am serving a template from that private network.
 From the ssvm I can ping the mgt server and the hypervisor, I can also 
 mount the secondary storage by hand.
 
 However it does not get mounted automatically and when I try to register 
 the template I get the dreaded:
 
 2013-10-02 05:00:13,407 DEBUG [cloud.api.ApiServlet] 
 (catalina-exec-20:null) ===START===  172.16.153.1 -- GET  
 command=registerTemplateresponse=jsonsessionkey=ErhEwVpkdKXC3br3zZUoAyaFY7E%3Dname=totodisplayText=totourl=http%3A%2F%2F192.168.38.100%3A80%2Ftinylinux.qcow2zoneid=-1format=QCOW2isextractable=falsepasswordEnabled=falseosTypeId=278f54ca-29d1-11e3-9b24-000c290705d2hypervisor=KVMispublic=trueisfeatured=true_=1380715213357
 2013-10-02 05:00:13,452 WARN  [storage.download.DownloadMonitorImpl] 
 (catalina-exec-20:null) There is no secondary storage VM for secondary 
 storage host nfs://192.168.38.100/export/secondary
 
 I am at a loss on this one..
 
 -sebastien
 This email and any attachments to it may be confidential and are intended 
 solely for the use of the individual to whom it is addressed. Any views or 
 opinions expressed are solely those of the author and do not necessarily 
 represent those of Shape Blue Ltd or related companies. If you are not the 
 intended recipient of this email, you must neither take any action based 
 upon its contents, nor copy or show it to anyone. Please contact the sender 
 if you believe you have received this email in error. Shape Blue Ltd is a 
 company incorporated in England  Wales. ShapeBlue Services India LLP is a 
 company incorporated in India and is operated under license from Shape Blue 
 Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil 
 and is operated under license from Shape Blue Ltd. ShapeBlue is a 
 registered trademark.
 
 This email and any attachments to it may be confidential and are intended 
 solely for the use of the individual to whom it is addressed. Any views or 
 opinions expressed are solely those of the author and do not necessarily 
 represent those of Shape Blue Ltd or related companies. If you are not the 
 intended recipient of this email, you must neither take any action based 
 upon its contents, nor copy or show it to anyone. Please contact the sender 
 if you believe you have received this email in error. Shape Blue Ltd is a 
 company incorporated in England  Wales. ShapeBlue Services India LLP is a 
 company incorporated in India and is operated under license from Shape Blue 
 Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil 
 and is operated under license from Shape Blue Ltd. ShapeBlue is a registered 
 trademark.
 



Bare Metal Docs for 4.2.0?

2013-10-02 Thread Jason Davis
Looking at the release notes it looks like Bare Metal guests are back from
their hiatus!

Looking around however, I'm not seeing any documentation for this as of
yet. Is there any documentation available and if so, where can it be found
as it's not on the official documentation portion of the website.


RE: cannot delete primary storage

2013-10-02 Thread Geoff Higginbottom
Hi Len,

I've had similar with NFS Storage and had to revert to changing settings 
directly in the DB

Regards

Geoff Higginbottom

D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581

geoff.higginbot...@shapeblue.com

-Original Message-
From: Len Bellemore [mailto:len.bellem...@controlcircle.com]
Sent: 02 October 2013 15:32
To: users@cloudstack.apache.org
Subject: cannot delete primary storage

Hi Guys,

I've got an iSCSI-based Primary Storage pool that I am unable to delete.  I'm 
running XenServer 6.1 and have created the storage pool via the PreSetup option 
in CS.

I've had other pools set up exactly the same way and they have removed without 
problems.

When I try to delete the pool (via the GUI or the API) the state of the storage 
pool goes to Removed and throws an error:

errorcode530/errorcodecserrorcode/cserrorcodeerrortextFailed to 
finish storage pool removal. The storage pool will not be used but cleanup is 
needed/errortext/deletestoragepoolresponse

Anyone seen this before?

thanks

Len



IMPORTANT NOTICE. This electronic message contains information from Control 
Circle Ltd, which may be privileged or confidential. The information is 
intended for use only by the individual(s) or entity named above. If you are 
not the intended recipient, be aware that any disclosure, copying, distribution 
or use of the contents of this information is strictly prohibited. If you have 
received this electronic message in error, please notify me by telephone or 
email (to the number or email address above) immediately. Activity and use of 
the ControlCircle e-mail system is monitored to secure its effective operation 
and for other lawful business purposes. Communications using this system will 
also be monitored and may be recorded to secure effective operation and for 
other lawful business purposes
This email and any attachments to it may be confidential and are intended 
solely for the use of the individual to whom it is addressed. Any views or 
opinions expressed are solely those of the author and do not necessarily 
represent those of Shape Blue Ltd or related companies. If you are not the 
intended recipient of this email, you must neither take any action based upon 
its contents, nor copy or show it to anyone. Please contact the sender if you 
believe you have received this email in error. Shape Blue Ltd is a company 
incorporated in England  Wales. ShapeBlue Services India LLP is a company 
incorporated in India and is operated under license from Shape Blue Ltd. Shape 
Blue Brasil Consultoria Ltda is a company incorporated in Brasil and is 
operated under license from Shape Blue Ltd. ShapeBlue is a registered trademark.


Re: cannot delete primary storage

2013-10-02 Thread Kirk Jantzer
Ditto to Geoff - when I've had issues deleting primary storages in the
past, I've ended up having to delete volumes that were still associated
with the datastore from the cloud.volumes table.


Regards,

Kirk Jantzer
http://about.me/kirkjantzer


On Wed, Oct 2, 2013 at 12:16 PM, Geoff Higginbottom 
geoff.higginbot...@shapeblue.com wrote:

 Hi Len,

 I've had similar with NFS Storage and had to revert to changing settings
 directly in the DB

 Regards

 Geoff Higginbottom

 D: +44 20 3603 0542 | S: +44 20 3603 0540 | M: +447968161581

 geoff.higginbot...@shapeblue.com

 -Original Message-
 From: Len Bellemore [mailto:len.bellem...@controlcircle.com]
 Sent: 02 October 2013 15:32
 To: users@cloudstack.apache.org
 Subject: cannot delete primary storage

 Hi Guys,

 I've got an iSCSI-based Primary Storage pool that I am unable to delete.
  I'm running XenServer 6.1 and have created the storage pool via the
 PreSetup option in CS.

 I've had other pools set up exactly the same way and they have removed
 without problems.

 When I try to delete the pool (via the GUI or the API) the state of the
 storage pool goes to Removed and throws an error:

 errorcode530/errorcodecserrorcode/cserrorcodeerrortextFailed
 to finish storage pool removal. The storage pool will not be used but
 cleanup is needed/errortext/deletestoragepoolresponse

 Anyone seen this before?

 thanks

 Len


 
 IMPORTANT NOTICE. This electronic message contains information from
 Control Circle Ltd, which may be privileged or confidential. The
 information is intended for use only by the individual(s) or entity named
 above. If you are not the intended recipient, be aware that any disclosure,
 copying, distribution or use of the contents of this information is
 strictly prohibited. If you have received this electronic message in error,
 please notify me by telephone or email (to the number or email address
 above) immediately. Activity and use of the ControlCircle e-mail system is
 monitored to secure its effective operation and for other lawful business
 purposes. Communications using this system will also be monitored and may
 be recorded to secure effective operation and for other lawful business
 purposes
 This email and any attachments to it may be confidential and are intended
 solely for the use of the individual to whom it is addressed. Any views or
 opinions expressed are solely those of the author and do not necessarily
 represent those of Shape Blue Ltd or related companies. If you are not the
 intended recipient of this email, you must neither take any action based
 upon its contents, nor copy or show it to anyone. Please contact the sender
 if you believe you have received this email in error. Shape Blue Ltd is a
 company incorporated in England  Wales. ShapeBlue Services India LLP is a
 company incorporated in India and is operated under license from Shape Blue
 Ltd. Shape Blue Brasil Consultoria Ltda is a company incorporated in Brasil
 and is operated under license from Shape Blue Ltd. ShapeBlue is a
 registered trademark.



Re: Choosing VMWare SCSI Controller Type

2013-10-02 Thread Francois Gaudreault
We came across the same issue at some point in the past, but we decided 
to change the templates to reflect to proper controller. There might be 
a thread on the dev list around that.


Let me know the bug id once you create it, one of our customer might 
need that feature.


Francois

On 2013-10-02 1:43 PM, Kelven Yang wrote:


On 10/2/13 3:00 AM, Chris Sciarrino chris.sciarr...@gmail.com wrote:


Hi Sean,

I have tried this in 4.1.1 and 4.2. I have tried the HDD adapter type in
the register template screen like you also suggested but that did not have
an effect.

Unless I am mistaken, I think that option will set the disk type to ide or
scsi and not change the actual controller type that the scsi disk uses.


Please report it as a feature-request bug, choosing controller type is not
currently supported yet

Kelven


Thanks,

Chris


On Wed, Oct 2, 2013 at 5:16 AM, Sean Hamilton
s...@seanhamilton.co.ukwrote:


Hey Chris,

What version of CS are you running? I've seen a bug in the Register
Template screen. If you select the location for the template it should
open up more options, one of which is the HDD adapter type.

Let me know how it goes.


On 2 October 2013 05:12, Chris Sciarrino chris.sciarr...@gmail.com
wrote:


Hi,

I am having an issue where my vmware templates are being deployed with

the

lsi parallel scsi controller type which is causing them to blue

screen.
Is

there any way to choose which scsi controller type it will be deployed
with? Or is there any other way to make it deploy the lsi sas

controller?


Thanks,

Chris







--
Francois Gaudreault
Architecte de Solution Cloud | Cloud Solutions Architect
fgaudrea...@cloudops.com
514-629-6775
- - -
CloudOps
420 rue Guy
Montréal QC  H3J 1S6
www.cloudops.com
@CloudOps_



CS 4.2 storage vm

2013-10-02 Thread Erdősi Péter

Dear,

I installed CS 4.2 from rpm packages to Centos 6.4.
Everything works fine, with install, and with configuration, but after 
the CS deploy the storage VM I can't add ISO-s.


After some research in the logs I found this on a secstorage system VM:

s-1-VM: /var/log/cloud.log
2013-10-02 13:31:19,269 INFO  [cloud.agent.AgentShell] (main:null) Agent 
started
2013-10-02 13:31:19,273 INFO  [cloud.agent.AgentShell] (main:null) 
Implementation Version is 4.2.0
2013-10-02 13:31:19,274 INFO  [cloud.agent.AgentShell] (main:null) 
agent.properties found at /usr/local/cloud/systemvm/conf/agent.properties
2013-10-02 13:31:19,281 DEBUG [cloud.agent.AgentShell] (main:null) Found 
property: instance
2013-10-02 13:31:19,281 DEBUG [cloud.agent.AgentShell] (main:null) Found 
property: resource
2013-10-02 13:31:19,281 INFO  [cloud.agent.AgentShell] (main:null) 
Defaulting to using properties file for storage
2013-10-02 13:31:19,283 INFO  [cloud.agent.AgentShell] (main:null) 
Defaulting to the constant time backoff algorithm
2013-10-02 13:31:19,290 INFO  [cloud.utils.LogUtils] (main:null) log4j 
configuration found at /usr/local/cloud/systemvm/conf/log4j-cloud.xml
2013-10-02 13:31:19,318 DEBUG [cloud.agent.AgentShell] (main:null) 
Checking to see if agent.SecStorage.pid exists.
2013-10-02 13:31:19,326 DEBUG [cloud.utils.ProcessUtil] (main:null) 
environment.properties could not be opened
2013-10-02 13:31:19,337 DEBUG [cloud.utils.ProcessUtil] (main:null) 
Executing: bash -c echo $PPID
2013-10-02 13:31:19,344 DEBUG [cloud.utils.ProcessUtil] (main:null) 
Execution is successful.
2013-10-02 13:31:19,345 ERROR [cloud.agent.AgentShell] (main:null) 
*Unable to start agent: Resource class not found: 
com.cloud.storage.resource.PremiumSecondaryStorageResource due to: 
java.lang.ClassNotFoundException: 
com.cloud.storage.resource.PremiumSecondaryStorageResource *



Can somebody help me with this?

Thanks,
 Peter ERDOSI


Re: Choosing VMWare SCSI Controller Type

2013-10-02 Thread Chris Sciarrino
I have reported it, the id is cloudstack-4787.


On Wed, Oct 2, 2013 at 2:53 PM, Francois Gaudreault 
fgaudrea...@cloudops.com wrote:

 We came across the same issue at some point in the past, but we decided to
 change the templates to reflect to proper controller. There might be a
 thread on the dev list around that.

 Let me know the bug id once you create it, one of our customer might need
 that feature.

 Francois


 On 2013-10-02 1:43 PM, Kelven Yang wrote:


 On 10/2/13 3:00 AM, Chris Sciarrino chris.sciarr...@gmail.com wrote:

  Hi Sean,

 I have tried this in 4.1.1 and 4.2. I have tried the HDD adapter type in
 the register template screen like you also suggested but that did not
 have
 an effect.

 Unless I am mistaken, I think that option will set the disk type to ide
 or
 scsi and not change the actual controller type that the scsi disk uses.

  Please report it as a feature-request bug, choosing controller type is
 not
 currently supported yet

 Kelven

  Thanks,

 Chris


 On Wed, Oct 2, 2013 at 5:16 AM, Sean Hamilton
 s...@seanhamilton.co.uk**wrote:

  Hey Chris,

 What version of CS are you running? I've seen a bug in the Register
 Template screen. If you select the location for the template it should
 open up more options, one of which is the HDD adapter type.

 Let me know how it goes.


 On 2 October 2013 05:12, Chris Sciarrino chris.sciarr...@gmail.com
 wrote:

  Hi,

 I am having an issue where my vmware templates are being deployed with

 the

 lsi parallel scsi controller type which is causing them to blue

 screen.
 Is

 there any way to choose which scsi controller type it will be deployed
 with? Or is there any other way to make it deploy the lsi sas

 controller?


 Thanks,

 Chris





 --
 Francois Gaudreault
 Architecte de Solution Cloud | Cloud Solutions Architect
 fgaudrea...@cloudops.com
 514-629-6775
 - - -
 CloudOps
 420 rue Guy
 Montréal QC  H3J 1S6
 www.cloudops.com
 @CloudOps_




Re: Cloudstack 4.1

2013-10-02 Thread Kirk Kosinski
Hi, the log shows a VM being destroyed, which doesn't match the
description of the problem.  If the description is correct, upload more
of the load to Pastebin.  The log that needs to be provided will most
likely include the error text from the UI.

Best regards,
Kirk

On 10/02/2013 09:59 AM, motty cruz wrote:
 Hello,
 I'm trying to build a VM but I get the following error Unable to create a
 deployment for VM[User]test4]
 
 primary storage is up CLVM,
 secondary storage nfs is up
 
 logs:
 2013-10-02 09:46:07,885 DEBUG [cloud.async.AsyncJobManagerImpl]
 (catalina-exec-1:null) submit async job-50, details: AsyncJobVO {id:50,
 userId: 2, accountId: 2, sessionKey: null, instanceT
 ype: VirtualMachine, instanceId: 8, cmd:
 org.apache.cloudstack.api.command.user.vm.DestroyVMCmd, cmdOriginator:
 null, cmdInfo: {id:9a48d353-f57a-46b4-8a32-3f09fa114409,response:json
 ,sessionkey:XXXUS8OPHkdR1qhkb8bAUYFHfps\u003d,ctxUserId:2,_:1380732367999,ctxAccountId:2,ctxStartEventId:204},
 cmdVersion: 0, callbackType: 0, callbackAddress: null, s
 tatus: 0, processStatus: 0, resultCode: 0, result: null, initMsid:
 73644477032, completeMsid: null, lastUpdated: null, lastPolled: null,
 created: null}
 2013-10-02 09:46:07,887 DEBUG [cloud.async.AsyncJobManagerImpl]
 (Job-Executor-3:job-50) Executing
 org.apache.cloudstack.api.command.user.vm.DestroyVMCmd for job-50
 2013-10-02 09:46:07,892 DEBUG [cloud.api.ApiServlet] (catalina-exec-1:null)
 ===END===  ... -- GET
  
 command=destroyVirtualMachineid=9a48d353-f57a-46b4-8a32-3f09fa114409response=j
 sonsessionkey=XXXUS8OPHkdR1qhkb8bAUYFHfps%3D_=1380732367999
 2013-10-02 09:46:07,946 DEBUG [cloud.vm.VirtualMachineManagerImpl]
 (Job-Executor-3:job-50) Destroying vm VM[User|test4]
 2013-10-02 09:46:07,947 DEBUG [cloud.vm.VirtualMachineManagerImpl]
 (Job-Executor-3:job-50) Stopped called on VM[User|test4] but the state is
 Error
 2013-10-02 09:46:07,963 DEBUG [cloud.capacity.CapacityManagerImpl]
 (Job-Executor-3:job-50) VM state transitted from :Error to Expunging with
 event: DestroyRequestedvm's original host id: n
 ull new host id: null host id before state transition: null
 2013-10-02 09:46:08,001 DEBUG [cloud.async.AsyncJobManagerImpl]
 (Job-Executor-3:job-50) Complete async job-50, jobStatus: 1, resultCode: 0,
 result: org.apache.cloudstack.api.response.UserV
 mResponse@2d453a4b
 2013-10-02 09:46:08,017 DEBUG [cloud.async.AsyncJobManagerImpl]
 (Job-Executor-3:job-50) Done executing
 org.apache.cloudstack.api.command.user.vm.DestroyVMCmd for job-50
 2013-10-02 09:46:10,931 DEBUG [cloud.api.ApiServlet] (catalina-exec-5:null)
 ===START===...-- GET
  
 command=queryAsyncJobResultjobId=16b35e61-cedd-4173-90ce-aad61486b001respons
 e=jsonsessionkey=XXXUS8OPHkdR1qhkb8bAUYFHfps%3D_=1380732371066
 2013-10-02 09:46:10,974 DEBUG [cloud.async.AsyncJobManagerImpl]
 (catalina-exec-5:null) Async job-50 completed
 2013-10-02 09:46:11,003 DEBUG [cloud.api.ApiServlet] (catalina-exec-5:null)
 ===END===... -- GET
  command=queryAsyncJobResultjobId=16b35e61-cedd-4173-90ce-aad6148
 


Re: cloudstack 4.1 GRE/SDN

2013-10-02 Thread murali reddy
Have you tried to create a new isolated network for the VM after setting
'sdn.ovs.controller' to  true? Please see
https://issues.apache.org/jira/browse/CLOUDSTACK-2878


On Thu, Oct 3, 2013 at 9:11 AM, Luca Salvatore l...@ninefold.com wrote:

 i'm trying to do some testing with cloudstack 4.1, specifically around the
 GRE and SDN features.
 I have configured the management server and I have two zones.  Everything
 is working well, I can deploy VMs in each zone and everything there is
 good. Each zone is configured with GRE isolation.
 When I changed the sdn.ovs.controller to true and tried to deploy VMs they
 all failed, weird thing is that they don't even appear in the management
 console in a error state, just nothing happens.  The logs do show an
 exception:


 2013-10-03 11:48:47,171 DEBUG [cloud.vm.VirtualMachineManagerImpl]
 (catalina-exec-20:null) Allocating entries for VM: VM[User|test1]
 2013-10-03 11:48:47,172 DEBUG [cloud.vm.VirtualMachineManagerImpl]
 (catalina-exec-20:null) Allocating nics for VM[User|test1]
 2013-10-03 11:48:47,173 DEBUG [cloud.network.NetworkManagerImpl]
 (catalina-exec-20:null) Allocating nic for vm VM[User|test1] in network
 Ntwk[208|Guest|8] with requested profile NicProfile[0-0-null-null-null
 2013-10-03 11:48:47,179 DEBUG [db.Transaction.Transaction]
 (catalina-exec-20:null) Rolling back the transaction: Time = 22 Name =
  createVirtualMachine; called by
 -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-TransactionContextBuilder.interceptException:63-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:133-VirtualMachineManagerImpl.allocate:304-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-CloudOrchestrator.createVirtualMachine:211-UserVmManagerImpl.createVirtualMachine:3384-ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept:125-UserVmManagerImpl.createAdvancedVirtualMachine:3101-DeployVMCmd.create:460
 2013-10-03 11:48:47,189 ERROR [cloud.api.ApiServer]
 (catalina-exec-20:null) unhandled exception executing api command:
 deployVirtualMachine
 java.lang.NullPointerException
 at
 com.cloud.network.NetworkManagerImpl.allocateNic(NetworkManagerImpl.java:1267)
 at
 com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
 at
 com.cloud.network.NetworkManagerImpl.allocate(NetworkManagerImpl.java:1206)
 at
 com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)
 at
 com.cloud.vm.VirtualMachineManagerImpl.allocate(VirtualMachineManagerImpl.java:304)
 at
 com.cloud.utils.component.ComponentInstantiationPostProcessor$InterceptorDispatcher.intercept(ComponentInstantiationPostProcessor.java:125)


 Not sure what is going on here.  Any thoughts?
 I'm using XenSever 6.1 with a single bond (2 NICs) for all networks, also
 using local storage for all VMs.
 Can't seem to find much doco on how to configure zones for SDN… Any help
 would be great

 Thanks
 Luca.










RE: cloudstack 4.1 KVM There no secondary storage for secondary VM

2013-10-02 Thread Sanjeev Neelarapu
If you have created the bridges as per the instructions in section 8.1.8.3. 
Configuring the network bridges then you need to specify those bridge names 
(e.g cloudbr0 and cloudbr1) as traffic labels in the physical network for 
respective traffics like guest and management traffic.  After this destroy all 
the vms (If any are already created) and re-launch. 

Hope this will solve the problem.

-Sanjeev



-Original Message-
From: motty cruz [mailto:motty.c...@gmail.com] 
Sent: Tuesday, October 01, 2013 11:05 PM
To: users@cloudstack.apache.org
Subject: Re: cloudstack 4.1 KVM There no secondary storage for secondary VM

yes, I did.however i think cloudstack traffic is trying to go through public 
network and NFS server in an a private network. each hypervisor has two network 
cards, public and private private is nic ifcfg-eth0 and public ifcfg-eth1


the management has only one network interface, configured to static on the 
private network(same subnet as nfs server)

I believe that my problem is network bridges on my hypervisor machine,  I 
followed this guide:
http://cloudstack.apache.org/docs/en-US/Apache_CloudStack/4.1.1/html/Installation_Guide/hypervisor-kvm-install-flow.html#hypervisor-kvm-requirements

but no success.



On Tue, Oct 1, 2013 at 9:08 AM, dave.hoff...@appcore.com wrote:

 Do you have an NFS share created and added to Cloudstack for it to use 
 as Secondary Storage?

 - Original Message -
 From: motty cruz motty.c...@gmail.com
 To: users@cloudstack.apache.org
 Sent: Monday, September 30, 2013 8:43:05 PM
 Subject: cloudstack 4.1 KVM There no secondary storage for secondary 
 VM

 Hello, I need help!
 I have installed CloudStack 4.1 on CentOS, I have two hypervisors KVM 
 running on CentOS 6.4. both KVM hypervison have 2 network cards one 
 have static public IP and 2nd has a private IP. can someone point the 
 steps to have basic network to run with CloudStack?

 currently I have cloudstack working but the error I'm getting is 
 There are no secondary storage for secondary VM I know is because my 
 network interfaces are not configure correctly.

 Thanks,
  Motty