MS Access and SpamFilter Quarantine web access... |
Post Reply ![]() |
Author | |
Eran Zeitoun ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() 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.
|
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4105 |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
|
Desperado ![]() Senior Member ![]() ![]() Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
![]() ![]() ![]() ![]() ![]() |
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. I am not sure what the Forum text box will do with this so it may not show. Regards, Dan S. |
|
![]() |
|
Eran Zeitoun ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
|
Eran Zeitoun ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
Desperado ![]() Senior Member ![]() ![]() Joined: 27 January 2005 Location: United States Status: Offline Points: 1143 |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
LogSat ![]() Admin Group ![]() ![]() Joined: 25 January 2005 Location: United States Status: Offline Points: 4105 |
![]() ![]() ![]() ![]() ![]() |
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. |
|
![]() |
|
Ric Marques ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
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 |
|
![]() |
|
Eran Zeitoun ![]() Guest Group ![]() |
![]() ![]() ![]() ![]() ![]() |
Well Roberto, You were right, its access related problem... i have set the correct rights and everything works...
Thanks, Eran. |
|
![]() |
Post Reply ![]() |
|
Tweet
|
Forum Jump | Forum Permissions ![]() You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum |
This page was generated in 0.207 seconds.