So you know you would have to make all your nodes mysql clients and give them access to the mysql server.
Yes. Not an issue, while they do not all belong to the same flat network, the network is routed.
You would also have to have the mysql admin id and password available on the nodes for the query. Not sure I would want to do this.I agree, that would be a terrible thing to do, so I did not go this route :) I created a separate, non-privileged mysql user that only has permissions to read from the "nodelist" table. This user cannot read any other table, nor can they write to the nodelist table. Only read.
On 2/1/2012 2:28 PM, Lissa Valletta wrote:
So you know you would have to make all your nodes mysql clients and give them access to the mysql server. You would also have to have the mysql admin id and password available on the nodes for the query. Not sure I would want to do this. Lissa K. Valletta 2-3/T12 Poughkeepsie, NY 12601 (tie 293) 433-3102 From: Russell Jones<[email protected]> To: <[email protected]> Date: 02/01/2012 12:51 PM Subject: Re: [xcat-user] Grab groups a node is a member of Hi Lissa, The database is MySQL. We are creating a postscript that is going to be handling configuring OS settings on the node based on various definitions, such as the profile and groups a node is a member of. Profile is passed via the environment variables so that is not an issue to get, it's just grabbing the groups that is. While we do configure SSH from the compute nodes back to the management node, I really do not want to go that route, as several hundred compute nodes causing SSH processes to spin up on the master node just to do a nodels doesn't seem like the right route to go with this :) If I can have the compute nodes grab this information from their xcat master through the xcatd daemon itself, that would be perfect and preferred over doing direct MySQL queries. I agree that getting this information from xCAT directly is better. On 01.02.2012 09:33, Lissa Valletta wrote: So what database are you running? I am not sure why you would do an SQL query vs use xCAT database commands. You could pretty easy write a script to get a list of all nodes using nodels and their group accessing the nodelist.groups attribute. The other thing is we do not say we will never change our database definitions. If you use the xCAT commands, you will be immune from any changes. Not that I expect to change this area. And no there is no supported way, to grab the groups the nodes are in from the compute node, other than write your own postscript. I am still curious why you need the groups on the compute nodes. Lissa K. Valletta 2-3/T12 Poughkeepsie, NY 12601 (tie 293) 433-3102 From: Russell Jones<[email protected]> To: [email protected]: 01/30/2012 05:26 PM Subject: Re: [xcat-user] Grab groups a node is a member of Thanks Jarrod, Can you please clarify what you mean by "in remote"? Currently just to be able to continue with the script I am creating I am doing a SQL query directly on the database (as the thought of having many compute nodes SSH'ing to the management node to run nodels seems more dirty). Is there a supported way of grabbing the groups a node is a member of from the xcatmaster via the same way that the compute nodes grab the postscripts they need to run? On 1/30/2012 4:11 PM, Jarrod B Johnson wrote: Equivalent of 'nodelsgroups' in remote can work, it may warrant something more special... ------------------------------------------------------------------------------ Try before you buy = See our experts in action! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-dev2 _______________________________________________ xCAT-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcat-user ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ xCAT-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcat-user ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ xCAT-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcat-user ------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d _______________________________________________ xCAT-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcat-user
------------------------------------------------------------------------------ Keep Your Developer Skills Current with LearnDevNow! The most comprehensive online learning library for Microsoft developers is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3, Metro Style Apps, more. Free future releases when you subscribe now! http://p.sf.net/sfu/learndevnow-d2d
_______________________________________________ xCAT-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/xcat-user
