[Asterisk-Users] Problem with mysql and with asterisk

[DIPAK PAUL]

Hi Every one and Lerale Erwan

I have briefly describe my problem and I have provide the steps as follows:

I have intalled redhat properly and from the konsole I checked with mysql.

"rpm -qa | grep mysql" and the konsole provide me the message:

mysql-3.23.54a-11
mysql-server-3.23.54a-11

Then I have download the asterisk and addons:

By the using of :

cd /usr/src
export CVSROOT=:pserver:anoncvs at cvs.digium.com:/usr/cvsroot
cvs login           - the password is anoncvs.
cvs checkout asterisk

Then

cd/usr/src
export CVSROOT=:pserver:anoncvs at cvs.digium.com:/usr/cvsroot
cvs login           - the password is anoncvs.
cvs checkout asterisk-addons

Compile /usr/src/asterisk-addons as follows:

cd asterisk-addons
make clean
make install

But the system send me an error messge like

./mkdep -fPIC -I../asterisk -D_GNU_SOURCE     `ls *.c`
cdr_addon_mysql.c:33:19: mysql.h: No such file or directory
cdr_addon_mysql.c:34:20: errmsg.h: No such file or directory
for x in  ; do install -m 755 $x /usr/lib/asterisk/modules ; done

The I have used
"to use mysql-vm-routines, set USE_MYSQL_VM_INTERFACE to 1
in asterisk/apps/Makefile , then put this file into
asterisk/apps/ and (re)build asterisk."

Then use make from the /usr/src/asterisk/

Then system have give me this type of error message:

make[1]: Entering directory `/usr/src/asterisk/apps'
gcc -pipe  -Wall -Wstrict-prototypes -Wmissing-prototypes 
-Wmissing-declarations -g  -Iinclude -I../include -D_REENTRANT -D_GNU_SOURCE 
  -O6 -march=i686     -DASTERISK_VERSION=\"CVS-HEAD-08/23/04-11:39:24\" 
-DINSTALL_PREFIX=\"\" -DASTETCDIR=\"/etc/asterisk\" 
-DASTLIBDIR=\"/usr/lib/asterisk\" -DASTVARLIBDIR=\"/var/lib/asterisk\" 
-DASTVARRUNDIR=\"/var/run\" -DASTSPOOLDIR=\"/var/spool/asterisk\" 
-DASTLOGDIR=\"/var/log/asterisk\" 
-DASTCONFPATH=\"/etc/asterisk/asterisk.conf\" 
-DASTMODDIR=\"/usr/lib/asterisk/modules\" 
-DASTAGIDIR=\"/var/lib/asterisk/agi-bin\"     -DBUSYDETECT_MARTIN      -fPIC 
-DUSEMYSQLVM   -c -o app_voicemail.o app_voicemail.c
app_voicemail.c:45:25: mysql/mysql.h: No such file or directory
In file included from app_voicemail.c:372:
mysql-vm-routines.h:7: parse error before '*' token
mysql-vm-routines.h:7: warning: type defaults to `int' in declaration of 
`dbhandler'
mysql-vm-routines.h:7: warning: data definition has no type or storage class
mysql-vm-routines.h: In function `mysql_login':
mysql-vm-routines.h:18: warning: implicit declaration of function 
`mysql_init'
mysql-vm-routines.h:18: warning: assignment makes pointer from integer 
without a cast
mysql-vm-routines.h:19: warning: implicit declaration of function 
`mysql_real_connect'
mysql-vm-routines.h: In function `mysql_logout':
mysql-vm-routines.h:29: warning: implicit declaration of function 
`mysql_close'
mysql-vm-routines.h: In function `find_user':
mysql-vm-routines.h:35: `MYSQL_RES' undeclared (first use in this function)
mysql-vm-routines.h:35: (Each undeclared identifier is reported only once
mysql-vm-routines.h:35: for each function it appears in.)
mysql-vm-routines.h:35: `result' undeclared (first use in this function)
mysql-vm-routines.h:36: `MYSQL_ROW' undeclared (first use in this function)
mysql-vm-routines.h:36: parse error before "rowval"
mysql-vm-routines.h:37: `MYSQL_FIELD' undeclared (first use in this 
function)
mysql-vm-routines.h:37: `fields' undeclared (first use in this function)
mysql-vm-routines.h:68: warning: implicit declaration of function 
`mysql_query'
mysql-vm-routines.h:69: warning: implicit declaration of function 
`mysql_store_result'
mysql-vm-routines.h:70: `rowval' undeclared (first use in this function)
mysql-vm-routines.h:70: warning: implicit declaration of function 
`mysql_fetch_row'
mysql-vm-routines.h:71: warning: implicit declaration of function 
`mysql_num_fields'
mysql-vm-routines.h:72: warning: implicit declaration of function 
`mysql_fetch_fields'
mysql-vm-routines.h:89: warning: implicit declaration of function 
`mysql_free_result'
make[1]: *** [app_voicemail.o] Error 1
make[1]: Leaving directory `/usr/src/asterisk/apps'
make: *** [subdirs] Error 1


Please help me. I had totaly upset to install the asterisk with cdr. Please 
help me because i am now helpless.

With best regards.


Dipak Kumar Paul
Tryarc LLC

_________________________________________________________________
Claim your Citibank Ready Cash today.  http://go.msnserver.com/IN/54177.asp 
It’s fast, easy and affordable.