[vchkpw] Adding a new Hard Disk

[Juan Enciso - DNSQ]

Hello friends I want that they offer its valuable 
aid me

I have all my account in this drirectory: 
/usr/vpopmail/domains/mail.com/
In this moment I need add a new hard disk, because 
my server is remaining without sufficient space of disk 


According to the table dir_control, my last created 
user have his home directory in: 
/usr/vpopmail/domains/domain.com/6/Y/user

I would like havethis new 
partition:
/usr/vpopmail/domains/domain.com/disk2

I want that only the new users have their working 
directory ina newpartition in this new hard disk

For example:
/usr/vpopmail/domains/domain.com/disk2/newuser

How I can do this? 
How works the table dir_control? 

I wait foryours answers. Thanks 

Juan Enciso Condeña.Área de OperacionesQnet 
- Servicios InternetTelf. 241-4122 anexo 2245 - 2244www.qnet.com.pe

[vchkpw] Re: SOLUTION, Deny the option Roaming-User the a specific Pool of IP

[Juan Enciso - DNSQ]

Hello Bill,

Thank you very much by your suggestion with respect to my problem.

Now I have modified the code of the file vpopmail.c and in addition I have
added a new file pop3.cdb. Perhaps it is good for implementing this option
in the next versions of the vpopmail package. I think that the option of
ALLOWROAMING seems a good option to have a better control of roaming.

Again, Thank you very much.

These were my modification:

file vpopmail.c

#ifdef POP_AUTH_OPEN_RELAY
int open_smtp_relay()
{
char *allowroaming;
allowroaming = getenv(ALLOWROAMING);

if(allowroaming == NULL){
return(0);
}

create the new file : /usr/vpopmail/etc/tcp.pop3
192.168.:allow,ALLOWROAMING=

this is my file /var/qmail/supervise/qmail-pop3d/run

#!/bin/sh
VPOPMAILUID=`id -u vpopmail`
VPOPMAILGID=`id -g vpopmail`
exec /usr/local/bin/tcpserver -l 0 -R -H -v \
-x /usr/vpopmail/etc/tcp.pop3.cdb \
-u$VPOPMAILUID -g$VPOPMAILGID 0 110   \
/var/qmail/bin/qmail-popup kerberos.qnet.com.pe \
/usr/vpopmail/bin/vchkpw   \
/var/qmail/bin/qmail-pop3d Maildir 21

Before, execute this command.
 tcprules /usr/vpopmail/etc/tcp.pop3.cdb /usr/vpopmail/etc/tcp.pop3.tmp 
/us
r/vpopmail/etc/tcp.pop3

Do you have another idea for this topic?


- Original Message -
From: Bill Shupp [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: [vchkpw] Deny the option Roaming-User the a specific Pool of IP
Ok, upon rereading your post, I see that I answered a different
question..  ; )

What you are asking for could be done pretty easily, I think.  Just
setup another rules file, like tcp.pop, and add a rule like so:

1.2.3.:allow,ALLOWROAMING='

This says that only addresses in 1.2.3.0/24 are allowed to roam
(assuming that the the NO_RELAY bit is not set for the user).

Then, in apply this patch to vpopmail.c:

*** vpopmail.c.orig Tue Aug 20 21:34:34 2002
--- vpopmail.c  Tue Aug 20 21:37:39 2002
***
*** 2040,2045 
--- 2040,2050 
   #ifdef POP_AUTH_OPEN_RELAY
   int open_smtp_relay()
   {
+  allowroaming = env_get(ALLOWROAMING);
+  if(!allowroaming) {
+ return(0);
+  }
+
   #ifdef USE_SQL
 vopen_smtp_relay();
 update_rules();


That should prevent roaming users for any ip's that don't have
ALLOWROAMING set.  *Note that this hack forces you to specify which
ranges can roam, and prevents roaming by default.  Also, I haven't
tested this, but it does compile.  So your mileage may vary... ; )

Regards,

Bill Shupp

[vchkpw] vchkpw can't connect to mysql update server

[Juan Enciso - DNSQ]

Hi  friends

I am using vpopmail-5.2.1 with mysql running vchkpw authentication.
Once in a while, the qmail-send show me this error message:

2002-08-25 04:32:50.580965500 status: local 16/100 remote 0/250
2002-08-25 04:32:50.601224500 delivery 4226: deferral:
could_not_connect_to_mysql_update_server_To
o_many_connections_with_database/could_not_connect_to_mysql_update_server_To
o_many_connections/
2002-08-25 04:32:50.601241500 status: local 15/100 remote 0/250

And when I make a connection pop3 show me this:

[root@linux /root]# telnet localhost 110
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
+OK [EMAIL PROTECTED]
user [EMAIL PROTECTED]
+OK
pass XX
could not connect to mysql update server Too many connections with database
could not connect to mysql update server Too many connections
could not create lastauth table CREATE TABLE vlog ( id BIGINT PRIMARY KEY
AUTO_I
NCREMENT,   user char(32), passwd CHAR(32),   domain CHAR(64), logon
VAR
CHAR(200),   remoteip char(18), message VARCHAR(255),   timestamp
bigint
 default 0 NOT NULL, error INT,   INDEX user_idx (user),   INDEX
domain_
idx (domain), INDEX remoteip_idx (remoteip),   INDEX error_idx (error),
INDE
X message_idx (message) )
error inserting into lastauth table
-ERR authorization failed

In order to solve this problem, I erase the table vlog using this mysql
command:
delete from vlog;
and I have shutdown qmail and mysql services.
In addition I have than fix the table vlog using the command:
myisamchk  -r -q /var/lib/mysql/vpopmail/vlog

Somebody has an idea of which it can be happening?

Thanks for your replies.
Bye

[vchkpw] Deny the option Roaming-User the a specific Pool of IP

[Juan Enciso - DNSQ]

Hello people.
I am using vpopmail-5.2.1 with the option roaming-user 
available and everything works very well.
I have a suggestion to add a new function to the program, 
specifically in theoption of romaing-user. It wanted that only 
somepools of IP have the possibility of making a pop 
authentication,thus to be able to send messages. 
These pools would be put in a file with similar format to 
tcp.smtp. 
I want to have a better control on the IP that can send 
messages. Desire to have the capacity to denyany IP or pools IP even so 
they are my users. 

Thanks for your response

Juan Enciso Condeña.Área de OperacionesQnet 
- Servicios InternetTelf. 241-4122 anexo 2245 - 2244www.qnet.com.pe