[vchkpw] What if mysql was preinstalled?

2003-09-04 Thread Don Walters
I am trying to install vpopmail, and I have a small problem.  I started 
installing vpopmail according to Michael Bowes mysql/vpopmail guide found 
here...

http://www.pipeline.com.au/staff/mbowe/isp/vpopmail-mysql.htm

When I got to the part about installing mysql, I realized that mysql was 
already installed when I loaded Redhat 9.  I decided that rather than try to 
remove it, I would try to use the installation I already had and just 
configure it accordingly.  Well, I managed to work thru that and everything 
seemed OK until I got to the part where you do a ./configure and there are a 
bunch of parameters you pass to it like --enable-domain-quotas=n \.  I guess 
there were about 10 of these.

Well, the installation didn't go much farther.  I got a whole bunch of 
errors when I did a make afterwards because the paths for the incdir and the 
libdir are not where they should be.

I'm sure if I went thru the installation exactly as Michael Bowes specified, 
those directories would be exactly where they should be.  However, I don't 
even have a directory for /usr/local/mysql/, much less the lib or include 
directories.

So my question is:  Where can I find the needed files, or will this even be 
a problem?  What sort of files are found under the lib and include 
directories that I need to be concerned about?

I have found that most all of the needed files for this installation were 
actually on the drive, but were not in the locations I expected them to be.

_
Express yourself with MSN Messenger 6.0 -- download now! 
http://www.msnmessenger-download.com/tracking/reach_general




[vchkpw] How to completely remove a database

2003-09-11 Thread Don Walters
I am trying to wipe out everything and start from scratch.  I tried using 
drop database vpopmail; and creating it again using the instructions to 
install vpopmail, but I'm unable to add the same domains back again.  It 
keeps saying the domain already exists.  If I try to use the command 
vdeldomain to remove it, it says the domain doesn't exist!

The reason I didn't use vdeldomain in the first place is because I had to 
reload everything all over again and I was installing over the top of a 
previous installation.  I think all I need to do is wipe the slate and start 
adding my domains back into a clean database.

How can I be assured that I'm wiping out everything and starting fresh?

Thanks in advance.

_
Need more e-mail storage? Get 10MB with Hotmail Extra Storage.   
http://join.msn.com/?PAGE=features/es




Re: [vchkpw] How to completely remove a database

2003-09-12 Thread Don Walters
Ok, that worked great.  I was able to kill the database and all of those 
entries from the various files and I was able to recreate the database and 
add my domains back.

Only one problem remains:  I'm unable to pop into the account and get my 
mail.  There are no errors that I can see happening in any of the log files, 
but I am popping like crazy and no mail is coming.  I can see that the 
messages were delivered to the right mailbox because I went to the 
~vpopmail/domains folder and I could see the messages were stored in the 
appropriate mailbox.

Here's an exceprt from my log file located at /var/log/qmail/pop3d/current

@40003f61fe982c0320c4 tcpserver: status: 1/40
@40003f61fe982c033c1c tcpserver: pid 22184 from 24.116.177.127
@40003f61fe982c0343ec tcpserver: ok 22184 0:192.168.0.50:110 
:24.116.177.127::41746
@40003f61fe9835c5210c tcpserver: end 22184 status 256
@40003f61fe9835c53c64 tcpserver: status: 0/40

So there were no errors that I can see, and when I keep hitting the 
Send/Receive button of my mail client (outlook) it adds another entry 
similar to this in the log.

I don't know if this is related, but when I do...

ps -efl | grep service errors | grep -v grep

as suggested in Life With Qmail, I get...

0 S root 19866 19857  0  84   0-   336 pipe_w Sep11 ?
00:00:00 readproctitle service
errors: 




Should I be worried about this?  I get no other messages from running this 
command.  Maybe it's OK as is.



From: Bill Shupp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] How to completely remove a database
Date: Thu, 11 Sep 2003 22:24:58 -0700
On Thursday, September 11, 2003, at 10:21  PM, Don Walters wrote:

I am trying to wipe out everything and start from scratch.  I tried using 
drop database vpopmail; and creating it again using the instructions to 
install vpopmail, but I'm unable to add the same domains back again.  It 
keeps saying the domain already exists.  If I try to use the command 
vdeldomain to remove it, it says the domain doesn't exist!

The reason I didn't use vdeldomain in the first place is because I had to 
reload everything all over again and I was installing over the top of a 
previous installation.  I think all I need to do is wipe the slate and 
start adding my domains back into a clean database.

How can I be assured that I'm wiping out everything and starting fresh?
In addition to removing the database/recreating it, remove the domain 
directory, and the entry from /var/qmail/users/assign and run 
/var/qmail/bin/qmail-newu to update the assign cdb file.

Regards,

Bill Shupp


_
Express yourself with MSN Messenger 6.0 -- download now! 
http://www.msnmessenger-download.com/tracking/reach_general




[vchkpw] qmailadmin and apache suexec

2003-11-05 Thread Don Walters
I had qmailadmin installed and working great.  Today, I setup my apache 
server to use suexec.  I noticed my qmailadmin stopped working.  After 
looking through the archives, I found a post where someone mentioned that I 
needed to change the owner, group, and permissions on the qmailadmin file.  
I made them the same user and group as the suexec parameter I specified in 
apache.  Now it is working fine.  My question is... is that OK?  Will I mess 
anything up by running it as a user other than vpopmail.vchkpw?

Thanks in advance.

_
From Beethoven to the Rolling Stones, your favorite music is always playing 
on MSN Radio Plus. No ads, no talk. Trial month FREE!  
http://join.msn.com/?page=offers/premiumradio




Re: [vchkpw] Re: qmailadmin and apache suexec

2003-11-05 Thread Don Walters

In my case, i use a specific virtualhost for qmailadmin, and i set suexec 
on
this virtualhost to vpopmail.vchkpw
After setting up my vhosts as you described, I discovered that in order for 
apache to run suexec as the vpopmail user, it must run as uid and gid of 89. 
 My suexec is configured to run only uid's and gid's higher than 508.

As I understand it, most apache configs are setup by default to allow only 
uid and gid of 100 or higher to run suexec unless you change it using the 
--configure options for apache when you rebuild.

Can I run qmailadmin as uid and gid of something higher?  How about 600.600? 
 The instructions specifically say to setup vpopmail as 89.89, so there 
must be some special reason why this is chosen.

What worries me... and I'm not sure if I should be cautious here or not... 
the user nobody on my system is 99.99.  So if I lowerd my apache suexec to 
89.89 then the user nobody will be able to run suexec'd on the box.  
Yikes!

_
From Beethoven to the Rolling Stones, your favorite music is always playing 
on MSN Radio Plus. No ads, no talk. Trial month FREE!  
http://join.msn.com/?page=offers/premiumradio




[vchkpw] vpopmail uid/gid 89

2003-11-07 Thread Don Walters
Can somebody explain what I need to do in order to change the uid/gid for 
vpopmail to something other than 89.89.  I have poured over the archives 
looking for a way, but I can't find anything that explains how.  Is there 
some special reason it needs to be 89?

I have tried going into some of the config files and I found a couple of 
places where it specifies 89.89 for the uid/gid.  I have even tried changing 
these to what I want them to be, but now my qmail isn't working.  Looking at 
some of my files, I discovered some of them are owned by user 89 and group 
89, so I have changed those to vpopmail.vchkpw.  And of course, I have 
changed /etc/passwd  /etc/group to reflect the uid/gid I want to use.  Is 
there something I am missing?

_
Is your computer infected with a virus?  Find out with a FREE computer virus 
scan from McAfee.  Take the FreeScan now! 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963




Re: [vchkpw] vpopmail uid/gid 89

2003-11-07 Thread Don Walters
On a lot of systems these days you can run vipw to edit the password file 
and change the UID.
vipw will update the shadow password file too (if you use shadow 
passwords).


I have vipw (I'm running RH9) but it seems to be just a incantation of the 
vi editor that takes me through the files and allows me to edit them.  
/etc/shadow doesn't seem to have any uid/gid in there, but I could be wrong.

I think I smell an enhancement to vpopmail just waiting to happen.  Wouldn't 
it be nice if I could specify the uid/gid when I run --configure??  I mean, 
that's kind of a grand assumption that every single user everywhere who 
installs vpopmail will always want the uid/gid to be 89.

_
Is your computer infected with a virus?  Find out with a FREE computer virus 
scan from McAfee.  Take the FreeScan now! 
http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963




[vchkpw] Moving everything to a new server

2004-03-07 Thread Don Walters
I would like to move everything from one server to another.  I have
installed mysql, vpopmail, qmail, and a bunch of other services on the new
machine.  Now all that remains is moving my vpopmail database over to the
new server.  Since this database is pretty big, I don't want to create all
of those tables again, so I'd like to just copy everything over.
I have tried copying over all the stuff from /var/lib/mysql/vpopmail over to
the new machine.  I have also copied over all the domains under
/home/vpopmail/domains, and also copied over the stuff under
/var/qmail/control and /var/qmail/users but it's still giving me vpopmail
user not found errors when I try to authenticate with a mail client.
I have run mysql login commands manually to be sure it's not a login problem
to the mysql server.  The file /home/vpopmail/etc/vpopmail.mysql was also
copied over.
What am I forgetting?  Is there a better (cleaner) way to do this?

_
One-click access to Hotmail from any Web page – download MSN Toolbar now! 
http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/



Re: [vchkpw] Moving everything to a new server

2004-03-08 Thread Don Walters
I'm no database expert, but you may need to export the database to
some flat file format from the old server, then import it into the
new one.


Yeah, I've been reading about using vconvert to save the mysql database to 
cdb format and then import that back into the new server, running the 
conversion backwards... like so...

[EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -m -c

[EMAIL PROTECTED] # /home/vpopmail/bin/vconvert -c -m

Problem is... I did the first command and I don't have any idea where the 
stuff was written to.   I tried looking for documentation on vconvert but 
the stuff on inter7.com's website is a joke!

Take a look at their man pages for vconvert:

http://www.inter7.com/vpopmail/doc/vconvert.html

Can somebody tell me what all of the options are for vconvert?  What 
arguments will it take?  What do they do?  Where is the output written?  I'd 
love to use it if I just knew how!

_
One-click access to Hotmail from any Web page – download MSN Toolbar now! 
http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/



Re: [vchkpw] Moving everything to a new server

2004-03-08 Thread Don Walters
~vpopmail/bin/vconvert -- run that by itself.


Ok, that helps.  Now I guess that means I need to create each domain on the 
new server, put this file under each domain (same place as on the old 
server) and rerun the command converting everything back to mysql format?  
That will update the mysql tables for me?

Sorry for all the Q's.  I just want to be sure I'm doing right before I 
start doing all this work.

_
One-click access to Hotmail from any Web page – download MSN Toolbar now! 
http://clk.atdmt.com/AVE/go/onm00200413ave/direct/01/