Don't use commas as delimiters in database. You must use pipe |. Replace
your commas and see if that does the trick.
-Matthew
Wei Kun wrote:
Hi;
I have entries as below in DB,
mysql> select * from sip_buddies;
+----+------+----------+------------+---------+------------+--------+-------
-----+------------+----------+------+
| id | name | context | defaultip | host | mailbox | type |
regseconds | ipaddr | username | port |
+----+------+----------+------------+---------+------------+--------+-------
-----+------------+----------+------+
| 1 | 2000 | from-sip | 10.1.2.192 | dynamic | [EMAIL PROTECTED] | friend |
1123733887 | 10.1.2.192 | 2000 | 5060 |
| 2 | 2001 | from-sip | 10.1.2.220 | dynamic | [EMAIL PROTECTED] | friend |
1123733888 | 10.1.1.220 | 2001 | 5080 |
+----+------+----------+------------+---------+------------+--------+-------
-----+------------+----------+------+
2 rows in set (0.01 sec)
mysql> select * from extensions_table;
+----+----------+-------+----------+---------------+----------------+
| id | context | exten | priority | app | appdata |
+----+----------+-------+----------+---------------+----------------+
| 1 | from-sip | 2000 | 1 | Dial | SIP/2000,20 |
| 2 | from-sip | 2000 | 2 | Voicemail | u2000 |
| 3 | from-sip | 2000 | 102 | Voicemail | b2000 |
| 4 | from-sip | 2000 | 103 | Hangup | |
| 5 | from-sip | 2001 | 1 | Dial | SIP/2001 |
| 6 | from-sip | 2001 | 2 | Voicemail | u2001 |
| 7 | from-sip | 2001 | 102 | Voicemail | b2001 |
| 8 | from-sip | 2001 | 103 | Hangup | |
| 9 | from-sip | 2999 | 1 | VoicemailMain | ${CALLERIDNUM} |
+----+----------+-------+----------+---------------+----------------+
9 rows in set (0.00 sec)
Somehow the program get the info '2001,20' stripped from extensions_table
appdata column 'SIP/2001, 20', and try to look it up in sip_buddies name
column as debug output below.
Aug 11 12:23:05 DEBUG[23952] res_config_mysql.c: MySQL RealTime: Retrieve
SQL: SELECT * FROM sip_buddies WHERE name = '2001,20'
Of course, it can't find it, and go to second step for voicemail. If I
change the appdata to 'SIP/2001', it can find it and ring remote party, the
problem is it rings for ever without the 20 hint.
Any hints for this problem?
Thanks
Kun
_______________________________________________
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
_______________________________________________
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
