Hi Replace & for & to get a valifd XML
Bye El Dom 03 Ago 2003 06:39, engp0510 escribi�: > Thanks very much! > Y, I have tried. But always throw org.xml.sax.SAXParseException said a ";" > is needed to end the quote of "password". > Any advice? > > > ----- Original Message ----- > From: "Emmanuel G. Dialynas" <[EMAIL PROTECTED]> > To: "engp0510" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Sunday, August 03, 2003 6:07 PM > Subject: Re: HELP!! TOMCAT and MYSQL > > > Try: > > > connectionURL="jdbc:mysql://localhost/authority?user=leeson&password=xxxx" > > At 04:32 �� 03/08/03 +0800, engp0510 wrote: > >Hi, > > I am using Tomcat 4.0 and MySQL 4.0.14 on WIn2K Professional. > >In Server.XML of Tomcat, I use: > > > > <Realm className="org.apache.catalina.realm.JDBCRealm" debug="99" > > driverName="org.gjt.mm.mysql.Driver" > > > >connectionURL="jdbc:mysql://localhost/authority?user=leeson;password=xxxx" > > userTable="users" userNameCol="user_name" > > userCredCol="user_pass" > > userRoleTable="user_roles" roleNameCol="role_name" /> > > > >In MySQL, I set all user must access database with password and grant user > >'leeson' with all privileges @ localhost. I can use leeson and password to > >log into > >MySQL. All setting of MySQL will work well when I login MySQL using CMD on > >Win2K > > > >But when I start tomcat-standalone, there is always : > > > >Catalina.start: LifecycleException: Exception opening database > > connection: java.sql.SQLException: Invalid authorizatio > >n specification: Access denied for user: 'leeson;[EMAIL PROTECTED]' > > (Using password: NO) > >LifecycleException: Exception opening database connection: > >java.sql.SQLException: Invalid authorization specification: > > Access denied for user: 'leeson;[EMAIL PROTECTED]' (Using password: NO) > > ... > > > >So, it seem Parser regard user as "leeson;password", not "leeson". But if > >I grant leeson all privileges but without password, the tomcat could work. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
