ports/121635: ezmlm-idx MySQL support broken

[Paul Reece]

>Number:         121635
>Category:       ports
>Synopsis:       ezmlm-idx MySQL support broken
>Confidential:   no
>Severity:       serious
>Priority:       medium
>Responsible:    freebsd-ports-bugs
>State:          open
>Quarter:        
>Keywords:       
>Date-Required:
>Class:          sw-bug
>Submitter-Id:   current-users
>Arrival-Date:   Wed Mar 12 06:40:00 UTC 2008
>Closed-Date:
>Last-Modified:
>Originator:     Paul Reece
>Release:        7.0-STABLE
>Organization:
>Environment:
FreeBSD nero-new.fastlane.net.au 7.0-STABLE FreeBSD 7.0-STABLE #0: Wed Mar 12 00:43:35 WST 2008     root at nero-new.fastlane.net.au:/usr/obj/usr/src/sys/NERO  amd64
>Description:
Build of ezmlm-idx with MySQL extensions fails to compile.

logmsg.c: In function 'logmsg':
logmsg.c:52: warning: return discards qualifiers from pointer target type
./compile subscribe.c `head -1 conf-sqlcc`
In file included from subscribe.c:17:
log.h:4: warning: conflicting types for built-in function 'log'
./compile opensql.c `head -1 conf-sqlcc`
opensql.c: In function 'opensql':
opensql.c:95: error: lvalue required as left operand of assignment
opensql.c:99: warning: return discards qualifiers from pointer target type
*** Error code 1

Stop in /usr/ports/mail/ezmlm-idx/work/ezmlm-0.53.

>How-To-Repeat:
cd /usr/ports/mail/ezmlm-idx
make -DWITH_MYSQL

>Fix:
Fix that was applied to Gentoo last year appears to solve problem.  See https://bugs.gentoo.org/show_bug.cgi?id=152503 for further detail.

Specifically changing line 95 of opensql.c from:

if (!((MYSQL *)psql = mysql_init((MYSQL *) 0)))

to

if (!(psql = (void *)mysql_init((MYSQL *) 0)))



>Release-Note:
>Audit-Trail:
>Unformatted: