asterisk users - Jul 2004 - Which version of MySQL works with cdr_addon_mysql?

I'm having problems compiling cdr_addon_mysql with MySQL 3.23.58
I get the following errors:

cc -fPIC -I../asterisk -D_GNU_SOURCE  -I/usr/include/mysql     -c -o 
cdr_addon_mysql.o cdr_addon_mysql.c
cdr_addon_mysql.c:50: warning: parameter names (without types) in 
function declaration
cdr_addon_mysql.c:50: warning: data definition has no type or storage class
cdr_addon_mysql.c: In function `mysql_log':
cdr_addon_mysql.c:107: `mysql_lock' undeclared (first use in this function)
cdr_addon_mysql.c:107: (Each undeclared identifier is reported only once
cdr_addon_mysql.c:107: for each function it appears in.)
cdr_addon_mysql.c: In function `usecount':
cdr_addon_mysql.c:417: `mysql_lock' undeclared (first use in this function)
make: *** [cdr_addon_mysql.o] Error 1

I have loaded:
MySQL-3.23.58-1.i386.rpm
MySQL-client-3.23.58-1.i386.rpm
MySQL-devel-3.23.58-1.i386.rpm
MySQL-shared-3.23.58-1.i386.rpm

Does cdr_addon_mysql work with this version of MySQL or do I need to 
install version 4?

Thanks
Malcolm Bader

Hi-
I've used MySQL, both version 3 and 4 with no trouble.  I copied the
following from my notes:

   * MySQL version 4 - use the files in /usr/src.  Move to new directory
     /usr/src/mysql.  Install by using rpm -U for each, in this order:
      * shared-compat
      * client
      * devel
      * server - and follow on screen instructions 
        to create root pw

Can't remember whether shared-compat is needed on version 3, but definitely
in version 4.

Hope this helps,
Scott


Scott M. Stingel
President,
Emerging Voice Technology, Inc.
Palo Alto California & London England
www.evtmedia.com 

-----Original Message-----
From: asterisk-users-admin@lists.digium.com
[mailto:asterisk-users-admin@lists.digium.com] On Behalf Of Malcolm Bader
Sent: Saturday, July 31, 2004 8:00 AM
To: astrerisk users
Subject: [Asterisk-Users] Which version of MySQL works with cdr_addon_mysql?

I'm having problems compiling cdr_addon_mysql with MySQL 3.23.58 I get the
following errors:

cc -fPIC -I../asterisk -D_GNU_SOURCE  -I/usr/include/mysql     -c -o 
cdr_addon_mysql.o cdr_addon_mysql.c
cdr_addon_mysql.c:50: warning: parameter names (without types) in function
declaration
cdr_addon_mysql.c:50: warning: data definition has no type or storage class
cdr_addon_mysql.c: In function `mysql_log':
cdr_addon_mysql.c:107: `mysql_lock' undeclared (first use in this function)
cdr_addon_mysql.c:107: (Each undeclared identifier is reported only once
cdr_addon_mysql.c:107: for each function it appears in.)
cdr_addon_mysql.c: In function `usecount':
cdr_addon_mysql.c:417: `mysql_lock' undeclared (first use in this function)
make: *** [cdr_addon_mysql.o] Error 1

I have loaded:
MySQL-3.23.58-1.i386.rpm
MySQL-client-3.23.58-1.i386.rpm
MySQL-devel-3.23.58-1.i386.rpm
MySQL-shared-3.23.58-1.i386.rpm

Does cdr_addon_mysql work with this version of MySQL or do I need to install
version 4?

Thanks
Malcolm Bader

_______________________________________________
Asterisk-Users mailing list
Asterisk-Users@lists.digium.com
http://lists.digium.com/mailman/listinfo/asterisk-users
To UNSUBSCRIBE or update options visit:
   http://lists.digium.com/mailman/listinfo/asterisk-users

In article <410BB3D6.3070502@slauson.com>,
Malcolm Bader <mbader@slauson.com> wrote:
> I'm having problems compiling cdr_addon_mysql with MySQL 3.23.58
> I get the following errors:
> 
> cc -fPIC -I../asterisk -D_GNU_SOURCE  -I/usr/include/mysql     -c -o 
> cdr_addon_mysql.o cdr_addon_mysql.c
> cdr_addon_mysql.c:50: warning: parameter names (without types) in 
> function declaration
> cdr_addon_mysql.c:50: warning: data definition has no type or storage class
> cdr_addon_mysql.c: In function `mysql_log':
> cdr_addon_mysql.c:107: `mysql_lock' undeclared (first use in this
function)
> cdr_addon_mysql.c:107: (Each undeclared identifier is reported only once
> cdr_addon_mysql.c:107: for each function it appears in.)
> cdr_addon_mysql.c: In function `usecount':
> cdr_addon_mysql.c:417: `mysql_lock' undeclared (first use in this
function)
> make: *** [cdr_addon_mysql.o] Error 1
Those errors are nothing to do with the version of MySQL. They indicate
that you are compiling a recent version of cdr_addon_mysql with an older
version of Asterisk. Specifically, a version of Asterisk from before the
BSD portability fixes were added.

Try fetching the latest CVS HEAD version of Asterisk, compile and install
it, and then try compiling cdr_addon_mysql again.

Oh, and I'm using MySQL 3.23.58 with no problems at all.

Cheers
Tony
-- 
Tony Mountifield
Work: tony@softins.co.uk - http://www.softins.co.uk
Play: tony@mountifield.org - http://tony.mountifield.org