Yes. Are you able to access the db vip or the two db nodes using mysql command from management server?
On Wednesday, May 29, 2024, Alexandru Stan <[email protected]> wrote: > You're right. This is the actual problem: > > Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to > initialize a connection to the database for locking purposes > Caused by: java.sql.SQLNonTransientConnectionException: Could not create > connection to database server. Attempted reconnect 3 times. Giving up. > > But everything seems right in the db.properties file. The host should be > the virtual ip of the load balancer, right? > > > -----Original Message----- > From: Wei ZHOU <[email protected]> > Sent: Wednesday, May 29, 2024 10:28 PM > To: [email protected] > Subject: Re: HA for management server > > Hi, > > The exception is misleading > > You can check the real exception by > grep Exception management-server.log | grep -v > NoSuchBeanDefinitionException > > I guess the root cause is database configuration or db.properties. > > By the way, it is better mariadb galera cluster have 3 servers. > > > -Wei > > > On Wednesday, May 29, 2024, Alexandru Stan > <[email protected]> > wrote: > > > Hello, > > > > There seems to be issues with installing the management server > > databases on a separate server, I setup a galera cluster with 2 > > servers and tried to install the management server on a different > > server using (where it still > > applies) this guide: https://www.shapeblue.com/how- > > to-deploy-high-availability-cloudstack-with-mariadb-galera-cluster/ > > > > However, while the database setup seems to be fine and everything > > after, the cloudstack-management service is running but there's no UI. > > Checking the status shows this: > > > > Failed to start module [redfish] due to: [Error creating bean with > > name 'org.springframework.beans.factory.config. > PropertyPlaceholderConfigurer#0' > > defined in URL [jar:file:/usr/share/cloudstack-management/lib/ > > cloudstack-4.19.0.1.jar!/META-INF/cloudstack/bootstrap/ > > spring-bootstrap-context-inheritable.xml]: Cannot resolve reference to > > bean 'DefaultConfigResources' while setting bean property 'locations'; > > nested exception is org.springframework.beans.factory. > NoSuchBeanDefinitionException: > > No bean named 'DefaultConfigResources' available]. > > > > Any idea why this happens? > > > > > > -----Original Message----- > > From: Jayanth Babu A <[email protected]> > > Sent: Monday, May 27, 2024 12:28 PM > > To: [email protected] > > Subject: Re: HA for management server > > > > Hello, > > Yes, DB clustering with Galera or some other sort should be looked into. > > I'm not sure if [1] has worked for someone so far. > > > > [1] https://docs.cloudstack.apache.org/en/latest/ > > adminguide/reliability.html#configuring-database-high-availability > > > > Thanks, > > Jayanth > > ________________________________ > > From: Alexandru Stan <[email protected]> > > Sent: Monday, May 27, 2024 2:48 PM > > To: [email protected] <[email protected]> > > Subject: RE: HA for management server > > > > Hi, > > > > Actually no, I'm just documenting the process so far, so nothing was > > done for the DB. For this I assume the info in the official > > documentation would be ok? Or something more advanced would be needed, > like a galera cluster? > > > > > > > > -----Original Message----- > > From: Jayanth Babu A <[email protected]> > > Sent: Monday, May 27, 2024 12:12 PM > > To: [email protected] > > Subject: Re: HA for management server > > > > Hello Alexandru, > > Please see [1] and [2]. I assume your DB HA is taken care of. > > > > [1] https://checkpoint.url-protection.com/v1/url?o=https% > > 3A//docs.cloudstack.apache.org/en/latest/adminguide/reliability.html&g > > = ZmEwYjAwNmYwMjIxNTU5ZQ==&h=NmQyMzY5Nzc5YTU2ZDkyYjc4N2ExND > > U4Y2Q0OWFkMjQ4OGRhMGZiZjdiNDA5N2NmNmRhM2EwYjUzZGEwMmI2Mg==&p= > > Y3AxZTpueHRnZW5pbmZpbml0ZWRhdGFjZW50ZXI6YzpvOmY0ZWFkYmU5NDkz > > MjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYxOnA6VA== > > [2] https://checkpoint.url-protection.com/v1/url?o=https% > > 3A//github.com/apache/cloudstack/issues/8221&g=YzVlNDk3YjI5NTEwMTM5Mg= > > =&h= > > OTBmN2Q4ZjA3YzRlOTAxZDk1YzcwMmExMTAzYTY4N2VmYjg5MGZkZGQyMDE2 > > NTM3MTU4MGUxNDRjNzMzN2E0ZQ==&p=Y3AxZTpueHRnZW5pbmZpbml0ZWRhdG > > FjZW50ZXI6YzpvOmY0ZWFkYmU5NDkzMjMyMjdjY2EyM2IxN2YzOGZiMWE4OnYxOnA6VA== > > > > Regards, > > Jayanth Reddy > > Engineering Manager > > > > From: Alexandru Stan <[email protected]> > > Date: Monday, 27 May 2024 at 2:38 PM > > To: [email protected] <[email protected]> > > Subject: HA for management server > > Hello, > > > > Is there any documentation on deployment of multiple management > > servers in high availability? Or does anyone have good info on this? > > The official documentation does not contain anything relevant > unfortunately. > > > > Thank you! > > Disclaimer *** This e-mail contains PRIVILEGED AND CONFIDENTIAL > > INFORMATION intended solely for the use of the addressee(s). If you > > are not the intended recipient, please notify the sender by e-mail and > > delete the original message. Further, you are not authorised to copy, > > disclose, or distribute this e-mail or its contents to any other > > person and any such actions are unlawful and strictly prohibited. This > > e-mail may contain viruses. NxtGen Datacenter & Cloud Technologies > > Private Ltd (“NxtGen”) has taken every reasonable precaution to > > minimize this risk but is not liable for any damage you may sustain as > > a result of any virus in this e-mail. You should carry out your own > > virus checks before opening the e-mail or attachment. NxtGen reserves > > the right to monitor and review the content of all messages sent to or > > from this e-mail address. Messages sent to or from this e-mail address > > may be stored on the NxtGen e-mail system. *** End of Disclaimer > > ***NXTGEN*** Disclaimer *** This e-mail contains PRIVILEGED AND > CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). > > If you are not the intended recipient, please notify the sender by > > e-mail and delete the original message. Further, you are not > > authorised to copy, disclose, or distribute this e-mail or its > > contents to any other person and any such actions are unlawful and > > strictly prohibited. This e-mail may contain viruses. NxtGen > > Datacenter & Cloud Technologies Private Ltd > > (“NxtGen”) has taken every reasonable precaution to minimize this risk > > but is not liable for any damage you may sustain as a result of any > > virus in this e-mail. You should carry out your own virus checks > > before opening the e-mail or attachment. NxtGen reserves the right to > > monitor and review the content of all messages sent to or from this > > e-mail address. Messages sent to or from this e-mail address may be > stored on the NxtGen e-mail system. > > *** End of Disclaimer ***NXTGEN*** > > >
