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
>
_______________________________________________
Users mailing list
Users@lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
