From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: (qmail 1931 invoked from network); 22 Aug 2003 23:19:23 -0000 Received: from unknown (HELO monty-python.gnu.org) (199.232.76.173) by sources.redhat.com with SMTP; 22 Aug 2003 23:19:23 -0000 Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.20) id 19qKLg-0003dl-SX for listarch-gnats-devel@sources.redhat.com; Fri, 22 Aug 2003 18:25:36 -0400 Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.20) id 19qDlL-0007iY-TC for help-gnats@gnu.org; Fri, 22 Aug 2003 11:23:39 -0400 Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.20) id 19q0yp-0003aa-U0 for help-gnats@gnu.org; Thu, 21 Aug 2003 21:45:16 -0400 Received: from [199.232.41.8] (helo=mx20.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.20) id 19pzv0-0000mm-6T for help-gnats@gnu.org; Thu, 21 Aug 2003 20:36:42 -0400 Received: from [63.64.185.250] (helo=us-wkf-interscan1.comverse.com) by mx20.gnu.org with esmtp (Exim 4.20) id 19ppfE-0005OZ-KZ for help-gnats@gnu.org; Thu, 21 Aug 2003 09:39:44 -0400 Received: from mail-in.comverse.com (localhost.localdomain [127.0.0.1]) by us-wkf-interscan1.comverse.com (8.11.6/8.11.6) with ESMTP id h7LDddC09725; Thu, 21 Aug 2003 09:39:40 -0400 Received: by mail-in.comverse.com with Internet Mail Service (5.5.2653.19) id ; Thu, 21 Aug 2003 09:33:40 -0400 Message-ID: <6B1DF6EEBA51D31182F20090274043680A73648D@mail-in.comverse.com> From: Iqbal Saima To: "'Hans-Albert Schneider'" , Iqbal Saima Date: Sat, 23 Aug 2003 09:13:00 -0000 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="iso-8859-1" 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/msg00043.txt.bz2 Hello, I'm having some trouble adding fields to GNATS. I'm using GNATS4. The field I want to add is enumerated. I tried adding it to the dbconfig fild in the gnatsdb directory, but there wasn't a change on gnatsweb that took affect. Should I be making the change somewhere else also? Also, I modified the 'release' field from being 'text' to 'enumerated-in-file', but for some reason the enumerations don't show up corresponding to the file. Any help would be appreciated. Thanks in advance. Saima Iqbal -----Original Message----- From: Hans-Albert Schneider [mailto:Hans-Albert@ha-schneider.de] Sent: Tuesday, August 12, 2003 7:03 AM To: Iqbal Saima Cc: help-gnats@gnu.org Subject: Re: gnats help -----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 only one "database backend", namely its own format (every report is a 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 new ones, it must communicate with gnats the way it currently does. The SQL stuff in the contrib directory was what somebody used for complex reporting, connecting to customer database, etc. The data are extracted from gnats and stuffed into the database on a regular basis. (See contrib/sql/README.) So this is only a *copy* of the 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 gnats-adm/gnatsdb (individually for each database). You just add a description for each of you additional fields. There are some 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; you usually get faster response. E.g., I have been very busy until the end of last week, and I am about to leave for vacation (with rare or no e-mail access), so your mail was lucky to hit just the few days in between. All the best, Hans-Albert - -- 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== =fPae -----END PGP SIGNATURE----- _______________________________________________ Help-gnats mailing list Help-gnats@gnu.org http://mail.gnu.org/mailman/listinfo/help-gnats