[CDBI] CDBI::Sweet->page() not quite working with mysql?

Rhesa Rozendaal perl at rhesa.com
Fri Sep 23 11:24:54 BST 2005

Matt S Trout wrote:
> On Fri, Sep 23, 2005 at 03:49:10AM +0200, Rhesa Rozendaal wrote:
>>I had hoped i would, but I just did upgrade it to 3.0002 before mailing
>>the list. As far as I know, I'm using all the latest releases:
>>- DBD::mysql v3.0002
>>- Class::DBI v0.96
>>- Class::DBI::Sweet v0.05
> Have you considered it might be your libmysqlclient version that's
> knackering you? ISTR Red Hat shipped a 3.23 series MySQL to a stupid date,
> and if the 4.0+ server's a /usr/local job then CPAN probably built against
> the /usr/lib copy.

No, I hadn't considered that, even though I _know_ FC3 comes with 3.23. 
But this box didn't have mysql installed, and I put the 4.1.12 binary 
rpms from mysql.com on it.

Thanks for reminding me to cover this angle.

Let's rule out linkage against an old version:
- /usr/local/(lib|include|src) are empty
- mysql version is 4.1.12 (from /usr/include/mysql/mysql_version.h)
- /usr/lib/libmysqlclient.so links to libmysqlclient.so.14.0.0

- perl Makefile.PL flags:
I will use the following settings for compiling and testing:

   cflags        (mysql_config) = -I/usr/include/mysql -mcpu=i486
   embedded      (mysql_config) =
   libs          (mysql_config) = -L/usr/lib/mysql -lmysqlclient -lz
				 -lcrypt -lnsl -lm -lc -lnss_files
				 -lnss_dns -lresolv -lc -lnss_files
				 -lnss_dns -lresolv
   mysql_config  (guessed     ) = mysql_config
   nocatchstderr (default     ) = 0
   nofoundrows   (default     ) = 0
   ssl           (guessed     ) = 0
   testdb        (default     ) = test
   testhost      (default     ) =
   testpassword  (default     ) =
   testsocket    (default     ) =
   testuser      (default     ) =

> The other thing to look at is if you've got PHP loaded in the same apache
> - it has a talent for compiling itself against its own ancient libmysqlclient
> which has caused me all sorts of DBD::mysql woes in mod_perl installs.

I doubt PHP is even installed (not if I can help it in any case ;)
/etc/httpd/modules does not contain a mod_php.so, and there are no 
references in the conf file.

So, out of my depth and out of ideas.

Can I at least make disable_sql_paging default? The synopsis seems to 
suggest that the following works, but it's not otherwise documented.

__PACKAGE__->default_search_attributes({ disable_sql_paging => 1 } );

Thanks for following up, and an even bigger thanks for releasing Sweet. 
I'm quite anxious to start working with it :)


More information about the ClassDBI mailing list