From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 31222 invoked from network); 12 Aug 2003 11:10:51 -0000 Received: from unknown (HELO monty-python.gnu.org) (199.232.76.173) by sources.redhat.com with SMTP; 12 Aug 2003 11:10:51 -0000 Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.20) id 19mWy8-0000iL-IZ for listarch-gnats-devel@sources.redhat.com; Tue, 12 Aug 2003 07:05:36 -0400 Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.20) id 19mWxl-0000fl-60 for help-gnats@gnu.org; Tue, 12 Aug 2003 07:05:13 -0400 Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.20) id 19mWxE-0000U3-M6 for help-gnats@gnu.org; Tue, 12 Aug 2003 07:05:11 -0400 Received: from [212.227.126.186] (helo=moutng.kundenserver.de) by monty-python.gnu.org with esmtp (Exim 4.20) id 19mWxE-0000So-67 for help-gnats@gnu.org; Tue, 12 Aug 2003 07:04:40 -0400 Received: from [212.227.126.155] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 19mWxB-0005Iu-00; Tue, 12 Aug 2003 13:04:37 +0200 Received: from [217.232.193.113] (helo=habakuk.home.ha-schneider.de) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 19mWxB-0004By-00; Tue, 12 Aug 2003 13:04:37 +0200 Received: from localhost (localhost [127.0.0.1]) by habakuk.home.ha-schneider.de (Super-secret mailer on Tralala-OS/47.11) with ESMTP id 2CF4039C4F; Tue, 12 Aug 2003 13:03:49 +0200 (CEST) Received: by habakuk.home.ha-schneider.de (Super-secret mailer on Tralala-OS/47.11, from userid 1000) id 5A8B139C35; Tue, 12 Aug 2003 13:03:48 +0200 (CEST) From: Hans-Albert Schneider To: Iqbal Saima Date: Wed, 13 Aug 2003 21:48:00 -0000 User-Agent: KMail/1.5.1 References: <6B1DF6EEBA51D31182F20090274043680A736486@mail-in.comverse.com> In-Reply-To: <6B1DF6EEBA51D31182F20090274043680A736486@mail-in.comverse.com> MIME-Version: 1.0 Content-Type: Text/Plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Content-Description: clearsigned data Content-Disposition: inline Message-Id: <200308121303.47747.Hans-Albert@HA-Schneider.de> X-Virus-Scanned: by AMaViS snapshot-20020531 Cc: help-gnats@gnu.org Subject: Re: gnats help X-BeenThere: help-gnats@gnu.org X-Mailman-Version: 2.1.2 Precedence: list List-Id: General discussion about GNU GNATS List-Archive: List-Post: List-Help: List-Subscribe: , Sender: help-gnats-bounces+listarch-gnats-devel=sources.redhat.com@gnu.org Errors-To: help-gnats-bounces+listarch-gnats-devel=sources.redhat.com@gnu.org X-SW-Source: 2003-q3/txt/msg00024.txt.bz2 -----BEGIN PGP SIGNED MESSAGE----- On Monday 11 August 2003 18:20, you wrote: > Hello, > > I was wondering if I could get some feedback on setting up gnatsweb > with an SQL database? Is that something doable? Any ideas on how > to connect the two (ODBC, JDBC, or gnats daemon)? Would it be > compatible? I am not sure what exactly you want to do. GNATS currently supports=20 only one "database backend", namely its own format (every report is a=20 file of its own, with e-mail headers and the GNATS fields). So, if gnatsweb shall be able to edit existing reports or to submit=20 new ones, it must communicate with gnats the way it currently does. The SQL stuff in the contrib directory was what somebody used for=20 complex reporting, connecting to customer database, etc. The data are=20 extracted from gnats and stuffed into the database on a regular=20 basis. (See contrib/sql/README.) So this is only a *copy* of the=20 gnats database, not the working database. > I was having trouble adding fields, and tables, to the gnats > database with v3.xx. Is adding a field to the gnats database > easier in Version 4? If not, any tips on how to handle that? It is much easier in GNATS 4; all the fields are defined in file=20 gnats-adm/gnatsdb (individually for each database). You just add a=20 description for each of you additional fields. There are some=20 examples in the documentation. > Thanks in advance for all your help. You are welcome. BTW, I have Cc-ed my reply to the mailing list help-gnats@gnu.org It is generally a good idea to ask the list instead of individuals;=20 you usually get faster response. E.g., I have been very busy until=20 the end of last week, and I am about to leave for vacation (with rare=20 or no e-mail access), so your mail was lucky to hit just the few days=20 in between. All the best, Hans-Albert - --=20 Hans-Albert Schneider Munich, Germany EMail: Hans-Albert@HA-Schneider.de -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iQEVAwUBPzjJkb5/YryrhGWVAQGR6Af+MB08cCg0ouiCgDc5JgAYyLepxN078mdP bugJDR6YTQJHe+6pS4sB+s5wxQhJy0sSrmd1a0usMq8GkLrTFBE5Y3475LK6hAL/ Uc6+tTKeSNlz4SdaA33LU33wMP/e8vKIj7SMij+l9R/CXeSj6cmnZvJPnRRiiRVQ T/8+bHiD/yuYQpdUhTTf2OsUTIBTSJjPIYLac2V3bCpBfPWxAwfafJvpA5JmabKh 95BKf+zm7Ldl4d2nuMU1z7HJP3BnVQRa8Q9uShfyhqci2gR0y2lWwcpktRdzzOfn IjjnRWPjX+XDffSjcBkma+FaYTAu3X3ly/5vM+sEEeyLX9fsNIMWYA=3D=3D =3DfPae -----END PGP SIGNATURE----- _______________________________________________ Help-gnats mailing list Help-gnats@gnu.org http://mail.gnu.org/mailman/listinfo/help-gnats