This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
31
E-Mail - Ask For Help / Receive e-mail - processing Bounce Messages
« on: May 30, 2014, 08:12:59 AM »
I think it was a change in version of NT, but the following code no longer gets the correct email address from the message.
The fields do not seem to deliver any values anymore....
Does anyone have an example of processing bounce messages?
Thanks.
Paul
The fields do not seem to deliver any values anymore....
Does anyone have an example of processing bounce messages?
Thanks.
Paul
Code: [Select]
SaveMessage routine
! Save the message
rcvd:Subject = clip(GetMsg.Subject)
rcvd:account_address = GetMsg.user
rcvd:DeliveryReceiptTo = clip(GetMsg.DeliveryReceiptTo)
rcvd:DSOriginalRecipient = clip(GetMsg.DeliveryStatusOriginalRecipient)
rcvd:DSFinalRecipient = clip(GetMsg.DeliveryStatusFinalRecipient)
rcvd:DSAction = clip(GetMsg.DeliveryStatusAction)
rcvd:DSStatus = clip(GetMsg.DeliveryStatusStatus)
rcvd:DSRemoteMTA = clip(GetMsg.DeliveryStatusRemoteMTA)
rcvd:DSDiagCode = clip(GetMsg.DeliveryStatusDiagnosticCode)
rcvd:DSLastAttemptDate = clip(GetMsg.DeliveryStatusLastAttemptDate)
rcvd:MessageID = clip(GetMsg.MessageID)
rcvd:WholeMsg = clip(GetMsg.WholeMessage[1:GetMsg.WholeMessageLen])
rcvd:ToAddress = clip(GetMsg.ToList)
rcvd:FromAddress = clip(GetMsg.From)
TempDateStr = GetMsg.sentdate
TempDateStr = sub(TempDateStr,6,11)
TempTimeStr = GetMsg.sentdate
TempTimeStr = sub(TempTimeStr,len(TempTimeStr)-18,8)
rcvd:rcvDate_DATE = deformat(TempDateStr,@D8) ! today()
rcvd:rcvDate_TIME = deformat(TempTimeStr,@T4)
Access:RcvdeMail.Insert()
32
Web Server - Ask For Help / Re: Paypal IPN SSL Problem after Upgrading 6 to 7
« on: April 02, 2014, 01:33:37 PM »
Appreciate the encouragement 
Mine was running for years - literally. Had to add functionality and ended up with this problem w/ Paypal - did not change that procedure at all.....
Had to "change the location" of my certificate, but that took a few minutes and was working fine.
When Paypal tries to post the IPN, I get NADA in the log. No https activity at all.
So, my though was perhaps its an issue with encryption.
Does anyone know, if (d)encryption fails is anything posted to the log on screen?

Mine was running for years - literally. Had to add functionality and ended up with this problem w/ Paypal - did not change that procedure at all.....
Had to "change the location" of my certificate, but that took a few minutes and was working fine.
When Paypal tries to post the IPN, I get NADA in the log. No https activity at all.
So, my though was perhaps its an issue with encryption.
Does anyone know, if (d)encryption fails is anything posted to the log on screen?
33
Web Server - Ask For Help / Paypal IPN SSL Problem after Upgrading 6 to 7
« on: April 01, 2014, 07:59:10 AM »
For certain reasons I can't go to 8 right now...
I upgraded a webserver from 6 to 7. Of course I ran into the SSL changed, etc. and made the appropriate changes....
I can connect to the site with any web browser and get a valid certificate, etc.
The problem is Paypal says they can't "establish ssl"
I can post to my IPN page. I can take their posting and it works.
But they continue to say they can't establish ssl.
I don't think it's my firewall (I can reach the page from outside).....
I ran SSL scan and it reports:
Accepted SSLv3 256 bits AES256-SHA
Accepted SSLv3 128 bits AES128-SHA
Accepted SSLv3 168 bits DES-CBC3-SHA
Thoughts?
I upgraded a webserver from 6 to 7. Of course I ran into the SSL changed, etc. and made the appropriate changes....
I can connect to the site with any web browser and get a valid certificate, etc.
The problem is Paypal says they can't "establish ssl"
I can post to my IPN page. I can take their posting and it works.
But they continue to say they can't establish ssl.
I don't think it's my firewall (I can reach the page from outside).....
I ran SSL scan and it reports:
Accepted SSLv3 256 bits AES256-SHA
Accepted SSLv3 128 bits AES128-SHA
Accepted SSLv3 168 bits DES-CBC3-SHA
Thoughts?
34
Web Server - Share Knowledge / Re: Multi-company solution using HostHeader
« on: February 20, 2014, 10:39:09 AM »
Additional Notes:
DNS entries "*.app" and "app" are DIFFERENT.
So, "app.mysite.com" can point to a different place.
In practice you may just point to the same place and when you validate the HostHeader you find it not a valid entry and redirect to a different site...
SSL - I believe - but haven't tested it yet, that a WildCard Certificate WILL work.
You MAY need a wildcard that says "*.app.mysite.com" instead of "*.mysite.com"
DNS entries "*.app" and "app" are DIFFERENT.
So, "app.mysite.com" can point to a different place.
In practice you may just point to the same place and when you validate the HostHeader you find it not a valid entry and redirect to a different site...
SSL - I believe - but haven't tested it yet, that a WildCard Certificate WILL work.
You MAY need a wildcard that says "*.app.mysite.com" instead of "*.mysite.com"
35
Web Server - Share Knowledge / Multi-company solution using HostHeader
« on: February 20, 2014, 10:13:52 AM »
In the Nettalk webinar #7 there was a discussion about how to handle multiple companies using the HostHeader property.
One part of the discussion was the adding of DNS entries to handle different companies.
Example:
C1.mysite.com
C2.mysite.com
You'd need to add CNAME entries C1, C2, etc.
You could get the HostHeader and distinguish between the "companies". The downside is that you need to create A records in the DNS for each company.. or do you?
A better way is to use a DNS Wildcard....
What you can do is add a DNS A entry that says something like:
"*.app" and point it to the correct IP....
So, the User would type "C1.app.mysite.com" and be directed to that IP.
They could type "C2.app.mysite.com" and go to the same IP.
No matter what they type in the URL before ".app.mysite.com", DNS will send them to the correct place.
On your server you would then receive a HostHeader of "C1.app.mysite.com" or whatever they had typed.
1 DNS entry - unlimited "companies"
One part of the discussion was the adding of DNS entries to handle different companies.
Example:
C1.mysite.com
C2.mysite.com
You'd need to add CNAME entries C1, C2, etc.
You could get the HostHeader and distinguish between the "companies". The downside is that you need to create A records in the DNS for each company.. or do you?
A better way is to use a DNS Wildcard....
What you can do is add a DNS A entry that says something like:
"*.app" and point it to the correct IP....
So, the User would type "C1.app.mysite.com" and be directed to that IP.
They could type "C2.app.mysite.com" and go to the same IP.
No matter what they type in the URL before ".app.mysite.com", DNS will send them to the correct place.
On your server you would then receive a HostHeader of "C1.app.mysite.com" or whatever they had typed.
1 DNS entry - unlimited "companies"
36
Web Server - Ask For Help / LoginForm vs SecwinWebLoginForm
« on: March 10, 2012, 01:02:28 AM »
Are both of these procedures needed? 2 login forms?
This was a wizarded app...
This was a wizarded app...
37
Web Server - Ask For Help / Re: Database Design Issues - One NT Server, Multiple Entities
« on: February 08, 2012, 11:35:21 AM »
Kevin,
You said that using an EntityID doesn't scale well.
I'm just wondering how the big boys do it? I thought they all ran everything into a large SQL database.
If I used the EntityID method it would definitely be in SQL.
My next thought is if I use separate "databases"
folders/paths for TPS files or
databases in SQL
which would have a faster response to the user?
has anyone done this comparison?
You said that using an EntityID doesn't scale well.
I'm just wondering how the big boys do it? I thought they all ran everything into a large SQL database.
If I used the EntityID method it would definitely be in SQL.
My next thought is if I use separate "databases"
folders/paths for TPS files or
databases in SQL
which would have a faster response to the user?
has anyone done this comparison?
38
Web Server - Ask For Help / Re: Database Design Issues - One NT Server, Multiple Entities
« on: February 08, 2012, 11:31:35 AM »
so it's just a matter of issuing a SetPath in the embed?
No buffers getting mixed up?
tables all need to be threaded I assume?
No buffers getting mixed up?

tables all need to be threaded I assume?
39
Web Server - Ask For Help / Database Design Issues - One NT Server, Multiple Entities
« on: February 08, 2012, 12:54:34 AM »
I'm getting a lot of pressure from users of one of my products to get a web version going. Basically 90% of my inqueries are for a web version.
So, initially I was thinking of having a NTS login page where once logged in it would set some session variables for company ID, and Database Path. This would point their data access to a separate set of TPS files.
Alternatively, restructure the database with an EntityID in each table and filter data using this EntityID.
In this case probably go with a SQL backend.
My concern is how will NTS behave when I'm changing the path/filename of tables constantly. Every page load, etc.
Thoughts, experience, suggestions?
Thanks,
Paul
So, initially I was thinking of having a NTS login page where once logged in it would set some session variables for company ID, and Database Path. This would point their data access to a separate set of TPS files.
Alternatively, restructure the database with an EntityID in each table and filter data using this EntityID.
In this case probably go with a SQL backend.
My concern is how will NTS behave when I'm changing the path/filename of tables constantly. Every page load, etc.
Thoughts, experience, suggestions?
Thanks,
Paul