Solution For Traffic Count Mail In/Out (Courrier/Dovecot + Postfix) + Ftp Traffic

Discussion in 'Developers' Forum' started by moglia, Jan 20, 2011.

  1. moglia

    moglia New Member

    This packages on squeeze and debian have a solution to get traffic information.
    Indepent you using courrier or dovecot.

    This have a couple of daemons looking the syslog can get all traffic info on realtime. The work now is discovery how it´s works and adapt it for ispconfig3.
    I belive need create a little bit of adtional tables and change a couple of mysql queries.

    http://packages.debian.org/search?keywords=mysqmail

    Im easy backported the packages and used it on past part of DTC project.

    Adtional will be gain a FTP Trafic information, IMAP Trafic great benefits.

    Have way to build packages for redhat/debian easy. just need change the names and codes and release a special fork for ispconfig3.
     
  2. moglia

    moglia New Member

    Modularity / Custom Queries

    mysqmail is a fantastic group of packages. but is not modular now only works with DTC. have a potentially to works on anyting but need a possibility to change the queries using a conf like. like you can do on dovecot/postfix maping.

    Anyone have any opinion about it? I´m personaly tested it on past and works great.
     
  3. till

    till Super Moderator

    If it is available as package for all supported Linux distributions (Debian, Centos, Ubuntu, OpenSuSE, Fedora) then we can consider to add it to ispconfig.
     
  4. moglia

    moglia New Member

    More Information

    This packages is ready for Debian/Ubuntu.

    Centos, OpenSuSE and Fedora is RPM based distros i see buildrpm inside the sources. I talk with thomas. and see on site.

    Ports for FreeBSD is avaliable too. Gentoo and OSX with small patches.

    sbox-dtc is a interest package too.

    But remember need make some parametric queries on sources to make this more portable and configurable beetween DTC and ISPCONFIG. I see the sources this don´t be appers complicated.
     
  5. till

    till Super Moderator

    But maybe it is not nescessary to adapt this package to ispconfig as ispconfig counts most other traffic stats of its own already and we try to avoid any additional external dependency. Do you know from which source or how the package gets the size of incoming messages from dovecot? It might be better to add a few lines of code to the exsiting ispconfig system instead of adding a new external dependency, as no code from DTC can be added to ispconfig due to incompatible open source licenses.

    I've checked the mysqlmail page and there is no dovecot support listed:

    http://www.gplhost.com/software-mysqmail_3package.html

    are you sure that there is a dovecot module available?
     
  6. moglia

    moglia New Member

    This page is relative outdated:

    Packages is on debian/ubuntu repositories and avaliable for centos/redhat via yum.

    http://packages.debian.org/sid/mysqmail-dovecot-logger
    http://packages.debian.org/sid/mysqmail-postfix-logger
    http://packages.debian.org/sid/mysqmail-courier-logger
    http://packages.debian.org/sid/mysqmail-pure-ftpd-logger

    Is more easy adapt the packages for universal working build query by config. like dovecot and postfix query. Then this daemons can be used by any solution to count mail/ftp trafic not only just for DTC or ISPCONFIG.

    I talk with Thomas Goirand about this idea and say yes think it is interessant.

    Contact Thomas: thomas [ at ] goirand [ dot ] fr, or join the #dtc-dev channel on IRCnet (thomas nick is zigo).

    http://packages.debian.org/search?keywords=mysqmail&searchon=names&suite=unstable&section=all

    About licence: You talk about BSD license x GPL is incompatible right?

    I get all sources packages using apt-get source mysqmail SID source repository.
     
    Last edited: Jan 21, 2011
  7. till

    till Super Moderator

    I will check out the packages.

    Yes. If we would add GPL code to ispconfig, then the ispconfig project would gets infected by gpl and becomes gpl licensed. But it is the goal of the ispconfig project to use a liberal license like BSD for this project.
     
  8. moglia

    moglia New Member

    Possible Change Licence.

    Menssage from Developer:
    "I don't mind re licensing it as BSD license. It's easy to do so, because
    I've been the only author so far."
    Thomas
     
  9. till

    till Super Moderator

    That is a really great option indeed if he would consider that in case that we could use them. I will check out the packages to see how they fit into ispconfigs traffic accounting system.
     

Share This Page