Opened 5 years ago

Closed 11 months ago

#10869 closed bug (invalid)

mysqlPP on Perl fails to connect

Reported by: bluedalmatian Owned by: nobody
Priority: normal Milestone: R1
Component: Network & Internet Version: R1/alpha4
Keywords: Perl MySQL Cc:
Blocked By: Blocking:
Has a Patch: no Platform: All

Description

Connecting to MySQL via Perl does not work. AFAIK the MySQL C lib is at present incomptaible with Haiku and will not build therefore it would seem at present MySQLPP is the only short term way to connec to MySQL.

The Perl MySQLPP module which implements the MySQL protocol purely in Perl will not connect. This appears to be am incompatibility between the Net::MySQL module (which MySQLPP depends on) as normal IP sockets (IO::Socket::INET) under Perl work OK

The error given when connecting is DBI connect('database=dbname;host=dbserver.domain.com','username',...) failed: Couldn't connect to mysql.positive-internet.com:3306/tcp: IO::Socket::INET: connect: Operation now in progress at /boot/common/lib/perl5/site_perl/5.10.1/DBD/mysqlPP.pm line 109

Line 109 calls into Net::MySQL's new() function.

Looking in the code for the new() function Im wondering if its the use of Unix domain sockets which is causing the problem?

This occuring with Alpha 4 with Perl modules installed using the cpan command. I have been unable to test it on a more recent nightly build as I cannot get one to boot on my hardware.

Attachments (1)

testmysqlpp.pl (1.6 KB) - added by bluedalmatian 5 years ago.
Simple Perl script using DBD::mysqlPP to connect to a MySQL Server and print if it succeeds. See comments in source

Download all attachments as: .zip

Change History (4)

comment:1 Changed 5 years ago by axeld

Could you please add links to the source in question? It would lower the barrier to look into this problem a lot. Also, for those unfamiliar with Perl, what are the steps to reproduce this issue (installation, ...)?

Can you add an example file?

Changed 5 years ago by bluedalmatian

Attachment: testmysqlpp.pl added

Simple Perl script using DBD::mysqlPP to connect to a MySQL Server and print if it succeeds. See comments in source

comment:2 Changed 5 years ago by bluedalmatian

Ive attached a Perl script which attempts to connect to a MySQL server begin a transaction then rollsback. You will need to edit the server & database details as described in the comments

To setup perl run the following commands at the terminal cpan Net::MySQL cpan DBD::mysqlPP

comment:3 Changed 11 months ago by waddlesplash

Resolution: invalid
Status: newclosed

Perl port bugs should be reported to HaikuPorts, not here.

Note: See TracTickets for help on using tickets.