Re: Can't locate the database?

The tutorial didn't really tell me how to do that.  Actually, I'm not telling Cake anywhere what DB to use.  How and where can I set that?

On Thu, Sep 29, 2011 at 4:04 PM, Ryan Schmidt <google-2010@ryandesign.com> wrote:

......so you have a *database* called cake_posts that contains a *table* called posts?

Also, in your config I see you have chosen not to set up the $default database config but instead to set up a new config called $cake_posts. Where are you telling CakePHP that you want it to use the new $cake_posts config instead of the $default config?

On Sep 29, 2011, at 14:02, Yves S. Garret wrote:

> Yes.  I called the database cake_posts.  Do I set something up so that it points to that specific db?
>
> 2011/9/29 Vinícius Moraes de Araújo <vinizinmoraes@gmail.com>
> You have the table posts created on your database ?
>
> Atenciosamente,
>
> Vinícius Moraes
>
>
> 2011/9/29 Yves S. Garret <yoursurrogategod@gmail.com>
> By the way, this is my database.php file:
>
> <?php
> /**
>  * This is core configuration file.
>  *
>  * Use it to configure core behaviour ofCake.
>  *
>  * PHP versions 4 and 5
>  *
>  * CakePHP(tm) : Rapid Development Framework (http://cakephp.org)
>  * Copyright 2005-2011, Cake Software Foundation, Inc. (http://cakefoundation.org)
>  *
>  * Licensed under The MIT License
>  * Redistributions of files must retain the above copyright notice.
>  *
>  * @copyright     Copyright 2005-2011, Cake Software Foundation, Inc. (http://cakefoundation.org)
>  * @link          http://cakephp.org CakePHP(tm) Project
>  * @package       cake
>  * @subpackage    cake.app.config
>  * @since         CakePHP(tm) v 0.2.9
>  * @license       MIT License (http://www.opensource.org/licenses/mit-license.php)
>  */
> /**
>  * In this file you set up your database connection details.
>  *
>  * @package       cake
>  * @subpackage    cake.config
>  */
> /**
>  * Database configuration class.
>  * You can specify multiple configurations for production, development and testing.
>  *
>  * driver => The name of a supported driver; valid options are as follows:
>  *        mysql         - MySQL 4 & 5,
>  *        mysqli         - MySQL 4 & 5 Improved Interface (PHP5 only),
>  *        sqlite        - SQLite (PHP5 only),
>  *        postgres    - PostgreSQL 7 and higher,
>  *        mssql        - Microsoft SQL Server 2000 and higher,
>  *        db2            - IBM DB2, Cloudscape, and Apache Derby (http://php.net/ibm-db2)
>  *        oracle        - Oracle 8 and higher
>  *        firebird    - Firebird/Interbase
>  *        sybase        - Sybase ASE
>  *        adodb-[drivername]    - ADOdb interface wrapper (see below),
>  *        odbc        - ODBC DBO driver
>  *
>  * You can add custom database drivers (or override existing drivers) by adding the
>  * appropriate file to app/models/datasources/dbo.  Drivers should be named 'dbo_x.php',
>  * where 'x' is the name of the database.
>  *
>  * persistent => true / false
>  * Determines whether or not the database should use a persistent connection
>  *
>  * connect =>
>  * ADOdb set the connect to one of these
>  *    (http://phplens.com/adodb/supported.databases.html) and
>  *    append it '|p' for persistent connection. (mssql|p for example, or just mssql for not persistent)
>  * For all other databases, this setting is deprecated.
>  *
>  * host =>
>  * the host you connect to the database.  To add a socket or port number, use 'port' => #
>  *
>  * prefix =>
>  * Uses the given prefix for all the tables in this database.  This setting can be overridden
>  * on a per-table basis with the Model::$tablePrefix property.
>  *
>  * schema =>
>  * For Postgres and DB2, specifies which schema you would like to use the tables in. Postgres defaults to
>  * 'public', DB2 defaults to empty.
>  *
>  * encoding =>
>  * For MySQL, MySQLi, Postgres and DB2, specifies the character encoding to use when connecting to the
>  * database.  Uses database default.
>  *
>  */
> class DATABASE_CONFIG {
>
>     var $default = array(
>         'driver' => 'mysqli',
>         'persistent' => false,
>         'host' => 'localhost',
>         'login' => 'root',
>         'password' => 'summer11',
>         'database' => 'mysql',
>         'prefix' => '',
>         //'encoding' => 'utf8',
>     );
>
>     var $cake_posts = array(
>         'driver' => 'mysqli',
>         'persistent' => false,
>         'host' => 'localhost',
>         'login' => 'root',
>         'password' => 'summer11',
>         'database' => 'cake_posts',
>         'prefix' => '',
>         //'encoding' => 'utf8',
>     );
>
>     var $doc_lookup = array(
>         'driver' => 'mysqli',
>         'persistent' => false,
>         'host' => 'localhost',
>         'login' => 'root',
>         'password' => 'summer11',
>         'database' => 'doc_lookup',
>         'prefix' => '',
>         //'encoding' => 'utf8',
>     );
>
>     var $test = array(
>         'driver' => 'mysql',
>         'persistent' => false,
>         'host' => 'localhost',
>         'login' => 'user',
>         'password' => 'password',
>         'database' => 'test_database_name',
>         'prefix' => '',
>         //'encoding' => 'utf8',
>     );
> }

--

Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.


To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php

--
Our newest site for the community: CakePHP Video Tutorials http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others with their CakePHP related questions.
 
 
To unsubscribe from this group, send email to
cake-php+unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/cake-php