9 messages in com.mysql.lists.perlRe: Re: Setting up mysql server on a ...
FromSent OnAttachments
Amol Sapkal04 Jan 2004 04:43 
Rudy Lippan04 Jan 2004 08:01 
Amol Sapkal04 Jan 2004 08:27 
Amol Sapkal04 Jan 2004 08:32 
Jochen Wiedmann04 Jan 2004 09:45 
Jochen Wiedmann04 Jan 2004 09:46 
Amol Sapkal04 Jan 2004 11:04 
Amol Sapkal04 Jan 2004 11:40 
Amol Sapkal04 Jan 2004 12:00 
Subject:Re: Re: Setting up mysql server on a seperate host
From:Amol Sapkal (amol@coolgoose.com)
Date:01/04/2004 08:27:25 AM
List:com.mysql.lists.perl

If your script does not explicitly specify the connect DSN you can use the DBI_DSN envionment variable, otheriwse you are going to have to modify your script so that the host to connect to is configurable (environment varible/config file / &c..

Pls give me an example code. the configs could be:

MySQL server: 10.1.1.2 (hostname: mars) database name: metric port:3306 (default) Script are on:10.1.1.1 (hostname:earth)

Below will be part of my scripts (no harm in changing these): $dbh = DBI->connect($dsn, $user, $password)

Could you help me with defining my $dsn with above configs? I have not set any username/password for my database (have installed it using simple rpms)

Rudy