MySQL Server - Puppet Labs module and Oracle Linux 72019 Community Moderator ElectionHost 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL serverMySql server startup error 'The server quit without updating PID file 'Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)Centos/fedora/amazon linux: iptables best practicePuppet - how to apply module to puppet client node?Puppet ensure apt-get update before MySQLmanaging a user password for linux in puppetHow to use puppet modules in puppet client?How to handle linux and windows in puppet modules?Install mysql-server with puppet
Possible to detect presence of nuclear bomb?
Can one live in the U.S. and not use a credit card?
Why do phishing e-mails use faked e-mail addresses instead of the real one?
Can't make sense of a paragraph from Lovecraft
What will happen if my luggage gets delayed?
What would be the most expensive material to an intergalactic society?
I can't die. Who am I?
What is the population of Romulus in the TNG era?
What sort of fish is this
Why is there an extra space when I type "ls" in the Desktop directory?
Proving a statement about real numbers
Having the player face themselves after the mid-game
Professor forcing me to attend a conference, I can't afford even with 50% funding
PTIJ: Why does only a Shor Tam ask at the Seder, and not a Shor Mu'ad?
How exactly does an Ethernet collision happen in the cable, since nodes use different circuits for Tx and Rx?
Getting the || sign while using Kurier
Finitely many repeated replacements
ER diagram relationship node size adjustment
What materials can be used to make a humanoid skin warm?
How do electrons receive energy when a body is heated?
What are some noteworthy "mic-drop" moments in math?
How is it possible to drive VGA displays at such high pixel clock frequencies?
Do cubics always have one real root?
School performs periodic password audits. Is my password compromised?
MySQL Server - Puppet Labs module and Oracle Linux 7
2019 Community Moderator ElectionHost 'xxx.xx.xxx.xxx' is not allowed to connect to this MySQL serverMySql server startup error 'The server quit without updating PID file 'Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (38)Centos/fedora/amazon linux: iptables best practicePuppet - how to apply module to puppet client node?Puppet ensure apt-get update before MySQLmanaging a user password for linux in puppetHow to use puppet modules in puppet client?How to handle linux and windows in puppet modules?Install mysql-server with puppet
With the popular MySQL server module from Puppet Labs, it sets $provider to mariadb on Oracle Linux 7.x, which causes issues if I am not using Maria, but instead using Percona. The issue is in params.pp. I was wondering if there is a way to force the $provider to be mysql. I could try creating a symlink to mariadb.log, to get around this issue but it is ugly...
Here's the code from params.pp:
case $::osfamily {
'RedHat': {
case $::operatingsystem OracleLinux)$/:
if versioncmp($::operatingsystemmajrelease, '7') >= 0
$provider = 'mariadb'
else
$provider = 'mysql'
default:
$provider = 'mysql'
Source: https://github.com/puppetlabs/puppetlabs-mysql/blob/master/manifests/params.pp
Error: Could not set 'present' on ensure: No such file or directory @ rb_sysopen - /var/log/mariadb/mariadb.log at /[redacted]/modules/mysql/manifests/server/installdb.pp:25
Bsically, I am looking for a graceful workaround via Puppet over rides. But not experienced enough to know how to implement it. :(
Thanks!
mysql puppet percona
add a comment |
With the popular MySQL server module from Puppet Labs, it sets $provider to mariadb on Oracle Linux 7.x, which causes issues if I am not using Maria, but instead using Percona. The issue is in params.pp. I was wondering if there is a way to force the $provider to be mysql. I could try creating a symlink to mariadb.log, to get around this issue but it is ugly...
Here's the code from params.pp:
case $::osfamily {
'RedHat': {
case $::operatingsystem OracleLinux)$/:
if versioncmp($::operatingsystemmajrelease, '7') >= 0
$provider = 'mariadb'
else
$provider = 'mysql'
default:
$provider = 'mysql'
Source: https://github.com/puppetlabs/puppetlabs-mysql/blob/master/manifests/params.pp
Error: Could not set 'present' on ensure: No such file or directory @ rb_sysopen - /var/log/mariadb/mariadb.log at /[redacted]/modules/mysql/manifests/server/installdb.pp:25
Bsically, I am looking for a graceful workaround via Puppet over rides. But not experienced enough to know how to implement it. :(
Thanks!
mysql puppet percona
There are no overrides for class parameters like there can be for resource parameters. Much less for class variables that are not parameters.
– John Bollinger
Mar 7 at 21:59
add a comment |
With the popular MySQL server module from Puppet Labs, it sets $provider to mariadb on Oracle Linux 7.x, which causes issues if I am not using Maria, but instead using Percona. The issue is in params.pp. I was wondering if there is a way to force the $provider to be mysql. I could try creating a symlink to mariadb.log, to get around this issue but it is ugly...
Here's the code from params.pp:
case $::osfamily {
'RedHat': {
case $::operatingsystem OracleLinux)$/:
if versioncmp($::operatingsystemmajrelease, '7') >= 0
$provider = 'mariadb'
else
$provider = 'mysql'
default:
$provider = 'mysql'
Source: https://github.com/puppetlabs/puppetlabs-mysql/blob/master/manifests/params.pp
Error: Could not set 'present' on ensure: No such file or directory @ rb_sysopen - /var/log/mariadb/mariadb.log at /[redacted]/modules/mysql/manifests/server/installdb.pp:25
Bsically, I am looking for a graceful workaround via Puppet over rides. But not experienced enough to know how to implement it. :(
Thanks!
mysql puppet percona
With the popular MySQL server module from Puppet Labs, it sets $provider to mariadb on Oracle Linux 7.x, which causes issues if I am not using Maria, but instead using Percona. The issue is in params.pp. I was wondering if there is a way to force the $provider to be mysql. I could try creating a symlink to mariadb.log, to get around this issue but it is ugly...
Here's the code from params.pp:
case $::osfamily {
'RedHat': {
case $::operatingsystem OracleLinux)$/:
if versioncmp($::operatingsystemmajrelease, '7') >= 0
$provider = 'mariadb'
else
$provider = 'mysql'
default:
$provider = 'mysql'
Source: https://github.com/puppetlabs/puppetlabs-mysql/blob/master/manifests/params.pp
Error: Could not set 'present' on ensure: No such file or directory @ rb_sysopen - /var/log/mariadb/mariadb.log at /[redacted]/modules/mysql/manifests/server/installdb.pp:25
Bsically, I am looking for a graceful workaround via Puppet over rides. But not experienced enough to know how to implement it. :(
Thanks!
mysql puppet percona
mysql puppet percona
edited 2 days ago
Tiw
3,85261329
3,85261329
asked Mar 7 at 4:49
farhanyfarhany
4071718
4071718
There are no overrides for class parameters like there can be for resource parameters. Much less for class variables that are not parameters.
– John Bollinger
Mar 7 at 21:59
add a comment |
There are no overrides for class parameters like there can be for resource parameters. Much less for class variables that are not parameters.
– John Bollinger
Mar 7 at 21:59
There are no overrides for class parameters like there can be for resource parameters. Much less for class variables that are not parameters.
– John Bollinger
Mar 7 at 21:59
There are no overrides for class parameters like there can be for resource parameters. Much less for class variables that are not parameters.
– John Bollinger
Mar 7 at 21:59
add a comment |
1 Answer
1
active
oldest
votes
That you are trying to work through a provider suggests that you are approaching this through resources, such as The mysql::db, but that's never going to work if the server is not configured to match.$provider variable you highlight in the question is both set and used only inside class mysql::params, and only for certain OS families even there. It is an ordinary variable belonging to the class, not a class parameter, and, being undocumented, it should be considered private to that class. In any event, no, Puppet provides no way to override that variable's value without modifying the module.
It is class mysql::server that provides the avenue for configuring for an alternative MySQL fork. It offers numerous parameters by which you can configure all the details, but no once-for-all mechanism for setting a different MySQL personality. I think you will find that if you do that correctly then all the resource types will just work. In any case, you should not be declaring any resources of private resource types, nor overriding the properties of resources you do not declare.
An example covering almost the exact use case you've asked about is presented in the module docs as Install Percona Server on CentOS. Note that I have replicated the heading from the docs, but the word "Install" in it is a bit misleading. That should not only install the server, but set the stage for all the module's resource types to manage it.
I gather that you would prefer a simpler way to configure for a non-default fork, but the module does not presently offer one.
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via classmysql::serverand its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.
– John Bollinger
Mar 7 at 21:58
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55036303%2fmysql-server-puppet-labs-module-and-oracle-linux-7%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
That you are trying to work through a provider suggests that you are approaching this through resources, such as The mysql::db, but that's never going to work if the server is not configured to match.$provider variable you highlight in the question is both set and used only inside class mysql::params, and only for certain OS families even there. It is an ordinary variable belonging to the class, not a class parameter, and, being undocumented, it should be considered private to that class. In any event, no, Puppet provides no way to override that variable's value without modifying the module.
It is class mysql::server that provides the avenue for configuring for an alternative MySQL fork. It offers numerous parameters by which you can configure all the details, but no once-for-all mechanism for setting a different MySQL personality. I think you will find that if you do that correctly then all the resource types will just work. In any case, you should not be declaring any resources of private resource types, nor overriding the properties of resources you do not declare.
An example covering almost the exact use case you've asked about is presented in the module docs as Install Percona Server on CentOS. Note that I have replicated the heading from the docs, but the word "Install" in it is a bit misleading. That should not only install the server, but set the stage for all the module's resource types to manage it.
I gather that you would prefer a simpler way to configure for a non-default fork, but the module does not presently offer one.
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via classmysql::serverand its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.
– John Bollinger
Mar 7 at 21:58
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
add a comment |
That you are trying to work through a provider suggests that you are approaching this through resources, such as The mysql::db, but that's never going to work if the server is not configured to match.$provider variable you highlight in the question is both set and used only inside class mysql::params, and only for certain OS families even there. It is an ordinary variable belonging to the class, not a class parameter, and, being undocumented, it should be considered private to that class. In any event, no, Puppet provides no way to override that variable's value without modifying the module.
It is class mysql::server that provides the avenue for configuring for an alternative MySQL fork. It offers numerous parameters by which you can configure all the details, but no once-for-all mechanism for setting a different MySQL personality. I think you will find that if you do that correctly then all the resource types will just work. In any case, you should not be declaring any resources of private resource types, nor overriding the properties of resources you do not declare.
An example covering almost the exact use case you've asked about is presented in the module docs as Install Percona Server on CentOS. Note that I have replicated the heading from the docs, but the word "Install" in it is a bit misleading. That should not only install the server, but set the stage for all the module's resource types to manage it.
I gather that you would prefer a simpler way to configure for a non-default fork, but the module does not presently offer one.
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via classmysql::serverand its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.
– John Bollinger
Mar 7 at 21:58
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
add a comment |
That you are trying to work through a provider suggests that you are approaching this through resources, such as The mysql::db, but that's never going to work if the server is not configured to match.$provider variable you highlight in the question is both set and used only inside class mysql::params, and only for certain OS families even there. It is an ordinary variable belonging to the class, not a class parameter, and, being undocumented, it should be considered private to that class. In any event, no, Puppet provides no way to override that variable's value without modifying the module.
It is class mysql::server that provides the avenue for configuring for an alternative MySQL fork. It offers numerous parameters by which you can configure all the details, but no once-for-all mechanism for setting a different MySQL personality. I think you will find that if you do that correctly then all the resource types will just work. In any case, you should not be declaring any resources of private resource types, nor overriding the properties of resources you do not declare.
An example covering almost the exact use case you've asked about is presented in the module docs as Install Percona Server on CentOS. Note that I have replicated the heading from the docs, but the word "Install" in it is a bit misleading. That should not only install the server, but set the stage for all the module's resource types to manage it.
I gather that you would prefer a simpler way to configure for a non-default fork, but the module does not presently offer one.
That you are trying to work through a provider suggests that you are approaching this through resources, such as The mysql::db, but that's never going to work if the server is not configured to match.$provider variable you highlight in the question is both set and used only inside class mysql::params, and only for certain OS families even there. It is an ordinary variable belonging to the class, not a class parameter, and, being undocumented, it should be considered private to that class. In any event, no, Puppet provides no way to override that variable's value without modifying the module.
It is class mysql::server that provides the avenue for configuring for an alternative MySQL fork. It offers numerous parameters by which you can configure all the details, but no once-for-all mechanism for setting a different MySQL personality. I think you will find that if you do that correctly then all the resource types will just work. In any case, you should not be declaring any resources of private resource types, nor overriding the properties of resources you do not declare.
An example covering almost the exact use case you've asked about is presented in the module docs as Install Percona Server on CentOS. Note that I have replicated the heading from the docs, but the word "Install" in it is a bit misleading. That should not only install the server, but set the stage for all the module's resource types to manage it.
I gather that you would prefer a simpler way to configure for a non-default fork, but the module does not presently offer one.
edited Mar 7 at 21:57
answered Mar 7 at 15:01
John BollingerJohn Bollinger
83.4k74279
83.4k74279
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via classmysql::serverand its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.
– John Bollinger
Mar 7 at 21:58
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
add a comment |
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via classmysql::serverand its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.
– John Bollinger
Mar 7 at 21:58
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
Maybe I didn't explain properly. Issue is that I am indeed attempting to use mysql::server with percona packages, on an Oracle Linux 7.x machine sets the $provider to MariaDB, which sets defaults for maria, such as the log file, etc. This causes the module to fail as persona's branched off of mysql so there are no MariaDB artifacts/files to be found, This seems like a bug to me. If the package and service_name are Percona-XtraDB-Cluster and mysql, then the same default should be based off of these parameters that I do provide.
– farhany
Mar 7 at 21:19
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via class
mysql::server and its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.– John Bollinger
Mar 7 at 21:58
@farhany, I have updated the answer to clarify that the only way the module presently provides for achieving the configuration you want is via class
mysql::server and its parameters. If you are not satisfied with the details then the module's code is available for you to modify as you like, and I'm sure Puppet, Inc. would be happy to consider incorporating any improvements you might choose to offer back to them.– John Bollinger
Mar 7 at 21:58
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
I will indeed fork it and modify the code to achieve an over ride by basing on what server_name is presented to the public class. This seems clean to me, and in my testing is working as expected. I thank you for your input.
– farhany
2 days ago
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55036303%2fmysql-server-puppet-labs-module-and-oracle-linux-7%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
There are no overrides for class parameters like there can be for resource parameters. Much less for class variables that are not parameters.
– John Bollinger
Mar 7 at 21:59