[sork] vacation not working with qmail, autorespond, vpopmail

[Rick Romero]

On Jun 23, 2007, at 3:09 PM, Claus Szypura wrote:

> Rick Romero <rick <at> havokmon.com> writes:
>
>
>> LMAO.  Sorry - I didn't attach it ;)
>> http://www.havokmon.com/stuff/horde/vacation/vpopmailsql.1.diff
>>
> LMAO too, have been starting to get some daubts about myself... ;)
> Many thanks for the files!
> I've diffed and patched the conf.php and the vpopmailsql.php, but  
> still the same
> message. If Pureftp is needed I will go ahead now and install it,  
> since it isn't
> installed yet (didn't need it up to now - my horde/passwd problem  
> is solved
> without using an ftp server).
> Are there any special configurations needed or will it be done by a  
> standard
> install?

Uhhh - well I set it to use MySQL authentication, then pointed it to  
vpopmail.  So my pure-ftpd.conf:
ChrootEveryone              yes
BrokenClientsCompatibility  no
MaxClientsNumber            50
Daemonize                   yes
MaxClientsPerIP            15
VerboseLog                  yes
DisplayDotFiles             yes
AnonymousOnly               no
NoAnonymous                 yes
SyslogFacility              auth
DontResolve                 yes
MaxIdleTime                 15
MySQLConfigFile               /usr/local/etc/pureftpd-mysql.conf
LimitRecursion              2000 8
AnonymousCanCreateDirs      yes
MaxLoad                     4
AntiWarez                   yes
Bind                      127.0.0.1,21
UserBandwidth             25
Umask                       133:022
MinUID                      89
AllowUserFXP                no
AllowAnonymousFXP           no
ProhibitDotFilesWrite       no
ProhibitDotFilesRead        no
AutoRename                  no
AnonymousCantUpload         yes
AltLog                     clf:/var/log/pureftpd.log
MaxDiskUsage               98
CustomerProof              yes
TLS                      0

And my pureftpd-mysql.conf:

MYSQLServer     mastersql.vfemail.net
MYSQLSocket     /tmp/mysql.sock
MYSQLUser      username
MYSQLPassword   password
MYSQLDatabase   vpopmail
MYSQLCrypt      cleartext
MYSQLGetPW      SELECT pw_clear_passwd FROM vpopmail WHERE concat 
(pw_name,"@",pw_domain)="\L"
MYSQLGetUID      SELECT "\L"
MYSQLDefaultUID 89
MYSQLGetGID      SELECT "\L"
MYSQLDefaultGID 89
MYSQLGetDir      SELECT pw_dir FROM vpopmail WHERE concat(trim 
(pw_name),"@",trim(pw_domain))="\L"
MYSQLGetQTASZ   SELECT pw_shell FROM vpopmail WHERE concat(trim 
(pw_name),"@",trim(pw_domain))="\L"

The problem you're going to have is the table isn't 'vpopmail' - it's  
part of the username.

Know any C ?  I would export a new 'variable' for pw_name, and  
pw_domain wherever \L is being exported, and then adjust the queries  
accordingly.

Rick

> Claus
>>
>>>
>>>
>>> -- 
>>> Sork mailing list - Join the hunt: http://horde.org/bounties/#sork
>>> Frequently Asked Questions: http://horde.org/faq/
>>> To unsubscribe, mail: sork-unsubscribe <at> lists.horde.org
>>
>>
>>
>
>
>
>
> -- 
> Sork mailing list - Join the hunt: http://horde.org/bounties/#sork
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: sork-unsubscribe at lists.horde.org