failed to open xapian db

[GiulianoM]

hi everybody, i'm here again. we have abandoned plesk. fresh server without plesk, only centos 7.2, xapian 1.2.23, php 5.6.21. we are trying to use xapian with chamilo 1.10.4, which has a dedicated plugin functioning with all previous version of xapian and chamilo too. we know there are some issue in chamilo-xapian-plugin but they occur during using xapian, not in install phase. now the issue: xapian installed with php, it is visible in the chamilo system, but it seems no xapian db exists and cannot create it in the chamilo-plugin-xapian folder. "Error: Failed to open the search DB" where "search DB" is the db folder passed by chamilo plugin to xapian db object. maybe some permission, but that folder is writable, maybe some missing setting for folder db, as xapian is installed in default mode we assume, as in docs, it is using chert db backend, but where does it create the default folder for db? execpt what can be related specifically to chamilo, is there other setting/configuration that we can missed or can do? thanks

[James Aylett]

Xapian has no fixed location for storing its databases; applications (such as Chamilo) that use Xapian specify where the database should live on disk. There are three things I'd look for:

• where is Chamilo documented as putting its database? (​https://github.com/chamilo/chamilo-lms/blob/720288ad0de934a4e7da9c8a7bae7be7124c39ce/main/inc/lib/search/xapian/XapianIndexer.class.php#L79)
• is there a separate command for creating the database before running Chamilo?
• are the Unix permissions correct on the parent directory to allow for the database to be created?

This is in any case an issue to do with Chamilo (either documentation or a bug at their end) rather than Xapian.

[GiulianoM]

thank you James 1) chamilo put its db in plugin/searchdb folder, i know that 2) this is the golden question, i'm searching on because it is for me too the point of connection between chamilo and xapian 3) i'm quite sure that all permission are ok, but i'll re-check to be completely sure, as it seems to me too the real root of my issue, as when "failed to connect/open file..." appears.

i know that maybe it is more a chamilo issue than xapian issue, but in the spirit of communities i'm asking help here as i've done in chamilo forum to have the help from all the best experienced people in their field. this can help me to reduce the field of research for the problem and solution

thank you also for your quick answer, not usual in general forums.

[GiulianoM]

i confirm the closure of ticket. it was a permission setting not accepted. now it is working fine except other little issues. not sure they're related to xapian, maybe more concerned with chamilo plugin. the issue: search result empty