The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

warning: World-writeable config file /etc/my.cnf is ignored

Discussion in 'General Discussion' started by blackadder, Jan 17, 2004.

  1. blackadder

    blackadder Member

    Joined:
    Aug 21, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    I am getting this message all over the place, it has only just started happeneing. Anyone know the reason for this?
     
  2. allenhui

    allenhui Well-Known Member

    Joined:
    Aug 17, 2003
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    You have someting wrong with your mysql setting.
    Try to use ssh to vi /etc/my.cnf
     
  3. blackadder

    blackadder Member

    Joined:
    Aug 21, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    I have been using this MySQL .cnf file for 3 months now and no problems, but suddenly this. :confused:

    Here is my .cnf file...

    [mysqld]
    set-variable = max_connections=500
    key_buffer = 16M
    myisam_sort_buffer_size = 64M
    join_buffer_size = 2M
    read_buffer_size = 2M
    sort_buffer_size = 3M
    table_cache = 1500
    thread_cache_size = 128
    wait_timeout = 14400
    connect_timeout = 10
    max_allowed_packet = 16M
    max_connect_errors = 10
    query_cache_limit = 1M
    query_cache_size = 32M
    query_cache_type = 1
    skip-innodb

    [mysqld_safe]
    open_files_limit = 8192

    [mysqldump]
    quick
    max_allowed_packet = 16M

    [myisamchk]
    key_buffer = 64M
    sort_buffer = 64M
    read_buffer = 16M
    write_buffer = 16M
     
  4. blackadder

    blackadder Member

    Joined:
    Aug 21, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    In fact, since I updated my CP to WHM 8.6.0 cPanel 8.6.0-R21 earlier today everything seems to have gone pear shaped...

    SSH
    Exim
    exim (exim-4.24-30_cpanel_stmpcontrol_antivirus_rewrite_mailman2) failed

    MySQL
    And I cannot send any email...!

    Before I upgraded everything was running fine.
     
  5. allenhui

    allenhui Well-Known Member

    Joined:
    Aug 17, 2003
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16

    Can you post your cnf to let me check?
     
  6. allenhui

    allenhui Well-Known Member

    Joined:
    Aug 17, 2003
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16

    there is some missing line as i see~
     
  7. blackadder

    blackadder Member

    Joined:
    Aug 21, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    This has been fixed.

    Somehow, I do not know how, files such as my.cnf, exim.conf and my SSH directory were all CHMOD 777.

    After the SSH directory and files were set back to 600, I could log in and CHMOD my.cnf and exim.conf back to 600 and bingo, I now have email again and I do not receive the error about my.cnf.

    All I remember doing is upgrading WHM/cPanel, then the problems started, no idea how these files got the wrong CHMOD values.

    By the way allenhui, what lines are missing from my.cnf? I would like to have that file properly configured. :)
     
  8. allenhui

    allenhui Well-Known Member

    Joined:
    Aug 17, 2003
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    Let have a look on my config file,
    I have probably optimize the mysql due ot high loading on my server,it really works and the loading of the server is probabaly normal.

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    skip-locking
    skip-innodb
    query_cache_limit=1M
    query_cache_size=32M
    query_cache_type=1
    max_connections=1000
    interactive_timeout=100
    wait_timeout=100
    connect_timeout=10
    thread_cache_size=128
    key_buffer=16M
    join_buffer=1M
    max_allowed_packet=16M
    table_cache=1024
    record_buffer=1M
    sort_buffer_size=2M
    read_buffer_size=2M
    max_connect_errors=10
    # Try number of CPU's*2 for thread_concurrency
    thread_concurrency=2 <--- Try 4 for dual pentiums
    myisam_sort_buffer_size=64M
    log-bin
    server-id=1

    [mysql.server]
    user=mysql
    basedir=/var/lib

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/lib/mysql/mysql.pid <-- Not necessary
    open_files_limit=8192

    [mysqldump]
    quick
    max_allowed_packet=16M

    [mysql]
    no-auto-rehash
    #safe-updates

    [isamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [myisamchk]
    key_buffer=64M
    sort_buffer=64M
    read_buffer=16M
    write_buffer=16M

    [mysqlhotcopy]
    interactive-timeout
     
  9. blackadder

    blackadder Member

    Joined:
    Aug 21, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    1
    Thanks for the info. :)
     
  10. allenhui

    allenhui Well-Known Member

    Joined:
    Aug 17, 2003
    Messages:
    105
    Likes Received:
    0
    Trophy Points:
    16
    You are welcome~
     
Loading...

Share This Page