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










0















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!










share|improve this question
























  • 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
















0















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!










share|improve this question
























  • 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














0












0








0








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!










share|improve this question
















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






share|improve this question















share|improve this question













share|improve this question




share|improve this question








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


















  • 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













1 Answer
1






active

oldest

votes


















-1














That you are trying to work through a provider suggests that you are approaching this through resources, such as mysql::db, but that's never going to work if the server is not configured to match. The $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.






share|improve this answer

























  • 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











  • 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










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
);



);













draft saved

draft discarded


















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









-1














That you are trying to work through a provider suggests that you are approaching this through resources, such as mysql::db, but that's never going to work if the server is not configured to match. The $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.






share|improve this answer

























  • 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











  • 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















-1














That you are trying to work through a provider suggests that you are approaching this through resources, such as mysql::db, but that's never going to work if the server is not configured to match. The $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.






share|improve this answer

























  • 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











  • 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













-1












-1








-1







That you are trying to work through a provider suggests that you are approaching this through resources, such as mysql::db, but that's never going to work if the server is not configured to match. The $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.






share|improve this answer















That you are trying to work through a provider suggests that you are approaching this through resources, such as mysql::db, but that's never going to work if the server is not configured to match. The $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.







share|improve this answer














share|improve this answer



share|improve this answer








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 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

















  • 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











  • 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



















draft saved

draft discarded
















































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.




draft saved


draft discarded














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





















































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







Popular posts from this blog

How to get text form Clipboard with JavaScript in Firefox 56?How to validate an email address in JavaScript?How do JavaScript closures work?How do I remove a property from a JavaScript object?How do you get a timestamp in JavaScript?How do I copy to the clipboard in JavaScript?How do I include a JavaScript file in another JavaScript file?Get the current URL with JavaScript?How to replace all occurrences of a string in JavaScriptHow to check whether a string contains a substring in JavaScript?How do I remove a particular element from an array in JavaScript?

Can't initialize raids on a new ASUS Prime B360M-A motherboard2019 Community Moderator ElectionSimilar to RAID config yet more like mirroring solution?Can't get motherboard serial numberWhy does the BIOS entry point start with a WBINVD instruction?UEFI performance Asus Maximus V Extreme

List of MPs elected to the English parliament in 1640 (April) Contents List of constituencies and members See also Notes References Navigation menueNational Archives – The Glynde Place ArchivesCobbett's Parliamentary history of England, from the Norman Conquest in 1066 to the year 1803'Aldermen in Parliament', The Aldermen of the City of London: Temp. Henry III – 1912onepage&q&f&#61, false 229