MySql 5 - Linux

This is a discussion on MySql 5 - Linux ; I have installed MySQL 5 which i downloaded from the MySQL.org site (installation wan on a clean version of RedHat AS 4) I have installed the following files MySQL-server-standard-5.0.18-0.rhel4.i386.rpm MySQL-client-standard-5.0.18-0.rhel4.i386.rpm after the instalation, mysql tryed to start automaticly but failed ...

+ Reply to Thread
Results 1 to 4 of 4

Thread: MySql 5

  1. MySql 5

    I have installed MySQL 5 which i downloaded from the MySQL.org site
    (installation wan on a clean version of RedHat AS 4)

    I have installed the following files

    MySQL-server-standard-5.0.18-0.rhel4.i386.rpm
    MySQL-client-standard-5.0.18-0.rhel4.i386.rpm




    after the instalation, mysql tryed to start automaticly but failed with
    out errors printed into shell

    this is part od var/log/messages


    Jul 27 13:12:03 localhost kernel: audit(1153998720.940:0): avc: denied
    { append } for pid=2342 exe=/usr/sbin/mysqld
    path=/var/lib/mysql/localhost.localdomain.err dev=dm-0 ino=3819465
    scontext=user_u:system_r:mysqld_t tcontext=rootbject_r:var_lib_t
    tclass=file
    Jul 27 13:12:03 localhost kernel: audit(1153998720.940:0): avc: denied
    { append } for pid=2342 exe=/usr/sbin/mysqld
    path=/var/lib/mysql/localhost.localdomain.err dev=dm-0 ino=3819465
    scontext=user_u:system_r:mysqld_t tcontext=rootbject_r:var_lib_t
    tclass=file
    Jul 27 13:12:03 localhost kernel: audit(1153998723.440:0): avc: denied
    { write } for pid=2342 exe=/usr/sbin/mysqld name=mysql dev=dm-0
    ino=3819462 scontext=user_u:system_r:mysqld_t
    tcontext=rootbject_r:var_lib_t tclass=dir
    Jul 27 13:12:03 localhost xinetd[2248]: xinetd Version 2.3.13 started
    with libwrap loadavg options compiled in.
    Jul 27 13:12:03 localhost xinetd[2248]: Started working: 0 available
    services
    Jul 27 13:12:04 localhost kernel: audit(1153998724.071:0): avc: denied
    { write } for pid=2342 exe=/usr/sbin/mysqld name=mysql dev=dm-0
    ino=3819462 scontext=user_u:system_r:mysqld_t
    tcontext=rootbject_r:var_lib_t tclass=dir




    What could that be? and does anyone know a sollution to the problem?




    --
    You're not payed to think. A mindless worker is a happy worker. Shut up
    and do your job!

  2. Re: MySql 5

    feudalac! wrote:
    > I have installed MySQL 5 which i downloaded from the MySQL.org site
    > (installation wan on a clean version of RedHat AS 4)
    >
    > I have installed the following files
    >
    > MySQL-server-standard-5.0.18-0.rhel4.i386.rpm
    > MySQL-client-standard-5.0.18-0.rhel4.i386.rpm
    >
    >
    >
    >
    > after the instalation, mysql tryed to start automaticly but failed with
    > out errors printed into shell
    >
    > this is part od var/log/messages
    >
    >
    > Jul 27 13:12:03 localhost kernel: audit(1153998720.940:0): avc: denied
    > { append } for pid=2342 exe=/usr/sbin/mysqld
    > path=/var/lib/mysql/localhost.localdomain.err dev=dm-0 ino=3819465
    > scontext=user_u:system_r:mysqld_t tcontext=rootbject_r:var_lib_t
    > tclass=file
    > Jul 27 13:12:03 localhost kernel: audit(1153998720.940:0): avc: denied
    > { append } for pid=2342 exe=/usr/sbin/mysqld
    > path=/var/lib/mysql/localhost.localdomain.err dev=dm-0 ino=3819465
    > scontext=user_u:system_r:mysqld_t tcontext=rootbject_r:var_lib_t
    > tclass=file
    > Jul 27 13:12:03 localhost kernel: audit(1153998723.440:0): avc: denied
    > { write } for pid=2342 exe=/usr/sbin/mysqld name=mysql dev=dm-0
    > ino=3819462 scontext=user_u:system_r:mysqld_t
    > tcontext=rootbject_r:var_lib_t tclass=dir
    > Jul 27 13:12:03 localhost xinetd[2248]: xinetd Version 2.3.13 started
    > with libwrap loadavg options compiled in.
    > Jul 27 13:12:03 localhost xinetd[2248]: Started working: 0 available
    > services
    > Jul 27 13:12:04 localhost kernel: audit(1153998724.071:0): avc: denied
    > { write } for pid=2342 exe=/usr/sbin/mysqld name=mysql dev=dm-0
    > ino=3819462 scontext=user_u:system_r:mysqld_t
    > tcontext=rootbject_r:var_lib_t tclass=dir
    >
    >
    >
    >
    > What could that be? and does anyone know a sollution to the problem?
    >
    >
    >

    It appears your kernel has some type of process auditing enabled, and
    thus is disallowing mysqld to write to
    /var/lib/mysql/localhost.localdomain.err

    Check your configuration. I have never used Red Hat before, but I can
    determine a error message's meaning just by reading it.

  3. Re: MySql 5

    Segin izlupa:

    > feudalac! wrote:
    > > I have installed MySQL 5 which i downloaded from the MySQL.org site
    > > (installation wan on a clean version of RedHat AS 4)
    > >
    > > I have installed the following files
    > >
    > > MySQL-server-standard-5.0.18-0.rhel4.i386.rpm
    > > MySQL-client-standard-5.0.18-0.rhel4.i386.rpm
    > >
    > >
    > >
    > >
    > > after the instalation, mysql tryed to start automaticly but failed
    > > with out errors printed into shell
    > >
    > > this is part od var/log/messages
    > >
    > >
    > > Jul 27 13:12:03 localhost kernel: audit(1153998720.940:0): avc:
    > > denied { append } for pid=2342 exe=/usr/sbin/mysqld
    > > path=/var/lib/mysql/localhost.localdomain.err dev=dm-0 ino=3819465
    > > scontext=user_u:system_r:mysqld_t tcontext=rootbject_r:var_lib_t
    > > tclass=file
    > > Jul 27 13:12:03 localhost kernel: audit(1153998720.940:0): avc:
    > > denied { append } for pid=2342 exe=/usr/sbin/mysqld
    > > path=/var/lib/mysql/localhost.localdomain.err dev=dm-0 ino=3819465
    > > scontext=user_u:system_r:mysqld_t tcontext=rootbject_r:var_lib_t
    > > tclass=file
    > > Jul 27 13:12:03 localhost kernel: audit(1153998723.440:0): avc:
    > > denied { write } for pid=2342 exe=/usr/sbin/mysqld name=mysql
    > > dev=dm-0 ino=3819462 scontext=user_u:system_r:mysqld_t
    > > tcontext=rootbject_r:var_lib_t tclass=dir
    > > Jul 27 13:12:03 localhost xinetd[2248]: xinetd Version 2.3.13
    > > started with libwrap loadavg options compiled in.
    > > Jul 27 13:12:03 localhost xinetd[2248]: Started working: 0 available
    > > services
    > > Jul 27 13:12:04 localhost kernel: audit(1153998724.071:0): avc:
    > > denied { write } for pid=2342 exe=/usr/sbin/mysqld name=mysql
    > > dev=dm-0 ino=3819462 scontext=user_u:system_r:mysqld_t
    > > tcontext=rootbject_r:var_lib_t tclass=dir
    > >
    > >
    > >
    > >
    > > What could that be? and does anyone know a sollution to the problem?
    > >
    > >
    > >

    > It appears your kernel has some type of process auditing enabled, and
    > thus is disallowing mysqld to write to
    > /var/lib/mysql/localhost.localdomain.err
    >
    > Check your configuration. I have never used Red Hat before, but I can
    > determine a error message's meaning just by reading it.


    thanks...


    after i did this
    /etc/selinux/config
    SELINUX=disabled

    the error is gone

    now i have the following entry in var/log/messages
    Jul 27 15:21:54 localhost lsb_log_message: failed

    but in /var/lib/mysql/localhost.localdomain.err i have
    Fatal Error: Can't open and lock privilege tables: mysql.host doesn't
    exist


    thanks


    --
    You're not payed to think. A mindless worker is a happy worker. Shut up
    and do your job!

  4. Re: MySql 5

    feudalac!, on 07/28/2006 02:01 AM said:
    >
    > but in /var/lib/mysql/localhost.localdomain.err i have
    > Fatal Error: Can't open and lock privilege tables: mysql.host doesn't
    > exist
    >


    MySQL has a set of instructions that you need to follow to initialize
    the 'mysql' database and the tables that reside in it.

    Running 'mysql_install_db' should fix the problem. After that, run
    mysql_secure_installation to set a MySQL root password and configure
    some other options to create a secure MySQL installation. You may need
    to run these commands as the 'mysql' user; check the documentation to be
    sure.

    -- Mike

    --
    Michael B. Trausch http://www.trausch.us/

    Pidgin 2.1.0 repository for Feisty: http://www.trausch.us/pidgin

+ Reply to Thread