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
