Hi Bharath ; sory QMT is a scheme currently used. Postfix database scheme is as follows.
CREATE TABLE mailbox ( username varchar(255) NOT NULL default '', password varchar(255) NOT NULL default '', name varchar(255) NOT NULL default '', maildir varchar(255) NOT NULL default '', quota int(10) NOT NULL default '0', domain varchar(255) NOT NULL default '', created datetime NOT NULL default '0000-00-00 00:00:00', modified datetime NOT NULL default '0000-00-00 00:00:00', active tinyint(1) NOT NULL default '1', PRIMARY KEY (username), KEY username (username) ) COMMENT='Postfix Admin - Virtual Mailboxes' 2013/9/26 Bharath Chari <qmailtoas...@arachnis.com> > Are you sure this is your postfix database schema.? This looks like our > good old qmt schema. > Bharath > PS : Sorry for the top posting-using a mobile device > > > "Hasan Akgöz" <hasanak...@mail.ru> wrote: >> >> Hi Bharath ; >> >> database scheme is as follows. >> >> mysql> desc domain.com.tr; >> +-----------+-----------+------+-----+---------+-------+ >> | Field | Type | Null | Key | Default | Extra | >> +-----------+-----------+------+-----+---------+-------+ >> | pw_name | char(32) | NO | PRI | | | >> | pw_passwd | char(40) | YES | | NULL | | >> | pw_uid | int(11) | YES | | NULL | | >> | pw_gid | int(11) | YES | | NULL | | >> | pw_gecos | char(48) | YES | | NULL | | >> | pw_dir | char(160) | YES | | NULL | | >> | pw_shell | char(20) | YES | | NULL | | >> +-----------+-----------+------+-----+---------+-------+ >> >> mysql> show tables; >> +--------------------+ >> | Tables_in_vpopmail | >> +--------------------+ >> | dir_control | >> | domain.com.tr | >> | lastauth | >> | valias | >> | vlog | >> +--------------------+ >> >> >> >> 2013/9/26 Bharath Chari <qmailtoas...@arachnis.com> >> >>> Please give us the database table schema for your postfix installation >>> as well as your qmailtoaster installation. It can be done by a simple SQL >>> query. >>> >>> Bharath >>> >>> >>> On Thursday 26 September 2013 02:21 AM, Hasan Akgöz wrote: >>> >>> Hi Bharath; >>> >>> you're right. I used format for the encrypted password is crypt with a >>> salt. I get the value of a table ( pw_passwd ) in mysql with php code >>> as follows. In postfix how to use it. ? >>> >>> <?php >>> echo crypt( '12345' , '$1$QkFJ6cbB$') ; >>> ?> >>> >>> >>> 2013/9/25 Bharath Chari <qmailtoas...@arachnis.com> >>> >>>> On Wednesday 25 September 2013 09:07 PM, Peter Peltonen wrote: >>>> >>>> >>>> Hi, >>>> >>>> On Wed, Sep 25, 2013 at 6:20 PM, Hasan Akgöz <hasanak...@mail.ru>wrote: >>>> >>>>> Hi Peter; >>>>> >>>>> when I run the application vuserinfo, clear passwd line is empty. >>>>> Qmailtoaster I did not do the installation. maybe the person who >>>>> previously >>>>> may have been modified. misunderstood not clear text passwords. clear >>>>> text of the password. >>>>> >>>>> name: hasan >>>>> passwd: $1$HYuFXpYx$dYWO5IuUBzABRo.NMjR1z/ >>>>> clear passwd: >>>>> >>>>> >>>> >>>> Are you going to be using postfix with mysql for virtual domains and >>>> users. If that is the case, there is no issue. The format for the encrypted >>>> password is crypt with a salt, which is the same that is expected for the >>>> postfix/dovecot system. >>>> >>>> Can you describe your schema a little more in detail? >>>> >>>> Bharath >>>> >>>> >>>> That is indeed strange. Perhaps the other admin modified the toaster >>>> installation as you suggested or even removed the clear text password after >>>> creating the account (I am not sure if the toaster would be functional or >>>> not after this)? >>>> >>>> The toaster will be fully functional if one is not using PLAIN. >>>> I've done that before. >>>> >>>> You could test this by creating a new account and then checking >>>> again with vuserinfo if the clear password is empty? >>>> >>>> Anyway, I don't think you have now anyway to access the clear text >>>> passwords as they have been somehow removed... >>>> >>>> Regards, >>>> Peter >>>> >>>> >>>> >>> >>> >>
