Re: gnats help

[Hans-Albert Schneider]

-----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 address@hidden
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: address@hidden
-----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-----