search for: voipadmin

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...

...ot; Besids the commands i tried below, isn't there any other way to see what's going on? Perhaps it is totally unrelated, but if i perform a mysql-login on the prompt, i first have to select the database manualy, ie it isn't selected by default for the created mysqluser [in this case: voipadmin] Other wild idea, is there a minimum number of fields that haved to be filled? And why is asterisk complaining about not being able to find the databse, when trying to fill it from the asterisk-CLI? My database _is_ named "asterisk"...... > kc3054*CLI> realtime update sipusers se...

...ers [Monitored: 0 online, 0 offline Unmonitored: 0 online, 2 offline] kc3054*CLI> Here i see at for both users and peers ONLY the statis entries from sip.conf file, nothing from mysql... kc3054*CLI> realtime mysql status general connected to asterisk at 127.0.0.1, port 3306 with username voipadmin for 5 seconds. kc3054*CLI> =>No warnings/errors but nothing else either... kc3054*CLI> kc3054*CLI> realtime mysql cache kc3054*CLI> =>No warnings/errors but nothing else either... the module res_config_mysql.so is loaded, Try todo something else: kc3054*CLI> realtime upda...