Poking the database directly
Answered
I was wondering if there was a way to poke the database directly and use that to show information in Team City directly instead of having to go through the REST API. I'm currently using a test setup with the internal database, but in the end, it would be used on an external database.
Please sign in to leave a comment.
Hello Simon,
Could you please describe what information do you want to see directly instead in TeamCity UI?
You can connect to the internal database directly and see the stored tables and data, see how to perform it: http://stackoverflow.com/questions/4918911/teamcity-ntlm-authentication-change-admin-user-lost-in-transition/8121719#8121719.
It would be to have a plugin on the server machine and use the information directly in the database instead of having to go through the REST API.
It would be used only to fetch information about users and their VCS changes so that we can create an alternative overview that would have as a main filter, the user's submitted changes and than for each of these, there would be the configurations that have failed, to make it easier to track which change is affecting what configuration.
Currently there is no such ability in TeamCity. You can create a plugin to get and show need information in TeamCity UI.
I have a large number of VCS roots defined for our TeamCity server, and we need to update all of them to start using the https secure socket connection. Is itt possible for me to just update the vcsroots teamcity table with the new address and have all of our VCS roots start using the new secure socket address that way? It will take a lot of time to manually edit every source root in teamcity web ui. We are on TeamCity v8.0.6 right now.