Tomcat 4.1.10 - Administration Tool Setup

[MP]

Has any body successfully installed and made this administration tool operation wich comes along tomcat4. If yes can you give how to do the configuration tomake it work ?

[Rene Larsen]

You need to add a user in '<tomcat_root>\conf\tomcat-users.xml'
Like this:

<user username="[your logon name]" password="[your password]" fullName="[some name]" roles="admin,manager,standard"/>

now you can make a logon by calling e.g. 'http://127.0.0.1/admin'
Rene

[Rene Larsen]

Can you assist me in setting up a small demo software of mine which works on jsp & mysql.
I want you to guide me in placing the java files and then configuring the jdbc and mysql

I've made a JDBC connect sample for mySQL:

import java.sql.*;
class JdbcTest {
   public static void main (String args []) throws Exception {
      // Load JDBC driver
      Class.forName("com.mysql.jdbc.Driver").newInstance();
      // Connect to the local database
      Connection conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/<DATABASE_NAME>?user=<USER_NAME>&password=<PASSWORD>");
      // Query the employee names
      Statement stmt = conn.createStatement();
      ResultSet rs = stmt.executeQuery("select * from test;");
      // Print the name out
      while(rs.next())
         System.out.println(rs.getString(1));
      // close the resultSet
      rs.close();
      // Close the statement
      stmt.close();
      // Close the connection
      conn.close();
   }
}

You places your resources like this:

<tomcat_lib>/webapps/myWebApp/
                              *.jsp
                              WEB_INF/classes/*.class
                              WEB-INF/web.xml

PS.: Try to reply to the forum and not as a 'private message', this way you get a lot of experts helping you instead of only one.
/Rene
[ September 24, 2002: Message edited by: Rene Larsen ]

[MP]

I could configure the data source through the new tomcat webserver GUI inteface. Now i want to know how to use the manager webapps to configure the program which are htm and jsp files

[MP]

Thanks for the help received from Rene which helped me to configure tomcat.
Now i am facing the following problem when i am tyring to run and see a small demo programme
I am running tomcat4 @ run command and it is showing the following error in spite of me configuring the jdbc connections :
================================
[root@localhost root]# tomcat4 run
Using CATALINA_BASE: /var/tomcat4
Using CATALINA_HOME: /var/tomcat4
Using CATALINA_TMPDIR: /var/tomcat4/temp
Using JAVA_HOME: /usr/java/jdk1.3.1_04
[INFO] Registry - -Loading registry information
[INFO] Registry - -Creating new Registry instance
[INFO] Registry - -Creating MBeanServer
[INFO] Http11Protocol - -Initializing Coyote HTTP/1.1 on port 8080
Starting service Tomcat-Standalone
Apache Tomcat/4.1
[INFO] Http11Protocol - -Starting Coyote HTTP/1.1 on port 8080
[INFO] ChannelSocket - -JK2: ajp13 listening on tcp port 8009
[INFO] JkMain - -Jk running ID=0 time=16/66 config=/var/tomcat4/conf/jk2.proper
ties
java.sql.SQLException: General error: Access denied for user: '@localhost.locald
omain' to database 'b2bdata'
at com.mysql.jdbc.MysqlIO.sendCommand(Unknown Source)
at com.mysql.jdbc.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.jdbc2.Connection.connectionInit(Unknown Source)
at com.mysql.jdbc.Driver.connect(Unknown Source)

=====================
Can some body help me to figure out from where it is deriving the default userid for connection or to to redirect tomcat to see the jdbc configuration userid and password for connecting to database

[MP]

Can any body assit me in compiling the java & jsp files to have the required class files in the debugging mode