Spam Filter ISP Forums : register.asp not recording emails in SQL2

register.asp not recording emails in SQL2 : Barry, In the ASP pages Desperado...

Wed, 02 Mar 2005 16:51:06 +0000

Author: LogSat
Subject: 5083
Posted: 02 March 2005 at 4:51pm

Barry,

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

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.

register.asp not recording emails in SQL2 : Barry, The server ID is in both...

Wed, 02 Mar 2005 16:02:22 +0000

Author: Desperado
Subject: 5083
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

register.asp not recording emails in SQL2 : '****** MAKE SURE THE SERVER...

Wed, 02 Mar 2005 15:21:32 +0000

Author: Guests
Subject: 5083
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

register.asp not recording emails in SQL2 : Barry, Without seeing your...

Wed, 02 Mar 2005 13:40:55 +0000

Author: Desperado
Subject: 5083
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 <support@yourdomain.com>"
rs("EMailFrom") = "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,

register.asp not recording emails in SQL2 : I recently converted the access...

Wed, 02 Mar 2005 10:10:20 +0000

Author: bearb319
Subject: 5083
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