Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

We've moved the forum!

Please use forum.silverstripe.org for any new questions (announcement).
The forum archive will stick around, but will be read only.

You can also use our Slack channel or StackOverflow to ask for help.
Check out our community overview for more options to contribute.

Installing SilverStripe /

Getting SilverStripe up and running on your computer and on your web server.

Moderators: martimiz, Sean, Ed, biapar, Willr, Ingo, swaiba

Install SS with SQLite


Go to End


2 Posts   2251 Views

Avatar
TPJ

Community Member, 1 Post

30 November 2011 at 8:14pm

I'd like to use SS 2.4 with an SQLite DB. Untortunatelly, so far I was unable to install SS with such a DB. Here's what I have tried:

A.

1) Download & extract SS 2.4
2) Download & extract the SQLite Database module
3) Place the sqlite3-v1.0 directory in the root SS directory
4) Open in a browser http://localhost/mysite/install.php

The result: no SQLite DB available. PHP has all the required extensions, but SS is missing the module.

B.

1) Download & extract SS 2.4
2) Download & extract the SQLite Database module
3) Place the sqlite3-v1.0 directory in the root SS directory
4) Open in a browser http://localhost/mysite/dev/build

The result: not found, 404

C.

1) Download & extract SS 2.4
2) Download & extract the SQLite Database module
3) Place the sqlite3-v1.0 directory in the root SS directory
4) Open in a browser http://localhost/mysite/index.php/dev/build

The result:

Warning: fopen(/tmp/silverstripe-cache-home-tpj-public_html-ss_simple_test/manifest-index): failed to open stream: Permission denied in /home/tpj/public_html/ss_simple_test/sapphire/core/ManifestBuilder.php on line 120 Fatal error: Cannot write manifest file! Check permissions of /tmp/silverstripe-cache-home-tpj-public_html-ss_simple_test/manifest-index in /home/tpj/public_html/ss_simple_test/sapphire/core/ManifestBuilder.php on line 124

D.

1) Download & extract SS 2.4
2) Download & extract the SQLite Database module
3) Place the sqlite3-v1.0 directory in the root SS directory
4) Open in a browser http://localhost/mysite/install.php/dev/build

The result: The standard installation page (without CSS), SS missing the SQLite module.

E.

1) Download & extract SS 2.4
2) Download & extract the SQLite Database module
3) Place the sqlite3-v1.0 directory in the root SS directory
4) In the console, run "php sapphire/cli-script.php dev/build

The result:

PHP Warning:  Director::protocolAndHost() lacks sufficient information - HTTP_HOST not set.  You probably want to define $_FILE_TO_URL_MAPPING in your _ss_environment.php as instructed on the "sake" page of the doc.silverstripe.com wiki in /home/tpj/public_html/ss_simple_test/sapphire/core/control/Director.php on line 388

Warning: Director::protocolAndHost() lacks sufficient information - HTTP_HOST not set.  You probably want to define $_FILE_TO_URL_MAPPING in your _ss_environment.php as instructed on the "sake" page of the doc.silverstripe.com wiki in /home/tpj/public_html/ss_simple_test/sapphire/core/control/Director.php on line 388
ERROR [User Error]: DB::connect: Not passed a valid database config

(...)

Trace
=====
<ul>user_error(DB::connect: Not passed a valid database config,256)
line 91 of DB.php

DB::connect(<filtered>)
line 65 of cli-script.php

I have found some topics on the SQLite module installation on this forum, but without any solutions. (The authors proudly informed, that they have solved their problems.)

Avatar
Willr

Forum Moderator, 5523 Posts

13 December 2011 at 9:23pm

Also - make sure the folder is named "sqlite3" shouldn't affect it in this case but thats what it should be.

B: 404 - you don't have mod rewrite enabled, thats why C gets a result
C - you need to fix your permissions try create a silverstripe-cache folder in your root with 777.
E - to run sake you need an _ss_environment file.

Downloading 2.4, downloading sqlite3 putting it in root folder then reloading the mysite/install.php should display it. Make sure sqlite3/_config.php file exists (SS will then load that module)