Cloudstack installation on Ubuntu Xenial

Hello Everyone, I'm getting myself familiar with CloudStack so please excuse if I have overlooked something obvious. Using build and install instructions from the official documentation I have managed to successfully install CloudStack 4.11 on the neasted CentOS 7.4 KVM (from both community

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Does ACS have a native support to Ceph? How is the storage setup in your hosts? How are you presenting this storage to ACS? On Mon, Mar 12, 2018 at 4:56 PM, McClune, James < mcclu...@norwalktruckers.net> wrote: > I'm using the UI to register storage. > > - James > > On Mon, Mar 12, 2018 at 3:50

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

I'm using the UI to register storage. - James On Mon, Mar 12, 2018 at 3:50 PM, Rafael Weingärtner < rafaelweingart...@gmail.com> wrote: > So, you are getting the error while adding the storage in ACS. Right? > I copied and pasted the SQL you have your logs, and I got this: > Error: Column

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Yes, I also got Error: Column 'host_address' cannot be null as well. I manually added my RADOS monitor IP for the host_address. Is this right? - James On Mon, Mar 12, 2018 at 3:51 PM, McClune, James < mcclu...@norwalktruckers.net> wrote: > Sorry if I confused you on upgrading from 4.9.3 to

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Sorry if I confused you on upgrading from 4.9.3 to 4.11.0. I decided to start from scratch and re-installed with 4.11.0. I did not use any old SQL backups from 4.9.3. - James On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner < rafaelweingart...@gmail.com> wrote: > When are you receiving this

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

So, you are getting the error while adding the storage in ACS. Right? I copied and pasted the SQL you have your logs, and I got this: Error: Column 'host_address' cannot be null SQLState: 23000 This is the SQL I executed, which is in one of your emails: > INSERT INTO storage_pool >

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

I started fresh with 4.11.0. The Ceph storage was already setup, however, I'm just now adding it to ACS. I get this error anytime I add primary storage. Secondary storage can be added with no problems. - James On Mon, Mar 12, 2018 at 3:39 PM, Rafael Weingärtner < rafaelweingart...@gmail.com>

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

When are you receiving this error? I mean, are you receiving it when you add the storage? Or, when you do something else? Was the storage already confgured? On Mon, Mar 12, 2018 at 4:35 PM, McClune, James < mcclu...@norwalktruckers.net> wrote: > I'm using Oracle MySQL. > > - James > > On Mon,

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

I'm using Oracle MySQL. - James On Mon, Mar 12, 2018 at 3:33 PM, Rafael Weingärtner < rafaelweingart...@gmail.com> wrote: > Well, you can delete the entry you just inserted. the idea to run the SQL > was to find the problem. > It is odd, I was expecting to be a missing column problem. What is

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Well, you can delete the entry you just inserted. the idea to run the SQL was to find the problem. It is odd, I was expecting to be a missing column problem. What is the DB that you are using? MariaDB or Oracle MySQL? On Mon, Mar 12, 2018 at 4:29 PM, McClune, James < mcclu...@norwalktruckers.net>

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Hi Rafael, I ran the SQL query and got these errors: When I deleted the *_binary* and *storage_pool.* from the query entries, it seemed to work. However, I'm still experiencing oddities: Some of my entries were 'null', when they shouldn't be. Any help is much appreciated. Thanks, James On

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

No, I'll try that right now. Thanks for the prompt reply Rafael. - James On Mon, Mar 12, 2018 at 3:06 PM, Rafael Weingärtner < rafaelweingart...@gmail.com> wrote: > Did you try running the insert that is causing the error manually? > > On Mon, Mar 12, 2018 at 4:04 PM, McClune, James < >

Re: Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Did you try running the insert that is causing the error manually? On Mon, Mar 12, 2018 at 4:04 PM, McClune, James < mcclu...@norwalktruckers.net> wrote: > Hello CloudStack Community, > > I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary storage > (Ceph RBD). The problem I'm

Failed to add data store: DB Exception on: com.mysql.jdbc.JDBC42PreparedStatement

Hello CloudStack Community, I just upgraded ACS from 4.9.3 to 4.11.0. I'm revamping my primary storage (Ceph RBD). The problem I'm experiencing is every time I try to re-add my Ceph storage pool, I get this error: - Something went wrong; please correct the following: Failed to add data

Re: KVM HostHA

> > Hi Jon, > > As I said, in my case, making the host HA didn't work but by just having a > HA VM running on host and executing - (WARNING) "echo c > > /proc/sysrq-trigger" to simulate a kernel crash on host, the management > server registered it as down and started the VM on another host. I know

RE: KVM HostHA

I tested using: echo c > /proc/sysrq-trigger which will crash the host. Kind regards, Paul Angus paul.an...@shapeblue.com  www.shapeblue.com 53 Chandos Place, Covent Garden, London WC2N 4HSUK @shapeblue -Original Message- From: Jon Marshall Sent: 12

Re: KVM HostHA

Hi Paul Thanks for the response. I think I am not understanding how it was meant to work then. My understanding was that the manager used ipmitool to just keep querying the compute nodes as to their status so I assumed it didn't matter how you shut the node down, once it was down the

RE: KVM HostHA

Hi Jon, I think that what you guys are finding, is that a controlled host shutdown, which will cause the agent to shutdown cleanly; Is not considered an HA event. I wouldn't expect CloudStack to take any action if you shut down a host, only if the host (agent) stops responding. Kind

Re: KVM HostHA

I have the same issue here and am not entirely sure what the behaviour should be. I have one manager node and 2 compute nodes running 4.11 with ipmi working correctly. >From the UI under HA - HA Enabled Yes HA State Available HA Provider kvmhaprovider although

Re: Storage Migration VPC ACS 4.5.2

Tks All, Now its ok, we can migrate and now update for ACS 4.9.2 Att / Regards Felipe Rossi Diretor de Negócios e Inovação Cloud Architect +55(45) 9911.60094 +55(45) 3326-4568 fel...@brascloud.com.br www.brascloud.com.br