Log inUsernamePassword
Log me on automatically each visit    
Register
Register
Log in to check your private messages
Log in to check your private messages
SMS Forum Index » Suggestions

Post new topic   Reply to topic
MailWatch for mailscanner Goto page 1, 2  Next
View previous topic :: View next topic  
Author Message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sun Sep 18, 2011 4:46 pm    Post subject: MailWatch for mailscanner Reply with quote

Any options to have this on next release? Smile

http://mailwatch.sourceforge.net/doku.php
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Sun Sep 18, 2011 6:00 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sun Sep 18, 2011 8:09 pm    Post subject: Reply with quote

yes, please!!!

Will you post a packet? until new release? Smile
Back to top
View user's profile Send private message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Fri Sep 30, 2011 2:50 pm    Post subject: Reply with quote

any news about this new packet ? Smile
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Sun Oct 02, 2011 8:56 pm    Post subject: Reply with quote

You can try the package at
http://sms.it-ccs.com/isos/SMS.Native.CD/extra/mailwatch-1.0.5-noarch-1sms.txz

Most likely it will go to extra/packages as it will alter MailScanner.conf and we don't like that.

default login is
user: admin
pass: admin

you may need to edit
/var/www/htdocs/mailscanner/luser/luser_functions.php

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Slackwan
Junior Member


Joined: 04 Jul 2010
Posts: 14

PostPosted: Mon Oct 03, 2011 6:25 am    Post subject: Reply with quote

Great Package

Thank you
Back to top
View user's profile Send private message
miguipda
Member


Joined: 14 Jul 2011
Posts: 93

PostPosted: Thu Oct 06, 2011 7:22 pm    Post subject: Reply with quote

Yes indeed, a great package.

Thx gerasimos_h and Sinbad

_________________
Miguipda Wink
Back to top
View user's profile Send private message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sat Dec 24, 2011 7:00 pm    Post subject: Reply with quote

Thanks for upgrade!! Smile

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
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Sat Dec 24, 2011 8:31 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Sun Dec 25, 2011 8:06 pm    Post subject: Reply with quote

chmod on this folder is postfix. any other sugestion?

Can you please check script? Smile
Back to top
View user's profile Send private message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Mon Dec 26, 2011 12:47 pm    Post subject: Reply with quote

today i will try wit fresh install Smile
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Mon Dec 26, 2011 1:12 pm    Post subject: Reply with quote

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
View user's profile Send private message Visit poster's website
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Tue Dec 27, 2011 6:17 pm    Post subject: Reply with quote

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 Smile
Back to top
View user's profile Send private message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Thu Jan 05, 2012 2:33 pm    Post subject: Reply with quote

Hi!

We have new version. Can you please update? Smile


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
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Thu Jan 05, 2012 9:21 pm    Post subject: Reply with quote

Package updated...

gerasimos_h

_________________
Superb! Mini Server Project Manager
http://sms.it-ccs.com
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » Suggestions All times are GMT + 2 Hours
Goto page 1, 2  Next
Page 1 of 2

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum

SMS - Superb! Mini Server Project © 2016
Powered by phpBB © 2001, 2002 phpBB Group
iCGstation v1.0 Template By Ray © 2003, 2004 iOptional