[OpenSER-Users] asterisk/openser/mysql

[Eliass Salim]

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
>