Hi Tommy, thanks you very much ! we succeed to automatically insert all the vms in RackTables for rackTables users : we change the parameter AutoPorts for the type server (4) : ( 4 = 1*33*kvm + 2*24*eth%u;15 = 1*446*kvm changed to 15 = 1*446*kvm) now, i have to find the best way to fill the rackspace information (we use vmware Ressource Pools as Rackspace objects) and i will be sure to have all my servers in RackTables Thanks for your work and your help Best Regards Abdel ----- Mail Original ----- De: "Tommy Botten Jensen" <tommy.botten.jensen@xxxxxx> À: abdelmounhim@xxxxxxx, racktables-users@xxxxxxxxxxxxx Envoyé: Jeudi 14 Octobre 2010 16h11:09 GMT +01:00 Amsterdam / Berlin / Berne / Rome / Stockholm / Vienne Objet: RE: Automatic insertions of servers in the db Hi Abdel I have been able to reproduse this, and it seems to be because of a configuration option which adds ports by default to an object. If you disable this, ports and IP allocation should start working. Best regards, Tommy -----Original Message----- From: abdelmounhim@xxxxxxx [mailto:abdelmounhim@xxxxxxx] Sent: Thu 10/14/2010 2:37 PM To: racktables-users@xxxxxxxxxxxxx Cc: Tommy Botten Jensen Subject: Re: Automatic insertions of servers in the db Hi, i am coming back. Your puppet are really great. I have installed it, and now i can directly insert all my vms in RackTables . i have only one little problem: all my fields are filled in RackTables except the ip address (and the mac address). has someone succeed to solve this issue? for information, my yaml file (one of my vms) contains the ip and the macaddress : virtual: vmware kernel: Linux is_virtual: true network_eth0: 10.45.1.0 uniqueid: 2d0a7401 operatingsystemrelease: "5.4" ipaddress_eth0: 10.45.1.116 netmask_eth0: 255.255.255.0 fqdn: vlsportaildev01.xxxx.com timezone: CEST kernelrelease: 2.6.18-164.15.1.el5 domain: xxxx.com type: Other id: root kernelversion: 2.6.18 lsbdistdescription: CentOS release 5.4 (Final) manufacturer: VMware, Inc. lsbdistrelease: "5.4" macaddress_eth0: 00:50:56:B6:46:76 productname: VMware Virtual Platform interfaces: eth0,sit0 architecture: x86_64 hostname: vlsportaildev01 macaddress_eth0: 00:50:56:B6:46:76 operatingsystem: CentOS Thanks for you help Abdel Hi I did an implementation of this using puppets[1] facter[2] for info gathering. It is sort of limited to fetching objects and importing them. I haven't had time to implement diff/modification yet. http://racktables.svn.sourceforge.net/viewvc/racktables/contribs/yaml_import/ If you don't like the yaml/puppet format you still might be able to use the methods and framework for importing your own lists. Best regards, Tommy Botten Jensen [1] http://www.puppetlabs.com/ [2] http://www.puppetlabs.com/puppet/related-projects/facter/ On 09/13/2010 07:38 PM, abdelmounhim@xxxxxxx wrote: > Hi all, > We are using in my entreprise racktables since few months, and this product > is really great. We would like to add directly (by script) several objects > (for example servers that are in fact virtual machines). Has someone succeed > to do this, or do you insert your servers in racktables one by one ? > > What would be also great is to be able to update or to delete servers > automatically. > > For information, i tried some sql queries, but it seems not so easy. > > Thanks for help