Menu
▾
▴
Re: [Opensims-user] Torque and MySQL
|
From: Ritter, N. <Nic...@am...> - 2008-12-04 16:32:53
|
I checked the versions and compat on MySQL site for J/Connector 5.1 and Java 1.4.2...I am using the correct version for the mysql and java versions I am running.
Here is the output you requested:
[root@hades mysql-connector-java-5.1.7]# jar tvf mysql-connector-java-5.1.7-bin.jar | grep Driver
21 Tue Oct 21 04:02:24 CDT 2008 META-INF/services/java.sql.Driver
692 Tue Oct 21 04:02:16 CDT 2008 com/mysql/jdbc/Driver.class
12595 Tue Oct 21 04:02:16 CDT 2008 com/mysql/jdbc/NonRegisteringDriver.class
2474 Tue Oct 21 04:02:16 CDT 2008 com/mysql/jdbc/NonRegisteringReplicationDriver.class
731 Tue Oct 21 04:02:16 CDT 2008 com/mysql/jdbc/ReplicationDriver.class
336 Tue Oct 21 04:02:18 CDT 2008 org/gjt/mm/mysql/Driver.class
[root@hades mysql-connector-java-5.1.7]# jar tvf mysql-connector-java-5.1.7-bin.jar | grep org
0 Tue Oct 21 04:02:12 CDT 2008 org/
0 Tue Oct 21 04:02:12 CDT 2008 org/gjt/
0 Tue Oct 21 04:02:12 CDT 2008 org/gjt/mm/
0 Tue Oct 21 04:02:18 CDT 2008 org/gjt/mm/mysql/
336 Tue Oct 21 04:02:18 CDT 2008 org/gjt/mm/mysql/Driver.class
Nick
-----Original Message-----
From: Mando Escamilla [mailto:ma...@sy...]
Sent: Thu 12/4/2008 9:47 AM
To: ope...@li...
Subject: Re: [Opensims-user] Torque and MySQL
Nick,
I'm afraid my MySQL-fu is weak :). Can you do the following for me?
Make sure that "jar tvf mysql-connector jar" has org/mysql/jdbc/Driver
somewhere in the listing. Like I said, I've only really done this
with Postgres, so I'm not familiar with which jars work with various
mysql and java combos.
--
Mando Escamilla
On Dec 4, 2008, at 9:43 AM, Ritter, Nicholas wrote:
> I have copied the jar to the same classpaths listed via "ant -
> diagnostics" and it has not changed the outcome at all. I installed
> the distro (centos 5.2) package for postgres jdbc to see where they
> put it, and then I copied the mysql jar to there and it still didn't
> work. The error returned has been exactly the same throughout
> everything I have tried. Of the 3, or so, versions of the mysql j/
> connector available, I am not sure I am using the correct version
> for the version of ant/tomcat/java I am using.
>
> To make things easier on myself, I started of with using the ant,
> tomcat, apache, and java that is bundled with CentOS 5.2 x86_64.
> This involves:
>
> java 1.4.2 via gnu gij version 4.1.2
> ant 1.6.5
> tomcat5 (5.5.23)
>
> I have never worked with ant/tomcat/java so I am in the dark a bit.
> I tried following the install information on the MySQL website and
> realized that the version of J/Connector I am using ( mysql-
> connector-java-5.1.7 ) is JDBC v4 driver, and may not be supported
> with my version of Java...but I have not been able to figure out how
> to find the version of JDBC that my system supports.
>
> I am somewhat curious as to why I specify the path to the driver in
> the build.properties file when the driver should, or needs, to be in
> the global CLASSPATH and thus would be loadable by default.
>
> Nick
>
>
> -----Original Message-----
> From: Mando Escamilla [mailto:ma...@sy...]
> Sent: Wed 12/3/2008 4:45 PM
> To: ope...@li...
> Subject: Re: [Opensims-user] Torque and MySQL
>
> Nicholas,
>
> That's a great question :). I'm relatively new to the opensims
> project, so I've never fully investigated getting opensims running
> with MySQL (which is pretty embarrassing, I must admit).
>
> I'd take a look at two things:
>
> 1) Make sure that opensims/torque/lib is in opensims/java/
> classpath.xml
> 2) Make sure that org.mysql.jdbc.Driver is actually in the mysql-
> connector jar file.
>
> Frankly, the classpath stuff is very much a mess right now :(. It
> definitely takes some tweaking and poking to get everything in place.
>
> Try hacking around with those two things, and if you can't make any
> head way let me know.
>
> Thanks,
>
> --
> Mando Escamilla
>
> On Dec 3, 2008, at 4:03 PM, Ritter, Nicholas wrote:
>
>> Ok...did some digging...and downloaded the J/Connector v5.1.7 jar
>> from MySQL.com.
>>
>> I copied the mysql-connector-java-5.1.7-bin.jar to the Torque /lib
>> dir.
>>
>> I then edited the build.properties to show the following:
>>
>> db.platform = mysql
>> db.jdbc.driver = org.mysql.jdbc.Driver
>> db.jdbc.jar = /opt/opensims/tools/torque/lib/mysql-connector-
>> java-5.1.7-bin.jar
>>
>> I then run: "ant preflight clean config build test datadump" from
>> the "/opt/opensims/tools/torque" directory. I get the following
>> error:
>>
>> Buildfile: build.xml
>>
>> config:
>> [copy] Copying 1 file to /opt/opensims/build
>>
>> load_properties:
>>
>> preflight:
>> [echo]
>> [echo] Now using Torque to build OpenSIMS database ...
>> [echo]
>> [echo] platform: mysql
>> [echo] driver: org.mysql.jdbc.Driver
>> [echo] JAR file: /opt/opensims/tools/torque/lib/mysql-
>> connector-java-5.1.7-bin.jar
>> [echo] user: <censored for this post>
>> [echo] password: <censored for this post>
>> [echo] create URL: jdbc:mysql://localhost:3306/mysql
>> [echo] build URL: jdbc:mysql://localhost:3306/opensims
>> [echo] db URL: jdbc:mysql://localhost:3306/opensims
>> [echo] valid query: SELECT 1
>> [echo]
>> [echo] ...the answer should be '1'
>> [echo] ...otherwise, your database properties are not quite right.
>> [echo]
>>
>> BUILD FAILED
>> /opt/opensims/tools/torque/build.xml:246: Class Not Found: JDBC
>> driver org.mysql.jdbc.Driver could not be loaded
>>
>> Total time: 0 seconds
>>
>>
>> I figured this is a CLASSPATH issue? How do I solve it?
>>
>> -------------------------------------------------------------------------
>> This SF.Net email is sponsored by the Moblin Your Move Developer's
>> challenge
>> Build the coolest Linux based applications with Moblin SDK & win
>> great prizes
>> Grand prize is a trip for two to an Open Source event anywhere in
>> the world
>> http://moblin-contest.org/redirect.php?banner_id=100&url=/
>> _______________________________________________
>> Opensims-user mailing list
>> Ope...@li...
>> https://lists.sourceforge.net/lists/listinfo/opensims-user
>
>
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/
> _______________________________________________
> Opensims-user mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/opensims-user
>
>
> <
> winmail
> .dat
> >
> -------------------------------------------------------------------------
> This SF.Net email is sponsored by the Moblin Your Move Developer's
> challenge
> Build the coolest Linux based applications with Moblin SDK & win
> great prizes
> Grand prize is a trip for two to an Open Source event anywhere in
> the world
> http://moblin-contest.org/redirect.php?banner_id=100&url=/_______________________________________________
> Opensims-user mailing list
> Ope...@li...
> https://lists.sourceforge.net/lists/listinfo/opensims-user
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Opensims-user mailing list
Ope...@li...
https://lists.sourceforge.net/lists/listinfo/opensims-user
|
