[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Nufw-users] nulog 2.1.4-1 + ulogd-pgsql 1.24-2.1
From: |
Vladimir Elizarov |
Subject: |
Re: [Nufw-users] nulog 2.1.4-1 + ulogd-pgsql 1.24-2.1 |
Date: |
Tue, 19 May 2009 17:15:08 +0400 |
User-agent: |
Thunderbird 2.0.0.21 (X11/20090409) |
Glen Ogilvie wrote:
> ----- "Vladimir Elizarov" <address@hidden> wrote:
>
>> Hello!
>> I'm install nulog 2.1.4-1 in debian lenny. Create databse, user.
>> Insert
>> dump sql nulog.pgsql.sql.
>> Get error in ulogd:
>>
>> Mon Apr 6 16:39:51 2009 <7> ulogd_PGSQL.c:216 sql error during
>> insert:
>> ERROR: column "ip_daddr" is of type inet but expression is of type
>> bigint
>> LINE 1:
>> ...ck,tcp_urg,tcp_ackseq,tcp_seq,tcp_dport,tcp_sport,ip_daddr,i...
>> ^
>> HINT: You will need to rewrite or cast the expression.
>>
>>
>
> Hi,
>
> It sounds like ulogd will be logging the ip_daddr as a bigint, rather than an
> IP address. What it does
> is converts an IP address like 202.123.234.23 into decimal like: 3397118487.
> I think this is because in mysql, the is no type for inet.
>
> To undrestand conversions, this site is handy:
> http://www.allredroster.com/iptodec.htm
>
> So, to fix this, you either need ulogd to use a stored procedure for inserts
> that converts it to the right type, or alter the ulog table and change the
> column type for ip_daddr to bigint. you will probably need to change the
> ip_saddr column too.
>
I'm change type column. Get segfault ulogd:
Tue May 19 17:08:29 2009 <5> ulogd.c:594 sigterm received, exiting
> I am assuming your using ulogd version 1, rather than 2?
>
> Regards
> Glen Ogilvie
>
>
>> What fix?
>>
>> Thanks.
>>
>>
>> _______________________________________________
>> Nufw-users mailing list
>> address@hidden
>> http://lists.nongnu.org/mailman/listinfo/nufw-users
>>
signature.asc
Description: OpenPGP digital signature