"mysql" client application on login2?

Before the recent change, the “mysql” client application (along with related applications, such as “mysqldump”) was available on “login.ibiblio.org”. Now, on “login2”, these applications are no longer available.

Could you please make these applications available on “login2” once again?

The binaries are there, they’re just under SCL, which is not the default path for users. This is somewhat unfortunate.

[cmpalmer@login2 ~]$ scl --help
usage: scl <action> [<collection>...] <command>
   or: scl -l|--list [<collection>...]
   or: scl register <path>
   or: scl deregister <collection> [--force]

Options:
    -l, --list            list installed Software Collections or packages
                          that belong to them
    -h, --help            display this help and exit

Actions:
    enable                calls enable script from Software Collection
                          (enables a Software Collection)
    <SCL script name>     calls arbitrary script from a Software Collection

Use '-' as <command> to read the command from standard input.
[cmpalmer@login2 ~]$ scl -l
httpd24
rh-mariadb100
rh-mariadb101
rh-php56
rh-php70
rh-php71
rh-php72
rh-php73
rh-python34
rh-python35
rh-python36
sclo-git25
sclo-subversion19

You can have your bash (or other shell) load an scl by default at login by doing something like this:

[cmpalmer@login2 ~]$ cat .enable_scls
  source scl_source enable rh-php72
  source scl_source enable rh-mariadb101
[cmpalmer@login2 ~]$ grep enable_scl ~/.bashrc
. ~/.enable_scls

I’ve taken the liberty of going ahead and setting that up for the ‘confluence’ user, so you should see that on your next login:

[confluence@login2 ~]$ which mysql
/opt/rh/rh-mariadb101/root/usr/bin/mysql

Please let us know if you run into any trouble.

1 Like

A related FYI: I’ve added the rh-php73 packages, so now you can have this:

[cmpalmer@login2 ~]$ which php
/opt/rh/rh-php73/root/usr/bin/php
[cmpalmer@login2 ~]$ php --version
PHP 7.3.11 (cli) (built: Dec 10 2019 16:14:50) ( NTS )
Copyright (c) 1997-2018 The PHP Group
Zend Engine v3.3.11, Copyright (c) 1998-2018 Zend Technologies
    with Zend OPcache v7.3.11, Copyright (c) 1999-2018, by Zend Technologies
    with Xdebug v2.7.2, Copyright (c) 2002-2019, by Derick Rethans
[cmpalmer@login2 ~]$ grep php ~/.enable_scls
  source scl_source enable rh-php73

This worked, thanks for the help. Unfortunately we don’t have write permissions on .bashrc, but we can just run the required SCL command line everytime we need to use mysqldump.

Daniel