The way I would do this in Propel instead is in my ModelClasses for the
tables in database xyz is overwrite the doSelect, doSelectOne methods to
explicitly call the correct connection:

public static function (Criteria $criteria, $con = null)
{
  parent::doSelect($criteria, Propel::getConnection('xyz'));
}

Also, ensure you have generated model classes for the xyz database and then
cleared cache after you did that too

On Mon, Nov 23, 2009 at 2:52 PM, axel at <[email protected]> wrote:

> hello,
>
> I have defined two database connections in my databases.yml:
> all:
>  xyz:
>    class: sfDoctrineDatabase
>    param:
>      dsn: 'mysql:host=localhost;dbname=xyz'
> ...
>  abc:
>    class: sfDoctrineDatabase
>    param:
>      dsn: 'mysql:host=localhost;dbname=abc'
>
> installed sfGuardPlugin, the sf* databases are located in xyz database
>
> when I try to add a new user with:
> symfony guard:create-user --connection="xyz" admin password
>
> I get the following error:
>  SQLSTATE[42S02]: Base table or view not found: 1146 Table
> 'avz.sf_guard_user' doesn't exist
>
> it seems that the --connection option is ignored?
>
> --
>
> You received this message because you are subscribed to the Google Groups
> "symfony users" group.
> To post to this group, send email to [email protected].
> To unsubscribe from this group, send email to
> [email protected]<symfony-users%[email protected]>
> .
> For more options, visit this group at
> http://groups.google.com/group/symfony-users?hl=.
>
>
>


-- 
Gareth McCumskey
http://garethmccumskey.blogspot.com
twitter: @garethmcc

--

You received this message because you are subscribed to the Google Groups 
"symfony users" group.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to 
[email protected].
For more options, visit this group at 
http://groups.google.com/group/symfony-users?hl=.


Reply via email to