Netgate Discussion Forum
    • Categories
    • Recent
    • Tags
    • Popular
    • Users
    • Search
    • Register
    • Login

    Spamd RRD not working since the couple of last versions

    Scheduled Pinned Locked Moved pfSense Packages
    11 Posts 3 Posters 6.0k Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      annv
      last edited by

      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?

      1 Reply Last reply Reply Quote 0
      • S
        sullrich
        last edited by

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

        1 Reply Last reply Reply Quote 0
        • A
          annv
          last edited by

          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?

          1 Reply Last reply Reply Quote 0
          • S
            sullrich
            last edited by

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

            Unfortunately I do not run the SpamD package any longer.

            1 Reply Last reply Reply Quote 0
            • D
              databeestje
              last edited by

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

              1 Reply Last reply Reply Quote 0
              • A
                annv
                last edited by

                databeestje,

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

                No luck.

                1 Reply Last reply Reply Quote 0
                • D
                  databeestje
                  last edited by

                  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
                  1 Reply Last reply Reply Quote 0
                  • A
                    annv
                    last edited by

                    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
                                    )

                    )

                    )

                    1 Reply Last reply Reply Quote 0
                    • D
                      databeestje
                      last edited by

                      Duplicated! Fixed in CVS!

                      Thank you for the bug report.

                      1 Reply Last reply Reply Quote 0
                      • A
                        annv
                        last edited by

                        Thanks for your help, guys!

                        1 Reply Last reply Reply Quote 0
                        • A
                          annv
                          last edited by

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

                          Thanks again!  ;D

                          1 Reply Last reply Reply Quote 0
                          • First post
                            Last post
                          Copyright 2025 Rubicon Communications LLC (Netgate). All rights reserved.