Author Archives: Dmitriy Altuhov

Car Support Version 1.0.6

Among innovations: 1) Changed the format of data storage for XML. In this regard, the old base in the new version were not able to open. I will try to make the conversion ater 2) Added highliting (red) parts that need to be changed in the car. 3) no longer uses the registry key HKEY_CURRENT_USER […]

Posted in CarSupport | Comments closed

alLANBilling and alSUMBilling database optimization

Please delete old indexes before! I recomend to add this indexes to speedup processing: KEY `unix_secs` (`unix_secs`), KEY `dstusecs` (`dstaddr`,`unix_secs`), KEY `srcusecs` (`srcaddr`,`unix_secs`), KEY `output` (`output`,`unix_secs`) KEY `unix_secs` (`unix_secs`), KEY `dstusecs` (`dstaddr`,`unix_secs`), KEY `srcusecs` (`srcaddr`,`unix_secs`), KEY `output` (`output`,`unix_secs`)

Posted in alLANBilling, alSUMBilling | Comments closed

In alLANBilling added database cleanup

In the alLANBilling version 20080928 added textbox where you can type date. All records BEFORE entered date will be deleted from database. After delete database will optimize and check. Don’t forget to grant delete privilege to the user! grant delete on DATABSE.TABLE to USER; UPD: After mistake in the code…i’ve lost all records in my […]

Posted in alLANBilling | Comments closed

New fixes! alSAMSBilling. 25042008

New version of the alSAMSBilling. 25042008 Changes: Fixed counting money. Added new columns in the user traffic table called “From Cache”, “From Internet” Right now when counting user trafic you’ll see 3 colums “Total trafic”, “From Cache” and “From Internet”. This meens trafic from squid cache or from internet and total traffic. In the cost […]

Posted in alSAMSBilling | Comments closed

New project alStaff!

Today I starded new project called alStaff. This will be a database with web-interface for bussines phonebook and invventory database. Wait for screenshots..

Posted in site | Comments closed

alb 2008!

Oh… Happy new year! Today me have woken and have informed, that it is impossible to see internet-statistics (in the alLANBilling) of work in December 2007… Fixed! Right now you can select 2007 or 2008 year. Month selection also fixed (”december bug”). Some code and UI fixes.

Posted in alLANBilling | Comments closed

asb 2008!

Oh… Happy new year! Today me have woken and have informed, that it is impossible to see internet-statistics (in the alSAMSBilling) of work in December 2007… Fixed! Right now you can select 2007 or 2008 year. Month selection also fixed (“december bug”).

Posted in alSAMSBilling | Comments closed

New in asb071130

Displaying client’s IP address of the query (because same user name (login) may be used from the different computers): Download from sourceforge.net

Posted in alSAMSBilling | Comments closed

Typical errors

If not working web, check this: 1) if mysql extension for php is installed (php-mysql-*.rpm must be installed) 2)when you are filling “Your local network address” you should enter 192.168.1.0 (if computers in your network has addreses like 192.168.1.1, 192.168.1.5), and so on..

Posted in alLANBilling | Comments closed

Installing engine for alLANBilling

1) I hope that the NAT, routing, httpd, php, mysql,fprobe-ulog, flow-tools packages already installed 2) Add iptables rule to which all packages will be NAT-pass through ULOG This is only EXAMPLE: *filter :INPUT ACCEPT [0:0] :FORWARD DROP [0:0] :OUTPUT ACCEPT [0:0] :NETFLOW – [0:0] -A FORWARD -s 192.168.0.0/24 -d 123.123.123.123/32 -p tcp -m tcp –dport […]

Posted in alLANBilling, alSUMBilling | Comments closed