exec commands with quotes fail

[cmeissner]

I need to run command with quotes with compose.exec. With docker-compose command line client I do the following:

$ docker-compose -f services/docker-compose.yml exec <container> sh -c 'mysql --help | head -n 10'
mysql  Ver 15.1 Distrib 10.5.12-MariaDB, for Linux (x86_64) using readline 5.1
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Usage: mysql [OPTIONS] [database]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf 
The following groups are read: mysql mariadb-client client client-server client-mariadb
The following options may be given as the first argument:
--print-defaults          Print the program argument list and exit.

So the command works well. I need to use sh -c '...' because I need to redirect a file into mysql client.

This is my node code (try) to achieve the same from a script:

function exec() {

    if (!fs.existsSync(services_exec)) {
        console.log('exec.yml not found');
    } else {
        let container_commands = yaml.load(fs.readFileSync(services_exec, 'utf8'));

        for(const cc of container_commands['exec_list']) {
            try {
                console.log(`executing "${cc.name}" inside "${cc.container}"`);
                for(const c of cc['commands'])
                {
                    console.log(`executing: ${c}`);
                    compose.exec(cc.container, `${c}`, { config: composeFile, log: true })
                }
            } catch (error) {
                core.setFailed(error.message);
            }
        }
    }
}

If I run the function I get the following error:

executing "initial database" inside "<container>"
executing: sh -c 'mysql --help | head -n 10'
--help: line 1: syntax error: unterminated quoted string
node:internal/process/promises:246
          triggerUncaughtException(err, true /* fromPromise */);
          ^

[UnhandledPromiseRejection: This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason "#<Object>".] {
  code: 'ERR_UNHANDLED_REJECTION'
}

I try different ways to escape the quote but unfortunately I didn't found a way to run this command. How I have to escape the string to let it run?

[AlexZeitler]

I've been able to reproduce it using this simple setup:

version: '3'

services:
  maria:
   image: mariadb
   environment:
     - MARIADB_ROOT_PASSWORD=root

import { exec } from "docker-compose";

exec("maria", "sh -c 'mysql --help | head -n 10'")
  .then((result) => console.log(result))
  .catch((e) => console.log(e));

However I don't have a solution right now.

[AlexZeitler]

Solved it:

import { exec } from "docker-compose";

exec("maria", ["sh", "-c", "mysql --help | head -n 10"])
  .then((result) => console.log(result.out))
  .catch((e) => console.log(e));

$ yarn ts-node index.ts
yarn run v1.22.17
mysql  Ver 15.1 Distrib 10.6.5-MariaDB, for debian-linux-gnu (x86_64) using readline 5.2
Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Usage: mysql [OPTIONS] [database]

Default options are read from the following files in the given order:
/etc/my.cnf /etc/mysql/my.cnf ~/.my.cnf
The following groups are read: mysql mariadb-client client client-server client-mariadb
The following options may be given as the first argument:
--print-defaults          Print the program argument list and exit.

[healergyl]

I want to
docker exec polar-n9-omnicored1 /bin/send_coin.sh 2Mv1pQ2VKQfxJrbfMJJ6ZV7ah3B6KxuDSH3
instead of
const result = await this.execute(compose.exec, node.name, this.getArgs(network));

What should I do?

[healergyl]

or instead of
await compose.exec(
node.name,
' /bin/send_coin.sh 2Mv1pQ2VKQfxJrbfMJJ6ZV7ah3B6KxuDSH3',
this.getArgs(network),
);