I'ev downloaded the latest version of netacct-mysql and netacct-netstat so i'll have the daemon load the traffic data into a database wich i want to parse over the web so i can monitor traffic at all time via a browser .
Things went verry ok as the daemon started after a compilation on a Slackware 8.1 with a kernel 2.4.20-xfs and started loading my database with the correct amounts of traffic made by each IP .
The problem apeared at the php interface and it seems to me that the README and the FAQ files are verry weak in responses to questions not verry asked but verry stressing for a system with all requestets/dependencies fullfilled correctly .
I've installed the netacct-netstat *.php files into my DirectoryRoot used by apache , i have php and apache installed by default from the slackware distributions . I've edited the config.php file and introduced there the corect user and pass sequence for connecting to mysql.socket present in /var/run/mysql .
The problem apeared first in creating the databses over the web , as you might know netacct-netstat has in the contrib directory thre php files wich either install or upgrade the databases correctly to the last version of netacct-netstat .
Neither of those scripts worked ! I've put into the install_database.php the user and pass for the database . Nothing happened and i've decided to user the root login to mysql . It went exacly the same . Nothing happened . At last i've installed the databases manualu from the file netacct.sql . The databse installed corectly . As it sais in the README i've made a last insert into ipallow so i'll have access from the IP i use on my machine .
I've started apache and tried to login with the username and pass provided in the setup process (user admin , pass admin) . When i press [Login] nothing happens . I've tryed to debug the whole thing but it seems that the framing of the index.php doesen't like my intrussions into this file . I've printed out my address o i'll see if somehow the server receives another ip from the HTTP_GET_ADDR variable or whatever it is called . The ip was correctly stated in the file as my ip and as the ip wich was inserted into the ipallow table .
As you might think i've done all things "by the book" and it's still doesen't work .
As a last measurement before writing here i've recompiled mysql , apache and php using sources well tested in production . The result was exaclty the same . I have two netacctd daemons counting traffic and loading the info correctly into mysql but the netacct-netstat still doesen't work .
Can anyone help ? Did this happened before to any of you ?
Please answer , i'm verry fascinated about this type of programs , i've build one myself but my interface works FINE , the daemon wich counts traffic was written in C by a coleague of mine and it was too bugy so we quit doing it :)
I really wanna know .
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hello guys .
I'ev downloaded the latest version of netacct-mysql and netacct-netstat so i'll have the daemon load the traffic data into a database wich i want to parse over the web so i can monitor traffic at all time via a browser .
Things went verry ok as the daemon started after a compilation on a Slackware 8.1 with a kernel 2.4.20-xfs and started loading my database with the correct amounts of traffic made by each IP .
The problem apeared at the php interface and it seems to me that the README and the FAQ files are verry weak in responses to questions not verry asked but verry stressing for a system with all requestets/dependencies fullfilled correctly .
I've installed the netacct-netstat *.php files into my DirectoryRoot used by apache , i have php and apache installed by default from the slackware distributions . I've edited the config.php file and introduced there the corect user and pass sequence for connecting to mysql.socket present in /var/run/mysql .
The problem apeared first in creating the databses over the web , as you might know netacct-netstat has in the contrib directory thre php files wich either install or upgrade the databases correctly to the last version of netacct-netstat .
Neither of those scripts worked ! I've put into the install_database.php the user and pass for the database . Nothing happened and i've decided to user the root login to mysql . It went exacly the same . Nothing happened . At last i've installed the databases manualu from the file netacct.sql . The databse installed corectly . As it sais in the README i've made a last insert into ipallow so i'll have access from the IP i use on my machine .
I've started apache and tried to login with the username and pass provided in the setup process (user admin , pass admin) . When i press [Login] nothing happens . I've tryed to debug the whole thing but it seems that the framing of the index.php doesen't like my intrussions into this file . I've printed out my address o i'll see if somehow the server receives another ip from the HTTP_GET_ADDR variable or whatever it is called . The ip was correctly stated in the file as my ip and as the ip wich was inserted into the ipallow table .
As you might think i've done all things "by the book" and it's still doesen't work .
As a last measurement before writing here i've recompiled mysql , apache and php using sources well tested in production . The result was exaclty the same . I have two netacctd daemons counting traffic and loading the info correctly into mysql but the netacct-netstat still doesen't work .
Can anyone help ? Did this happened before to any of you ?
Please answer , i'm verry fascinated about this type of programs , i've build one myself but my interface works FINE , the daemon wich counts traffic was written in C by a coleague of mine and it was too bugy so we quit doing it :)
I really wanna know .
Your IP is't allowed. By default only 127.0.0.1 is.
Make this query first:
INSERT INTO ipallow (ip_host) VALUES ('123.123.123.123');
just replace 123.123.123.123 with your IP ;")
into install_database.php script I have one error when script create base and is needed to get back and start again for creating of tables.
Sorry about