Re: DBI -> Access denied for user...

Sounds to me like this is due to security settings in mysql. I'm a bit 
rusty on mysql, since I've used postgres the last few years. Doesn't the 
mysql logs say anything interesting?

   // Joel

On Thu, 25 Nov 2004, Martin Ertl wrote:

> hm,
>
> I'm trying to use a mysql database as repository for data
> submitted by the user (instead of the autodata textfile).
>
>
> But I can do what I want, the only thing I get is the following:
> Could not do a DBI connect. Error was : Access denied for user: 
> '[email protected]' to database 'data'
>
> the SURVEY tag looks like this:
> <SURVEY
>
> DBIPASSWD="modsurvey"
> DBIUSER="modsurvey"
> DBITABLE="data"
> DBIDSN="dbi:mysql:database=data;host=192.168.1.31"
>
> CHECKKEY="no"
> TITLE="datenbank"
>> 
>
> mod survey runs on 192.168.1.32, the mysql databse on 192.168.1.31
>
> The error occurs in Display.pm (~line 84 if (! ($self->{DBH} = 
> DBI->connect...))
> The values of $dsn, $usr, $psw are ok
>
>
> When I run a test scrip from commandline, everything work well...
>
> I really don't know, what I should do now because it would be very important 
> for
> us to store data not in a file but in a database...
>
>
> thx
> Martin
>
> Skickat av Martin Ertl <[email protected]>
> till survey-discussion
>
>
Skickat av Joel Palmius <[email protected]>
till survey-discussion