Postfix with mysql support in yellowdog 4.0

Thu May 19 14:47:38 MDT 2005

On May 19, 2005, at 3:42 PM, C.J. Harris wrote:

> Thanks, I beleive the mail server is working, but it's
> smtp port is closed from the outside, Is there a
> firewall of some sort installed by default? Other
> machines cannot telnet into my server on port 25 but
> when I try to telnet from the server it's self (telnet
> localhost 25) it works and I see the smtp banner i set
> in the postfix main.cf.

yes.

install webmin and use webmin to adjust the firewall. that is the  
easiest way.

You can do it on the local machine using lynx if you enjoy pain or you  
can use the browser in x windows. the UI for that in webmin is really  
easy.

>
> --- Howard Shere <hshere at greendragon.com> wrote:
>
>>
>> On May 18, 2005, at 3:47 PM, C.J. Harris wrote:
>>
>>> Hello, All I'm new to yellow dog, And my company
>> needs
>>> a isp class mail server, so I installed yellow dog
>>> 4.0
>>> on one of our Apple G5 64bit servers. The problem
>> is
>>> that I need to host virtual email accounts
>> preferably
>>> using postfix, courier-imap/pop, and mysql to
>> store
>>> the information so it can easily be changed. But
>> the
>>> problems I seems like the postfix rpm does not
>> have
>>> the mysql support built into it. So I'm stuck. I
>> can
>>> compile postfix from the source but in order to
>>> compile in the mysql support it needs the location
>> of
>>> mysql headers and  the mysql client library, but
>> since
>>> mysql on yellowdog 4.0 is only available from the
>> rpms
>>> i don't think it has the needed header files and
>>> libraries. Is there a postfix rpm some where that
>> i
>>> can use that has mysql support?  Does any one have
>> any
>>> suggestions?
>>>
>>
>> Yeah. i got this to work using these instuctions:
>>
>>
> http://www.faqs.org/docs/Linux-HOWTO/Postfix-Cyrus-Web-cyradm- 
> HOWTO.html
>>
>> with some work. I had to remcompile several things
>> (includning PHP) to
>> make it all work, but I did finally get it to work.
>> here are some notes
>> I made along the way:
>>
>>
>> This document contains notes about getting the linux
>> mail server for
>> mutantegg.com and greendragon.com to work.
>>
>> I tried several howto docs I found online and
>> finally settled on this
>> one:
>>
>>
> http://www.faqs.org/docs/Linux-HOWTO/Postfix-Cyrus-Web-cyradm- 
> HOWTO.html
>>
>> This gets postfix (for SMTP), cyrus (for IMAP and
>> POP3), sasl and pam
>> (for authentication), mysql for the authentication
>> database and
>> web-cyradm for web based admin of the mail accounts.
>>
>> We also end up with a system which does not require
>> unix accounts on
>> the server for each mail account.
>>
>> While the instructions on the above page are good,
>> they did not work
>> exactly as listed and I am going to try to comment
>> on the things that
>> were different for me using yellow dog linux. The
>> numbers (like 3.1.2)
>> are the sections in the above web page.
>>
>> I still have not updated the kernel on this machine.
>> Doing so probably
>> would not change any of the comments here.
>>
>> As I went through things I made sure to open ports
>> in the firewall.
>>
>> 3.1.2
>>
>> I ended up using mysql-4.1.10a instead of the
>> version listed. This was
>> because I started with a different set of
>> instructions which used the
>> newew mysql and I didn’t want to try backing the new
>> version of mysql
>> out and installing the old one. I used yum to remove
>> the older version
>> before I compiled this and installed it. Because
>> mysql was previously
>> on the system I didn’t have to create the mysql
>> user. It already
>> existed.
>>
>> To get the init.d stuff to work I am pretty sure
>> (not positive) that I
>> had to use the scripts that came with the
>> mysql-4.1.10a package instead
>> of the ones that were already there.
>>
>> 3.2.1
>>
>> This is really db4 and not bdb. I got it with yum
>> instead of building
>> it.
>>
>> 3.3.1
>>
>> I also got this from yum.
>>
>> 3.4.1
>>
>> I got both cyrus-imap and cyrus-sasl from yum.
>>
>> 3.5.1
>>
>> I compiled postfix. I had to alter the paths passed
>> in to point at the
>> place where mysql was as well as use db4 instead of
>> bdb. Later, after I
>> had the mail server working, I wanted to use PCRE in
>> one of the postfix
>> configuration files so I went back and rebuilt
>> postfix with PCRE
>> support. This command builds postfix with PCRE
>> support:
>>
>> make makefiles 'CCARGS=-DHAS_MYSQL -DHAS_PCRE \
>> -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH \
>> -I/usr/include/sasl -I/usr/include/pcre
>> -I/usr/include/db4' \
>> 'AUXLIBS=-L/usr/local/mysql/lib/mysql \
>> -lmysqlclient -lz -lm -lpcre -L/usr/local/lib
>> -lsasl2'
>>
>> And this one is before I turned on PCRE support:
>>
>> make makefiles 'CCARGS=-DHAS_MYSQL \
>> -I/usr/local/mysql/include/mysql -DUSE_SASL_AUTH \
>> -I/usr/include/sasl -I/usr/include/db4' \
>> 'AUXLIBS=-L/usr/local/mysql/lib/mysql \
>> -lmysqlclient -lz -lm -L/usr/local/lib -lsasl2'
>>
>> I just pressed return for all the questions that
>> “make install” asks to
>> install postfix.
>>
>> 3.7.2
>>
>> The paths in the command to build pam needs to point
>> to the mysql
>> install location.
>>
>> 3.8.2
>>
>> When I installed the web-cyradm it didn’t work. It
>> turned out that php
>> was not compiled with mysql support enabled. Also,
>> it used some modules
>> which were not installed (like pear) so I had to use
>> yum to get most of
>> the things and then compile php myself with the
>> following configure
>> command:
>>
>>   './configure' '--host=powerpc-yellowdog-linux-gnu'
>>
>> '--build=powerpc-yellowdog-linux-gnu'
>> '--target=ppc-yellowdog-linux-gnu'
>> '--program-prefix=' '--prefix=/usr'
>> '--exec-prefix=/usr' '--bindir=/usr/bin'
>> '--sbindir=/usr/sbin'
>> '--sysconfdir=/etc' '--datadir=/usr/share'
>> '--includedir=/usr/include'
>> '--libdir=/usr/lib' '--libexecdir=/usr/libexec'
>> '--localstatedir=/var'
>> '--sharedstatedir=/usr/com'
>> '--mandir=/usr/share/man'
>> '--infodir=/usr/share/info'
>> '--cache-file=../config.cache'
>> '--with-config-file-path=/etc'
>> '--with-config-file-scan-dir=/etc/php.d'
>> '--enable-force-cgi-redirect' '--disable-debug'
>> '--enable-pic'
>> '--disable-rpath' '--enable-inline-optimization'
>> '--with-bz2'
>> '--with-db4=/usr' '--with-curl'
>> '--with-exec-dir=/usr/bin'
>> '--with-freetype-dir=/usr' '--with-png-dir=/usr'
>> '--with-gd'
>> '--enable-gd-native-ttf' '--without-gdbm'
>> '--with-gettext'
>> '--with-ncurses' '--with-gmp' '--with-iconv'
>> '--with-jpeg-dir=/usr'
>> '--with-openssl' '--with-png' '--with-pspell'
>> '--with-regex=system'
>> '--with-xml' '--with-expat-dir=/usr'
>> '--with-dom=shared,/usr'
>> '--with-dom-xslt=/usr' '--with-dom-exslt=/usr'
>> '--with-xmlrpc=shared'
> === message truncated ===>
> _______________________________________________
>> yellowdog-general mailing list
>> yellowdog-general at lists.terrasoftsolutions.com
>>
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general
>> HINT: to Google archives, try  '<keywords>
> site:terrasoftsolutions.com'
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam?  Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
> _______________________________________________
> yellowdog-general mailing list
> yellowdog-general at lists.terrasoftsolutions.com
> http://lists.terrasoftsolutions.com/mailman/listinfo/yellowdog-general
> HINT: to Google archives, try  '<keywords> site:terrasoftsolutions.com'
>
>

Howard Shere
http://blogs.greendragon.com/index.php/gdc
Altair 8800a to Mac OS X so far...