CentOS 7 build at JLab No Go in CentOS 7 Container

This was a suspicion. Problem is the mysqlclient library coming from a non-standard rpm at JLab:

sh-4.2$ hd_root
hd_root: error while loading shared libraries: libmysqlclient.so.20: cannot open shared object file: No such file or directory
Advertisements

MySQL vs. Mariadb on the JLab farm

Told Andrew to forget about switching to standard Mariadb on the farm. Too much hassle.

  • All of the farm and ifarm would have to change all at once.
  • Explanation to folks that there would be two flavors of binaries, those with the old libraries and those with the new.
  • Possible unintended consequences.

Options for containers

  1. Create a CentOS container with the JLab MySQL rpms installed.
  2. Do a separate build of our software for a Mariadb container.

 

Cannot write to, dump from CCDB

problems with mysqldump and writing constants to ccdb. mysqldump error was:

mysqldump: Got error: 1044: Access denied for user ‘ccdb_user’@’%.jlab.org’ to database ‘ccdb’ when using LOCK TABLES

seemed like mysql was marking the connection as coming from host “%” and not host “%.jlab.org”. That caused reduced privileges for user = ccdb_user. Here is the line in question:

mysql> select * from user where user=’ccdb_user’ and host = ‘%’;
+——+———–+———-+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+——–+———————–+
| Host | User | Password | Select_priv | Insert_priv | Update_priv | Delete_priv | Create_priv | Drop_priv | Reload_priv | Shutdown_priv | Process_priv | File_priv | Grant_priv | References_priv | Index_priv | Alter_priv | Show_db_priv | Super_priv | Create_tmp_table_priv | Lock_tables_priv | Execute_priv | Repl_slave_priv | Repl_client_priv | Create_view_priv | Show_view_priv | Create_routine_priv | Alter_routine_priv | Create_user_priv | Event_priv | Trigger_priv | Create_tablespace_priv | ssl_type | ssl_cipher | x509_issuer | x509_subject | max_questions | max_updates | max_connections | max_user_connections | plugin | authentication_string |
+——+———–+———-+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+——–+———————–+
| % | ccdb_user | | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | N | | | | | 0 | 0 | 0 | 0 | | |
+——+———–+———-+————-+————-+————-+————-+————-+———–+————-+—————+————–+———–+————+—————–+————+————+————–+————+———————–+——————+————–+—————–+——————+——————+—————-+———————+——————–+——————+————+————–+————————+———-+————+————-+————–+—————+————-+—————–+———————-+——–+———————–+
1 row in set (0.00 sec)

There is a corresponding line in the db table referring to host = “%” and user = ccdb_user, database = “ccdb” that allows select privilege only. Wish I had copied that down as well.

Did the fix as follows:

mysql> delete from user where user=’ccdb_user’ and host = ‘%’;
Query OK, 1 row affected (0.00 sec)

mysql> delete from db where user=’ccdb_user’ and host = ‘%’;
Query OK, 1 row affected (0.01 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)