it works. The “existing domain” message should have given me the hint to first create the mail account and then add the pointer domain as server alias. But it was late yesterday night, so that’s gonna be my excuse
I encountered the same error message as above, but this time while adding the domain
vmysql: sql error: Data too long for column ‘pw_clear_passwd’ at row 1
Failed while attempting to add user to auth backend
Error: no authentication database connection
So I had to remove the domain again with
and then added it with a shorter password. That worked and adding the mail account with a similar short password worked fine to. After re-adding the pointer domain and an Apache restart everything works now as intended. Excellent!
Does anone have any idea, why the password length seems to be limited and to what length?
I looked up the docs for Vpopmail here http://www.qmailwiki.org/Vpopmail and will try a few more things. Especially the “vaddaliasdomain” intrigues me, I have to play with that and see what it does. If it does what I think, this could be a very convenient way to “create” the mailaccounts we need.
As for the quota issue, I could solve that two ways. Use either the option -q quota_in_bytes (sets the users quota, use NOQUOTA for unlimited) while adding the user or I could move the domain folder from /var/vpopmail/domains into the siteworx account folder and create a symbolic link, just like siteworx does it. Or combine both in order to limit the mail account and add it to the space quota of the siteworx account. But in our case I don’t really need it, just wanted to tell others, that might need it.
One more thing: I tested the vuserinfo command and also tried /home/vpopmail/bin/vuserinfo -C [email protected] and that gave me the unencrypted password I entered before. This sets of all alarm bells in me. Shouldn’t vpopmail be configured with the option --disable-clear-passwd by default? This is exactly the kind of oversight, that makes leeching user data from hacked servers so easy and attractive. Or am I wrong?
Anyways, thanks a lot John and Justin, you helped me a lot.