Bug #30398 for DBIx-SearchBuilder: DBIx::SearchBuilder::Handle::mysql does not seem to deal with config file specification

Wed Oct 31 22:59:22 2007 chardin [...] gmail.com - Ticket created

Subject:	DBIx::SearchBuilder::Handle::mysql does not seem to deal with config file specification
Date:	Wed, 31 Oct 2007 19:59:07 -0700
To:	bug-DBIx-SearchBuilder [...] rt.cpan.org
From:	Chuck Hardin <chardin [...] naming-schemes.org>

I am working with the DBIx::SearchBuilder version that was distributed with Red Hat Fedora Core 4. I believe it's version 1.43. I'm also using perl v5.8.6. I'm not sure why the following code does not work: my $shared_handle = DBIx::SearchBuilder::Handle->new(); my $dsn = "dbi:mysql:<db_name>;host=<hostname>;mysql_read_default_file=<config_file>"; my $dbh = DBI->connect($dsn, undef, undef); $shared_handle->dbh($dbh); However, it demonstrably does not. I've tried using it from within an HTML::Mason control component and have gotten nothing but errors. CCH

Tue Nov 06 12:43:22 2007 jesse [...] fsck.com - Correspondence added

CC:	undisclosed-recipients: ;
Subject:	Re: [rt.cpan.org #30398] DBIx::SearchBuilder::Handle::mysql does not seem to deal with config file specification
Date:	Tue, 6 Nov 2007 12:43:13 -0500
To:	Chuck Hardin via RT <bug-DBIx-SearchBuilder [...] rt.cpan.org>
From:	jesse <jesse [...] fsck.com>

Show quoted text

> Subject: DBIx::SearchBuilder::Handle::mysql does not seem to deal with config file specification > > > I am working with the DBIx::SearchBuilder version that was distributed > with Red Hat Fedora Core 4. I believe it's version 1.43. I'm also > using perl v5.8.6. > > I'm not sure why the following code does not work: > > my $shared_handle = DBIx::SearchBuilder::Handle->new(); > > my $dsn = "dbi:mysql:<db_name>;host=<hostname>;mysql_read_default_file=<config_file>"; > my $dbh = DBI->connect($dsn, undef, undef); > $shared_handle->dbh($dbh);

Does the raw dbh work? Knowing what errors you get is likely to be the first step toward knowing what's wrong Show quoted text

> > However, it demonstrably does not. I've tried using it from within an > HTML::Mason control component and have gotten nothing but errors. > > CCH >

--

Tue Nov 06 12:43:30 2007 The RT System itself - Status changed from 'new' to 'open'

Thu Jun 05 20:30:58 2008 RUZ [...] cpan.org - Severity Normal added

Thu May 19 21:43:51 2011 chardin [...] gmail.com - Correspondence added

Please expand this suggestion. Are you asking me to instantiate a handle through a DBI call and then pass it to DBIx::SearchBuilder::Handle::dbh? Something else? It still doesn't work, incidentally. Show quoted text

> Does the raw dbh work? Knowing what errors you get is likely to be the > first step toward knowing what's wrong