Spamd RRD not working since the couple of last versions

annv

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?

sullrich

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

annv

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?

sullrich

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

Unfortunately I do not run the SpamD package any longer.

databeestje

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

annv

databeestje,

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

No luck.

databeestje

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

annv

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
)

)

databeestje

Duplicated! Fixed in CVS!

Thank you for the bug report.

annv

Thanks for your help, guys!

annv

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

Thanks again! ;D