<div dir="ltr">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 ..<br>
<br><br>ojo te muestro como cree las tablas del realtime en mysql<br><br>create database asterisk;<br><br>use asterisk;<br><br>CREATE TABLE `voicemessages` (<br> `id` int(11) NOT NULL auto_increment,<br> `msgnum` int(11) NOT NULL default '0',<br>
`dir` varchar(80) default '',<br> `context` varchar(80) default '',<br> `macrocontext` varchar(80) default '',<br> `callerid` varchar(40) default '',<br> `origtime` varchar(40) default '',<br>
`duration` varchar(20) default '',<br> `mailboxuser` varchar(80) default '',<br> `mailboxcontext` varchar(80) default '',<br> `recording` longblob,<br> PRIMARY KEY (`id`),<br> KEY `dir` (`dir`)<br>
) ENGINE=InnoDB;<br><br>CREATE VIEW vmusers AS<br>SELECT id as uniqueid,<br> username as customer_id,<br> 'netsoluciones' as context,<br> username as mailbox,<br> vmail_password as password,<br> CONCAT(first_name,' ',last_name) as fullname,<br>
email_address as email,<br> NULL as pager,<br> datetime_created as stamp<br>FROM openser.subscriber;<br><br>CREATE VIEW sipusers AS<br>SELECT username as name,<br> username,<br> 'friend' as type,<br> NULL as secret,<br>
domain as host,<br> CONCAT(rpid, ' ','<',username,'>') as callerid,<br> 'netsoluciones' as context,<br> username as mailbox,<br> 'yes' as nat,<br> 'no' as qualify,<br>
username as fromuser,<br> NULL as authuser,<br> domain as fromdomain,<br> NULL as insecure,<br> 'no' as canreinvite,<br> NULL as disallow,<br> NULL as allow,<br> NULL as restrictcid,<br> domain as defaultip,<br>
domain as ipaddr,<br> '5060' as port,<br> NULL as regseconds<br>FROM openser.subscriber;<br><br><br>saludoss<br><br>rickygm<br><br><br><br><div class="gmail_quote">2008/10/14 Saúl Ibarra <span dir="ltr"><<a href="mailto:saghul@gmail.com">saghul@gmail.com</a>></span><br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">Como has hecho la vista de la tabla subscriber? Yo tuve más de un<br>
problema con eso...<br>
<br>
<br>
</blockquote></div><br></div>