On Mon, 2010-01-18 at 08:23 -0600, Caldarale, Charles R wrote: > > From: Rick Bragg [mailto:li...@gmnet.net] > > Subject: RE: Cyclos Webapp Trouble (404) > > > > Yes I notices that as well, I forgot to post my cyclos.properies Here > > is the "mysql" section... > > > > hibernate.connection.url = jdbc:mysql://127.0.0.1:3306/cyclos > > The above doesn't jibe with the error message displayed at runtime: > > jdbc:mysql://localhost/cyclos3?useUnicode=true&characterEncoding=utf8 > > Note the use of "localhost" instead of "127.0.0.1", the lack of explicit port > number, and the database name. > > What you posted is not what you're actually running with. > > - Chuck > > > THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY > MATERIAL and is thus for use only by the intended recipient. If you received > this in error, please contact the sender and delete the e-mail and its > attachments from all computers.
Sorry, that must have been one of my "variations"... To be clear, here are the files as of now. cyclos.properties (MySQL section) ### MySQL hibernate.dialect = org.hibernate.dialect.MySQLInnoDBDialect hibernate.connection.driver_class = com.mysql.jdbc.Driver hibernate.connection.url = jdbc:mysql://127.0.0.1:3306/cyclos hibernate.connection.username = cyclos hibernate.connection.password = ******** ### Connection provider properties hibernate.connection.provider_class = org.hibernate.connection.C3P0ConnectionProvider hibernate.c3p0.minPoolSize = 1 hibernate.c3p0.maxPoolSize = 100 hibernate.c3p0.acquireIncrement = 1 hibernate.c3p0.maxIdleTime = 21600 hibernate.c3p0.testConnectionOnCheckout = true hibernate.c3p0.preferredTestQuery = select 1 hibernate.c3p0.acquireRetryAttempts = 5 hibernate.c3p0.numHelperThreads = 3 and error log: Jan 18, 2010 8:22:42 AM org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextDestroyed() Jan 18, 2010 8:22:42 AM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextDestroyed() Jan 18, 2010 8:22:50 AM org.apache.catalina.core.ApplicationContext log INFO: ContextListener: contextInitialized() Jan 18, 2010 8:22:50 AM org.apache.catalina.core.ApplicationContext log INFO: SessionListener: contextInitialized() Jan 18, 2010 8:22:51 AM org.apache.catalina.core.ApplicationContext log INFO: Initializing Spring root WebApplicationContext Jan 18, 2010 8:22:56 AM org.apache.catalina.core.StandardContext listenerStart SEVERE: 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 'sessionFactory' defined in class path resource [nl/strohalm/cyclos/spring/persistence.xml]: Invocation of init method failed; nested exception is java.lang.RuntimeException: Error connecting to database at jdbc:mysql://127.0.0.1:3306/cyclos?useUnicode=true&characterEncoding=utf8 Caused by: java.lang.RuntimeException: Error connecting to database at jdbc:mysql://127.0.0.1:3306/cyclos?useUnicode=true&characterEncoding=utf8 at nl.strohalm.cyclos.setup.DataBaseConfiguration.validateConnection(DataBaseConfiguration.java:342) at nl.strohalm.cyclos.setup.DataBaseConfiguration.run(DataBaseConfiguration.java:107) at nl.strohalm.cyclos.spring.CustomSessionFactoryBean.newSessionFactory(CustomSessionFactoryBean.java:42) at org.springframework.orm.hibernate3.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:745) ... Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure ... Last packet sent to the server was 0 ms ago. 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:513) at com.mysql.jdbc.Util.handleNewInstance(Util.java:406) at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:335) at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2043) ... 56 more Caused by: java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182) at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366) at java.net.Socket.connect(Socket.java:525) at java.net.Socket.connect(Socket.java:475) at java.net.Socket.<init>(Socket.java:372) at java.net.Socket.<init>(Socket.java:215) at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:253) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284) ... 57 more Jan 18, 2010 8:22:56 AM org.apache.catalina.core.ApplicationContext log INFO: Closing Spring root WebApplicationContext Jan 18, 2010 8:23:10 AM org.apache.catalina.core.ApplicationContext log INFO: HTMLManager: init: Associated with Deployer 'Catalina:type=Deployer,host=localhost' Jan 18, 2010 8:23:10 AM org.apache.catalina.core.ApplicationContext log INFO: HTMLManager: init: Global resources are available Jan 18, 2010 8:23:10 AM org.apache.catalina.core.ApplicationContext log INFO: HTMLManager: list: Listing contexts for virtual host 'localhost' When I change variation in cyclos.properties (such as localhost, etc) the log does reflect that in the log... Thanks again, and sorry for that confusion... Rick --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
