"Frank" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> "Tom Collins" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > On Sunday, September 21, 2003, at 02:53 AM, Frank wrote:
> > >> That part is very odd. I'm not sure why it's appending the
> > >> "//home/frank,,mydomain.com/" to the path name. I just rechecked the
> > >> code in vmysql.c, and I can't see how the config file name would fail
> > >> to be built properly.
> > >
> > > no idea, either. ktrace/kdump (FreeBSD 4.x) doesn't come
> > > up with anything useful I can go through (500Mb dump in 10 seconds..)
>
> I managed to capture a reasonable dump with the vmysql errors.
> Attached is a portion with the errors. I'm not much the programmer, so
> hope you can make something out of it.
>
> vpopmail-5.3.27
> qmail-1.03 with QMAILQUEUE and TLS patch
> FreeBSD 4.3
>
> There's 2 things I see:
> #1) qmail-local is complaining, "vmysql: can't read settings from
> /home/vpopmail/etc/vpopmail.mysql"
>
> 93567 qmail-local NAMI "/home/frank"
> 93567 qmail-local RET chdir 0
> 93567 qmail-local CALL open(0xbfbffa48,0,0x1b6)
> 93567 qmail-local NAMI "/home/vpopmail/etc/vpopmail.mysql"
> 93567 qmail-local RET open -1 errno 13 Permission denied
> 93567 qmail-local CALL write(0x2,0xbfbff320,0x43)
> 93567 qmail-local GIO fd 2 wrote 67 bytes
> "vmysql: can't read settings from /home/vpopmail/etc/vpopmail.mysql
> "
>
> Don't get why there's a Permission denied. Qmail-local, which has root,
> is trying to open /home/vpopmail/etc/vpopmail.mysql.
>
> # ls -l /var/qmail/bin/qmail-local
> -rwxr-xr-x 1 root qmail 154450 Sep 22 09:02 /var/qmail/bin/qmail-local
> # ls -l /home/vpopmail/etc/vpopmail.mysql
> -rw-r----- 1 vpopmail vchkpw 45 Sep 11 14:16
> /home/vpopmail/etc/vpopmail.mysql
I chmodded /vpopmail.mysql to 644, which got passed the Permission
denied error.
# chmod 644 vpopmail.mysql
After checking that it got past the error, I noticed that the permissions
were set to root on the ~/etc directory. (Root seems to be the default
after installation ~ bug??)
# pwd
/usr/home/vpopmail
# ls -l
total 6
drwxr-xr-x 2 root vchkpw 512 Sep 10 11:39 bin
drwxr-xr-x 4 root vchkpw 512 Sep 7 10:10 doc
drwx------ 4 vpopmail vchkpw 512 Sep 25 06:17 domains
drwxr-xr-x 2 root vchkpw 512 Sep 7 10:11 etc
drwxr-xr-x 2 root vchkpw 512 Sep 10 11:39 include
drwxr-xr-x 2 root vchkpw 512 Sep 10 11:39 lib
#
That explains why vpopmail was getting the error on vpopmail.mysql
located in etc... I chmodded all to vpopmail:
# ls -l
total 8
drwxr-xr-x 2 vpopmail vchkpw 512 Sep 10 11:39 bin
drwxr-xr-x 4 vpopmail vchkpw 512 Sep 7 10:10 doc
drwx------ 4 vpopmail vchkpw 512 Sep 25 06:17 domains
drwxr-xr-x 2 vpopmail vchkpw 512 Sep 7 10:11 etc
drwxr-xr-x 2 vpopmail vchkpw 512 Sep 10 11:39 include
drwxr-xr-x 2 vpopmail vchkpw 512 Sep 10 11:39 lib
#
Hope this gets changed in the next release. ;)
> #2 ) You'll see qmail-lspawn, qmail-send, and splogger with the
> appended: /home/frank,,mydomain1.com
>
> 93459 qmail-lspawn GIO fd 1 wrote 96 bytes
> "\0Zvmysql: can't read settings from
> /home/vpopmail/etc/vpopmail.mysql
> /home/frank,,mydomain1.com
> \0"
> 93457 qmail-send GIO fd 0 wrote 93 bytes
>
> "vmysql:_can't_read_settings_from_/home/vpopmail/etc/vpopmail.mysql//ho\
> me/frank,,mydomain1.com/"
> 93458 splogger GIO fd 0 read 93 bytes
>
> "vmysql:_can't_read_settings_from_/home/vpopmail/etc/vpopmail.mysql//ho\
> me/frank,,mydomain1.com/"
>
Still don't know why the "vmysql" error comes up, but for anyone getting
the same thing, I finally had to delete/recreate the domain(s) & user(s) as
a
workaround:
1. shutdown qmail (as root):
#/var/qmail/rc stop
2. backup all emails (as root)
# cd /home/vpopmail/domains/mydomain.com/user1/Maildir/
# tar -czf /tmp/user1.email.tar.gz cur new .Sent
(tar for each user(s))
3. Backup user passwords:
# mysql -u root -p vpopmail
mysql> SELECT CONCAT(pw_name,"@",pw_domain), pw_clear_passwd INTO OUTFILE
'/tmp/vpopuserspasswd.out' FROM vpopmail WHERE pw_name <> 'postmaster';
4. Delete all the domain(s) (as root).
# /home/vpopmail/bin/vdeldomain mydomain.com
(Delete each domain(s))
5. Delete all the lock files in /var/qmail/control and users (as root):
# rm /var/qmail/control/*.lock /var/qmail/users/*.lock
6. Delete the cdb database (as root)
# rm /var/qmail/users/cdb
7. Recreate the domain(s) (as root):
# /home/vpopmail/bin/vadddomain mydomain mypasswd
8. Recreate the users (as root):
# bash
$ while read a
> do
> /home/vpopmail/bin/vadduser $a
> done < /tmp/vpopuserspasswd.out
9. Recreate the maildirsize (as vpopmail) especially needed when
using the quota_usage plugin:
# su - vpopmail
# bash
$ for i in `awk '{print $1}' /tmp/vpopuserspasswd.out`
> do
> /home/vpopmail/bin/vuserinfo $i
> done
10. Delete (or save) the /tmp/vpopuserspasswd.out
Tom, if you need anything else (i.e. more trace dumps, or whatever),
let me know.
Frank
