[Asterisk-Users] cdr_addon_mysql compile error

[Asterisk VOIP]

On Thu, 29 Jan 2004 12:45:35 -0600, Tilghman Lesher wrote
> On Thursday 29 January 2004 11:31, Asterisk VOIP wrote:
> > On Thu, 29 Jan 2004 10:32:56 -0600, Tilghman Lesher wrote
> >
> > > On Wednesday 28 January 2004 16:47, Asterisk VOIP wrote:
> > > > Having some trouble building cdr_addon_mysql.  I've installed
> > > > mysql and mysql-dev and all related rpms on a RH9 box.  The box
> > > > is up and running *.
> > > >
> > > > I've checked out the asterisk-addons but at "make install", I
> > > > receive the following error:
> > > >
> > > > ./mkdep -fPIC -I../asterisk  -I/usr/include/mysql   `ls *.c`
> > > > cc -fPIC -I../asterisk  -I/usr/include/mysql     -c -o
> > > > cdr_addon_mysql.o cdr_addon_mysql.c
> > > > cdr_addon_mysql.c: In function `mysql_log':
> > > > cdr_addon_mysql.c:113: structure has no member named `userfield'
> > > > cdr_addon_mysql.c:114: structure has no member named `userfield'
> > > > cdr_addon_mysql.c:114: structure has no member named `userfield'
> > > > make: *** [cdr_addon_mysql.o] Error 1
> > > >
> > > > any ideas?
> > >
> > > Please recompile and reinstall the latest version of Asterisk
> > > before you attempt to compile cdr_addon_mysql.  Your header files
> > > are out of date.
> >
> > a reinstall of * only or zaptel, libpri, as well?
> >
> > btw, thanks for the great module and advice.
> 
> Generally speaking, you should always compile and install in the
> following order:
> 
> 1) zaptel
> 2) libpri
> 3) asterisk
> 4) asterisk-addons
> 
> You're likely to have fewer problems if you follow this order anytime
> you update Asterisk or any of its components.
> 
> -Tilghman
> 
> _______________________________________________
> Asterisk-Users mailing list
> Asterisk-Users at 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

thank you, I checked out and installed all.

added following to /etc/asterisk/modules.conf
load => cdr_addon_mysql.so

created /etc/asterisk/cdr_mysql.conf
[global]
hostname=IPADDR
dbname=DBNAME
password=DBPASS
user=DBUNAME
port=3306
sock=/tmp/mysql.sock
userfield=1

installed mysql and mysql-devel and all related/required rpms

created DBNAME on sql server and tables re doco

and, upon restart I see 
[cdr_addon_mysql.so] => (MySQL CDR Backend)
  == Parsing '/etc/asterisk/cdr_mysql.conf': Found

BUT, nothing appears in the DB for calls.  

I do get cdr info for the calls in /var/log/asterisk/cdr-csv/Master.csv, as
was always the case.

any ideas?

thanks again,
wr