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
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
yes, but when I installed openser, I also installed webser that is what I don't understand Can you tell me which file I have to modify please.
thanks Eliass
Henning Westerholt wrote:
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
On Wednesday 09 July 2008, Eliass Salim wrote:
yes, but when I installed openser, I also installed webser that is what I don't understand Can you tell me which file I have to modify please.
Hi Eliass,
i misread your first mail, i thought you have _not_ installed the SERWEB stuff and not activated SERWEB=yes in openserctlrc. Do you have installed the SERWEB tables too?
Cheers,
Henning
Hi Eliass,
On 07/09/08 18:04, Henning Westerholt wrote:
On Wednesday 09 July 2008, Eliass Salim wrote:
yes, but when I installed openser, I also installed webser that is what I don't understand Can you tell me which file I have to modify please.
Hi Eliass,
i misread your first mail, i thought you have _not_ installed the SERWEB stuff and not activated SERWEB=yes in openserctlrc. Do you have installed the SERWEB tables too?
paste here the output of "show create table openser.subscriber' -- it will reveal if you have needed columns.
Cheers, Daniel
Hi Daniel,
Here is the result of the command.
Thanks.
mysql> show create table openser.subscriber; +------------+--------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------------+ | Table | Create Table | +------------+-------------------------------------------------------------------------------------------------------------------- ------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------------------------------------------------------------------------------------ ------------------------------------------------------+ | subscriber | CREATE TABLE `subscriber` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL default '', `domain` varchar(64) NOT NULL default '', `password` varchar(25) NOT NULL default '', `first_name` varchar(64) NOT NULL default '', `last_name` varchar(64) NOT NULL default '', `email_address` varchar(64) NOT NULL default '', `datetime_created` datetime NOT NULL default '1900-01-01 00:00:01', `ha1` varchar(64) NOT NULL default '', `ha1b` varchar(64) NOT NULL default '', `timezone` varchar(64) default NULL, `rpid` varchar(64) default NULL, `vmail_password` varchar(40) default NULL, `vmail` tinyint(1) default '1', PRIMARY KEY (`id`), UNIQUE KEY `account_idx` (`username`,`domain`), KEY `username_idx` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 | +------------+---------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------------- ------------------------------------------+ 1 row in set (0.06 sec)
Daniel-Constantin Mierla wrote:
Hi Eliass,
On 07/09/08 18:04, Henning Westerholt wrote:
On Wednesday 09 July 2008, Eliass Salim wrote:
yes, but when I installed openser, I also installed webser that is what I don't understand Can you tell me which file I have to modify please.
Hi Eliass,
i misread your first mail, i thought you have _not_ installed the SERWEB stuff and not activated SERWEB=yes in openserctlrc. Do you have installed the SERWEB tables too?
paste here the output of "show create table openser.subscriber' -- it will reveal if you have needed columns.
Cheers, Daniel
Hello Eliass,
you haven't created the serweb tables - phplib_id is missing. If you use serweb 0.9.x, you need them, otherwise you can change the phplib_id with id when creating the view.
Cheers, Daniel
On 07/11/08 14:00, Eliass Salim wrote:
Hi Daniel,
Here is the result of the command.
Thanks.
mysql> show create table openser.subscriber; +------------+---------------------------------------------------------------------------------------------------------------------
------------------------------------------------+ | Table | Create Table | +------------+--------------------------------------------------------------------------------------------------------------------
------------------------------------------------------+ | subscriber | CREATE TABLE `subscriber` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL default '', `domain` varchar(64) NOT NULL default '', `password` varchar(25) NOT NULL default '', `first_name` varchar(64) NOT NULL default '', `last_name` varchar(64) NOT NULL default '', `email_address` varchar(64) NOT NULL default '', `datetime_created` datetime NOT NULL default '1900-01-01 00:00:01', `ha1` varchar(64) NOT NULL default '', `ha1b` varchar(64) NOT NULL default '', `timezone` varchar(64) default NULL, `rpid` varchar(64) default NULL, `vmail_password` varchar(40) default NULL, `vmail` tinyint(1) default '1', PRIMARY KEY (`id`), UNIQUE KEY `account_idx` (`username`,`domain`), KEY `username_idx` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 | +------------+----------------------------------------------------------------------------------------------------------------------
------------------------------------------+ 1 row in set (0.06 sec)
Daniel-Constantin Mierla wrote:
Hi Eliass,
On 07/09/08 18:04, Henning Westerholt wrote:
On Wednesday 09 July 2008, Eliass Salim wrote:
yes, but when I installed openser, I also installed webser that is what I don't understand Can you tell me which file I have to modify please.
Hi Eliass,
i misread your first mail, i thought you have _not_ installed the SERWEB stuff and not activated SERWEB=yes in openserctlrc. Do you have installed the SERWEB tables too?
paste here the output of "show create table openser.subscriber' -- it will reveal if you have needed columns.
Cheers, Daniel
yes, but how can I create them. Does serweb is very usefull?
thanks, Eliass Daniel-Constantin Mierla wrote:
Hello Eliass,
you haven't created the serweb tables - phplib_id is missing. If you use serweb 0.9.x, you need them, otherwise you can change the phplib_id with id when creating the view.
Cheers, Daniel
On 07/11/08 14:00, Eliass Salim wrote:
Hi Daniel,
Here is the result of the command.
Thanks.
mysql> show create table openser.subscriber; +------------+---------------------------------------------------------------------------------------------------------------------
------------------------------------------------+ | Table | Create Table | +------------+--------------------------------------------------------------------------------------------------------------------
------------------------------------------------------+ | subscriber | CREATE TABLE `subscriber` ( `id` int(10) unsigned NOT NULL auto_increment, `username` varchar(64) NOT NULL default '', `domain` varchar(64) NOT NULL default '', `password` varchar(25) NOT NULL default '', `first_name` varchar(64) NOT NULL default '', `last_name` varchar(64) NOT NULL default '', `email_address` varchar(64) NOT NULL default '', `datetime_created` datetime NOT NULL default '1900-01-01 00:00:01', `ha1` varchar(64) NOT NULL default '', `ha1b` varchar(64) NOT NULL default '', `timezone` varchar(64) default NULL, `rpid` varchar(64) default NULL, `vmail_password` varchar(40) default NULL, `vmail` tinyint(1) default '1', PRIMARY KEY (`id`), UNIQUE KEY `account_idx` (`username`,`domain`), KEY `username_idx` (`username`) ) ENGINE=MyISAM AUTO_INCREMENT=37 DEFAULT CHARSET=latin1 | +------------+----------------------------------------------------------------------------------------------------------------------
------------------------------------------+ 1 row in set (0.06 sec)
Daniel-Constantin Mierla wrote:
Hi Eliass,
On 07/09/08 18:04, Henning Westerholt wrote:
On Wednesday 09 July 2008, Eliass Salim wrote:
yes, but when I installed openser, I also installed webser that is what I don't understand Can you tell me which file I have to modify please.
Hi Eliass,
i misread your first mail, i thought you have _not_ installed the SERWEB stuff and not activated SERWEB=yes in openserctlrc. Do you have installed the SERWEB tables too?
paste here the output of "show create table openser.subscriber' -- it will reveal if you have needed columns.
Cheers, Daniel
On 07/11/08 16:38, Eliass Salim wrote:
yes, but how can I create them. Does serweb is very usefull?
serweb is a web interface that can be used to manage the database records. I do not know how much compatibility is with openser 1.3, but with a bit of code tweaking should work -- if you don't know about it, then probably you don't need it.
However, when you run openserdbctl to create the opener database, it asks whether to create or not the serweb tables.
Cheers, Daniel
-
Daniel-Constantin Mierla -
Eliass Salim -
Henning Westerholt