| View previous topic :: View next topic |
| Author |
Message |
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
 Posted: Sun Sep 18, 2011 6:00 pm Post subject: |
 |
|
I'll look at it, it has good chances to be available in new release.
It seems easy to install though if you wanna try it...
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Sun Sep 18, 2011 8:09 pm Post subject: |
|
|
yes, please!!!
Will you post a packet? until new release?  |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Fri Sep 30, 2011 2:50 pm Post subject: |
|
|
| any news about this new packet ? |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
|
| Back to top |
|
Slackwan
Junior Member
Joined: 04 Jul 2010
Posts: 14
|
| Posted: Mon Oct 03, 2011 6:25 am Post subject: |
|
|
Great Package
Thank you |
|
| Back to top |
|
miguipda
Member
Joined: 14 Jul 2011
Posts: 93
|
| Posted: Thu Oct 06, 2011 7:22 pm Post subject: |
|
|
Yes indeed, a great package.
Thx gerasimos_h and Sinbad
_________________
Miguipda  |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Sat Dec 24, 2011 7:00 pm Post subject: |
|
|
Thanks for upgrade!!
i have this error:
Please verify read permissions on:
/var/spool/postfix/hold and /var/spool/postfix/incoming
and
Error executing query:
Table 'mailscanner.mtalog_ids' doesn't exist
SQL:
SELECT
DATE_FORMAT(m.timestamp,'%d/%m/%y %H:%i:%s') AS 'Date/Time',
m.host AS 'Relayed by',
m.relay AS 'Relayed to',
m.delay AS 'Delay',
m.status AS 'Status'
FROM
mtalog AS m
LEFT JOIN mtalog_ids AS i ON (i.smtp_id = m.msg_id)
WHERE
i.smtpd_id='04E1BF41B71.A0D87'
AND
m.type='relay'
ORDER BY
m.timestamp DESC |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Sat Dec 24, 2011 8:31 pm Post subject: |
|
|
It seems that doesn't like the upgrade
Try to execute SQL query
| Code: | | mysql -umailwatch -p$RCPASS -D mailscanner < tables.txt |
tables.txt
| Code: | -- Table structure for table `mtalog`
CREATE TABLE mtalog (
timestamp datetime default NULL,
host text,
type text,
msg_id varchar(20) default NULL,
relay text,
dsn text,
status text,
delay time default NULL,
UNIQUE KEY mtalog_uniq (timestamp,host(10),type(10),msg_id,relay(20)),
KEY mtalog_timestamp (timestamp),
KEY mtalog_type (type(10))
) TYPE=MyISAM;
|
As for permissions are set by postfix
try
| Code: | | postfix set-permissions |
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Sun Dec 25, 2011 8:06 pm Post subject: |
|
|
chmod on this folder is postfix. any other sugestion?
Can you please check script? |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Mon Dec 26, 2011 12:47 pm Post subject: |
|
|
| today i will try wit fresh install |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Mon Dec 26, 2011 1:12 pm Post subject: |
|
|
It's possible a bug of mailwatch, caused by postfix.inc
| Code: | function postfixinq()
{
$handle = opendir('/var/spool/postfix/hold/');
$inq = 0;
while (false !== ($file = readdir($handle)))
{
//evaluate each entry, removing the . & .. entries
if ($file !== '.' && $file !== '..')
{
$inq++;
}
}
closedir($handle); |
Other than that, is it working?
If not we might switch to 1.0.5 until it's fixed.
version 1.1.3 is quite different.
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Tue Dec 27, 2011 6:17 pm Post subject: |
|
|
can we try to change code from:
| Code: |
$date = @mysql_result(dbquery("SELECT DATE_FORMAT(date,'%Y%m%d') FROM maillog where id='".mysql_escape_string($_GET['id'])."' AND ".$_SESSION["filter"].""),0);
|
to
| Code: | | $date = @mysql_result(dbquery("SELECT DATE_FORMAT(date,'%Y%m%d') FROM maillog where id='".mysql_escape_string($_GET['id'])."'"),0); |
?
MailWatch isworking, only this error is bug,.. i wil search for fix over the internet |
|
| Back to top |
|
simbad
Senior Member
Joined: 30 Jun 2011
Posts: 106
|
| Posted: Thu Jan 05, 2012 2:33 pm Post subject: |
|
|
Hi!
We have new version. Can you please update?
1.1.5
:: Fixed a syntax issue on rep_virus.php and quarantine_action.php
:: Add some checking to detail.php to see if the mtalog_ids are being used with postfix.
:: Permissions check on geoip_update.php were added to verify that it can download and untar the geoip Zip file.
:: Change geoip_update.php to use /tmp rather than the mailscanner temp folder.
:: Corrected permissions to only check to see if postfix has read permissions on the queue directories
:: Fixed all html for 4.01 transitional for prep to move to html5
:: Fixed page caching issue
:: Fixed an issue with the db_clean script
:: Navigation bar change
1.1.4
:: Fixed DB clean to clean the mtalog and mtalog_ids
:: Added better error reporting for the Reports page.
:: Fixed a table issue on reports.php
:: Changed geoip_update.php to curl for security and functionality |
|
| Back to top |
|
gerasimos_h
Site Admin
Joined: 09 Aug 2007
Posts: 1757
Location: Greece
|
| Posted: Thu Jan 05, 2012 9:21 pm Post subject: |
|
|
Package updated...
gerasimos_h
_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com |
|
| Back to top |
|
|
