Jake, HEY! That did it. Thanks very much for the suggestion.
Ken -----Original Message----- From: Jacob Kjome [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 2:42 PM To: Tomcat Users List Subject: Re[2]: JDBC realm problems Hello Ken, Well, then write it as the entity & which is the xml equivalent of "&" as long as the DTD defines that entity. Jake Monday, April 22, 2002, 1:22:56 PM, you wrote: JK> Yes I have. After some more investigation I think the problem is this: the JK> entry in server.xml is like this user=ken;password=ken. But mySQL wants a JK> "&" and xml parser demands a ";". With a ";" mySQL thinks no password was JK> sent and so denies me with 'password: no'. With "&" debug=99 comes into play JK> and tells me "The reference to entity 'password' must end with the ';' JK> delimiter". But as soon as I do that then mySQL no longer sees the JK> password!! JK> I have read about the need to change the ";" to "&" while investigating on JK> google so I know some people have found that necessary. My problem is that I JK> then get the parser error. JK> So it seems to me I'm sitting on the horns of a dilemma from which I hope JK> someone can remove me. JK> Thanks! JK> -----Original Message----- JK> From: Rick Fincher [mailto:[EMAIL PROTECTED]] JK> Sent: Monday, April 22, 2002 2:14 PM JK> To: Tomcat Users List JK> Subject: Re: JDBC realm problems JK> Hi Ken, JK> Have you tried setting the debug level to 99 in the realm tag in server.xml? JK> You may have already done this, but it will add a lot more info to the log JK> about the process of getting into the realm. JK> Rick >> Hi, >> >> I've spent many hours last week and a few more today trying to get JDBC >> security realm to work and keep stumbling on this error: >> java.sql.SQLException: General error: Access denied for user: >> 'localhost.localdomain' to database 'tomcatusers'; >> >> I'm sure many people have problems getting this to work right off and I've >> read a fair amount about various solutions. But what I can't figure out is >> why the access denied error doesn't include a user name but only >> localhost.localdomain. I've put user and password in server.xm; there is a >> tomcatusers table with what i believe are the correct entries. In fact >> they're copied/modified from the Goodwill book. I wouldn't be surprised by JK> a >> bad username or bad password error but this indicates that the user name >> just isn't being passed along. Anyway I assume that I'll find the answer JK> to >> the authentication problem if I can find out why the user name doesn't JK> seem >> to be passed along to the database call. >> >> Does anyone have any clues? >> >> Thanks, >> >> Ken >> >> >> >> -- >> To unsubscribe: <mailto:[EMAIL PROTECTED]> >> For additional commands: <mailto:[EMAIL PROTECTED]> >> Troubles with the list: <mailto:[EMAIL PROTECTED]> >> >> JK> -- JK> To unsubscribe: <mailto:[EMAIL PROTECTED]> JK> For additional commands: <mailto:[EMAIL PROTECTED]> JK> Troubles with the list: <mailto:[EMAIL PROTECTED]> JK> -- JK> To unsubscribe: <mailto:[EMAIL PROTECTED]> JK> For additional commands: <mailto:[EMAIL PROTECTED]> JK> Troubles with the list: <mailto:[EMAIL PROTECTED]> -- Best regards, Jacob mailto:[EMAIL PROTECTED] -- 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]>