Menu
▾
▴
opensims-user — General openSIMS user support and discussion mailing list
You can subscribe to this list here.
| 2006 |
Jan
|
Feb
|
Mar
|
Apr
(2) |
May
|
Jun
|
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
|
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2008 |
Jan
|
Feb
|
Mar
|
Apr
|
May
|
Jun
(1) |
Jul
|
Aug
|
Sep
|
Oct
|
Nov
|
Dec
(6) |
|
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
|
|
From: Mando E. <ma...@sy...> - 2008-12-04 15:48:14
|
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 |
|
From: Ritter, N. <Nic...@am...> - 2008-12-04 15:43:25
|
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 |
|
From: Mando E. <ma...@sy...> - 2008-12-03 23:25:03
|
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 |
|
From: Ritter, N. <Nic...@am...> - 2008-12-03 22:03:13
|
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? |
|
From: Ritter, N. <Nic...@am...> - 2008-12-03 21:15:04
|
Greetings everyone, I am using CentOS 5.2 x86_64 and working to install opensims which I downloaded yesterday. My question is what is the procedure to add MySQL support to Torque and the MySQL config for build.properties? I have run "ant -V init" just fine....and found that I don't know what to put in build.properties for the mysql support. I was going to follow the postgres example fairly literally, but I have the feeling that it would not work because I don't have a Torque connect for MySQL installed. I searched the Internet and found some information here and there about Torque and MySQL, but nothing much. Can someone provided me with more information please? Nick |
|
From: whurley <wh...@ie...> - 2008-06-08 07:33:07
|
Hey everyone, Well, after a very long working weekend Mando has just made the first code drop into the project SVN repository. The code does build without errors, so feel free to check it out. Be warned however that the config (needed to get things up and running) is still difficult...but hey, we're working on it :) More to come, whurley -- whurley +1 (512) 788-5353 wh...@ie... http://whurley.com http://opensville.org Follow me online: Twitter - http://twitter.com/whurley |
|
From: whurley <wh...@gm...> - 2006-04-13 00:13:19
|
If so, please reply. -whurley -- whurley wh...@gm... http://www.whurley.com |
|
From: whurley <wh...@gm...> - 2006-04-12 22:42:59
|
The new openSIMS mailing... ope...@li... is now active. You can join and post at will. -whurley -- whurley wh...@gm... http://www.whurley.com |