cocoon-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Mark Berry <m...@shareaphoto.com>
Subject Re: Problem w/url and SQL processor
Date Wed, 16 Aug 2000 23:49:59 GMT
I am not an expert, but I would guess that your permissions are not
setup correctly on MySQL.

Mike Klein wrote:

> I have been able to use sql example with a copy of Oracle I have
> running, but can't get it to work with MySQL. Can someone show me the
> problem w/my url. I am getting an error of the
> following: java.sql.SQLException: Invalid authorization specification:
> Access denied for user: 'mklein@mother.vxappliance.com' (Using
> password: YES)
>         at org.gjt.mm.mysql.MysqlIO.init(MysqlIO.java, Compiled Code)
>         at org.gjt.mm.mysql.Connection.<init>(Connection.java,
> Compiled Code)
>         at org.gjt.mm.mysql.Driver.connect(Driver.java, Compiled Code)
>
>         at java.sql.DriverManager.getConnection(DriverManager.java,
> Compiled Code)I can use the cmdline (ie mysql) to manually attach
> using these parameters (db=info, user=mklein, pwd=foo).This is the
> mysql reference in my xml file:<connectiondefs>
>   <connection name="VxAppliance">
>    <driver>org.gjt.mm.mysql.Driver</driver>
>    <dburl>jdbc:mysql://192.168.1.2/info</dburl>
>    <username>mklein</username>
>    <password>foo</password>
>   </connection>
>  </connectiondefs>I believe I have added the mysql user
> correctly...adding grants for both mklein@localhost and mklein@"%"
> like the manual said. mike

Mime
View raw message