On Sep 26, 2006, at 12:45 PM, Joseph Alotta wrote:
I have a application in Perl that prints reports from a MySQL
database. I also have DSL that is accessed via Airport in my house.
Recently I bought an iMac for my wife and I want her to help me
print reports from this new computer. How do I get her computer
to get data from the MySQL database that lives on my computer via
Airport?
Do you have any suggestions on things I can try?
Presumably, your Perl app does something like ...
$host = 'localhost';
$dsn = "DBI:mysql:database=$database;host=$hostname";
$dbh = DBI->connect($dsn, $user, $password);
... to connect to the MySQL database. When run from your wife's
computer, you'll have to change the 'localhost' to the IP address of
the computer where the MySQL database resides. You'll need to make
sure your MySQL permissions are set up to allow this. You may want to
try connecting to the database using the 'mysql' command line tool
first. Once you can do that successfully, then make the appropriate
mods to the connection parameters in your app.
Ray
