[OpenSER-Users] asterisk/openser/mysql

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