Hai Tao
2012-Jul-25 16:43 UTC
[Puppet Users] inventory service vs stored config (conflicts?)
I have set up inventory service to save my client''s fact, as [master] facts_terminus = inventory_active_record dblocation = {sqlite file path (sqlite only)} dbadapter = {sqlite3|mysql|postgresql|oracle_enhanced} dbname = {database name (all but sqlite)} dbuser = {database user (all but sqlite)} dbpassword = {database password (all but sqlite)} dbserver = {database server (MySQL and PostgreSQL only)} dbsocket = {database socket file (MySQL only; optional)} the question is if I then config the stored config, will the db conflicts? storeconfigs = true dbadapter = mysql dbuser = puppet dbpassword = password dbserver = localhost dbsocket = /var/run/mysqld/mysqld.sock as many are overlaped, such as dbadapter, dbpassword? I also do not understand what stored config store other than facts. Thankls. Hai T. -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Justin Stoller
2012-Jul-25 17:46 UTC
Re: [Puppet Users] inventory service vs stored config (conflicts?)
they will conflict you should definitely look into puppetdb as a more scalable solution than the active_record terminus for both inventory service and storeconfigs storedconfigs stores resources from your puppet manifests and inventory service stores facts. - Justin sorry for the top post On Wed, Jul 25, 2012 at 9:43 AM, Hai Tao <ehaitao@gmail.com> wrote:> I have set up inventory service to save my client''s fact, as > > [master] > facts_terminus = inventory_active_record > dblocation = {sqlite file path (sqlite only)} > dbadapter = {sqlite3|mysql|postgresql|oracle_enhanced} > dbname = {database name (all but sqlite)} > dbuser = {database user (all but sqlite)} > dbpassword = {database password (all but sqlite)} > dbserver = {database server (MySQL and PostgreSQL only)} > dbsocket = {database socket file (MySQL only; optional)} > > the question is if I then config the stored config, will the db conflicts? > > storeconfigs = true > dbadapter = mysql > dbuser = puppet > dbpassword = password > dbserver = localhost > dbsocket = /var/run/mysqld/mysqld.sock > > as many are overlaped, such as dbadapter, dbpassword? I also do not > understand what stored config store other than facts. > > Thankls. > > Hai T. > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Hai Tao
2012-Jul-25 18:08 UTC
Re: [Puppet Users] inventory service vs stored config (conflicts?)
storeconfig also store facts, as I can see from the table list after I configured stored config: +------------------+ | Tables_in_puppet | +------------------+ | fact_names | | fact_values | | hosts | | inventory_facts | | inventory_nodes | | param_names | | param_values | | puppet_tags | | resource_tags | | resources | | source_files | +------------------+ then the question is why would inventory needed anymore? On Wed, Jul 25, 2012 at 10:46 AM, Justin Stoller <justin@puppetlabs.com> wrote:> they will conflict > > you should definitely look into puppetdb as a more scalable solution > than the active_record terminus for both inventory service and > storeconfigs > > storedconfigs stores resources from your puppet manifests and > inventory service stores facts. > > > - Justin > sorry for the top post > > > On Wed, Jul 25, 2012 at 9:43 AM, Hai Tao <ehaitao@gmail.com> wrote: >> I have set up inventory service to save my client''s fact, as >> >> [master] >> facts_terminus = inventory_active_record >> dblocation = {sqlite file path (sqlite only)} >> dbadapter = {sqlite3|mysql|postgresql|oracle_enhanced} >> dbname = {database name (all but sqlite)} >> dbuser = {database user (all but sqlite)} >> dbpassword = {database password (all but sqlite)} >> dbserver = {database server (MySQL and PostgreSQL only)} >> dbsocket = {database socket file (MySQL only; optional)} >> >> the question is if I then config the stored config, will the db conflicts? >> >> storeconfigs = true >> dbadapter = mysql >> dbuser = puppet >> dbpassword = password >> dbserver = localhost >> dbsocket = /var/run/mysqld/mysqld.sock >> >> as many are overlaped, such as dbadapter, dbpassword? I also do not >> understand what stored config store other than facts. >> >> Thankls. >> >> Hai T. >> >> -- >> You received this message because you are subscribed to the Google Groups "Puppet Users" group. >> To post to this group, send email to puppet-users@googlegroups.com. >> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. >> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >-- Hai Tao -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Justin Stoller
2012-Jul-25 18:33 UTC
Re: [Puppet Users] inventory service vs stored config (conflicts?)
On Wed, Jul 25, 2012 at 11:08 AM, Hai Tao <ehaitao@gmail.com> wrote:> storeconfig also store facts, as I can see from the table list after > I configured stored config: > > +------------------+ > | Tables_in_puppet | > +------------------+ > | fact_names | > | fact_values | > | hosts | > | inventory_facts | > | inventory_nodes | > | param_names | > | param_values | > | puppet_tags | > | resource_tags | > | resources | > | source_files | > +------------------+ > > then the question is why would inventory needed anymore?the db settings are the same for both inventory and storeconfigs (that''s why they''ll conflicdt). when you tell puppet to use either it will automatically create the database for you. it creates one puppet database, and puts tables in there for both storeconfigs and inventory service. the actual code to retrieve, save and query facts (inventory service) and puppet resources (storedconfigs) are different however and even if the tables exist they all won''t be populated until you enable both. does that make sense?> > On Wed, Jul 25, 2012 at 10:46 AM, Justin Stoller <justin@puppetlabs.com> wrote: >> they will conflict >> >> you should definitely look into puppetdb as a more scalable solution >> than the active_record terminus for both inventory service and >> storeconfigs >> >> storedconfigs stores resources from your puppet manifests and >> inventory service stores facts. >> >> >> - Justin >> sorry for the top post >> >> >> On Wed, Jul 25, 2012 at 9:43 AM, Hai Tao <ehaitao@gmail.com> wrote: >>> I have set up inventory service to save my client''s fact, as >>> >>> [master] >>> facts_terminus = inventory_active_record >>> dblocation = {sqlite file path (sqlite only)} >>> dbadapter = {sqlite3|mysql|postgresql|oracle_enhanced} >>> dbname = {database name (all but sqlite)} >>> dbuser = {database user (all but sqlite)} >>> dbpassword = {database password (all but sqlite)} >>> dbserver = {database server (MySQL and PostgreSQL only)} >>> dbsocket = {database socket file (MySQL only; optional)} >>> >>> the question is if I then config the stored config, will the db conflicts? >>> >>> storeconfigs = true >>> dbadapter = mysql >>> dbuser = puppet >>> dbpassword = password >>> dbserver = localhost >>> dbsocket = /var/run/mysqld/mysqld.sock >>> >>> as many are overlaped, such as dbadapter, dbpassword? I also do not >>> understand what stored config store other than facts. >>> >>> Thankls. >>> >>> Hai T. >>> >>> -- >>> You received this message because you are subscribed to the Google Groups "Puppet Users" group. >>> To post to this group, send email to puppet-users@googlegroups.com. >>> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. >>> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >>> >> >> -- >> You received this message because you are subscribed to the Google Groups "Puppet Users" group. >> To post to this group, send email to puppet-users@googlegroups.com. >> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. >> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >> > > > > -- > Hai Tao > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Hai Tao
2012-Jul-25 20:19 UTC
Re: [Puppet Users] inventory service vs stored config (conflicts?)
what if I need to install foreman, which uses stored config, right? Can foreman use the puppetDB as its database? On Wed, Jul 25, 2012 at 11:33 AM, Justin Stoller <justin@puppetlabs.com> wrote:> On Wed, Jul 25, 2012 at 11:08 AM, Hai Tao <ehaitao@gmail.com> wrote: >> storeconfig also store facts, as I can see from the table list after >> I configured stored config: >> >> +------------------+ >> | Tables_in_puppet | >> +------------------+ >> | fact_names | >> | fact_values | >> | hosts | >> | inventory_facts | >> | inventory_nodes | >> | param_names | >> | param_values | >> | puppet_tags | >> | resource_tags | >> | resources | >> | source_files | >> +------------------+ >> >> then the question is why would inventory needed anymore? > > the db settings are the same for both inventory and storeconfigs > (that''s why they''ll conflicdt). when you tell puppet to use either it > will automatically create the database for you. it creates one puppet > database, and puts tables in there for both storeconfigs and inventory > service. the actual code to retrieve, save and query facts (inventory > service) and puppet resources (storedconfigs) are different however > and even if the tables exist they all won''t be populated until you > enable both. > > does that make sense? > >> >> On Wed, Jul 25, 2012 at 10:46 AM, Justin Stoller <justin@puppetlabs.com> wrote: >>> they will conflict >>> >>> you should definitely look into puppetdb as a more scalable solution >>> than the active_record terminus for both inventory service and >>> storeconfigs >>> >>> storedconfigs stores resources from your puppet manifests and >>> inventory service stores facts. >>> >>> >>> - Justin >>> sorry for the top post >>> >>> >>> On Wed, Jul 25, 2012 at 9:43 AM, Hai Tao <ehaitao@gmail.com> wrote: >>>> I have set up inventory service to save my client''s fact, as >>>> >>>> [master] >>>> facts_terminus = inventory_active_record >>>> dblocation = {sqlite file path (sqlite only)} >>>> dbadapter = {sqlite3|mysql|postgresql|oracle_enhanced} >>>> dbname = {database name (all but sqlite)} >>>> dbuser = {database user (all but sqlite)} >>>> dbpassword = {database password (all but sqlite)} >>>> dbserver = {database server (MySQL and PostgreSQL only)} >>>> dbsocket = {database socket file (MySQL only; optional)} >>>> >>>> the question is if I then config the stored config, will the db conflicts? >>>> >>>> storeconfigs = true >>>> dbadapter = mysql >>>> dbuser = puppet >>>> dbpassword = password >>>> dbserver = localhost >>>> dbsocket = /var/run/mysqld/mysqld.sock >>>> >>>> as many are overlaped, such as dbadapter, dbpassword? I also do not >>>> understand what stored config store other than facts. >>>> >>>> Thankls. >>>> >>>> Hai T. >>>> >>>> -- >>>> You received this message because you are subscribed to the Google Groups "Puppet Users" group. >>>> To post to this group, send email to puppet-users@googlegroups.com. >>>> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. >>>> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >>>> >>> >>> -- >>> You received this message because you are subscribed to the Google Groups "Puppet Users" group. >>> To post to this group, send email to puppet-users@googlegroups.com. >>> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. >>> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >>> >> >> >> >> -- >> Hai Tao >> >> -- >> You received this message because you are subscribed to the Google Groups "Puppet Users" group. >> To post to this group, send email to puppet-users@googlegroups.com. >> To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. >> For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >> > > -- > You received this message because you are subscribed to the Google Groups "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. > For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en. >-- Hai Tao -- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.
Ohad Levy
2012-Jul-26 06:44 UTC
Re: [Puppet Users] inventory service vs stored config (conflicts?)
On Wed, Jul 25, 2012 at 11:19 PM, Hai Tao <ehaitao@gmail.com> wrote:> what if I need to install foreman, which uses stored config, right? > Can foreman use the puppetDB as its database? >foreman doesnt really need store configs, see http://theforeman.org/projects/foreman/wiki/Puppet_Facts Ohad> > On Wed, Jul 25, 2012 at 11:33 AM, Justin Stoller <justin@puppetlabs.com> > wrote: > > On Wed, Jul 25, 2012 at 11:08 AM, Hai Tao <ehaitao@gmail.com> wrote: > >> storeconfig also store facts, as I can see from the table list after > >> I configured stored config: > >> > >> +------------------+ > >> | Tables_in_puppet | > >> +------------------+ > >> | fact_names | > >> | fact_values | > >> | hosts | > >> | inventory_facts | > >> | inventory_nodes | > >> | param_names | > >> | param_values | > >> | puppet_tags | > >> | resource_tags | > >> | resources | > >> | source_files | > >> +------------------+ > >> > >> then the question is why would inventory needed anymore? > > > > the db settings are the same for both inventory and storeconfigs > > (that''s why they''ll conflicdt). when you tell puppet to use either it > > will automatically create the database for you. it creates one puppet > > database, and puts tables in there for both storeconfigs and inventory > > service. the actual code to retrieve, save and query facts (inventory > > service) and puppet resources (storedconfigs) are different however > > and even if the tables exist they all won''t be populated until you > > enable both. > > > > does that make sense? > > > >> > >> On Wed, Jul 25, 2012 at 10:46 AM, Justin Stoller <justin@puppetlabs.com> > wrote: > >>> they will conflict > >>> > >>> you should definitely look into puppetdb as a more scalable solution > >>> than the active_record terminus for both inventory service and > >>> storeconfigs > >>> > >>> storedconfigs stores resources from your puppet manifests and > >>> inventory service stores facts. > >>> > >>> > >>> - Justin > >>> sorry for the top post > >>> > >>> > >>> On Wed, Jul 25, 2012 at 9:43 AM, Hai Tao <ehaitao@gmail.com> wrote: > >>>> I have set up inventory service to save my client''s fact, as > >>>> > >>>> [master] > >>>> facts_terminus = inventory_active_record > >>>> dblocation = {sqlite file path (sqlite only)} > >>>> dbadapter = {sqlite3|mysql|postgresql|oracle_enhanced} > >>>> dbname = {database name (all but sqlite)} > >>>> dbuser = {database user (all but sqlite)} > >>>> dbpassword = {database password (all but sqlite)} > >>>> dbserver = {database server (MySQL and PostgreSQL only)} > >>>> dbsocket = {database socket file (MySQL only; optional)} > >>>> > >>>> the question is if I then config the stored config, will the db > conflicts? > >>>> > >>>> storeconfigs = true > >>>> dbadapter = mysql > >>>> dbuser = puppet > >>>> dbpassword = password > >>>> dbserver = localhost > >>>> dbsocket = /var/run/mysqld/mysqld.sock > >>>> > >>>> as many are overlaped, such as dbadapter, dbpassword? I also do not > >>>> understand what stored config store other than facts. > >>>> > >>>> Thankls. > >>>> > >>>> Hai T. > >>>> > >>>> -- > >>>> You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > >>>> To post to this group, send email to puppet-users@googlegroups.com. > >>>> To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com. > >>>> For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > >>>> > >>> > >>> -- > >>> You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > >>> To post to this group, send email to puppet-users@googlegroups.com. > >>> To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com. > >>> For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > >>> > >> > >> > >> > >> -- > >> Hai Tao > >> > >> -- > >> You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > >> To post to this group, send email to puppet-users@googlegroups.com. > >> To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com. > >> For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > >> > > > > -- > > You received this message because you are subscribed to the Google > Groups "Puppet Users" group. > > To post to this group, send email to puppet-users@googlegroups.com. > > To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com. > > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > > > > > > -- > Hai Tao > > -- > You received this message because you are subscribed to the Google Groups > "Puppet Users" group. > To post to this group, send email to puppet-users@googlegroups.com. > To unsubscribe from this group, send email to > puppet-users+unsubscribe@googlegroups.com. > For more options, visit this group at > http://groups.google.com/group/puppet-users?hl=en. > >-- You received this message because you are subscribed to the Google Groups "Puppet Users" group. To post to this group, send email to puppet-users@googlegroups.com. To unsubscribe from this group, send email to puppet-users+unsubscribe@googlegroups.com. For more options, visit this group at http://groups.google.com/group/puppet-users?hl=en.