Spamd RRD not working since the couple of last versions



  • Hi!
    I used to run 1.0-RC1 and spamd. RRD-graphs for spamd worked fine.

    But the spamd RRD graphs don't work in;
    RC2 or the RC2i versions (did a fresh install to harddrive and then upgraded to RC2i directly),
    pfSense-Full-Update-1.0-SNAPSHOT-09-14-06.tgz (update through GUI), 
    pfSense-Full-Update-1.0-SNAPSHOT-09-18-06.tgz (update through GUI).

    The error i get is "There is no database available to generate spamd from."
    RRD-graphs for Traffic, pakets etc work.
    I also get a funny feeleing that the GUI/spamd is not working correctly. I can live with that because spamd does protect my mailserver the way it should (mostly).

    White-listing and black-listing seem to work, but when it comes to importing importing External sources i'm not sure. I've managed to import the files manually but it doesn't show on the statuspage.

    Right now it looks like this after a reinstall;
    Database totals:
      4 total items in the whitelist.
      3 total items in the blacklist.
      98 total items in the SpamDB.

    I've tried to uninstall spamd, reboot, install, reboot but nothing seems to fix my main concern - the RRD-graphs. Even tried to delete the spamd-rrd file, the database etc (followed instructions in other posts). Have checked that the files got created after install. But my knowledge of FreeBSD if very limited.

    Is it only me having this problem? Any hints?



  • Click save on the wan interface and allow it to recreate the RRD queues.



  • sullrich,

    I'm not sure that you noticed that it's only the RRD-graph for spamd thats causing my concern?

    Anyway, this is what i have done. I'm not sure i completely understand your hint (allow it to create???).
    Went to menu Interfaces_WAN and clicked button Save
    Waited for about ½ hour - no change
    Rebooted and waited ½ hour - no change
    Changed IP on Interfaces_WAN and Saved. Changed IP back saved and rebooted - no change.
    Did the same for Interfaces_LAN.

    Dont know if this helps in diagnosing my problem, but i've mounted my other disk with RC1 in another computer and tested what works and what don't.

    Shows RRD-graph?
    RC1
    WAN Traffic - Yes
    WAN Quality - Yes
    WAN Queue - Yes
    WAN Packets - Yes
    WAN spamd - Yes
    LAN Traffic - Yes
    LAN Quality - No data in minimalistic graph
    LAN Queue - No data in minimalistic graph
    LAN Packets - Yes
    LAN spamd - Yes

    1.0-SNAPSHOT-09-18-06
    WAN Traffic - Yes
    WAN Quality - Yes
    WAN Queue - Yes
    WAN Packets - Yes
    WAN spamd - There is no database available to generate spamd from.
    LAN Traffic - Yes
    LAN Quality - There is no database available to generate quality from.
    LAN Queue - There is no database available to generate queue from.
    LAN Packets - Yes
    LAN spamd - There is no database available to generate spamd from.

    I'm sorry to say my problem is still there …
    Is there anything else i can do?



  • Not sure then.  We'll have to wait for Seth to comment.

    Unfortunately I do not run the SpamD package any longer.



  • Uhm, you did "enable rrd graphing" on the spamd settings page did you?



  • databeestje,

    It is been enabled.
    I've also tested to disable reboot and enable reboot at some point.

    No luck.



  • what are the contents from```
    ls -l /var/db/rrd

    
    Paste the contents from```
    /var/db/rrd/updaterrd.sh
    

    Does that mention spamd?

    also include a```
    print_r($config['installedpackages']);

    
    Thank you


  • databeestje - This what you wanted?

    ls -l /var/db/rrd

    total 1240
    -rw-r–r--  1 root  wheel    1058 Sep 23 16:46 index.html
    -rw-r--r--  1 root  wheel  130760 Sep 25 00:39 lan-packets.rrd
    -rw-r--r--  1 root  wheel  130760 Sep 25 00:39 lan-traffic.rrd
    -rw-r--r--  1 root  wheel  195848 Sep 25 00:39 spamd.rrd
    -rw-r--r--  1 root  wheel    2134 Sep 23 16:46 updaterrd.sh
    -rw-r--r--  1 root  wheel  130760 Sep 25 00:39 wan-packets.rrd
    -rw-r--r--  1 root  wheel  65672 Sep 25 00:39 wan-quality.rrd
    -rw-r--r--  1 root  wheel  456296 Sep 25 00:39 wan-queues.rrd
    -rw-r--r--  1 root  wheel  130760 Sep 25 00:39 wan-traffic.rrd

    polling spamd for connections and tarpitness

    /usr/local/bin/rrdtool update /var/db/rrd/spamd.rrd
    /usr/local/bin/php -q /usr/local/bin/spamd_gather_stats.php
    sleep 60
    done

    Array
    (
        [spamdsources] => Array
            (
                [config] => Array
                    (
                        [0] =>
                        [1] => Array
                            (
                                [providername] => Kina
                                [providertype] => black
                                [providerdescription] => Kina
                                [rejectmessage] =>
                                [providermethod] => http
                                [providerurl] => http://72.36.234.251/chinacidr.txt
                            )

    [2] => Array
                            (
                                [providername] => Korea
                                [providertype] => black
                                [providerdescription] => Korea
                                [rejectmessage] =>
                                [providermethod] => http
                                [providerurl] => http://www.okean.com/koreacidr.txt
                            )

    [3] => Array
                            (
                                [providername] => L1
                                [providertype] => black
                                [providerdescription] => L1
                                [rejectmessage] => No, no
                                [providermethod] => http
                                [providerurl] => http://www.spews.org/spews_list_level1.txt
                            )

    )

    )

    [spamdsettings] => Array
            (
                [config] => Array
                    (
                        [0] => Array
                            (
                                [identifier] => Microsoft MAIL Service, Version: 5.0.2195.1600 ready at
                                [maxblack] =>
                                [maxcon] =>
                                [greylisting] => on
                                [passtime] => xx (substituted my actual value)
                                [greyexp] => 4
                                [whiteexp] => 860
                                [stuttersecs] => 61
                                [delaysecs] =>
                                [window] =>
                                [replysmtperror] => 451
                                [nextmta] =>
                                [enablerrd] => on
                            )

    )

    )

    [spamdoutlook] => Array
            (
                [config] => Array
                    (
                        [0] => Array
                            (
                                [username] =>
                                [password] =>
                            )

    )

    )

    [spamdwhitelist] => Array
            (
                [config] => Array
                    (
                        [0] => Array
                            (
                                [ip] => xxx.xxx.xxx.xxx (substituted my actual value)
                                [description] => P
                            )

    [1] => Array
                            (
                                [ip] => xxx.xxx.xxx.xxx (substituted my actual values)
                                [description] => Xxxxx
                            )

    (deleted the rest of the array)

    )

    )

    )

    [package] => Array
            (
                [0] => Array
                    (
                        [name] => spamd
                        [website] => http://www.openbsd.org/spamd/
                        [descr] => Tarpits like spamd are fake SMTP servers, which accept connections but don't deliver mail. Instead, they keep the connections open and reply very slowly. If the peer is patient enough to actually complete the SMTP dialogue (which will take ten minutes or more), the tarpit returns a 'temporary error' code (4xx), which indicates that the mail could not be delivered successfully and that the sender should keep the mail in their queue and retry again later.
                        [category] => Services
                        [config_file] => http://www.pfsense.com/packages/config/spamd.xml
                        [depends_on_package_base_url] => http://ftp13.freebsd.org/pub/FreeBSD/ports/i386/packages-6.0-release/All
                        [depends_on_package] => Array
                            (
                                [0] => spamd-3.7.tbz
                            )

    [version] => 4.3
                        [status] => BETA
                        [required_version] => 1.0-RC3
                        [maintainer] => geekgod@geekgod.com
                        [configurationfile] => spamd.xml
                        [logging] => Array
                            (
                                [facilityname] => spamd
                                [logfilename] => spamd.log
                            )

    )

    )

    [menu] => Array
            (
                [0] => Array
                    (
                        [name] => SpamD
                        [section] => Services
                        [configfile] => spamd.xml
                    )

    )

    [service] => Array
            (
                [0] => Array
                    (
                        [name] => spamd
                        [rcfile] => /usr/local/etc/rc.d/spamd.sh
                    )

    )

    )



  • Duplicated! Fixed in CVS!

    Thank you for the bug report.



  • Thanks for your help, guys!



  • Updated to the latest snapshot tonight.
    RRD-graphs are now working for me.

    Thanks again!  ;D


Log in to reply