[vchkpw] vacation messages / robots / copy and forward and MySQL

2007-07-27 Thread Ron Culler
We are running the following

vpopmail-5.4.18
courier-imap-4.1.2
courier-authlib-0.59.1
autorespond-2.0.4
netqmail-1.05

Vpopmail is setup to use MySQL with valias table created.

We can create users directly in MySQL and everything works great the users
pw_dir field is populated and the actual mailbox dir is created when the
user logs in for the first time or receives their first email.

We can create aliases in the valias table alias, domain, valias_line
that point to an existing users email box, as well as single forwards (no
box on system)

Example Alias - record
alias - joe, domain - mydomain.com, valias_line - [EMAIL PROTECTED]

Example Forward - record
alias - bill, domain - mydomain.com, valias_line - [EMAIL PROTECTED]

What we would like to be able to do is take the remaining features in
qmailadmin and push them to MySQL as well by getting rid of .qmail files
in the users mail dir.

Copy and Forward - example .qmail
[EMAIL PROTECTED]
/home/vpopmail/domains/mydomain.com/bob/Maildir/

Vacation Message - example .qmail
/home/vpopmail/domains/mydomain.com/bob/Maildir/
| /usr/local/bin/autorespond 86400 3
/home/vpopmail/domains/mydomain.com/bob/vacation/message
/home/vpopmail/domains/mydomain.com/bob/vacation

Robot - example .qmail
|/usr/local/bin/autorespond 1 5
/home/vpopmail/domains/mydomain.com/ROBOT/message
/home/vpopmail/domains/mydomain.com/ROBOT
[EMAIL PROTECTED]

With the Vacation Message and Robot we would like to have the contents of
the directory stored in MySQL as well.

The ultimate goal is to allow for a custom web frontend that can be
incorporated into what ever web email client we run.

I have see the file dotqmail2valias but from what I can tell it makes
changes for alias and forwards only not anything above. Has anyone looked
at this before or been able to get it to work?

Any help or ideas would be appreciated.
Thanks

Ron




[vchkpw] password problem converting from 5.3 to 5.4

2005-03-23 Thread Ron Culler
having a problem with user pop authentication on new users or users
who's passwords were changed after the upgrade.  With 2 additional
characters added to the salt I am not able to login using pop3.  

Upgrade 5.3.27 to 5.4.8
Redhat Enterprise 3 
Mysql 3.23.58-1

./configure --enable-roaming-users --enable-logging=v --enable-log-
name=vpopmail --disable-ip-alias-domains --disable-passwd 
--enable-clear-passwd --enable-domain-qoutas --enable-auth-module=mysql
--enable-auth-logging --enable-mysql-logging --disable-mysql-limits

I dumped the DB from the old server and created it on the new server.
Old (salt) users login fine but if I create a new user (vpopmail command
line) or Qmailadmin 1.2.3, or change the users password with either tool
I get login errors.

If I change the salt code in vpopmail.c back to the same code from
5.3.27 then everything works correctly.  Did I miss something in the
upgrade that should have changed the existing passwords to the new salt
format and thus allow authentication correctly? 

Any help would be appreciated.


-- 
Ron Culler




[vchkpw] vcalias not compiling

2005-03-14 Thread Ron Culler
vpopmail-5.4.8

Get the following messages

vcalias.c: In function `main':
vcalias.c:73: `MYSQL_DATABASE' undeclared (first use in this function)
vcalias.c:73: (Each undeclared identifier is reported only once
vcalias.c:73: for each function it appears in.)



-- 
Ron Culler




[vchkpw] smtp-auth on separate server queries vpopmail -mysql

2004-06-23 Thread Ron Culler
I'm and having difficulty setting up a separate qmail server as a
smtp-auth server.  
(* Its being done to provide inbound virus scanning prior to the message
being delivered to the local mailbox)

I have successfully setup Qmail and can get smtp-auth to work with
checkpassword and the local shadow users.  I installed vpopmail enabling
roaming users, and mysql-auth.  I then set the vpopmail.mysql file to
use the DB on my main vpopmail server.  I can see it connect but it
returns an incorrect password response for the user and then sends the
email.  

My question is can vpopmail provide this type of functionality?

If not has anyone seen something that can?  I want to be able to have
smtp-auth query the vpopmail user DB.

Thanks
Ron Culler




Re: [vchkpw] Antivirus Scanner

2003-06-11 Thread Ron Culler
Qmail-Scanner works well and gives you the ability to incorporate SPAM
filtering


On Wed, 2003-06-11 at 11:37, Guillermo Villasana Cardoza wrote:
 Hi guys, do anyone know a good antivirus scanner that can be installed on linux
 but not directly in the machine with the email server? and that works with
 qmail+vpopmail?
 
 eg:
 
 
 Firewall---Antivirus Mail scanner---Qmail+Vpopmail Mailserver
 
 Thanks again
-- 
Ron Culler





Re: [vchkpw] vpopmail as a daemon

2003-02-24 Thread Ron Culler
How about this for an Idea. Since I believe that we all agree in the
power of Qmail and its superiority over the other systems. I think that
we leave that portion of Qmail and Vpopmail alone.

As a suggestion I think that Jesse did bring up some valid points when
it comes to the administration of Vpopmail.  I believe that some middle
ground exists on this issue.  Vpopmail could benefit from a more
flexible set of webbased tools.  

As a user of Qmailadmin I like the unified design and the security of
not having to run my web server as the vpopmail user(It lacks the ease
of integration into perl/php based web email frontends). On the other
hand the vpopmail.pm file gives me some of the flexibility that I want
when it comes to integration with a web based mail frontend but has the
security issues to contend with.  I have looked at the php vpopmail
extensions and while they have great flexibility you are forced to give
on security. Having a flexible/secure web based control tool would allow
you to have the speed/security of Qmail, the power/expandablity of
Vpopmail.  


I submit that having an admin daemon running on your Vpopmail server
would solve this. You could submit calls from the webased interface of
your choice giving you the flexibility of integrating Vpopmail
seamlessly into your web systems.

I agree that some of this functionallity exists with the Mysql
integration of Vpopmail 

1) the ability to change users passwords
2) Alias/Forward support with valias (This precludes the use of
qmailadmin for any alias/forward creation) as the .qmail file takes
precedence )
3) creation of new users (you either send them a welcome email or wait
for the first message to arrive for that user to create the dir
structure)

This is just my 2cents worth of input on the topic

Thanks



On Mon, 2003-02-24 at 03:38, Paul Theodoropoulos wrote:
 At 12:01 AM 02-24-2003, [EMAIL PROTECTED] wrote:
 
 Hi !!
 
   If you dislike NFS, then why did you go with qmail to begin with?
   That was the target for qmail.  To use NFS without file locking.
 
 I hope this never reaches djb since I'm 100% sure he never
 thougth qmail to be designed for Network Failure System... :-)
 
 he didn' t design qmail for NFS. however, he designed Maildir specifically 
 for NFS, and it's an integral part of qmail.
 
 qmail and NFS play together in harmony. production systems I built back in 
 1998 are still up and running (though i no longer work for that company), 
 running qmail on dual Sun E4500's, behind redundant Big/IP's, with the 
 filestore on clustered Netapps, NFS mounted over gigabit to the E4500's. 
 still running like a top. NFS has come a long way since qmail 0.91 was 
 released back in 1996.
 
 
 Paul Theodoropoulos
 http://www.anastrophe.com
 http://folding.stanford.edu
 The Nicest Misanthrope on the Net 
 
-- 
Ron Culler





Re: [vchkpw] vpopmail as a daemon

2003-02-23 Thread Ron Culler
I agree with that it would make life alot easier to integrate other
web-based email apps.  I currently use vpopmail with a mysql backend and
have compiled in the valias support.  This works great except that if I
use qmailadmin I loose the valias(mysql) support as it only creates a
.qmail file in the users Maildir. Having the ability to integrate the
functionality of qmailadmin into what ever web front-end that you wish
using the lang. of your choice would be great.




On Sun, 2003-02-23 at 13:03, Jesse Guardiani wrote:
 Greetings list,
 
 I'm sure people have considered this before, but I'd like to collect everyone's 
 thoughts on the idea I'm about to present:
 
 VPopMail as a daemon
 
 What does everyone think about the possibility of turning vpopmail into a daemon? 
 Complete with network ports and the like. It would
 allow for a much more distributed architecture, IMHO.
 
 Currently, if someone wants to run qmailadmin on a separate web server, they have to 
 create an NFS share, right?
 
 Wouldn't it make a lot of sense to provide a vpopmail network protocol that allows 
 connections from remote administrative utilities?
 
 Possibly even implement support for vpopmail clusters (although I'm thinking you'd 
 have to have a crazy amount of users to need a
 cluster! Vpopmail is pretty darn efficient.)
 
 Administrative programs like qmailadmin and vqadmin would benefit by not having to 
 be run on the primary mail server, but I highly
 doubt that the majority of web traffic comes from the admin CGIs.
 
 Programs like sqwebmail would benefit by not having to be recompiled every time 
 vpopmail is upgraded. The port protocol wouldn't
 change much between versions, and developers could maintain backward compatibility.
 
 Sqwebmail WOULDN'T be able to run on a separate server, as it accesses maildirs 
 directly, but at least administration, upgrades, and
 general package stability would likely improve a bit.
 
 Who knows. One might even be able to implement a maildir access protocol. But that 
 would probably just duplicate the functionality
 of the IMAP protocol.
 
 Can anyone else think of a good reason why vpopmail might benefit from being made 
 into a daemon?
 
 Can anyone think of a really good reason why it shouldn't? (Other than the time it 
 would take to code everything.)
 
 I'm just thinking aloud here, but I'd like to hear everyone's ideas on the matter.
 
 Thanks,
 
 --
 Jesse Guardiani, Systems Administrator
 WingNET Internet Services,
 P.O. Box 2605 // Cleveland, TN 37320-2605
 423-559-LINK (v)  423-559-5145 (f)
 http://www.wingnet.net
 
 We are actively looking for companies that do a lot of long
 distance faxing and want to cut their long distance bill by
 up to 50%.  Contact [EMAIL PROTECTED] for more info.
 
-- 
Ron Culler [EMAIL PROTECTED]




[vchkpw] password hash info

2003-02-18 Thread Ron Culler
I am writing a perl module that will change the users passwords after
verifing the old password.  What I'm looking for is the method used by
vpopmail to generate the password.  My goal is to create a perl version
of this.   


-- 
Ron Culler






[vchkpw] client gets multiple copies of email

2003-01-24 Thread Ron Culler
We are seeing a strange problem with some of our pop email clients. They
are seeing multiple copies of an email message appear in thier inbox
(outlook or outlook express) when only one copy of the email was ever in
the inbox to begin with.  This only appears to happen when receiving
mail from one particular source (running ComunigatePro 4.0) they send to
several different domains that we host and all appear to have the same
thing happening.  I have looked at the message and the headers and they
look normal. But the end-user seems to get the message over and
over(usually 4-20 copies) when the check the mailbox with POP3 

Running Redhat 7.3 vpopmail 5.2 

Any Ideas

-- 
Ron Culler






[vchkpw] Using vchkwp on a seperate box for smtp auth

2002-12-19 Thread Ron Culler
I am wanting to setup a seperate smtp auth server and use vchkpw to
query a vpopmail DB for user id and password. I then use the qmail
smtproutes command to foward that mail to a virus scanning gateway and
then to the final destination (the vpopmail users mailbox or external
MTA). My question is do I need to set anything different on the vpopmail
install other than pointing to the server running MySQL and the vpopmail
db? If not will this allow the users to just use the smtp auth settings
with thier email address and password?


-- 
Ron Culler







RE: [vchkpw] Spamassassin per user (MySQL)

2002-11-16 Thread Ron Culler
valias support in mysql will work. the current problem is that
qmailadmin does not support the valias mod for vpopmail. It only likes
.qmail files...

If you can write a webfront end that only writes to the mysql tables you
can get most of qmailadmins features - user creation/ mods (not deletes
-cant remove the mail dir)

Note: if you create a user in the sql table the directory is only
created when that user receives its first email

Ron


On Sat, 2002-11-16 at 09:26, Andy BIERLAIR wrote:
 First intersting thing would probably be the integration of .qmail files
 from each user into mysql and maybe even .qmail-default
 
 e.g.
 
 ~vpopmail/domain/postmaster/.qmail
 ~vpopmail/domain/any_user/.qmail
 
 My primary objective is getting rid of all the flat files (except the
 Maildir of course)
 
 
 
 Andy
 
 
 

**
The Firelan(tm) Virus Scanning Service has scanned this email for viruses, vandals 
and malicious content.
http://www.firelan.net
**





[vchkpw] valias questions

2002-11-11 Thread Ron Culler
Has valias (mysql) be integrated with qmailadmin yet?

I know its the wrong list but I'm posting to both to get a response..

Sorry 
Ron 



**
The Firelan(tm) Virus Scanning Service has scanned this email for viruses, vandals 
and malicious content.
http://www.firelan.net
**





[vchkpw] smtp auth only server questions

2002-09-09 Thread Ron Culler


Looking for a configuration that would allow users to use the vpopmail
virtual user and password as thier smtp auth credentials. The
configuration requires the smtp auth server to be separate from the pop
store (filtering, av scanning).

I don't want to use the auto tcp.smtp create that vpopmail normally uses
as this machine will only responed to valid auth requests and all others
will be rejected.  

I am able to get checkpassword to work with a locally created account
but this adds an unwanted process.

Has anyone done this ? if so what mods did you have to make to the vpop
install?

Thanks
Ron



**
The Firelan(tm) Virus Scanning Service has scanned this email for viruses, vandals 
and malicious content.
http://www.firelan.net
**




[vchkpw] (.mailfilter) and vpopmail

2002-09-03 Thread Ron Culler

Is there a way to delete a message when it arrives based on the body
content? I get 3-4 messages from a system that are part of is logging
and I don't need them. I use vpopmail and courier imap and haven't found
a way to auto delete these messages without touching the mail folder
with an email client.

Thanks
Ron



**
The Firelan(tm) Virus Scanning Service has scanned this email for viruses, vandals 
and malicious content.
http://www.firelan.net
**