<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi,<br>
<br>
It depens on your sql database server. dbtype mean "character
varying(30)" or "boolean" and so on in case of postgresql. But the
types (and the names of the types) of columns are different for all
database types (for example: varying in case of pgsql, but varchar
for mysql and so on...)<br>
<br>
Syslog-ng does not try to understand the column type, just will use
it as a "plain" text in a sql insert. So that there are no
restrictions, but if it is not a valid type for the given sql
server, the sql server will rejected it.<br>
<br>
anyway, here is the documentation about existing column types:<br>
<a class="moz-txt-link-freetext" href="http://www.postgresql.org/docs/7.4/static/datatype.html">http://www.postgresql.org/docs/7.4/static/datatype.html</a><br>
<br>
and here is an example for pgsql:<br>
<br>
columns("a1 character varying(30)", "a2 bigserial", "a3 bit", "a4
bit varying(8)", "a5 boolean", "a6 box", "a7 bytea", "a8 bigint",
"a9 character(30)",<br>
"b1 cidr", "b2 circle", "b3 date", "b4 double precision",
"b5 inet", "b6 integer", "b7 interval(10)", "b8 line", "b9 lseg",<br>
"c1 macaddr", "c2 money", "c3 numeric(1,1)", "c4 path",
"c5 point", "c6 polygon", "c7 real", "c8 smallint", "c9 serial",<br>
"d1 text", "d2 time", "d3 timestamp")<br>
<br>
<br>
On 2011-02-22 08:55, Hendrik Visage wrote:
<blockquote
cite="mid:AANLkTinyEdpPpdqFEXDKFxK1kJd12=qVyO+3xV_L_72h@mail.gmail.com"
type="cite">Hi there,<br>
<br>
found the following entry in the Administrator's guide(s):<br>
<br>
<quote><br>
<br>
columns
<a moz-do-not-send="true" class="indexterm" name="id3004444"></a>
<div class="informaltable">
<table style="border-collapse: collapse; border-top: 1pt solid
rgb(19, 53, 129); border-bottom: 1pt solid rgb(19, 53, 129);">
<colgroup>
<col width="40pt">
<col>
</colgroup>
<tbody>
<tr>
<td style="" bgcolor="#d4d6eb">Type: </td>
<td style="">string list</td>
</tr>
<tr>
<td style="" bgcolor="#d4d6eb">Default: </td>
<td style="">"date", "facility", "level", "host",
"program", "pid", "message"</td>
</tr>
</tbody>
</table>
</div>
<p><span class="guilabel"><strong>Description:</strong></span>
Name of the columns storing the data in <em class="parameter"><code>fieldname
[dbtype]</code></em> format. The <em class="parameter"><code>[dbtype]</code></em>
parameter is optional, and specifies the type of the field. By
default, syslog-ng creates <em class="parameter"><code>text</code></em>
columns. Note that not every database engine can index text
fields.</p>
<p></quote><br>
</p>
<p>So now before I go search the source code for answers, what
types of "[dbtype]" is supported/handled by syslog-ng 3.2.2?</p>
<p>More precisely, I'm running on HP-UX 11.31 and preference is
using PostgreSQL<br>
</p>
<p>Thank you</p>
<p>HEndrik<br>
</p>
<br>
<pre wrap="">
<fieldset class="mimeAttachmentHeader"></fieldset>
______________________________________________________________________________
Member info: <a class="moz-txt-link-freetext" href="https://lists.balabit.hu/mailman/listinfo/syslog-ng">https://lists.balabit.hu/mailman/listinfo/syslog-ng</a>
Documentation: <a class="moz-txt-link-freetext" href="http://www.balabit.com/support/documentation/?product=syslog-ng">http://www.balabit.com/support/documentation/?product=syslog-ng</a>
FAQ: <a class="moz-txt-link-freetext" href="http://www.campin.net/syslog-ng/faq.html">http://www.campin.net/syslog-ng/faq.html</a>
</pre>
</blockquote>
<br>
</body>
</html>