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 >> >> >> > >
