Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

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:
    151
    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:
    166
    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:
    151
    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:
    151
    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:
    166

    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:
    166

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

    blackadder Member

    Joined:
    Aug 21, 2003
    Messages:
    7
    Likes Received:
    0
    Trophy Points:
    151
    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:
    166
    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:
    151
    Thanks for the info. :)
     
  10. allenhui

    allenhui Well-Known Member

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

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice