[vchkpw] vconvert and mysql
I have recently converted a mailserver running a shupp toaster to mysql from cbd. I ran vconvert -c -m and all the popboxes were entered into the mysql database, but none of the aliases (.qmail-xxx) were converted and none of them show up in qmailadmin. They still accept and forward mail though and if I create a new forward in qmailadmin it appears in vpopmail.valias and works OK Is there a way to convert the existing .qmail files to mysql? Any pointers would be much appreciated. Thanks. -- - Bob Hutchinson Midwales dot com - !DSPAM:49e47f3432681344819242!
[vchkpw] vconvert problem
Hello all; I am trying to move from a qmailrocks server to a newer qmailtoaster-iso server but I am having problems moving the domains over to the qmailtoaster machine. I have the two machines running, qmailrocks is the production machine, qmailtoaster is the new machine. I would like to make sure that the conversion will go smoothly so I am doing a dry run of moving the domains over and seeing if they will import. I have used rsync to copy the /home/vpopmail/domains directory over to the qmailtoaster. Once this is complete the owner of the domain directories and files is the user ID number and group ID number from the original qmailrocks machine. Then I change the ownership of this directory tree to vpopmail:vchkpw. I then have run vconvert -c -m to convert all of the domains, but it explicitly says it fails. Then I have copied the /var/qmail/control/cdb and assign files over to the qmailtoaster machine and run the same vconvert -c -m command and it explicitly says the the domains converted successfully. This I am very happy about. Now, however I am not able to log into any of the accounts that have converted. Not even the postmaster account. I have noticed that if I use an incorrect password with a valid account I get an incorrect username or password error. If I use a valid password I get dropped from a Squirrelmail login or a pop3 telnet session. When I look at the imap4 log I see a "permission denied" error. I have been wrestling with this for weeks now and the boss is getting impatient. Any help would be greatly appreciated. Ray Webster !DSPAM:4734be0d32001037962888!
[vchkpw] What does vconvert assume about /etc/password source domains?
What does 'vconvert' assume about /etc/password source domains? Where does it expect the users' files? Can it work against NFS-stored Maildirs?
[vchkpw] What's the state of vconvert?
Can someone comment on the state of vconvert please? Available documentation is a bit sparse (sorry that's not supposed to hurt feelings) # ./vconvert -v version: 5.4.17 vconvert: usage The first option sets which format to convert FROM, the second option sets which format to convert TO. -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info Q: Is there a "test" mode to see what vconvert thinks it would do? Q: What do I do if the migration is between servers, and from /etc/passwd to mysql/vpopmail? I don't think I can figure out how to convince it to straddle two servers to go straight to mysql on the source server. Do I need to output from source (/etc/passwd) to CDB, then move the CDB to target and migrate CDB to mysql? Q: What does -d really do? Q: Ken's documentation infers that individual domains can be selected under certain circumstances? Not for /etc/password or is it possible? Thanks! Dave.
[vchkpw] Bug in vpopmail 5.4.5 (vconvert)?
I've a server with qmail 1.03 and vpopmail 5.4.5 using mysql authentication, well i'm migrating from another server with vpopmail 5.4.4 using cdb authentication. When i add domains about 300 domains in a new server create /home/vpopmail/domains/domains.com after 100 domains create /home/vpopmail/domains/0/anotherdomains.com and using vconvert from cdb to mysql, the domains out from /home/vpopmail/domains in mysql are deleted and the migration is failed. How i can remove or edit the hash from domains dir (not user dir)? PS. I compiled vpopmail 5.4.4 and deleted all and insert agains but the hash domain dir persist. Thanks Marcos
Re: [vchkpw] vconvert deletes qmailadmin-limits?
Fwiw.. I did the reverse dumped my mysql stuff to cdb before the upgrade just in case.. and it did the same thing too after the upgrade.. removed all the .qmailadmin-limits.. I assumed it was somethng that I must have not read in the docs and didn't submit a bug report. - Brian Jeff Koch wrote: Hi: We transferred 600 domains and about 5000 mail accounts from a server using vpopmail with cdb to a new server using the latest 5.4.0 built with mysql for auth but no mysql aliases or limits. After untarring the domains.tgz file and copying over the /qmail/control and /qmail/assign files we ran 'vconvert -c -m' and after the conversion we found vconvert had deleted all of the '.qmailadmin-limits' files. Is this a known bug or did we do something stupid? Our configure directives were: ./configure --enable-logging=v --enable-clear-passwd --enable-auth-module=mysql --disable-mysql-limits --enable-mysql-logging Best Regards, Jeff Koch
Re: [vchkpw] vconvert deletes qmailadmin-limits?
On Feb 17, 2004, at 11:18 AM, Jeff Koch wrote: After untarring the domains.tgz file and copying over the /qmail/control and /qmail/assign files we ran 'vconvert -c -m' and after the conversion we found vconvert had deleted all of the '.qmailadmin-limits' files. Is this a known bug or did we do something stupid? It's a known bug now. I just added it to SourceForge. When converting to MySQL, vconvert will delete the .qmailadmin-limits file. I'll try to get a fix in soon. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter handheld Network Tester: http://sniffter.com/
Re: [vchkpw] vconvert deletes qmailadmin-limits?
Hi Tom: The only tables we see are: mysql> show tables; ++ | Tables_in_vpopmail | ++ | dir_control| | lastauth | | vlog | | vpopmail | ++ 4 rows in set (0.00 sec) Any ideas? At 03:00 PM 2/17/2004, you wrote: On Feb 17, 2004, at 11:18 AM, Jeff Koch wrote: After untarring the domains.tgz file and copying over the /qmail/control and /qmail/assign files we ran 'vconvert -c -m' and after the conversion we found vconvert had deleted all of the '.qmailadmin-limits' files. Is this a known bug or did we do something stupid? Did it move the limits into MySQL? -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter handheld Network Tester: http://sniffter.com/ Best Regards, Jeff Koch, Intersessions
Re: [vchkpw] vconvert deletes qmailadmin-limits?
On Feb 17, 2004, at 11:18 AM, Jeff Koch wrote: After untarring the domains.tgz file and copying over the /qmail/control and /qmail/assign files we ran 'vconvert -c -m' and after the conversion we found vconvert had deleted all of the '.qmailadmin-limits' files. Is this a known bug or did we do something stupid? Did it move the limits into MySQL? -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ Info on the Sniffter handheld Network Tester: http://sniffter.com/
[vchkpw] vconvert deletes qmailadmin-limits?
Hi: We transferred 600 domains and about 5000 mail accounts from a server using vpopmail with cdb to a new server using the latest 5.4.0 built with mysql for auth but no mysql aliases or limits. After untarring the domains.tgz file and copying over the /qmail/control and /qmail/assign files we ran 'vconvert -c -m' and after the conversion we found vconvert had deleted all of the '.qmailadmin-limits' files. Is this a known bug or did we do something stupid? Our configure directives were: ./configure --enable-logging=v --enable-clear-passwd --enable-auth-module=mysql --disable-mysql-limits --enable-mysql-logging Best Regards, Jeff Koch
[vchkpw] Vconvert problem in 5.4.0 - help
Does anyone know if there is a problem in the vconvert program converting from cdb to mysql in vpopmail 5.4.0? After running vconvert across all domains here is the contents of the mysql vpopmail table: | pw_name| pw_domain | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir| pw_shell| pw_clear_passwd | ++---+++++---+-+-+ | spam | emm15.org | $1$Squ80GTv$x/0r6Qqm51cxi0r3RborU1 | 1 | 0 | spam | /home/vpopmail/domains/5/emm15.org/spam | 20485760S,1000C | xxx | | postmaster | emm15.org | $1$ag6IlD6H$/USpGUDz5jaAOq7Mc72rH/ | 1 | 0 | Postmaster | /home/vpopmail/domains/5/emm15.org/postmaster | 20485760S,1000C | bxer| ++---+++++---+-+-+ But yet when I run 'vdominfo emm15.org' I get: orion:/home/vpopmail/bin# ./vdominfo emm15.org domain: emm15.org uid:89 gid:89 dir:/home/vpopmail/domains/5/emm15.org users: 0 It show 0 users when the mysql table shows 2 users. (I'm depressed.) Best Regards, Jeff Koch
Re: [vchkpw] vconvert
All set properly.. Still conversion failed.. :( > Original Message > From: Cristiano Deana <[EMAIL PROTECTED]> > To: "Duane Stark" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] > Date: Tue, Nov-4-2003 7:24 AM > Subject: Re: [vchkpw] vconvert > > Il giorno Saturday 01 November 2003 06:34, Duane Stark mi scriveva: > > > It's almost like vconvert cant get access to the mysql database. What > > connection info is it using? > > Did you properly set your mysql user/permission in according with > # cat ~vpopmail/etc/vpopmail.mysql > localhost|0|vpopmail|mysecurepasswd|vpopmail > localhost|0|vpopmail|mysecurepasswd|vpopmail > > P.S. > # pkg_info | grep vpopmail > vpopmail-5.3.28 Easy virtual domain and authentication package for use > with > > vconvert ok here. > > > > >
Re: [vchkpw] vconvert
Il giorno Saturday 01 November 2003 06:34, Duane Stark mi scriveva: > It's almost like vconvert cant get access to the mysql database. What > connection info is it using? Did you properly set your mysql user/permission in according with # cat ~vpopmail/etc/vpopmail.mysql localhost|0|vpopmail|mysecurepasswd|vpopmail localhost|0|vpopmail|mysecurepasswd|vpopmail P.S. # pkg_info | grep vpopmail vpopmail-5.3.28 Easy virtual domain and authentication package for use with vconvert ok here.
Fw: Re: [vchkpw] vconvert
Any ideas re: this problem? I'm in bad need of some help!! Thanks, Duane > Original Message > From: "Duane Stark" <[EMAIL PROTECTED]> > To: [EMAIL PROTECTED] > Date: Fri, Oct-31-2003 11:34 PM > Subject: Re: [vchkpw] vconvert > > According to pkg_info, vpopmail-5.3.28. > > It's almost like vconvert cant get access to the mysql database. What connection > info is it using? Since the documentation on vconvert appears to be scarce, I can't > confirm that it's not a breakage in the vconver > mysql link. > > Thanks, > Duane > > > Original Message > > From: "Michael Bowe" <[EMAIL PROTECTED]> > > To: <[EMAIL PROTECTED]> > > Date: Fri, Oct-31-2003 10:43 PM > > Subject: Re: [vchkpw] vconvert > > > > > > > After that, I ran vconvert -c -m and recieved the following error: > > > > > > converting demodomain.com ...domain conversion failed > > > > > > Any ideas? > > > > > > > What version of vpopmail do you have? > > > > I saw you posted previously that you had the "latest", but can you quote the > > actual version number please because it is common enough for people to think > > they have the very latest when they actually havent :-) > > > > Michael. > > > > > > > > >
Re: [vchkpw] vconvert
According to pkg_info, vpopmail-5.3.28. It's almost like vconvert cant get access to the mysql database. What connection info is it using? Since the documentation on vconvert appears to be scarce, I can't confirm that it's not a breakage in the vconver > mysql link. Thanks, Duane > Original Message > From: "Michael Bowe" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Date: Fri, Oct-31-2003 10:43 PM > Subject: Re: [vchkpw] vconvert > > > > After that, I ran vconvert -c -m and recieved the following error: > > > > converting demodomain.com ...domain conversion failed > > > > Any ideas? > > > > What version of vpopmail do you have? > > I saw you posted previously that you had the "latest", but can you quote the > actual version number please because it is common enough for people to think > they have the very latest when they actually havent :-) > > Michael. > > > >
Re: [vchkpw] vconvert
> After that, I ran vconvert -c -m and recieved the following error: > > converting demodomain.com ...domain conversion failed > > Any ideas? > What version of vpopmail do you have? I saw you posted previously that you had the "latest", but can you quote the actual version number please because it is common enough for people to think they have the very latest when they actually havent :-) Michael.
[vchkpw] vconvert
After following some help recieved through the mailing list, this is what I've dont in my effort to move email accounts from one machine, to a new machine (changing the auth type to mysql) I copied the domains/ folder, the qmail/control folder and the qmail/users/assign file (changning the uid and gid.. then I ran qmail-newu) After that, I ran vconvert -c -m and recieved the following error: converting demodomain.com ...domain conversion failed Any ideas? Thanks, Duane
Re: [vchkpw] Vconvert failure
Thanks Michael and X-istence, I thought that the lastest was 5.2.1 since this was the lastest reported on inter7.com website. I've tried 5.2.2 and vconvert works like a charm... Thanks! Paolo Michael Bowe wrote: Hi all, I'm trying to convert a 5.2 cdb installation to a 5.2.1 mysql installation. I've tried to use vconvert tools but it fails. I think that vconvert is badly out of date. Do you have any suggestions (over fixing the code :-) )? vpopmail-5.2.2 contains a much newer version of the vconvert utility. vpopmail-5.2.2 is now the recommended "stable" version to be using (not vpopmail-5.2.1). The 5.2.2 build includes a number of important bug fixes. You can get vpopmail-5.2.2 from http://sourceforge.net/projects/vpopmail Michael.
Re: [vchkpw] Vconvert failure
> Hi all, > I'm trying to convert a 5.2 cdb installation to a 5.2.1 mysql installation. > I've tried to use vconvert tools but it fails. > I think that vconvert is badly out of date. > Do you have any suggestions (over fixing the code :-) )? vpopmail-5.2.2 contains a much newer version of the vconvert utility. vpopmail-5.2.2 is now the recommended "stable" version to be using (not vpopmail-5.2.1). The 5.2.2 build includes a number of important bug fixes. You can get vpopmail-5.2.2 from http://sourceforge.net/projects/vpopmail Michael.
[vchkpw] Vconvert failure
Hi all, I'm trying to convert a 5.2 cdb installation to a 5.2.1 mysql installation. I've tried to use vconvert tools but it fails. [root mail] ~/vpopmail-5.2.1# ./vconvert -c -m foo.it converting foo.it domain deleted domain created opening /usr/local/vpopmail/domains/foo.it/vpasswd domain conversion failed NOTE: I've added some debugging printf's. It basically fails to open vpasswd file because that file doesn't exist! The file is in: /usr/local/vpopmail/domains/1/foo.it/vpasswd I've seen that the do_all_domains scan the domains directory but doesn't analyze all the tree (domains/1 dir for example). I think that vconvert is badly out of date. Do you have any suggestions (over fixing the code :-) )? Ciao! Paolo
[vchkpw] vconvert cleartext support (patch included)
Today while mingling with Brian's users we realized that vconvert doesnt
convert the cleartext passwords from mysql to cdb...
So I attached a patch which adds cleartext support to vconvert
This patch is made from 5.3.24 version
Evren
--- vconvert.c.orig Fri Aug 8 17:19:21 2003
+++ vconvert.c Fri Aug 8 17:22:44 2003
@@ -256,6 +256,17 @@
}
pw = vauth_getall(domain, 1, 0);
while( pw != NULL ) {
+#ifdef CLEAR_PASS
+ fprintf(fs, "%s:%s:%d:%d:%s:%s:%s:%s\n",
+ pw->pw_name,
+ pw->pw_passwd,
+ pw->pw_uid,
+ pw->pw_gid,
+ pw->pw_gecos,
+ pw->pw_dir,
+ pw->pw_shell,
+ pw->pw_clear_passwd);
+#else
fprintf(fs, "%s:%s:%d:%d:%s:%s:%s\n",
pw->pw_name,
pw->pw_passwd,
@@ -264,6 +275,7 @@
pw->pw_gecos,
pw->pw_dir,
pw->pw_shell);
+#endif
pw = vauth_getall(domain, 0, 0);
}
fclose(fs);
[vchkpw] vconvert woes...
Yep, it doesn't end
So, I have the legacy data all brought over.
Made sure I have /var/qmail/users/*, and /var/qmail/control/*
Of course, also brought up all the /home/vpopmail/domains/*
Now, when running vconvert -c -m
I get a bunch of domains that claim to have converted, and a bunch of
domains that haven't converted (even though they claim '...done!'), and a
bunch of domains that won't convert as they claim to have an error ('you
have an error in your sql syntax At line 2').
When looking at the domains that did not carry over with phpmyadmin, the
'bad' ones show up as 1.0k in size, and nothing to browse.
But even those that claim to be 'good' don't have all users in the schema,
and are obviously missing some essential datas (when checking them out with
qmail-toaster, or qmailadmin (qmailadmin will simply refuse to login with a
'file permissions error /path/to/domain/postmaster/Maildir/1059630555.qw')
I did make sure that all files have the vpopmail:vchkpw ownerships, and same
permissions as on the prior server.
Any ideas...?
Harry
Re: [vchkpw] Vconvert / converting / migrating woes....
Hi, Harry Zink wrote: Alright, thanks for the tips on vconvert - I have, in the meantime, found out that it is one of the worst documented utilities. Heck, not even inter7 has a decent man page for it. I think that vconvert -c -m domain.name will do the trick, though (or just vconvert -c -m for all domains). That's where the present 'rub' is, though. The scenario: - I have the new server, set up with qmail-toaster, and vpopmail 5.38, qmailadmin 1.06. All configured for mysql. - I have data from the legacy server, with standard cdb files in the vpopmail configuration without mysql. So, while obviously I can just drop over the content of /home/vpopmail/domains into the new location, that doesn't really convince qmail to see any of those domains, and consequently vconvert doesn't see them either. So: - what else, besides dropping the content of /domains/ in place, do I need to do / copy over from the prior installation in order for the domains to be recognized by qmail, qmailadmin, and hence vconvert? You also need /var/qmail/control/* and /var/qmail/users/* And make sure the uid and gid in the /var/qmail/users/assign file matches the uid and gid for vpopmail and vchkpw on the new server. Regards, Rick
[vchkpw] Vconvert / converting / migrating woes....
Alright, thanks for the tips on vconvert - I have, in the meantime, found out that it is one of the worst documented utilities. Heck, not even inter7 has a decent man page for it. I think that vconvert -c -m domain.name will do the trick, though (or just vconvert -c -m for all domains). That's where the present 'rub' is, though. The scenario: - I have the new server, set up with qmail-toaster, and vpopmail 5.38, qmailadmin 1.06. All configured for mysql. - I have data from the legacy server, with standard cdb files in the vpopmail configuration without mysql. So, while obviously I can just drop over the content of /home/vpopmail/domains into the new location, that doesn't really convince qmail to see any of those domains, and consequently vconvert doesn't see them either. So: - what else, besides dropping the content of /domains/ in place, do I need to do / copy over from the prior installation in order for the domains to be recognized by qmail, qmailadmin, and hence vconvert? Thanks, Harry
[vchkpw] vconvert doesn't work
Hi, I have installed Vpopmail 5.2.1 with mysql support. Now I have copied the domains with vpasswd files from a vpopamil 4.9.1 installation. After that I do a ./vconvert -c -m domain.tld vconvert answers: converting domain.tld done But in the MySQL table vpopmail aren't any entry's. The table is empty! I have done a strace and at the last lines, vconvert reads the vpasswd file, but don't write the data to mysql But there aren't any error messages What do I'm wrong?? please help me Greetings Jan sorry, for my bad english
[vchkpw] Bug in vconvert?
Hi all!
I've just migrated from vpopmail 5.2.1 using CDB to vpopmail 5.3.20
using MySql. During this migration I discovered a small bug in vconvert.
When running 'vconvert -c -m', vconvert reads the
/var/qmail/users/assign file, which on my system ends with a line
containing a ".\n" When vconvert reaches this line, the check for
tmpbuf[1] != '\n' in line 120 fails, but this does not stop the next
line (conv_domain( &tmpbuf[1] )) from being executed. Of course this
does not work - it tries to convert a domain called "\n". My fix is the
following code:
if ( tmpbuf[1] != '\n' ) {
printf("converting %s ...", &tmpbuf[1] );
if ( conv_domain( &tmpbuf[1] ) != 0 ) {
printf("domain conversion failed\n");
} else {
printf("done\n");
}
}
Is there a problem with this fix?
Kind regards
Jonas Thomsen,
JT-COM
Eugen Warmings Vej 37, 1. th. - DK-8000 Aarhus C.
Tlf. +45 87 30 16 10 - Fax: +45 87 30 16 11
http://www.jt-com.dk
Re: [vchkpw] Bug in vconvert?
Looks fine to me :0
-- Remo Mattei --cell 801-209-8554
http://www.italy1.com
Freelance Networking-Security/Consultant
MCSE, MCP, MCP+I, MCT
Linux Trainer & Firewall Development
[EMAIL PROTECTED]
> From: "Jonas Thomsen" <[EMAIL PROTECTED]>
> Organization: JT-COM
> Date: Sun, 8 Jun 2003 18:16:17 +0200
> To: <[EMAIL PROTECTED]>
> Subject: [vchkpw] Bug in vconvert?
>
> Hi all!
>
> I've just migrated from vpopmail 5.2.1 using CDB to vpopmail 5.3.20
> using MySql. During this migration I discovered a small bug in vconvert.
> When running 'vconvert -c -m', vconvert reads the
> /var/qmail/users/assign file, which on my system ends with a line
> containing a ".\n" When vconvert reaches this line, the check for
> tmpbuf[1] != '\n' in line 120 fails, but this does not stop the next
> line (conv_domain( &tmpbuf[1] )) from being executed. Of course this
> does not work - it tries to convert a domain called "\n". My fix is the
> following code:
>
> if ( tmpbuf[1] != '\n' ) {
> printf("converting %s ...", &tmpbuf[1] );
> if ( conv_domain( &tmpbuf[1] ) != 0 ) {
> printf("domain conversion failed\n");
> } else {
> printf("done\n");
> }
> }
>
> Is there a problem with this fix?
>
>
>
> Kind regards
>
> Jonas Thomsen,
> JT-COM
> Eugen Warmings Vej 37, 1. th. - DK-8000 Aarhus C.
> Tlf. +45 87 30 16 10 - Fax: +45 87 30 16 11
> http://www.jt-com.dk
>
>
>
>
Re: [vchkpw] problem iwth vconvert to sql
Please apply the following patch to vconvert:
diff -u vpopmail-5.3.20/vconvert.c vpopmail-5.3.20-tc/vconvert.c
--- vpopmail-5.3.20/vconvert.c 2003-03-24 13:54:37.0 -0700
+++ vpopmail-5.3.20-tc/vconvert.c 2003-06-04 14:32:54.0
-0700
@@ -312,8 +312,8 @@
void usage()
{
fprintf(stdout, "vconvert: usage\n");
- fprintf(stdout, " The first option sets which format to convert
FROM");
- fprintf(stdout, " the second option sets which format to
convert TO");
+ fprintf(stdout, " The first option sets which format to convert
FROM,\n");
+ fprintf(stdout, " the second option sets which format to
convert TO.\n");
fprintf(stdout, " -e = etc format\n");
fprintf(stdout, " -c = cdb format\n");
fprintf(stdout, " -m = sql format\n");
On Wednesday, June 4, 2003, at 12:41 PM, Ken Jones wrote:
I'm not writing any new code.
I'm only applying code changes that people send me.
Ken
On Wednesday 04 June 2003 2:16 pm, Rick Macdougall wrote:
Hi,
Would you not want -c -m ? I do not see -s as an option anywhere.
Oh, Ken, as long as you are patching today, maybe you could add a line
feed to the help message so the -e = etc format starts on a new line
:)
Regards,
Rick
Eduardo Garcia wrote:
Hello people.
i was a new installation of qmail+vpopmail+mysql in a new server,
the
instalation that's ok.
but, i need migrate my accounts email to my new server, the old qmail
have authentiation with cdb files, and i need migrate to auth with
mysql.
i try use de vconvert utility, i read de README.msysql, but the
instruccion.
#vconvert -c -s
don't work and display the next message.
[EMAIL PROTECTED] ti0.net]# vconvert -c -s
vconvert: invalid option -- s
vconvert: usage
The first option sets which format to convert FROM the second option
sets which format to convert TO -e = etc format
-c = cdb format
-m = sql format
-S = set sqwebmail passwords
-v = version
-d = debug info
[EMAIL PROTECTED] ti0.net]#
some idea.
plase help me, i have 20 domains.
sorry but my english it's very bad, i don't speak.
thanks.
enzo
Eduardo Garcia.
--
Tom Collins
[EMAIL PROTECTED]
Re: [vchkpw] problem iwth vconvert to sql
I'm not writing any new code. I'm only applying code changes that people send me. Ken On Wednesday 04 June 2003 2:16 pm, Rick Macdougall wrote: > Hi, > > Would you not want -c -m ? I do not see -s as an option anywhere. > > Oh, Ken, as long as you are patching today, maybe you could add a line > feed to the help message so the -e = etc format starts on a new line :) > > Regards, > > Rick > > Eduardo Garcia wrote: > > Hello people. > > > > i was a new installation of qmail+vpopmail+mysql in a new server, the > > instalation that's ok. > > > > but, i need migrate my accounts email to my new server, the old qmail > > have authentiation with cdb files, and i need migrate to auth with mysql. > > > > i try use de vconvert utility, i read de README.msysql, but the > > instruccion. > > > > #vconvert -c -s > > > > don't work and display the next message. > > > > [EMAIL PROTECTED] ti0.net]# vconvert -c -s > > vconvert: invalid option -- s > > vconvert: usage > > The first option sets which format to convert FROM the second option > > sets which format to convert TO -e = etc format > > -c = cdb format > > -m = sql format > > -S = set sqwebmail passwords > > -v = version > > -d = debug info > > [EMAIL PROTECTED] ti0.net]# > > > > some idea. > > > > plase help me, i have 20 domains. > > > > > > sorry but my english it's very bad, i don't speak. > > > > > > thanks. > > > > enzo > > Eduardo Garcia.
Re: [vchkpw] problem iwth vconvert to sql
Hi, Would you not want -c -m ? I do not see -s as an option anywhere. Oh, Ken, as long as you are patching today, maybe you could add a line feed to the help message so the -e = etc format starts on a new line :) Regards, Rick Eduardo Garcia wrote: Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
[vchkpw] problem iwth vconvert to sql
Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
[vchkpw] problem with vconvert to sql
Hello people. i was a new installation of qmail+vpopmail+mysql in a new server, the instalation that's ok. but, i need migrate my accounts email to my new server, the old qmail have authentiation with cdb files, and i need migrate to auth with mysql. i try use de vconvert utility, i read de README.msysql, but the instruccion. #vconvert -c -s don't work and display the next message. [EMAIL PROTECTED] ti0.net]# vconvert -c -s vconvert: invalid option -- s vconvert: usage The first option sets which format to convert FROM the second option sets which format to convert TO -e = etc format -c = cdb format -m = sql format -S = set sqwebmail passwords -v = version -d = debug info [EMAIL PROTECTED] ti0.net]# some idea. plase help me, i have 20 domains. sorry but my english it's very bad, i don't speak. thanks. enzo Eduardo Garcia.
[vchkpw] vconvert broken
Hello, I'm trying to use vconvert to convert my existing CDB installation to MySQL (mostly because I want a nice breakdown of what's actually there ;-) but it won't work. vconvert will create the vpopmail table in the vpopmail DB but doesn't add a single line, no matter whether I leave it running for the whole domain. vpopmail is compiled with ./configure --enable-mysql=y --enable-valias=y and the DB permissions obviously are right, else vconvert wouldn't create the table. Has anyone else tried to use it recently?
Re: [vchkpw] vconvert
> Hello, all. > > I am successfully running a qmail, Courier-IMAP, vpopmail(v 5.3.19), MySql > (compiled with --enable-many-domains=y), and squirrelmail installation. I > want to use vconvert to convert a shadow password file into a MySql DB. > The docs on this procedure are a little skimpy so I hope someone will > confirm a couple of things for me. First, does it work, and can I be > secure that I won't hose my current DB? Second, what is the exact syntax > to convert all the users in the shadow password file into the DB with the > proper x.com extention? > > Thanks for the help, all. > > > -- > Regards, > > Kenneth D. Johnson Your shadow file won't contain the domain information will it? I had this same scenario when converting from a sendmail install to qmail/vpopmail/mysql. I didn't use vconvert or http://www.enderunix.org/vpwd2sql/. I have a three step process that worked very well for me if : a - you have a list of domains. b - you know what users belong to what domain. I can detail it off-list if you're interested. Jason
[vchkpw] vconvert
Hello, all. I am successfully running a qmail, Courier-IMAP, vpopmail(v 5.3.19), MySql (compiled with --enable-many-domains=y), and squirrelmail installation. I want to use vconvert to convert a shadow password file into a MySql DB. The docs on this procedure are a little skimpy so I hope someone will confirm a couple of things for me. First, does it work, and can I be secure that I won't hose my current DB? Second, what is the exact syntax to convert all the users in the shadow password file into the DB with the proper x.com extention? Thanks for the help, all. -- Regards, Kenneth D. Johnson Email services provided by KYOnline.net, A division of World View Resources, Inc. http://www.kyonline.net/
[vchkpw] vconvert - cdb to MySQL problem
Hello everyone,I'm trying to convert several virtual domains using cdb (mostly encrypted passwords) into MySQL as I'm moving all domains to a new mail server using MySQL authentication. I use vpopmail 5.2.1. vpopmail is configured to use the database "vpopmail" and user "vpopmail" in the vmysql.h configuration file.The problem is that when I run "vconvert -c -m yourplana.com" nothing really happens with the vpopmail database. Everything seems to be ok and vconvert returns "converting yourplana.com done".But, there's no additional table(s) added in the database "vpopmail":mysql> show tables;++| Tables_in_vpopmail |++| vpopmail |++And there's nothing in the vpopmail table:mysql> select * from vpopmail;Empty set (0.00 sec)If I add a domain using ./vadddomain yourplana222.com the postmaster user is created in the vpopmail table and it also creates two new tables called "dir_control" and "lastauth". I have tried to run vconvert for yourplana.com again, but that doesn't help either.I have tried to run ./vconvert -c -m without specifying a domain name. Vconvert then runs through the entire list of domains in /home/vpopmail/domains and actually deletes the yourplana222.com domain I created a few minutes ago(!) The vpopmail table is now empty again. (At least this rules out any database connection problems.)Doesn't vconvert support encrypted passwords in the vpasswd.cdb file, or are something wrong with my intallation?I have configured vpopmail with the following options:--enable-mysql-logging=y--enable-logging=y--enable-auth-logging=y--enable-roaming-users=y--enable-mysql=yAny suggestions are very much appreciated.Thanks,--Erik
[vchkpw] Vconvert problem
Hi all. I'm testing a migration from cdb to mysql on vpopmail, but I encounter a problem. If I run "vconvert -c -m", it reports success but my vpopmail table in vpopmail db is clear. I also try to create a new account to test if it was a permission problem, but all works well: the new account was inserted in vpopmail table. Then, if I rerun "vconvert -c -m", I find that my vpopmail table is cleared again, loosing also my new account definitions. Vpopmail version 5.3.12 Any ideas?? Thanks in advance Ciao Gianni
[vchkpw] vconvert -c -m hashing problem, revisited
Heya, Searched through the archives and saw a few people have already brought this up, but I was wondering if/when this was going to be fixed? I did my cdb->mysql conversion last night and ran into this.. I ended up just copying those directories(since all the domains in the numbered subdirectories were quite small) to ~vpopmail/domains/ and then running vconvert, and I'll probably end up deleting the directories that i copied to ~vpopmail/domains/ since their numbered directory is still in the assigns, vpopmail db, etc.. Has anyone else who has noticed this had any problems afterwards with account management (adding/removing users or domains), or is the problem only in the vconvert utility? Any information is appreciated, thanks in advance :) - Andre Fortin, CCNA Systems Administrator Technician Persona Communications, Northern Division 500 Barrydowne Rd. Sudbury, Ontario [EMAIL PROTECTED] Tel.: (705)560-1560 ext. 266
Fw: [vchkpw] vconvert
Looks like it ! Thanks, Stephen D. - Original Message - From: "Jason S" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 3:58 PM Subject: Re: [vchkpw] vconvert > Is this it: > http://www.enderunix.org/vpwd2sql > > > > Hello, > > > > if such a tool does not exist, > > I would like to code it. > > > > Bye, > > Werner. > > > > > > > > > > >
Fw: [vchkpw] vconvert
Thanks for all the reply, I don't think it will be much of a problem importing the accounts into the database and creating the vpopmail accounts but I don't know how to import the encrypted passwords. Guess I could set them and have the owners of the accounts change them. Thanks Again, Stephen D. - Original Message - From: "Bill Shupp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 12:45 PM Subject: Re: [vchkpw] vconvert On Monday, November 4, 2002, at 11:38 AM, Stephen Spicer wrote: > > Has anyone had a problem with the vconvert utility. > > When trying to convert entry's from my /etc/passwd file to > a MySql database only two of the entry's get parsed, all other > are ignored. Now errors are reported. > > Their are over 1000 entry's in the passwd file, excluding the system > accounts. > > I am doing a: vconvert -e -m Possible that I'm using it incorrectly ? I didn't think vconvert supported /etc/passwd users, just going from cdb to sql, etc. I'd have to look at the source, though. Bill
Re: [vchkpw] vconvert
Is this it: http://www.enderunix.org/vpwd2sql > Hello, > > if such a tool does not exist, > I would like to code it. > > Bye, > Werner. > > > >
RE: [vchkpw] vconvert
Hello, if such a tool does not exist, I would like to code it. Bye, Werner.
Re: [vchkpw] vconvert
Hi, It does support /etc/passwd to cdb, that is for sure. I use it all the time to convert old sendmail installations to qmail. Bit of a drag having to replace the passwd file though, I wish it could read from another file in passwd format. >From reading through the source it appears to use built in functions, limiting you to the real /etc/passwd file. I know this doesn't help with your MySQL import, but it does work passwd -> cdb. Regards, Rick - Original Message - From: "Bill Shupp" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, November 04, 2002 2:45 PM Subject: Re: [vchkpw] vconvert On Monday, November 4, 2002, at 11:38 AM, Stephen Spicer wrote: > > Has anyone had a problem with the vconvert utility. > > When trying to convert entry's from my /etc/passwd file to > a MySql database only two of the entry's get parsed, all other > are ignored. Now errors are reported. > > Their are over 1000 entry's in the passwd file, excluding the system > accounts. > > I am doing a: vconvert -e -m Possible that I'm using it incorrectly ? I didn't think vconvert supported /etc/passwd users, just going from cdb to sql, etc. I'd have to look at the source, though. Bill
Re: [vchkpw] vconvert
On Monday, November 4, 2002, at 11:38 AM, Stephen Spicer wrote: Has anyone had a problem with the vconvert utility. When trying to convert entry's from my /etc/passwd file to a MySql database only two of the entry's get parsed, all other are ignored. Now errors are reported. Their are over 1000 entry's in the passwd file, excluding the system accounts. I am doing a: vconvert -e -m Possible that I'm using it incorrectly ? I didn't think vconvert supported /etc/passwd users, just going from cdb to sql, etc. I'd have to look at the source, though. Bill
[vchkpw] vconvert
Has anyone had a problem with the vconvert utility. When trying to convert entry's from my /etc/passwd file to a MySql database only two of the entry's get parsed, all other are ignored. Now errors are reported. Their are over 1000 entry's in the passwd file, excluding the system accounts. I am doing a: vconvert -e -m Possible that I'm using it incorrectly ? Thanks, Stephen D. Spicer
Re: [vchkpw] vconvert problem - ignoring one user
The "-" in the domain name should not matter.
I would suggest running vconvert in gdb and walk through the
how it processes that one domain. Then you can see what is
going on.
Hope that helps
Ken Jones
On Sunday 13 October 2002 10:42 pm, Jesse Reynolds wrote:
> Hi
>
> I'm having a problem running vconvert -c -m to convert our
> installation from CDB files to MySQL. Out of 243 users accross 61
> domain names only one user is not imported. The domain name has a
> hyphin in it ("-") - would this cause the problem perhaps? There is
> only one user in this domain. The domain got imported, just not the
> user.
>
> We are running on the new server (MySQL):
>
> vpopmail 5.3.8
> mysql 3.23.49
> freebsd 4.6.2
>
> On the old server (CDB):
>
> vpopmail 5.2.1
> freebsd 4.2
>
> Thankyou
>
> Jesse
[vchkpw] vconvert problem - ignoring one user
Hi
I'm having a problem running vconvert -c -m to convert our
installation from CDB files to MySQL. Out of 243 users accross 61
domain names only one user is not imported. The domain name has a
hyphin in it ("-") - would this cause the problem perhaps? There is
only one user in this domain. The domain got imported, just not the
user.
We are running on the new server (MySQL):
vpopmail 5.3.8
mysql 3.23.49
freebsd 4.6.2
On the old server (CDB):
vpopmail 5.2.1
freebsd 4.2
Thankyou
Jesse
--
Jesse Reynolds - Virtual Artists Pty Ltd - http://www.va.com.au
Email: jesse (at) va.com.au> Website Development
Phone: +61 (0)8 8223 2288 > Web & Email Hosting
Web: http://jesse.va.com.au > Streaming Media Hosting
> Telehousing / Colocation
RE: vconvert usage
Using 4.9.9. --- Brad Dameron Network Account Executive TSCNet Inc. www.tscnet.com Silverdale, WA. 1-888-8TSCNET -Original Message- From: Bill Shupp [mailto:[EMAIL PROTECTED]] Sent: Monday, September 24, 2001 2:31 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: vconvert usage on 9/24/01 2:53 PM, Brad Dameron at [EMAIL PROTECTED] spake: > I used this feature. It prints the use but also seems to add them to sql. > You have to reload the database to see it for some reason. I just tried this and it didn't work for me. What version of vpopmail are you using? Bill
Re: vconvert usage
on 9/24/01 2:53 PM, Brad Dameron at [EMAIL PROTECTED] spake: > I used this feature. It prints the use but also seems to add them to sql. > You have to reload the database to see it for some reason. I just tried this and it didn't work for me. What version of vpopmail are you using? Bill
RE: vconvert usage
I used this feature. It prints the use but also seems to add them to sql. You have to reload the database to see it for some reason. --- Brad Dameron Network Account Executive TSCNet Inc. www.tscnet.com Silverdale, WA. 1-888-8TSCNET -Original Message- From: Bill Shupp [mailto:[EMAIL PROTECTED]] Sent: Saturday, September 22, 2001 8:52 PM To: [EMAIL PROTECTED] Subject: Re: vconvert usage Incidentally, vconvert (cdb to sql) doesn't seem to work. I can go from sql to cdb, but cdb to sql just prints the usage. Anyone else seeing this? I'm using the 5.0 release. Cheers, Bill Shupp
Re: vconvert usage
Incidentally, vconvert (cdb to sql) doesn't seem to work. I can go from sql to cdb, but cdb to sql just prints the usage. Anyone else seeing this? I'm using the 5.0 release. Cheers, Bill Shupp
vconvert usage
Ken, As of the current 5.0, vconvert's "usage" statement still displays the s/l options for mysql small/large sites even though they don't work (use m instead). Cheers, Bill Shupp
migrating vconvert
Hello everyone. i can't solve my old problem with halting authorization via mysql and want to convert mysql base to cdb(?). posiibly vconvert utilities useful for it, but one trouble. i run vconvert as example: vconvert -s -c vconvert -s -c mydomain.com vconvert -c -s etc... util always return the help message without any errors. i use last development version of 4.x series. and now: possibly better i must install last 5.0 version and try to convert userbase with it? or any other things? please help, mailer work very unstable with mysql authorize :( and i have a lot of users, for manual adding record for it. -- Best regards, konsul mailto:[EMAIL PROTECTED]
I cann't vconvert with mysql
vchkpw vchkpw£¬hello£¡ I install vpopmail 4.9.10+mysql 3.23.40+qmailadmin 0.45,I installed vpopmail option is ./configure --enable-roaming-users=y --enable-hardquota=1000 --enable-default-domain=rad.ccnu.edu.cn --enable-ucspi-dir=../ucspi-tcp-0.88 --enable-passwd=n --enable-auth-logging=y --enable-logging=e --enable-log-name=vpopmail --enable-sqwebmail-pass=y --enable-mysql=y --enable-sqlincdir=/usr/local/mysql/include --enable-sqllibdir=/usr/local/mysql/lib/mysql --enable-clear-passwd=y --enable-incdir=/usr/local/mysql/include --enable-libdir=/usr/local/mysql/lib/mysql I had vi /etc/ld.so.conf /usr/local/mysql/lib/mysql # add one line in end ldconfig # run I can "./vadddomain mail.rad.ccnu.edu.cn passowrd" but I can't "./vconvert" [root@rad bin]# ./vadddomain mail.rad.ccnu.edu.cn xmbill1 [root@rad bin]# ./vadduser [EMAIL PROTECTED] xmbill1 [root@rad bin]# ./vconvert -c -s converting rad.ccnu.edu.cn domain conversion failed converting mail.rad.ccnu.edu.cn domain conversion failed I had use "perl ../vconvert-cdb-sql-big.pl" I had installed DBI 1.19.tar.gz and Msql-Mysql-modules-1.2216.tar.gz,make ,make test,make install [root@rad bin]# perl /home/xm/qmail/vconvert-cdb-sql-big.pl CAN'T OPEN /home/vpopmail/domains/rad.ccnu.edu.cn/vpasswd at vconvert-cdb-sql-b. Can you help me,thank you! Ö Àñ£¡ mxiao [EMAIL PROTECTED] *ת·¢ÄÚÈݽáÊø* Ö Àñ£¡ mxiao [EMAIL PROTECTED]
vconvert
Hi, I didn't find any manual for vconvert. Can anybody provide me?? I want to migrate users from a mail server using qmail and authentication from /etc/passwd file to new mail server using qmail and vpopmail with mysql. Aadish Shreshta
Re: Vconvert problem,
William Marcelo Piovezan wrote: > > Hi, > > I am trying to use vconvert to convert the /etc/passwd and /etc/shadow to > vpasswd.cdb but with no success. I am using RH6.2 with shadow passwords and > MD5. Here is my procedure: > > vadddomain mydomain.com > vconvert -e -c mydomain.com > > The program produces no results. I've tried to change the command line > switches (-s -f -l -p) or even run it without them but the program returns > nothing (message errors, success messages, nothing). > > I'm using Vpopmail 4.10.28 and there was no errors during compilation. > > Any helps? > > Regards, > > William Marcelo Piovezan. vconvert has been disabled in the devel releases untill the new mysql api can be added back in. Ken Jones
Vconvert problem,
Hi, I am trying to use vconvert to convert the /etc/passwd and /etc/shadow to vpasswd.cdb but with no success. I am using RH6.2 with shadow passwords and MD5. Here is my procedure: vadddomain mydomain.com vconvert -e -c mydomain.com The program produces no results. I've tried to change the command line switches (-s -f -l -p) or even run it without them but the program returns nothing (message errors, success messages, nothing). I'm using Vpopmail 4.10.28 and there was no errors during compilation. Any helps? Regards, William Marcelo Piovezan.
vconvert 4.9.10
Hello list, I'm trying to use vconvert 4.9.10 stable. It does about a dozen of my domains, then seg faults. ./vconvert -c -s The dozen seem to look fine inside mysql. IE. looks like it was successful at converting. When I manually vconvert the next domain (IE, the one it WOULD have done next had it not seg faulted,) it converts it fine too. Then I manually do the next, and the next, and the next... they all work fine. If no one has an answer, I guess I'll just use a Perl script to read the domains dir, and vconvert each domain one at a time... that will probably work. Any ideas?
Re: vconvert
I use Webmin my self. Very useful. However, how would you put, for example, users and their passwords from inside a large "shadow-file-type" file into a domain handled by vpopmail+mysql? Vconvert would not only assimilate the users and encrypted passwords, but would also make their individual directories and Maildir for the domain of your choice. There is also a need to, vice-versa, backup this information from MySQL database tables into some sort of "shadow-file-type" file for recovery purposes, if needed. (BTW, I searched for "RTFM" at mysql.com. Didn't find anything on it.) Faruque At 01:26 PM 6/29/01 -0400, KEnet Webmaster wrote: >Theres two things I could reccommend for using mysql > >The first (and simplistic) is PHPmyAdmin which is a php based MySQL >administration tool. > >The second is WebMin. I like webmin personally. It gives you total >protected access to all your system stuff (system, crons, servers, etc) >including mysql, and in the mysql section you canpoint and click your way to >a back up. > >But theres always the better way of RTFM at mysql.com and learn how to do >it. > >Kil > >- Original Message - >From: "Syed Faruque Ahmed" <[EMAIL PROTECTED]> >To: "chris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> >Sent: Friday, June 29, 2001 1:21 PM >Subject: Re: vconvert > > >I have been mulling over this for sometime. I still don't feel comfortable >putting the development versions into production; too many frequent changes >that might be necessary. So I am still with the stable version of vpopmail >with a working vconvert. >However, there is an interesting script in the source under "contrib" >directory called addusers.pl, that manually adds a list of users, one by >one, to a domain you specify. The catch is that it requires cleartext >passwords. Can "vadduser" work with encrypted passwords? >Another problem is how to backup a list of users with their passwords from >the MySQL db? I plan to use vconvert to create vpasswd files on a regular >basis, but how can one do that with the development vpopmail? Does anybody >have a (perl?) script that can read the db table and write out a neat >little vpasswd file? I think that it is do-able, but am too pressed with >other stuff. > >Faruque > >At 09:56 AM 6/29/01 -0700, chris wrote: > >With the current version of vconvert "disabled," does anyone have a > >suggestion on how to import my current domains into mysql? I'm not > >currently using the replication feature which is -as I understand it- the > >reason vconvert is disabled right now. It doesn't currently support the > >replication freature that the rest of vpopmail does. I tried using an >older > >version of vconvert, I believe it was 4.10.18. It loaded the domain info, > >but it seemed that the path to the domains dir was not imported correctly. > > > >Any ideas? > > > >Thanks, > >Chris Bunnell >
Re: vconvert
Theres two things I could reccommend for using mysql The first (and simplistic) is PHPmyAdmin which is a php based MySQL administration tool. The second is WebMin. I like webmin personally. It gives you total protected access to all your system stuff (system, crons, servers, etc) including mysql, and in the mysql section you canpoint and click your way to a back up. But theres always the better way of RTFM at mysql.com and learn how to do it. Kil - Original Message - From: "Syed Faruque Ahmed" <[EMAIL PROTECTED]> To: "chris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, June 29, 2001 1:21 PM Subject: Re: vconvert I have been mulling over this for sometime. I still don't feel comfortable putting the development versions into production; too many frequent changes that might be necessary. So I am still with the stable version of vpopmail with a working vconvert. However, there is an interesting script in the source under "contrib" directory called addusers.pl, that manually adds a list of users, one by one, to a domain you specify. The catch is that it requires cleartext passwords. Can "vadduser" work with encrypted passwords? Another problem is how to backup a list of users with their passwords from the MySQL db? I plan to use vconvert to create vpasswd files on a regular basis, but how can one do that with the development vpopmail? Does anybody have a (perl?) script that can read the db table and write out a neat little vpasswd file? I think that it is do-able, but am too pressed with other stuff. Faruque At 09:56 AM 6/29/01 -0700, chris wrote: >With the current version of vconvert "disabled," does anyone have a >suggestion on how to import my current domains into mysql? I'm not >currently using the replication feature which is -as I understand it- the >reason vconvert is disabled right now. It doesn't currently support the >replication freature that the rest of vpopmail does. I tried using an older >version of vconvert, I believe it was 4.10.18. It loaded the domain info, >but it seemed that the path to the domains dir was not imported correctly. > >Any ideas? > >Thanks, >Chris Bunnell
Re: vconvert
I have been mulling over this for sometime. I still don't feel comfortable putting the development versions into production; too many frequent changes that might be necessary. So I am still with the stable version of vpopmail with a working vconvert. However, there is an interesting script in the source under "contrib" directory called addusers.pl, that manually adds a list of users, one by one, to a domain you specify. The catch is that it requires cleartext passwords. Can "vadduser" work with encrypted passwords? Another problem is how to backup a list of users with their passwords from the MySQL db? I plan to use vconvert to create vpasswd files on a regular basis, but how can one do that with the development vpopmail? Does anybody have a (perl?) script that can read the db table and write out a neat little vpasswd file? I think that it is do-able, but am too pressed with other stuff. Faruque At 09:56 AM 6/29/01 -0700, chris wrote: >With the current version of vconvert "disabled," does anyone have a >suggestion on how to import my current domains into mysql? I'm not >currently using the replication feature which is -as I understand it- the >reason vconvert is disabled right now. It doesn't currently support the >replication freature that the rest of vpopmail does. I tried using an older >version of vconvert, I believe it was 4.10.18. It loaded the domain info, >but it seemed that the path to the domains dir was not imported correctly. > >Any ideas? > >Thanks, >Chris Bunnell
vconvert
With the current version of vconvert "disabled," does anyone have a suggestion on how to import my current domains into mysql? I'm not currently using the replication feature which is -as I understand it- the reason vconvert is disabled right now. It doesn't currently support the replication freature that the rest of vpopmail does. I tried using an older version of vconvert, I believe it was 4.10.18. It loaded the domain info, but it seemed that the path to the domains dir was not imported correctly. Any ideas? Thanks, Chris Bunnell
Re: vconvert is not working in 4.10.24
Thanks Chris, but I tried the version from 4.10.23, with the same result. Nothing seems to be happening at all. I peeked at the source in vconvert.c. There is a "#ifdef FOOB" on the very first line. There dosen't seem to be any reference to this anywhere else in the code. I don't pretend to be a programmer, but do you think this may be related to the problem? ;i.e. it is not getting some dependency it requires? Should I just remove the "ifdef" and related "endif" and try and recompile? Dear Ken, if you have the time, can you please help on this? thanks in advance. Faruque At 02:34 PM 6/25/01 -0700, chris wrote: >Just an FYI, the failure of vconvert to report "usage" info when you don't >supply any arguments after the command has been happening for some time >(read revs.) now. I discovered this a while back and thought it was >indicative of a bigger problem I was seeing, but I now think it's just >buggy... Try .23's version of vconvert. Maybe it's not broken as badly. > >Chris Bunnell > >- Original Message - >From: "Syed Faruque Ahmed" <[EMAIL PROTECTED]> >To: <[EMAIL PROTECTED]> >Sent: Monday, June 25, 2001 2:06 PM >Subject: vconvert is not working in 4.10.24 > > > > Hi, > > > > I am trying to install the newer version 4.10.24 over 4.9.10. But it >seems > > "vconvert" is not working at all in version 4.10.24. It doesn't produce > > anything, not even if it is run without any options (should produce the > > help menu?). > > > > The binary is a lot smaller than in the earlier versions (about 4KB). I > > think something gets seriously missed during compiling. My configure > > options are; > > > > ./configure --enable-prefix=/var/vpopmail --enable-qmaildir=/var/qmail > > --enable-qmailbindir=/var/qmail/bin > > --enable-tcprules-prog=/usr/local/bin/tcprules > > --enable-tcpserver-file=/var/vpopmail/etc/tcp.smtp --enable-auth-logging=y > > --enable-logging=y --enable-sqwebmail-pass=n --enable-vpopuser=vpopmail > > --enable-vpopgroup=vchkpw --enable-default-domain=global-bd.net > > --enable-sqllibdir=/usr/lib/mysql --enable-libs=/usr/lib --enable-mysql=y > > --enable-ip-alias-domains=y --enable-passwd=n > > > > No errors are obvious, even after "make" and "make install-strip". Can > > someone please help? > > > > thanks in advance > > SFQ > >
Re: vconvert is not working in 4.10.24
Just an FYI, the failure of vconvert to report "usage" info when you don't supply any arguments after the command has been happening for some time (read revs.) now. I discovered this a while back and thought it was indicative of a bigger problem I was seeing, but I now think it's just buggy... Try .23's version of vconvert. Maybe it's not broken as badly. Chris Bunnell - Original Message - From: "Syed Faruque Ahmed" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, June 25, 2001 2:06 PM Subject: vconvert is not working in 4.10.24 > Hi, > > I am trying to install the newer version 4.10.24 over 4.9.10. But it seems > "vconvert" is not working at all in version 4.10.24. It doesn't produce > anything, not even if it is run without any options (should produce the > help menu?). > > The binary is a lot smaller than in the earlier versions (about 4KB). I > think something gets seriously missed during compiling. My configure > options are; > > ./configure --enable-prefix=/var/vpopmail --enable-qmaildir=/var/qmail > --enable-qmailbindir=/var/qmail/bin > --enable-tcprules-prog=/usr/local/bin/tcprules > --enable-tcpserver-file=/var/vpopmail/etc/tcp.smtp --enable-auth-logging=y > --enable-logging=y --enable-sqwebmail-pass=n --enable-vpopuser=vpopmail > --enable-vpopgroup=vchkpw --enable-default-domain=global-bd.net > --enable-sqllibdir=/usr/lib/mysql --enable-libs=/usr/lib --enable-mysql=y > --enable-ip-alias-domains=y --enable-passwd=n > > No errors are obvious, even after "make" and "make install-strip". Can > someone please help? > > thanks in advance > SFQ >
vconvert is not working in 4.10.24
Hi, I am trying to install the newer version 4.10.24 over 4.9.10. But it seems "vconvert" is not working at all in version 4.10.24. It doesn't produce anything, not even if it is run without any options (should produce the help menu?). The binary is a lot smaller than in the earlier versions (about 4KB). I think something gets seriously missed during compiling. My configure options are; ./configure --enable-prefix=/var/vpopmail --enable-qmaildir=/var/qmail --enable-qmailbindir=/var/qmail/bin --enable-tcprules-prog=/usr/local/bin/tcprules --enable-tcpserver-file=/var/vpopmail/etc/tcp.smtp --enable-auth-logging=y --enable-logging=y --enable-sqwebmail-pass=n --enable-vpopuser=vpopmail --enable-vpopgroup=vchkpw --enable-default-domain=global-bd.net --enable-sqllibdir=/usr/lib/mysql --enable-libs=/usr/lib --enable-mysql=y --enable-ip-alias-domains=y --enable-passwd=n No errors are obvious, even after "make" and "make install-strip". Can someone please help? thanks in advance SFQ
Re[2]: vconvert : updating from 4.9.5 with cdb to 4.10.3 with mysql
Hmm... i found the problem: apparently vconvert takes the already encrypted password out of the ~vpopmail/domains/domain.com/vpasswd file and encrypts it again, when it stores that password into the sql table. i can log into a pop3 account when i enter the encrypted des hash of the original password. this doesn't make sense at all. vauth_adduser_size () always encrypts the pass line 210: mkpasswd3(pass,Crypted, 100); so i'd say a vauth_adduser_size_noencrypt () function would make sense, which then could be used by vconvert regards, Justin
Re: vconvert : updating from 4.9.5 with cdb to 4.10.3 with mysql
Justin, My only suggestion would be to look at the password hash inside of your mysql table and confirm that it is still using a DES hash after you change one of the accounts with ./vpasswd. The KJ / 0C change is based on time and it's nothing to worry about. -Ryan At 11:18 AM 5/19/2001 +0200, Justin Heesemann wrote: >hi.. > >i have a weird problem: >whilst moving from 4.9.5 to 4.10.3 i also switched to mysql auth. >well, after executing "vconvert -c -s", it seemed as if it did fine, >except for the passwords: > >the first 2 chars of the password in the sql table of every domain i >convert are the same. > >ghandi domain.com 0CT1cQAicfFEw >postmaster domain.com 0CJ3V6wm1riYA >torxdomain.com 0CJ..MZu/97jg > >when i run "vconvert -c -s" again, all passwords in the sql table >look different, but the first 2 chars are still the same. > >ghandi domain.com kJ7pEAwPlrYRw >postmaster domain.com kJUzEwqVyWuww >torxdomain.com kJ6ziHqRlaK3U > > >of course pop3 authentication failes. >however, if i run vpasswd and set a new password, everything is just >fine.. authentication works. > >any ideas ? > > >regards, > >Justin >
vconvert : updating from 4.9.5 with cdb to 4.10.3 with mysql
hi.. i have a weird problem: whilst moving from 4.9.5 to 4.10.3 i also switched to mysql auth. well, after executing "vconvert -c -s", it seemed as if it did fine, except for the passwords: the first 2 chars of the password in the sql table of every domain i convert are the same. ghandi domain.com 0CT1cQAicfFEw postmaster domain.com 0CJ3V6wm1riYA torxdomain.com 0CJ..MZu/97jg when i run "vconvert -c -s" again, all passwords in the sql table look different, but the first 2 chars are still the same. ghandi domain.com kJ7pEAwPlrYRw postmaster domain.com kJUzEwqVyWuww torxdomain.com kJ6ziHqRlaK3U of course pop3 authentication failes. however, if i run vpasswd and set a new password, everything is just fine.. authentication works. any ideas ? regards, Justin
Re: vconvert on 4.9.10
On Thu, May 17, 2001 at 02:14:09PM -0400, Mathieu Martin wrote: > Same problem here. I'll try to work on a patch/workaround later today. > Because of the design of vpopmail, there is no "pretty" way to patch it. > The code for reading .dir-control files is in the vcdb.c file, which is > not compiled when you --enable-mysql. It's possible to duplicate this > code in vconvert.c, or to write a quick script to import the files. Of > course, I can be totally wrong, I only had a quick look at the code. After I posted the question, I did some more involved digging through the code and it appears it should be dead easy to write a script to import the .dir-control file into the database after doing vconvert... If I do throw something like that together, I will make it available. Ben -- Ben Beuchler There is no spoon. [EMAIL PROTECTED]-- The Matrix
Re: vconvert on 4.9.10
Same problem here. I'll try to work on a patch/workaround later today. Because of the design of vpopmail, there is no "pretty" way to patch it. The code for reading .dir-control files is in the vcdb.c file, which is not compiled when you --enable-mysql. It's possible to duplicate this code in vconvert.c, or to write a quick script to import the files. Of course, I can be totally wrong, I only had a quick look at the code. If anyone has comments or if someone is already working on the issue, please let me know. Mathieu Martin Network Admin CoopTel [EMAIL PROTECTED] Ben Beuchler a écrit : > > I couldn't help but notice that after running 'vconvert -c -s' on a > domain, it converts all the accounts but doesn't seem to have saved the > .dir-control contents. Is that expected? > > Ben > > -- > Ben Beuchler There is no spoon. > [EMAIL PROTECTED]-- The Matrix
Bug - vconvert with domain aliases (SQL)
Hi, I think I found a bug in vconvert (vpopmail 4.9.10). While converting my current userbase (cdb) to SQL, I noticed that users were added to the SQL table for each domain alias. Let's say you have domain.com and domain2.com, which is an alias to domain.com, and user "test": vconvert takes every directory in "/var/vpopmail/domains", even symlinks, and adds the user to the SQL table. Then, you have [EMAIL PROTECTED] and [EMAIL PROTECTED] in the SQL table. I patched vconvert to check if the directory is a link before converting it. If it's a link (domain alias), it skips to the next entry. What is the "standard" way to use diff to create patches? I'll post the patch here if anyone is interested. Thank you! Mathieu Martin Network Admin CoopTel [EMAIL PROTECTED]
vconvert on 4.9.10
I couldn't help but notice that after running 'vconvert -c -s' on a domain, it converts all the accounts but doesn't seem to have saved the .dir-control contents. Is that expected? Ben -- Ben Beuchler There is no spoon. [EMAIL PROTECTED]-- The Matrix
vconvert and LDAP?
Does vconvert have an option to convert cdb to LDAP? -- Ben Beuchler There is no spoon. [EMAIL PROTECTED]-- The Matrix
Re: Convert FreeBSD /etc/passwd users to CDB: vconvert fail, passwd, mail?
Ken Jones <[EMAIL PROTECTED]> writes: > What I would try would be: > vconvert -e -c domainname > > That should read /etc/passwd and create users and set their > passwords to match thier /etc/passwd password. /etc/passwd does not contain crypted/hashed passwords. Modern systems put these in /etc/shadow; FreeBSD puts them in /etc/master.passwd. This way normal users can't look at the hashes and use brute force attacks to crack them. So this won't help in my case. :-( > You might want to build a Mailbox to Maildir program into > vconvert. It's fairly simple code. Get the perl mbox2mdir > or convertandcreate for a sample. Yeah, would be a nice option: as each account is created, translate its mail files into Maildir.
Re: Convert FreeBSD /etc/passwd users to CDB: vconvert fail, passwd, mail?
Chris Shenton wrote: > > I have a site which I've just installed vpopmail on -- very very cool. > > Now of course I want to move all these "system" users in /etc/passwd > out of the system and into a default virtual domain. I'll need to > > * Create vpopmail users for each passwd user > * Deal with the actual crypt() passwd > * Transform mail in /var/mail/username into the vpopmail Maildir format > > FreeBSD can use DES or MD5 passwords, and in this case, the existing > server uses MD5. These crypted passwords are in a /etc/master.passwd > file. > > The vconvert program exists and tho the Usage doesn't show it, the > code indicates a "-p passwdFile" option which I tried like: > > vconvert -p /etc/master.passwd -c > > It seems to have created accounts in both my vpopmail domains. How do > I specify which it should create in? > > It seems to have done *something* with the vpopmail password CDB (as > seen in the text-exported version). But I can't auth any longer. It > may be because of the MD5 hashing instead of DES crypt(). Ideas? > > It doesn't try and convert existing user mail in /var/spool/username > to a Maildir hierarchy. What tools do you recommend to do this? > > Thanks for any leads. What I would try would be: vconvert -e -c domainname That should read /etc/passwd and create users and set their passwords to match thier /etc/passwd password. You might want to build a Mailbox to Maildir program into vconvert. It's fairly simple code. Get the perl mbox2mdir or convertandcreate for a sample. Ken Jones
Convert FreeBSD /etc/passwd users to CDB: vconvert fail, passwd, mail?
I have a site which I've just installed vpopmail on -- very very cool. Now of course I want to move all these "system" users in /etc/passwd out of the system and into a default virtual domain. I'll need to * Create vpopmail users for each passwd user * Deal with the actual crypt() passwd * Transform mail in /var/mail/username into the vpopmail Maildir format FreeBSD can use DES or MD5 passwords, and in this case, the existing server uses MD5. These crypted passwords are in a /etc/master.passwd file. The vconvert program exists and tho the Usage doesn't show it, the code indicates a "-p passwdFile" option which I tried like: vconvert -p /etc/master.passwd -c It seems to have created accounts in both my vpopmail domains. How do I specify which it should create in? It seems to have done *something* with the vpopmail password CDB (as seen in the text-exported version). But I can't auth any longer. It may be because of the MD5 hashing instead of DES crypt(). Ideas? It doesn't try and convert existing user mail in /var/spool/username to a Maildir hierarchy. What tools do you recommend to do this? Thanks for any leads.
Re: vconvert
Trond Arve Nordheim wrote: > > Hi. > > I'm trying to convert a cbd-database to MySQL (large-site-layout). > > I'm running the command `vconvert -c -l`, and vconvert reports everything > OK. > The problem is; i'm not able to log in to any virtual accounts, and not into > qmailadmin either (I get a "bad file"-error). > > Then I take a look into the database, and see that vconvert removed the path > in front of the user-dir in the pw_dir-field, so instead of saying > /home/vpopmail/domains/somedomain.com/postmaster, it says /postmaster. I've > tried changing this, and then everything works. > > Why doesn't vconvert fix this? > I have a large number of users to convert, so I can't sit here and fix every > single row in the database. > > -- > Trond Arve Nordheim Try fixing vconvert.c ;] Ken Jones
vconvert
Hi. I'm trying to convert a cbd-database to MySQL (large-site-layout). I'm running the command `vconvert -c -l`, and vconvert reports everything OK. The problem is; i'm not able to log in to any virtual accounts, and not into qmailadmin either (I get a "bad file"-error). Then I take a look into the database, and see that vconvert removed the path in front of the user-dir in the pw_dir-field, so instead of saying /home/vpopmail/domains/somedomain.com/postmaster, it says /postmaster. I've tried changing this, and then everything works. Why doesn't vconvert fix this? I have a large number of users to convert, so I can't sit here and fix every single row in the database. -- Trond Arve Nordheim
Problem with vconvert
Hello list, I tried to use the vconvert program to 'move' my /etc/passwd users over to a virtual domain. Only about half of the users were created in the virtual domain. Any thoughts on why vconvert would skip such a large number of entries from /etc/passwd & /etc/shadow ? Thanks in advance for any help! Chris
vconvert
i'm using the new vpopmail 4.9.5. 4.9.4 wouldn't work. maybe a redhat 7 thing... the vconvert -e -c /etc/shadow yields a bunch of "user xyz domain /etc/shadow did not add" statements. the domain above is really 'domain' in the error. should it say my domain? should i recompile with more flags than '--enable-remote-users=y'? thanks
Re: vconvert
Benoit de Mulder wrote: > > Hello, > > I have a large /etc/passwd file on a server I will convert it to cdb > database on a new server. > vconvert seems to use the /etc/passwd file by default. Is there a way to > use a designated passwd file with vconvert ? > There isn't any code to do that. But I'm working on it. It would probably have to support both an /etc/passwd option and an /etc/shadow option. Does your conversion have it's passwords in the "passwd" file? Ken Jones
vconvert
Hello, I have a large /etc/passwd file on a server I will convert it to cdb database on a new server. vconvert seems to use the /etc/passwd file by default. Is there a way to use a designated passwd file with vconvert ? Benoit -- System Administrator Mamma.com - The Mother of All Search Engines 388 St. Jacques Street West, 9th Floor Montreal Quebec, H2Y 1S1 [EMAIL PROTECTED] - http://www.mamma.com/
