[MCOL-3306] non-root install my.sql default location support Created: 2019-05-13 Updated: 2020-08-25 Resolved: 2019-10-07 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | None |
| Fix Version/s: | 1.4.0 |
| Type: | New Feature | Priority: | Major |
| Reporter: | David Hill (Inactive) | Assignee: | Todd Stoffel (Inactive) |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Description |
|
Customer request enhancement for non-root install and the default setup for my.cnf 1. MYSQL_HOME is not defined - appears to be much more useful for non-root installs for apps to locate the my.cnf file 2. When a my.cnf file cannot be located, the client tries to use a bogus internal default socket 'db/mysql.sock' file, which does not exist. 3. software support the default /etc/my.cnf |
| Comments |
| Comment by Andrew Hutchings (Inactive) [ 2019-09-26 ] |
|
toddstoffel In 1.4.0 the columnstore specific settings are stored in /etc/my.cnf.d/columnstore.cnf which is loaded in by my.cnf. Does that fulfil the requirements here? |
| Comment by David Hill (Inactive) [ 2019-10-07 ] |
|
Support case ID has been corrected |
| Comment by David Hill (Inactive) [ 2019-10-07 ] |
|
customer feedback not sure which requirement they are trying to fulfil with that statement. Steps we took to resolve the issue was to define MYSQL_HOME Add a custom cnf file to /home/mysql/mariadb/columnstore/mysql/my.cnf.d and edit /home/mysql/mariadb/columnstore/mysql/my.cnf to add a line with After postConfigure is executed and it and the system startup puts all these files in place, FYI on the 1.2.5 system we just stood up, there is not a columnstore.cnf in the specified location. The last one being our custom file. |
| Comment by Andrew Hutchings (Inactive) [ 2019-10-07 ] |
|
In that case it will be fixed in 1.4. With 1.4 we load the default /etc/my.cnf and have ColumnStore specific options in /etc/my.cnf.d/columnstore.cnf. A user can add their own options in /etc/my.cnf.d. |
| Comment by David Hill (Inactive) [ 2019-10-08 ] |
|
Question Is this the location for non-root installs or is non-root install supported in 1.4 /etc/my.cnf.d/columnstore.cnf |
| Comment by Andrew Hutchings (Inactive) [ 2019-10-08 ] |
|
The former for now, we haven't made a decision on the latter. |
| Comment by David Hill (Inactive) [ 2019-10-08 ] |
|
Since this is non-root install related, |
| Comment by Andrew Hutchings (Inactive) [ 2019-10-09 ] |
|
If non-root goes away it will be replaced by something else. Either way the paths have already changed in 1.4. |