Two things: 1. Set the context 2. Set the port > Hi, > > I am using Realtime for sip configuration. > When there is an INVITE which arrives at asterisk > asterisk makes the following selects: > Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 > mysql_reconnect: MySQL RealTime: Everything is fine. > [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:138 > realtime_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM > sip_conf WHERE name = 'tzl' > [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 > mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 > 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: > MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE host = > '192.168.0.74' AND port = '5060' > [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 > mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 > 10:37:10] DEBUG[31852]: res_config_mysql.c:138 realtime_mysql: > MySQL RealTime: Retrieve SQL: SELECT * FROM sip_conf WHERE ipaddr = > '192.168.0.74' AND port = '5060' > [Nov 20 10:37:10] DEBUG[31852]: res_config_mysql.c:651 > mysql_reconnect: MySQL RealTime: Everything is fine. [Nov 20 > 10:37:10] DEBUG[31852]: res_config_mysql.c:258 > realtime_multi_mysql: MySQL RealTime: Retrieve SQL: SELECT * FROM > sip_conf WHERE host = '192.168.0.74' ORDER BY host [Nov 20 > 10:37:10] DEBUG[31852]: res_config_mysql.c:651 mysql_reconnect: > MySQL RealTime: Everything is fine. [Nov 20 10:37:10] DEBUG[31852]: > res_config_mysql.c:258 realtime_multi_mysql: MySQL RealTime: > Retrieve SQL: SELECT * FROM sip_conf WHERE ipaddr = '192.168.0.74' > ORDER BY ipaddr Found no matching peer or user for > '192.168.0.74:5060' > > as seen above there is no result for this select although I have > such record in the database: > > mysql> SELECT * FROM sip_conf WHERE host = '192.168.0.74' ORDER BY > host; +----+-----------------------+-------------+----------+------- > ----+------------+-------------+---------+-----------+----------+--- > -------+------------+-------------+--------------+----------+------- > ---+---------+-----------+-----+------+--------+------+------------- > +------+---------+-------------+------------+----------------+------ > --+------+----------+----------+-------------------------+---------- > ---+------------+--------+----------+----------------+--------+ > | id | name | accountcode | amaflags | callgroup | > callerid | canreinvite | context | defaultip | dtmfmode | > fromuser | fromdomain | fullcontact | host | insecure | > language | mailbox | md5secret | nat | deny | permit | mask | > pickupgroup | port | qualify | restrictcid | rtptimeout | > rtpholdtimeout | secret | type | username | disallow | allow > | musiconhold | regseconds | ipaddr | regexten | > cancallforward | setvar | +----+-----------------------+------------ > -+----------+-----------+------------+-------------+---------+------ > -----+----------+----------+------------+-------------+------------- > -+----------+----------+---------+-----------+-----+------+-------- > +------+-------------+------+---------+-------------+------------+-- > --------------+--------+------+----------+----------+--------------- > ----------+-------------+------------+--------+----------+---------- > ------+--------+ > | 3 | outbound-voip.touk.pl | NULL | NULL | NULL | > TouK S.K.A | no | NULL | NULL | NULL | NULL > | NULL | NULL | 192.168.0.74 | NULL | NULL | > NULL | NULL | no | NULL | NULL | NULL | NULL | > | NULL | NULL | NULL | NULL | NULL | peer > | | all | g729;ilbc;gsm;ulaw;alaw | NULL | 0 | > | | yes | | +----+----------------------- > +-------------+----------+-----------+------------+-------------+--- > ------+-----------+----------+----------+------------+------------- > +--------------+----------+----------+---------+-----------+-----+-- > ----+--------+------+-------------+------+---------+-------------+-- > ----------+----------------+--------+------+----------+----------+-- > -----------------------+-------------+------------+--------+-------- > --+----------------+--------+ > > Why does realtime select give no results?? > > Cheers > tomasz > > _______________________________________________ > --Bandwidth and Colocation Provided by http://www.api-digital.com-- > > asterisk-users mailing list > To UNSUBSCRIBE or update options visit: > http://lists.digium.com/mailman/listinfo/asterisk-users
_______________________________________________ --Bandwidth and Colocation Provided by http://www.api-digital.com-- asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users
