Hi all,
A week or so down the list, i read that not many people were using
realtime on an Asterisk18, so i had this afternoon a go at it...
[sorry for the inconveneant line-wraps]
First i did:
mysql> create database asterisk;
mysql> grant all on asterisk.* to 'voipadmin'@'localhost' identified by
next i used the info from the wiki:
CREATE TABLE `sip_devices` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(80) NOT NULL DEFAULT '', `context` varchar(80) DEFAULT
NULL, ....
....
[and lots more]
and populated it with a test user:
mysql> 'secret'; insert into sip_devices (name, secret, username, host,
nat) values ('00000031756', 'geheim', '00000031756', 'dynamic', 'Yes');
tested the database:
mysql -h localhost -u voipadmin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 12645
Server version: 5.0.67 SUSE MySQL RPM
Type 'help;' or '\h' for help. Type '\c' to clear the buffer.
mysql> select * from sip_devices\G
ERROR 1046 (3D000): No database selected
mysql> use asterisk;
Database changed
mysql> select name,username,secret,host,nat from sip_devices;
+-------------+-------------+--------+---------+-----+
| name | username | secret | host | nat |
+-------------+-------------+--------+---------+-----+
| 00000031756 | 00000031756 | geheim | dynamic | Yes |
+-------------+-------------+--------+---------+-----+
1 row in set (0.00 sec)
mysql>
So-far all looked, as expected, great
Changed the *-config files:
(method, db-name, table-name)
;
;iaxusers => odbc,asterisk
;iaxpeers => odbc,asterisk
;sipusers => odbc,asterisk
sipusers => mysql,asterisk,sip_devices
sippeers => mysql,asterisk,sip_devices
;sippeers => odbc,asterisk
;sipregs => odbc,asterisk
;voicemail => odbc,asterisk
And restarted the asterisk-process...
Some lines from /var/log/asterisk/messages:
May 12 14:05:33] WARNING[2585] config.c: Realtime mapping for 'sippeers'
found to engine 'mysql', but the engine is not available
[May 12 14:05:33] WARNING[2585] config.c: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
[May 12 14:05:55] WARNING[2630] config.c: Realtime mapping for
'sippeers' found to engine 'mysql', but the engine is not available
And on the asterisk console:
kc3054*CLI> sip show peers
Name/username Host Dyn Forcerport ACL Port Status
00000277611 (Unspecified) D N 0 Unmonitored
j.witvliet (Unspecified) D N 0 Unmonitored
2 sip peers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 2
offline] [May 12 14:17:47] WARNING[2630]: config.c:2045 find_engine:
Realtime mapping for 'sippeers' found to engine 'mysql', but the engine
is not available
CLI> sip show users
Username Secret Accountcode Def.Context ACL ForcerPort
j.witvliet geheim default No Yes
00000277611 25b06d3a0b5ef73 default No Yes
CLI>
====================================================
1) as shown above, access to mysql seems to be OK,
2) * did not complain at "sip-show-users" but only for "sip-show-peers"
fyi, i use: asterisk180-1.8.3.2-87.1.x86_64.rpm
Any suggesions?
Hans