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" <[email protected]> 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 <[email protected]> > >> 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 <[email protected]> >> >>> On Wednesday 25 September 2013 09:07 PM, Peter Peltonen wrote: >>> >>> >>> Hi, >>> >>> On Wed, Sep 25, 2013 at 6:20 PM, Hasan Akgöz <[email protected]> >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 >>> >>> >>> >> >>
