It does the trick! Thanks Kun
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Matthew Boehm Sent: Thursday, August 11, 2005 11:13 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: Re: [Asterisk-Users] asterisk query mysql problem or bug? 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 > [email protected] > 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 [email protected] 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 [email protected] http://lists.digium.com/mailman/listinfo/asterisk-users To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
