DBD::mysql over Cygwin

Oleg Eterevsky <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
I've tried to install DBD::mysql over Cygwin. First of all I compiled 
MySQL client library (version 4.0.20). Then I tried to install DBD::mysql 
2.9004. It compiled ok, but failed three tests: 46-48. As a test database 
I used NT mysql server, to which I accessed through TCP/IP (not using 
sockets).

I installed the module ignoring the failed test and tried to run Bugzilla 
cgi-scripts with it. It failed on the following lines of Bugzilla::DB:

my $dsn = "DBI:mysqlPP:host=$db_host;database=$db_name;port=$db_port";

my $dbh = DBI->connect($dsn,
                        '',
                        '',
                        { RaiseError => 1,
                          PrintError => 0,
                          Username => $db_user,
                          Password => $db_pass,
                          ShowErrorStatement => 1,
                          HandleError => \&_handle_error,
                          FetchHashKeyName => 'NAME_lc',
                          TaintIn => 1,
                        });

It returned the following error message:

DBI connect('host=195.131.128.9;database=bugs;port=3306','bugs',...) 
failed: Can't create TCP/IP socket (1) at 
/usr/lib/perl5/site_perl/5.8.5/cygwin-thread-multi-64int/DBI.pm line 606
     DBI::__ANON__('undef', 'undef') called at 
/usr/lib/perl5/site_perl/5.8.5/cygwin-thread-multi-64int/DBI.pm line 663
     DBI::connect('DBI', 
'DBI:mysql:host=195.131.128.9;database=bugs;port=3306', '', '', 
'HASH(0x1055f154)') called at Bugzilla/DB.pm line 146
 
Bugzilla::DB::_connect('DBI:mysql:host=195.131.128.9;database=bugs;port=3306') 
called at Bugzilla/DB.pm line 138
     Bugzilla::DB::connect_main() called at Bugzilla.pm line 143
     Bugzilla::dbh('Bugzilla') called at Bugzilla/DB.pm line 60
     Bugzilla::DB::SendSQL('SELECT 1 FROM group_control_map WHERE entry != 
0 LIMIT 1') called at globals.pl line 448
     main::AnyEntryGroups() called at /var/www5/bugzilla/enter_bug.cgi line 60


I'm not really sure that this error is related to failed test during the 
installation, but nevertheless I will be grateful if somebody help me with 
either of the problems.

--
Oleg Eterevsky.

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.