Re: jahia mysql configuration problem

venkata sukumar kommuru <[email protected]> Tue, 03 Jun 2008 20:54:09 +0200
Newsgroups gmane.comp.cms.jahia.install
Message-ID <[email protected]>
Hello Sergiy,

  Thanks alot for the immediate response. Now its working fine. I have  
  a small problem with the database name. In my project, I need to  
develop a job board. Is it possible to create a job board with Jahia.  
Kindly let me know.

Thanks alot!
Best Regards,
Venkata
Quoting Sergiy Shyrkov <[email protected]>:

> Hello Venkata,
>
> please ensure that:
> 1) your MySQL server is up and running on your localhost machine on
> port 2273 (is this the port number you need? because the default MySQL
> server port is 3306). An easy test would be to open a command prompt
> window on your local machine and issue the following command: telnet
> localhost 2273
> 2) you can connect with any database viewer tool (MySQL Query Browser,
> etc.) or command line MySQL tool to your database. Your DBMS server
> needs to be configured to accept connections from localhost (and
> perhaps from your IP address).
>
> You could also try to replace 'localhost:2273' with the
> '127.0.0.1:2273' or with your real IP address.
>
> Kind regards
> Sergiy
>
> If the server is running
>
> venkata sukumar kommuru wrote:
>> Hi,
>>
>>         I am new to Jahia CMS. During Configuration of the   
>> community  edition, I want to add mysql database server. But I am   
>> getting the  following error:
>>
>> Environment : jahia5.0.3, mysql5.0,windows xp ; jahia installed to   
>>  C:\jahia5.0.3_r18957, mysql-C:\Program Files\MySQL\MySQL Server 5.0,
>> Database    
>> url:jdbc:mysql://localhost:2273/jahia?useUnicode=true&characterEncoding=UTF-8&useServerPrepStmts=false
>>
>> Error while connecting to the database:Communications link failure   
>> due to underlying exception: ** BEGIN NESTED EXCEPTION **    
>> java.net.SocketException MESSAGE: java.net.ConnectException:    
>> Connection refused: connect STACKTRACE: java.net.SocketException:    
>> java.net.ConnectException: Connection refused: connect at    
>> com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)  at com.mysql.jdbc.MysqlIO.(MysqlIO.java:284) at  com.mysql.jdbc.Connection.createNewIO(Connection.java:2569) at  com.mysql.jdbc.Connection.(Connection.java:1485) at  com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java:525) at  java.sql.DriverManager.getConnection(DriverManager.java:171) at  org.jahia.admin.database.DatabaseConnection.databaseOpen(DatabaseConnection.java:250) at org.jahia.admin.database.DatabaseConnection.databaseTest(DatabaseConnection.java:108) at org.jahia.bin.JahiaConfigurationWizard.testDBConnection(JahiaConfigurationWizard.java:1496) at org.jahia.bin.JahiaConfigurationWizard.processAdvSettings(JahiaConfigura
 tionWizard.java:1007) 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.jahia.utils.ActionHandler.call(ActionHandler.java:142) at org.jahia.bin.JahiaConfigurationWizard.dispatcher(JahiaConfigurationWizard.java:368) at org.jahia.bin.JahiaConfigurationWizard.service(JahiaConfigurationWizard.java:224) 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.jahia.bin.filters.esi.ESIFilter.doFilter(ESIFilter.java:110) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202) 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:432) 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) ** END NESTED EXCEPTION ** Last packet sent to the server was 170 ms    
>> ago.
>>
>>  please let me know the changes I need to make.
>>
>> Thank you,
>> Venkata
>>
>> _______________________________________________
>> install_list mailing list
>> [email protected]
>> http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list
>>



_______________________________________________
install_list mailing list
[email protected]
http://lists.jahia.org/cgi-bin/mailman/listinfo/install_list