Results 1 to 4 of 4

Thread: Building SVN for CentOS 4.4 (mysql)

  1. #1
    Join Date
    Nov 2006
    Posts
    10
    Rep Power
    9

    Default Building SVN for CentOS 4.4 (mysql)

    Hello,

    According to the build howto, it has you use the binary mysql-standard-4.1.20-pc-linux-gnu-i686-glibc23 tarball. However looking at the directory structure and md5sums of the binaries included in the RHEL4 binary package, it would seem that a real compile is being done.

    I have compiled my own using these configure options:

    Code:
    CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"
    ./configure --prefix=/opt/zimbra/mysql-standard-4.1.20-pc-linux-gnu-i686-glibc23 --enable-assembler --with-mysqld-ldflags=-all-static
    It seems to work (I can add users at least), however the mysqld processes are quite abundant:

    Code:
    12883 pts/1    S      0:00 su - zimbra
    12884 pts/1    S      0:00 -bash
    16658 ?        S      0:00 [pdflush]
    16662 ?        S      0:00 [pdflush]
    17097 ?        Ssl    0:00 /opt/zimbra/openldap-2.3.21/libexec/slapd -l LOCAL0 -
    17380 pts/1    S      0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --de
    17397 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-
    17423 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmmtaconfig
    17515 pts/1    S      0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-
    17520 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17543 pts/1    S      0:01 /usr/bin/perl /tmp/.swatch_script.17397
    17550 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17551 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17552 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17553 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17578 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17599 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17611 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
    17628 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17629 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17630 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17631 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17632 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17636 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17637 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17638 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17639 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17668 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17669 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17672 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17673 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    17760 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    17912 ?        Ss     0:00 /opt/zimbra/libexec/zmtomcatmgr start -Xms55m -Xmx55m
    17913 ?        Sl     0:41 /opt/zimbra/jdk1.5.0_08/bin/java -Xms55m -Xmx55m -cli
    18104 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/swatch --config-fil
    18112 ?        Ss     0:00 /opt/zimbra/clamav/bin/freshclam --config-file=/opt/z
    18114 pts/1    S      0:01 /usr/bin/perl /tmp/.swatch_script.18104
    18117 ?        Ss     0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    18119 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    18120 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    18121 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    18122 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    18123 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    18210 ?        Ss     0:00 /opt/zimbra/clamav/sbin/clamd --config-file /opt/zimb
    18230 ?        Ss     0:00 /opt/zimbra/postfix-2.2.9/libexec/master
    18247 ?        S      0:00 pickup -l -t fifo -u
    18248 ?        S      0:00 qmgr -l -t fifo -u
    18282 ?        Ss     0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    18283 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    18284 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    18285 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    18286 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    18302 ?        Ss     0:02 amavisd (master)
    18395 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    18497 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    18524 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    18538 ?        S      0:00 amavisd (ch1-avail)
    18539 ?        S      0:00 amavisd (virgin child)
    18540 ?        S      0:00 amavisd (virgin child)
    18541 ?        S      0:00 amavisd (virgin child)
    18546 ?        S      0:00 amavisd (virgin child)
    18547 ?        S      0:00 amavisd (virgin child)
    18548 ?        S      0:00 amavisd (virgin child)
    18549 ?        S      0:00 amavisd (virgin child)
    18558 ?        S      0:00 amavisd (virgin child)
    18559 ?        S      0:00 amavisd (virgin child)
    19478 pts/1    S      0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    19536 ?        S      0:00 tlsmgr -l -t unix -u
    19935 pts/1    S      0:00 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    21386 ?        S      0:00 showq -t unix -u
    With the RHEL4 binary package the mysqld processes are much fewer:

    Code:
    23211 pts/1    S      0:00 su - zimbra
    23212 pts/1    S+     0:00 -bash
    23304 ?        Ssl    0:00 /opt/zimbra/openldap-2.3.21/libexec/slapd -l LOCAL0 -
    23594 pts/1    S      0:00 /bin/sh /opt/zimbra/logger/mysql/bin/mysqld_safe --de
    23613 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/logswatch --config-
    23668 pts/1    Sl     0:01 /opt/zimbra/logger/mysql/libexec/mysqld --defaults-fi
    23670 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmmtaconfig
    23724 pts/1    S      0:00 /bin/sh /opt/zimbra/mysql/bin/mysqld_safe --defaults-
    23806 pts/1    Sl     0:00 /opt/zimbra/mysql/libexec/mysqld --defaults-file=/opt
    23845 pts/1    S      0:01 /usr/bin/perl /tmp/.swatch_script.23613
    23860 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/zmlogger
    24126 ?        Ss     0:00 /opt/zimbra/libexec/zmtomcatmgr start -Xms55m -Xmx55m
    24127 ?        Sl     0:17 /opt/zimbra/jdk1.5.0_08/bin/java -Xms55m -Xmx55m -cli
    24316 pts/1    S      0:00 /usr/bin/perl /opt/zimbra/libexec/swatch --config-fil
    24322 ?        Ss     0:00 /opt/zimbra/clamav/bin/freshclam --config-file=/opt/z
    24323 pts/1    S      0:00 /usr/bin/perl /tmp/.swatch_script.24316
    24327 ?        Ss     0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    24330 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    24331 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    24332 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    24343 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    24344 ?        S      0:00 /opt/zimbra/httpd-2.0.54/bin/httpd -k start -f /opt/z
    24423 ?        Ss     0:00 /opt/zimbra/postfix-2.2.9/libexec/master
    24426 ?        S      0:00 pickup -l -t fifo -u
    24427 ?        S      0:00 qmgr -l -t fifo -u
    24436 ?        Ss     0:00 /opt/zimbra/clamav/sbin/clamd --config-file /opt/zimb
    24471 ?        Ss     0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    24472 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    24473 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    24474 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    24475 ?        S      0:00 /opt/zimbra/cyrus-sasl-2.1.21.ZIMBRA/sbin/saslauthd -
    24514 ?        Ss     0:02 amavisd (master)
    24751 ?        S      0:00 amavisd (virgin child)
    24752 ?        S      0:00 amavisd (virgin child)
    24768 ?        S      0:00 amavisd (virgin child)
    24769 ?        S      0:00 amavisd (virgin child)
    24770 ?        S      0:00 amavisd (virgin child)
    24771 ?        S      0:00 amavisd (virgin child)
    24780 ?        S      0:00 amavisd (virgin child)
    24781 ?        S      0:00 amavisd (virgin child)
    24782 ?        S      0:00 amavisd (virgin child)
    24783 ?        S      0:00 amavisd (virgin child)
    24948 ?        S      0:00 showq -t unix -u
    Does anyone know what configure options I should be using to build the mysql source? Whatever the Zimbra folks are using for the RHEL4 mysql build would be most useful.

    Any help/suggestions would be greatly appreciated!

  2. #2
    Join Date
    Nov 2006
    Posts
    10
    Rep Power
    9

    Default

    I found a solution to the too many mysqld processes. I just compiled mysql with none of the extra flags (just prefix) and it worked.

    Code:
    ./configure --prefix=/opt/zimbra/mysql-standard-4.1.20-pc-linux-gnu-i686-glibc23
    I now have a working CentOS 4.4 Zimbra build (4.0.4_GA_494)!

    Does anyone know if there is a way to checkout the 4.0.4_GA_457 version from SVN? Are the updates put into the EDISON branch safe enough for production?

  3. #3
    Join Date
    Jan 2006
    Posts
    81
    Rep Power
    9

    Default

    It would be helpful if you haven't already, to put your solutions in the wiki so that people can more easily find them.
    Jacob Turner
    Ringnebula Systems - Ukiah, CA

  4. #4
    Join Date
    Jul 2006
    Posts
    623
    Rep Power
    10

    Default

    The goal is to get the SVN versions tagged with the appropriate releases but until then, internally the EDISON branch is locked so it is should be considered stable.

    Mysql is internally compiled for each platform but we try to maintain options as close to the Mysql binary releases as possible. Usually these are just pulled straight from the options in the rpm spec files they publish.

    Code:
    CFLAGS="-O3" CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti" ./configure --enable-local-infile --enable-assembler --with-extra-charsets=complex --enable-thread-safe-client --with-readline --with-mysqld-ldflags=-all-static --libdir=/opt/zimbra/mysql-$(MYSQL_VERSION)/lib --prefix=/opt/zimbra/mysql-$(MYSQL_VERSION)

Similar Threads

  1. Zimbra fails after working for 2 weeks
    By Linsys in forum Administrators
    Replies: 10
    Last Post: 10-07-2008, 01:42 AM
  2. Zimbra wont start, only LDAP...
    By redbaron in forum Installation
    Replies: 14
    Last Post: 08-11-2007, 12:17 AM
  3. Building SVN for CentOS 4.4 (jakarta-tomcat)
    By GrepACE in forum Developers
    Replies: 1
    Last Post: 12-13-2006, 01:45 PM
  4. Replies: 18
    Last Post: 03-20-2006, 02:22 PM
  5. Can't start MySQL to init db - Gentoo
    By fak3r in forum Installation
    Replies: 3
    Last Post: 10-10-2005, 07:59 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •