tomcat-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 42063] New: - Connect to database (under Windows) from linux :(
Date Fri, 06 Apr 2007 05:17:28 GMT
DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG·
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=42063>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND·
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=42063

           Summary: Connect to database (under Windows) from linux :(
           Product: Tomcat 5
           Version: 5.5.17
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: normal
          Priority: P2
         Component: Servlet & JSP API
        AssignedTo: tomcat-dev@jakarta.apache.org
        ReportedBy: ustaswolf@narod.ru


Hi. I write a servlet that connect with database mysql. On the PC under Windows 
it works fine, but under Linux i cant solve 1 problem: the connection to 
database not created. User have all needed rights in database and another 
program (under linux) could connect to this server. The sql driver mysql-
connector-java-5.0.4-bin.jar is in apache-tomcat-5.5.17\common\lib and in 
Servlet/web-inf/lib. 
Servlet/META-INF/contex.xml :
 <Context privileged="true" antiResourceLocking="false" antiJARLocking="false">
  
  <Resource name="jdbc/positioneer" auth="Container"
            type="javax.sql.DataSource" username="user" password="xxxxx"
            driverClassName="com.mysql.jdbc.Driver" 
url="jdbc:mysql://217.67.191.210:3306/positioneer"
            maxActive="8" maxIdle="4"/>
  
</Context>

Servlet/WEB-INF/web.xml :

<?xml version="1.0" encoding="UTF-8"?>
<web-app version="2.4"
         xmlns="http://java.sun.com/xml/ns/j2ee"
         xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee 
http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd" >

	<resource-ref>
	 <description>
	   Resource reference to a factory for java.sql.Connection
	   instances that may be used for talking to a particular
	   database that is configured in the server.xml file.
	 </description>
	 <res-ref-name>jdbc/positioneer</res-ref-name>
	 <res-type>javax.sql.DataSource</res-type>
	 <res-auth>Container</res-auth>
   </resource-ref>

	<servlet>
        <description>Main servlet</description>
        <display-name>SSSServlet</display-name>
        <servlet-name>SSSServlet</servlet-name>
        <servlet-class>Reports.SSSServlet</servlet-class>
   </servlet>
    <servlet-mapping>
        <servlet-name>SSSServlet</servlet-name>
        <url-pattern>/*</url-pattern>
    </servlet-mapping>

</web-app>

I listen 3306 port when servlet tried to init, but nothing send or recieved.
Please help to find where is mistake. The error script :

Not connected to database.Errors occurs when communicating with the database 
server: Communications link failure due to underlying exception: 

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.security.AccessControlException: access denied 
(java.net.SocketPermission 89.108.80.240:3306 connect,resolve)

STACKTRACE:

java.net.SocketException: java.security.AccessControlException: access denied 
(java.net.SocketPermission 89.108.80.240:3306 connect,resolve)
     at com.mysql.jdbc.StandardSocketFactory.connect
(StandardSocketFactory.java:156)
     at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
     at com.mysql.jdbc.Connection.createNewIO(Connection.java:2666)
     at com.mysql.jdbc.Connection.<init>(Connection.java:1531)
     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 Reports.SSSServlet.openConnection(SSSServlet.java:106)
     at Reports.SSSServlet.init(SSSServlet.java:131)
     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.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:243)
     at java.security.AccessController.doPrivileged(Native Method)
     at javax.security.auth.Subject.doAsPrivileged(Subject.java:517)
     at org.apache.catalina.security.SecurityUtil.execute(SecurityUtil.java:275)
     at org.apache.catalina.security.SecurityUtil.doAsPrivilege
(SecurityUtil.java:161)
     at org.apache.catalina.security.SecurityUtil.doAsPrivilege
(SecurityUtil.java:114)
     at org.apache.catalina.core.StandardWrapper.loadServlet
(StandardWrapper.java:1099)
     at org.apache.catalina.core.StandardWrapper.allocate
(StandardWrapper.java:757)
     at org.apache.catalina.core.StandardWrapperValve.invoke
(StandardWrapperValve.java:130)
     at org.apache.catalina.core.StandardContextValve.invoke
(StandardContextValve.java:178)
     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.processConne
ction(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 **

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@tomcat.apache.org
For additional commands, e-mail: dev-help@tomcat.apache.org


Mime
View raw message