Spam Filter ISP Support - register.asp not recording emails in SQL2

register.asp not recording emails in SQL2

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=5083
Printed Date: 12 March 2025 at 7:56am

Topic: register.asp not recording emails in SQL2

Posted By: bearb319
Subject: register.asp not recording emails in SQL2
Date Posted: 02 March 2005 at 10:10am

I recently converted the access DB to sql2000. Now it appears that the register.asp page no longers "registers" the email account and adds it to the tblogins table. Could this be a permissions problem?

I am not a asp wizard or a sql master so any pointers will be most appreciated.

I'm also interested in using the code updates that have been posted here but apparently, I'm not setting something up correctly as they do not work. I went back to the dafault pages.

Cheers and TIA for any assistance,

Barry

Replies:

Posted By: Desperado
Date Posted: 02 March 2005 at 1:40pm

Barry,

Without seeing your code, I am not sure what is going on BUT ... can you compare your Register.asp with the following section?

Message = Message & "." & vbCRLF
SQL = "SELECT * FROM tblMsgs WHERE 0 = 1"
rs.Open(SQL)
rs.AddNew
rs("Msg") = Message
rs.Update
MsgID = rs("MsgID")
rs.Close
SQL="SELECT * FROM tblQuarantine WHERE 0 = 1"
rs.Open(SQL)
rs.AddNew
' rs("EMailFrom") = "Administrator < mailto:support@yourdomain.com - support@yourdomain.com >"
rs("EMailFrom") = " mailto:support@yourdomain.comt - support@yourdomain.comt "
rs("EMailTo") = EMail
rs("Subject") = "Your quarantine area password"
rs("MsgID") = MsgID
rs("MsgDate") = MessageDate
rs("Expire") = 0
rs("Deliver") = 1

'****** MAKE SURE THE SERVER ID IS CORRECT ******
rs("ServerID") = 5
'******************************
rs("RejectDetails") = ""
rs("RejectID") = 0
rs.Update
rs.Close
Set rs = Nothing

Regards,

-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Posted By: Guests
Date Posted: 02 March 2005 at 3:21pm

'****** MAKE SURE THE SERVER ID IS CORRECT ******

How would I know whhat the server ID is? This is installed ont he same box ( spamfilter and sql2000). The register.asp is the same file as what comes int he sample files from logsat.

Thanks!!!

Barry

Posted By: Desperado
Date Posted: 02 March 2005 at 4:02pm

Barry,

The server ID is in both the SQL Server "tblServers" and in the SpamFilter.ini entry: tblServersServerID=

AND ... look carefully at my sql query. If it is differant than the one you are using, I made the changes to make it work. There is a thread somewhere on the Forum about this issue but as I said, see if there are differances in the email address format and also the exoire, rejectID and deliver settings.

Dan

-------------
The Desperado
Dan Seligmann.
Work: http://www.mags.net
Personal: http://www.desperado.com

Posted By: LogSat
Date Posted: 02 March 2005 at 4:51pm

Barry,

In the ASP pages Desperado is correct in his suggestion to compare the register.asp page with the section he posted. More specifically, can you

rs("EMailFrom") = "System Administrator <>"

to something like

rs("EMailFrom") = "someemail@yourdomain.com"

For the ServerID you can use "0".

On another note, have yo uby any chance changed the computer's name? That would require changing the ServerID in the database.

-------------
Roberto Franceschetti

http://www.logsat.com" rel="nofollow - LogSat Software

http://www.logsat.com/sfi-spam-filter.asp" rel="nofollow - Spam Filter ISP