Wiith correct privileges on MySQL, I can't login. May be a bad definition of ResourceLink attribut, look to my current post.
Marcel ----- Original Message ----- From: Jean-Luc BEAUDET <[EMAIL PROTECTED]> To: Tomcat Users List <[EMAIL PROTECTED]> Sent: Wednesday, October 30, 2002 3:33 PM Subject: Re: Connecting to mysql - Server configuration denies accessto data source > Well i don't have all the whole pb cause i just set up my brand new > netscape.... > > It seems yu got in troubles with connection to mysql database. I just > made it yesterday night to have my Tomcat's manager properly set up... > > First make yur database and tables. I can give yu a .sql script. > Second, under sql admin, create a user who'll handle this database: > user: tomcat, password: tompass. > They are many ways to do it, but on i use to is - assuming the db is > called tomcatusers - > > GRANT ALL PRIVILEGES ON tomcatusers.* TO tomcat@localhost IDENTIFIED BY > 'tompass'; > > If all is OK, yu can then test it with: > > shell# mysql -u tomcat -p > password: > bla bla ../.. > mysql> connect tomcatusers; > bla bla ../.. > mysql>mysql> show tables; > +-----------------------+ > | Tables_in_tomcatusers | > +-----------------------+ > | roles | > | user_roles | > | users | > +-----------------------+ > 3 rows in set (0.00 sec) > > mysql> > > After that, yu have to modify the server.xml according to the Tomcat's doc. > > > For instance: > <!-- Because this Realm is here, an instance will be shared > globally --> > <!-- <Realm className="org.apache.catalina.realm.MemoryRealm" /> --> > <!-- Test with a JDBCRealm connected to a MySQL DataBase --> > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > driverName="org.gjt.mm.mysql.Driver" > connectionURL="jdbc:mysql://localhost/tomcatusers" > connectionName="tomcat" connectionPassword="tompass" > userTable="users" userNameCol="user_name" > userCredCol="user_pass" > userRoleTable="user_roles" roleNameCol="role_name" /> > > Hope this help. > > JLB :O) > > Sam Taylor wrote: > > >you might also want to check that you haven't exceeded your max connections > >to mysql... > > > > -----Original Message----- > >From: Larry Meadors [mailto:Larry.Meadors@;plumcreek.com] > >Sent: Wednesday, October 30, 2002 8:31 AM > >To: [EMAIL PROTECTED] > >Subject: RE: Connecting to mysql - Server configuration denies accessto data > >source > > > >I got this a long time ago, so if I am wrong, sorry. > > > >Look in the user table in mysql, and you will find that each user is > >associated with a host. The user you have in your datasource gets a > >hostname added to it (i.e., lmeadors@mylinuxbox instead of just > >lmeadors) and that combination is not valid in your mysql user table. > > > >Thanks for the reminder, I have a mysql database to setup today. ;-) > > > >Larry > > > >PS: BTW, > > John is right - please be more specific in your posts, you will > >get much better responses. > > > > > >>>>[EMAIL PROTECTED] 10/30/02 06:06 AM >>> > >>>> > > > >Has anybody seen what? Please be more specific. > > > >John > > > >>-----Original Message----- > >>From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk] > >>Sent: Wednesday, October 30, 2002 6:50 AM > >>To: Tomcat Users List (E-mail) > >>Subject: Connecting to mysql - Server configuration denies access to > >>data source > >> > >> > >>Has anybody seen this. > >> > >>I've set the mysql tables correctly. > >> > >>Can anybody shed any light on this. > >> > >>Thanks > >> > >>Kevin Passey > >>KDP Software Limited > >>Tel: 01273 712830 > >>Fax: 08700 510103 > >>mailto:kpassey@;kdpsoftware.co.uk > >>http://www.kdpsoftware.co.uk > >> > >>-- > >>To unsubscribe, e-mail: > >><mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > >>For ad > >>ditional commands, e-mail: > >><mailto:tomcat-user-help@;jakarta.apache.org> > >> > > > >-- > >To unsubscribe, e-mail: > ><mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > >For additional commands, e-mail: > ><mailto:tomcat-user-help@;jakarta.apache.org> > > > > > > > >-- > >To unsubscribe, e-mail: > ><mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > >For additional commands, e-mail: > ><mailto:tomcat-user-help@;jakarta.apache.org> > > > > > > > > > >-- > >To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > >For additio > >nal commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> > > > > > > > > > -- > To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> > For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org> > > > -- To unsubscribe, e-mail: <mailto:tomcat-user-unsubscribe@;jakarta.apache.org> For additional commands, e-mail: <mailto:tomcat-user-help@;jakarta.apache.org>
