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