I just posted to another thread on this eact problem issue. The example MySQL realm in server.xml is wrong. MySQL uses an amperstand character (&) between the user and password parameters in the URL. Here is the correct URL for making a connection to a MySQL database:
connectionURL="jdbc:mysql://crypton:3306/authority?user=tkadmin&password=tkadmin" & is used because XML standards require the & symbol be expressed this way. Hope this helps you out. --David On Wednesday 06 March 2002 12:50 am, you wrote: > This is a permissions problem on your system. The error means what it > says. > > At 12:22 PM 3/5/02 -0800, you wrote: > >Setting up Tomcat & Mysql is documented on the Tomcat > >website. Look at the documentation link and then > >under realms. There is a discussion of using database > >for authentication and MySQL is the example they show > >for the deployment descriptors. > > > >There is also an excellent book out called "JSP, > >MYSQL, and Servlet Development" or something close. > >It documents the process well too. > > > >Tim > > > >--- [EMAIL PROTECTED] wrote: > > > Hi, > > > > > > I have been trying to setup JDBC Realm authen with > > > mysql and have hit a > > > dead end. > > > I have been following the posts but my errors don't > > > match what others are > > > getting. > > > I'm sure this is a config error on my part but I > > > just can't seem to figure > > > it out. > > > > > > > > > When trying to startup Tomact 4 I get the following > > > error in catalina.out I > > > have also attached the > > > relavant server.xml entries. > > > > > > > > > SERVER.XML > > > > > > <Realm > > > className="org.apache.catalina.realm.JDBCRealm" > > > debug="99" > > > driverName="org.gjt.mm.mysql.Driver" > > > >connectionURL="jdbc:mysql://crypton:3306/authority?user=tkadmin;password=t > >kadmin" > > > > > userTable="users" > > > userNameCol="user_name" > > > userCredCol="user_pass" > > > userRoleTable="user_roles" > > > roleNameCol="role_name" /> > > > > > > > > > CATALINA.OUT error > > > > > > Starting service Tomcat-Standalone > > > Apache Tomcat/4.0.3 > > > Catalina.start: LifecycleException: Exception > > > opening database > > > connection: jav > > > a.sql.SQLException: Invalid authorization > > > specification: Access denied for > > > user: > > > 'tkadmin;[EMAIL PROTECTED]' (Using password: > > > NO) > > > LifecycleException: Exception opening database > > > connection: java.sql.SQLExcepti > > > on: Invalid authorization specification: Access > > > denied for user: > > > 'tkadmin;passwo > > > [EMAIL PROTECTED]' (Using password: NO) > > > > > > > > > Thanks > > > > > > randy > > > > > > > > > -- > > > To unsubscribe: > > > <mailto:[EMAIL PROTECTED]> > > > For additional commands: > > > <mailto:[EMAIL PROTECTED]> > > > Troubles with the list: > > > <mailto:[EMAIL PROTECTED]> > > > >__________________________________________________ > >Do You Yahoo!? > >Try FREE Yahoo! Mail - the world's greatest free email! > >http://mail.yahoo.com/ > > > >-- > >To unsubscribe: <mailto:[EMAIL PROTECTED]> > >For additional commands: <mailto:[EMAIL PROTECTED]> > >Troubles with the list: <mailto:[EMAIL PROTECTED]> -- To unsubscribe: <mailto:[EMAIL PROTECTED]> For additional commands: <mailto:[EMAIL PROTECTED]> Troubles with the list: <mailto:[EMAIL PROTECTED]>
