[qmailadmin] qmailadmin 1.2.3 and aliases
I am running qmailadmin 1.2.3 and vpopmail 5.4.8. I have compiled vpopmail with enable-valias=y. I ran the dotqmail2valias program, and all my aliases are in the valias table in my database. The aliases work correctly as far as routing mail is concerned. My problem is that I cannot see these aliases in qmailadmin any more. How can I fix that? Thanks, Brad White
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
Title: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql Hi all, Im building a server to replace an existing mail server thats being retired. Ive built qmail (net-qmail) following the Life with Qmail guide and maildir format Ive added vpopmail 5.4.10 with mysql - without issue, and configured domains from the command line Ive installed and configured vqadmin-2.3.2 and had no problems creating/removing domains from the web interface, using the cgi scripts. Ive now just installed and configured qmailadmin 1.2.3. All built ok, and the configure script showed the correct UID/GID for vpopmail / vchkpw. However when I try to login as postmaster for any of the domains hosted on the new machine, I get invalid login as though I had entered the wrong password (which Ive not) The apache error log is showing vmysql: sql error[3]: MySQL server has gone away or vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Mysql is running fine, and if I connect on the command line just using mysql as the vpopmail user, all is well. If I add a user using the vpopmail binaries, all works. If I add a user/domain usering the vqadmin web admin all is well, just qmailadmin The permissions on my /home/vpopmail/etc/vpopmail.mysql looks like this -rw-r- 1 vpopmail vchkpw 36 2005-04-10 19:40 /home/vpopmail/etc/vpopmail.mysql Which looks good, and the root of the ~vpopmail is locked down tight drwx-- 8 vpopmail vchkpw 4096 2005-04-10 19:45 vpopmail The permissions on the cgi script for qmailadmin look like this [EMAIL PROTECTED]:/usr/local/apache/cgi-bin# ls -la total 312 drwxr-xr-x 3 root root 4096 2005-04-11 02:36 . drwxr-xr-x 13 root root 4096 2005-04-10 22:21 .. -rwxr-xr-x 1 root root 268 2005-04-10 22:07 printenv -rwsr-sr-x 1 vpopmail vchkpw 294906 2005-04-11 02:36 qmailadmin -rwxr-xr-x 1 root root 757 2005-04-10 22:07 test-cgi drwxr-xr-x 3 vpopmail vchkpw 4096 2005-04-11 02:36 vqadmin and the permissions on the working vqadmin look like this [EMAIL PROTECTED]:/usr/local/apache/cgi-bin# ls -la vqadmin/ total 108 drwxr-xr-x 3 vpopmail vchkpw 4096 2005-04-11 02:36 . drwxr-xr-x 3 root root 4096 2005-04-11 02:36 .. -rw-r--r-- 1 nobody root 114 2005-04-11 02:36 .htaccess drwxr-xr-x 2 vpopmail vchkpw 4096 2005-04-11 02:36 html -rw-r--r-- 1 vpopmail vchkpw 864 2005-04-11 02:36 vqadmin.acl -rwsr-sr-x 1 root root 83624 2005-04-11 02:36 vqadmin.cgi Now these permissions all look fine to me, vpopmail/mysql/vqadmin is working, so why cant qmailadmin connect to mysql and do its thing ? Thanks, Matt (sorry for the long email, but thought Id include appropriate detail) Well, Im getting no-where fast with this. Could someone send me the default and correct permissions for the vpopmail home dir and subdirs Im almost certain mine are correct and this is not a permissions error, but as Im getting no-where and I cant find anyone else suffering with this problem Ill have to start somewhere. Thanks, Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
Title: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql From var: drwxr-xr-x 8 vpopmail vchkpw 4096 Feb 23 21:21 vpopmail From /var/vpopmail: drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 08:37 bin drwxr-xr-x 4 vpopmail vchkpw 4096 Feb 23 21:04 doc drwx-- 809 vpopmail vchkpw 81920 Apr 12 11:41 domains drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 10:03 etc drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 08:37 include drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 08:37 lib From /var/vpopmail/etc: -rw-r--r-- 1 vpopmail vchkpw 24 Apr 13 08:37 inc_deps -rw-r--r-- 1 vpopmail vchkpw 80 Apr 13 08:37 lib_deps -rw-r--r-- 1 vpopmail vchkpw 1861 Apr 11 13:31 tcp.smtp -rw-r--r-- 1 vpopmail vchkpw 135371 Apr 13 10:03 tcp.smtp.cdb -rw-r--r-- 1 vpopmail vchkpw 1107 Feb 23 21:04 vlimits.default -rw-r- 1 vpopmail vchkpw 88 Apr 1 09:26 vpopmail.mysql From: matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 10:06 AM To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql Hi all, Im building a server to replace an existing mail server thats being retired. Ive built qmail (net-qmail) following the Life with Qmail guide and maildir format Ive added vpopmail 5.4.10 with mysql - without issue, and configured domains from the command line Ive installed and configured vqadmin-2.3.2 and had no problems creating/removing domains from the web interface, using the cgi scripts. Ive now just installed and configured qmailadmin 1.2.3. All built ok, and the configure script showed the correct UID/GID for vpopmail / vchkpw. However when I try to login as postmaster for any of the domains hosted on the new machine, I get invalid login as though I had entered the wrong password (which Ive not) The apache error log is showing vmysql: sql error[3]: MySQL server has gone away or vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql Mysql is running fine, and if I connect on the command line just using mysql as the vpopmail user, all is well. If I add a user using the vpopmail binaries, all works. If I add a user/domain usering the vqadmin web admin all is well, just qmailadmin The permissions on my /home/vpopmail/etc/vpopmail.mysql looks like this -rw-r- 1 vpopmail vchkpw 36 2005-04-10 19:40 /home/vpopmail/etc/vpopmail.mysql Which looks good, and the root of the ~vpopmail is locked down tight drwx-- 8 vpopmail vchkpw 4096 2005-04-10 19:45 vpopmail The permissions on the cgi script for qmailadmin look like this [EMAIL PROTECTED]:/usr/local/apache/cgi-bin# ls -la total 312 drwxr-xr-x 3 root root 4096 2005-04-11 02:36 . drwxr-xr-x 13 root root 4096 2005-04-10 22:21 .. -rwxr-xr-x 1 root root 268 2005-04-10 22:07 printenv -rwsr-sr-x 1 vpopmail vchkpw 294906 2005-04-11 02:36 qmailadmin -rwxr-xr-x 1 root root 757 2005-04-10 22:07 test-cgi drwxr-xr-x 3 vpopmail vchkpw 4096 2005-04-11 02:36 vqadmin and the permissions on the working vqadmin look like this [EMAIL PROTECTED]:/usr/local/apache/cgi-bin# ls -la vqadmin/ total 108 drwxr-xr-x 3 vpopmail vchkpw 4096 2005-04-11 02:36 . drwxr-xr-x 3 root root 4096 2005-04-11 02:36 .. -rw-r--r-- 1 nobody root 114 2005-04-11 02:36 .htaccess drwxr-xr-x 2 vpopmail vchkpw 4096 2005-04-11 02:36 html -rw-r--r-- 1 vpopmail vchkpw 864 2005-04-11 02:36 vqadmin.acl -rwsr-sr-x 1 root root 83624 2005-04-11 02:36 vqadmin.cgi Now these permissions all look fine to me, vpopmail/mysql/vqadmin is working, so why cant qmailadmin connect to mysql and do its thing ? Thanks, Matt (sorry for the long email, but thought Id include appropriate detail) Well, Im getting no-where fast with this. Could someone send me the default and correct permissions for the vpopmail home dir and subdirs Im almost certain mine are correct and this is not a permissions error, but as Im getting no-where and I cant find anyone else suffering with this problem Ill have to start somewhere. Thanks, Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 and aliases
I resolved this issue myself, it was actually working as it is supposed to after I performed the below procedure. From: White, Brad [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 9:14 AM To: qmailadmin@inter7.com Subject: [qmailadmin] qmailadmin 1.2.3 and aliases I am running qmailadmin 1.2.3 and vpopmail 5.4.8. I have compiled vpopmail with enable-valias=y. I ran the dotqmail2valias program, and all my aliases are in the valias table in my database. The aliases work correctly as far as routing mail is concerned. My problem is that I cannot see these aliases in qmailadmin any more. How can I fix that? Thanks, Brad White
Re: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
On Apr 13, 2005, at 1:05 PM, matt wrote: Could someone send me the default and correct permissions for the vpopmail home dir and subdirs Im almost certain mine are correct and this is not a permissions error, but as Im getting no-where and I cant find anyone else suffering with this problem Ill have to start somewhere. Sounds like a suid problem. Check /etc/fstab to make sure the volume with QmailAdmin isn't mounted with the nosuid option. Make sure that Apache is configured to run programs with the suid-bit set. -- Tom Collins - [EMAIL PROTECTED] QmailAdmin: http://qmailadmin.sf.net/ Vpopmail: http://vpopmail.sf.net/ You don't need a laptop to troubleshoot high-speed Internet: sniffter.com
Re: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
White, Brad said the following on 4/13/2005 12:10 PM: From var: drwxr-xr-x 8 vpopmail vchkpw 4096 Feb 23 21:21 vpopmail From /var/vpopmail: (sorry for the long email, but thought I'd include appropriate detail) Well, I'm getting no-where fast with this. Could someone send me the default and correct permissions for the vpopmail home dir and subdir's I'm almost certain mine are correct and this is not a permissions error, but as I'm getting no-where and I can't find anyone else suffering with this problem I'll have to start somewhere. Thanks, Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005 Not quite sure why you guys are sending multipart msgs into a technical list...your msgs are 22K-30K being multipart, where they might only be 3K-5K, if they were text only. Would you be so kind as to check your mailer and adjust them to only send plaintext msgs into the list? FYI- http://www.expita.com/nomime.html Thanks
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
-Original Message- From: Tom Collins [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 18:28 To: qmailadmin@inter7.com Subject: Re: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql On Apr 13, 2005, at 1:05 PM, matt wrote: Could someone send me the default and correct permissions for the vpopmail home dir and subdirs Im almost certain mine are correct and this is not a permissions error, but as Im getting no-where and I cant find anyone else suffering with this problem Ill have to start somewhere. Sounds like a suid problem. Check /etc/fstab to make sure the volume with QmailAdmin isn't mounted with the nosuid option. Make sure that Apache is configured to run programs with the suid-bit set. Tom, That was my first initial thought, and a bit of googling backed this up The mail server is running on linux with default mount options which does not include nosuid. Apache is configured to run projects with suid as vqadmin is working. If vqadmin wasn't working, I'd probably agree easier, but because it works, I'm not sure if thats the right cause of the problem. Thanks for the input though. Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
Title: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql -rw-r--r-- 1 root root 367656 Apr 13 08:37 libvpopmail.a _ From: matt [mailto:[EMAIL PROTECTED]] Sent: Wednesday, April 13, 2005 11:05 AM To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql From: White, Brad [mailto:[EMAIL PROTECTED]] Sent: 13 April 2005 18:10 To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql From var: drwxr-xr-x 8 vpopmail vchkpw 4096 Feb 23 21:21 vpopmail From /var/vpopmail: drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 08:37 bin drwxr-xr-x 4 vpopmail vchkpw 4096 Feb 23 21:04 doc drwx-- 809 vpopmail vchkpw 81920 Apr 12 11:41 domains drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 10:03 etc drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 08:37 include drwxr-xr-x 2 vpopmail vchkpw 4096 Apr 13 08:37 lib From /var/vpopmail/etc: -rw-r--r-- 1 vpopmail vchkpw 24 Apr 13 08:37 inc_deps -rw-r--r-- 1 vpopmail vchkpw 80 Apr 13 08:37 lib_deps -rw-r--r-- 1 vpopmail vchkpw 1861 Apr 11 13:31 tcp.smtp -rw-r--r-- 1 vpopmail vchkpw 135371 Apr 13 10:03 tcp.smtp.cdb -rw-r--r-- 1 vpopmail vchkpw 1107 Feb 23 21:04 vlimits.default -rw-r- 1 vpopmail vchkpw 88 Apr 1 09:26 vpopmail.mysql Thanks Thats a great start. How about the permissions on your qmailadmin library ? Thanks, Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
From: White, Brad [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 19:14 To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql -rw-r--r-- 1 root root 367656 Apr 13 08:37 libvpopmail.a Sorry, I meant your qmailadmin cgi script. Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
-rwsr-sr-x 1 vpopmail vchkpw 144072 Apr 13 08:55 qmailadmin -Original Message- From: matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 1:24 PM To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql From: White, Brad [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 19:14 To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql -rw-r--r-- 1 root root 367656 Apr 13 08:37 libvpopmail.a Sorry, I meant your qmailadmin cgi script. Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
-Original Message- From: White, Brad [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 21:25 To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql -rwsr-sr-x 1 vpopmail vchkpw 144072 Apr 13 08:55 qmailadmin Spot on - same as mine -rwsr-sr-x 1 vpopmail vchkpw 294906 2005-04-14 02:39 qmailadmin -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
When you run a vdominfo on one of your domains, are the UID and GID displayed the correct ones? -Original Message- From: matt [mailto:[EMAIL PROTECTED] Sent: Wednesday, April 13, 2005 1:50 PM To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql -Original Message- From: White, Brad [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 21:25 To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql -rwsr-sr-x 1 vpopmail vchkpw 144072 Apr 13 08:55 qmailadmin Spot on - same as mine -rwsr-sr-x 1 vpopmail vchkpw 294906 2005-04-14 02:39 qmailadmin -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
-Original Message- From: White, Brad [mailto:[EMAIL PROTECTED] Sent: 13 April 2005 21:57 To: qmailadmin@inter7.com Subject: RE: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql When you run a vdominfo on one of your domains, are the UID and GID displayed the correct ones? Yup all good. Vpopmail is working, vqadmin is working, this is something to do with qmailadmin not being able to connect to mysql. In the apache logs I see vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql although I don't see a reason it wouldn't be able to read that when it executes setuid I also see vmysql: sql error[3]: MySQL server has gone away which is probably because it can't get the correct login details for mysql from vpopmail.mysql Mysql is fine - vqadmin and vpopmail are using it fine, I can connect to mysql and the vpopmail database using the vpopmail use from the command line, and I can select and update manually so there is %100 no problem there, which is backed up by vqadmin. I can't see it being a SUID problem as vqadmin is working fine in the same directory. I'm a bit stumped by this. I've installed qmailadmin a good few times and never seen this prolem. I'm open to any suggestions really. Is vpopmail.mysql read on every connection (I assume so as it appears in the apache logs real time) or at build time ? Thanks, Matt -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.308 / Virus Database: 266.9.7 - Release Date: 12/04/2005
Re: [qmailadmin] qmailadmin 1.2.3 cannot read vpopmail.mysql
matt wrote: In the apache logs I see vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql although I don't see a reason it wouldn't be able to read that when it executes setuid If it says that, it _is_ having a problem reading the file where it stores the settings needed to open the database. I also see vmysql: sql error[3]: MySQL server has gone away which is probably because it can't get the correct login details for mysql from vpopmail.mysql If there is one of these for each can't read message, it is certain. Mysql is fine - vqadmin and vpopmail are using it fine, I can connect to mysql and the vpopmail database using the vpopmail use from the command line, and I can select and update manually so there is %100 no problem there, which is backed up by vqadmin. So why can't qmailadmin read the configuration file with the database settings in it? Find that and you've probably got it. Rick