Try:
my $dbh = DBI->connect('dbi:mysql:database=helpdesk:host=123.123.123.123',
'user', 'pw');
Thanks,
John W. Herbold Jr.
Security Specialist
501-399-3939
-----Original Message-----
From: Herbert Braun [mailto:[EMAIL PROTECTED]
Sent: Monday, August 25, 2003 4:53 AM
To: [EMAIL PROTECTED]
Subject: Database and Web Server on Different Machines
Hello DBI users,
I try to set up a MySQL database with a web interface via DBI. Database and
Apache web server run on different machines (both Debian Linux), and this is
where my problems start.
- is it possible to communicate to the remote database server with a syntax
like
my $dbh = DBI->connect('dbi:mysql:[EMAIL PROTECTED]', 'user', 'pw') ?
- in "Programming the Perl DBI", chapter 8, Alligator and Tim explain how to
set up a database proxy. Do I have to do that? That chapter read like a
whole bunch of trouble ...
- is there a way to properly install DBD::mysql without installing MySQL on
the web server? The documentation said that I had to install only the MySQL
client but almost all setup tests failed because of 'could not connect to
MySQL server' (of course it couldn't ...). I tried to direct the test
routines to the remote database but failed.
Thanks in advance to anyone who can help!
Greetings from Berlin,
Herbert Braun
