DSPAM WebUI with Virtual Users on Debian Sid - mod auth mysql

Discussion in 'HOWTO-Related Questions' started by aws910, Oct 31, 2007.

  1. aws910

    aws910 New Member

    I know that, in the "DSPAM WebUI with Virtual Users on Debian Sid" tutorial, the mysql authentication module is referenced. I can NOT find the repository that it installs from. What do I need to add to my sources.list? Sorry, I know this is a noob question, but I've been trying for almost an hour to get it installed.

    Also, I found the package referenced elsewhere as libapache-mod-auth-mysql, but mod_auth_mysql is what the article references. Which one should I install... mod_auth_mysql or libapache-mod-auth-mysql?


    edit: solved. the package name should have been libapache2-mod-auth-mysql... forgot the 2. no applause, please.
     
    Last edited: Oct 31, 2007
  2. doublet

    doublet New Member

    Same error here, but my english is not very good. Witch is the solution of this?

    Thanks.

     
  3. aws910

    aws910 New Member

    Well, in my case, I didn't have the "libapache2-mod-auth-mysql" package installed. I initially thought that This package allows apache2.x to authenticate via MySQL so that you have one database for all email recipients/webusers.

    Anyway, the command that saved me in this case was:

    sudo apt-get install libapache2-mod-auth-mysql

    ...but you might find that your authentication is non-functional for other reasons. I'd recommend checking out the apache2 log. You can do this by typing at a command line:

    nano /var/log/apache2/error.log
     
  4. doublet

    doublet New Member

    Well, i just folowed original howto on this link http://www.howtoforge.com/etch_postfix_dspam_clamav but seems there's no solution about this, in debian 4.0 etch none of the commands are working:

    trix:~/files/dsmap/mod_auth_mysql-3.0.0# apt-get install libapache2-mod-auth-mysql
    Reading package lists... Done
    Building dependency tree... Done
    Package libapache2-mod-auth-mysql is not available, but is referred to by another package.
    This may mean that the package is missing, has been obsoleted, or
    is only available from another source
    E: Package libapache2-mod-auth-mysql has no installation candidate

    Maybe I just need a nice repo to do that job?
     
  5. aws910

    aws910 New Member

    My machine has since been re-purposed.

    Could you post the contents of /etc/apt/sources.list plz?
     
  6. doublet

    doublet New Member

    # deb cdrom:[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 NETINST Binary-1 20

    #deb cdrom:[Debian GNU/Linux 4.0 r0 _Etch_ - Official i386 NETINST Binary-1 200

    deb http://ftp.uni-erlangen.de/pub/Linux/debian/ etch main
    deb-src http://ftp.uni-erlangen.de/pub/Linux/debian/ etch main

    deb http://security.debian.org/ etch/updates main contrib
    deb-src http://security.debian.org/ etch/updates main contrib

    # Debian Volatile

    deb http://volatile.debian.org/debian-volatile etch/volatile main contrib non-f
    deb http://apt.scunc.it/ etch main
     
  7. aws910

    aws910 New Member

    Hope this helps... I found this page:
    http://packages.debian.org/search?k...th-mysql&searchon=names&suite=all&section=all

    So I think you need to change your repositories from ETCH to SID. I remember a post somewhere on the tutorial itself saying this - that the title of the article had to be changed from etch to sid because of the inclusion of this one package. When you change your sources.list, don't forget to do an "apt-get update".

    but I had difficulties after getting this to work anyway. Things just didn't work right for some reason, and I was under the gun to get an antispam system working.... that and the fact that end-users stared at me blankly when I told them they needed to log in to a webpage to check for false-positives. The idea of a web-ui appeals to us techies because it gives us more control, but end-users just don't want *any* more complexity, and it gives them just one more thing to call us about on holidays.

    ...as for me, I ended up installing ASSP - I had it up and running in less than an hour. We've been on that for months and I've had zero false-positives reported. If you're just tinkering, keep hacking with DSpam/webui, but if you need something now, look at one of the great tutorials on this site regarding ASSP. I think this may have been the one I used:
    http://www.howtoforge.com/assp_clamav_postfix_debian_etch

    Nothing personal against the DSpam people, I really appreciate their effort and am glad they are selflessly giving their time to the community. I'm sure their product works just as good, I just couldn't get it working in time.
     
  8. doublet

    doublet New Member

    Thanks aws .... I'll take a look when i have some time. I appreciate ur help. While that I think is a good idea to take the easy option of installing ASSP. Also I've seen that is a nice tool also.

    Will tell u something, hope after this weekend migration that I have.

    Cheers! ;)
     

Share This Page