[HELP] Realtime problem again

Asterisk Asterisk Support
1

Ok i already post my problem here but now i problem is a bit larger than i thought. My realtime is not working at all… but its very strange :
Here my output when i do realtime mysql status :

Connected to asterisk@localhost, port 3306 with username root for 40 minutes, 29 seconds.

So it seems to work. But when i change a voicemail box from my config file to my database here what asterisk say :

 -- Executing VoiceMail("IAX2/64.26.157.230:4569-1", "u220@torrent") in new stack
Aug 15 18:15:55 WARNING[11156]: app_voicemail.c:2410 leave_voicemail: No entry in voicemail config file for '220'
    -- Executing Hangup("IAX2/64.26.157.230:4569-1", "") in new stack
  == Spawn extension (torrent-inside, 220, 10) exited non-zero on 'IAX2/64.26.157.230:4569-1'
    -- Hungup 'IAX2/64.26.157.230:4569-1'

So its like if asterisk just don’t go look in my database.

here is my extconfig.conf

sipusers => mysql,asterisk,sip_buddies
sippeers=>mysql,asterisk,sip_buddies
extensions=>mysql,asterisk,extensions_table
voicemail=>mysql,asterisk,voicemail_users
queues=>mysql,asterisk,queue_table
queue_members=>mysql,asterisk,queue_member_table

So i went back to voip-info.org and take a look again at their howto. And i saw that they say to use the svn version of asterisk-addons . I was using the one on on their ftp . So i tried to build the “subversion” version!

make[1]: Entering directory `/usr/src/asterisk-addons/menuselect'
make[1]: `menuselect' is up to date.
make[1]: Leaving directory `/usr/src/asterisk-addons/menuselect'
make[1]: Entering directory `/usr/src/asterisk-addons'
make[2]: Entering directory `/usr/src/asterisk-addons/menuselect'
make[2]: `menuselect' is up to date.
make[2]: Leaving directory `/usr/src/asterisk-addons/menuselect'
gcc -g -c -fPIC -fPIC -o app_addon_sql_mysql.o app_addon_sql_mysql.c
app_addon_sql_mysql.c:15:22: asterisk.h: No such file or directory
In file included from /usr/include/asterisk/linkedlists.h:23,
                 from /usr/include/asterisk/chanvars.h:26,
                 from /usr/include/asterisk/channel.h:111,
                 from /usr/include/asterisk/file.h:30,
                 from app_addon_sql_mysql.c:27:
/usr/include/asterisk/lock.h: In function `ast_mutex_init':
/usr/include/asterisk/lock.h:534: error: `PTHREAD_MUTEX_RECURSIVE' undeclared (first use in this function)
/usr/include/asterisk/lock.h:534: error: (Each undeclared identifier is reported only once
/usr/include/asterisk/lock.h:534: error: for each function it appears in.)
app_addon_sql_mysql.c: In function `MYSQL_exec':
app_addon_sql_mysql.c:390: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:390: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:390: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:412: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:412: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:412: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:412: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c: At top level:
app_addon_sql_mysql.c:419: error: conflicting types for 'unload_module'
/usr/include/asterisk/module.h:57: error: previous declaration of 'unload_module' was here
app_addon_sql_mysql.c:419: error: conflicting types for 'unload_module'
/usr/include/asterisk/module.h:57: error: previous declaration of 'unload_module' was here
app_addon_sql_mysql.c: In function `unload_module':
app_addon_sql_mysql.c:420: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c:420: error: dereferencing pointer to incomplete type
app_addon_sql_mysql.c: At top level:
app_addon_sql_mysql.c:425: error: conflicting types for 'load_module'
/usr/include/asterisk/module.h:46: error: previous declaration of 'load_module' was here
app_addon_sql_mysql.c:425: error: conflicting types for 'load_module'
/usr/include/asterisk/module.h:46: error: previous declaration of 'load_module' was here
app_addon_sql_mysql.c:432: error: conflicting types for 'description'
/usr/include/asterisk/module.h:75: error: previous declaration of 'description' was here
app_addon_sql_mysql.c:432: error: conflicting types for 'description'
/usr/include/asterisk/module.h:75: error: previous declaration of 'description' was here
app_addon_sql_mysql.c:437: error: conflicting types for 'key'
/usr/include/asterisk/module.h:92: error: previous declaration of 'key' was here
app_addon_sql_mysql.c:437: error: conflicting types for 'key'
/usr/include/asterisk/module.h:92: error: previous declaration of 'key' was here
app_addon_sql_mysql.c:441: warning: data definition has no type or storage class
make[1]: *** [app_addon_sql_mysql.o] Error 1
make[1]: Leaving directory `/usr/src/asterisk-addons'
make: *** [all] Error 2

I really need help here … my boss just don’t stop asking me when the realtime server will be up … So please any idea would be great
Thanks for reading

2
derrr, into the sql insert query i had to put a value for the 'name' field.... no longer have a problem, tah

i’m having trouble too, but not the types you’re having. Something to do with the KEY. I can’t even INSERT into DB. I get this error.
mysql> INSERT INTO sip_all
-> (callgroup,callerid,canreinvite,context,dtmfmode,host,mailbox,nat,pickupgroup,secret,type,username,disallow,allow)
-> VALUES(1,30,“yes”,“full-access”,“rfc2833”,“dynamic”,20,“never”,1,“asdf”,“friend”,“30 netcomm”,“all”,“g729”);
ERROR 1062 (23000): Duplicate entry ‘’ for key 2

To create the table I just took the stuff off voip-info.

`ipaddr` varchar(15) NOT NULL default '', `regexten` varchar(80) NOT NULL default '', `cancallforward` char(3) default 'yes', `setvar` varchar(100) NOT NULL default '', PRIMARY KEY (`id`), UNIQUE KEY `name` (`name`), KEY `name_2` (`name`) ) TYPE=MyISAM ROW_FORMAT=DYNAMIC;

I don’t understand why that third KEY is there.
Can someone enlighten me please.

3

It dosent seem that the asterisk add ons complied properly. Also do you have the switch statement at the bottom of your conf files. Also did you do a reload after making changes ?