RE: Connecting to MySQL on GoDaddy.com

Hello flint, usually nobody responds in this mail list. 
What do you mean with your "live enviroment" your production webapp with
your prod database ?

If yes, clearly you have some access rights problem.

Are you using dbcp ??? If yes, what is your context xml ?

Are you using your own pool/connection, what is your url connection
string?

Can you access thru phpMyAdmin to your mysql ? 

Regards
Rodrigo

-----Original Message-----
From: Flint Gatrell [mailto:[email protected]] 
Sent: Thursday, May 17, 2007 5:17 PM
To: [email protected]
Subject: Connecting to MySQL on GoDaddy.com

Hello,

I have a Linux hosting account with Java enabled, and I am trying to
make a connection to my MySQL database from one of my servlets.  I have
been successful in connecting to MySQL from this servlet on my local
machine, but I have been unable to figure it out in my "live"
environment.

The error I receive is included below.

Has anyone else solved a similar problem before with their own servlets?
Or has anyone got any ideas of where I can look for someone that has?
GoDaddy's tech support seems unwilling to assist.

I can post code snippets upon request.

Thanks,
Flint

Exception report:

com.mysql.jdbc.CommunicationsException: Communications link failure due
to underlying exception: ** BEGIN NESTED EXCEPTION **
java.security.AccessControlException MESSAGE: access denied
(java.net.SocketPermission mysql p41mysql3.secureserver.net resolve)
STACKTRACE: java.security.AccessControlException: access denied
(java.net.SocketPermission mysql p41mysql3.secureserver.net resolve) at
java.security.AccessControlContext.checkPermission(AccessControlContext.
java:264)
at
java.security.AccessController.checkPermission(AccessController.java:427
)
at java.lang.SecurityManager.checkPermission(SecurityManager.java:532)
at
java.lang.SecurityManager.checkConnect(SecurityManager.java:1031) at
java.net.InetAddress.getAllByName0(InetAddress.java:1117) at
java.net.InetAddress.getAllByName0(InetAddress.java:1098) at
java.net.InetAddress.getAllByName(InetAddress.java:1061) at
com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:
137)
at com.mysql.jdbc.MysqlIO.(MysqlIO.java:276) at
com.mysql.jdbc.Connection.createNewIO(Connection.java:2666) at
com.mysql.jdbc.Connection.(Connection.java:1531) at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:26
6)
at java.sql.DriverManager.getConnection(DriverManager.java:525) at
java.sql.DriverManager.getConnection(DriverManager.java:193) at
myservlets.dbUtilities.connect(dbUtilities.java:46) at
myservlets.MySQLAccess.processRequest(MySQLAccess.java:49) at
myservlets.MySQLAccess.doPost(MySQLAccess.java:95) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
org.apache.catalina.servlets.InvokerServlet.serveRequest(InvokerServlet.
java:419)
at
org.apache.catalina.servlets.InvokerServlet.doPost(InvokerServlet.java:1
69)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:709) at
javax.servlet.http.HttpServlet.service(HttpServlet.java:802) at
sun.reflect.GeneratedMethodAccessor136.invoke(Unknown Source) at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessor
Impl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585) at
org.apache.catalina.security.SecurityUtil$1.run(SecurityUtil.java:239)
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:266)
at
org.apache.catalina.security.SecurityUtil.doAsPrivilege(SecurityUtil.jav
a:157)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:231)
at
org.apache.catalina.core.ApplicationFilterChain.access$000(ApplicationFi
lterChain.java:50)
at
org.apache.catalina.core.ApplicationFilterChain$1.run(ApplicationFilterC
hain.java:140)
at java.security.AccessController.doPrivileged(Native Method) at
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:136)
at
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:214)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
at
org.apache.catalina.core.StandardContextValve.invokeInternal(StandardCon
textValve.java:198)
at
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:152)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
at
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:137)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
at
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:117)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:102)
at
org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:535
)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:102)
at
org.apache.catalina.authenticator.SingleSignOn.invoke(SingleSignOn.java:
417)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:102)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
at
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:109)
at
org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveCo
ntext.java:104)
at
org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:5
20)
at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:929)
at
org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:160)
at
org.apache.jk.server.JkCoyoteHandler.invoke(JkCoyoteHandler.java:300) at
org.apache.jk.common.HandlerRequest.invoke(HandlerRequest.java:374) at
org.apache.jk.common.ChannelSocket.invoke(ChannelSocket.java:743) at
org.apache.jk.common.ChannelSocket.processConnection(ChannelSocket.java:
675)
at org.apache.jk.common.SocketConnection.runIt(ChannelSocket.java:866)
at
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:683)
at java.lang.Thread.run(Thread.java:595) ** END NESTED EXCEPTION ** Last
packet sent to the server was 1 ms ago.
SQL State: 08S01
SQL ErrorCode: 0


--
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:
http://lists.mysql.com/[email protected]


This message (including any attachments) contains confidential 
and/or proprietary information intended only for the addressee.  
Any unauthorized disclosure, copying, distribution or reliance on 
the contents of this information is strictly prohibited and may 
constitute a violation of law.  If you are not the intended 
recipient, please notify the sender immediately by responding to 
this e-mail, and delete the message from your system.  If you 
have any questions about this e-mail please notify the sender 
immediately. 

-- 
MySQL Java Mailing List
For list archives: http://lists.mysql.com/java
To unsubscribe:    http://lists.mysql.com/[email protected]