Results 1 to 10 of 10

Thread: Mariadb is unable to follow configurations as defined in /etc/my.cnf

  1. #1
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Talking Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Hello.

    Mariadb is unable to follow configurations as defined in /etc/my.cnf

    From initial /etc/my.cnf :
    Code:
    # If you want to use mysqld_multi uncomment 1 or more mysqld sections
    # below or add your own ones.
    
    # WARNING
    # --------
    # If you uncomment mysqld1 than make absolutely sure, that database mysql,
    # configured above, is not started.  This may result in corrupted data!
    #
    # [mysqld1]
    # port       = 3306
    # datadir    = /var/lib/mysql
    # pid-file   = /var/lib/mysql/mysqld.pid
    # socket     = /var/lib/mysql/mysql.sock
    # user       = mysql
    
    # [mysqld2]
    # port       = 3307
    # datadir    = /var/lib/mysql-databases/mysqld2
    # pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
    # socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
    # user       = mysql
    
    .....
    .....
    .....
    from mysql@.service
    Code:
    [Unit]
    Description=MySQL server - %I instance
    Wants=basic.target
    PartOf=mysql.target
    After=basic.target network.target syslog.target
    
    [Service]
    Restart=on-abort
    Type=simple
    ExecStartPre=/usr/lib/mysql/mysql-systemd-helper  install %i
    ExecStartPre=/usr/lib/mysql/mysql-systemd-helper  upgrade %i
    ExecStart=/usr/lib/mysql/mysql-systemd-helper     start   %i
    ExecStartPost=/usr/lib/mysql/mysql-systemd-helper wait    %i
    
    [Install]
    WantedBy=multi-user.target
    From mysql-systemd-helper which is called with the instance number

    Multiple instances problem 1 : datadir path does not follow what could be in /etc/my.cnf
    Code:
    .....
        if [[ -z "$INSTANCE" ]]; then
            datadir=/var/lib/mysql
            socket="/var/run/mysql/mysql.sock"
        else
            datadir="/var/lib/mysql-$INSTANCE"
            socket="/var/run/mysql/mysql.${INSTANCE}.sock"
        fi
    .....
    Multiple instances problem 2 : /etc/my.cnf is not read
    Code:
    ....
        if [[ -n "$INSTANCE" ]]; then
            opts="$(/usr/bin/my_print_defaults mysqld mysqld_multi "$INSTANCE")"
            tmp_opts="$opts"
            config="/etc/my${INSTANCE}.cnf"
        else
            opts="$(/usr/bin/my_print_defaults mysqld)"
            tmp_opts="$opts"
            config="/etc/my.cnf"
        fi
    ....
    This point can be solved by splitting mysqld% from /etc/my.cnf in /etc/my${INSTANCE}.cnf even if I prefer to have every things in the same file.

    But for the first problem what can I do ?

    I have modified mysql-systemd-helper to read datadir, and socket from /etc/my.cnf (for [mysqld%] )
    But it seems not to be enough.

    Any help is welcome.
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  2. #2

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by jcdole View Post
    But for the first problem what can I do ?
    File a bug report.

    And/or look at this possible workaround I already told you:
    https://forums.opensuse.org/showthre...23#post2858123

  3. #3

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by jcdole View Post
    I have modified mysql-systemd-helper to read datadir, and socket from /etc/my.cnf (for [mysqld%] )
    But it seems not to be enough.
    If you already modify mysql-systemd-helper, you could just as well modify to only use my.cnf instead.

    It might be helpful if you posted your modifications though. How should anybody else know what changes you did, that may be crucial to the solution?
    Also, you might have made a simple mistake.

  4. #4
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by wolfi323 View Post
    If you already modify mysql-systemd-helper, you could just as well modify to only use my.cnf instead.

    It might be helpful if you posted your modifications though. How should anybody else know what changes you did, that may be crucial to the solution?
    Also, you might have made a simple mistake.
    >If you already modify mysql-systemd-helper, you could just as well modify to only use my.cnf instead.
    Yes I did, but somethings is missing because my modifications does not work.

    >Also, you might have made a simple mistake
    Sure.

    Ok. I am going to restart from beginning and send my modifications and screenshots as soon as possible.
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  5. #5
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    I have open a bug report : https://jira.mariadb.org/browse/MDEV-16030
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  6. #6

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by jcdole View Post
    Sorry, I probably wasn't clear enough in this regard.
    I meant to file a bug report at bugzilla.opensuse.org, I think this helper is very openSUSE specific...

  7. #7
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by wolfi323 View Post
    Sorry, I probably wasn't clear enough in this regard.
    I meant to file a bug report at bugzilla.opensuse.org, I think this helper is very openSUSE specific...
    I am sorry. that's my bug.

    Ok I open an opensuse bug.
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  8. #8
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by wolfi323 View Post
    If you already modify mysql-systemd-helper, you could just as well modify to only use my.cnf instead.

    It might be helpful if you posted your modifications though. How should anybody else know what changes you did, that may be crucial to the solution?
    Also, you might have made a simple mistake.
    Here is mysql-systemd-helper modified script : http://paste.opensuse.org/77682310
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  9. #9
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Quote Originally Posted by wolfi323 View Post
    Sorry, I probably wasn't clear enough in this regard.
    I meant to file a bug report at bugzilla.opensuse.org, I think this helper is very openSUSE specific...
    Here it is : http://bugzilla.opensuse.org/show_bug.cgi?id=1091084
    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

  10. #10
    Join Date
    Jun 2008
    Location
    South-West France
    Posts
    1,069

    Default Re: Mariadb is unable to follow configurations as defined in /etc/my.cnf

    Thanks for helping. JCD
    __________
    server leap 15.0 -- ASUS g75vw KDE leap 15.0 -- ASUS g750JZ Optimus KDE leap 15.1 -- acer aspire s13 win 10 home -- HP Omen win 10 home - scan EPSON V500 - Brother HL2250DN - Samsung CLP-325W

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •