mysqlPP on Perl fails to connect

[bluedalmatian]

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.

[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?

[bluedalmatian]

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

[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

[waddlesplash]

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