Re: C# sharp scripting and NAnt + CCNet

I think you might want to cut the CCNet part out of that solution. CCNet
gives you a nice interface to start the build, but it sounds like you want
it to prompt the DBA for credentials which you are unlikely to achieve. I
would recommend having the DBA simply run NAnt from a command line, then
your script will work (as you've tested). If you need to run it on a
different machine than the one the DBA is using, PSExec in PSTools will do
the trick.

Hope that helps.
---
Chris.

Continuous improvement is better than delayed perfection. - Mark Twain


On Tue, Apr 20, 2010 at 8:53 PM, Simon H <[email protected]> wrote:

>  I am designing a automated compilation script for an Oracle Forms and
> Reports development environment containing numerous databases with
> associated projects. As the username and password for connecting to the
> databases differs, and because of organisational measures in place that
> require that developers are not privy to the username and password for
> various databases (only DBA's have these rights). The ideal solution is:
>
>
>    - The DBA runs a force build from CCNet via their browser using the
>    WebDashboard.
>    - CCNet calls a NAnt script that prompts them for the
>    username, password and database relevant to the files they wish to have
>    automatically compiled and deployed (I am already able to achieve this in a
>    NAnt build file using C# scripting as outlined in previous post)
>
>
> However, for some reason CCNet does not execute the NAnt build file as
> desired (outlined in previous post). How can I make CCNet execute the NAnt
> build file so that it correctly runs the embedded C# script that prompts for
> user input?
>
> ------------------------------
> From: [email protected]
> Date: Tue, 20 Apr 2010 20:38:19 -0700
>
> Subject: Re: [NAnt-users] C# sharp scripting and NAnt + CCNet
> To: [email protected]
> CC: [email protected]
>
>
> Hi Simon,
>
> CCNet is generally used for automated/unattended builds. What is the core
> problem you are trying to solve with this solution, ie, why do you want user
> input during a CCNet build?
> ---
> Chris.
>
> Continuous improvement is better than delayed perfection. - Mark Twain
>
>
> On Tue, Apr 20, 2010 at 8:17 PM, Simon H <[email protected]> wrote:
>
>
>  "Can you store the username, password, an database in a database and have
> the nant script look at that if a console isn't available?" This is not a
> viable solution due to security considerations.
>
>
> ------------------------------
> Date: Tue, 20 Apr 2010 20:03:58 -0700
> From: [email protected]
>
> To: [email protected]
> Subject: Re: [NAnt-users] C# sharp scripting and NAnt + CCNet
>
>
>  How will ccnet accept user input if its running as a service on an
> unattended build server?
>
> Can you store the username, password, an database in a database and have
> the nant script look at that if a console isn't available?
>
>  ------------------------------
> *From:* Simon H <[email protected]>
> *To:* [email protected]
> *Sent:* Tue, April 20, 2010 10:32:20 PM
> *Subject:* [NAnt-users] C# sharp scripting and NAnt + CCNet
>
> Hi guys,
> I have a C# script within my NAnt build file which allows me to accept user
> input from the commandline. A truncutated excerpt of the NAnt build file is:
> ...
> <property name="username"            value="" />
> <property name="password"            value="" />
> <property name="database"            value="" />
> ...
> <target name="menu">
>     <script language="C#" mainclass="GetInput">
>       <code>
>         <![CDATA[
>           class GetInput
>           {
>             public static void ScriptMain(Project project)
>             {
>               Console.Clear();
>
> Console.WriteLine("===================================================================");
>               Console.WriteLine("Welcome to the Compile and Deploy Oracle
> Forms and Reports Facility");
>
> Console.WriteLine("===================================================================");
>               Console.Write("Please enter username: ");
>               project.Properties["username"] = Console.ReadLine();
>               Console.WriteLine();
>               Console.Write("Please enter password: ");
>               project.Properties["password"] = Console.ReadLine();
>               Console.WriteLine();
>               Console.Write("Please enter database: ");
>               project.Properties["database"] = Console.ReadLine();
>               Console.WriteLine();
>               ...
>         ]]>
>       </code>
>     </script>
>   </target>
>
> When I run this build file from the commandline, it works perfectly.
> However, when I call this build file from CCNet it does not work. The only
> reason for this I can think of is that when CCNet calls the NAnt script, it
> is not sure how to pass the C# script calls to the System.Console class to
> the commandline. I'm not sure how to do this though.
>
> I've also been playing around with the idea of the C# script opening a new
> instance of cmd.exe and then trying to execute the remainder of the script.
> From searches on Google, I found the following solution that works as a C#
> class:
>
> using System;
> using System.Windows.Forms;
> using System.Text;
> using System.IO;
> using System.Runtime.InteropServices;
> using Microsoft.Win32.SafeHandles;
> class Program
> {
>     [DllImport("kernel32.dll",
>         EntryPoint = "GetStdHandle",
>         SetLastError = true,
>         CharSet = CharSet.Auto,
>         CallingConvention = CallingConvention.StdCall)]
>     private static extern IntPtr GetStdHandle(int nStdHandle);
>     [DllImport("kernel32.dll",
>         EntryPoint = "AllocConsole",
>         SetLastError = true,
>         CharSet = CharSet.Auto,
>         CallingConvention = CallingConvention.StdCall)]
>     private static extern int AllocConsole();
>     private const int STD_OUTPUT_HANDLE = -11;
>     private const int MY_CODE_PAGE = 437;
>     private static string deployment = "\\\\vm-osb-oasd\\sohaan";
>     static void Main(string[] args)
>     {
>         AllocConsole();
>         IntPtr stdHandle = GetStdHandle(STD_OUTPUT_HANDLE);
>         SafeFileHandle safeFileHandle = new SafeFileHandle(stdHandle,
> true);
>         FileStream fileStream = new FileStream(safeFileHandle,
> FileAccess.Write);
>         Encoding encoding = System.Text.Encoding.GetEncoding(MY_CODE_PAGE);
>         StreamWriter standardOutput = new StreamWriter(fileStream,
> encoding);
>         standardOutput.AutoFlush = true;
>         Console.SetOut(standardOutput);
>         Console.Clear();
>
> Console.WriteLine("===================================================================");
>         Console.WriteLine("Welcome to the Compile and Deploy Oracle Forms
> and Reports Facility");
>
> Console.WriteLine("===================================================================");
>         Console.Write("Please enter username: ");
>         string username = Console.ReadLine();
>         ....
>     }
> }
> This works perfectly in a C# environment. However, I do not know how to
> embed it within a NAnt script correctly...From what I know about NAnt, I may
> need to create an extension, but am uncertain of how to go about this. Can
> anyone help me out?
>
> ------------------------------
> Meet local singles online. Browse profiles for FREE!<http://clk.atdmt.com/NMN/go/150855801/direct/01/>
>
> ------------------------------
> Australia's #1 job site If It Exists, You'll Find it on SEEK<http://clk.atdmt.com/NMN/go/157639755/direct/01/>
>
>
> ------------------------------------------------------------------------------
>
> _______________________________________________
> NAnt-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/nant-users
>
>
>
> ------------------------------
> Looking for a hot date? View photos of singles in your area!<http://clk.atdmt.com/NMN/go/150855801/direct/01/>
>

------------------------------------------------------------------------------

_______________________________________________
NAnt-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/nant-users