mysql tables and vpopmail 5.0
Good day list Could someone shed some light about MySQL tables structure under Vpopmail 5.0? Vpopmail was compiled with --enable-many-domains=n option, so there is one table per domain. Here is the list of my tables in vpopmail DB: dir_control domain1_com domain2_com domain3_com relay Everything works fine, I was just wondered about content of dir_control table. How many records should be there if I have only three domains? I suppose there should be three records? In my case there are 5 (five) records: domain1_com domain2_com domain3_com dom_90 - (?) empty record - (I mean there is nothing in domain field) What's the purpose of dom_90 and empty one record? Is it normal behavior or I just did something wrong during installation? (In fact it was not fresh installation of Vpopmail 5.0 - I upgraded from Vpopmail 4.9.10 BUT everything works just fine :-))) Thank you very much. Roman
courier-imap and vpopmail too old error (SOLVED)
Good day.
Finally, problem was solved. Gold rule - if something goes wrong at the
evening it will probably be solved tomorrow morning :-)
I would like to share what I did - sorry if these are basic things,
maybe it will be out of help for someone like me :) I'm not sure if it's
correct, anyway it works for me.
Personal thanks to Joe Modjeski and Tren Blackburn. Thank you a lot guys!
1. Copy preauthvchkpw.c from
http://www.inter7.com/vpopmail/preauthvchkpw.c to
courier-imap-1.3.11.xxx/authlib directory.
2. *Temporarily* change permissions on ~vpopmail/lib:
chmod 755 ~vpopmail/lib
chmod 644 ~vpopmail/lib/libvpopmail.a
After compiling Courier-IMAP turn them back:
chmod 711 ~vpopmail/lib
chmod 600 ~vpopmail/lib/libvpopmail.a
3. Edit courier-imap-1.3.11.xxx/authlib/configure script (lines 2949-2955):
# if test -f ${vpopmail_home}/etc/lib_deps
# then
CFLAGS=-I/your/path/to/vpopmail/include/directory $CFLAGS
VPOPMAILLIBS=-L/your/path/to/vpopmail/lib/directory -lvpopmail
-lmysqlclient -lz
# else
#{ echo configure: error: vpopmail too old - upgrade 12;
exit 1; }
# fi
4. Run ./configure --with-authvchkpw --etc, etc
5. Before making make edit courier-imap-1.3.11.xxx/authlib/Makefile
(line 404):
LDFLAGS = -L/your/path/to/mysql/lib/directory -lmysqlclient -lz
6. make
...
Thank you.
Regards,
Roman
Re: Vpopmail Upgrade
Hi I'm not sure if this helps, but my assign file has the same structure with some exception. +domain.com-:domain.com:90:90:/home/vpopmail/domains/domain.com:-:: . You see, there is . (dot) at the end. Hope this helps. Regards, Roman After Upgrade: lrwxrwxrwx1 vpopmail vchkpw 43 Oct 23 11:02 test.receivables.cc - /home/vpopmail/domains/test.barbwirenet.com [root@cera domains]# cat /var/qmail/users/assign +test.barbwirenet.com-:test.barbwirenet.com:508:503:/home/vpopmail/domains/t est.barbwirenet.com:-:: +test.receivables.cc-:test.receivables.cc:508:503:/home/vpopmail/domains/tes t.receivables.cc:-:: After ../bin/vdeldomain test.receivables.cc ../bin/vaddaliasdomain test.receivables.cc test.barbwirenet.com: lrwxrwxrwx1 root root 43 Oct 23 11:22 test.receivables.cc - /home/vpopmail/domains/test.barbwirenet.com [root@cera domains]# cat /var/qmail/users/assign +test.barbwirenet.com-:test.barbwirenet.com:508:503:/home/vpopmail/domains/t est.barbwirenet.com:-:: +test.receivables.cc-:test.receivables.cc:508:503:/home/vpopmail/domains/tes t.barbwirenet.com:-:: Tren Blackburn writes: Hrm...as I recall there were changes done to the code for how aliased domains work. I'm not sure if it ever made it in or was slated for 5.1 development. I've not run into this problem as I've been making new servers for all my vpopmail 5 implementations (one of the reasons that learning passwords has been a godsend) Has anyone else run into this problem? Can you show us the contents of the assign file before and after as well as the links before and after? Just the relevant bits of course. Regards, Tren. -Original Message- From: cyclo8 [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 23, 2001 1:38 PM To: Tren Blackburn Cc: [EMAIL PROTECTED] Subject: Re: Vpopmail Upgrade
courier-imap and vpopmail too old error (II)
Hi again :)
After checking *configure* script in
courier-imap-1.3.11.20011014/authlib directory I hope I found what was
the reason of error.
Take a look at lines 2949-2954:
if test -f ${vpopmail_home}/etc/lib_deps
then
CFLAGS='cat ${vpopmail_home}/etc/inc_deps' $CFLAGS
VPOPMAILLIBS='cat ${vpopmail_home}/etc/lib_deps'
else
{ echo configure: error: vpopmail too old - upgrade 12; exit 1; }
fi
As I understood it tries to find ~vpopmail/etc/inc_deps and
~vpopmail/etc/lib_deps. Just curious, what is inc_deps and lib_deps? I
guess it has something to do with 4.9.x devel? Am I wrong?
What I did in order to run ./configure with no errors.
I checked configure script from old releases of Courier-IMAP and made
some changes.
First, I defined full path to vpopmail working directory and tried to
use old-style configure script:
# if test -f ${vpopmail_home}/etc/lib_deps
# then
CFLAGS=-I/home/vpopmail/include $CFLAGS
VPOPMAILLIBS=-L/home/vpopmail/lib
# else
#
{ echo configure: error: vpopmail too old - upgrade 12; exit 1; }
# fi
OK, ./configure runs with NO errors, but enemy is still at the gates
:) - while running make I have another portion of errors:
Making all in authlib
gcc -I/home/vpopmail/include -g -O2 -Wall -I.. -I./.. -o authvchkpw
modauthvchkpw.o libauthmod.a libauth.a ../md5/libmd5.a ../sha1/libsha1.a
-L/home/vpopmail/lib -lm -lcrypt
libauth.a(authvchkpw.o): In function `auth_vchkpw_changepass':
/usr/tmp/courier-imap-1.3.11.20011014/authlib/authvchkpw.c(.text+0x1ee):
undefined reference to `vget_assign'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/authvchkpw.c(.text+0x1fe):
undefined reference to `vauth_getpw'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/authvchkpw.c(.text+0x27d):
undefined reference to `vpasswd'
libauth.a(preauthvchkpw.o): In function `auth_vchkpw_pre':
/usr/tmp/courier-imap-1.3.11.20011014/authlib/preauthvchkpw.c(.text+0xa1):
undefined reference to `vget_assign'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/preauthvchkpw.c(.text+0xb1):
undefined reference to `vauth_getpw'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/preauthvchkpw.c(.text+0xe0):
undefined reference to `make_user_dir'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/preauthvchkpw.c(.text+0xed):
undefined reference to `vauth_getpw'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/preauthvchkpw.c(.text+0x103):
undefined reference to `vsqwebmail_pass'
/usr/tmp/courier-imap-1.3.11.20011014/authlib/preauthvchkpw.c(.text+0x117):
undefined reference to `vclose'
*** Error code 1
Stop in /usr/tmp/courier-imap-1.3.11.20011014/authlib.
*** Error code 1
Stop in /usr/tmp/courier-imap-1.3.11.20011014.
1) I tried to copy preauthvchkpw.c from
http://www.inter7.com/vpopmail/preauthvchkpw.c. Same error.
2) I tried to run make as root/regular user. No effect.
3) I changed permissions on /home/vpopmail/lib (755, libvpopmail.a -
644) as it was suggested by Tren. Still no success.
Anyone had any success with building Courier-IMAP 1.3.11 with Vpopmail
5.0? Or should we wait response from Mr. Sam? :)
Thank you very much.
Regards,
Roman
courier-imap and vpopmail too old error
Good day I've finally moved to Vpopmail 5.0. Many thanks to Tren for help - learning-password feature is really cool! I got problem compiling Courier-IMAP with Vpopmail 5.0. I'm sorry for off-topic but I didn't find any similiar questions neither in this mailing list nor in courier-imap's archive. FreebSD 4.4 STABLE, Courier-IMAP 1.3.11.20011014, Vpopmail 5.0 I was trying to build Courier-IMAP with this options: ./configure --without-ipv6 --with-db=db --enable-workarounds-for-imap-client-bugs \ --enable-unicode --with-authvchkpw --with-authdaemon ./configure fails with error: configure: error: vpopmail too old - upgrade configure: error: ./configure failed for authlib I run ./configure as a *regular* user. I also tried to put preauthvchkpw.c (from http://www.inter7.com/vpopmail/preauthvchkpw.c) into authlib directory. No effects - same error. Thank you for your help. Regards, Roman
--enable-large-site=y and vpopmail 5.0
Good day. I'm planning to upgrade Vpopmail 4.9.10 to 5.0 (final beta). I use MySQL authorization and plan to add --enable-large-site=y while compiling Vpopmail 5.0. I *didn't* use --enable-large-site=y feature in 4.9.10 before. FAQ says that process of upgrading is approx. similiar to fresh install - download sources - compile - done :). Is it true for migration from 4.9.10 to 5.0? In other words, adding support for large-site will definitely rebuild/remake vpopmail's DB in MySQL (make it one table per domain). Right now I have all domains/users in one table (vpopmail), do I have to change settings of database (vpopmail) manually or everything will be fixed up by vpopmail? :) OS: FreeBSD 4.4 STABLE, MySQL 3.23.28 Thank you very much. Regards, Roman
Re: --enable-large-site=y and vpopmail 5.0
Hi Tren! Thank you for your answer. It helps a lot. Could you be so kind to explain features you mentioned before? I read a lot about learning passwords and clear-text password features from this mailing list, but do not have clear picture what is it. I guess it will be helpful for those of us who are going to migrate to 5.0 soon. :) My users mostly use web access (horde/imp) - so as I understood they will be prompted to provide password first time they login right? Thank you. Regards, Roman Tren Blackburn wrote: If you want to change your schema from small site, to large site, I would recommend you do the conversion while you're at 4.9.10 using the vconvert tool as this tool does not work for mysql database backend under 5.0 (Ken, any time frame on this working again?) It should be pretty simple, just do: ~vpopmail/bin/vconvert -s -l This will take you from small site to large site. Also as an FYI, the --enable-large-site=y has been depreciated in vpopmail 5 and replaced with --enable-many-domains=n If you want to use the clear-text passwords option in vpopmail 5, I would highly recommend you go through the UPGRADE.tren file included with the vpopmail 5 distribution as it will walk you through the necessary conversions to you mysql tables to support the extra field. I'd also recommend turning on the learning passwords feature (*plug*) as it's a very nice feature. Make the user with a blank password and first time they pop in, it sets their password. I hope this information helps, but just remember, convert to large site format under 4.9.10 first, test, then upgrade. Regards, Tren. -Original Message- From: Roman Serbski [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 18, 2001 5:48 AM To: [EMAIL PROTECTED] Subject: --enable-large-site=y and vpopmail 5.0 Good day. I'm planning to upgrade Vpopmail 4.9.10 to 5.0 (final beta). I use MySQL authorization and plan to add --enable-large-site=y while compiling Vpopmail 5.0. I *didn't* use --enable-large-site=y feature in 4.9.10 before. FAQ says that process of upgrading is approx. similiar to fresh install - download sources - compile - done :). Is it true for migration from 4.9.10 to 5.0? In other words, adding support for large-site will definitely rebuild/remake vpopmail's DB in MySQL (make it one table per domain). Right now I have all domains/users in one table (vpopmail), do I have to change settings of database (vpopmail) manually or everything will be fixed up by vpopmail? :) OS: FreeBSD 4.4 STABLE, MySQL 3.23.28 Thank you very much. Regards, Roman
Re: Vpopmail and Qmail Scanner
Hi In order to use qmail-scanner you have to patch qmail with qmail-queue patch and make sure that perl is suid. After that set QMAILQUEUE in /var/qmail/supervise/smtp/run (your path could be different): QMAILQUEUE=/var/qmail/bin/qmail-scanner-queue.pl export QMAILQUEUE Do not forget to increase softlimit in the same file - it should be at least 5MB IMHO. As for webmail, you have to set QMAILQUEUE in the Apache start up script. That's it. It works for me just fine with vpopmail and horde/imp. Hope this helps. Roman KENet Webmaster wrote: Ok, I finally got qmail scanner compiled and tests show it to be working, however, Im having a slight problem. qmail-scanner-queue.pl is in the bin directory. The install instructions are for a qmail install in general. Could someone who has successfully done this show me what and which files I need to alter for qmail scanner to work with the server and webamil Thanks
vpopmail+mysql question
Good day all I've just noticed some strangeness with Vpopmail + MySQL scheme. After upgrading from 4.9.8 to 4.9.10 (with --enable-hardquota=x feature) something was changed in MySQL's 'vpopmail' database (table 'vpopmail'). How many fields should I have in table 'vpopmail'? Right now I have 8. pw_name, pw_domain, pw_passwd, pw_uid, pw_gid, pw_gecos, pw_dir, pw_shell BUT, there is quota information (NOQUOTA or 300) in the field 'pw_shell'! I'm not sure - is it OK? Before upgrade I've used 4.9.8 with --enable-hardquota=n option, when I moved to 4.9.10 I added --enable-hardquota=300 feature. Everything works fine incl. quota :-), no errors - I just wondered is it normal that I have quota information in pw_shell field? FreeBSD 4.2 STABLE Vpopmail 4.9.10 MySQL 3.23.28-gamma Thank you very much. Ciao, Roman Serbski mailto:libser@[no_spam_plz]manas.kg
Re: problem using qmail-scanner
Hi Matthieu Your question is well described in qmail-scanner FAQ (Question 1): http://qmail-scanner.sourceforge.net/FAQ.php Ciao, Roman Serbski mailto:libser@[no_spam_plz]manas.kg i've install qmail-scanner (which seems to work) but /var/log/syslog report this error : Jul 30 14:28:26 hey qmail: 996496106.929742 Can't do setuid
Re: archive
Hi Yes. http://www.mail-archive.com/vchkpw%40inter7.com/ Ciao, Roman Serbski mailto:libser@[no_spam_plz]manas.kg Is there an archive of this mailing list?? Aadish Shreshta
vqadmin.acl questions
Hi everybody! I'm trying to use vQadmin 1.3 and I've been stuck with vqadmin.acl. Maybe I'm so stupid but I can understand nothing from attached vqadmin.acl... =) Please help... whatever I do - I receive :Permission denied from vqadmin.cgi's interface... 1. Defining a group: What about syntax??? (default - ...) default - my_group_name OR my_group_name - user(-s???) Finally who is the user? I guess it is a username that was defined in Apache for accessing cgi-bin/vqadmin.cgi ... am I wrong? 2. Access permissions: For example tech PV tech1user - PV is OK, but what about tech and tech1user??? First one is group name and the second one is username... right??? 3. What ownership should be set for vqadmin.cgi? Thank you a lot! Ciao, Roman Serbski mailto:[EMAIL PROTECTED]
Re: Antivirus
http://qmail-scanner.sourceforge.net/ Ciao, Roman Serbski mailto:[EMAIL PROTECTED] - Original Message - From: "Dimitri SZAJMAN" [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, April 05, 2001 4:42 PM Subject: Antivirus Hi, I am looking for a good antivirus, working with vpopmail,maildir,... I saw some but I think they only work with ~/Mailbox Any URL would be really apreciated thanks
moving off sendmail
Good day all! I have several questions concerning moving off sendmail. I think it could be nice to add this part to vpopmail FAQ. Right now I use Sendmail 8.9.3 with shadow-passwd users (running on Linux Redhat 5.2). I installed Qmail 1.03 on another computer (powered by FreeBSD 4.2 STABLE) + Vpopmail 4.9.7 (Maildir delivery) with MySQL authorization (MySQL 3.23.28-gamma). Everything works quite good (POP3, SMTP)! (many thanks to Vpopmail developers :-) Both operating systems use DES encryption. Question 1.: Is it possible to convert passwd users from Linux to vpasswd.cdb on FreeBSD (as it was mentioned, both OS use DES encryption)? I looked through mailist archives, people suggested to use vconvert, but I use two different computers...as I know vconvert doesn't have options where I can define source file to convert from? Question 2.: What should I change in sendmail.cf file to migrate all mail messages from sendmail to Qmail? I mean I would like to forward mails from sendmail to Qmail, and than I will stop using sendmail at all. Looking forward to hear from you. Thank you. Roman
Re: instalation of courier-imap
Hi BOFH /mail/vpopmail. when i'm building courier-imap-1.3.0.. First try courier-imap-1.3.1 Second thing - add env LIBS="-L/your_path_to_mysql_libs -lmysqlclient" before ./configure bla-bla Regards, Roman
moving off sendmail
Good day all! I have several questions concerning moving off sendmail. I think it could be nice to add this part to vpopmail FAQ. Right now I use Sendmail 8.9.3 with shadow-passwd users (running on Linux Redhat 5.2). I installed Qmail 1.03 on another computer (powered by FreeBSD 4.2 STABLE) + Vpopmail 4.9.7 (Maildir delivery) with MySQL authorization (MySQL 3.23.28-gamma). Everything works quite good (POP3, SMTP)! (many thanks to Vpopmail developers :-) Both operating systems use DES encryption. Question 1.: Is it possible to convert passwd users from Linux to vpasswd.cdb on FreeBSD (as it was mentioned, both OS use DES encryption)? I looked through mailist archives, people suggested to use vconvert, but I use two different computers...as I know vconvert doesn't have options where I can define source file to convert from? Question 2.: What should I change in sendmail.cf file to migrate all mail messages from sendmail to Qmail? I mean I would like to forward mails from sendmail to Qmail, and than I will stop using sendmail at all. Looking forward to hear from you. Thank you. Roman
Re: qmail as mail cache
Please check http://qmail-scanner.sourceforge.net/or http://amavis.org/- everything is well-documented. Moreoveryou could attachantivirus database from different antivirus vendors (AVP, F-secure etc.). Qmail-scanner works pretty fine with my qmail box. Regards. Roman - Original Message - From: Dominik Brumm To: [EMAIL PROTECTED] Sent: Tuesday, January 09, 2001 12:21 AM Subject: qmail as mail cache Hello At the momentwe have a AS/400 with Lotus Domino mail server, which handels all mails for our domain. This server goes down every night, so it's impossible to receive mails and the sender gets an error message. Now I setup a linux box with qmail for caching the incomming mails for about 48 hrs. At the same time, the mails should be checked for viruses and forwarded to the IP adress of the mail server. If anyone can help me with information and related links to this problem. Thanks dominik
adding nK users script?
Good day all! I use Qmail 1.03 + Vpopmail 4.9.7 + Mysql authorization. I have almost 2K users to add. Are there any Perl (C)scripts for adding big amount of users? Something like ./vaddscript users.dat, where users.dat consists of username and password: [EMAIL PROTECTED] pass1 [EMAIL PROTECTED] pass2 ... etc. Thank you, Roman
