----------------------------------------------------------------
BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
WHEN YOU POST, include all relevant version numbers, log files,
and configuration files. Don't make us guess your problem!!!
----------------------------------------------------------------
Hi Bing
The simple way to work this out is to follow a simple procedure.
Login or telnet to the host that is making the JDBC request to the MySQL
database.
Run the mysql command and login with the username and password your
servlet is using. Then manually type the query your servlet is trying to
perform.
The key to making MySQL authenticate you/your servlet, is to make sure you
have granted appropriate right to:
1. The username
2. The password matches with the username
3. The address making the request matches with that username/password
combination
4. The user has rights to perform the operation being requested
4 simple tests to solve your problem.
hth
Chris
On Tue, 10 Oct 2000 12:55:35 +0100, Bing Yang wrote:
>----------------------------------------------------------------
>BEFORE YOU POST, search the faq at <http://java.apache.org/faq/>
>WHEN YOU POST, include all relevant version numbers, log files,
>and configuration files. Don't make us guess your problem!!!
>----------------------------------------------------------------
>
>
>Firstly thank Brevsville Administrator and Savio Mesquita for help.
>
>However I still have the problem.
>
>Here are details:
>
>I have:
>
>1 Apache 1.3.12 & JServ1.1.2 on NT4 with SP6
>2 Microdsoft SQL 7 server on the same machine.
>
>
>
>3 One servlet called MSSQLConnectorServlet in zone "byuntility" to do
>the
>connection work with MS SQL using JDBC:ODBC driver by
>
> public void init(javax.servlet.ServletConfig config) throws
>javax.servlet.ServletException {
> super.init(config);
> try {
> this.connector=new MSSQLServerConnector(
> "LocalServer","user","password");
> this.connector.connect();
> // make the connection
> }
> catch(java.sql.SQLException e) {
> throw new javax.servlet.UnavailableException(this,e.getMessage());
> }
> catch(ClassNotFoundException e) {
> throw new javax.servlet.UnavailableException(this,e.getMessage());
> }
> catch(Exception e) {
> throw new javax.servlet.UnavailableException(this,e.getMessage());
> }
> }
>
>
>
>4 One Servlet called workload in zone "workload" to serve user's
>request
>by
>
> public void init(ServletConfig config) throws
>javax.servlet.ServletException {
>
> super.init(config);
>
> byutility.ConnectorServletInterface databaseServlet=
> (byutility.ConnectorServletInterface) (getServletConfig().
> getServletContext().
>
>getServlet("byutility.MSSQLConnectorServlet"));
>
> this.connector= databaseServlet.getConnector();
> }
>
>
>5 On web browser, if I type
>http://myMachine/servlets/workload/workload
>
> I get:
>
> Authorization Required
> This server could not verify that you are authorized to access the
>document requested. Either you supplied the wrong credentials (e.g.,
>bad
>password), or your browser doesn't understand how to supply the
>credentials required.
>
>
>
>6 On web browser, if I type
>
> http://myMachine/servlets/byutility/byutility.MSSQLConnectorServlet
>
> I get the result.
>
>
>7 I am quite sure I should do some work on configuration for one
>servlet in one zone to call another zone servlet , but have not got any
>clue.
>
>
>
>Hope someone can give me a direction.
>
>Bing
>
>
>--
>Dr. Bing Yang Tel: +44 121 643 6711 X231
>Maunsell Ltd Fax: +44 121 643 1357
>Attwood House, 1 Worcester Walk Web: www.maunsell.co.uk
>New Street, Birmingham, B2 4NX, United Kingdom
>
>
>
>--
>--------------------------------------------------------------
>Please read the FAQ! <http://java.apache.org/faq/>
>To subscribe: [EMAIL PROTECTED]
>To unsubscribe: [EMAIL PROTECTED]
>Search Archives:
><http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
>Problems?: [EMAIL PROTECTED]
>
--
--------------------------------------------------------------
Please read the FAQ! <http://java.apache.org/faq/>
To subscribe: [EMAIL PROTECTED]
To unsubscribe: [EMAIL PROTECTED]
Search Archives:
<http://www.mail-archive.com/java-apache-users%40list.working-dogs.com/>
Problems?: [EMAIL PROTECTED]
