Sorry, I meant "documents tab" instead of "management tab" below.
-------------------- On 12/05/2012 05:38 PM, glaws wrote: > It appears we have possibly corrupted our glpi database unnoticed > during one of our last two upgrades. Everything works fine except for > viewing documents (mostly .pdf files). The document titles do show > correctly under the management tab. > > For both glpi versions 0.83.6 and 0.83.4, when we try to view loaded > documents under the management tab we get an error message: "File not > found", with the tab indicating "Access Denied". > > Here is the mysql output for "grants": > > mysql> use glpi > Reading table information for completion of table and column names > You can turn off this feature to get a quicker startup with -A > > Database changed > mysql> show grants; > +----------------------------------------------------------------------------------------------------------------------------------------+ > | Grants for > root@localhost > > | > +----------------------------------------------------------------------------------------------------------------------------------------+ > | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY > PASSWORD '*xxxxxxxxxxxxxxx' WITH GRANT OPTION | > | GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT > OPTION > > | > +----------------------------------------------------------------------------------------------------------------------------------------+ > 2 rows in set (0.00 sec) > > And a snip of the actual directory list in /var/lib/mysql/glpi: > > ...................snip.................... > -rw-rw---- 1 mysql mysql 8622 Sep 20 15:31 glpi_documentcategories.frm > -rw-rw---- 1 mysql mysql 156 Sep 20 15:31 glpi_documentcategories.MYD > -rw-rw---- 1 mysql mysql 9216 Sep 20 15:32 glpi_documentcategories.MYI > -rw-rw---- 1 mysql mysql 13282 Sep 20 15:31 glpi_documents.frm > -rw-rw---- 1 mysql mysql 8768 Sep 20 15:31 glpi_documents_items.frm > -rw-rw---- 1 mysql mysql 4572 Sep 20 15:31 glpi_documents_items.MYD > -rw-rw---- 1 mysql mysql 13312 Sep 20 15:32 glpi_documents_items.MYI > -rw-rw---- 1 mysql mysql 18912 Sep 20 15:31 glpi_documents.MYD > -rw-rw---- 1 mysql mysql 25600 Sep 20 15:32 glpi_documents.MYI > -rw-rw---- 1 mysql mysql 12892 Sep 20 15:31 glpi_documenttypes.frm > -rw-rw---- 1 mysql mysql 3520 Sep 20 15:31 glpi_documenttypes.MYD > -rw-rw---- 1 mysql mysql 17408 Sep 20 15:32 glpi_documenttypes.MYI > > We are not using any additional plugins. > > Any ideas what the problem might be and a fix? > > > > -- > Greg Lawson > Network Administrator > Rolling Hills Consolidated Library > 1912 N. Belt Highway > St. Joseph, MO 64506 >
_______________________________________________ Glpi-user mailing list [email protected] https://mail.gna.org/listinfo/glpi-user
