Re: [Slashcode-general] Newbie question: Virtual Hosts

[shane <sh...@lo...>]

At 06:16 PM 9/26/2001 -0400, Scott Johnson wrote:
>[...] I would like to create another slash site as a virtual host [...]
>As I read the docs, here's what seems to need to happen:
>
>* Create another MySQL database for the new site (not at all sure if this 
>is required)

yep

>* Create a MySQL username & pwd combo with rights to this database (I know 
>how to do this)
>* Add a new virtual user to DBIx::Password (not one clue at all how to do 
>this, really need help here)

the easiest way, IMHO, is to edit the Password.pm and dup your current virtual
setup, and then change the username,database, and password settings for the 
new site. So if you original had this:

my $virtual1 = {
               'slash' => {
                            'driver' => 'mysql',
                            'username' => 'slash',
                            'attributes' => {},
                            'port' => '',
                            'database' => 'slash',
                            'password' => 'password',
                            'host' => 'sql1',
                            'connect' => 'DBI:mysql:database=slash;host=sql1'
                          },
};

you'd change it to

my $virtual1 = {
               'slash' => {
                            'driver' => 'mysql',
                            'username' => 'slash',
                            'attributes' => {},
                            'port' => '',
                            'database' => 'slash',
                            'password' => 'password',
                            'host' => 'sql1',
                            'connect' => 'DBI:mysql:database=slash'
                          },
               'slashdev' => {
                            'driver' => 'mysql',
                            'username' => 'slashdev',
                            'attributes' => {},
                            'port' => '',
                            'database' => 'slashdev',
                            'password' => 'password',
                            'host' => 'sql1',
                            'connect' => 'DBI:mysql:database=slashdev'
                          },

};

for more info: perldoc DBIx::Password or http://www.tangent.org/DBIx-Password/