OpenForum RSS: Squid � MySQL

Squid � MySQL (ALEXEYCH)

Fri, 11 Jul 2008 07:31:27 GMT

>� � �� mysql ��.
>�� access_log.c � ��.
>��

� �� , �� .

Squid � MySQL (��..��)

Fri, 11 Jul 2008 07:15:28 GMT

� � �� mysql ��.
�� access_log.c � ��.
��

Squid � MySQL (blitzkrieg)

Thu, 10 Jul 2008 05:07:12 GMT

>
>>�� squid_stat �� squid.
>>�� squid.squid
>
>� �� squid_stat, � squid

�� , �� . ICQ 128352030
��, ��

Squid � MySQL (ALEXEYCH)

Thu, 10 Jul 2008 05:04:30 GMT

>�� squid_stat �� squid.
>�� squid.squid

� �� squid_stat, � squid

Squid � MySQL (blitzkriegmail.ru)

Wed, 09 Jul 2008 14:12:36 GMT

>[�� ]
>$max_date_query="SELECT MAX(time) FROM squid;";
>$sth = $dbh->prepare($max_date_query);
>� �.�.
>
>�� .
>
>DBD::mysql::st execute failed: Table 'squid.squid' doesn't exist at ./2 line 9.
>DBD::mysql::st fetchrow_array failed: fetch() without execute() at ./2 line 10.
>The number of parsed strings is 2930 and was added to database
>only 2930 strings.

�� squid_stat �� squid.
�� squid.squid

Squid � MySQL (ALEXEYCH)

Wed, 09 Jul 2008 13:14:35 GMT

��

#!/usr/local/bin/perl
use DBI;

$full_path='/var/log/squid/access.log';

$dbh = DBI->connect("DBI:mysql:squid_stat:localhost",root,pass);
$max_date_query="SELECT MAX(time) FROM squid;";
$sth = $dbh->prepare($max_date_query);
� �.�.

�� .

DBD::mysql::st execute failed: Table 'squid.squid' doesn't exist at ./2 line 9.
DBD::mysql::st fetchrow_array failed: fetch() without execute() at ./2 line 10.
The number of parsed strings is 2930 and was added to database only 2930 strings.

Squid � MySQL (blitzkrieg)

Wed, 09 Jul 2008 11:42:39 GMT

�� access.log � Mysql
�� sh

mysql --user=root --password=pass --database=squid_stat --execute="drop table squid"
mysql --user=root --password=pass --database=squid_stat \
--execute="create table squid(time varchar(14),ip varchar(16),result_codes varchar(50) \
,bytes bigint unsigned default 0,method varchar(10),url varchar(255),short_url varchar(255),user varchar(30),hierarchy_code varchar(30));"

�� , �� .
�� -�� , �� , �� , �� , � �� @a � �� .

�� @b �� http://site.ru/

#!/usr/local/bin/perl
use DBI;

$full_path='/var/log/squid/access.log';

$dbh = DBI->connect("DBI:mysql:squid_stat:localhost",root,pass);
$max_date_query="SELECT MAX(time) FROM squid;";
$sth = $dbh->prepare($max_date_query)

OpenForum RSS: Squid � MySQL

Squid � MySQL (ALEXEYCH)

Squid � MySQL (���..������������)

Squid � MySQL (blitzkrieg)

Squid � MySQL (ALEXEYCH)

Squid � MySQL (blitzkriegmail.ru)

Squid � MySQL (ALEXEYCH)

Squid � MySQL (blitzkrieg)

Squid � MySQL (��..��)