To convert from vpasswd.cdb to mysql.
1) compile vpopmail with mysql support
2) ./vconvert -c -s
3) make install-strip
done
Rick Updegrove writes:
> From: "Kieran Barnes" <[EMAIL PROTECTED]>
> Also in reply to Ken Jones suggestion about qmail-inject
>
>> I use vpopmail with mysql. So the signup request goes straight into the
>> mysql database.
>
> ahh I have not yet converted to mysql although I wish I had started with it
> now.
>
> I am sort of looking for an "easy way" to convert the all of the vpasswd.cdb
> files to mysql. I had just recently converted all those damnable sqwebmail-pass
> files back to vpasswd.cdb and am not looking forward to the mysql conversion.
> Any suggestions?
>
>> I dont think there is a secure way of reseting/sending the user their
>> password.
>
> Hmm why not?
>
>> Although,we have a seperate table which stores other account information
>> such as a real name, ftp password, address, phone number and such like for
>> accounting purposes. We have a "Memorable name" field too which the user
>> must fill in upon signup, we ask for it every time they call our tech.
>> support
>>
>> I guess this is the idea in the vqregister database, but a more stripped
>> down version with the "Memorable name" field being their email address.
>> Maybe it could be altered to be a memorable name or a pin number or
>> something like that - a la hotmail.
>>
>> Having their email password sent to another account seems strange to me,
>> kinda useless - what if the user only uses the account on your server - they
>> are screwed, no?
>
> yes currently thery are screwed : )
>
>> Just out of interest, do you have a significant number of users that have
>> signed up with vqregister?
>
> Well, I give them away for free still and some of the people have used vqsignup
> and the rest used vqregister. I think I am over 100 users because vpopmail
> started with its seemingly arbitrary "0" directory creations.
>
> I modified this line - this was all one line
>
> from
>
> eret = execl("/var/qmail/bin/qmail-remote", "/var/qmail/bin/qmail-remote", p,
> "[EMAIL PROTECTED]", cemail, NULL);
>
> to
>
> eret = execl("/var/qmail/bin/qmail-inject", "/var/qmail/bin/qmail-inject", p,
> "[EMAIL PROTECTED]", cemail, NULL);
>
>
> And although I got a different error, it failed to create the account YET it
> sent me a confirmation error, with a password!
>
> Oh yeah whats the [EMAIL PROTECTED] for/from? The ad?
>
>
>
> Rick Up
>