Alles neu installiert, Realtime Tabellen (bzw zumindest die "sip" Tabelle) werden aber nicht ausgelesen.
Ich sehe keine Fehlermeldungen in Logs
/var/log/asterisk/messages
/var/log/mysql/mysql.log
res_mysql.conf
extconfig.conf
Tabelle "sip" hat einige Einträge drinnen.
Habe mit rtcachefriends=yes und no ausprobiert, keine Auswirkung.
Hat wer eine Ahnung was ich da nicht richtig mache?
lG,
Ammar
Code:
# service asterisk start
...
Connected to Asterisk 1.6.2.19 currently running on asterisk16 (pid = 2401)
Verbosity is at least 3
asterisk16*CLI> sip show peers
Name/username Host Dyn Nat ACL Port Status Realtime
0 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 0 offline]
asterisk16*CLI> realtime mysql status
general connected to asterisk@localhost, port 3306 with username astrealtime for 7 minutes.
asterisk16*CLI> realtime mysql cache
general sip
general voicemail_users
general queue_membersIch sehe keine Fehlermeldungen in Logs
/var/log/asterisk/messages
Code:
[Jul 6 16:42:14] NOTICE[2401] cdr.c: CDR simple logging enabled.
[Jul 6 16:42:14] NOTICE[2401] loader.c: 175 modules will be loaded.
[Jul 6 16:42:14] NOTICE[2401] res_smdi.c: No SMDI interfaces are available to listen on, not starting SMDI listener.
[Jul 6 16:42:14] NOTICE[2401] config.c: Registered Config Engine mysql
[Jul 6 16:42:14] NOTICE[2401] pbx_ael.c: Starting AEL load process.
[Jul 6 16:42:14] NOTICE[2401] pbx_ael.c: AEL load process: parsed config file name '/etc/asterisk/extensions.ael'.
[Jul 6 16:42:14] NOTICE[2401] pbx_ael.c: AEL load process: checked config file name '/etc/asterisk/extensions.ael'.
[Jul 6 16:42:14] NOTICE[2401] pbx_ael.c: AEL load process: compiled config file name '/etc/asterisk/extensions.ael'.
[Jul 6 16:42:14] NOTICE[2401] pbx_ael.c: AEL load process: merged config file name '/etc/asterisk/extensions.ael'.
[Jul 6 16:42:14] NOTICE[2401] pbx_ael.c: AEL load process: verified config file name '/etc/asterisk/extensions.ael'.
[Jul 6 16:42:14] NOTICE[2401] chan_skinny.c: Configuring skinny from skinny.conf
[Jul 6 16:42:14] WARNING[2401] chan_dahdi.c: Ignoring any changes to 'userbase' (on reload) at line 23.
[Jul 6 16:42:14] WARNING[2401] chan_dahdi.c: Ignoring any changes to 'vmsecret' (on reload) at line 31.
[Jul 6 16:42:14] WARNING[2401] chan_dahdi.c: Ignoring any changes to 'hassip' (on reload) at line 35.
[Jul 6 16:42:14] WARNING[2401] chan_dahdi.c: Ignoring any changes to 'hasiax' (on reload) at line 39.
[Jul 6 16:42:14] WARNING[2401] chan_dahdi.c: Ignoring any changes to 'hasmanager' (on reload) at line 47.
[Jul 6 16:42:14] WARNING[2401] utils.c: trying to reset empty pool
[Jul 6 16:42:14] WARNING[2401] utils.c: trying to reset empty pool
[Jul 6 16:42:14] WARNING[2401] utils.c: trying to reset empty pool/var/log/mysql/mysql.log
Code:
110706 16:42:14 16 Connect astrealtime@localhost on asterisk
16 Query SET NAMES latin1
16 Query DESC sip
16 Init DB asterisk
16 Query DESC voicemail_users
17 Connect astrealtime@localhost on asterisk
17 Query SET NAMES ''
17 Query DESC cdr
16 Init DB asterisk
16 Query DESC queue_membersres_mysql.conf
Code:
[general]
dbhost = localhost
dbname = asterisk
dbuser = astrealtime
dbpass = ...
dbport = 3306
dbsock = /var/lib/mysql/mysql.sock
dbcharset = latin1
requirements=warn ; or createclose or createchar
...extconfig.conf
Code:
...
sippeers => mysql,general,sip
sipusers => mysql,general,sip
Code:
mysql> desc sip;
+------------------+------------------------------+------+-----+----------+----------------+
| Field | Type | Null | Key | Default | Extra |
+------------------+------------------------------+------+-----+----------+----------------+
| id | int(11) | NO | PRI | NULL | auto_increment |
| name | varchar(80) | NO | UNI | | |
| host | varchar(31) | NO | | dynamic | |
| nat | varchar(5) | NO | | no | |
| type | enum('user','peer','friend') | NO | | friend | |
| accountcode | varchar(20) | YES | | NULL | |
| amaflags | varchar(13) | YES | | NULL | |
| call-limit | smallint(5) unsigned | YES | | NULL | |
| callgroup | varchar(10) | YES | | NULL | |
| callerid | varchar(80) | YES | | NULL | |
| cancallforward | char(3) | YES | | yes | |
| canreinvite | char(3) | YES | | no | |
| context | varchar(80) | YES | | interno | |
| defaultip | varchar(15) | YES | | NULL | |
| dtmfmode | varchar(7) | YES | | NULL | |
| fromuser | varchar(80) | YES | | NULL | |
| fromdomain | varchar(80) | YES | | NULL | |
| insecure | varchar(4) | YES | | NULL | |
| language | char(2) | YES | | NULL | |
| mailbox | varchar(50) | YES | | NULL | |
| md5secret | varchar(80) | YES | | NULL | |
| deny | varchar(95) | YES | | NULL | |
| permit | varchar(95) | YES | | NULL | |
| mask | varchar(95) | YES | | NULL | |
| musiconhold | varchar(100) | YES | | NULL | |
| pickupgroup | varchar(10) | YES | | NULL | |
| qualify | char(3) | YES | | yes | |
| regexten | varchar(80) | YES | | NULL | |
| restrictcid | char(3) | YES | | NULL | |
| rtptimeout | char(3) | YES | | NULL | |
| rtpholdtimeout | char(3) | YES | | NULL | |
| secret | varchar(80) | YES | | asterisk | |
| setvar | varchar(100) | YES | | NULL | |
| disallow | varchar(100) | YES | | all | |
| allow | varchar(100) | YES | | alaw | |
| fullcontact | varchar(80) | NO | | | |
| ipaddr | varchar(15) | NO | | | |
| port | smallint(5) unsigned | NO | | 0 | |
| regserver | varchar(100) | YES | | NULL | |
| regseconds | int(11) | NO | | 0 | |
| lastms | int(11) | NO | | 0 | |
| username | varchar(80) | NO | | | |
| defaultuser | varchar(80) | NO | | | |
| subscribecontext | varchar(80) | YES | | NULL | |
| useragent | varchar(20) | YES | | NULL | |
+------------------+------------------------------+------+-----+----------+----------------+
45 rows in set (0.01 sec)Tabelle "sip" hat einige Einträge drinnen.
Habe mit rtcachefriends=yes und no ausprobiert, keine Auswirkung.
Hat wer eine Ahnung was ich da nicht richtig mache?
lG,
Ammar
Zuletzt bearbeitet:
