develooper Front page | perl.dbi.users | Postings from February 2001

RE: Using DBI when MySQL is on another server

Thread Previous | Thread Next
From:
Steve Howard
Date:
February 26, 2001 19:22
Subject:
RE: Using DBI when MySQL is on another server
Message ID:
NEBBLDBLJCNLBCNOBCOBGEJECAAA.showard@pccompsoft.net
Glad to help :)

-----Original Message-----
From: David Coley [mailto:davidcoley@home.com]
Sent: Monday, February 26, 2001 9:19 PM
To: dbi-users@perl.org
Subject: RE: Using DBI when MySQL is on another server


Hey guys I would just like to say thanks... Rinke and Steve both remind my
thick skull that athough the damon is on a differnt machine I still need to
install the mysql client on the app machine (doh).  Just goes to show you...
there's always something you forget.

David Coley

-----Original Message-----
From: Reinke Bonte [mailto:reinkebonte@worldmetal.com]
Sent: Monday, February 26, 2001 10:05 PM
To: David Coley
Subject: Re: Using DBI when MySQL is on another server


I reply private, because I'm not an expert with MySQL. For Oracle at least,
you need to have the Oracle client already installed on the same machine
where you install DBD::Oracle. This is because the installation needs some
header files from the Oracle client. It's probably the same with MySQL:
although the MySQL server is on remote machine, you need a client on the
local machine.


I hope that helps, at least to rephrase your question to make it
understandable for the experts.


-ren


----- Original Message -----
From: "David Coley" <davidcoley@home.com>
To: <dbi-users@perl.org>
Sent: Tuesday, February 27, 2001 10:58 AM
Subject: RE: Using DBI when MySQL is on another server


> >From the two responces I've gotten back, I know I didn't phrase this
right.
>
> My problem is when I get to the point:
>
> Where is your MySQL installed? Please tell me the directory that
> contains the subdir 'include'. [/usr/local]
> Cannot find one of include/mysql/mysql.h, include/mysql.h in /usr/local at
> lib/D
>
> I need to tell it that MySQL is located on a differnt server and not the
> local machine... is there a way around this?  And still give me access to
> DBI on this machine?
>
> David Coley
>
>
> -----Original Message-----
> From: Sterin, Ilya [mailto:Isterin@ciber.com]
> Sent: Monday, February 26, 2001 9:44 PM
> To: David Coley; dbi-users@perl.org
> Subject: RE: Using DBI when MySQL is on another server
>
>
> Read DBD::mysql for proper connect statement.  One of them should have a
> specified location of mysql which can be a network address I believe.
>
> Ilya Sterin
>
> -----Original Message-----
> From: David Coley [mailto:davidcoley@home.com]
> Sent: Monday, February 26, 2001 9:31 PM
> To: dbi-users@perl.org
> Subject: Using DBI when MySQL is on another server
>
>
> I've looked through the docs on this so I thought I'd go to the horse
mouth.
> We use MySQL however it is on a different server than the Application will
> be running.  I want to use DBI with MySQL support in order to help handle
my
> perl calls to MySQL, however when I get to the line asking for where MySQL
> is installed I do not know what to do.  Can DBI run on a different server
> than the on that MySQL is install on?  I figure it must be able to since
you
> can access MySQL from differnt Servers.
>
> Any help appreciated.  Sorry if this question has been answered, I have
not
> found any archives of the list.
>
> David Coley
>
>


Thread Previous | Thread Next


nntp.perl.org: Perl Programming lists via nntp and http.
Comments to Ask Bjørn Hansen at ask@perl.org | Group listing | About