Hi, I have installed postfix from plus repo. Also restarted mailscanner service. Still getting below error:
*# tailf /var/log/maillog* Nov 11 18:49:57 testvps postfix/smtpd[30336]: fatal: /etc/postfix/ mysql-relay_recipients.cf, line 5: missing '=' after attribute name: "UNION SELECT 1 FROM auth_user WHERE username='%s' OR email='%s' \" Nov 11 18:49:58 testvps postfix/master[29982]: warning: process /usr/libexec/postfix/smtpd pid 30336 exit status 1 Nov 11 18:49:58 testvps postfix/master[29982]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling Nov 11 18:50:58 testvps postfix/smtpd[30348]: fatal: /etc/postfix/ mysql-relay_recipients.cf, line 5: missing '=' after attribute name: "UNION SELECT 1 FROM auth_user WHERE username='%s' OR email='%s' \" Nov 11 18:50:59 testvps postfix/master[29982]: warning: process /usr/libexec/postfix/smtpd pid 30348 exit status 1 Nov 11 18:50:59 testvps postfix/master[29982]: warning: /usr/libexec/postfix/smtpd: bad command startup -- throttling *# cat /etc/postfix/mysql-relay_recipients.cf* user = baruwa password = pwd dbname = baruwa query = SELECT 1 FROM user_addresses WHERE address='%s' AND address_type=2 \ UNION SELECT 1 FROM auth_user WHERE username='%s' OR email='%s' \ hosts = 127.0.0.1 *# postconf -m* btree cidr environ hash ldap *mysql* nis pcre *pgsql* proxy regexp static unix I am using http://readthedocs.org/docs/baruwa/en/latest/integration.html#postfix to configure postfix with MailScanner Am I missing anything? Thank you, On Fri, Nov 11, 2011 at 8:45 PM, Jeremy McSpadden <[email protected]>wrote: > You need to follow the baruwa guide. > > --**** > Jeremy McSpadden**** > Flux Labs, Inc**** > http://www.fluxlabs.net > Endless Solutions**** > *Office* : 850-588-4626**** > *Cell* : 850-890-2543 > *Fax* : 850-254-2955 > > On Nov 11, 2011, at 9:13 AM, [email protected] wrote: > > # postconf -m > btree > cidr > environ > hash > ldap > nis > pcre > proxy > regexp > static > unix > > Yes, I dont have mysql support. > > Let me install postfix from > http://wiki.centos.org/AdditionalResources/Repositories/CentOSPlus > > After installing it, do we need any configuration to make it work? > > Thank you, > > > On Fri, Nov 11, 2011 at 8:36 PM, Jeremy McSpadden <[email protected]>wrote: > >> [root@smtp2 jeremy]# postconf -m >> btree >> cidr >> environ >> hash >> ldap >> mysql >> nis >> pcre >> pgsql >> proxy >> regexp >> static >> unix >> --**** >> Jeremy McSpadden**** >> Flux Labs, Inc**** >> http://www.fluxlabs.net >> Endless Solutions**** >> *Office* : 850-588-4626**** >> *Cell* : 850-890-2543 >> *Fax* : 850-254-2955 >> >> On Nov 11, 2011, at 8:54 AM, [email protected] wrote: >> >> Hello, >> >> [root@testvps MailScanner]# postconf -n >> alias_database = hash:/etc/aliases >> alias_maps = hash:/etc/aliases >> command_directory = /usr/sbin >> config_directory = /etc/postfix >> daemon_directory = /usr/libexec/postfix >> debug_peer_level = 2 >> header_checks = regexp:/etc/postfix/header_checks >> html_directory = no >> inet_interfaces = all >> mail_owner = postfix >> mailq_path = /usr/bin/mailq.postfix >> manpage_directory = /usr/share/man >> mydestination = $myhostname, localhost.$mydomain, localhost >> mydomain = dhavalsoni.com >> myhostname = testvps.xyz.com >> myorigin = $myhostname >> newaliases_path = /usr/bin/newaliases.postfix >> queue_directory = /var/spool/postfix >> readme_directory = /usr/share/doc/postfix-2.3.3/README_FILES >> relay_domains = mysql:/etc/postfix/mysql-relay_domains.cf >> relay_recipient_maps = mysql:/etc/postfix/mysql-relay_recipients.cf >> sample_directory = /usr/share/doc/postfix-2.3.3/samples >> sendmail_path = /usr/sbin/sendmail.postfix >> setgid_group = postdrop >> transport_maps = mysql:/etc/postfix/mysql-transports.cf >> unknown_local_recipient_reject_code = 550 >> >> >> On Fri, Nov 11, 2011 at 8:13 PM, Jeremy McSpadden <[email protected]>wrote: >> >>> You need to use the postfix rpm from the plus repo. Your current does >>> not support MySQL. >>> postconf -n >>> >>> >>> -- >>> Jeremy McSpadden >>> >>> On Nov 11, 2011, at 8:42 AM, "[email protected]" < >>> [email protected]> wrote: >>> >>> Hello, >>> >>> I am getting below error while setting up MTA with baruwa. >>> >>> Nov 11 17:36:41 testvps postfix/qmgr[24327]: fatal: unsupported >>> dictionary type: mysql >>> Nov 11 17:36:42 testvps postfix/master[24224]: warning: process >>> /usr/libexec/postfix/qmgr pid 24327 exit status 1 >>> Nov 11 17:36:42 testvps postfix/master[24224]: warning: >>> /usr/libexec/postfix/qmgr: bad command startup -- throttling >>> Nov 11 17:36:51 testvps postfix/smtpd[24328]: fatal: unsupported >>> dictionary type: mysql >>> Nov 11 17:36:52 testvps postfix/master[24224]: warning: process >>> /usr/libexec/postfix/smtpd pid 24328 exit status 1 >>> Nov 11 17:36:52 testvps postfix/master[24224]: warning: >>> /usr/libexec/postfix/smtpd: bad command startup -- throttling >>> >>> I have followed http://www.baruwa.org/docs/install_centos.html to >>> install Baruwa and >>> http://readthedocs.org/docs/baruwa/en/latest/integration.html#postfixfor >>> MTA integration. >>> >>> I am running this setup on Centos 5.7 32 bit. >>> >>> Do let me know if you need further information on the same. >>> >>> Thank you, >>> >>> -- >>> Kind regards, >>> Dhaval Soni ( RHCA ) >>> >>> Active Contributor of *LinuxArticles.org* <http://LinuxArticles.org/> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >>> >>> _______________________________________________ >>> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >>> >>> >> >> >> -- >> Kind regards, >> Dhaval Soni ( RHCA ) >> >> Active Contributor of *LinuxArticles.org* <http://LinuxArticles.org/> >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> >> >> _______________________________________________ >> Keep Baruwa FREE - http://pledgie.com/campaigns/12056 >> >> > > > -- > Kind regards, > Dhaval Soni ( RHCA ) > > Active Contributor of *LinuxArticles.org* <http://LinuxArticles.org/> > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > > > _______________________________________________ > Keep Baruwa FREE - http://pledgie.com/campaigns/12056 > > -- Kind regards, Dhaval Soni ( RHCA ) Active Contributor of *LinuxArticles.org* <http://LinuxArticles.org>
_______________________________________________ Keep Baruwa FREE - http://pledgie.com/campaigns/12056
