> What happens when you run `strings ~vpopmail/bin/vdelivermail | grep
> "vpopmail.mysql"`?
>
> You should get a single line with "vpopmail.mysql" on it.

That's exactly what I get:
# strings vdelivermail | grep "vpopmail.mysql"
vpopmail.mysql
#

> > vmysql: sql error[1]: Can't create database 'vpopmail'. Database exists
>
> Did you work out your problems with the vpopmail.mysql file?

Yes. I don't seem to be getting that sql error anymore. BTW,

# pwd
/usr/home/vpopmail/etc
# ls -l vpopmail.mysql
-rw-r-----  1 vpopmail  vchkpw  45 Sep 11 14:16 vpopmail.mysql
# cat vpopmail.mysql
localhost|0|vpopmailuser|vpoppasswd|vpopmail
#


> Again, I'm not sure where the weird filenames are coming from
> (/home/vpopmail/domains/mydomain.com,,mydomain.com).
>
> What does the .qmail-default file look like for mydomain.com?

# pwd
/usr/home/vpopmail/domains/mydomain.com
# cat .qmail-default
| /home/vpopmail/bin/vdelivermail ''
/home/vpopmail/domains/mydomain.com/frank

Noting: I've sed 's/myactualdomain.com/mydomain.com'


Thanks Tom for continuing to look into this. I think I migh have
something that might help...

I deleted my domain (/home/vpopmail/bin/vdeldomains mydomain.com)
and recreated it (/home/vpopmail/bin/vadddomain mydomain.com pass).
It wiped out everything under the /home/vpopmail/domains/mydomain.com
directory, including some important emails. But at least no more
"vmysql:_can't_read_settings_from..." error anymore.

But emails to non-existent accounts were mail looping endlessly. Trying
to stop it, I decided to backup my new important emails this time:
# cd /home/vpopmail/domains/mydomain.com/frank/Maildir
# tar -czf /tmp/myemails.tar.gz cur new

And deleted the domain and recreated it with my user again:
# /home/vpopmail/bin/vadeldomain mydomain.com
# /home/vpopmail/bin/vadddomain mydomain.com pass
# /home/vpopmail/bin/vadduser [EMAIL PROTECTED] pass

Then restored my important emails.
# cd /home/vpopmail/domains/mydomains.com/frank/Maildir
# tar -xzf /tmp/myemails.tar.gz

I noted that the queue name format didn't look like every other because
I moved queues around. I had moved emails in my system account's
Maildir to my vpopmail user account's Maildir:

# mv /home/frank/Maildir/new/*
/home/vpopmail/domains/mydomain.com/frank/Maildir/new/*

I looked at the emails (which moved everything in new to cur). Now those
email name formats don't have quite the same format:
# ls -l cur new
cur:
total 176
-rw-------  1 vpopmail  vchkpw    2314 Sep 23 03:41
1063608441.18859.www.mydomain.com:2,S
-rw-------  1 vpopmail  vchkpw    2441 Sep 23 03:41
1063777535.26975.www.mydomain.com:2,S
-rw-------  1 vpopmail  vchkpw    1367 Sep 18 01:14
1063815291.28928.www.mydomain.com,S=1328:2,RS
-rw-------  1 vpopmail  vchkpw    1384 Sep 18 08:46
1063842377.79354.www.mydomain.com,S=1345:2,RS
-rw-------  1 vpopmail  vchkpw    1626 Sep 18 08:49
1063842558.79572.www.mydomain.com,S=1587:2,S
-rw-------  1 vpopmail  vchkpw  132134 Sep 18 12:17
1063855052.93458.www.mydomain.com,S=132095:2,RS
-rw-------  1 vpopmail  vchkpw    3577 Sep 18 13:37
1063859866.98209.www.mydomain.com,S=3538:2,RS
-rw-------  1 vpopmail  vchkpw    2615 Sep 19 09:03
1063929803.61907.www.mydomain.com,S=2576:2,RS
-rw-------  1 vpopmail  vchkpw    5691 Sep 21 03:10
1064081408.82962.www.mydomain.com,S=5652:2,S
-rw-------  1 vpopmail  vchkpw    2256 Sep 22 17:46
1064220386.86347.www.mydomain.com,S=2217:2,RS
-rw-------  1 vpopmail  vchkpw    1980 Sep 23 01:42
1064248923.87123.www.mydomain.com,S=1941:2,S
-rw-------  1 vpopmail  vchkpw    1601 Sep 23 01:52
1064249545.87168.www.mydomain.com,S=1562:2,S

After all that, when I send myself a email: [EMAIL PROTECTED],
I get the same error in /var/log/maillog:
Sep 23 04:13:32 www qmail: 1064258012.943110 starting delivery 5: msg 468246
to
local [EMAIL PROTECTED]
Sep 23 04:13:32 www qmail: 1064258012.943985 status: local 1/10 remote 0/20
Sep 23 04:13:32 www qmail: 1064258012.954235 delivery 5: deferral:
vmysql:_can't
_read_settings_from_/home/vpopmail/etc/vpopmail.mysql//home/frank,,mydomain.
com/
Sep 23 04:13:32 www qmail: 1064258012.954616 status: local 0/10 remote 0/20

And the email I sent myself stays in /var/qmail/queue :
# pwd
/var/qmail/queue
# find . -type f
./mess/12/468246
./info/12/468246
./local/12/468246
./lock/tcpto
./lock/sendmutex


Can moving old emails into vpopmail's Maildirs cause this?
Does vpopmail keep track of mail queue numbers?
Sorry if these are dumb questions, but I've been up all
night and nothing is going clicking anymore...

Frank




Reply via email to