[Asterisk-Users] Realtime mysql problem?

Matt Schulte mschulte at netlogic.net
Thu Mar 24 07:18:12 MST 2005


All, I get this whenever trying to dial to a peer when the peer
registered to another server. I'm basically trying to use realtime to
check for the peer and dial it.

Mar 24 09:16:47 VERBOSE[4527]:     -- Executing Dial("SIP/brak-f69f",
"IAX2/brak-test/107") in new stack
Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Retrieve SQL: SELECT * FROM
sip_users WHERE name = 'brak-test'
Mar 24 09:16:47 DEBUG[4527]: MySQL RealTime: Everything is fine.
Mar 24 09:16:47 NOTICE[4527]: Unable to create channel of type 'IAX2'
(cause 3)
Mar 24 09:16:47 VERBOSE[4527]:   == Everyone is busy/congested at this
time (1:0/1/0)
Mar 24 09:16:47 DEBUG[4527]: Exiting with DIALSTATUS=CONGESTION.

When I query mysql manually I see this (using the exact same command
that mysql realtime did). Looks fine to me, wheres the problem at?? can
I debug anymore somehow? Thanks

mysql> SELECT * FROM sip_users WHERE name = 'brak-test'
    -> ;
+----+-----------+-------------+----------+-----------+----------+------
-------+----------+-------------+-----------+----------+----------+-----
-------+---------+----------+---------+-----+-------------+------+------
---+-------------+------------+----------------+-----------+--------+---
--------+----------+----------------+------------+---------------+------
----------+
| id | name      | accountcode | amaflags | callgroup | callerid |
canreinvite | context  | peercontext | defaultip | dtmfmode | fromuser |
fromdomain | host    | insecure | mailbox | nat | pickupgroup | port |
qualify | restrictcid | rtptimeout | rtpholdtimeout | secret    | type
| username  | disallow | allow          | regseconds | ipaddr        |
cancallforward |
+----+-----------+-------------+----------+-----------+----------+------
-------+----------+-------------+-----------+----------+----------+-----
-------+---------+----------+---------+-----+-------------+------+------
---+-------------+------------+----------------+-----------+--------+---
--------+----------+----------------+------------+---------------+------
----------+
|  3 | brak-test | NULL        | NULL     | NULL      | NULL     | no
| outbound | incoming    | NULL      | NULL     | NULL     | NULL
| dynamic | NULL     | NULL    |   0 | NULL        | 4569 | NULL    |
NULL        | NULL       | NULL           | brak-test | friend | blah
| all      | ulaw;alaw;g729 | 1111673371 | 206.80.xxx.xxx | yes
|
+----+-----------+-------------+----------+-----------+----------+------
-------+----------+-------------+-----------+----------+----------+-----
-------+---------+----------+---------+-----+-------------+------+------
---+-------------+------------+----------------+-----------+--------+---
--------+----------+----------------+------------+---------------+------
----------+



More information about the asterisk-users mailing list