DBI -> Access denied for user...
Martin Ertl <[email protected]>
| Newsgroups | gmane.comp.apache.mod-survey.general |
|---|---|
| Message-ID | <[email protected]> |
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