Updates from April, 2010 Toggle Comment Threads | Keyboard Shortcuts

  • levin 5:52 pm on April 27, 2010 Permalink | Reply
    Tags:   

    MySQL multiple instance on CentOS howto 

    Create new database instance on new destination

    mkdir /u02/mysql
    mkdir /u02/mysql/data
    mkdir /u02/mysql/log
    mkdir /u02/mysql/run
    mkdir /u02/mysql/lock
    
    chown -R mysql:mysql /u02/mysql
    mysql_install_db --datadir=/u02/mysql/data --user=mysql
    

    (More …)

     
    • Murad 1:11 pm on August 19, 2010 Permalink | Reply

      hello levin…
      after doing ‘ service mysqld.server2 start ‘ i’m getting one error.
      the error is
      ‘ mysqld.server2: unrecognized service ‘
      hope you can help me …
      thanks in advance


      murad

    • levin 2:13 pm on August 19, 2010 Permalink | Reply

      Hi Murad,

      How about /etc/rc.d/init.d/mysqld.server2 start ?

    • Joris Conijn 5:50 pm on October 21, 2010 Permalink | Reply

      Murad, try the following:

      $ chmod +x /etc/init.d/mysqld.server2
      $ service mysqld.server2 start

      The start script in init.d should be executable

  • levin 6:30 am on March 12, 2010 Permalink | Reply
    Tags: cyrus-sasl, postfix, smtp   

    auxpropfunc error no mechanism available errors 

    Overview

    Once you configured Postfix + MySQL + Courier imap + SASL SMTP Auth,

    And you configured SASL with using courier auth daemon as the following config.
    /usr/lib/sasl2/smtpd.conf

    pwcheck_method: authdaemond
    log_level: 3
    mech_list: plain login
    authdaemond_path:/var/spool/authdaemon/socket
    

    You may notice there have a error message when every smtp attempt.

    Mar 12 06:10:32 lxpsrv01 postfix/smtpd[29770]: sql_select option missing
    Mar 12 06:10:32 lxpsrv01 postfix/smtpd[29770]: auxpropfunc error no mechanism available
    Mar 12 06:10:32 lxpsrv01 postfix/smtpd[29770]: auxpropfunc error invalid parameter supplied
    

    Solution

    Remove SASL sql package, because you don’t need it while you configured to use authdaemon instead of direct sql query. Or simply ignore it, it’s no harm and just annoying.

    rpm -e cyrus-sasl-sql
    
     
  • levin 9:04 pm on March 2, 2010 Permalink | Reply
    Tags:   

    Samba 3.4.6 RPM for CentOS 5.4 x86_64 

    Complied on CentOS 5.4 x86_64 using http://www.samba.org/samba/ftp/stable/samba-3.4.6.tar.gz without customization.

    samba-3.4.6-1.x86_64.rpm (665)
    md5: 1a43369d6e9dd8c24b3c24c2c51f9527

    samba-client-3.4.6-1.x86_64.rpm (333)
    md5: 5f2f6eda1faa6c835657cc48f4889cd4

    samba-common-3.4.6-1.x86_64.rpm (314)
    md5: 50af881f6a96c3bbe22e05bef32d981b

    samba-debuginfo-3.4.6-1.x86_64.rpm (272)
    md5: 6c1b8a214fd81bb2f07167a48056b306

    samba-doc-3.4.6-1.x86_64.rpm (268)
    md5: 59310246c7eb38e96e9718266c551d9b

    samba-swat-3.4.6-1.x86_64.rpm (285)
    md5: ac2f6550ae8fbef4f28cd8b4f3247084

     
  • levin 2:01 pm on March 2, 2010 Permalink | Reply
    Tags:   

    MS Document with Samba Changes Owner of File 

    When user B saves a MS document that is owned by user A, the updated file is now owned by user B, and user B saves the file again, the permission reset to owen read only. How do I fix this?

            force create mode = 0770
            force directory mode = 0770
            force security mode = 0770
            force directory security mode = 0770
    

    These two settings will ensure that all directories and files that get created in the share will be readable/writable by the owner and group set on the directory itself.

    http://www.samba.org/samba/docs/man/Samba-HOWTO-Collection/AccessControls.html

     
  • levin 4:06 am on February 25, 2010 Permalink | Reply
    Tags: , , , performance, ,   

    Performance tuning on Apache, PHP, MySQL, WordPress v1.1 – Updated 

    Introduction

    This tutorial is covering the web server performance tunings on MySQL, PHP and Apache, WordPress and BuddyPress or general web hosting purpose, the tuning example is based on CentOS 5.

    The key of the following performance tuning is focus on memory and caching, most of people host a web site or forum or blog without any tunings or even use the all out-of-box setting.

    (More …)

     
    • Chris 10:41 am on August 27, 2010 Permalink | Reply

      Thank for performa tuning server guide.

    • Eric Nielsen 7:31 am on January 21, 2011 Permalink | Reply

      Followed your instructions to setup FastCGI, all worked well accept at the end, when I hit my website, I get:

      #!/bin/bash
      PHP_CGI=/usr/bin/php-cgi
      PHP_FCGI_CHILDREN=16
      PHP_FCGI_MAX_REQUESTS=1000
      export PHP_FCGI_CHILDREN
      export PHP_FCGI_MAX_REQUESTS
      exec $PHP_CGI

      • levin 1:59 pm on January 21, 2011 Permalink | Reply

        Hi, please make sure you have the similar lines as below.

        ScriptAlias /cgi-bin/ “/var/www/cgi-bin/”

        \< Directory "/var/www/cgi-bin" \>
        AllowOverride None
        Options None
        Order allow,deny
        Allow from all
        \< \/Directory \>

  • levin 6:41 pm on December 27, 2009 Permalink | Reply
    Tags:   

    Add a cron job in a command line 

    As you familiar with UNIX cron with crontab -e when you going to add a new schedule cron job.. do you ever tried to add a cron job up to 100 machine?

    Simply to use pipe-in with crontab -l to regenerate the crontab.

    Here you are

    (crontab -l; echo "0 0 * * * /path/to/myscript.sh") | crontab -
    

    Easy?!

     
  • levin 7:48 pm on December 17, 2009 Permalink | Reply
    Tags:   

    Remove IBM HTTP Server Manually 

    There are two ways how to uninstall IBM HTTP Server.
    Automatically by running this command: /opt/IBM/HTTPServer/uninstall/uninstall

    Or Manually only removing the /opt/IBM/HTTPServer directory is not enough. You have to also remove the file /opt/.ibm/.nif/.nifregistry (please, backup the file first, as it will remove other installed IBM websphere family product.

    /opt/.ibm/.nif/.nifregistry

     
  • levin 6:08 pm on December 1, 2009 Permalink | Reply
    Tags:   

    If you have performance issue with WordPress/BuddyPress 

    Story:

    Recently, I have time to investigate on my servers memory usage, I found that most of wordpress running site was taken about 20MB to 30MB memory, and the buddypress site is 60MB (WHAO!).

    Actually, it still not yet hit the bottleneck what i seen in daily, becoz they’re not busy site, but somewhat when i try to stress it with 50 concurrent user loading on the BP site, it was unbelievable slow!

    (More …)

     
c
compose new post
j
next post/next comment
k
previous post/previous comment
r
reply
e
edit
o
show/hide comments
t
go to top
l
go to login
h
show/hide help
shift + esc
cancel