Re: cakephp dynamic databases.

Finally figured it out.. YAAAAAAAAAAAY. (sorry, took me 3 days and the solution was pretty obvious and nowhere to be found..).
Thanks for pointing the bootstrap thing out :) Your help was awesome!

Thought i'll share it since it cannot be found on the internet after searching for 3 days.

1 Simple solution :)

Bootstrap.php

App::import('Component', 'Session');
App::import('Model', 'User');
$SessionClass = new SessionComponent();
$UserClass = new User();


if($SessionClass->check('User')){
  $user = $UserClass->findById($SessionClass->read('User'));
 
  ConnectionManager::create(
          $name = 'user',
          $config = array('driver' => 'mysql',
                          'persistent' => false,
                          'host' => $user['User']['name'],
                          'login' => $user['User']['dbuser'],
                          'password' => $user['User']['dbpass'],
                          'database' => $user['User']['dbname'])
  );
}

Once the user session is active (User is logged in) switch to the userDb.
If needed you can still switch back. (just define the $useDbConfig in the model for when u need either the default or the user db.)

Thanks again Dr. Loboto :)

2010/10/2 Dr. Loboto <drloboto@gmail.com>

You can improve your beforeFilter solution by doing it in
bootstrap.php: request login database there and create new database
config. In this case you can keep $useDbConfig in all models pointing
to dynamic config and do not hit missing DB error.

On Oct 1, 7:52 pm, Jos Gerrits <josgerrit...@gmail.com> wrote:
> Thats whats happening,
>
> i have 1 database which has the login details for the other databases.
>

> 2010/10/1 Jeremy Burns | Class Outfit <jeremybu...@classoutfit.com>

>
>
>
> > Couldn't store this data in a separate database that just has log in
> > details?
>
> > Jeremy Burns

> > *Class Outfit*
> > *
> > *
> > jeremybu...@classoutfit.com <jeremybu...@mac.com>

> >http://www.classoutfit.com
>
> > On 30 Sep 2010, at 20:06, nithiz wrote:
>
> > Hi all,
>
> > im developing an application which has the cakephp installed on 1
> > server and has a login system for customers to connect to their own
> > databases.
>
> > Now my question is, is there an alternative for manualy entering all
> > customers (1000+) in the database.php config file?
>
> > I have all my customers in a local database with all their database
> > configurations. So my default in my database.php config in cakephp is
> > the local database with all my customers.
>
> > I have done this one time before by having my app_controller do a
> > beforeFilter() and retrieve the database configurations from my local
> > database depending on a login + pass. (although, this caused problems
> > every time..)
>
> > Thanks in advance :)
>

> > Check out the new CakePHP Questions sitehttp://cakeqs.organd help others

> > with their CakePHP related questions.
>
> > You received this message because you are subscribed to the Google Groups
> > "CakePHP" group.
> > To post to this group, send email to cake-php@googlegroups.com
> > To unsubscribe from this group, send email to
> > cake-php+unsubscribe@googlegroups.com For more options, visit this group

> > athttp://groups.google.com/group/cake-php?hl=en
>
> >  Check out the new CakePHP Questions sitehttp://cakeqs.organd help

> > others with their CakePHP related questions.
>
> > You received this message because you are subscribed to the Google Groups
> > "CakePHP" group.
> > To post to this group, send email to cake-php@googlegroups.com
> > To unsubscribe from this group, send email to

> > cake-php+unsubscribe@googlegroups.com<cake-php%2Bunsubscribe@googlegroups.c om>For more options, visit this group at

> >http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.

You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with their CakePHP related questions.
 
You received this message because you are subscribed to the Google Groups "CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
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?hl=en