Re: vacation not working with qmail, autorespond, vpopmail
Rick Romero <[email protected]>
| Newsgroups | gmane.comp.horde.sork |
|---|---|
| Message-ID | <[email protected]> |
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: [email protected] -- Sork mailing list - Join the hunt: http://horde.org/bounties/#sork Frequently Asked Questions: http://horde.org/faq/ To unsubscribe, mail: [email protected]