CakePHP SQLite

Question

Hi all! 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:

var $default = array(
  'driver' => 'sqlite',
  'connect' =>'sqlite_popen',
  'persistent' => false,
  'host' => 'localhost',
  'port' => '',
  'login' => '',
  'password' => '',
  'database' => '/home/MY_USER_NAME/public_html/my_database.sqlite',
  'schema' => '',
  'prefix' => '',
  'encoding' => ''
);

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?

Thanks in advance.

Answer 1

Are you trying to connect to a SQLite 3 database? CakePHP doesn't support them yet.

Other than that, you might want to try adding the leading / in your path. Seems like you're trying to do an absolute path but without the leading slash it's not going to do what you think it's going to do.

Answer 2

SQLite3 is not officially supported yet by CakePHP... probably because the file attached to this bug/enhancement works.

https://trac.cakephp.org/ticket/3003

Grab the latest version of the file, update it with any newer patches, upload it to your cake/libs/model/datasources/dbo directory and configure it in your database.php file.

I am using a file called dbo_sqlite3.php

My configuration file uses this for the driver setting:

  'driver' => 'sqlite3',

Answer 3

Posted a howto Trac solution and another one for using sqlite3 with Cakephp 1.2.x at http://gacimartin.com/2009/11/15/como-utilizar-sqlite3-en-cakephp-1-2/

Answer 4

How to CakePHP with SQLite3:

Requirments:

• CakePHP version 1.3
• Datasources plugin

Steps:

Unpack the Datasources plugin in place.

Edit dbo_sqlite3.php and add:

App::import('Datasource','DboSource');

...just before the 'class' definition.

Use the following configuration in your database.php file:

var $default = array(
    'datasource' => 'Datasources.DboSqlite3',
    'login' => '',
    'password' => '',
    'database' => '/full/path/to/db.sqlite');

Done.