+- LetoDMS Community Forum (https://community.letodms.com)
+-- Forum: LetoDMS Support (https://community.letodms.com/forumdisplay.php?fid=4)
+--- Forum: Technical Support (https://community.letodms.com/forumdisplay.php?fid=10)
+--- Thread: Access Denied problem - new installation (/showthread.php?tid=67)
Access Denied problem - new installation - d0nnyoz - 05-19-2010
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?
RE: Access Denied problem - new installation - administrator - 05-19-2010
(05-19-2010, 01:18 AM)d0nnyoz Wrote: 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.
RE: Access Denied problem - new installation - d0nnyoz - 05-19-2010
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.
RE: Access Denied problem - new installation - d0nnyoz - 05-19-2010
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....