Tim or anyone else who knows, I was going to attempt to answer
this question, but it's been a long while since I've had to
setup a similar "dbserver on one machine, and webserver(db
client) on another machine" scenerio, so I went looking for
docs to describe it. I can't find any that describe what
needs to be installed on what machine in order to accomplish
this.
Here's what I think:
dbserver
- install and setup MySQL *server* and get working
properly
- install DBI
webserver (db client)
- install MySQL *client*
- install DBI
- install DBD::mysql
but I honestly can't remember. I've looked quickly through
the DBI and DBD::mysql perldocs, and through the DBI FAQ at
http://dbi.perl.org/doc/faq.html, but I can't find this
described. Seems to me that this can be described in a
generic way(db independent) in 'perldoc DBI', or more
specifically in each DBD::??.
I'd check the book "Programming the Perl DBI" which I think(?)
describes this, but I don't have it handy. Besides, this
info is basic enough that it should be available in the
docs somewhere. Maybe it is, but I couldn't find it - if it
is in the docs, please point it out to me and I'll go hide
in a corner ;-)
Thanks.
--
Hardy Merrill
Red Hat, Inc.
Herbert Braun [EMAIL PROTECTED] wrote:
> 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
