lo que hice realmente fue un ALTER TABLE subscriber ADD vmail_password
varchar(32); dentro de la base de datos de openser , lo raro es que al hacer
un sip show peers en asterisk solo me presenta el usuario de openser que
tengo creado dentro del sip.conf , y deberian aparecerme todos los usuarios
de openser , es asi como he estado leyendo ..
ojo te muestro como cree las tablas del realtime en mysql
create database asterisk;
use asterisk;
CREATE TABLE `voicemessages` (
`id` int(11) NOT NULL auto_increment,
`msgnum` int(11) NOT NULL default '0',
`dir` varchar(80) default '',
`context` varchar(80) default '',
`macrocontext` varchar(80) default '',
`callerid` varchar(40) default '',
`origtime` varchar(40) default '',
`duration` varchar(20) default '',
`mailboxuser` varchar(80) default '',
`mailboxcontext` varchar(80) default '',
`recording` longblob,
PRIMARY KEY (`id`),
KEY `dir` (`dir`)
) ENGINE=InnoDB;
CREATE VIEW vmusers AS
SELECT id as uniqueid,
username as customer_id,
'netsoluciones' as context,
username as mailbox,
vmail_password as password,
CONCAT(first_name,' ',last_name) as fullname,
email_address as email,
NULL as pager,
datetime_created as stamp
FROM openser.subscriber;
CREATE VIEW sipusers AS
SELECT username as name,
username,
'friend' as type,
NULL as secret,
domain as host,
CONCAT(rpid, ' ','<',username,'>') as callerid,
'netsoluciones' as context,
username as mailbox,
'yes' as nat,
'no' as qualify,
username as fromuser,
NULL as authuser,
domain as fromdomain,
NULL as insecure,
'no' as canreinvite,
NULL as disallow,
NULL as allow,
NULL as restrictcid,
domain as defaultip,
domain as ipaddr,
'5060' as port,
NULL as regseconds
FROM openser.subscriber;
saludoss
rickygm
2008/10/14 Saúl Ibarra <saghul(a)gmail.com>
Como has hecho la vista de la tabla subscriber? Yo
tuve más de un
problema con eso...