Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-6760

init script ignored lower_case_table_names in the mariadb section

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Cannot Reproduce
    • Affects Version/s: 10.0.13
    • Fix Version/s: N/A
    • Component/s: OTHER
    • Labels:
      None

      Description

      After a fresh install on centos 6.5 via yum
      lower_case_table_names=1 set in /etc/my.cnf.d/server.cnf in [mariadb-10.0] section.

      After restart the variable is not set !

      setting lower_case_table_names in the [mysqld] section works

        Gliffy Diagrams

          Attachments

            Activity

            Hide
            elenst Elena Stepanova added a comment - - edited

            Works for me:

            $ cat /etc/my.cnf.d/server.cnf 
            #
            # These groups are read by MariaDB server.
            # Use it for options that only the server (but not clients) should see
            #
            # See the examples of server my.cnf files in /usr/share/mysql/
            #
            
            # this is read by the standalone daemon and embedded servers
            [server]
            
            # this is only for the mysqld standalone daemon
            [mysqld]
            
            # this is only for embedded server
            [embedded]
            
            # This group is only read by MariaDB servers, not by MySQL.
            # If you use the same .cnf file for MySQL and MariaDB,
            # you can put MariaDB-only options here
            [mariadb]
            
            # This group is only read by MariaDB-10.0 servers.
            # If you use the same .cnf file for MariaDB of different versions,
            # use this group for options that older servers don't understand
            [mariadb-10.0]
            lower_case_table_names=1
            
            $ mysql -uroot
            Welcome to the MariaDB monitor.  Commands end with ; or \g.
            Your MariaDB connection id is 3
            Server version: 10.0.13-MariaDB MariaDB Server
            
            Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others.
            
            Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
            
            MariaDB [(none)]> select @@lower_case_table_names;
            +--------------------------+
            | @@lower_case_table_names |
            +--------------------------+
            |                        1 |
            +--------------------------+
            1 row in set (0.00 sec)
            

            Could you please double-check, maybe restart didn't work, or something?

            Show
            elenst Elena Stepanova added a comment - - edited Works for me: $ cat /etc/my.cnf.d/server.cnf # # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # # See the examples of server my.cnf files in /usr/share/mysql/ # # this is read by the standalone daemon and embedded servers [server] # this is only for the mysqld standalone daemon [mysqld] # this is only for embedded server [embedded] # This group is only read by MariaDB servers, not by MySQL. # If you use the same .cnf file for MySQL and MariaDB, # you can put MariaDB-only options here [mariadb] # This group is only read by MariaDB-10.0 servers. # If you use the same .cnf file for MariaDB of different versions, # use this group for options that older servers don't understand [mariadb-10.0] lower_case_table_names=1 $ mysql -uroot Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 3 Server version: 10.0.13-MariaDB MariaDB Server Copyright (c) 2000, 2014, Oracle, SkySQL Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> select @@lower_case_table_names; +--------------------------+ | @@lower_case_table_names | +--------------------------+ | 1 | +--------------------------+ 1 row in set (0.00 sec) Could you please double-check, maybe restart didn't work, or something?
            Hide
            stephane@skysql.com VAROQUI Stephane added a comment -

            Thanks Elena i'll point this to our client, for him to re-check.

            Show
            stephane@skysql.com VAROQUI Stephane added a comment - Thanks Elena i'll point this to our client, for him to re-check.
            Hide
            elenst Elena Stepanova added a comment -

            Closing for now as 'Cannot Reproduce', please comment to re-open if you get new information.

            Show
            elenst Elena Stepanova added a comment - Closing for now as 'Cannot Reproduce', please comment to re-open if you get new information.

              People

              • Assignee:
                Unassigned
                Reporter:
                stephane@skysql.com VAROQUI Stephane
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Due:
                  Created:
                  Updated:
                  Resolved: