New Addon for ISP billing

[Roke]

26 NOVEMBER 2010
----------------------------------------------------------
New release of cclient on http://www.rokeblog.com

Now we use the "nth_percentile" and "bandwidth_summation" functions of cacti, the code is small and more easy to understand.

Now you can bill for 95th percentile !!!!!!!

Please send feedback to my email!!

----------------------------------------------------------

Im working in addon for ISP billing with cacti, you can assign a server to a cacti user and configure traffic limit or bandwidth.

The user can see the report in real time and is include in the cacti interface, now im working for exporting all data in xml file so you can import this xml files to your own billing program.

In the next month i think i finish the addon, until this i give you a screenshot so you can see the addon working.

EDIT: 14-10-2010

I think i have the firts release, I make a simple web for all this plugin. You can write in this thread the bug and the need you think would be in the plugin. All information about install the plugin and how it workt are in http://www.rokeblog.com

See the video of the plugin.

http://www.youtube.com/v/k989ItlENDo?fs=1&hl=es_ES



http://www.rokeblog.com

[Vins]

watch out that the cclient.sql script has an error; executing the code

CREATE TABLE `cclient_data` (
`idcliente` INT NOT NULL ,
`nombrecliente` VARCHAR( 255 ) NOT NULL ,
`nombreservidor` INT NOT NULL ,
`caudal` BOOLEAN NOT NULL COMMENT '1=Caudal 0=Trafico',
`trafico` INT NOT NULL ,
`costegiga` INT NOT NULL,
PRIMARY KEY (`idcliente`),
) ENGINE = MYISAM ;

ends with

ERROR 1064 (42000) at line 2: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') ENGINE = MYISAM' at line 9


you should remove the last "," of your query...

CREATE TABLE `cclient_data` (
`idcliente` INT NOT NULL ,
`nombrecliente` VARCHAR( 255 ) NOT NULL ,
`nombreservidor` INT NOT NULL ,
`caudal` BOOLEAN NOT NULL COMMENT '1=Caudal 0=Trafico',
`trafico` INT NOT NULL ,
`costegiga` INT NOT NULL,
PRIMARY KEY (`idcliente`)
) ENGINE = MYISAM ;

is correctly installed



Thanks for the plugins

[Roke]

CClient is avaible on http://www.rokeblog.com

[rony]

Please contact me via email, I have something that might interest you.

[Roke]

Hi,

I have to announce shortly a new version of the program CClient that fix several bugs and is translate to spanish and english. In a few days I will post the download links as well as a document of installation and use of the plugin.

While finishing the last changes I leave a list of functions that have:

- Detailed Traffic in Graph tab
- Linking Graphs with users to set limits traffic and bill the excessive traffic consumed
- Monthly reports of the server you selected
- Export report to XML
- Email reports in HTML or/and XML

In a few days I will have you prepared the documentation and facilitates the plugin.

A greeting.

[Hyperlord]

Oh I'm really looking forward for that, building up a new Cacti installation soon and this might fit in very well!

[Roke]

I have made a simple web to have all documents and all information about the plugin. Please visit the website and post in the forum the impression and all bug you find.

The CClient is avaible on http://www.rokeblog.com

[dhost]

Very nice plugin. I too am upgrading cacti and look forward to using it with the new cacti setup. Will watch for english translation.

Thanks for sharing.

[Roke]

26 NOVEMBER 2010
----------------------------------------------------------
New release of cclient on http://www.rokeblog.com

Now we use the "nth_percentile" and "bandwidth_summation" functions of cacti, the code is small and more easy to understand.

Now you can bill for 95th percentile !!!!!!!

Please send feedback to my email!!

----------------------------------------------------------