Print Page | Close Window

Attempting to get web site working on iis 7

Printed From: LogSat Software
Category: Spam Filter ISP
Forum Name: Spam Filter ISP Support
Forum Description: General support for Spam Filter ISP
URL: https://www.logsat.com/spamfilter/forums/forum_posts.asp?TID=6939
Printed Date: 27 December 2024 at 9:09am


Topic: Attempting to get web site working on iis 7
Posted By: RBarrow
Subject: Attempting to get web site working on iis 7
Date Posted: 22 April 2011 at 6:42pm
I am in the process of moving our old spamfilter server into the graveyard...and moving spamfilter to 2008 R2 VM.
 
I have installed and have the spamfilter itself working but I am unable to get the web interface to cooperate.
 
I have installed ASP, modified the UDL (test connection passes), but I keep getting cryptic http 500 errors.
 
I just need to get the old interface up and going while kicking the tires on some of the new interfaces.
 
HELP!
 
Tnx...Roy


Replies:
Posted By: AndrewD
Date Posted: 25 April 2011 at 12:47am
Unfortunatly http 500 is a Generic error code that basically means that something went wrong at the serverside. You would need to analyze your webserver logs for more information. It may also help to turn OFF "show friendly HTTP error messages" in your IE browser. This may give you more info on the error including the line number that had the error.
 
If you can give us a URL to the installation then we may be able to see the error's and give more advise. But in this case the error code itself is not enough information to go on.


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: RBarrow
Date Posted: 25 April 2011 at 8:33am
Andrew...
 
I figured it out...I had issues with the connection string.

Posted By: ktrunkett
Date Posted: 02 May 2012 at 2:27pm
How did you get this working?

Posted By: AndrewD
Date Posted: 02 May 2012 at 9:18pm
He fixed his connection string.
you are better of telling us the problem that you are having and what steps you have tried.
 
if what you have is public facing then as per above if you give me the url i can look at the site and see what errors it is throwing.
 
cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: ktrunkett
Date Posted: 02 May 2012 at 9:34pm
was having the same problems as he(she) was.  500 etc.

basically getting a 800a8e7a error. so i tried different application settings etc.  change to 32 bit on the application and that just shuts down and gives a 503 error.

My Spamfiliteraccess.udl file looks like this:

[oledb]
; Everything after this line is an OLE DB initstring
Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files (x86)\SpamFilter\Database\SpamFilter.mdb;Persist Security Info=False

Posted By: AndrewD
Date Posted: 02 May 2012 at 10:27pm
Okay 800a8e7a indicates a provider error.
you need to fix, test, and verify the udl before it will work.
 
see http://blogs.msdn.com/b/farukcelik/archive/2007/12/31/basics-first-udl-test.aspx" rel="nofollow - http://blogs.msdn.com/b/farukcelik/archive/2007/12/31/basics-first-udl-test.aspx
 
Cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: ktrunkett
Date Posted: 02 May 2012 at 10:57pm
my server does not have a sql server running on it.  neither does my 2003 machine and it works.

the blog you referenced i believe is refencing sql server 2000 or 2005. 


Posted By: ktrunkett
Date Posted: 02 May 2012 at 10:58pm
well, i guess my 2003 box had Blackberry server on it which loaded sql server


Posted By: AndrewD
Date Posted: 03 May 2012 at 12:26am
Doesnt matter that you dont have SQL the connector to an access database works in much the same way and can be tested in the exact same way.
 
Cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: ktrunkett
Date Posted: 03 May 2012 at 12:29am
I know the database connected fine through Spamfilter.  the test where you name a file test.udl did not work

Posted By: ktrunkett
Date Posted: 03 May 2012 at 12:33am
what application pool do you associate with the Spamfilter web on server 2008?

Posted By: ktrunkett
Date Posted: 03 May 2012 at 12:35am
and my udl file is:
provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Program Files (x86)\SpamFilter\Database\SpamFilter.mdb;Persist Security Info=False

which the "provider" is not found
what should i change that too?

Posted By: AndrewD
Date Posted: 03 May 2012 at 1:13am
I created its own App pool. as a rule i dont like sharing app pools between sites.
 
Cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: ktrunkett
Date Posted: 03 May 2012 at 1:13am
got it figured out

Posted By: ktrunkett
Date Posted: 03 May 2012 at 1:16am
I changed my provider to
Provider=Microsoft.ACE.OLEDB.12.0
and it works.

Posted By: AndrewD
Date Posted: 03 May 2012 at 1:21am
cool it is always better if you work it out as you will have learnt a little about udl files along the way ;)
 
Cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: ktrunkett
Date Posted: 03 May 2012 at 1:25am
the problem is the old jet stuff that doesn't work with 2008 server.  and i didn't quite figure out the "Provider" change (or where to change it) until I read more and more and found the accessdatabase engine update

Posted By: ktrunkett
Date Posted: 03 May 2012 at 12:08pm
Crap.  I just realized that my change works for the web page but then it Breaks Spamfilterisp.  it now doesn't recognize the "NEW" provider.

Roberto, care to chime in?

Posted By: AndrewD
Date Posted: 04 May 2012 at 9:28am
SpamfilterISP doesnt use the udl file.
What do you mean "it now doesn't recognize the "NEW" provider"
 
what is happening?
is the website not working or is the console reporting an issue?
 
have you run through the "Database" tab steps to check your connectivity?
 
Cheers


-------------
Spamfilter web interface. www.tyrexpg.com.au

See http://www.logsat.com/SpamFilter/Forums/forum_posts.asp?TID=6883

Posted By: ktrunkett
Date Posted: 04 May 2012 at 10:23am
Unfortuneately Spamfilter does use the UDL file.  and to your point, yes, i have used the database steps, and that is, of course here you select the UDL file to read.    The error is Provider not found when using a PROVIDER that Server 2008 Recognizes for the Web based part of the equation.
 
Do you have Server 2008 R2 with Spamfilter (access database) running and the Web Quarantine interface working? 


Print Page | Close Window