Geoffroy, I was sure that there was a better way of doing that.
You method is cool :-) Tested ok. Regards, Olivier. Le mardi 15 décembre 2009 19:13:21, vous avez écrit : > Olivier, > > I guess you would like to modify the following line in mkdhcpconf: > print OUTFILE "option domain-name \"$HINFO{domain}\";\n"; > > If so, in that context, we already know the subnet (e.g., 192.168.0.0), which > could be used to get the information you are looking for from the Networks > table: > select rfc1918 from Networks where base_ip=$HINFO{net}; > > Does it make sense? Did i miss something? > > Regards, > > ----- "Olivier LAHAYE" <olivier.lah...@cea.fr> a écrit : > > > hi, > > > > I'll try to implement this test into mkdhcpconf. if this query returns > > 1, then no dns, else dns. > > > > select rfc1918 from Networks,Nics,Clusters where Networks.n_id = > > Nics.network_id AND Nics.name = Clusters.headnode_interface AND > > Nics.node_id = 1; > > > > Regards, > > > > Olivier. > > > > Le vendredi 11 décembre 2009 14:47:55, vous avez écrit : > > > > > > hi, > > > > > > I've identified the problem that prevents clients sge post deploy > > script to run successfully. > > > > > > It's because the hostname is FQDN while there is no access to any > > DNS server from the private network. > > > > > > A way to circumvent this is to remove option domain-name > > "intra.cea.fr" from dhcpd.conf IF (only if): > > > > > > 1 == select rfc1918 from Networks where n_id=(select network_id from > > Nics where name = (select headnode_interface from Clusters)); > > > > > > After that, if you install a node on a private network, the hostname > > command returns the base hostname without any dns appended (non-FQDN). > > > Then, sge feels better. > > > > > > The problem. I'm bad at mysql complex request, and I'm conviced that > > there are far better way to do a request that checks if oscar pravate > > interface is on a private network (rfc1918). > > > > > > Geoffroy, any idea? > > > > > > > > > > -- > > Olivier LAHAYE > > CEA Saclay > > DRT-LIST-DETECS-SSTM > > > > ------------------------------------------------------------------------------ > > Return on Information: > > Google Enterprise Search pays you back > > Get the facts. > > http://p.sf.net/sfu/google-dev2dev > > _______________________________________________ > > Oscar-devel mailing list > > Oscar-devel@lists.sourceforge.net > > https://lists.sourceforge.net/lists/listinfo/oscar-devel > -- Olivier LAHAYE CEA Saclay DRT-LIST-DETECS-SSTM ------------------------------------------------------------------------------ This SF.Net email is sponsored by the Verizon Developer Community Take advantage of Verizon's best-in-class app development support A streamlined, 14 day to market process makes app distribution fast and easy Join now and get one step closer to millions of Verizon customers http://p.sf.net/sfu/verizon-dev2dev _______________________________________________ Oscar-devel mailing list Oscar-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/oscar-devel