huangmingyou
2008-May-08 07:54 UTC
[Puppet Users] puppetmaster connect remote mysql server error
hi,guys When I test the puppetmaster use a remote mysql server,get error like this: err: Could not retrieve catalog: Mysql::Error: Lost connection to MySQL server during query: SHOW TABLES I use mysql -h remotehost -u user -ppass can login into the mysql server. os is debian etch,puppet version is 0.24.4 ,mysql server is 4.1.11-Debian_4sarge7-log but use local mysql server is ok. I don''t know what''s the resion get this error . Huang Mingyou --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---
Blake Barnett
2008-May-08 09:43 UTC
[Puppet Users] Re: puppetmaster connect remote mysql server error
On May 8, 2008, at 12:54 AM, huangmingyou wrote:> > hi,guys > When I test the puppetmaster use a remote mysql server,get error > like this: > err: Could not retrieve catalog: Mysql::Error: Lost connection to > MySQL server during query: SHOW TABLES > I use mysql -h remotehost -u user -ppass can login into the > mysql server. > os is debian etch,puppet version is 0.24.4 ,mysql server is > 4.1.11-Debian_4sarge7-log > > but use local mysql server is ok. > I don''t know what''s the resion get this error .This is a very common problem with ActiveRecord. To handle it correctly we have to wrap all of our database operations in code that can verify connections and reconnect if required. This is lame, and requires more effort than it''s worth since this code will go away once the REST support is in. -Blake --~--~---------~--~----~------------~-------~--~----~ 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 -~----------~----~----~----~------~----~------~--~---