Hi, I think there might be an issue with the command you executed. maybe refer to "cloudstack-setup-databases -h" for help
normally I use a command like cloudstack-setup-databases alex:founder@1.2.3.4 --deploy-as=root:nonsense -e file -m password -k dbpassword -i 10.20.30.40 -Wei On Tue, Feb 11, 2025 at 5:15 PM Chi vediamo <tatay...@gmail.com> wrote: > Please help, as I am lost, > > I read everything i can find about, even reinstalling, I create the DB and > installed with the command shown below: > > cloudstack-setup-databases cloud:rootpass@10.23.23.23 --schema-only -m > iknow -k somekey -i 10.23.23.21 -r 1 > > db server 10.23.23.23 cluster > management server 10.23.23.21 and secondary 10.23.23.22 > the database contains the tables. > > No connection errors to the DB. Mysql 8.0.40 > OS Ubuntu 22.04.5 > > > And I still got the 503 error. > > I don't see any table with data, but the tables were populated, and again > there are no errors on the Mysql server side. > > > > the management server /var/log/cloudstack/management/management-server.out > > shows only this reapeated times. > > 2025-02-11 15:48:54,030 main ERROR TcpSocketManager (TCP:localhost:4560) > caught exception and will continue: java.io.IOException: Unable to create > socket for localhost at port 4560 using ip address 127.0.0.1 and port 4560 > at > org.apache.logging.log4j.core.net.TcpSocketManager$TcpSocketManagerFactory.createSocket(TcpSocketManager.java:509) > at > org.apache.logging.log4j.core.net.TcpSocketManager$TcpSocketManagerFactory.createManager(TcpSocketManager.java:478) > at > org.apache.logging.log4j.core.net.TcpSocketManager$TcpSocketManagerFactory.createManager(TcpSocketManager.java:459) > at > org.apache.logging.log4j.core.appender.AbstractManager.getManager(AbstractManager.java:144) > at > org.apache.logging.log4j.core.appender.OutputStreamManager.getManager(OutputStreamManager.java:100) > at > org.apache.logging.log4j.core.net.TcpSocketManager.getSocketManager(TcpSocketManager.java:202) > at > org.apache.logging.log4j.core.appender.SocketAppender.createSocketManager(SocketAppender.java:497) > at > org.apache.logging.log4j.core.appender.SyslogAppender$Builder.build(SyslogAppender.java:151) > at > org.apache.logging.log4j.core.appender.SyslogAppender$Builder.build(SyslogAppender.java:50) > at > org.apache.logging.log4j.core.config.plugins.util.PluginBuilder.build(PluginBuilder.java:124) > at > org.apache.logging.log4j.core.config.AbstractConfiguration.createPluginObject(AbstractConfiguration.java:1138) > at > org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1063) > at > org.apache.logging.log4j.core.config.AbstractConfiguration.createConfiguration(AbstractConfiguration.java:1055) > at > org.apache.logging.log4j.core.config.AbstractConfiguration.doConfigure(AbstractConfiguration.java:664) > at > org.apache.logging.log4j.core.config.AbstractConfiguration.initialize(AbstractConfiguration.java:258) > at > org.apache.logging.log4j.core.config.AbstractConfiguration.start(AbstractConfiguration.java:304) > at > org.apache.logging.log4j.core.LoggerContext.setConfiguration(LoggerContext.java:621) > at > org.apache.logging.log4j.core.LoggerContext.reconfigure(LoggerContext.java:694) > at > org.apache.logging.log4j.core.LoggerContext.reconfigure(LoggerContext.java:711) > at > org.apache.logging.log4j.core.LoggerContext.start(LoggerContext.java:253) > at > org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:155) > at > org.apache.logging.log4j.core.impl.Log4jContextFactory.getContext(Log4jContextFactory.java:47) > at > org.apache.logging.log4j.LogManager.getContext(LogManager.java:196) > at > org.apache.logging.log4j.LogManager.getLogger(LogManager.java:599) > at org.apache.cloudstack.ServerDaemon.<init>(ServerDaemon.java:65) > at org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:110) > Caused by: java.net.ConnectException: Connection refused > at java.base/sun.nio.ch.Net.connect0(Native Method) > at java.base/sun.nio.ch.Net.connect(Net.java:579) > at java.base/sun.nio.ch.Net.connect(Net.java:568) > at java.base/sun.nio.ch > .NioSocketImpl.connect(NioSocketImpl.java:593) > at java.base/java.net > .SocksSocketImpl.connect(SocksSocketImpl.java:327) > at java.base/java.net.Socket.connect(Socket.java:633) > at > org.apache.logging.log4j.core.net.TcpSocketManager.createSocket(TcpSocketManager.java:409) > at > org.apache.logging.log4j.core.net.TcpSocketManager$TcpSocketManagerFactory.createSocket(TcpSocketManager.java:504) > ... 25 more > > 2025-02-11 15:48:54,042 main ERROR appenders Appenders has no parameter > that matches element properties > > > On Feb 10, 2025, at 7:06 PM, Chi vediamo <tatay...@gmail.com> wrote: > > > > Is a fresh Install > > > > I have the same issue with 4.20, with Mysql 8.0 > > > > My DB is in a separate server, > > > > I try to find the "spring-bootstrap-context-inheritable.xml" which is > missing !! > > > > > > > > I follow the basic install with a separate DB. which completed as > successful. > > > > cloudstack-setup-databases cloud:rootpass@10.23.23.23 --schema-only -m > iknow -k somekey -i 10.23.23.21 -r 1 > > Mysql user name:cloud > [ OK ] > > Mysql user password:****** > [ OK ] > > Mysql server ip:10.23.23.23 > [ OK ] > > Mysql server port:3306 > [ OK ] > > Using specified cluster management server node IP 10.23.23.21 > [ OK ] > > Checking Cloud database files ... > [ OK ] > > Checking local machine hostname ... > [ OK ] > > Checking SELinux setup ... > [ OK ] > > Preparing /etc/cloudstack/management/db.properties > [ OK ] > > Applying /usr/share/cloudstack-management/setup/create-schema.sql > [ OK ] > > Applying > /usr/share/cloudstack-management/setup/create-schema-premium.sql [ OK > ] > > Applying /usr/share/cloudstack-management/setup/server-setup.sql > [ OK ] > > Applying /usr/share/cloudstack-management/setup/templates.sql > [ OK ] > > Processing encryption ... > [ OK ] > > Finalizing setup ... > [ OK ] > > > > CloudStack has successfully initialized database, you can check your > database configuration in /etc/cloudstack/management/db.properties > > > > All firewalls are down for now. > > > > > > my tail log is very simple: > > > > tail -f /var/log/cloudstack/management/management-server.log > > 2025-02-10 23:00:35,420 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] > (main:[]) (logid:) Encryption Type: file > > 2025-02-10 23:41:24,440 INFO [o.a.c.ServerDaemon] (main:[]) (logid:) > Server configuration file found: > /etc/cloudstack/management/server.properties > > 2025-02-10 23:41:24,446 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] > (main:[]) (logid:) Encryption Type: null > > 2025-02-10 23:41:24,449 INFO [o.a.c.ServerDaemon] (main:[]) (logid:) > Initializing server daemon on null, with http.enable=true, http.port=8080, > https.enable=true, https.port=8443, context.path=/client > > 2025-02-10 23:41:33,784 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:[]) (logid:) Loading module context [bootstrap] from URL > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.20.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context.xml] > > 2025-02-10 23:41:33,784 INFO [o.a.c.s.m.m.i.DefaultModuleDefinitionSet] > (main:[]) (logid:) Loading module context [bootstrap] from URL > [jar:file:/usr/share/cloudstack-management/lib/cloudstack-4.20.0.0.jar!/META-INF/cloudstack/bootstrap/spring-bootstrap-context-inheritable.xml] > > 2025-02-10 23:41:33,868 DEBUG [c.c.u.c.EncryptionSecretKeyChecker] > (main:[]) (logid:) Encryption Type: file > > > > Tata Y. > > > > > >> On Jan 27, 2025, at 3:35 AM, ManuFe (via GitHub) <g...@apache.org> > wrote: > >> > >> > >> GitHub user ManuFe closed a discussion: Error accessing Cloudstack UI > after installation > >> > >> Hello team, > >> > >> I've took interest in CloudStack a few days ago and tried to install > it. I've got success but now I have a problem accessing the client UI in my > browser. > >> > >> My system for test is Ubuntu 18.04.6 LTS and CloudStack Relase is > 4.20.0.0. I've followed the steps at > https://docs.cloudstack.apache.org/en/4.20.0.0/installguide/management-server/index.html > >> > >> Type of installation is single node management server with nfs and db > on same host. > >> > >> Java version: > >> ``` > >> openjdk 11.0.19 2023-04-18 > >> OpenJDK Runtime Environment (build > 11.0.19+7-post-Ubuntu-0ubuntu118.04.1) > >> OpenJDK 64-Bit Server VM (build 11.0.19+7-post-Ubuntu-0ubuntu118.04.1, > mixed mode, sharing) > >> ``` > >> MySql version: > >> `mysql Ver 14.14 Distrib 5.7.42, for Linux (x86_64) using EditLine > wrapper` > >> > >> Database is configure and I have all grants for cloud user. I can > access the database at localhost with no problem with command > >> `mysql -u cloud -p cloud -h localhost` > >> > >> and the grants > >> ``` > >> mysql> show grants; > >> +----------------------------------------------------------------+ > >> | Grants for cloud@localhost | > >> +----------------------------------------------------------------+ > >> | GRANT PROCESS ON *.* TO 'cloud'@'localhost' | > >> | GRANT ALL PRIVILEGES ON `cloud`.* TO 'cloud'@'localhost' | > >> | GRANT ALL PRIVILEGES ON `cloud_usage`.* TO 'cloud'@'localhost' | > >> +----------------------------------------------------------------+ > >> ``` > >> This is part of my db.properties > >> ``` > >> # management server clustering parameters, change cluster.node.IP to > the machine IP address > >> # in which the management server is running > >> cluster.node.IP=127.0.0.1 > >> cluster.servlet.port=9090 > >> region.id=1 > >> > >> # CloudStack database settings > >> db.cloud.username=cloud > >> db.cloud.password=ENC(nV8er4pYAlcF8Fw/UK56Z7AL9CYPkPIwyKP6IsHbhFLM) > >> db.cloud.host=localhost > >> db.cloud.driver=jdbc:mysql > >> db.cloud.port=3306 > >> db.cloud.name=cloud > >> ``` > >> > >> And this is output of command for service status > >> ``` > >> systemctl status cloudstack-management > >> cloudstack-management.service - CloudStack Management Server > >> Loaded: loaded (/lib/systemd/system/cloudstack-management.service; > enabled; vendor preset: enabled) > >> Active: active (running) since Sun 2025-01-26 13:20:11 CET; 40min ago > >> Main PID: 5358 (java) > >> ``` > >> which shows some errors (i guess) in the second part > >> ``` > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.util.component.ContainerLifeCycle.start(ContainerLifeCycle.java:169) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.server.Server.start(Server.java:423) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.util.component.ContainerLifeCycle.doStart(ContainerLifeCycle.java:110) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.server.handler.AbstractHandler.doStart(AbstractHandler.java:97) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.server.Server.doStart(Server.java:387) > >> gen 26 13:20:21 mypc java[5358]: at > org.eclipse.jetty.util.component.AbstractLifeCycle.start(AbstractLifeCycle.java:73) > >> gen 26 13:20:21 mypc java[5358]: at > org.apache.cloudstack.ServerDaemon.start(ServerDaemon.java:199) > >> gen 26 13:20:21 mypc java[5358]: at > org.apache.cloudstack.ServerDaemon.main(ServerDaemon.java:112) > >> ``` > >> > >> As of now I cannot access the http://localhost:8080/client/ address as > it shows http 503. > >> > >> Netstat output > >> ``` > >> netstat -tulpn | grep 8080 > >> tcp6 0 0 :::8080 :::* > LISTEN 5358/java > >> ``` > >> > >> You can find attached my log > >> [log.txt](https://github.com/user-attachments/files/18550118/log.txt) > >> > >> There is a single sql exception about creating a table that already > exists. > >> ``` > >> 2025-01-26 11:00:34,007 ERROR [c.c.u.DatabaseUpgradeChecker] (main:[]) > (logid:) Unable to execute upgrade script java.sql.SQLSyntaxErrorException: > Table 'nsx_providers' already exists > >> 2025-01-26 11:00:34,008 ERROR [c.c.u.DatabaseUpgradeChecker] (main:[]) > (logid:) Unable to upgrade the database > com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade > script > >> Caused by: java.sql.SQLSyntaxErrorException: Table 'nsx_providers' > already exists > >> ``` > >> > >> But relevant part of log seems linked to Bean Definition. There are > many errors (under DEBUG/WARN) like this for different modules. > >> `[o.a.c.s.m.m.i.DefaultModuleDefinitionSet] (main:[]) (logid:) Failed > to start module [storage-volume-flasharray] 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.20.0.0.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]` > >> > >> How can I resolve? > >> > >> Thank you for any help. > >> > >> GitHub link: https://github.com/apache/cloudstack/discussions/10276 > >> > >> ---- > >> This is an automatically sent email for users@cloudstack.apache.org. > >> To unsubscribe, please send an email to: > users-unsubscr...@cloudstack.apache.org > >> > > > >
