[Catalyst] Newbie Question about Database

Giancarlo Corcuera giancarlo at capybara-software.com
Mon Jan 19 20:10:46 GMT 2009


Hi:

I'm building an App but I want to have my database in another IP. Is 
there a way to enter the parameters to do this instead of the normal 
connection that appears in the manual?

This is my model (a very standar one):

package App::Model::ModelDB;

use strict;
use base 'Catalyst::Model::DBIC::Schema';

__PACKAGE__->config(
    schema_class => 'App::Schema::ModelDB',
    connect_info => [
        'dbi:mysql:model',
        'model',
        'model',
        {
            mysql_enable_utf8   => 0,
            on_connect_do       => [
                "SET NAMES 'utf8'",
                "SET CHARACTER SET 'utf8'",
            ],
        }
    ],
);

How can I change it to connect to a DB in another IP?

TIA,

Giancarlo




More information about the Catalyst mailing list