1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice

Can't modify my.cnf file

Discussion in 'Plesk for Linux - 8.x and Older' started by juanchi, Mar 27, 2005.

  1. juanchi

    juanchi Guest

    0
     
    This is my actual my.cnf file:

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock

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

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    Then I tried to include this three lines:

    set-variable = interactive_timeout = 120
    set-variable = wait_timeout = 120
    set-variable = max_connections = 200

    Like this:

    [mysqld]
    datadir=/var/lib/mysql
    socket=/var/lib/mysql/mysql.sock
    set-variable = interactive_timeout = 120
    set-variable = wait_timeout = 120
    set-variable = max_connections = 200


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

    [safe_mysqld]
    err-log=/var/log/mysqld.log
    pid-file=/var/run/mysqld/mysqld.pid

    But when I restart mysqld service the conection to the database is broken, I can't log to the plesk control panel.

    This is part of my mysqld.log file:

    050327 22:07:27 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'

    050327 22:07:27 mysqld ended

    050327 22:07:29 mysqld started
    050327 22:07:29 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'

    050327 22:07:29 mysqld ended

    050327 22:08:11 mysqld started
    050327 22:08:11 /usr/libexec/mysqld: unknown variable 'interactive_timeout = 120'

    050327 22:08:11 mysqld ended

    050327 22:09:03 mysqld started
    050327 22:09:04 InnoDB: Started
    /usr/libexec/mysqld: ready for connections.
    Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    050327 22:09:06 /usr/libexec/mysqld: Normal shutdown

    050327 22:09:06 InnoDB: Starting shutdown...
    A mysqld process already exists at Sun Mar 27 22:09:06 EST 2005
    050327 22:09:08 InnoDB: Shutdown completed
    050327 22:09:08 /usr/libexec/mysqld: Shutdown Complete

    050327 22:09:08 mysqld ended

    050327 22:10:54 mysqld started
    050327 22:10:54 InnoDB: Started
    /usr/libexec/mysqld: ready for connections.
    Version: '4.0.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution
    050327 22:10:56 /usr/libexec/mysqld: Normal shutdown

    050327 22:10:56 InnoDB: Starting shutdown...
    A mysqld process already exists at Sun Mar 27 22:10:56 EST 2005
    050327 22:10:58 InnoDB: Shutdown completed
    050327 22:10:58 /usr/libexec/mysqld: Shutdown Complete

    050327 22:10:58 mysqld ended

    050327 22:12:11 mysqld started

    If I reverse this changes everything works fine again, I don't know what I'm doing wrong, I used both pico and nano.
     
Loading...