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