[vchkpw] Do "hooks" exist for vpopmail or its lib?

2004-09-24 Thread Brian Feeny
Does vpopmail have any hooks available so that when someone adds a 
domain or removes a domain, I can fire off
an external script?  qmailadmin had some hooks and they are nice, but I 
need to take some actions whenever a domain
is added. I am going to have techs adding domains via vqadmin.

Since I didn't know of any hooks, I have cron just looking in each 
domains directory (every 15 min) and if it doesn't see the files I want 
to be there, then it adds them.  But I would rather have a mechinism 
that worked more like a trigger/hook.

Brian
-
Brian Feeny, CCIE #8036, CISSP
Network Engineer
ShreveNet Inc.


PGP.sig
Description: This is a digitally signed message part


Re: [vchkpw] Tuning mysql for vpopmail

2004-09-24 Thread Ken Jones
On Friday 24 September 2004 06:48 pm, Juan Enciso Condeña wrote:
> Hello friends.
>
> I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha
> server. It has 1GB of memory with 2 proccesors.

Definitly upgrade to Tom's latest release. The 5.2.1 release is good but the
new release is much better.

>
> I am having problem with mysql at the hours peak. This show me the
> qmail-send log
>
> 2004-09-24 17:32:06.263335500 delivery 96079: failure:
> vmysql:_sql_error[3]:_Lost_connection_to_My
> SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/
The "Lost connection" message is from mysql.

>
> I have high concurrency (log qmail-send):
> @40004154ae4c2cd0fbfc status: local 10/100 remote 150/255
>
> My mysql setup is for default ( I haven't  /etc/my.cnf created !!!)
You are either using more mysql connections than the default or your
mysql server is over loaded.

> Somebody have a configuration of  mysql for high concurrency and that work
> with vpopmail?
I agree with Rick, use the large configuration file. 
Unless you are running a mysql cluster I recommend commenting out the 
"log bin" line. 

You might want to use InnoDB tables, which I think are the newer ones,
then uncomment all the inno_d lines. 

> Is possible limit vpopmail for don't use more of 100 connections? 
I think the default max connections are 100. So just give more to mysql,
like Rick suggests.

> Because it reboot my mysql daemon
I'm not surprised. Hopefully the max_connections are your problem and 
everything will run smooth. If mysql is still lagging you will need to 
consider a cluster of servers and distributed mysql.

> Should I think use postgresql instead of mysql?
First, fix the max connections. mysql should do fine.

I wonder is there any documentation on how to setup email/mysql/nfs
in a cluster? I would be willing to contribute text.

Ken Jones


[vchkpw] How are you all using maildrop with qmailadmin etc?

2004-09-24 Thread Brian Feeny
We use maildrop so that we can do some fancy mail routing for our 
customers.  For all of our domains
we put a .qmail-default file that references a .mailfilter file.

I know alot of you seem to use maildrop, but if you do, how do you have 
it play nice with qmailadmin?  qmailadmin wants to clobber 
.qmail-default file when the domain admin changes catchall values for 
example.  I wanted it so that if they selected "normal" (rather than 
catchall bounce or catchall delete, or catchall forward), then it puts 
my .qmail-default in place.  How is this accomplished?

Brian
-
Brian Feeny, CCIE #8036, CISSP
Network Engineer
ShreveNet Inc.


PGP.sig
Description: This is a digitally signed message part


Re: [vchkpw] .dir-control format

2004-09-24 Thread Brian Feeny
Dave,
First thanks alot for posting that link, I appreciate it.  I am not in  
fact using Mysql, perhaps you confused me with someone else.
I do plane on moving to a mysql setup, but I need to do so with as  
little downtime as possible.  It seems like there are many
different steps, like putting .dir-control in mysql, then putting the  
vpasswd's in mysql...isn't there something else that is usually
put in mysql, like maildir quota files?

Brian
On Sep 24, 2004, at 3:44 PM, Dave Goodrich wrote:
Brian Feeny wrote:
Can someone post the .dir-control format (the format of the file, and  
 what each value represents)?
This is a close as I have gotten, though I have not updated any  
further, it seems to be working fine.

http://www.mail-archive.com/[EMAIL PROTECTED]/msg19052.html
You might want to read all the thread for context. Once I get some  
other work done I intend to get back to it and write up all I have  
discovered.

also if you have a hosed .dir-control structure, how can you rebuild   
it, so that the .dir-control files are correct?
If you use sql, your dir-control is in there, not in files. I have a  
perl script that will repair your sql table, for those domains that  
have an accurate .dir-control file. I did as I converted my domains  
into MySQL.

if a .dir-control got deleted, how would that be fixed?
In your earlier post you said you used MySQL, if so you do not need a  
.dir control file, and vpopmail will not create one. All dir-control  
info will be in a sql table "dir_control".

DAve
Brian
-- 
-- --
Brian Feeny, CCIE #8036, CISSPe: [EMAIL PROTECTED]
Network Engineer   p: 318.213.4709
ShreveNet Inc. f: 318.221.6612
--
Systems Administrator
http://www.tls.net
Get rid of Unwanted Emails...get TLS Spam Blocker!


PGP.sig
Description: This is a digitally signed message part


Re: [vchkpw] Tuning mysql for vpopmail

2004-09-24 Thread Rick Macdougall

Juan Enciso Condeña wrote:
Hello friends.
I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha server.
It has 1GB of memory with 2 proccesors.
I am having problem with mysql at the hours peak. This show me the
qmail-send log
2004-09-24 17:32:06.263335500 delivery 96079: failure:
vmysql:_sql_error[3]:_Lost_connection_to_My
SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/
Hi,
I use the my-large.cnf (copied to /etc/my.cnf) and I add the following 
line under the [mysqld] group

set-variable = max_connections=500
Works for me (On quite a few servers).
Regards,
Rick


[vchkpw] Tuning mysql for vpopmail

2004-09-24 Thread Juan Enciso Condeña
Hello friends.

I have installed vpopmail-5.2.1 + mysql-4.013 running on HP-UX alpha server.
It has 1GB of memory with 2 proccesors.

I am having problem with mysql at the hours peak. This show me the
qmail-send log

2004-09-24 17:32:06.263335500 delivery 96079: failure:
vmysql:_sql_error[3]:_Lost_connection_to_My
SQL_server_during_query/Sorry,_no_mailbox_here_by_that_name._(#5.1.1)/

I have high concurrency (log qmail-send):
@40004154ae4c2cd0fbfc status: local 10/100 remote 150/255

My mysql setup is for default ( I haven't  /etc/my.cnf created !!!)
Somebody have a configuration of  mysql for high concurrency and that work
with vpopmail?
Is possible limit vpopmail for don't use more of 100 connections? Because it
reboot my mysql daemon
Should I think use postgresql instead of mysql?

Thanks for your suggestions

Juan



Re: [vchkpw] .dir-control format

2004-09-24 Thread Dave Goodrich
Brian Feeny wrote:
Can someone post the .dir-control format (the format of the file, and  
what each value represents)?

This is a close as I have gotten, though I have not updated any further, 
it seems to be working fine.

http://www.mail-archive.com/[EMAIL PROTECTED]/msg19052.html
You might want to read all the thread for context. Once I get some other 
work done I intend to get back to it and write up all I have discovered.

also if you have a hosed .dir-control structure, how can you rebuild  
it, so that the .dir-control files are correct?
If you use sql, your dir-control is in there, not in files. I have a 
perl script that will repair your sql table, for those domains that have 
an accurate .dir-control file. I did as I converted my domains into MySQL.

if a .dir-control got deleted, how would that be fixed?
In your earlier post you said you used MySQL, if so you do not need a 
.dir control file, and vpopmail will not create one. All dir-control 
info will be in a sql table "dir_control".

DAve
Brian
 
--
Brian Feeny, CCIE #8036, CISSPe: [EMAIL PROTECTED]
Network Engineer   p: 318.213.4709
ShreveNet Inc. f: 318.221.6612
--
Systems Administrator
http://www.tls.net
Get rid of Unwanted Emails...get TLS Spam Blocker!


[vchkpw] suggestions on this error

2004-09-24 Thread Remo Mattei



success: 
name:___remo/passwd:_$1$z8tkqJaK$OpE5RB0s9JXXZ/eQYeuTu./clear_passwd:_spoleto/uid:0/gid:0/flags:__0/gecos:_remo/limits:_No_user_limits_set./dir:___/home/vpopmail/domains/rm2.it/remo/quota:_NOQUOTA/usage:_NOQUOTA/account_created:_Sun_Sep_19_15:35:28_2004/last_auth:_Never_logged_in/did_0+0+1/
 
Hello guys can any suggest me what 
happen here? the user will not get mail. 
 
Thanks, 
 
Remo


[vchkpw] simscan

2004-09-24 Thread Itamar Reis Peixoto
when i am set the qmailqueue to simscan

451 unable to exec qq (#4.3.0)




Itamar Reis Peixoto
Analista Consultor
TreyNet Consultoria - Uberlândia
Tel : + 55 34 3231 0598
Cel:  +55 38 9107 1250
http://www.treynet.com.br



[vchkpw] .dir-control format

2004-09-24 Thread Brian Feeny
Can someone post the .dir-control format (the format of the file, and  
what each value represents)?

also if you have a hosed .dir-control structure, how can you rebuild  
it, so that the .dir-control files are correct?
if a .dir-control got deleted, how would that be fixed?

Brian
 
--
Brian Feeny, CCIE #8036, CISSP	e: [EMAIL PROTECTED]
Network Engineer   			p: 318.213.4709
ShreveNet Inc. 			f: 318.221.6612


PGP.sig
Description: This is a digitally signed message part


[vchkpw] hashing of domain directories

2004-09-24 Thread Brian Feeny
Doesnt vpopmail by default start putting domains into a hashed  
structure after 100 or so domains?
My usernames are hashing, but my domains under  
/home/cust/vpopmail/domains are all being put
into that directory, vadddomain is not branching out into other dirs.   
Any idea what that could be?

Brian
 
--
Brian Feeny, CCIE #8036, CISSP	e: [EMAIL PROTECTED]
Network Engineer   			p: 318.213.4709
ShreveNet Inc. 			f: 318.221.6612


PGP.sig
Description: This is a digitally signed message part


RE: [vchkpw] Quota

2004-09-24 Thread Rainer Duffner
Am Fr, den 24.09.2004 schrieb Edward Neville um 17:34:
> > -Original Message-
> > From: Tom Collins [mailto:[EMAIL PROTECTED] 
> > Sent: 24 September 2004 15:02
> > To: [EMAIL PROTECTED]
> > Subject: Re: [vchkpw] Quota
> > 
> > Vpopmail has domain quotas, but they're broken.  Even if/when they do 
> > work, they add a lot of load since vdelivermail has to calculate the 
> > domain's disk usage every time a message is delivered.
> > 
> > I didn't write the original implementation, I don't use them myself, 
> > and I'm not particularly interested in finding the problem and fixing 
> > it.
> 
> Ok! I have a large number of domains to administer (6000 ish). I Just
> stumbled upon the high disk usage that one domain had through having many
> accounts of 50meg mailboxes.

Hehe. I've now created a little script:

[EMAIL PROTECTED] cat /root/bin/top50.sh
#!/bin/sh
/root/bin/space.sh |sort -u|xargs du -d 0|sort -n -r |head -n 50

where space.sh contains:

#!/bin/sh
 for i in  `~vpopmail/bin/vdominfo -n | egrep -v ^$`
  do
 ~vpopmail/bin/vuserinfo -d -D $i
  done

That should at least match the topX accounts.
I don't know how well it scales, though. 

> Would a quota filesystem be a big overhead? If not, can you suggest a
> implementation for locking a domain to a quota?

OS Quotas is the only way to go, I'm told. 

> If you have any questions or queries please let me know.


I think you must create am OS-group and add the new domain with -g
GID_of_the_new_group.
Then you can use group-quotas to limit the disk-usage of the files of
this particular group.

 
I still have to try this myself- the problem is, there's no GUI to do
that, vqadmin doesn't handle GIDs. 



Rainer
-- 
===
~ Rainer Duffner - [EMAIL PROTECTED] ~
~   Freising - Munich - Germany   ~
~Unix - Linux - BSD - OpenSource - Security   ~
~  http://www.ultra-secure.de/~rainer/pubkey.pgp  ~
===



Re: [vchkpw] simscan quesiton: error

2004-09-24 Thread Payal Rathod
On Fri, Sep 24, 2004 at 07:01:20PM +0300, Kiril Todorov wrote:
> chmod --reference /var/qmail/bin/qmail-queue \
> /var/qmail/bin/simscan /var/qmail/simscan
> 
> chown --reference /var/qmail/bin/qmail-queue \
> /var/qmail/bin/simscan /var/qmail/simscan

Why do I need to have permission of qmail-queue? 
# ls -l qmail-queue
-rws--x--x  1 qmailq qmail 15912 Sep 24 11:38 qmail-queue

I believe that simscan appear at smtp level i.e. before the mail hits
the queue.

-Payal


Re: [vchkpw] simscan quesiton: error

2004-09-24 Thread Bastiaan van der Put
For your information, i don't have the problem someone else has.
And there's no need to change the owner of /var/qmail/bin/qmail-queue
Bas
At 18:01 9/24/2004, you wrote:
Bastiaan van der Put wrote:
# ls -l simscan
-rwxr-xr-x  1 qmaild nofiles 6136 Sep 24 11:25 simscan
chmod --reference /var/qmail/bin/qmail-queue \
/var/qmail/bin/simscan /var/qmail/simscan
chown --reference /var/qmail/bin/qmail-queue \
/var/qmail/bin/simscan /var/qmail/simscan

--
+---+
| Kiril Todorov  <+>  System::Network Administrator |
+---+
| /* waiting... dreaming... wishing... */   |
+---+



Re: [vchkpw] what appears to be mysql errors inside.... and other questions

2004-09-24 Thread Dave Goodrich
Grimes, David wrote:
-Original Message-
From: Dave Goodrich [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 23, 2004 4:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] what appears to be mysql errors inside and other
questions

Grimes, David wrote:

config to better equip it for things? Switches, etc... 
What do you have now for hardware?
[DG] Athlon 1700 512 60gig ide drive 
Should be plenty with a stock qmail-vpopmail-mysql-SA. Not sure how much 
qmail-scanner requires as far as resources. Perl can get hungry. I've 
processed twice as much on a Sparc 20 with dual 125mhz and 512 ram. I 
didn't run qmail-scanner and a AV solution though..


The fellow who could convert one of the many perl qmailqueue 
replacements to C, would likely be carried about town on the shoulders 
of a grateful crowd.


What version of SA are you running?
[DG] SA is 2.6.3
They should have the problems sorted out with SA 3.0.0 now, seems most 
of the traffic I have seen is people not thoroughly reading the docs 
before upgrading. The upgrade will also give you SURBL, which will help 
more than anything else I have tried.

What extra rules are your running in SA?
[DG] I used the out of the box rule set. Since reading your message I've
removed the RBL and razor checks/usage.
Did you add your RBLs into qmail-smtpd? (adding rblsmtpd to your run file)
How many messages do you normally handle a day?
[DG] this machine sees ~25k messages a day
I have found that when getting blasted to the extent that it becomes a 
hardware issue, turning off SA until you can get the queue cleared helps 
quite a bit.
[DG] I eventually did that but for about 4-5 hours my load avg was 400-500
I've got the screen shots to prove it ;) Eventually I blackholed my mx
record which allowed my box to catch up on already delievered mail and then
removed qmail scanner and let everything through un processed.
Painfull I know, but sometimes it is the only way ;^)
If you are doing Razor lookups in SA, stop. I've not found Razor to make 
a difference in spam caught compared to to the network and system 
resources it consumes.

If you are doing RBL lookups in SA, stop. RBL lookups are considerably 
faster with qmail and saves you having to process a message that you 
later would dump when it gets to SA anyway. Example; I move 40k to 50k 
inbound messages a day, 65k+ of those I dropped at the smtp level via 
qmail. If I had used RBL lookups in SA I would have over doubled my SA load.

Number two, this
message appeared quite often last night. What exactly is it telling me? 
It has been my experience,
someone/anyone correct me if I am wrong,
but you A) need to upgrade to 5.4.6 as there were changes to the SQL 
code or B) your MySQL connection was timing out.

It seemed to me that those errors went away here when I gave MySQL more 
resources. Of course, YMMV, and I could be just a nut ;^)

DAve
[DG] thanks for the input! David
Your welcome.
DAve

I realize this email is vague and poorly worded so any comments,
questions,
and suggestions to further the discussion would be greatly appreciated.

--
Systems Administrator
http://www.tls.net
Get rid of Unwanted Emails...get TLS Spam Blocker!


Re: [vchkpw] simscan quesiton: error

2004-09-24 Thread Kiril Todorov
Bastiaan van der Put wrote:
# ls -l simscan
-rwxr-xr-x  1 qmaild nofiles 6136 Sep 24 11:25 simscan
chmod --reference /var/qmail/bin/qmail-queue \
/var/qmail/bin/simscan /var/qmail/simscan
chown --reference /var/qmail/bin/qmail-queue \
/var/qmail/bin/simscan /var/qmail/simscan

--
+---+
| Kiril Todorov  <+>  System::Network Administrator |
+---+
| /* waiting... dreaming... wishing... */   |
+---+


[vchkpw] Vpopmail Randomly Ignoring Quotas?

2004-09-24 Thread buffalo
Greetings,

I've run into a strange situation with vpopmail 1.0.6, where it seems to
be ingnoring virtual domain quota limits for some mailboxes.

For example, in one case, I found in a user's Maildir the normal 
'maildirsize' file with the expect "1000S" figure in it, yet this 
user's box is over 700 megs (yes megabytes) in size(!).

Vqadmin is showing limits on individual users when I look at them.

Must .qmailadmin-limits have the default quota for a given domain for
individual user limits to work, or are these settings independent?

TIA,

--Duncan



RE: [vchkpw] Quota

2004-09-24 Thread Edward Neville
> -Original Message-
> From: Tom Collins [mailto:[EMAIL PROTECTED] 
> Sent: 24 September 2004 15:02
> To: [EMAIL PROTECTED]
> Subject: Re: [vchkpw] Quota
> 
> Vpopmail has domain quotas, but they're broken.  Even if/when they do 
> work, they add a lot of load since vdelivermail has to calculate the 
> domain's disk usage every time a message is delivered.
> 
> I didn't write the original implementation, I don't use them myself, 
> and I'm not particularly interested in finding the problem and fixing 
> it.

Ok! I have a large number of domains to administer (6000 ish). I Just
stumbled upon the high disk usage that one domain had through having many
accounts of 50meg mailboxes.

Would a quota filesystem be a big overhead? If not, can you suggest a
implementation for locking a domain to a quota?

If you have any questions or queries please let me know.

--
Regards,
Ed. 


Re: [vchkpw] simscan quesiton: error

2004-09-24 Thread Bastiaan van der Put
Check the permissions on the working dir too.
Bas
At 17:25 9/24/2004, you wrote:
On Fri, Sep 24, 2004 at 09:41:09AM -0500, Ken Jones wrote:
> If you are not running qmail-smtpd as root you may need to
> change the ownership of simscan to match qmail-smtpd.
I run qmail-smtpd as qmaild and now I have,
# ls -l simscan
-rwxr-xr-x  1 qmaild nofiles 6136 Sep 24 11:25 simscan
Still the same problem. I am running Mandrake 10.0
With warm regards,
-Payal



Re: [vchkpw] The low-down on the valias feature

2004-09-24 Thread Dave Goodrich
Tom Collins wrote:
On Sep 24, 2004, at 7:25 AM, Dave Goodrich wrote:
I've read all the posts in the archive afterching on "valias", a lot 
of posts, and I think my assumptions are correct. I would like to know 
if there are any limitations I should be aware of.

--enable-valias configures vpopmail to store .qmail-alias files in a 
table.  It does not affect the .qmail files in POP/IMAP user directories.

Currently, it can only properly handle email forwarding or calling a 
single program.  In the initial design, there wasn't a method to ensure 
the processing order of alias entries.  So, any .qmail-alias file in 
which the execution order is important (like spam scanning), will not 
work with valiases.
This answers my most pressing question, thank you.
It should be a simple fix -- add an auto-incrementing sequence column to 
the table and sort the results by it.  Entries will always be returned 
in the order they were added. The only problem is we need an easy way
to update existing valias tables to add the column.  
Yes, but if there are no current multi line entries in existing valias 
tables, then could not all rows be altered to have the column with a 
value of 1?

More complex .qmail 
files will be difficult to edit/manage if stored in the valias table.
Yes, I had thought so as well, which is why I asked. With command line 
tools this really could be nothing more than add, view, delete an entry.

You can store aliases, forwards and autoresponders in the valias table. 
 ezmlm mailing lists need to stay in .qmail files so ezmlm-make can 
modify them whenever the list's settings are changed.  .qmail-default 
remains as a .qmail file so qmail-local can find it and pass the message 
on to vdelivermail.
This is the one I couldn't find a hint of in the archives! I can use 
both valias and .qmail files within the same domain? (ezmlm and my spam 
script are the biggest concerns)

Provided I can have both, which hold precedence? If there is a 
.qmail- file, and a  entry in valias, which is run and which 
is not?

Thank you,
DAve
--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/

--
Systems Administrator
http://www.tls.net
Get rid of Unwanted Emails...get TLS Spam Blocker!


RE: [vchkpw] what appears to be mysql errors inside.... and other questions

2004-09-24 Thread Grimes, David


-Original Message-
From: Dave Goodrich [mailto:[EMAIL PROTECTED] 
Sent: Thursday, September 23, 2004 4:25 PM
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] what appears to be mysql errors inside and other
questions

Grimes, David wrote:
> Hello all, 
> 
> New user/abuser here...
> 
> 1.   Last night, due to a problem with a corporate mail server, my
mail
> server got flooded with ~20k emails. It tried like heck to chew through
them
> but the poor little machine just wasn't havin' it. My setup is a gentoo
box
> running vpopmail, qmail, qmail-scanner, spamassassin, -prot, and
courier-et
> al. with the latest packages as of yesterday. I have two questions 1.
> Outside of better hardware what are some things I should do to the
software
> config to better equip it for things? Switches, etc... 

What do you have now for hardware?
[DG] Athlon 1700 512 60gig ide drive 

What version of SA are you running?
[DG] SA is 2.6.3
What extra rules are your running in SA?
[DG] I used the out of the box rule set. Since reading your message I've
removed the RBL and razor checks/usage.

How many messages do you normally handle a day?
[DG] this machine sees ~25k messages a day

I have found that when getting blasted to the extent that it becomes a 
hardware issue, turning off SA until you can get the queue cleared helps 
quite a bit.
[DG] I eventually did that but for about 4-5 hours my load avg was 400-500
I've got the screen shots to prove it ;) Eventually I blackholed my mx
record which allowed my box to catch up on already delievered mail and then
removed qmail scanner and let everything through un processed.

If you are doing Razor lookups in SA, stop. I've not found Razor to make 
a difference in spam caught compared to to the network and system 
resources it consumes.

If you are doing RBL lookups in SA, stop. RBL lookups are considerably 
faster with qmail and saves you having to process a message that you 
later would dump when it gets to SA anyway. Example; I move 40k to 50k 
inbound messages a day, 65k+ of those I dropped at the smtp level via 
qmail. If I had used RBL lookups in SA I would have over doubled my SA load.


> Number two, this
> message appeared quite often last night. What exactly is it telling me? 

It has been my experience,

someone/anyone correct me if I am wrong,

but you A) need to upgrade to 5.4.6 as there were changes to the SQL 
code or B) your MySQL connection was timing out.

It seemed to me that those errors went away here when I gave MySQL more 
resources. Of course, YMMV, and I could be just a nut ;^)

DAve
[DG] thanks for the input! David
> 
> I realize this email is vague and poorly worded so any comments,
questions,
> and suggestions to further the discussion would be greatly appreciated.
> 
>  
> 
> Thanks
> 
> DG
> 
>  
> 
> @4000415240cb09be3594 delivery 3013: success:
>
vmysql:_sql_error[1]:_Can't_create_database_'vpopmail'._Database_exists/vmys
>
ql:_sql_error[3]:_No_Database_Selected/could_not_create_limits_table_CREATE_
>
TABLE_limits_(_domain_CHAR(64)_PRIMARY_KEY,___maxpopaccounts___I
>
NT(10)_NOT_NULL_DEFAULT_-1,___maxaliases___INT(10)_NOT_NULL_
>
DEFAULT_-1,___maxforwards__INT(10)_NOT_NULL_DEFAULT_-1,_
>
__maxautorespondersINT(10)_NOT_NULL_DEFAULT_-1,___maxmailinglist
>
s__INT(10)_NOT_NULL_DEFAULT_-1,___diskquotaINT(1
>
2)_NOT_NULL_DEFAULT_0,___maxmsgcount__INT(12)_NOT_NULL_DEFAU
>
LT_0,___defaultquota_INT(12)_NOT_NULL_DEFAULT_0,___defau
>
ltmaxmsgcount___INT(12)_NOT_NULL_DEFAULT_0,___disable_pop___
>
___TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_imap_TINYINT(1)_
>
NOT_NULL_DEFAULT_0,___disable_dialup___TINYINT(1)_NOT_NULL_DEFAU
>
LT_0,___disable_passwordchanging_TINYINT(1)_NOT_NULL_DEFAULT_0,___di
>
sable_webmail__TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_relay___
>
_TINYINT(1)_NOT_NULL_DEFAULT_0,___disable_smtp_TINYI
>
NT(1)_NOT_NULL_DEFAULT_0,___perm_account_TINYINT(2)_NOT_NULL
>
_DEFAULT_0,___perm_alias___TINYINT(2)_NOT_NULL_DEFAULT_0,___
>
perm_forward_TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_autor
>
esponder___TINYINT(2)_NOT_NULL_DEFAULT_0,___perm_maillist___
>
_TINYINT(4)_NOT_NULL_DEFAULT_0,___perm_quota___TINYINT(2)_NO
>
T_NULL_DEFAULT_0,___perm_defaultquotaTINYINT(2)_NOT_NULL_DEFAULT
>
_0_)/vmysql:_sql_error[p]:_No_Database_Selected/user_does_not_exist,_but_wil
> l_deliver_to_/var/vpopmail/domains/thegrimesfamily.net/test//did_0+0+1/
> 
> 

-- 
Systems Administrator
http://www.tls.net
Get rid of Unwanted Emails...get TLS Spam Blocker!


Re: [vchkpw] simscan quesiton: error

2004-09-24 Thread Payal Rathod
On Fri, Sep 24, 2004 at 09:41:09AM -0500, Ken Jones wrote:
> If you are not running qmail-smtpd as root you may need to
> change the ownership of simscan to match qmail-smtpd.

I run qmail-smtpd as qmaild and now I have,
# ls -l simscan
-rwxr-xr-x  1 qmaild nofiles 6136 Sep 24 11:25 simscan

Still the same problem. I am running Mandrake 10.0

With warm regards,
-Payal


Re: [vchkpw] chkuser 2.0

2004-09-24 Thread Ken Jones
On Thursday 23 September 2004 05:16 pm, tonix (Antonio Nati) wrote:
> chkuser 2.0 has been released.
>
> New version is available on: http://www.interazioni.it/opensource/chkuser.
>
> These are the most evident changes:
>  - new design, a lot more easy to install and update
>  - extended logging
>  - flexible and powerful tarpitting
>  - quota checking
>  - Makefile working with every vpopmail database (cdb, MySQL, LDAP,
> Postgres, etc.)
>  - a lot of chkuser settings added
>  - change of name, from chkusr to chkuser.
>
> 2.0 has been tested and put in production for more than one month, than
> other people has tested it before this public release (thanks to Juergen
> Kendzorra, Remo Mattei, Bill Shupp, Machiel Kuitert).
>
> As usual, test it deeply before putting on production system.

Excellent work! I can't wait to try it out. 
Nice going!

Ken Jones


[vchkpw] The low-down on the valias feature

2004-09-24 Thread Tom Collins
On Sep 24, 2004, at 7:25 AM, Dave Goodrich wrote:
I've read all the posts in the archive afterching on "valias", a lot 
of posts, and I think my assumptions are correct. I would like to know 
if there are any limitations I should be aware of.
--enable-valias configures vpopmail to store .qmail-alias files in a 
table.  It does not affect the .qmail files in POP/IMAP user 
directories.

Currently, it can only properly handle email forwarding or calling a 
single program.  In the initial design, there wasn't a method to ensure 
the processing order of alias entries.  So, any .qmail-alias file in 
which the execution order is important (like spam scanning), will not 
work with valiases.

It should be a simple fix -- add an auto-incrementing sequence column 
to the table and sort the results by it.  Entries will always be 
returned in the order they were added.  The only problem is we need an 
easy way to update existing valias tables to add the column.  More 
complex .qmail files will be difficult to edit/manage if stored in the 
valias table.

You can store aliases, forwards and autoresponders in the valias table. 
 ezmlm mailing lists need to stay in .qmail files so ezmlm-make can 
modify them whenever the list's settings are changed.  .qmail-default 
remains as a .qmail file so qmail-local can find it and pass the 
message on to vdelivermail.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] simscan quesiton: error

2004-09-24 Thread Ken Jones
On Friday 24 September 2004 01:16 am, Payal Rathod wrote:
> Hi,
> Since there is no official list for simscan and this was the list where
> few simscan questions were asked and answered, I am taking the liberty of
> asking it here.
> I have simscan-1.0 which i installed by,
> ./configure
> make
> make install-strip
>
> In my smtpd/run file I have,
> export QMAILQUEUE="/var/qmail/bin/simscan"
>
> But when I try to send a message I get,
> 451 mail server temporarily rejected message (#4.3.0)
>
> I tried to increase softlimit but still the same error.
> Can someone tell what is wrong?

If you are not running qmail-smtpd as root you may need to
change the ownership of simscan to match qmail-smtpd.

Ken Jones


Re: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL

2004-09-24 Thread Dave Goodrich
Tom Collins wrote:
If you're using the valias table with PostgreSQL or MySQL, please take  
a look at the following patch:
Possibly you would be the man to answer this question for me?
http://www.mail-archive.com/[EMAIL PROTECTED]/msg19410.html
I've read all the posts in the archive afterching on "valias", a lot of 
posts, and I think my assumptions are correct. I would like to know if 
there are any limitations I should be aware of.

Thanks,
DAve
http://sourceforge.net/tracker/index.php? 
func=detail&aid=1033801&group_id=85937&atid=577800

It should make valiases actually work for PostgreSQL (they didn't  
before now).

Also, the old code didn't work if you had Maildir delivery lines in the  
valias table.

If you fall into either of those categories, please try the patch and  
let me know whether it works for you.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/
--
Systems Administrator
http://www.tls.net
Get rid of Unwanted Emails...get TLS Spam Blocker!


Re: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL

2004-09-24 Thread Tom Collins
It should apply to 5.4.7 or 5.4.6.  It might even work for any 5.4.x  
release.

On Sep 23, 2004, at 10:20 PM, Remo Mattei wrote:
so should I apply this to the 5.4.7 then?
 
Remo
- Original Message -
 From: Tom Collins
To: vpopmail list
Sent: Thursday, September 23, 2004 10:37 PM
Subject: [vchkpw] Patch for problems with valiases and PostgreSQL/MySQL
If you're using the valias table with PostgreSQL or MySQL, please take  
a look at the following patch:

http://sourceforge.net/tracker/index.php? 
func=detail&aid=1033801&group_id=85937&atid=577800

It should make valiases actually work for PostgreSQL (they didn't  
before now).

Also, the old code didn't work if you had Maildir delivery lines in  
the valias table.

If you fall into either of those categories, please try the patch and  
let me know whether it works for you.

--
Tom Collins - [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/
 Info on the Sniffter hand-held Network Tester: http://sniffter.com/
--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] Quota

2004-09-24 Thread Tom Collins
On Sep 24, 2004, at 6:02 AM, Edward Neville wrote:
How can I limit the domain's quota to X bytes rather than limiting a 
user's
disk as I would prefer to have our customers set up a large number of 
mail
boxes but not letting the domain go over a given size.
Vpopmail has domain quotas, but they're broken.  Even if/when they do 
work, they add a lot of load since vdelivermail has to calculate the 
domain's disk usage every time a message is delivered.

I didn't write the original implementation, I don't use them myself, 
and I'm not particularly interested in finding the problem and fixing 
it.

--
Tom Collins  -  [EMAIL PROTECTED]
QmailAdmin: http://qmailadmin.sf.net/  Vpopmail: http://vpopmail.sf.net/
Info on the Sniffter hand-held Network Tester: http://sniffter.com/


Re: [vchkpw] Courier-Imap with Vpopmail help

2004-09-24 Thread dvruiz
I noticed that you set the following:

  AUTHMODULES="authvchkpw"

Did you also set what is listed below:

Edit /usr/lib/courier-imap/etc/authdaemonrc
Change authmodulelist="..." to authmodulelist="authvchkpw"
Edit /usr/lib/courier-imap/etc/imapd
Change 'IMAPDSTART=NO' to 'IMAPDSTART=YES'
Edit /usr/lib/courier-imap/etc/imapd-ssl
Change 'IMAPDSSLSTART=NO' to 'IMAPDSSLSTART=YES'




> Hey all,
>
>
> I've just moved to qmail with vpopmail and i'm following this doc
>
> http://www.qmailrocks.org/
>
> Now i'm tring to get courier-imap working correctly, when i try  pop3
> access i
> login fine, however imap is a different story
>
> kristine:~# telnet localhost 143
> Trying 127.0.0.1...
> Connected to localhost.localdomain.
> Escape character is '^]'.
> * OK [CAPABILITY IMAP4rev1 UIDPLUS CHILDREN NAMESPACE
> THREAD=ORDEREDSUBJECT
> THREAD=REFERENCES SORT QUOTA IDLE ACL ACL2=UNION STARTTLS] Courier-IMAP
> ready.
> Copyright 1998-2004 Double Precision, Inc.  See COPYING for distribution
> information.
> a login [EMAIL PROTECTED] kilo22
> a NO Login failed.
>
>
>
> This is in /var/log/mysql/mysql.log
>
> This is the table return
>
> mysql> select pw_name, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir,
> pw_shell ,
> pw_clear_passwd from wtfhax_com where pw_name = "tristram";
> +--++++++--+-+
> | pw_name | pw_passwd | pw_uid | pw_gid | pw_gecos | pw_dir | pw_shell |
> pw_clear_passwd |
> +--++++++--+-+
> | tristram | $1$CNMfwBu0$2JeNEmXhQPH8kTUCOMBii. | 0 | 8 | Tristram+Cheer |
> /home/vpopmail/domains/wtfhax.com/tristram | NOQUOTA | realpass |
> +--++++++--+-+
> 1 row in set (0.00 sec)
>
>
> I've changed my /etc/courier/imapd file to
>
> AUTHMODULES="authvchkpw"
>
>
> I run a debian system and i'm pulling my hair out, what am i doing wrong
>
>
> Is anyone able to help?
>



[vchkpw] Quota

2004-09-24 Thread Edward Neville
Hello all,

I am currently using a qmail/vpopmail setup and the vqadmin control panel. I
would like to know a bit more about how the quota system works. I currently
set the 'quota size' to 50,000,000 bytes.

How can I limit the domain's quota to X bytes rather than limiting a user's
disk as I would prefer to have our customers set up a large number of mail
boxes but not letting the domain go over a given size.

--
Regards,
Ed. 


Re: [vchkpw] strace on stunnel

2004-09-24 Thread Kiril Todorov
Remo Mattei wrote:
here is the error which I am not sure of it
read(6, "-ERR aack, child crashed\r\n", 16384) = 26
Can you include the log for the child with pid 16384 at that time?:)
--
+---+
| Kiril Todorov  <+>  System::Network Administrator |
+---+
| /* waiting... dreaming... wishing... */   |
+---+


Re: [vchkpw] chkuser 2.0 - doc typos

2004-09-24 Thread tonix (Antonio Nati)
Of course, there are a lot of typos and errors (all docs have been written 
in few days and, first of all, I'm not english motherlanguage), so thanks 
anyone for warning me:  write directly to [EMAIL PROTECTED]

Ciao,
Tonino
At 23/09/2004 23/09/2004 -0600, you wrote:
Tonix cambia questo
who's sending to who
a
who's sending to whom
Ciao,
Remo
- Original Message -
From: "tonix (Antonio Nati)" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, September 23, 2004 4:16 PM
Subject: [vchkpw] chkuser 2.0
>
> chkuser 2.0 has been released.
>
> New version is available on: http://www.interazioni.it/opensource/chkuser.
>
> These are the most evident changes:
>  - new design, a lot more easy to install and update
>  - extended logging
>  - flexible and powerful tarpitting
>  - quota checking
>  - Makefile working with every vpopmail database (cdb, MySQL,
LDAP,
> Postgres, etc.)
>  - a lot of chkuser settings added
>  - change of name, from chkusr to chkuser.
>
> 2.0 has been tested and put in production for more than one month, than
> other people has tested it before this public release (thanks to Juergen
> Kendzorra, Remo Mattei, Bill Shupp, Machiel Kuitert).
>
> As usual, test it deeply before putting on production system.
>
> Tonino
>
>
> 
>  [EMAIL PROTECTED]Interazioni di Antonio Nati
> http://www.interazioni.it  [EMAIL PROTECTED]
> 
>
>

[EMAIL PROTECTED]Interazioni di Antonio Nati
   http://www.interazioni.it  [EMAIL PROTECTED]