Rick Bragg wrote: > 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 > > Is your MySQL server actually listening on 3306? Some installations of MySQL leave the tcp port disabled for security reasons. I've never understood the decision, but it happens. You can test w/ the mysql command:
mysql -P 3306 -h localhost -u cyclos -p --David --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org