Spam Filter ISP Support Forum

  New Posts New Posts RSS Feed - MS Access and SpamFilter Quarantine web access...
  FAQ FAQ  Forum Search   Register Register  Login Login

MS Access and SpamFilter Quarantine web access...

 Post Reply Post Reply
Author
Eran Zeitoun View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eran Zeitoun Quote  Post ReplyReply Direct Link To This Post Topic: MS Access and SpamFilter Quarantine web access...
    Posted: 26 April 2004 at 8:42pm

Morning everyone,

When trying to register a user, i keep getting page cannot be found message after clicking the register on the register.asp page, if i look on iis log file i get:

2004-04-27 00:02:17 195.68.81.10 - 195.68.81.10 8123 POST /Register.asp |6|80004005|Could_not_use_'';_file_already_in_use. 500 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)

When creating the user manually (via access) i can login and see the spam mails...

but when trying to delete a certain mail, i get the page cannot be found again,

this time iis post the following error:

2004-04-27 00:36:14 195.68.81.10 - 195.68.81.10 8123 POST /ResolveSpam.asp |86|80004005|Operation_must_use_an_updateable_query. 500 Mozilla/4.0+(compatible;+MSIE+6.0;+Windows+NT+5.0)

Any ideas?

Also some feature request, Is it possible that from the web interface a user can approve a domain or e-mail address which was blocked and that the web interface will put it on

the white list?

 

Thanks,

Eran.

 

 

 

 

 

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4105
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2004 at 1:07am

Eran,

If the browser is Internet Explorer, can you uncheck the "Tools, Internet Options, Advanced tab, Show Friendly HTTP error messages" setting? This will allow you to see the "real" error on the web page that should be more explanatory that what you see in the iis log. With that we can have more info on what is happening.

RE your end-user web whitelist, we have that high in our wish list, but we won't be allowing them to specify a domain, just a complete email address. This is because you probably will not want a user to white list the whole hotmail.com domain for example, as you'll be receiving way too much spam then.

Roberto F.
LogSat Software

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2004 at 1:04pm

Most of us have written custom interfaces for our SpamFilter administration.  If you write some asp code to read and write to the white/black lists, SpamFilter reads the updated files every 5 minutes or so.  Below is a screen shot of the application (main Menu) I wrote for our internal Administrator use.

WARNING: Image embedded by poster.

I am not sure what the Forum text box will do with this so it may not show.

Regards,

Dan S.

Back to Top
Eran Zeitoun View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eran Zeitoun Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2004 at 1:06pm

Hi Roberto,

The messages are pretty much the same as the ones on the log file like i wrote before,

if i try to register, it says:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/Register.asp, line 66

If i try to delete a message from the view (after creating a user manually), i get:

Microsoft JET Database Engine error '80004005'

Operation must use an updateable query.

/ResolveSpam.asp, line 86

 

Thanks,

Eran.

Back to Top
Eran Zeitoun View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eran Zeitoun Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2004 at 1:53pm

Well... no image could be seen on your message...

I am not an asp coder..., i am best at formatting hard-drives and forgeting loose screws

on pcs... 8-)

any chance to get a small example of how u did it, i think i will manage to figure

how to bind it to the existing code...

Thanks,

Eran.

ezeitoun (at) dalet dot com

Back to Top
Desperado View Drop Down
Senior Member
Senior Member
Avatar

Joined: 27 January 2005
Location: United States
Status: Offline
Points: 1143
Post Options Post Options   Thanks (0) Thanks(0)   Quote Desperado Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2004 at 2:03pm

Hmmm,  The image is viewable when I go back into the forum.  Security settings in ie perhaps.  Let me get back to you on the ASP code ... I am right on my way out the door.

Dan

Back to Top
LogSat View Drop Down
Admin Group
Admin Group
Avatar

Joined: 25 January 2005
Location: United States
Status: Offline
Points: 4105
Post Options Post Options   Thanks (0) Thanks(0)   Quote LogSat Quote  Post ReplyReply Direct Link To This Post Posted: 27 April 2004 at 11:17pm

Eran,

Those errors look like they're caused by your ASP pages not being able to update the Access .mdb database. Please note that IIS normally uses the IUSR account to access resources on the web server. That accout will need write access to the directory the Access database resides in. So if you're using NTFS you'll need to grant RWD (read write delete) permissions to the database directory. It's not enough to give the RWD rights to the mdb file itself because MDAC creates a .lck file as well when updating the database in the same directory.

If you are worried about security (you probably are since it looks like you tightened down security on the server - by default Microsoft allows Everyone FULL control, very frightening...) please note that this is the reason we recommend using UDL files. If you place the mdb file in a directory outside the web area and/or outside any virtual directories, the IUSR will not be able to access that directory. But your ASP code is using an UDL file for the connection, which will tell MDAC about the physical location of the file, and being outside the web are will not pose an obstacle. MDAC will be able to read the mdb file, but the IUSR will not.

Please let us know if we guessed wrong and the problem is something else so we can try to help further.

Roberto F.
LogSat Software

Back to Top
Ric Marques View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Ric Marques Quote  Post ReplyReply Direct Link To This Post Posted: 28 April 2004 at 1:24pm

Dan -

The message isn't showing up for us, but it is for you because the path to the image is on your C drive.

-Ric

Back to Top
Eran Zeitoun View Drop Down
Guest Group
Guest Group
Post Options Post Options   Thanks (0) Thanks(0)   Quote Eran Zeitoun Quote  Post ReplyReply Direct Link To This Post Posted: 01 May 2004 at 5:09pm

Well Roberto,

You were right, its access related problem... i have set the correct rights

and everything works...

 

Thanks,

Eran.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down



This page was generated in 0.207 seconds.