MySql Command is override on start

[AlissonMedeiros]

When I start a new MySql container I set a diferent command, but this is override per the method "configure()"

My code:

(MySQLContainer) new MySQLContainer()
                .withDatabaseName("f"+timeStamp)
                .withUsername("f"+timeStamp)
                .withPassword("f"+timeStamp)
                .withCommand("mysqld", "--lower_case_table_names=1")
                .withLogConsumer(new Slf4jLogConsumer(logger));

The code of MYSQLContainer:

    @Override
    protected void configure() {
        optionallyMapResourceParameterAsVolume(MY_CNF_CONFIG_OVERRIDE_PARAM_NAME, "/etc/mysql/conf.d", "mysql-default-conf");

        addExposedPort(3306);
        addEnv("MYSQL_DATABASE", databaseName);
        addEnv("MYSQL_USER", username);
        addEnv("MYSQL_PASSWORD", password);
        addEnv("MYSQL_ROOT_PASSWORD", "test");
        setCommand("mysqld");
        setStartupAttempts(3);
    }

I need this to support case insentive. Do you know athoner way to do this? If not I can fix and open PR.

Another option is add lower_case_table_names=1" in the file my.cnf Or have
a way to add more configurations in the file.

Many thanks.

[bsideup]

Hi @AlissonMedeiros,

That's a bug indeed. For now, you can override MySQLContainer's configure command and set your command there. PR is also highly appreciated (you can just move setCommand to constructor) :)

[AlissonMedeiros]

@bsideup Thanks for help, I try to do this.

[pauldailly]

Hi there, would I be correct in saying the MariaDb test container module also suffers from this same issue?

testcontainers-java/modules/mariadb/src/main/java/org/testcontainers/containers/MariaDBContainer.java

Line 42 in 8402356

setCommand("mysqld");

If so, I'd be happy to start working on a PR similar to #560 if you would like me to?

One thing I am unsure of is the fact there's both a mariadb module in this project and a separate testcontainers-java-module-mariadb repository too. To which repo would I submit the PR?

[kiview]

@pauldailly
Yes, you are right. The correct module is the one in the main repository. We've moved all modules to the main repo at one point in time (mono repo). PR very much appreciated 🙂

[rnorth]

Released in 1.8.1! 🎉

Thanks for flagging this, @AlissonMedeiros and @pauldailly.