Community support for Plesk, CPanel, WebMin and others with insight from two of the founders of Plesk. Ask for help here! No question is too simple or complicated.
/*
Plesk Spamdyke Control Panel (Version see version.php) - GUI for Plesk spamdyke implementation
Copyright (C) [2008] [Matthias Hackbarth / www.haggybear.de]
This program is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as
published by the Free Software Foundation; either version 3 of the License, or (at your option) any later version.
This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty
of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License along with this program; if not, see <http://www.gnu.org/licenses/>.
*/
error_reporting(1);
define("DB_USR", "admin");
define("DB_PWD", trim(exec ("cat /etc/psa/.psa.shadow")));
define("DB_NAME", "psa");
define("DB_HOST", "localhost");
define("QMAIL_PATH", "/var/qmail/");
define("LOG_FILE","/usr/local/psa/var/log/maillog");
define("SPAMDYKE_CONFIG","/etc/spamdyke.conf");
//Only if you want to use the autoupdate function
define("AUTOUPDATE",true);
// define your language file, ex: en; ro; de;
define("LANG", "en");
define("PSA_PATH",trim(exec ("grep PRODUCT_ROOT_D /etc/psa/psa.conf | sed s/^[t]*[A-Z_]*[t]*//"))."/");
define("PSA_VERSION",substr(trim(exec ("cat ".PSA_PATH."version")),0,1));
//Default view - entries per page [25,50,100,200]
define("DEFAULT_PERPAGE",100);
//Logtype file/mysql (mysql only for the patched spamdyke-version from haggybear.de)
define("LOG_TYPE","mysql");
define("PSA_PATH",trim(exec ("grep PRODUCT_ROOT_D /etc/psa/psa.conf | sed s/^[t]*[A-Z_]*[t]*//"))."/");
define("PSA_VERSION",substr(trim(exec ("cat ".PSA_PATH."version")),0,1));
define("PSA_PATH",trim(exec ("grep PRODUCT_ROOT_D /etc/psa/psa.conf | sed s/^[t]*[A-Z_]*[t]*//"))."/");
define("PSA_VERSION",substr(trim(exec ("cat ".PSA_PATH."version")),0,1));
//Use whois detection for the daily reports! If false then the RDNS-detection will be used!
define("WHOIS_DETECT",true);
//Show flattr Button in Headline
define("SHOW_FLATTR",false);
//Master-Crypt-Key for Token encryption!
define("CRYPT_KEY",DB_PWD);
//
//
//
CREATE DATABASE spamdyke;
USE spamdyke;
CREATE TABLE `spamdyke_log_table` (
`id` bigint(7) NOT NULL auto_increment,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP,
`reason` varchar(30) character set utf8 NOT NULL,
`from` varchar(50) character set utf8 NOT NULL,
`to` varchar(50) character set utf8 NOT NULL,
`ip` varchar(15) character set utf8 NOT NULL,
`rdns` varchar(50) character set utf8 NOT NULL,
`auth` varchar(25) character set utf8 NOT NULL,
PRIMARY KEY (`id`),
KEY `time` (`time`),
KEY `reason` (`reason`,`from`,`to`,`ip`,`rdns`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
GRANT ALL ON spamdyke.* TO 'spamdyke'@'localhost' IDENTIFIED BY 'spamdyke';
FLUSH PRIVILEGES;
The database existed but the table did not. Now it is reporting everything in the SCP. Thank you so much for your help it is greatly appreciated. I hope this topic is helpful to others having similar issues.
Ok I hate to rehash this topic but I am at a loss. I upgraded plesk 10.0 to 10.2 and now HaggyBears Spamdyke is not functioning. Its not blocking messages and the daily reports I receive is incomplete. has anyone else had this issue after upgrading?
First thing. If it's not blocking anything anymore I bet that due to the pleak upgrade you need to edit the /etc/xinetd.d/smtp_psa and /etc/xinetd.d/smtps_psa. Also make sure that Plesks internal greylisting feature is disabled.
After that recheck if it's working.
Besides that you could also upgrade to latest Spamdyke Version 2.4.5
would that require me to uninstall the current spamdyke version and reinstall the new one or can I compile the new one right on top of the old install?
Trying the the other method first.
Thanks.
I am also strugling to get haggybear Spamdyke CP to PLESK 10.4.4 Centos 6.1[Final]
Everything seems to be running, i see log entries in the maillog and in the mysql databases
However when i try to access to the Spamdyke CP i get the following error.
Spamdyke not installed, or path to spamdyke.conf in config.inc.php is not set!!
I have extraced the folder "application" into the directory "smb" of your Plesk admin directory.
My custom button URL = /smb/haggybear?addon=spamdyke