RE: [cobalt-developers] Cannot make JDBC connection to MySQL (Java Developers Kit package)

["Alexander Povargo" <alpo@xxxxxxxxxxxxxxxxxx>]

Hi,

use this URL: jdbc:mysql://localhost/database
or set this permission to the appropriate virtaul host:
permission java.net.SocketPermission "mysite.com:1024-",
"listen,connect,resolve";
if you want to use mysite.com in URL.

Place your mysql driver to <appropriate virtual site>/WEB-INF/lib
or grant java.security.AllPermission to your mysql driver if you
place it in another place.
Are you sure that you use correct file - mm.mysql.jdbc-1.2c.tar.gz?
You need to use jar file instead to gz file. You wrote that you use
correct mm.mysql-2.0.4-bin.jar before, use it now.

Hope it help to you.
Regards,
Alex

> -----Original Message-----
> From: cobalt-developers-admin@xxxxxxxxxxxxxxx
> [mailto:cobalt-developers-admin@xxxxxxxxxxxxxxx]On Behalf Of Rick
> Archibald
> Sent: Monday, October 01, 2001 7:28 PM
> To: cobalt-developers@xxxxxxxxxxxxxxx
> Subject: [cobalt-developers] Cannot make JDBC connection to MySQL
> (Java Developers Kit package)
>
>
> Problem - cannot make JDBC connection to MySQL with the new Java
> Developers
> Kit package.
>
> Previously, I used JSP and servlets on my RaQ3 with a solution that had
> been hacked together.  After Cobalt came out with a package for
> the Cobalt,
> I decided I wanted to use that instead.  Here's what I did:
> 1.  Install latest patches:
>      RaQ3-All-System-4.0.1-10659.pkg
>      RaQ3-All-System-4.0.1-10765.pkg
>      RaQ3-All-Security-4.0.1-10628.pkg
>      RaQ3-All-Kernel-4.0.1-2.216C28III.pkg
> 2.  Remove old jakarta-tomcat directory, java sdk, and modifications to
> configuration files.
> 3.  Installed Java Developers Kit package and Java Update package.
>
> Everything installed fine, and my JSP and servlets work.
> However, I can no
> longer connect to the MySQL server.  When my JSP pages try to connect ,
> they produce a 500 page which says "Cannot connect to MySQL server on
> www.mysite.com:3306. Is there a MySQL server running on the machine/port
> you are trying to connect to?"  I can telnet "telnet www.mysite.com 3306",
> and I get a reply with the version of MySQL server followed by some
> gibberish.  I also run "mysqladmin -p -h 'www.mysite.com' --port=3306
> version", and I get a reply saying the connection is "www.mysite.com via
> TCP/IP" and theTCP port is "3306".  Everything appears to work
> fine, except
> I can't get my jsp pages to connect.
>
> After encountering these problems, I upgraded the MySQL package from
> 3.23.36 to 3.23.37, but I still got the 500 page with the same
> message.  An
> additional change I noted between the working solution I had
> before and the
> current solution is that the jdbc driver is currently from the
> mm.mysql.jdbc-1.2c.tar.gz (I think I used mm.mysql-2.0.4-bin.jar before).
>
> Here are the parameters:
> DRIVER = "org.gjt.mm.mysql.Driver";
> USERNAME = "my_username";
> PASSWORD = "my_password";
> URL = "jdbc:mysql://www.mysite.com/database";
>
> Here are the software packages I'm using:
> MySQL - 3.23.37
> JDBC driver - mm.mysql.jdbc-1.2c.tar.gz
> Tomcat - 3.2.3
> Java - jdk1.3.1
>
>
>
> ***********************************************************************
> This e-mail and any attachments may contain information which is
> confidential, privileged, proprietary or otherwise protected by law.
> The information is solely intended for the named addressee (or a person
> responsible for delivering it to the addressee).  If you are not the
> intended recipient of this message, you are not authorized to read,
> print, retain, copy or disseminate this message or any part of it.
> If you have received this e-mail in error, please notify the sender
> immediately by return e-mail and delete it from your computer.
> ***********************************************************************
>
> _______________________________________________
> cobalt-developers mailing list
> cobalt-developers@xxxxxxxxxxxxxxx
> http://list.cobalt.com/mailman/listinfo/cobalt-developers
>
>