Access Denied problem - new installation

[d0nnyoz]

Hi

I have just loaded letoDMS onto my server to check it out and the installation seemed to go well. The database creation and tables also went without a hitch.

I then logged in (admin/admin) and on the homepage after login I get this message under My Documents:

Access denied for user 'web132-pidocs'@'%' to database 'web132-pidocs': CREATE TEMPORARY TABLE IF NOT EXISTS `ttstatid` (PRIMARY KEY (`statusID`), INDEX (`maxLogID`)) SELECT `tblDocumentStatusLog`.`statusID`, MAX(`tblDocumentStatusLog`.`statusLogID`) AS `maxLogID` FROM `tblDocumentStatusLog` GROUP BY `tblDocumentStatusLog`.`statusID` ORDER BY `tblDocumentStatusLog`.`statusLogID`

Also displayed is a Warning:

Internal error. Unable to complete request. Exiting.

See attached screen grab.
Can someone let me know why this is happening?

[administrator]

Hi

I have just loaded letoDMS onto my server to check it out and the installation seemed to go well. The database creation and tables also went without a hitch.

I then logged in (admin/admin) and on the homepage after login I get this message under My Documents:

Access denied for user 'web132-pidocs'@'%' to database 'web132-pidocs': CREATE TEMPORARY TABLE IF NOT EXISTS `ttstatid` (PRIMARY KEY (`statusID`), INDEX (`maxLogID`)) SELECT `tblDocumentStatusLog`.`statusID`, MAX(`tblDocumentStatusLog`.`statusLogID`) AS `maxLogID` FROM `tblDocumentStatusLog` GROUP BY `tblDocumentStatusLog`.`statusID` ORDER BY `tblDocumentStatusLog`.`statusLogID`

Also displayed is a Warning:

Internal error. Unable to complete request. Exiting.

See attached screen grab.
Can someone let me know why this is happening?

that means , LetoDMS is not able authenticate the User in mysql

Thanks

LetoDMS team.

[d0nnyoz]

But this doesn't make sense:

>>user 'web132-pidocs'@'%'
What does the "@'%' " mean?

Can you offer a solution?
My settings file is setup correctly but somehow the user cannot get access to the database.

[d0nnyoz]

OK, I believe this is now fixed.
By default, my host does not allow database users to create temporary tables - I needed to request this access.
This has now been added to the user privileges and the system works fine.

Thanks again....