How to connect Teamcity server to an old DB and old folder into the Docker container

Hi All
I migrated my Teamcity server from version 2023.11 to 2023.11.3 three months ago. Recently, I updated my HTTPS certification key and restarted the server.However, upon doing so, I encountered an error, I  am unable to connect to the old DB. Could you  please assist me in resolving this issue? 

 

 

2024-06-14T02:46:51.158189873Z /run-server.sh

2024-06-14T02:46:51.158233680Z TeamCity server.xml parameter: -config conf/server.xml

2024-06-14T02:46:51.158275992Z Java executable is found: '/opt/java/openjdk/bin/java'

2024-06-14T02:46:51.158314150Z 2024-06-14 02:46:50 UTC: Starting TeamCity server

2024-06-14T02:46:51.158353352Z 2024-06-14 02:46:50 UTC: TeamCity process PID is 137

2024-06-14T02:46:51.158414614Z NOTE: Picked up JDK_JAVA_OPTIONS:  --add-opens jdk.management/com.sun.management.internal=ALL-UNNAMED -XX:+IgnoreUnrecognizedVMOptions --add-opens=java.base/java.lang=ALL-UNNAMED --add-opens=java.base/java.io=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED --add-opens=java.base/java.util.concurrent=ALL-UNNAMED --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED

2024-06-14T02:46:52.543600183Z 14-Jun-2024 02:46:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Name:               Linux

2024-06-14T02:46:52.543643004Z 14-Jun-2024 02:46:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log OS Version:            4.4.180+

2024-06-14T02:46:52.543674711Z 14-Jun-2024 02:46:51.767 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Architecture:          amd64

2024-06-14T02:46:52.543735492Z 14-Jun-2024 02:46:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Java Home:             /opt/java/openjdk

2024-06-14T02:46:52.543771536Z 14-Jun-2024 02:46:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Version:           17.0.7+7-LTS

2024-06-14T02:46:52.543812969Z 14-Jun-2024 02:46:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log JVM Vendor:            Amazon.com Inc.

2024-06-14T02:46:52.543853572Z 14-Jun-2024 02:46:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_BASE:         /opt/teamcity

2024-06-14T02:46:52.543884720Z 14-Jun-2024 02:46:51.768 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log CATALINA_HOME:         /opt/teamcity

2024-06-14T02:46:52.543915563Z 14-Jun-2024 02:46:52.042 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=jdk.management/com.sun.management.internal=ALL-UNNAMED

2024-06-14T02:46:52.543959281Z 14-Jun-2024 02:46:52.042 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -XX:+IgnoreUnrecognizedVMOptions

2024-06-14T02:46:52.543995205Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.lang=ALL-UNNAMED

2024-06-14T02:46:52.544029249Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.io=ALL-UNNAMED

2024-06-14T02:46:52.544063903Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util=ALL-UNNAMED

2024-06-14T02:46:52.544096399Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.base/java.util.concurrent=ALL-UNNAMED

2024-06-14T02:46:52.544137764Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: --add-opens=java.rmi/sun.rmi.transport=ALL-UNNAMED

2024-06-14T02:46:52.544179449Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.config.file=/opt/teamcity/conf/logging.properties

2024-06-14T02:46:52.544228213Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.util.logging.manager=org.apache.juli.ClassLoaderLogManager

2024-06-14T02:46:52.544265931Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djdk.tls.ephemeralDHKeySize=2048

2024-06-14T02:46:52.544307800Z 14-Jun-2024 02:46:52.043 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Djava.protocol.handler.pkgs=org.apache.catalina.webresources

2024-06-14T02:46:52.544351902Z 14-Jun-2024 02:46:52.044 INFO [main] org.apache.catalina.startup.VersionLoggerListener.log Command line argument: -Dorg.apache.catalina.security.SecurityListener.UMASK=0027

2024-06-14T02:46:52.909003016Z 14-Jun-2024 02:46:52.908 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["http-nio-8111"]

2024-06-14T02:46:52.947425915Z 14-Jun-2024 02:46:52.947 INFO [main] org.apache.coyote.AbstractProtocol.init Initializing ProtocolHandler ["https-jsse-nio-8543"]

2024-06-14T02:46:53.521283820Z 14-Jun-2024 02:46:53.520 INFO [main] org.apache.tomcat.util.net.AbstractEndpoint.logCertificate Connector [https-jsse-nio-8543], TLS virtual host [_default_], certificate type [UNDEFINED] configured from keystore [/opt/teamcity/cert/mykeystore.jks] using alias [tomcat] with trust store [null]

2024-06-14T02:46:53.523899195Z 14-Jun-2024 02:46:53.523 INFO [main] org.apache.catalina.startup.Catalina.load Server initialization in [2455] milliseconds

2024-06-14T02:46:53.590939341Z 14-Jun-2024 02:46:53.590 INFO [main] org.apache.catalina.core.StandardService.startInternal Starting service [Catalina]

2024-06-14T02:46:53.591262796Z 14-Jun-2024 02:46:53.590 INFO [main] org.apache.catalina.core.StandardEngine.startInternal Starting Servlet engine: [Apache Tomcat/9.0.83]

2024-06-14T02:46:53.599982406Z 14-Jun-2024 02:46:53.599 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deploying web application directory [/opt/teamcity/webapps/ROOT]

2024-06-14T02:46:57.036337961Z

2024-06-14T02:46:57.165335739Z

2024-06-14T02:47:03.856042159Z Using logs directory "/opt/teamcity/logs"

2024-06-14T02:47:03.929602755Z Log4J configuration file /opt/teamcity/bin/../conf/teamcity-server-log4j.xml will be monitored with interval 10 seconds.

2024-06-14T02:47:04.010433428Z 14-Jun-2024 02:47:04.009 INFO [main] org.apache.catalina.startup.HostConfig.deployDirectory Deployment of web application directory [/opt/teamcity/webapps/ROOT] has finished in [10,410] ms

2024-06-14T02:47:04.014243775Z 14-Jun-2024 02:47:04.013 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["http-nio-8111"]

2024-06-14T02:47:04.027984512Z 14-Jun-2024 02:47:04.027 INFO [main] org.apache.coyote.AbstractProtocol.start Starting ProtocolHandler ["https-jsse-nio-8543"]

2024-06-14T02:47:04.040439145Z 14-Jun-2024 02:47:04.039 INFO [main] org.apache.catalina.startup.Catalina.start Server startup in [10516] milliseconds

2024-06-14T02:47:04.192439060Z TeamCity version: 2023.11.3 (build 147512), data format version 1003

2024-06-14T02:47:04.192597344Z OS: Linux, version 4.4.180+, amd64, Current user: tcuser, Time zone: UTC

2024-06-14T02:47:04.208965306Z WARNING: A terminally deprecated method in java.lang.System has been called

2024-06-14T02:47:04.209116331Z WARNING: System::setSecurityManager has been called by jetbrains.buildServer.serverSide.impl.SecondaryNodeSecurityManager (file:/opt/teamcity/webapps/ROOT/WEB-INF/lib/ro-server-util.jar)

2024-06-14T02:47:04.209196160Z WARNING: Please consider reporting this to the maintainers of jetbrains.buildServer.serverSide.impl.SecondaryNodeSecurityManager

2024-06-14T02:47:04.209269057Z WARNING: System::setSecurityManager will be removed in a future release

2024-06-14T02:47:04.309674336Z [2024-06-14 02:47:04,308]   WARN [:03.700), node id: MAIN_SERVER] -  jetbrains.buildServer.STARTUP - Data directory '/data/teamcity_server/datadir' contains non-TeamCity files and directories: [test, test1, env.txt, 1, backup.sh.bak, backup_willie, upload.sh, backup.sh, database.postgresql.properties.dist.bak, iotsw-thetis.veretos.com, database.properties.bak]

2024-06-14T02:47:12.334844482Z [2024-06-14 02:47:12,334]  ERROR [:03.700), node id: MAIN_SERVER] -  jetbrains.buildServer.STARTUP - Found a TeamCity schema when expected an empty database

Log 


 

 


Teamcity container with Postgres in the the NSA server
 

Database.properties location and content 
 

 



PostgreDB


Thanks,

Willie 

0

Please sign in to leave a comment.