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 | 2000@local | friend |
1123733887 | 10.1.2.192 | 2000 | 5060 |
| 2 | 2001 | from-sip | 10.1.2.220 | dynamic | 2001@local | 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
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 | 2000@local | friend | > 1123733887 | 10.1.2.192 | 2000 | 5060 | > | 2 | 2001 | from-sip | 10.1.2.220 | dynamic | 2001@local | 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 >