Кусок extconfig.conf:
Код: Выделить всё
sippeers => odbc,asterisk
sipregs => odbc,asterisk
Код: Выделить всё
mysql> describe sipregs;
+-------------+-----------------------+------+-----+---------+----------------+
| Field | Type | Null | Key | Default | Extra |
+-------------+-----------------------+------+-----+---------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(80) | NO | UNI | | |
| fullcontact | varchar(80) | NO | | | |
| ipaddr | varchar(15) | NO | | | |
| port | mediumint(5) unsigned | NO | | 0 | |
| username | varchar(80) | NO | | | |
| regserver | varchar(100) | YES | | NULL | |
| regseconds | int(11) | NO | | 0 | |
+-------------+-----------------------+------+-----+---------+----------------+
mysql> select * from sipregs;
+----+----------+--------------------------------+--------+------+----------+--------------+------------+
| id | name | fullcontact | ipaddr | port | username | regserver | regseconds |
+----+----------+--------------------------------+--------+------+----------+--------------+------------+
| 1 | testline1 | 9999:sip2015@aster.lan/9999 | | 5060 | 9999 | aster.lan | 0 |
+----+----------+--------------------------------+--------+------+----------+--------------+------------+
