[OpenSER-Users] asterisk/openser/mysql

[Henning Westerholt]

On Wednesday 09 July 2008, Eliass Salim wrote:
> 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,
         ^^^^^^^^^
> I already had this problem for opensertcl, but I fixed it by adding
> WEBSER="yes" on openserctlr.

Hi Eliass,

you need to adapt the SQL script to your specific installation. If you choose 
to install without the support for SERWEB, then you also need to ommit the 
SERWEB parts also from the asterisk database.

Henning