[OpenSER-Users] asterisk/openser/mysql

[Daniel-Constantin Mierla]

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
>>
>

-- 
Daniel-Constantin Mierla
http://www.asipto.com