URGENT PLEASE - Proyects missing in TC1.2

I've restarted tomcat, and now we have no more proyects defined in TC... !
Where did they go??

This is the tomcat's log:



log4j:WARN No appenders could be found for logger
(org.apache.commons.digester.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
ERROR - ectionsMessageProcessorFactory -
java.sql.SQLException: Table already exists: INSPECTION_RESULTS in statement

WARN - ildTriggers.vcs.vss.VssSupport - Unable
to run SourceSafe VcsSupport under non-windows OS
ERROR - b.impl.BuildServerConfigurator - Problem
reading /home/seti/.BuildServer/config/main-config.xml

org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback;
uncategorized SQLException for SQL []; SQL state ; error code ;
S1000 General error java.lang.NullPointerException in statement [SELECT *
FROM vcs_history WHERE PROJECT_ID = ? AND VCS_ROOT = ? ORDER BY
MODIFICATION_ID DESC]; nested exception is java.sql.SQLException: S1000
General error java.lang.NullPointerException in statement [SELECT * FROM
vcs_history WHERE PROJECT_ID = ? AND VCS_ROOT = ? ORDER BY MODIFICATION_ID
DESC]
java.sql.SQLException: S1000 General error java.lang.NullPointerException in
statement [SELECT * FROM vcs_history WHERE PROJECT_ID = ? AND VCS_ROOT = ?
ORDER BY MODIFICATION_ID DESC]
at org.hsqldb.jdbc.Util.throwError(Unknown Source)
at org.hsqldb.jdbc.jdbcPreparedStatement.executeQuery(Unknown
Source)
at
org.apache.commons.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:92)
at
jetbrains.buildServer.serverSide.impl.query.Query.executeQuery(Query.java:8)
at
jetbrains.buildServer.serverSide.impl.query.LastModificationQuery.exec(LastModificationQuery.java:1)
at
jetbrains.buildServer.vcs.impl.DBVcsModificationHistory$5.run(DBVcsModificationHistory.java:1)
at
jetbrains.buildServer.serverSide.impl.DBFacade$14.doInConnection(DBFacade.java:2)
at
jetbrains.buildServer.serverSide.impl.DBFacade$16.doInConnection(DBFacade.java:1)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:230)
at
jetbrains.buildServer.serverSide.impl.DBFacade._runSql(DBFacade.java:118)
at
jetbrains.buildServer.serverSide.impl.DBFacade.runSql(DBFacade.java:169)
at
jetbrains.buildServer.vcs.impl.DBVcsModificationHistory.getLastModification(DBVcsModificationHistory.java:62)
at
jetbrains.buildServer.serverSide.impl.BuildServerImpl.createVcsChangesLoader(BuildServerImpl.java:329)
at
jetbrains.buildServer.serverSide.impl.ProjectImpl.addVcsRoot(ProjectImpl.java:107)
at
jetbrains.buildServer.serverSide.impl.XmlConfigurationExternalizer.readVcsRoots(XmlConfigurationExternalizer.java:126)
at
jetbrains.buildServer.serverSide.impl.XmlConfigurationExternalizer.readProject(XmlConfigurationExternalizer.java:135)
at
jetbrains.buildServer.serverSide.impl.XmlConfigurationExternalizer.readProjects(XmlConfigurationExternalizer.java:123)
at
jetbrains.buildServer.serverSide.impl.ProjectManagerImpl.loadProjects(ProjectManagerImpl.java:134)
at
jetbrains.buildServer.serverSide.impl.XmlConfigurationExternalizer$2.doInTransactionWithoutResult(XmlConfigurationExternalizer.java:0)
at
org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33)
at
org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:114)
at
jetbrains.buildServer.serverSide.impl.XmlConfigurationExternalizer.fillServer(XmlConfigurationExternalizer.java:287)
at
jetbrains.buildServer.serverSide.impl.XmlConfigurationExternalizer.fillServer(XmlConfigurationExternalizer.java:283)
at
jetbrains.buildServer.web.impl.BuildServerConfigurator.setupBuildServer(BuildServerConfigurator.java:35)
at
jetbrains.buildServer.web.impl.BuildServerConfigurator.loadConfiguration(BuildServerConfigurator.java:53)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeCustomInitMethod(AbstractAutowireCapableBeanFactory.java:1133)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1095)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:396)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:283)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)
at
org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)
at
org.springframework.web.servlet.FrameworkServlet.createWebApplicationContext(FrameworkServlet.java:306)
at
org.springframework.web.servlet.FrameworkServlet.initWebApplicationContext(FrameworkServlet.java:251)
at
org.springframework.web.servlet.FrameworkServlet.initServletBean(FrameworkServlet.java:220)
at
org.springframework.web.servlet.HttpServletBean.init(HttpServletBean.java:112)
at javax.servlet.GenericServlet.init(GenericServlet.java:211)
at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1105)
at
org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:932)
at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3917)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4201)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:527)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Mar 16, 2007 11:49:18 AM org.displaytag.properties.TableProperties INFO: Was not able to load a displaytag.properties; Can't find bundle for base name displaytag, locale en_US Mar 16, 2007 11:49:18 AM org.displaytag.properties.TableProperties ]]>
INFO: Was not able to load a displaytag.properties; Can't find bundle for
base name displaytag, locale en_US


8 comments
Comment actions Permalink

Gaston, to restore projects please try to do the following:

- shutdown server
- go to $HOME/.BuildServer
- move system -> system.old
- create empty system directory
- copy system.old/license.keys to system/ directory
- start the server

In this situation you're likely to loose user settings and build history, but your configurations will remain intact.
We recommend using Mysql in production environment, really sorry for inconvenience.
Hope this helps,
KIR

0
Comment actions Permalink

Kirill,

I'm going to do that.

Is there any way to backup users? I don't mind build history



"Kirill Maximov (JetBrains)" <no_reply@jetbrains.com> wrote in message
news:21052738.1174059042059.JavaMail.itn@is.intellij.net...

Gaston, to restore projects please try to do the following:

>

- shutdown server
- go to $HOME/.BuildServer
- move system -> system.old
- create empty system directory
- copy system.old/license.keys to system/ directory
- start the server

>

In this situation you're likely to loose user settings and build history,
but your configurations will remain intact.
We recommend using Mysql in production environment, really sorry for
inconvenience.
Hope this helps,
KIR



0
Comment actions Permalink

Gaston,

I'm afraid you faced database corruption.
We've had several reports like yours, so we're going to encourage all users to switch to Mysql when they're going to use TeamCity in production environment.

Kind regards,
KIR

0
Comment actions Permalink

Perhaps, we will need further instructions to do so.

Best regards,
Gaston



"Kirill Maximov (JetBrains)" <no_reply@jetbrains.com> wrote in message
news:21147812.1174064749898.JavaMail.itn@is.intellij.net...

Gaston,

>

I'm afraid you faced database corruption.
We've had several reports like yours, so we're going to encourage all
users to switch to Mysql when they're going to use TeamCity in production
environment.

>

Kind regards,
KIR



0
Comment actions Permalink

Gaston,

To setup Mysql in TeamCity 1.2, please search for 'mysql' string in our FAQ at
http://www.jetbrains.net/confluence/display/TW/TeamCity+FAQ

Please note, that in Agra we have another way to configure database:
http://www.jetbrains.net/confluence/display/TCD/Installation#Installation-SettingupMySQL

Hope this helps,
KIR

0
Comment actions Permalink

Kiril, I'm doing exactly what the FAQ told me to do... but that's not
working!

(here is the tomcat log) (this is a stand-alone tomcat installation)

log4j:WARN No appenders could be found for logger
(org.apache.commons.digester.Digester.sax).
log4j:WARN Please initialize the log4j system properly.
WARN - erver.serverSide.impl.DBFacade - Current
number of connections in pool (active/idle): 0/0
ERROR - work.web.context.ContextLoader - Context
initialization failed
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'buildServer' defined in ServletContext resource
: Instantiation of bean failed; nested
exception is org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class
: Constructor threw
exception; nested exception is
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
org.springframework.beans.BeanInstantiationException: Could not instantiate
bean class :
Constructor threw exception; nested exception is
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)
at
org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getConnection(TransactionAwareDataSourceProxy.java:107)
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)
at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at
jetbrains.buildServer.serverSide.impl.ConnectionPool.alloc(ConnectionPool.java:0)
at
jetbrains.buildServer.serverSide.versioning.VersionManager.convert(VersionManager.java:41)
at
jetbrains.buildServer.serverSide.impl.BuildServerImpl.]]>(BuildServerImpl.java:301)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at
org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:171)
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:78)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:703)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:358)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:283)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)
at
org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)
at
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:527)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
... 46 more
ERROR - alina].[localhost].[/teamcity] -
Exception sending context initialized event to listener instance of class
org.springframework.web.context.ContextLoaderListener
org.springframework.beans.factory.BeanCreationException: Error creating bean
with name 'buildServer' defined in ServletContext resource
: Instantiation of bean failed; nested
exception is org.springframework.beans.BeanInstantiationException: Could not
instantiate bean class
: Constructor threw
exception; nested exception is
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
org.springframework.beans.BeanInstantiationException: Could not instantiate
bean class :
Constructor threw exception; nested exception is
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get
JDBC Connection; nested exception is
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
org.apache.commons.dbcp.SQLNestedException: Cannot load JDBC driver class
'com.mysql.jdbc.Driver'
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
at
org.apache.commons.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)
at
org.springframework.jdbc.datasource.TransactionAwareDataSourceProxy.getConnection(TransactionAwareDataSourceProxy.java:107)
at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:112)
at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
at
jetbrains.buildServer.serverSide.impl.ConnectionPool.alloc(ConnectionPool.java:0)
at
jetbrains.buildServer.serverSide.versioning.VersionManager.convert(VersionManager.java:41)
at
jetbrains.buildServer.serverSide.impl.BuildServerImpl.]]>(BuildServerImpl.java:301)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method)
at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
at
org.springframework.beans.BeanUtils.instantiateClass(BeanUtils.java:171)
at
org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:78)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.autowireConstructor(AbstractAutowireCapableBeanFactory.java:703)
at
org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:358)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:233)
at
org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:145)
at
org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:283)
at
org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:313)
at
org.springframework.web.context.support.AbstractRefreshableWebApplicationContext.refresh(AbstractRefreshableWebApplicationContext.java:139)
at
org.springframework.web.context.ContextLoader.createWebApplicationContext(ContextLoader.java:252)
at
org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:190)
at
org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:49)
at
org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3729)
at
org.apache.catalina.core.StandardContext.start(StandardContext.java:4187)
at
org.apache.catalina.manager.ManagerServlet.start(ManagerServlet.java:1175)
at
org.apache.catalina.manager.HTMLManagerServlet.start(HTMLManagerServlet.java:527)
at
org.apache.catalina.manager.HTMLManagerServlet.doGet(HTMLManagerServlet.java:104)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at
org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:524)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
at
org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
at
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1352)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1198)
at java.lang.ClassLoader.loadClassInternal(ClassLoader.java:319)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:164)
at
org.apache.commons.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:760)
... 46 more
Mar 20, 2007 3:01:48 PM org.apache.catalina.core.StandardContext start
SEVERE: Error listenerStart
Mar 20, 2007 3:01:48 PM org.apache.catalina.core.StandardContext start
SEVERE: Context startup failed due to previous errors



Advanced topics

How to configure MySQL database?
TeamCity supports MySQL version 4.1.18 and later or MySQL 5.0.X and later.
InnoDB is required and should be configured
as default engine. To configure TeamCity to use MySQL database:

1. Download mysql jdbc driver from
http://dev.mysql.com/downloads/connector/j/5.0.html and
put jar file to webapps/ROOT/WEB-INF/lib directory of TeamCity.
2. Shutdown TeamCity server.
3. Modify database configuration in general Spring configuration file. It is
located in the
/WEB-INF/buildServerSpring.xml file within the exploded TeamCity
application. Just specify appropriate settings for
mysqlDbSettings bean, and set reference to mysqlDbSettings in the
buildServer bean definition.
4. Create database with the name specified in the connectionUrl property of
mysqlDbSettings bean. You should choose one-byte charset for the database
(latin1 and the like), multi-byte charsets (like UTF) are not supported by
TeamCity.
5. Grant necessary access rigths for the user specified in the
mysqlDbSettings bean.
6. Start TeamCity server.







"Kirill Maximov (JetBrains)" <no_reply@jetbrains.com> wrote in message
news:811302.1174076581808.JavaMail.itn@is.intellij.net...

Gaston,

>

To setup Mysql in TeamCity 1.2, please search for 'mysql' string in our
FAQ at
http://www.jetbrains.net/confluence/display/TW/TeamCity+FAQ

>

Please note, that in Agra we have another way to configure database:

http://www.jetbrains.net/confluence/display/TCD/Installation#Installation-SettingupMySQL

>

Hope this helps,
KIR






Attachment(s):
linkext7.gif
0
Comment actions Permalink

Gaston, please make sure you placed mysql-connector jar file to the TeamCity/webapps/ROOT/WEB-INF/lib directory before TeamCity startup.

It looks like TeamCity unable to find Mysql JDBC driver to connect to Mysql database.

Hope this helps,
KIR

0
Comment actions Permalink

Thanks. I migrated TC to MySQL successfully (actually I'm triggering
project's builds for being sure).

I also copied the user and user_property table from HSQLDB to MySQL,
launching the DB as stand-alone and exporting with dbvisualizer.
(Regardless of what you said)

best regards
Gaston






"Kirill Maximov (JetBrains)" <no_reply@jetbrains.com> wrote in message
news:8470248.1174421882359.JavaMail.itn@is.intellij.net...

Gaston, please make sure you placed mysql-connector jar file to the
TeamCity/webapps/ROOT/WEB-INF/lib directory before TeamCity startup.

>

It looks like TeamCity unable to find Mysql JDBC driver to connect to
Mysql database.

>

Hope this helps,
KIR



0

Please sign in to leave a comment.