Update not happening !
I have a script that is running on computer A which is trying to update
the database on computer B.
The script tries to connect to computer B and fails with the following
error.
[EMAIL PROTECTED] mysql]$ ./data_loader.pl
DBI connect('webmaster,blackhole','webmaster',...) failed: Access denied
for user: '[EMAIL PROTECTED]' (Using password: YES) at
./data_loader.pl line 8
In the script where the server B "blackhole" the ip address is in the
hosts file and I have even tried to change the script and put in the IP
address in place of the string "blackhole" with no luck. I do not
understand why it keeps trying to access [EMAIL PROTECTED]
I guess my question is how do I make the script access server A from B?
Here is the script
<snip>
#! /usr/bin/perl
use DBI;
use DBD::mysql;
$dsn = "DBI:mysql:webmaster,blackhole";
$dbh = DBI->connect($dsn,"username","password",{RaiseError=>1});
$sth = $dbh->prepare ( q{
LOAD data INFILE 'ITEMDATA.TXT'
REPLACE
INTO TABLE item
FIELDS TERMINATED BY '|'
LINES TERMINATED BY '\n'
});
$sth->execute();
$sth->finish();
$dbh->disconnect();
<end snip>
Any help would be greatly appreciated !!!
Larry Sandwick
Sarreid, Ltd.
Network/System Administrator
phone: (252) 291-1414 x223
fax : (252) 237-1592
