[NFDB-users] Apache problem trying to load NFD in OBSD 4.5

[Fernando Alvarez]

On the database log, I can see the following multiple times:

ERROR:  Date out of range.  Fix flows_insert_trigger() function.
STATEMENT:  INSERT INTO flows_template VALUES ($1,now(),$2,$3,$4,$5,$6,
$7,$8,$9,$10,$11,$12,$13,$14,$15,$16,$17,$18,$19,$20,$21,$22,$23,$24,
$25,$26,$27,$28,$29,$30,$31)


Is that normal? Could it be the root of my problems with nfdb?


El vie, 08-05-2009 a las 14:36 +0200, Fernando Alvarez escribió:
> Hi all,
> 
> I've tried to see what's happening with nfdb and I have no idea about
> what's going on...
> 
> I execute /var/www/netflowdashboard/sbin/netflowdb.pl -D and I can see
> lots of packets arriving at the interface:
>         ...
>         128.121.146.107:80 => 172.22.1.200:52162, 6 packets row UPDATED
>         ...
>         
> If I try flowd -d , I can see after some seconds, how packets are
> arriving:
> 
>         read_config: entering
>         child_get_config: entering
>         drop_privs: dropping privs without chroot
>         recv_config: entering fd = 3send_config: entering fd = 4
>         
>         recv_config: ready to receive configsend_config: done
>         
>         child_get_config: child config done
>         Listener for [10.0.0.2]:12345 fd = 3
>         Adjusted socket receive buffer from 41600 to 262144
>         Setting socket send buf to 1024
>         privsep_init: entering
>         drop_privs: dropping privs with chroot
>         init_pfd: entering (num_fds = 0)
>         init_pfd: done (num_fds = 2)
>         client_open_log: entering
>         answer_open_log: entering
>         
>         
>         Received max number of packets (512) on fd 3
>         Valid netflow v.5 packet 30 flows
>         process_flow: ACCEPT flow FLOW recv_time
>         2009-05-08T16:31:13.805051 proto 17 tcpflags 00 tos 00 agent
>         [10.0.0.1] src [208.67.222.222]:53 dst [172.22.1.200]:63421
>         gateway [0.0.0.0] packets 1 octets 79 in_if 0 out_if 0
>         sys_uptime_ms 1h15m49s.000 time_sec 2009-05-08T16:31:13
>         time_nanosec 454819 netflow ver 5 flow_start 6d8h4m25s.456
>         flow_finish 6d8h4m55s.456 src_AS 0 src_masklen 0 dst_AS 0
>         dst_masklen 0 engine_type 10752 engine_id 10752 seq 632 source 0
>         crc32 00000000 
>         output_flow_enqueue: initial allocation 16384
>         output_flow_enqueue: offset 116 alloc 16384
>         
>         ... and lots more like this one...
>         
> 
> And that's all... I don't know what to do because AFAIK everything seems
> to be ok, but the web interfaces shows nothing: no devices, no info, no
> graphics... only the main interface. That's frustrating! :-\
> 
> Anyway, thanks a lot for your help. Any idea is welcome
> 
> 
> Fernando
> 
> _______________________________________________
> nfdb-users mailing list
> nfdb-users at netflowdashboard.com
> http://www.dixongroup.net/mailman/listinfo/nfdb-users
>