Print Page | Close Window

Spamfilterweb issue when moving mail server

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
Printed Date: 22 September 2018 at 5:05pm

Topic: Spamfilterweb issue when moving mail server
Posted By: morten44
Subject: Spamfilterweb issue when moving mail server
Date Posted: 24 March 2009 at 5:53pm
I have before got this resolved on -
That time i had one server with www,mail og spamfilter and mysql
I am using windows 2003 with IIS
I had it to work from -  with the help of this solution.
Now i have got a dedicated mail / spamfilter  server
The setup is as follow
behind a router i have to server
port 80 is forwarding to IP:x.x.x.10
port 25 is forwarding to IP:x.x.x.16
IP:x.x.x.10  (webserver, before also mail/spamfilter server)
IP:x.x.x.16  (new mail server/spamfilter/mysql)
Now as i have moved spamfilter and spamfilterweb to x.x.x16 i can on that server if i physically sit on it write
http://localhost/spamfilterweb - http://localhost/spamfilterweb   and it works
But here is the problem
When i sit on  my own homepc i can not access it as there is no domain name on that new server. only an internal IP address.
on the old webserver i have now redirected spamfilterweb to the new mail server in ISS
I first got a fault that it could not connect
I then edited the line in  db_connect.asp:
con.Open "file name=c:\program files\spamfilter\databases\spamfiltermysql.udl
con.Open "file name=c:\\\spamfilter\databases\spamfiltermysql.udl
I now get the logon box. YES!!!!
One problem to go.
It stills look at the mysql on the old mailserver (now only webserver where the redirection is taking place) and not on the mysql server now on the new mail server
So here is the question if you could follow so far.  lol
When you logon to the smamfilterweb (pressing "Logon")
What file should i edit to get it to validate on the mysql server on instead on the webserver where there redirection is taking place (in this case localhost)
Any idea where to adit so it authenitcate on the new mail servers mysql server?
Kind Regards

Posted By: LogSat
Date Posted: 24 March 2009 at 11:37pm

The "db_connect.asp" page in your spamfilter web directory should contain a line similar to:

     con.Open "File Name=d:\inetpub\Databases\SpamFilter.udl"

The .UDL file referenced in the db_connect.asp should be the one you need to edit (by double-clicking it) to point it to the correct database.
This is if we were able to follow your thread correctly, which I'm not 100% sure I did! So please let us know if this is not what you meant.

Roberto Franceschetti" rel="nofollow - LogSat Software" rel="nofollow - Spam Filter ISP

Posted By: morten44
Date Posted: 25 March 2009 at 2:55pm
Thanks for your answer. You where on a right path. I am impressed that you understood my explenation:
In db_connect.asp
it was pointing to the Spamfilter.udl file on the new mail server.
When i opened it the build line read:
As this was on the new mail server and the mysql was also on the new mail server, i was sure i could use localhost, but for some reason it must have interpret "localhost" as the local on the webserver and not the mail server.
I changed the line to
(webserver2 is the name of the new mail server)
and now it works fine
Thanks for pointing me in the right direction
Kind Regards

Print Page | Close Window