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 » SMS User Support

Post new topic   Reply to topic
MailWatch & GEO problem
View previous topic :: View next topic  
Author Message
simbad
Senior Member


Joined: 30 Jun 2011
Posts: 106

PostPosted: Tue Oct 11, 2011 4:41 pm    Post subject: MailWatch & GEO problem Reply with quote

Hi!

When i try to update GeoIP Database from MaxMind (mailscanner), i recive this error:

Downloading file, please wait....
Unzip failed:
Error: Archive: temp/GeoIPCountryCSV.zip

I have full sms instalation, and i have installed gzip.

Any suggestion? Embarassed

Thanks Admin to bring this packet to sms!!!
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Tue Oct 11, 2011 5:28 pm    Post subject: Reply with quote

The problem is on maxmind site, when you try to download the file stops or not downloading at all.
http://geolite.maxmind.com/download/geoip/database/GeoIPCountryCSV.zip

From MailWatch stops at 600k while the file is 2.3MB.


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 Oct 11, 2011 5:44 pm    Post subject: Reply with quote

can i do manual?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Tue Oct 11, 2011 6:18 pm    Post subject: Reply with quote

If you can download it of course...
just edit /var/www/htdocs/mailscanner/geoip_update.php
and change $LINKGEO=
with your file.

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 Nov 27, 2011 7:28 pm    Post subject: Reply with quote

I have setup U&P for MySQL & MailScanner, and i can use mailscanner.

Do i need add sql prem.?

Downloading file, please wait....
Error executing query:

Access denied for user 'mailwatch'@'localhost' (using password: YES)

SQL:
LOAD DATA INFILE '/var/www/htdocs/mailscanner/temp/GeoIPCountryWhois.csv' INTO TABLE geoip_country FIELDS TERMINATED BY ',' ENCLOSED BY '"'
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Sun Nov 27, 2011 8:10 pm    Post subject: Reply with quote

Have you set mailwatch user's password?
That's the one you create during installation, of mailwatch package.

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 Nov 29, 2011 11:36 pm    Post subject: mail scanner problem procesing mail Reply with quote

I have resetup mysql DB,.. now i have this problem:

After setup mail, i have this mail log problem:

Nov 29 23:30:10 xenya spamd[2255]: spamd: processing message <CAAXOkgiqJtFSn6CWC0KQYcqDYFkwvEhvvG4djCJDo3HfMuBeCg@mail.gmail.com> for nobody:1003
Nov 29 23:30:19 xenya spamd[2255]: auto-whitelist: open of auto-whitelist file failed: locker: safe_lock: cannot create tmp lockfile /var/spool/spamassassin/auto-whitelist.lock.xxxx.xxxxx.xxx.2255 for /var/spool/spamassassin/auto-whitelist.lock: Permission denied
Nov 29 23:30:19 xenya spamd[2255]: plugin: eval failed: bayes: (in learn) locker: safe_lock: cannot create tmp lockfile /.spamassassin/bayes.lock.xxx.xxxxx.xxx.2255 for /.spamassassin/bayes.lock: No such file or directory

Do i need create new folder or chmod?
Back to top
View user's profile Send private message
gerasimos_h
Site Admin


Joined: 09 Aug 2007
Posts: 1752
Location: Greece

PostPosted: Wed Nov 30, 2011 9:05 am    Post subject: Reply with quote

What version of SMS you are using?
Quote:
<CAAXOkgiqJtFSn6CWC0KQYcqDYFkwvEhvvG4djCJDo3HfMuBeCg@mail.gmail.com> for nobody:1003


/var/spool/spamassassin owned by spamduser (uid 1003). Have you removed spamduser?
What's the permissions of /var/spool/spamassassin?

If you setup user nobody, you can try to "chmod" /var/spool/spamassassin to user nobody.

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: Wed Nov 30, 2011 10:24 pm    Post subject: Reply with quote

i have last v. sms and it is fresh install.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    SMS Forum Index » SMS User Support All times are GMT + 2 Hours
Page 1 of 1

 
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