How do I remove all references to the Sample DB when using the Forena reports module on a server without PDO Sqllite?

Question

We have Forena installed on a server that doesn't have the PDO driver for Sqllite and would like to remove all references to the Sample DB repository so that Forena pages don't display an error about the missing driver. The users see a lot of:

PDO driver support for sqlite not installed

I first tried removing permissions on the SampleDB repository as mentioned in one thread in the issue queue. This had no effect and the error message was still displayed.

I have tried using drupal_alter to remove the repos:

function mymodule_forena_repos_alter(&$repos) {
  if(isset($repos['forena_help'])){
    unset($repos['forena_help']);
  }
  if(isset($repos['sampledb'])){
   unset($repos['sampledb']);
 }

}

I then get a new error:

Undefined repositorysampledb

Undefined repositoryforena_help

I have tried patching the Forena module to unset the settings.php variables inside the sampledb folder. That also gives a new error along the lines of "PDO Driver not found".

How do I remove all references to the SampleDB repo? I would also like to remove the Forena Help and Drupal Admin repos if possible.

Answer 1

Quote from Dave's (Forena maintainer) comment in a related Support Issue:

... You might uncheck permissions associated with accessing sample reports to make sure other users don't see this error.

Using this approach you should be OK when upgrading to future versions.

Disclosure: I'm a co-maintainer of Forena (and contributed quite a bit of the content of that forena_help repo you seem to be strugling with).