Netacct Mysql / News: Recent posts

Added indexes in traffic table and corrected traffic result in admin page when user have more than one IPs.
SQL tuning for traffic visualisation in client and admin page.
Fixed some bugs into install and update php scripts from contrib.
Fixed empty field bug and warnings when there is no SQL record in netacct-mrtg script.

Possibility for use diferent languages. New file config.php for configuration setings. New files upgrade_database_3.02-3.03.php, install_database.php and upgrade_database_1.13-3.03.php into contrib directory. If you use install_database.php don't make a any table with netacct.sql file from netacct packets.

Patch by Stefan Rubner <stefan.rubner at epost.de> for authorization using host names instead of IPs - useful for users with DSL or dial-up connections. A new cron file for MRTG (netacct-mrtg.pl) for make a graph of IP traffic usage. Now the clients can to change his passwords or profile info.Addet field into users table for clients email. Maked montly cron script who generating traffic info for clients with email addresses every month. Added reverse host suport into Show IP traffic menu. And more and more ...

A new upgrade_database.php file helps convert the database from the version 0.73 to 0.74 format for netacct-mysql. A price visualization was added to the traffic columns, sorting in the traffic statistic page was corrected, and the problem with losing time periods when hiding and unhiding traffic columns was fixed. Hiding and unhiding capabilities were added to the client page.

Rewritten usage of old function mysql_db_query with new mysql_query, added possibility to hide some of traffics columns and adding group of consecutive IP-s per user.

New version of NetStat web interface for Netacct-Mysql >= version 0.74.

Rewritten most of code and queries for implementing usage of more IP's per user.

WARNING !!!
The table "users" has altered and added a new table "users_ip" !!!

this is unstable release and needs testing. DON'T USE IT FOR REAL ACCOUNTING!!!.

in release 0.74 was added new type of peering traffics direct and local (patch from Renegade). Direct (between some regional ISP), local (between IP nets of one ISP) and peering - traffic in country.
NetStat was added and new different prices for every input and output type ot this traffics and correct problem with register_globals=Off.

Minor changes, bug fixes and inproved web interface. Next version will have some major changes.

you can find nacctd + netstat in action at http://netacct-mysql.sourceforge.net/netstat/

The new coming soon in CVS version will have more categories of traffic(local, country peering, direct peering, transit, international). Increase the values for traffic fields from INT(11) into BIGINT(20)- patch from Marcin Zurakowski <marcin@interfirma.pl> and more ...

Patched the change of old user password and added new possibility into List Users to change IP info. With this new option administrator can transfer some user from one IP to other.

was added new posibility to change of metric in Bytes, Kbytes or Mbytes into traffic info pages

We have a new developer which will handle FreeBSD package and support of netacct-mysql. There is also a new package for freebsd 4.x

CVS uploaded in contrib mrta2netacct for easy importing MRTA traffic table into NetAcct table.
Now just set users and passwords for mrta and netacct databases and ... RUN.

In new version of NetStat 1.10 information was viewed with hour accuracy. Patched of traffic table and procces.c for this extension.

now netacct-mysql uses libpcap for collectiong traffic. orginal file capture-pcap.c which (i think) was desinged to work on solaris was ported to compile on linux, openbsd, freebsd .. so I need testers to report is it really working ... ;)
autoconf support was almost completly rewritten so now it is REAL ./configure sctipt

If someone want some features to be included or improved, write me :)

Sebastian Nohn has written web interface to netacct-mySQL, so I added him to developer list to work on web interface :)

The first release of netacct-mysql i out for testing. It works fine for me but does not have web interface yet. So perhaps it will be updated in next release. If someone wants to help with web interface please write me