mysql> select * from gag1_sip where name=3002; +--------+------+-------------+---------+------+------+-------------+----------+------------+-----------+-------------+----------------+-------------+----------+-----------+---------+----------+------------+----------+----------+---------+-----------+------+--------+------+-------------+-------------+---------+----------+-------------+------------+---------------+-----------------+--------+----------+------------+------------------------+---------------+-------+-----------------------+------------+--------+-------------+-----------------+--------------------------------------------+------------+----------+--------------+----------+--------+--------+------------+-------------+-----------------+---------------------+---------+---------+------------+---------+----------+-------------+------------+-------+--------------+----------+----------+-------+------------+----------+-----------+----------+------+----------+-------------+------------+ | sip_id | name | fullname | host | nat | type | accountcode | amaflags | call-limit | callgroup | callerid | cancallforward | canreinvite | context | defaultip | dtmfmod | fromuser | fromdomain | insecure | language | mailbox | md5secret | deny | permit | mask | musiconhold | pickupgroup | qualify | regexten | restrictcid | rtptimeout | rtpholdtimeut | secret | setvar | disallow | allow | fullcontact | ipaddr | port | regserver | regseconds | lastms | defaultuser | subscribecontext| useragent | macaddress | userbase | hasvoicemail | vmsecret | hassip | hasiax | hasmanager | callwaiting | threewaycalling | callwaitingcallerid |transfer | canpark | callreturn | vmexten | username | registersip | cid_number | email | hasdirectory | hasagent | autoprov | label | linenumber | linekeys | trunkname | authuser |group | hasexten | registeriax | trunkstyle | +--------+------+-------------+---------+------+------+-------------+----------+------------+-----------+-------------+----------------+-------------+----------+-----------+---------+----------+------------+----------+----------+---------+-----------+------+--------+------+-------------+-------------+---------+----------+-------------+------------+---------------+-----------------+--------+----------+------------+------------------------+---------------+-------+-----------------------+------------+--------+-------------+-----------------+--------------------------------------------+------------+----------+--------------+----------+--------+--------+------------+-------------+-----------------+---------------------+---------+---------+------------+---------+----------+-------------+------------+-------+--------------+----------+----------+-------+------------+----------+-----------+----------+------+----------+-------------+------------+ | 2 | 3002 | Carol Agent | dynamic | yes | peer | NULL | NULL | NULL | 1 | 0123456789| NULL | yes | DLPN_All | NULL | rfc2833 | NULL | NULL | no | NULL | 3002 | NULL | NULL | NULL | NULL | NULL | 1 | yes | NULL | NULL | NULL | NULL | xxxxxxxxxxxxxxx| NULL | all | ulaw;alaw; | sip:3002@192.168.1.230 | 195.59.152.66 | 40452 | XXXXXXXXX | 1287754928 | 93 | 3002 | NULL | PolycomSoundPointIP-SPIP_550-UA/3.3.1.0769 | NULL | NULL | no | NULL | NULL | NULL | NULL | NULL | NULL | NULL |NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL |NULL | NULL | NULL | NULL | +--------+------+-------------+---------+------+------+-------------+----------+------------+-----------+-------------+----------------+-------------+----------+-----------+---------+----------+------------+----------+----------+---------+-----------+------+--------+------+-------------+-------------+---------+----------+-------------+------------+---------------+-----------------+--------+----------+------------+------------------------+---------------+-------+-----------------------+------------+--------+-------------+-----------------+--------------------------------------------+------------+----------+--------------+----------+--------+--------+------------+-------------+-----------------+---------------------+---------+---------+------------+---------+----------+-------------+------------+-------+--------------+----------+----------+-------+------------+----------+-----------+----------+------+----------+-------------+------------+ 1 row in set (0.00 sec) mysql>