Re: DBI -> Access denied for user...
Martin Ertl <[email protected]>
| Newsgroups | gmane.comp.apache.mod-survey.general |
|---|---|
| Message-ID | <[email protected]> |
*grml* seems like I was very tired yesterday... How should it work when the wrong database is given ? Fortunately weekend is near :-) thx Martin Joel Palmius wrote: > 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 > Skickat av Martin Ertl <[email protected]> till survey-discussion