Re: [mysar-support] smoe error: Database error message: Column 'ip' cannot be null

[Giannis S. <gi...@st...>]

You have "log_fqdn" set  to "on" in your squid.conf file. Set it to
off, delete all the old log files and the problem should be solved.

Mysar can't parse log files with the client name already resolved.


On 7/31/06, chen bend <ccd...@ya...> wrote:
> hi,mysar.
>
> i found this error in my mysar-importer.log:
> SQL query: INSERT INTO
> traffic(date,time,ip,resultCode,bytes,url,authuser) VALUES
> ('2006-07-30','15:30:56',INET_ATON('unknown.Level3.net'),'TCP_MISS/500','409','http://www.yl35.com/info/Html/20058139254-1.shtml','-')
> Database error number: 1048
> Database error message: Column 'ip' cannot be null
>
> what should i do?
> thanks.
>
> i used a linux box tested mysar perform  :-)
> two intel PIII 1G cpu,and 1G RAM,used Redhat AS 4.2 .(php-4.3.9-3.8)
> one time ,mysar can processed 17761 records.