[MCOL-538] Argument in alias circumvents ~/.my.cnf option file Created: 2017-01-27  Updated: 2023-10-26  Resolved: 2017-06-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.0.7
Fix Version/s: 1.0.10, 1.1.0

Type: Bug Priority: Minor
Reporter: nathan aschoff Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: nash
Environment:

Debian 8, Single server install

Sprint: 2017-11, 2017-12

 Description   

After following install steps from KB on single server install from deb packages, I noticed that the alias mcsmysql was not reading the options that I wrote in the ~/.my.cnf file.

Alias as set by the install procedure

 
alias mcsmysql='/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-file=/usr/local/mariadb/columnstore/mysql/my.cnf -u root'

Solution (replace --defaults-file with --defaults-extra-file)

Alias as set by myself

 
alias mcsmysql='/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-extra-file=/usr/local/mariadb/columnstore/mysql/my.cnf -u root'



 Comments   
Comment by David Thompson (Inactive) [ 2017-01-27 ]

This seems like a good fix to put in the base alias script.

Comment by Chris Calender (Inactive) [ 2017-05-18 ]

Fyi, I just added this fix as described above.

C:\...\oam\install_scripts>diff columnstoreAlias columnstoreAlias-orig
 
3c3
 
< alias mcsmysql='/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-extra-file=/usr/local/mariadb/columnstore/mysql/my.cnf -u root'
 
---
 
> alias mcsmysql='/usr/local/mariadb/columnstore/mysql/bin/mysql --defaults-file=/usr/local/mariadb/columnstore/mysql/my.cnf -u root'

Comment by David Hill (Inactive) [ 2017-06-02 ]

checked in change that Chris had noted

1.0.10

commit 8ba6db5b36c7668685177fde63376c667145f268
Author: david hill <david.hill@mariadb.com>
Date: Fri Jun 2 09:35:11 2017 -0500

MCOL-538 - change mcsmysql alias

oam/install_scripts/columnstoreAlias | 2 +-

1.1.0

commit 4f2e992a2576e7312cb5f2981d41e2da4d8a01c9
Author: david hill <david.hill@mariadb.com>
Date: Fri Jun 2 09:36:31 2017 -0500

MCOL-538 - change mcsmysql alias

oam/install_scripts/columnstoreAlias | 2 +-

Comment by David Hill (Inactive) [ 2017-06-02 ]

did another release to fix defaults-extra to defaults-extra-file

Comment by Daniel Lee (Inactive) [ 2017-06-06 ]

Builds verified: Github source, 1.0.10, 1.1.0

1.0.10

[root@localhost mariadb-columnstore-server]# git show
commit a02e74550b0e5e5e4995b799ce31e7e5d11f467a
Merge: 478209c dd07cf6
Author: David.Hall <david.hall@mariadb.com>
Date: Fri Jun 2 11:47:32 2017 -0500

[root@localhost mariadb-columnstore-engine]# git show
commit 4d5a59d3d104cda2a7715b4e619318e43e964214
Author: david hill <david.hill@mariadb.com>
Date: Fri Jun 2 11:03:12 2017 -0500

1.1.0

[root@localhost mariadb-columnstore-server]# git show
commit a5f191d235596ca2ea6d0fabf628c2db95f61516
Author: david hill <david.hill@mariadb.com>
Date: Mon Jun 5 11:13:48 2017 -0500

[root@localhost mariadb-columnstore-engine]# git show
commit e79692ec3a6bdbbfb349851c8059f728ef2f2639
Merge: ba7825c 850d773
Author: David.Hall <david.hall@mariadb.com>
Date: Tue Jun 6 10:33:23 2017 -0500

Generated at Thu Feb 08 02:21:50 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.