title: How do I connect CakePHP to a SQLite database?
body: <p>I have a rather basic problem: I can't seem to connect CakePHP to my SQLite database. Surprisingly, I didn't find lots of information about it on the internet, though I may be looking up the wrong keywords. Nevertheless, this is my connection code:</p>
  
  <pre><code>var $default = array(
          'driver' =&gt; 'sqlite',
          'connect' =&gt;'sqlite_popen',
          'persistent' =&gt; false,
          'host' =&gt; 'localhost',
          'port' =&gt; '',
          'login' =&gt; '',
          'password' =&gt; '',
          'database' =&gt; '/home/MY_USER_NAME/public_html/my_database.sqlite',
          'schema' =&gt; '',
          'prefix' =&gt; '',
          'encoding' =&gt; ''
  );
  </code></pre>
  
  <p>Still, Cake only says "Cake is NOT able to connect to the database". Also, I don't know where to see the "real" logs (i.e., the error returned from the SQLite "driver"). So, I hit a dead-end. What should I do?</p>
  
  <p>Thanks in advance.</p>