Home » Forums » Installation and Setup

Newbie DB Question

27 Oct 2009 tmoz

Hi there!
I found your framework recently and it looks great! The part I am actually most interested in is the simple CRUD functionality. So I want to try lunar but I am stuck with database configuration- I want to configure a postgres db running on localhost.
Has anyone a hint for a real ZOOP-Newbie => what config-file maybe an example?
Thanks in advance!
Thomas

‹ Hi everyone! "From A to Zoop" doesn't match SourceForge OR subversion ›

config/db.php

Hi and Welcome to Zoop.

The configuration files for all of the components in Zoop live in the config folder where you copied the app code. In your case you are looking for the db.php file which has commented out lines for a prostgre database on the local host. Uncomment the lines and change them to suite your needs. See below for a sample of what the config file should look like:

config/db.php

////////////////////////////////////////////////////
//              Database Options               	  //
////////////////////////////////////////////////////
 
 
//these are defaults and will be overridden by anything defined before them.
/*
define('db_RDBMS', 'pgsql');
define('db_Username', 'postgres');
define('db_Password', '');
define('db_Server', 'localhost');
define('db_Port', '5432');
define('db_Database', 'databasename');
*/

jmorant@cloud9l... 27 Oct 2009

config/db.php

Thanks for your answer but I still get the same error:

Fatal Error: "DB configuration not defined. Please configure a database connection at `zoop.db.connections.[active_connection].dsn` or `zoop.db.dsn`" in file /var/www/lunar/zoop/db/component.php (on line 35)

Am I wrong that the use of config files dramatically changed with lunar? I am also puzzled that some *.dsn file or definition was missing. I would expect something to configure in the config.yaml in the config directory.
Any hints are welcome!
Thanks, Thomas

tmoz 28 Oct 2009

Lunar Branch

Thomas I just re-read your post and realized you are working with Zoop 2.0 which is still in development. I cannot comment on the state of the db components for that branch. I still have not had time to check it out myself since Zoop 1.3 has done all I have needed and more. I have implemented Zoop 1.5 in a couple projects just for testing and it works extremely well too.

You may want to install 1.5 and get a feel for the flow of Zoop on a Branch that is stable so I can assist you.

jmorant@cloud9l... 29 Oct 2009

config/db.php

Hi,
thanks for your answer! But what I was actually looking for was the easiest possible way to create a nice and easy CRUD application without great knowledge of programming. Thats why I found zoop 2.0 fascinating- if I am right such a feature is in the pipeline.
Thanks for your offer to assist with a stable production environment. I tried that also and can communicate with the database but this is no big difference to my existing plain php-files.
So I will be waiting for the new stable release.
Thanks, Thomas

tmoz 30 Oct 2009

Zoop 2

Thanks for your interest. Zoop 2 is progressing nicely. We haven't gotten around to updating all of the db classes, but we have full support for doctrine which is quite stable.

 

I'm working on a post outlining a quick getting started with Zoop 2 which would answer your question I believe.

 

Co-Author of Zoop Framework
http://spf13.com

steve.francia 19 Nov 2009