[vchkpw] Vconvert / converting / migrating woes....

[Harry Zink]

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

Re: [vchkpw] Vconvert / converting / migrating woes....

[Rick Macdougall]

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] vpopmail 5.3.23 segfaults when adding domain

[Tohru Kobayashi]

Hello, list,

I could not add a domain with vpopmail 5.3.23.

I have installed vpopmail 5.3.21 on a test server and upgraded to 5.3.23.
The whole thing worked properly, and I decided to do a new installation
with different compile options.  

I deleted the whole thing under /home/vpopmail, cleared all
/var/qmail/users/assign entries (and qmail-newu), cleard all
/var/qmail/control/rcpthosts entries and /var/qmail/virtualdomains
entires.

Then I deleted the vpopmail 5.3.23 source tree, and extracted it once
again from the tarball.

Configure, make, make-install suceeded with the compile options like
following:
./configure --enable-clear-passwd=n --enable-logging=y --enable-roaming-users=y

Finally I tried to add a domain, then I got the segmentation fault
after entering the password for postmaster account.

I went over the delete thing again and fell back to 5.3.21 with the same
configure options; everything worked properly.

---
Tohru Kobayashi
[EMAIL PROTECTED]

Re: [vchkpw] Re: error:domain already exsits

[Tohru Kobayashi]

Hello, lixiang,

On Fri, 25 Jul 2003 17:31:22 +0800
"lixiang" <[EMAIL PROTECTED]> wrote:

> hi, Rosa:
>   
>   i  removed the cdb file, then  the problem is solved. thank you . :-)
>   then , everything seems normal, except the pop authentication.  if i telnet 
> localhost 110, and input the correct username and password, it reports:
>   err aack, child crashed.
> 
> 
> my configure parameters:
> 
> ./configure --enalbe-ldap=y  --enable-logging=y 
> 
> redhat 7.3 
> vpopmail-5.3.20
> openldap-2.0.27
> qmailadmin-1.0.20
> 
> 
> any ideas?  
>  
> 

I had the same problem with you until I disabled the clear password
option.  Try

./configure --enable-lday=y --enable-loggin=y --enable-clear-password=n

However, I am still interested to have clear password working.  Anyone
with any suggestions?
---
Tohru Koobayashi
[EMAIL PROTECTED]

[vchkpw] SHA crypt ldap auth

[Rodrigo Pinheiro]

Hi,

I would like that vpopmail supports SHA crypt in ldap database

I'm using Iplanet and I would like to migrate to openldap.


Thanks

Rodrigo Pinheiro
Analista T.I
Netcenter Informática 

[vchkpw] SHA crypt ldap auth

[Rodrigo Pinheiro]

I would like TO KNOW


Sorry for my bad english

[]s

Rodrigo Pinheiro
Analista T.I
Netcenter Informática 

[vchkpw] SQL data

[Rudi Ahlers]

I know this is not entirely an SQL mailing list, but how do I dump only my
database table layout? I don't want a dump of all the data


Kind Regards
Rudi Ahlers
Océ Software Support
+27 (11) 661-9000

"The basic difference between an ordinary man and a warrior is that a
warrior takes everything as a challenge while an ordinary man takes
everything either as a blessing or a curse."

Re: [vchkpw] SQL data

[Justin Heesemann]

On Monday 30 July 2001 15:20, Rudi Ahlers wrote:
> I know this is not entirely an SQL mailing list, but how do I dump
> only my database table layout? I don't want a dump of all the data
>

man mysqldump 

...
-d|--no-data
  No row information.
---

so i assume   mysqldump -d databaseyouwanttodump
does the job


and this really is not "entirely" a SQL mailing list.

-- 
Mit internetten Grüßen / Best Regards
---
Justin Heesemannionium Technologies
[EMAIL PROTECTED]www.ionium.org

Re: [vchkpw] Re: error:domain already exsits

[Jens Jahr]

Zitat von Tohru Kobayashi <[EMAIL PROTECTED]>:

> 
> I had the same problem with you until I disabled the clear password
> option.  Try
> 
> ./configure --enable-lday=y --enable-loggin=y --enable-clear-password=n
> 
> However, I am still interested to have clear password working.  Anyone
> with any suggestions?

Hi Toruh,
I already have a patch for that, which also has been refused.

Download it and please give me Feedback...

See my posting:
http://bluedot.net/mail/archive/read.php?f=2&i=9479&t=9479

It enables "clear-text" passwords in LDAP-Auth.

Cheers
Jens
 

Re: [vchkpw] SQL data

[Scott Helms]

Rudi,

Here is the base way of doing it without any data.

mysqldump -d DATABASENAME > backup-file.sql


You can read this back into MySQL with:


mysql DATABASENAME < backup-file.sql

Check here for more options for mysqldump:

http://www.mysql.com/doc/en/mysqldump.html

Scott Helms


On Mon, 2001-07-30 at 09:20, Rudi Ahlers wrote:
> I know this is not entirely an SQL mailing list, but how do I dump only my
> database table layout? I don't want a dump of all the data
> 
> 
> Kind Regards
> Rudi Ahlers
> Océ Software Support
> +27 (11) 661-9000
> 
> "The basic difference between an ordinary man and a warrior is that a
> warrior takes everything as a challenge while an ordinary man takes
> everything either as a blessing or a curse."
> 

[vchkpw] why my vpopmail can not set default domain ??

[T.J.Ch]

I set a qmail, vpopmail server with vpopmail-5.3.23.
and config it as:

./configure \
  --enable-roaming-users=n \
  --enable-logging=p \
  --enable-defaultquota=20971520S \
  --enable-ip-alias-domains=n \
  --enable-domainquotas=y \
\
  --enable-passwd=n \
  --enable-clear-passwd=y \
\
  --enable-mysql=y \
  --enable-incdir=/usr/include/mysql \
  --enable-libdir=/usr/lib/mysql \
  --enable-many-domains=y \
\
  --enable-auth-logging=y \
  --enable-mysql-logging=y \
  --enable-valias=y \
  --enable-mysql-limits=y


there is only one domain now in this box -- testmail.com
and my box's hostname is mx.testmail.com
and my 
cat /var/qmail/control/defaultdomain
mx.testmail.com
cat /var/qmail/control/me
mx.testmail.com
cat /var/qmail/control/locals
mx.testmail.com

and the result of dns check
#dig mx testmail.com
testmail.com. 31506   IN  MX  0 mx.testmail.com.

but, later, after adding the first domain, with command
#~vpopmail/bin/vadddomain testmail.com
I found no matter what I do to change /var/qmail/control/defaultdomain 
with "testmail.com" or "mx.testmail.com", I only can do login pop3 account
by full name, for instance, [EMAIL PROTECTED], but not the "postmaster"
and I DO not know what is wrong with it, and I ever setup vpopmail
with vpopmail-4.9.10, all is okay, and this is the first time using vpopmail-5.3.23,
and is there something wrong with the configure?? or 
some control file in ill-usage??

any help is appreciated
Thanks advanced. 

T. J. Ch

Re: [vchkpw] Conversion to mysql..?

[Jeremy Oddo]

>> And btw, I don't do responses to TDMA or tdma type systems :)  So
>> you'll have to get your answer from the list.
>
> Just curious - why do you not 'do responses' to TMDA systems?
>
Well, I may not be Rick Macdougall but I'll tell you why I don't...
because it's a pain in the ass!  It adds extra traffic, and it's a pain to
send an e-mail only to get a response back saying you need to jump thru
some hoops in order to get the e-mail to the intended person.  On a list,
you're often replying to someone out of kindness (ie:  answering their
questions free of charge) so to be asked to do extra work is kind of "bad
form".

Most importantly, if you are a business and you work with new clients all
the time, they WON'T take kindly to the whole "reply" thing...even if they
only have to do it once.  You NEVER want to put a client thru extra crap
just to communicate with you.

My opinion:  it's an interesting idea...that should never be used in a
professional environment.

But then again, that's just me :)


Jeremy

Re: [vchkpw] Conversion to mysql..?

[Rick Macdougall]

Jeremy Oddo wrote:

And btw, I don't do responses to TDMA or tdma type systems :)  So
you'll have to get your answer from the list.
Just curious - why do you not 'do responses' to TMDA systems?

Well, I may not be Rick Macdougall but I'll tell you why I don't...
Man, be very very Happy you aren't Rick Macdougall :)

Regards,

Rick

Re: [vchkpw] OT TDMA Conversion to mysql..?

[Ajai Khattri]

Harry Zink wrote:

Well, being in the same boat, I simply set up a rule/filter which responds
to TMDA challenges with an automatic response, and files the
challenge/response/confirmation away. No interaction needed on my part, and
the lines of communication remain open. Very simple, really.
Most people are not savvy enough to setup their email clients in this 
way - nor do they want to be.

--
Aj.
Systems Administrator / Developer

Re: [vchkpw] why my vpopmail can not set default domain ??

[Ajai Khattri]

T.J.Ch wrote:

I set a qmail, vpopmail server with vpopmail-5.3.23.
and config it as:
./configure \
 --enable-roaming-users=n \
 --enable-logging=p \
 --enable-defaultquota=20971520S \
 --enable-ip-alias-domains=n \
 --enable-domainquotas=y \
\
 --enable-passwd=n \
 --enable-clear-passwd=y \
\
 --enable-mysql=y \
 --enable-incdir=/usr/include/mysql \
 --enable-libdir=/usr/lib/mysql \
 --enable-many-domains=y \
\
 --enable-auth-logging=y \
 --enable-mysql-logging=y \
 --enable-valias=y \
 --enable-mysql-limits=y
I don't see any default domain defined above.

--
Aj.
Systems Administrator / Developer

[vchkpw] why my vpopmail can not set default domain ??

[T.J.Ch]

I set a qmail, vpopmail server with vpopmail-5.3.23.
and config it as:

./configure \
  --enable-roaming-users=n \
  --enable-logging=p \
  --enable-defaultquota=20971520S \
  --enable-ip-alias-domains=n \
  --enable-domainquotas=y \
\
  --enable-passwd=n \
  --enable-clear-passwd=y \
\
  --enable-mysql=y \
  --enable-incdir=/usr/include/mysql \
  --enable-libdir=/usr/lib/mysql \
  --enable-many-domains=y \
\
  --enable-auth-logging=y \
  --enable-mysql-logging=y \
  --enable-valias=y \
  --enable-mysql-limits=y


there is only one domain now in this box -- testmail.com
with command
#~vpopmail/bin/vadddomain testmail.com
and my box's hostname is mx.testmail.com
and my 
cat /var/qmail/control/defaultdomain
mx.testmail.com
cat /var/qmail/control/me
mx.testmail.com
cat /var/qmail/control/locals
mx.testmail.com

and the result of dns check
#dig mx testmail.com is:
testmail.com. 31506   IN  MX  0 mx.testmail.com.

but, later, after adding the first domain, 
 no matter what I change /var/qmail/control/defaultdomain 
with "testmail.com" or "mx.testmail.com", I only can do login
by full name, for instance, [EMAIL PROTECTED],
and I do not know what is wrong with it, and I ever setup vpopmail
with vpopmail-4.9.10, and this is the first time using vpopmail-5.3.23,
and is there something wrong with the configure?? or 
some control file in ill-usage??

Thanks advanced. 

T. J. Ch

[vchkpw] IMAP/POP3 errors

[Juan Hernandez]

Hey, how are you all doing?

 

   This is my first
email to this mailing list and I think so far that it’s great. Anyway,
here’s my problem: I just Installed Courier-IMAP in my server to be able
to use swqirrelmail and everything worked fine. I have about 30 domains in my
vpopmail system and has been working perfect until
now. The problem comes when one user logs into the server thru IMAP using webmail
and then if he lf he logs back again thru pop3 will most of the time get errors,
Is it because of all the directories that IMAP
creates? Is it because I have to apply a patch or something?? Is it because you
either have to log all the time with IMAP or POP3 and not both?? Im using vpopmail-5.3.20
and courier imap autorespond-2.0.3 and outlook express for my customers POP3
client because SquirrelMail is the IMAP client

 

Thanx a lot for your help and expect more mails in this
great mailing list

 

RHCE/Oracle
DBA Juan F. Hernández

Administrador/Programador
de Sistemas Linux/Unix/PHP

Tel: 58212-6902445

Cel: 58412-9784303

MacPC Station C.A.

www.macpcstation.com

 

Re: [vchkpw] OT TDMA Conversion to mysql..?

[Jeremy Oddo]

Ajai Khattri said:
> Harry Zink wrote:
>
>>Well, being in the same boat, I simply set up a rule/filter which
>> responds to TMDA challenges with an automatic response, and files the
>>challenge/response/confirmation away. No interaction needed on my part,
>> and the lines of communication remain open. Very simple, really.
>>
> Most people are not savvy enough to setup their email clients in this
> way - nor do they want to be.
>
Nor should they HAVE to.  E-mail is used by nearly everyone in the
business world these days...and most of them aren't savvy.  Hoop jumping
should be kept to an absolute minimum.  Heck, some users even have
difficulty opening up their ".spam" folder!

Jeremy

Re: [vchkpw] why my vpopmail can not set default domain ??

[Flavio Caetano]

I'm using qmail+vpopmail

Can I rewrite a top header of each e-mail?

I want to add: "Report this mail as spam" for example... (with a link)

thanks

Re: [vchkpw] IMAP/POP3 errors

[spork]

On Wed, 30 Jul 2003, Juan Hernandez wrote:

> The problem comes when one user logs into the server thru IMAP using
> webmail and then if he lf he logs back again thru pop3 will most of the
> time get errors, Is it because of all the directories that IMAP creates?

Probably not.  What pop server are you using?  Qmail's popper or the
Courier popper?  How are you starting the popd?  What are the errors the
user gets when using pop?

> Is it because I have to apply a patch or something?? Is it because you
> either have to log all the time with IMAP or POP3 and not both??

Probably not, you should be able to use both imap/pop at the same time,
Maildirs should not have a problem with that at all.

Charles

> Thanx a lot for your help and expect more mails in this great mailing
> list
>
> RHCE/Oracle DBA Juan F. Hernández
> Administrador/Programador de Sistemas Linux/Unix/PHP
> Tel: 58212-6902445
> Cel: 58412-9784303
> MacPC Station C.A.
>   www.macpcstation.com
>
>

Re: [vchkpw] why my vpopmail can not set default domain ??

[Michael Bowe]

> T.J.Ch wrote:
> 
> > I set a qmail, vpopmail server with vpopmail-5.3.23.
> > and config it as:

> I don't see any default domain defined above.
> 

>From the 5.3.22 release notes

  - Switched from using --enable-default-domain to storing default
domain in ~vpopmail/etc/defaultdomain.  This should provide
flexibility when compiling packages for distribution.

Michael.

Re: [vchkpw] why my vpopmail can not set default domain ??

[T.J.Ch]

> > T.J.Ch wrote:
> > 
> > > I set a qmail, vpopmail server with vpopmail-5.3.23.
> > > and config it as:
> 
> > I don't see any default domain defined above.
> > 
> 
> From the 5.3.22 release notes
> 
>   - Switched from using --enable-default-domain to storing default
> domain in ~vpopmail/etc/defaultdomain.  This should provide
> flexibility when compiling packages for distribution.
> 
yes, you are right, so, I did not see this option when I configured vpopmail.
but, as you said, I 
#echo 'testmail.com' > ~vpopmail/etc/defaultdomain
and then reboot my computer, I still need login with full name, what is wrong ?

T.J.Ch

> Michael.
> 
> 
>

Re: [vchkpw] why my vpopmail can not set default domain ??

[T.J.Ch]

> > > T.J.Ch wrote:
> > > 
> > > > I set a qmail, vpopmail server with vpopmail-5.3.23.
> > > > and config it as:
> > 
> > > I don't see any default domain defined above.
> > > 
> > 
> > From the 5.3.22 release notes
> > 
> >   - Switched from using --enable-default-domain to storing default
> > domain in ~vpopmail/etc/defaultdomain.  This should provide
> > flexibility when compiling packages for distribution.
> > 
> yes, you are right, so, I did not see this option when I configured vpopmail.
> but, as you said, I 
> #echo 'testmail.com' > ~vpopmail/etc/defaultdomain
> and then reboot my computer, I still need login with full name, what is wrong ?
> 
OK, I got it, I test it again, now I can use
either
[EMAIL PROTECTED]
or
postmaster
for login, it is same!!  :)
and this new feature of vpopmail is very good !!

T.J.Ch

> T.J.Ch
> 
> > Michael.
> > 
> > 
> >

Re: [vchkpw] why my vpopmail can not set default domain ??

[Michael Bowe]

- Original Message - 
From: "T.J.Ch" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, July 31, 2003 1:24 PM
Subject: Re: [vchkpw] why my vpopmail can not set default domain ??


> yes, you are right, so, I did not see this option when I configured
vpopmail.
> but, as you said, I
> #echo 'testmail.com' > ~vpopmail/etc/defaultdomain
> and then reboot my computer, I still need login with full name, what is
wrong ?

I am using 5.3.23 on my server here and that new
~vpopmail/etc/defaultdomain
function seems to work ok for me

Are you sure you echo'ed the right thing to that file?

>From your original post it sounds like you did

  echo "mx.testdomain.com" > ~vpopmail/etc/defaultdomain

when I would think that the correct command would have been

  echo "testdomain.com" > ~vpopmail/etc/defaultdomain

Perhaps do a
  cat ~vpopmail/etc/defaultdomain
to verify you have got the right domain stored there

Also, it couldnt hurt to go back to your vpopmail 5.3.23 dir and run
  make clean
  ./configure  ...
  make
  make install-strip

And then dont forget you need to re-build any add-on apps that use vpopmail
authentication
eg qmailadmin, courier-imap, sqwebmail etc

Michael.

[vchkpw] could vpopmail prevent against password guess now?? password-nuke??

[T.J.Ch]

I just install the latest version vpopmail + courier-imap,
I found there is good ability to check password guess
through check the table vpopmail.vlog in mysql.

but is there a function of vpopmail to disable the connections
of such cracker's IP for minutes to protect account security??
or other ways??

and is it possible to configure courier-imap with same ability??
I found courier-imap only refer the auth type and no IP record.
Thanks!
T.J.Ch

[vchkpw] vconvert woes...

[Harry Zink]

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