FW: Msql Question - Tim Dellinger - com.mysql.lists.perl

3 messages in com.mysql.lists.perlFW: Msql Question

From	Sent On	Attachments
Jochen Wiedmann	22 Sep 2003 22:42
Tim Dellinger	23 Sep 2003 15:23
Jochen Wiedmann	24 Sep 2003 03:39

Subject:	FW: Msql Question
From:	Tim Dellinger (Del...@Willard-Oh.com)
Date:	09/23/2003 03:23:40 PM
List:	com.mysql.lists.perl

Thanks for the quick response. I tried it and still got the same thing. Just sits for awhile then completes with blank screen. I am using a router though. Maybe that is the problem. If you have any more ideas they would be appreciated. Thanks for your help Tim

-----Original Message----- From: Jochen Wiedmann [mailto:jo...@ispsoft.de] Sent: Tuesday, September 23, 2003 12:43 AM To: Del...@Willard-Oh.com Cc: pe...@lists.mysql.com Subject: Re: Msql Question

Tim Dellinger wrote:

sub OpenMySQL { use DBI; $dbh =

DBI->connect("DBI:mysql:tna-zhlc_tna:216.206.61.76:2082","tna-zhlc_test","te

st"); return; }

Try adding the RaiseError flag, as in

DBI->connect("DBI:mysql:tna-zhlc_tna:216.206.61.76:2082", "tna-zhlc_test","test" {RaiseError => 1});

That should make sure that you are seeing an error message.

When I run the scripts I receive no errors but no information is returned to me. It should print this information to my screen. When I run it it just sits for awhile like it is accessing the database, but shows nothing. I put the :2082 behind my ip address because when I access the database at tna, through my database management control panel, it shows this in the url. My site administrator tells me that: It does not matter where you are to access your web site (and database) as long as you are connected to the internet.

This is not entirely true, depending on your network. For example, if you are sitting behind some kind of personal firewall or router, then the situation may be more complex.

P.S: Please use the mailing list pe...@lists.mysql.com for queries.