Thanks Matt. My final scenario to this was taking the mm.mysql-2.0.3-scr.jar and
moving it to the" /servers/lib" directory. The url is "
jdbc:mysql://localhost:3306/mysql", and the driver is "org.gjt.mm.mysq.Driver". I
left the
class paths alone since the .jar is in the /servers/lib path, and that the admin
server, as well as the default server use the same class paths. I was finally able to
test successfully using the Default Server, but not the Admin
Server, where I was having the problems initially. Maybe you can tell me why the test
failed in the Admin Server being as both servers are configured the same.
Matthew Horn wrote:
> I've connected JRun to MySQL using a different JDBC driver. Here are
> instructions on doing it. I hope this helps.
>
> To set up a JDBC driver for MySQL:
> 1. Download a MySQL JDBC driver. You can get a type 4 driver from the
> following location:
> http://www.worldserver.com/mm.mysql/
>
> 2. Expand the JDBC driver into it's own directory. For example,
> c:\mm.mysql\mm.mysql-2.0.1.
>
> 3. Add the JDBC driver's mysql.jar file to both your default and admin JRun
> servers' classpaths. Do this by logging into the JMC.
>
> 4. In the left pane of the JMC, select machine_name > JRun Admin Server >
> Java Settings.
> The Java Settings panel appears.
>
> 5. In the right pane, click Edit. The Java Settings edit window appears.
>
> 6. Add the full path to the .jar file in the Classpath field. For example,
> c:/mm.mysql/mm.mysql-2.0.1/mysql.jar. Each entry should be on it's own line
> in the Classpath field. For example:
> {jrun.rootdir}/servers/lib
> {jrun.server.rootdir}/lib
> c:/mm.mysql/mm.mysql-2.0.1/mysql.jar
>
> 7. Close the Java Settings edit window by clicking the Update button and
> repeat this process for the Java settings of the JRun Default Server.
>
> 8. Restart the default and admin JRun servers:
> % jrun -restart
>
> 9. From the MySQL command line, add a new user to MySQL. This new user must
> be granted access to your database. For example, add a new user with the
> following command:
>
> mysql> grant ALL PRIVILEGES ON <your_database>.* TO fred IDENTIFIED BY
> 'fredspassword';
>
> The grant command creates a new user if the user is not already created.
> The <your_database>.* gives the user fred access to all the tables in your
> database. You can also use a comma-delimeted list of tables instead.
> The username and password (fred and fredspw) will be used by JRun servlet
> requests to log into the database. This is transparent to the Web client.
>
> ------- -- -----
> Matthew J. Horn
> Technical Writer
> Allaire Corp.
>
> >>-----Original Message-----
> >>From: Lynn Walton [mailto:[EMAIL PROTECTED]]
> >>Sent: Wednesday, December 27, 2000 3:41 PM
> >>To: JRun-Talk
> >>Subject: Re: JBDC Configuration with mySQL
> >>
> >>
> >>Sorry Jeff. I don't know. That looks like it would be o.k.
> >>to me but I'm not using Jrun 3 and it's datasources.
> >>
> >>Good luck,
> >>Lynn
> >>
> >>
> >>
> >>Jeff Ernst wrote:
> >>
> >>> I have tried this, with no luck. I also changed the
> >>driver name to a bogus title, and received the same error
> >>message " No valid driver". I am using
> >>"org.gjt.mm.mysql.Driver" as the driver name, which seems
> >>to be what is
> >>> needed. I have not changed the default localhost port,
> >>so the URL is used is "jdbc:mysql://localhost:3306/test".
> >>Could the "Name" of the datasource affect anything ??
> >>>
> >>> Lynn Walton wrote:
> >>>
> >>> > Did you try putting the port number after localhost?
> >>> > jdbc:mysql://localhost:3306/test
> >>> > 3306 is mysql's default port ... or substitute your
> >>port if you have it running on something other than the default
> >>> >
> >>> > I don't know if that would make a difference but that's
> >>what I use with Jrun2.3.
> >>> >
> >>> > Lynn
> >>> >
> >>> > Jeff Ernst wrote:
> >>> >
> >>> > > I have my mm.mysql-2.0.3-src.jar in the /lib,
> >>/servers/lib, and /servers/admin/lib. From what I have seen
> >>in the archives, if I receive this error message it's a URL
> >>issue. Can you tell me if the URL is correct assuming
> >>> > > there is a working database named "test" in mySQL.
> >>> > >
> >>> > > Thanks ...
> >>> > >
> >>> > > Dave Daniels wrote:
> >>> > >
> >>> > > > This is a common error. The driver should be in the
> >>Admin Server classpath
> >>> > > > as well for the test to work.
> >>> > > >
> >>> > > > ----- Original Message -----
> >>> > > > From: Jeff Ernst <[EMAIL PROTECTED]>
> >>> > > > To: JRun-Talk <[EMAIL PROTECTED]>
> >>> > > > Sent: Tuesday, December 26, 2000 11:22 AM
> >>> > > > Subject: JBDC Configuration with mySQL
> >>> > > >
> >>> > > > > I am trying to configure my Jrun JDBC data source
> >>to connect to mySQL.
> >>> > > > > I have my driver in the proper class path, and
> >>the URL I am using is
> >>> > > > > jdbc:mysql://localhost/test?user=root. Both
> >>Jrun, and mySQL are on
> >>> > > > > the same PC. When trying to test, I get the " No
> >>valid driver" error
> >>> > > > > message. Is this the right URL ??, and what
> >>would be the datasource
> >>> > > > > name I would use as well. Thanks for any help ... Jeff
> >>> > > > >
> >>> > > > >
> >>> > > > >
> >>> > > >
> >>> > >
> >>> >
> >>>
> >>
>
~~~~~~~~~~~~~ Paid Sponsorship ~~~~~~~~~~~~~
Get Your Own Dedicated Win2K Server! Instant Activation for $99/month w/Free
Setup from SoloServer PIII600 / 128 MB RAM / 20 GB HD / 24/7/365 Tech Support
Visit SoloServer, https://secure.irides.com/clientsetup.cfm.
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
