Thanks Martin for zour response! I will track that link and try to follow that instructions, and after i do it i will response zou back again. Thanks again.
--- Martin Gainty <[EMAIL PROTECTED]> wrote: > Good Morning Nenad > > If you follow these instructions > http://www.onjava.com/pub/a/onjava/2001/07/24/tomcat.html?page=2 > specifically.. populating with JDBCRealm these > attributes must be populated > > className The fully qualified name of the Realm > attribute e.g. > org.apache.catalina.realm.JDBCRealm > driverName The specific driver used to connect to > the DB e.g. > org.gjt.mm.mysql.Driver > connectionURL The URL referencing the DB > containing the users e.g. > jdbc:mysql://localhost/tomcatusers?user=test;password=test > connectionName username to use when > connecting to the DB (you can > encode connectionName in the connectionURL) > connectionPassword The password to use when > connecting to the DB (you can > encode connectionPassword in the connectionURL)) > userTable DB table containing > user credentials > userNameCol Name of Column to use when > referencing > username..best to call it 'user' > userCredCol Name of column to use when > referecning password > .best to call it 'password' > userRoleTable DB Table which contains > mapping between userTable > and roles and table containing possible user roles > roleNameCol userRoleTable column name > which specifies roles > given to a user..best to call 'role' > > HTH > Martin -- > > This email message and any files transmitted with it > contain confidential > information intended only for the person(s) to whom > this email message is > addressed. If you have received this email message > in error, please notify > the sender immediately by telephone or email and > destroy the original > message without making a copy. Thank you. > > ----- Original Message ----- > From: "Nenad Bosanac" <[EMAIL PROTECTED]> > To: <users@tomcat.apache.org> > Sent: Sunday, June 04, 2006 10:20 AM > Subject: Can`t resolve JDBCRealm problem > > > > Hi ! > > I try to implement JDBCRealm but witout success. > > I read documentation and make all as it said in > it,but > > when i try to login in tomcat Manager i can't do > it. > > I put this code in server.xml: > > > > <Realm > > className="org.apache.catalina.realm.JDBCRealm" > > driverName="com.mysql.jdbc.Driver" > > > > > connectionURL="jdbc:mysql://localhost:3306/jdbcrealm" > > connectionName="root" connectionPassword="" > > userTable="users" userNameCol="user_name" > > userCredCol="user_pass" > > userRoleTable="user_roles" > > roleNameCol="role_name" /> > > > > also i have this in server.xml > > > > <Realm > > > className="org.apache.catalina.realm.UserDatabaseRealm" > > resourceName="UserDatabase"/> > > > > I have database called jdbcrealm and to tables > like > > this in it > > > > create table users ( > > user_name varchar(15) not null primary > key, > > user_pass varchar(15) not null > > ); > > > > create table user_roles ( > > user_name varchar(15) not null, > > role_name varchar(15) not null, > > primary key (user_name, role_name) > > ); > > > > My MySQL databse username is root and i have no > > password for MYSQL database. > > I put mysql-connector-3.0.17.jar in > > $CATALINA_HOME/server/lib and in > > $CATALINA_HOME/common/lib. > > > > I use 5.5.16 Tomcat. > > > > I got this error when i try to connect to Manager: > > -------------------------------------------- > > HTTP Status 403 - Access to the requested resource > has > > been denied > > ________________________________________ > > type Status report > > message Access to the requested resource has been > > denied > > description Access to the specified resource > (Access > > to the requested resource has been denied) has > been > > forbidden. > > > ---------------------------------------------------- > > > > What i am doing wrong? > > Any help will be great ,thanks > > > > > > __________________________________________________ > > Do You Yahoo!? > > Tired of spam? Yahoo! Mail has the best spam > protection around > > http://mail.yahoo.com > > > > > --------------------------------------------------------------------- > > To start a new topic, e-mail: > users@tomcat.apache.org > > To unsubscribe, e-mail: > [EMAIL PROTECTED] > > For additional commands, e-mail: > [EMAIL PROTECTED] > > > > > > --------------------------------------------------------------------- > To start a new topic, e-mail: > users@tomcat.apache.org > To unsubscribe, e-mail: > [EMAIL PROTECTED] > For additional commands, e-mail: > [EMAIL PROTECTED] > > __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com --------------------------------------------------------------------- To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
