On Mon, 2010-01-18 at 09:43 -0500, David Smith wrote: > 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
Hi David, Yes the above works perfect. I can log into MySQL in exactly that way. I also double checked the password. As far as my inconsistencies in posts, what I meant was that the JDK, (JVM) Tomcat6, and cyclos are all brand new. This is on a system that also does other moderate production stuff as well so MySQL has been up and running for a bit longer... Thanks Rick --------------------------------------------------------------------- To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org
