[OpenSER-Users] asterisk/openser/mysql

[Eliass Salim]

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