[OpenSER-Users] asterisk/openser/mysql

[Eliass Salim]

Hi,

I've installed asterisk on a computer and openser on an other, I already 
have a mysql database for openser,
and I'm now trying to install one for asterisk, but when I type:

CREATE DATABASE asterisk;
USE asterisk;
CREATE VIEW voicemail AS
SELECT phplib_id as uniqueid,
username as customer_id,
'default' 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 WHERE
vmail = TRUE;


I have the following error:
ERROR 1054 (42S22): Unknown column 'phplib_id' in 'field list'


I already had this problem for opensertcl, but I fixed it by adding 
WEBSER="yes" on openserctlr.


thanks,
Eliass