When I was running into the same problem I used the
code bellow to make sure I had MySQL set up right.

Hope this helps, your almost there...
Erik Meade


import java.sql.*;

public class DBTest {

         static Connection connection;

         static String driver = "org.gjt.mm.mysql.Driver";
         static String url = "jdbc:mysql://localhost/turbine";
         static String user = "turbine";
         static String pass = "turbine";

         public static void main ( String arg[] ) {
                 System.out.println ( "Attempting to connect to: " + url );
                 try {
                 Class.forName ( driver );
                  connection = DriverManager.getConnection ( url , user , 
pass );
                 System.out.println ( "Connected." );
                 }
                 catch ( Exception  e ) {
                         System.out.println ( e.toString () );
                         System.out.println ( "Connection failed." );
                 }
         }
}

At 05:29 PM 5/30/2000 -0400, you wrote:
>Now, I've set these two as:
>database.default.username=turbine
>database.default.password=turbine
>
>Still I'm getting the following exception:
>
>---------------------------------------------------------------------------
>Exception: java.lang.Error: Error in BasePeer.initTableSchema(Visitor):
>Cannot connect to MySQL server on localhost:3306. Is there a MySQL server
>running on the machine/port you are trying to connect to?
>(java.security.AccessControlException)
>         at
>org.apache.turbine.om.peer.BasePeer.initTableSchema(BasePeer.java:225)
>         at
>org.apache.turbine.om.user.peer.TurbineUserPeer.<clinit>(TurbineUserPeer.jav
>a:146)
>         at
>org.apache.turbine.om.user.TurbineUser.retrieveFromStorage(TurbineUser.java:
>345)
>         at
>org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:113)
>         at
>org.apache.turbine.om.user.peer.UserFactory.getUser(UserFactory.java:88)
>         at
>org.apache.turbine.modules.actions.LoginUser.doPerform(LoginUser.java:96)
>         at org.apache.turbine.modules.Action.perform(Action.java:77)
>         at
>org.apache.turbine.modules.ActionLoader.exec(ActionLoader.java:111)
>         at Turbine.doGet(Turbine.java, Compiled Code)
>         at Turbine.doPost(Turbine.java:387)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:747)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
>         at com.sun.server.ServletState.callService(ServletState.java:226)
>         at
>com.sun.server.ServletManager.callServletService(ServletManager.java:936)
>         at
>com.sun.server.http.servlet.InvokerServlet.service(InvokerServlet.java:137)
>         at javax.servlet.http.HttpServlet.service(HttpServlet.java:840)
>         at com.sun.server.ServletState.callService(ServletState.java:226)
>         at
>com.sun.server.ServletManager.callServletService(ServletManager.java:936)
>         at
>com.sun.server.ProcessingState.invokeTargetServlet(ProcessingState.java:423)
>         at
>com.sun.server.http.HttpProcessingState.execute(HttpProcessingState.java:79)
>         at com.sun.server.http.stages.Runner.process(Runner.java:79)
>         at
>com.sun.server.ProcessingSupport.process(ProcessingSupport.java:294)
>         at com.sun.server.Service.process(Service.java:204)
>         at
>com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java
>:374)
>         at
>com.sun.server.http.HttpServiceHandler.handleRequest(HttpServiceHandler.java
>:166)
>         at com.sun.server.HandlerThread.run(HandlerThread.java:162)
>---------------------------------------------------------------------------
>
>Where else may I be doing wrong?
>
>One thing I forgot to mention in my last mail: I'm getting the "login"
>screen only if run the JavaWebServer2.0 from the command line. I'm NOT
>getting the login screen in case I run JavaWebServer2.0 as a service in my
>NT machine. Instead I get a blank screen.
>--------------------------------------------------------
>Blank screen's source code goes like this:
><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
>--------------------------------------------------------
>
>Any help on this part also, is appreciated.
>
>- Hement
>
>-----Original Message-----
>From: Jon Stevens [mailto:[EMAIL PROTECTED]]
>Sent: Tuesday, May 30, 2000 3:21 PM
>To: Turbine
>Subject: Re: Getting java.lang.NullPointerException
>
>on 5/30/2000 11:54 AM, Sasan, Hement at [EMAIL PROTECTED] wrote:
>
> > database.default.username=dbUser
> > database.default.password=dbPass
>
>you need to define these.
>
>-jon
>
>
>
>------------------------------------------------------------
>To subscribe:        [EMAIL PROTECTED]
>To unsubscribe:      [EMAIL PROTECTED]
>Problems?:           [EMAIL PROTECTED]



------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Problems?:           [EMAIL PROTECTED]

Reply via email to