Re: Apache/mod_perl/DBI/MySQL 4.0 alpha - Bill Adams - com.mysql.lists.bugs

8 messages in com.mysql.lists.bugsRe: Apache/mod_perl/DBI/MySQL 4.0 alpha

From	Sent On	Attachments
Bill Adams	22 Oct 2001 10:31
Sinisa Milivojevic	23 Oct 2001 04:38
Michael Widenius	25 Oct 2001 06:18
Bill Adams	29 Oct 2001 12:40
Jochen Wiedmann	29 Oct 2001 13:04
Michael Widenius	30 Oct 2001 03:37
Bill Adams	30 Oct 2001 09:24
Bill Adams	01 Nov 2001 10:12

Subject:	Re: Apache/mod_perl/DBI/MySQL 4.0 alpha
From:	Bill Adams (bad...@tqs.com)
Date:	11/01/2001 10:12:50 AM
List:	com.mysql.lists.bugs

I tried to repeat the error on a cleanly installed MDK 8.1 system with no luck. Apparently the system that I am experiencing this problem on has some other left over library, include file, or something.

Sorry to waste everyone's time. If I find anything new that seems important, I will let everyone know.

--Bill

Michael Widenius wrote:

Hi!

"Bill" == Bill Adams <bad...@tqs.com>

writes:

Bill> Not sure this is the right place to report this... Bill> This bug only happens when using Apache Bill> + mod_perl + DBI + MySQL 4.0 alpha. When trying Bill> to fetch a row (it does not matter which

Bill> fetchrow_* function is called) the call returns an Bill> error: "dbih_setup_fbav: invalid number of fields: Bill> 0, NUM_OF_FIELDS attribute probably not set right Bill> at ...". This problem does not happen when Bill> Msql-mysql-modules is linked against the 3.23.41 Bill> libmysqlclient.so.

Before checking this further, could you please verify that you have recompiled DBD-mysql with the new MySQL 4.0 header files ?

We added in 4.0 some new fields to the MYSQL struct that could cause problems like this if one uses the new libmysql libraries without recompiling.

I tried it with the 4.0 includes:

cc -c -I/usr/lib/perl5/site_perl/5.005/i386-linux/auto/DBI

-I/usr/local/mysql-4.0/include/mysql -I../dbd -I/usr/lib/perl5/site_perl/5.005/i386-linux/a to/DBI -I/usr/lib/perl5/5.00503/i386-linux -Dbool=char -DHAS_BOOL -I/usr/local/include -O2 -m486 -fno-strength-reduce -DVERSION=\"2.0418\" -DXS_VERSION=\"2.0418\" -fpic -I/usr/lib/perl5/5.00503/i386-linux/CORE -DDBD_MYSQL dbdimp.c

I verified that ldd was using the right libmysqlclient:

[root@host /tmp/Msql-Mysql-modules-1.2218]# ldd /usr/lib/perl5/site_perl/5.005/i386-linux/auto/ BD/mysql/mysql.so libmysqlclient.so.11 => /usr/local/mysql-4.0/lib/mysql/ ibmysqlclient.so.11 (0x2aabd000) libm.so.6 => /lib/libm.so.6 (0x2aadd000)

libz.so.1 => /usr/lib/libz.so.1 (0x2aafa000) libc.so.6 => /lib/libc.so.6 (0x2ab0a000)

libcrypt.so.1 => /lib/libcrypt.so.1 (0x2abff000) libnsl.so.1 => /lib/libnsl.so.1 (0x2ac2c000) /lib/ld-linux.so.2 => /lib/ld-linux.so.2 (0x55555000)

I still get the error:

[Tue Oct 30 09:18:36 2001] [notice] caught SIGTERM, shutting down [Tue Oct 30 09:18:39 2001] [notice] Apache/1.3.22 (Unix) mod_perl/1.26 PHP/4.0.3pl1 configured -- resuming normal operations [Tue Oct 30 09:18:39 2001] [notice] Accept mutex: sysvsem (Default: sysvsem) [Tue Oct 30 09:18:48 2001] [error] authen_cred() -- Fetch Error: dbih_setup_fbav: invalid number of fields: 0, NUM_OF_FIELDS attribute probably not set right at /home/httpd/pm/Apache/AuthMFG.pm line 65.

I recompiled with 3.23.41 and reinstalled, no problems.

Again, this is only an issue for mod_perl scripts. Everything else is just fine.

--Bill

------

--------------------------------------------------------------

Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail bugs...@lists.mysql.com To unsubscribe, e-mail <bugs...@lists.mysql.com>