1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    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...