date:20041101

My friend in Austin is looking for someone local to help him with a relative
small project that could be done with Access or MySQL and JSP or ASP it
seems to me.

You can contact him at
Ric Sternberg
AiM Productions
830-825-0133
www.aimproductions.com


Ric Sternberg <[EMAIL PROTECTED]>



-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com


"When you are born, you cry and those who love you rejoice.  And if you
live your life as you should, when you die, you rejoice and those who
love you cry."


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

Title: Re: Witango-Talk: WiTango & Email



 

  I did find some on a client's machine. However, 
  after running Ad Aware on the server, I found another 53 objects!
   
  Thanks for all your help.
  One other thought:The server has been compromised. 
  Has some sort of spamming virus on it. On 11/1/04 12:31 PM, 
  "Roland Dumas" <[EMAIL PROTECTED]> 
  wrote:
  I understand what is going on, but this 
SHOULDNT, unless youve left a door open.I suspect you have 
authentication off for your whole domain, rather than turn it off for a 
handful of trusted IPsWhen they send something through 
[EMAIL PROTECTED] and are sending it from an outside address, they should 
be challenged for user/pass, unless youve left an unnecessarily wide hole 
open by allowing relaying from anyone at your_domain.com. Your mail 
server is going to see the originating IP as 127.0.0.1 ONLY for clients 
actually on the same machine, namely witango. For every other message, it 
will see the senders IP as the IP of that originating client, not the 
domain that it claims to be from. On 11/1/04 12:19 PM, "Rick 
Sanders" <[EMAIL PROTECTED]> wrote:

  Hi Roland,  Thanks for your 
reply. Unfortunately, it's a  little more complicated than that. 
 The people relaying off the server, are using  the 
email address of the domain hosted on the server So, the 
spammers are using [EMAIL PROTECTED], and it's going through  without 
authentication because 127.0.0.1 is in the privileged IP 
range.The IP of 
that message is NOT 127.0.0.1, but the IP of the originating client. 
TO 
UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf-Roland 
  DumasRoberts Information Services310 W. Bellevue AvenueSan Mateo 
  CA 94402650-347-1373415-412-9300 
  (cell)[EMAIL PROTECTED]SMS: http://new.servqual.com/html/sms.tml
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

Title: Re: Witango-Talk: WiTango & Email



 

  Nope, there's no door left open, however it's 
  all happening on port 25. So, I redirected to port 26, same thing.
  127.0.0.1 isn't the problem anymore. I found 
  some spyware, and a trojan on a client machine. Arg!
  I excluded the IP's from the local clients one 
  by one and found the culprit!
  I understand what is going on, but this SHOULDNT, 
  unless youve left a door open.I suspect you have authentication off 
  for your whole domain, rather than turn it off for a handful of trusted 
  IPsWhen they send something through [EMAIL PROTECTED] and are sending it 
  from an outside address, they should be challenged for user/pass, unless 
  youve left an unnecessarily wide hole open by allowing relaying from anyone 
  at your_domain.com. Your mail server is going to see the originating 
  IP as 127.0.0.1 ONLY for clients actually on the same machine, namely witango. 
  For every other message, it will see the senders IP as the IP of that 
  originating client, not the domain that it claims to be from. On 
  11/1/04 12:19 PM, "Rick Sanders" <[EMAIL PROTECTED]> 
  wrote:
  
Hi Roland,  Thanks for your 
  reply. Unfortunately, it's a  little more complicated than that. 
   The people relaying off the server, are using  the 
  email address of the domain hosted on the server So, the 
  spammers are using [EMAIL PROTECTED], and it's going through  without 
  authentication because 127.0.0.1 is in the privileged IP 
  range.The IP of 
  that message is NOT 127.0.0.1, but the IP of the originating client. 
  
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

That's how it was set up. Everyone has to send authentication to send out 
email. Or they're denied.


By the way, if your mail server forces authentication for everybody that
tires to send mail through it, a solution that I've used in the past has
been to is an intermediary mail server (typically on the same machine)
that accepts connection from only localhost, that is setup to relay all
it's mail to the real mail server, and that intermediate mail server has
the authentication information to make the connection to the "real" mail
server.
If the real mail server and the web server are already on the same
machine perhaps you could accomplish this by running another smtp server
for just witango to talk to on a different port (8025).
I had to do something very similar to this when we installed an Intranet
appliation for a client at their location running on witango, and the
mail actions needed to send mail though the company mail server (which
is still hosted by us) We weren't about to trust any machines outside of
our own subnet, so instead we configured the witango box to SMTP through
itself, and that IIS SMTP server was setup to send all it's mail through
our server by authenticating.
/John
Rick Sanders wrote:
Hi Roland,
Thanks for your reply. Unfortunately, it's a little more
complicated than that.
The people relaying off the server, are using the email address of
the domain hosted on the server.
So, the spammers are using [EMAIL PROTECTED]
, and it's going through without
authentication because 127.0.0.1 is in the privileged IP range.
Of course, turning off the 127.0.0.1 stops un-authorized relaying,
but also stops the Tango server from sending auto email. Unless
the Tango server can send a username & password for authentication.
We've blocked a huge list of IP's, but they're spoofing IP's off
other Comcast & AT&T DSL customers.
Fun, fun, fun!
Hold on. Something’s amiss in your mail server setup.
IF you have relay enabled from 127.0.0.1 AND you have a mail
server on the same machine AND you have authentication turned on
for outside IP addresses, the mail server should still be
requiring authentication from outside people trying to use you as
an open relay.
I have that setup (webstar) and can see the steady stream of
attempted relays being blocked.
You can turn authentication off for your internal and trusted
networks, including 127.0.0.1 and the IP address of your witango
machine
Authentication required for everyone else
Use your firewall/router not not let in IP spoofers using 127. Or
your server’s IP address
Then, when the spammer is sending messages trying to exploit the
open relay, the mail server will reject because the IP address is
the originating machine or server, not your own. If they are
trying to spoof your Ip address, the mail won’t get in.
Check your detailed smtp log and you’ll see where your hole is.

On 11/1/04 10:34 AM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:
I have a client who's having email relay problems.
Basically, people are relaying off his email server. He's
turned off relay for local sender addresses, and enabled SMTP
authentication.
However, he's had to let his local machine IP 127.0.0.1 for
access to the mail server, because WiTango needs to send
automatic email. However, because of this, anyone can still
relay mail off the server.
The question:
Is it possible for the WiTango server to send a username &
password to the mail server for outbound authentication? I
know that WiTango can use a specific email address, but can it
send a Username & password for authentication?
The server is version 2000 with SP2.
Thanks in advance,
Rick Sanders


TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf

-
Roland Dumas
Roberts Information Services
310 W. Bellevue Avenue
San Mateo CA 94402
650-347-1373
415-412-9300 (cell)
[EMAIL PROTECTED]
SMS: http://new.servqual.com/html/sms.tml

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

Hey John,
Yep, that's what seems to be happening.
However, after checking the logs, the reason why other users at the same 
domain were getting email from [EMAIL PROTECTED] was because relay is on for 
mail sent within the same domain since both the sender and receiver are 
local.

So, unauthorized email isn't getting out at least! After I re-configured the 
SMTP.


If the mail is going to an account on the local machine, then the
spammers aren't relaying at all... They are simply using a generic
account name at the local domain as the return address.
The definition of mail relaying means that the mail would be relayed to
another server.
Typically relay restrictions are not enforced when the recepient is a
local account, because the mail isn't being relayed, it's being
delivered to it's final destination.
/John
Rick Sanders wrote:
Hi Roland,
Thanks for your reply. Unfortunately, it's a little more
complicated than that.
The people relaying off the server, are using the email address of
the domain hosted on the server.
So, the spammers are using [EMAIL PROTECTED]
, and it's going through without
authentication because 127.0.0.1 is in the privileged IP range.
Of course, turning off the 127.0.0.1 stops un-authorized relaying,
but also stops the Tango server from sending auto email. Unless
the Tango server can send a username & password for authentication.
We've blocked a huge list of IP's, but they're spoofing IP's off
other Comcast & AT&T DSL customers.
Fun, fun, fun!
Hold on. Something’s amiss in your mail server setup.
IF you have relay enabled from 127.0.0.1 AND you have a mail
server on the same machine AND you have authentication turned on
for outside IP addresses, the mail server should still be
requiring authentication from outside people trying to use you as
an open relay.
I have that setup (webstar) and can see the steady stream of
attempted relays being blocked.
You can turn authentication off for your internal and trusted
networks, including 127.0.0.1 and the IP address of your witango
machine
Authentication required for everyone else
Use your firewall/router not not let in IP spoofers using 127. Or
your server’s IP address
Then, when the spammer is sending messages trying to exploit the
open relay, the mail server will reject because the IP address is
the originating machine or server, not your own. If they are
trying to spoof your Ip address, the mail won’t get in.
Check your detailed smtp log and you’ll see where your hole is.

On 11/1/04 10:34 AM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:
I have a client who's having email relay problems.
Basically, people are relaying off his email server. He's
turned off relay for local sender addresses, and enabled SMTP
authentication.
However, he's had to let his local machine IP 127.0.0.1 for
access to the mail server, because WiTango needs to send
automatic email. However, because of this, anyone can still
relay mail off the server.
The question:
Is it possible for the WiTango server to send a username &
password to the mail server for outbound authentication? I
know that WiTango can use a specific email address, but can it
send a Username & password for authentication?
The server is version 2000 with SP2.
Thanks in advance,
Rick Sanders


TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf

-
Roland Dumas
Roberts Information Services
310 W. Bellevue Avenue
San Mateo CA 94402
650-347-1373
415-412-9300 (cell)
[EMAIL PROTECTED]
SMS: http://new.servqual.com/html/sms.tml

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

2004-11-01 Thread Roland Dumas

Title: Re: Witango-Talk: WiTango & Email

One other thought:
The server has been compromised. Has some sort of spamming virus on it.

On 11/1/04 12:31 PM, "Roland Dumas" <[EMAIL PROTECTED]> wrote:

I understand what is going on, but this SHOULDN’T, unless you’ve left a door open.

I suspect you have authentication off for your whole domain, rather than turn it off for a handful of trusted IPs

When they send something through [EMAIL PROTECTED] and are sending it from an outside address, they should be challenged for user/pass, unless you’ve left an unnecessarily wide hole open by allowing relaying from anyone at your_domain.com.

Your mail server is going to see the originating IP as 127.0.0.1 ONLY for clients actually on the same machine, namely witango. For every other message, it will see the sender’s IP as the IP of that originating client, not the domain that it claims to be from.

On 11/1/04 12:19 PM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:

Hi Roland,
Thanks for your reply. Unfortunately, it's a little more complicated than that.
The people relaying off the server, are using the email address of the domain hosted on the server
So, the spammers are using [EMAIL PROTECTED], and it's going through without authentication because 127.0.0.1 is in the privileged IP range.

The IP of that message is NOT 127.0.0.1, but the IP of the originating client.

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

-
Roland Dumas
Roberts Information Services
310 W. Bellevue Avenue
San Mateo CA 94402
650-347-1373
415-412-9300 (cell)
[EMAIL PROTECTED]
SMS: http://new.servqual.com/html/sms.tml

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

2004-11-01 Thread John McGowan

By the way, if your mail server forces authentication for everybody that 
tires to send mail through it, a solution that I've used in the past has 
been to is an intermediary mail server (typically on the same machine) 
that accepts connection from only localhost, that is setup to relay all 
it's mail to the real mail server, and that intermediate mail server has 
the authentication information to make the connection to the "real" mail 
server.

If the real mail server and the web server are already on the same 
machine perhaps you could accomplish this by running another smtp server 
for just witango to talk to on a different port (8025).

I had to do something very similar to this when we installed an Intranet 
appliation for a client at their location running on witango, and the 
mail actions needed to send mail though the company mail server (which 
is still hosted by us) We weren't about to trust any machines outside of 
our own subnet, so instead we configured the witango box to SMTP through 
itself, and that IIS SMTP server was setup to send all it's mail through 
our server by authenticating.

/John
Rick Sanders wrote:
Hi Roland,
Thanks for your reply. Unfortunately, it's a little more
complicated than that.
The people relaying off the server, are using the email address of
the domain hosted on the server.
So, the spammers are using [EMAIL PROTECTED]
, and it's going through without
authentication because 127.0.0.1 is in the privileged IP range.
Of course, turning off the 127.0.0.1 stops un-authorized relaying,
but also stops the Tango server from sending auto email. Unless
the Tango server can send a username & password for authentication.
We've blocked a huge list of IP's, but they're spoofing IP's off
other Comcast & AT&T DSL customers.
Fun, fun, fun!
Hold on. Something’s amiss in your mail server setup.
IF you have relay enabled from 127.0.0.1 AND you have a mail
server on the same machine AND you have authentication turned on
for outside IP addresses, the mail server should still be
requiring authentication from outside people trying to use you as
an open relay.
I have that setup (webstar) and can see the steady stream of
attempted relays being blocked.
You can turn authentication off for your internal and trusted
networks, including 127.0.0.1 and the IP address of your witango
machine
Authentication required for everyone else
Use your firewall/router not not let in IP spoofers using 127. Or
your server’s IP address
Then, when the spammer is sending messages trying to exploit the
open relay, the mail server will reject because the IP address is
the originating machine or server, not your own. If they are
trying to spoof your Ip address, the mail won’t get in.
Check your detailed smtp log and you’ll see where your hole is.

On 11/1/04 10:34 AM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:
I have a client who's having email relay problems.
Basically, people are relaying off his email server. He's
turned off relay for local sender addresses, and enabled SMTP
authentication.
However, he's had to let his local machine IP 127.0.0.1 for
access to the mail server, because WiTango needs to send
automatic email. However, because of this, anyone can still
relay mail off the server.
The question:
Is it possible for the WiTango server to send a username &
password to the mail server for outbound authentication? I
know that WiTango can use a specific email address, but can it
send a Username & password for authentication?
The server is version 2000 with SP2.
Thanks in advance,
Rick Sanders

TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf

-
Roland Dumas
Roberts Information Services
310 W. Bellevue Avenue
San Mateo CA 94402
650-347-1373
415-412-9300 (cell)
[EMAIL PROTECTED]
SMS: http://new.servqual.com/html/sms.tml

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
   


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

2004-11-01 Thread Roland Dumas

Title: Re: Witango-Talk: WiTango & Email




I understand what is going on, but this SHOULDN’T, unless you’ve left a door open.

I suspect you have authentication off for your whole domain, rather than turn it off for a handful of trusted IPs

When they send something through [EMAIL PROTECTED] and are sending it from an outside address, they should be challenged for user/pass, unless you’ve left an unnecessarily wide hole open by allowing relaying from anyone at your_domain.com. 

Your mail server is going to see the originating IP as 127.0.0.1 ONLY for clients actually on the same machine, namely witango. For every other message, it will see the sender’s IP as the IP of that originating client, not the domain that it claims to be from. 


On 11/1/04 12:19 PM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:

 
 
Hi Roland, 
 
Thanks for your reply. Unfortunately, it's a  little more complicated than that. 
 
The people relaying off the server, are using  the email address of the domain hosted on the server
 
So, the spammers are using [EMAIL PROTECTED], and it's going through  without authentication because 127.0.0.1 is in the privileged IP range.
 
The IP of that message is NOT 127.0.0.1, but the IP of the originating client. 






TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

2004-11-01 Thread John McGowan

If the mail is going to an account on the local machine, then the 
spammers aren't relaying at all... They are simply using a generic 
account name at the local domain as the return address.

The definition of mail relaying means that the mail would be relayed to 
another server.

Typically relay restrictions are not enforced when the recepient is a 
local account, because the mail isn't being relayed, it's being 
delivered to it's final destination.

/John
Rick Sanders wrote:
Hi Roland,
Thanks for your reply. Unfortunately, it's a little more
complicated than that.
The people relaying off the server, are using the email address of
the domain hosted on the server.
So, the spammers are using [EMAIL PROTECTED]
, and it's going through without
authentication because 127.0.0.1 is in the privileged IP range.
Of course, turning off the 127.0.0.1 stops un-authorized relaying,
but also stops the Tango server from sending auto email. Unless
the Tango server can send a username & password for authentication.
We've blocked a huge list of IP's, but they're spoofing IP's off
other Comcast & AT&T DSL customers.
Fun, fun, fun!
Hold on. Something’s amiss in your mail server setup.
IF you have relay enabled from 127.0.0.1 AND you have a mail
server on the same machine AND you have authentication turned on
for outside IP addresses, the mail server should still be
requiring authentication from outside people trying to use you as
an open relay.
I have that setup (webstar) and can see the steady stream of
attempted relays being blocked.
You can turn authentication off for your internal and trusted
networks, including 127.0.0.1 and the IP address of your witango
machine
Authentication required for everyone else
Use your firewall/router not not let in IP spoofers using 127. Or
your server’s IP address
Then, when the spammer is sending messages trying to exploit the
open relay, the mail server will reject because the IP address is
the originating machine or server, not your own. If they are
trying to spoof your Ip address, the mail won’t get in.
Check your detailed smtp log and you’ll see where your hole is.

On 11/1/04 10:34 AM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:
I have a client who's having email relay problems.
Basically, people are relaying off his email server. He's
turned off relay for local sender addresses, and enabled SMTP
authentication.
However, he's had to let his local machine IP 127.0.0.1 for
access to the mail server, because WiTango needs to send
automatic email. However, because of this, anyone can still
relay mail off the server.
The question:
Is it possible for the WiTango server to send a username &
password to the mail server for outbound authentication? I
know that WiTango can use a specific email address, but can it
send a Username & password for authentication?
The server is version 2000 with SP2.
Thanks in advance,
Rick Sanders

TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf

-
Roland Dumas
Roberts Information Services
310 W. Bellevue Avenue
San Mateo CA 94402
650-347-1373
415-412-9300 (cell)
[EMAIL PROTECTED]
SMS: http://new.servqual.com/html/sms.tml

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
   


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
 


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

Title: Re: Witango-Talk: WiTango & Email



 

  Hi Roland,
   
  Thanks for your reply. Unfortunately, it's a 
  little more complicated than that.
   
  The people relaying off the server, are using 
  the email address of the domain hosted on the server.
   
  So, the spammers are using [EMAIL PROTECTED], and it's going through 
  without authentication because 127.0.0.1 is in the privileged IP range.
   
  Of course, turning off the 127.0.0.1 stops 
  un-authorized relaying, but also stops the Tango server from sending auto 
  email. Unless the Tango server can send a username & password for 
  authentication.
   
  We've blocked a huge list of IP's, but they're 
  spoofing IP's off other Comcast & AT&T DSL customers.
   
  Fun, fun, fun!
   
  Hold on. 
  Somethings amiss in your mail server setup.IF you have relay enabled 
  from 127.0.0.1 AND you have a mail server on the same machine AND you have 
  authentication turned on for outside IP addresses, the mail server should 
  still be requiring authentication from outside people trying to use you as an 
  open relay.I have that setup (webstar) and can see the steady stream 
  of attempted relays being blocked.You can turn authentication off for 
  your internal and trusted networks, including 127.0.0.1 and the IP address of 
  your witango machineAuthentication required for everyone elseUse your 
  firewall/router not not let in IP spoofers using 127. Or your servers IP 
  addressThen, when the spammer is sending messages trying to exploit 
  the open relay, the mail server will reject because the IP address is the 
  originating machine or server, not your own. If they are trying to spoof your 
  Ip address, the mail wont get in. Check your detailed smtp log and 
  youll see where your hole is. On 11/1/04 10:34 AM, "Rick 
  Sanders" <[EMAIL PROTECTED]> wrote:
  I have a client 
who's having email relay problems.Basically, 
people are relaying off his email server. He's turned off relay for local 
sender addresses, and enabled SMTP authentication.However, he's 
had to let his local machine IP 127.0.0.1 for access to the mail server, 
because WiTango needs to send automatic email. However, because of this, 
anyone can still relay mail off the server.The 
question:Is it possible for the WiTango server to send a username & 
password to the mail server for outbound authentication? I know that WiTango 
can use a specific email address, but can it send a Username & password 
for authentication?The server is 
version 2000 with SP2.Thanks in 
advance,Rick SandersTO 
UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf-Roland 
  DumasRoberts Information Services310 W. Bellevue AvenueSan Mateo 
  CA 94402650-347-1373415-412-9300 
  (cell)[EMAIL PROTECTED]SMS: http://new.servqual.com/html/sms.tml
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: WiTango & Email

2004-11-01 Thread Ben Johansen









If you are using Witango Server 5 and
above you can do it though the @EMAILSESSION

 



Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement











From: Rick Sanders
[mailto:[EMAIL PROTECTED] 
Sent: Monday, November 01, 2004
10:35 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: WiTango
& Email



 



I have a client who's having email relay problems.





 





Basically, people are relaying off his email server. He's
turned off relay for local sender addresses, and enabled SMTP authentication.





 





However, he's had to let his local machine IP 127.0.0.1 for
access to the mail server, because WiTango needs to send automatic email.
However, because of this, anyone can still relay mail off the server.





 





The question:





 





Is it possible for the WiTango server to send a username
& password to the mail server for outbound authentication? I know that
WiTango can use a specific email address, but can it send a Username &
password for authentication?





 





The server is version 2000 with SP2.





 





Thanks in advance,





 





Rick Sanders










TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: WiTango & Email

2004-11-01 Thread Roland Dumas

Title: Re: Witango-Talk: WiTango & Email

Hold on. Something’s amiss in your mail server setup.

IF you have relay enabled from 127.0.0.1 AND you have a mail server on the same machine AND you have authentication turned on for outside IP addresses, the mail server should still be requiring authentication from outside people trying to use you as an open relay.

I have that setup (webstar) and can see the steady stream of attempted relays being blocked.

You can turn authentication off for your internal and trusted networks, including 127.0.0.1 and the IP address of your witango machine
Authentication required for everyone else
Use your firewall/router not not let in IP spoofers using 127. Or your server’s IP address

Then, when the spammer is sending messages trying to exploit the open relay, the mail server will reject because the IP address is the originating machine or server, not your own. If they are trying to spoof your Ip address, the mail won’t get in.

Check your detailed smtp log and you’ll see where your hole is.

On 11/1/04 10:34 AM, "Rick Sanders" <[EMAIL PROTECTED]> wrote:

I have a client who's having email relay problems.

Basically, people are relaying off his email server. He's turned off relay for local sender addresses, and enabled SMTP authentication.

However, he's had to let his local machine IP 127.0.0.1 for access to the mail server, because WiTango needs to send automatic email. However, because of this, anyone can still relay mail off the server.

The question:

Is it possible for the WiTango server to send a username & password to the mail server for outbound authentication? I know that WiTango can use a specific email address, but can it send a Username & password for authentication?

The server is version 2000 with SP2.

Thanks in advance,

Rick Sanders

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

-
Roland Dumas
Roberts Information Services
310 W. Bellevue Avenue
San Mateo CA 94402
650-347-1373
415-412-9300 (cell)
[EMAIL PROTECTED]
SMS: http://new.servqual.com/html/sms.tml

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Number Generate

2004-11-01 Thread Wilcox, Jamileh \(HSC\)

Title: Message



<@RANDOM> will 
generate a random number; you can set high & low limiters in the tag 
attributes.

  
  -Original Message-From: Steve Campbell 
  [mailto:[EMAIL PROTECTED] Sent: Monday, November 01, 2004 1:37 
  PMTo: [EMAIL PROTECTED]Subject: Witango-Talk: 
  Number Generate
  
  Hello
   
  I have a table that I am going to 
  insert info into 4 of the 5 fields into the table.  In the 5th 
  field, I just want the application to automatically generate a number or a 
  number with some prefixes I choose, and insert that number into the 
  5th field.
   
  I seem to remember in the past 
  using a metatag to do this, but I can’t seem to find what I need. 
  
   
  Any ideas would be 
  appreciate  and thanks in advance.
   
   
  Steve
   
   
  ---Outgoing mail is certified Virus Free.Checked by 
  AVG anti-virus system (http://www.grisoft.com).Version: 6.0.779 / Virus 
  Database: 526 - Release Date: 10/19/2004
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Number Generate

2004-11-01 Thread Robert Shubert









<@RANDOM LOW=lowest_possible_value HIGH=highest_possible_value>

 

-Original Message-
From: Steve Campbell
[mailto:[EMAIL PROTECTED] 
Sent: Monday, November 01, 2004
2:37 PM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Number
Generate

 

Hello

 

I have a table that I am going to
insert info into 4 of the 5 fields into the table.  In the 5th
field, I just want the application to automatically generate a number or a
number with some prefixes I choose, and insert that number into the 5th
field.

 

I seem to remember in the past using
a metatag to do this, but I can’t seem to find what I need. 

 

Any ideas would be appreciate 
and thanks in advance.

 

 

Steve

 

 








---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004
 



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Number Generate

2004-11-01 Thread Steve Campbell









Hello

 

I have a table that I am going to insert info into 4 of the
5 fields into the table.  In the 5th field, I just want the
application to automatically generate a number or a number with some prefixes I
choose, and insert that number into the 5th field.

 

I seem to remember in the past using a metatag to do this,
but I can’t seem to find what I need. 

 

Any ideas would be appreciate  and thanks in advance.

 

 

Steve

 

 








---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.779 / Virus Database: 526 - Release Date: 10/19/2004
 



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Urgent Help Needed

2004-11-01 Thread webdude

Title: Re: Witango-Talk: Urgent Help
Needed


I ended up rebooting the machine and it is now running correctly.
But why would this happen? I checked several sites before I went home
on Friday, and on Monday morning, I got nothing but this error. Did my
server update ITSELF during the weekend?

SQL7 is on a different machine

Both the WebServer and SQL7 Server are running Win2k...


I have seen this error recently. Have you
done any updates to the Operating System? Automatic or otherwise?
CHANGE THE TANGO Port number (T4Server.ini) from default 18100 to
another Port Number (LISTENERPORT=18200)
Restart the Tango Service. Test, That should take care of it.

~Brian Mowers

At 12:20 PM 11/1/2004, you wrote:
Win2k
IIS5
SQL7

I got here this morning, and on my production server I get this error
whenever a database call is made...

"Client Error

Configuration file does not specify a host and port
correctly."

It happens across the board for all my sites.

I desparately need help with this

Thanks

TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf


Brian Mowers
[EMAIL PROTECTED]


TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf





TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: WiTango & Email




I have a client who's having email relay 
problems.
 
Basically, people are relaying off his email 
server. He's turned off relay for local sender addresses, and enabled SMTP 
authentication.
 
However, he's had to let his local machine IP 
127.0.0.1 for access to the mail server, because WiTango needs to send automatic 
email. However, because of this, anyone can still relay mail off the 
server.
 
The question:
 
Is it possible for the WiTango server to send a 
username & password to the mail server for outbound authentication? I know 
that WiTango can use a specific email address, but can it send a Username & 
password for authentication?
 
The server is version 2000 with SP2.
 
Thanks in advance,
 
Rick Sanders



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Urgent Help Needed

2004-11-01 Thread Brian Mowers




I have seen this error recently. Have you done any updates to the
Operating System? Automatic or otherwise?
CHANGE THE TANGO Port number (T4Server.ini) from default 18100 to another
Port Number (LISTENERPORT=18200)
Restart the Tango Service. Test, That should take care of it.
~Brian Mowers
At 12:20 PM 11/1/2004, you wrote:
Win2k
IIS5
SQL7
I got here this morning, and on my production server I get this error
whenever a database call is made...
"Client Error
Configuration file does not specify a host and port
correctly."
It happens across the board for all my sites.
I desparately need help with this
Thanks

TO UNSUBSCRIBE: Go to
http://www.witango.com/developer/maillist.taf

Brian Mowers
[EMAIL PROTECTED]




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread Alan Wolfe

heres an optomization if you use the other distance formula:

distance = squareroot((x2-x1)^2 + (y2-y1)^2)

the square root takes a long time to compute, but the other math doesnt take
too long.  You might thing about squaring both sides and getting..

distance^2 = (x2-x1)^2 + (y2-y1)^2

that should be faster to calculate on the fly than trig and how you would
use it would be if you wanted a list of all locations where the distance was
less than 21, since both sides are squared you would check to see where the
distance was less than 441 (21^2).

When you get your results and want to display actual distances you could
just square root them at that time

- Original Message - 
From: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 01, 2004 7:33 AM
Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on...


> Jonah,
>
> to avoid a lot of calculations: I have allready short the formula. The
> enclosed formula was only to show how it works finally.
> Also I store allready the result for "SIN(<@COLUMN 'Adressen.Geo_Breite'>)
/
> COS(<@COLUMN 'Adressen.Geo_Breite'>)" in the database :-))
>
> But this don't help me to make the sort or to make a search in a radius
:-((
>
> regards
>
> Daniel
>
> - Original Message - 
> From: "Jonah Simpson" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Sunday, October 31, 2004 9:10 PM
> Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search
on...
>
>
> > Hey Daniel!
> >
> > What database are you using? I know MySQL can do the trigonometric
> > functions in a select statement and you could order your result from
> > the database...
> >
> > Doing trig functions is pretty gross efficiency wise. You might want
> > to store some of the functions that aren't going to change in your
> > location table. ie. Have columns for:
> > SIN(<@COLUMN 'Adressen.Geo_Breite'>)
> > COS(<@COLUMN 'Adressen.Geo_Breite'>)
> > in the same table that Adressen.Geo_Breite is stored in. As well,
> > pre-calculate:
> > COS(@@User$Breite_1) and
> > SIN(@@User$Breite_1) to avoid doing this calculation 2500 times.
> >
> > You might want to play with that formula and optimize it. I'm not
> > super hot with my trig identites, but I'm sure you could put it into a
> > form that allows you to store as much information in the database as
> > possible. Then you would only have to do a couple of calculations in
> > your actual select statement.
> >
> > Interesting problem...let us know what route you eventually take.
> >
> > Cheers,
> > Jonah Simpson
> > [EMAIL PROTECTED]
> >
> >
> > On Sun, 31 Oct 2004 19:22:39 +0100, [EMAIL PROTECTED]
> > <[EMAIL PROTECTED]> wrote:
> >>
> >> Distance Calculation is no problem, that works. Here the formula:
> >>
> >>
> >> <@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN
> >> 'Adressen.Geo_Breite'>)
> >> + COS(@@User$Breite_1)*COS(<@COLUMN
'Adressen.Geo_Breite'>)*COS(<@COLUMN
> >> 'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">
> >>
> >> The problem what I have is:
> >>
> >> 1) To do a sort of the result (OK, I can do it in a array, but this
need
> >> to
> >> much RAM [more as 2500 records, nearly 50x on one time])
> >>
> >> 2) To do a search in a specified area like "show me all points near x
> >> miles(km).
> >>
> >> One way what make sense is to store the formula in the database, but
> >> - if i make a assign to a variable, then Witango store only the result.
> >> What
> >> I like to store is the formula-text:
> >>
> >>
> >> Second problem: I can't do a sort on the stored formula (Sort command:
> >> <@COLUMN 'Adressen.formel' Encoding="Metahtml">)
> >>
> >> Any Successions ?
> >>
> >> THX for help
> >>
> >> regards
> >>
> >> Daniel
> >>
> >>

> >> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> > 
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> >
>
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread John McGowan

Not sure if this is what you're looking for, because I haven't had time 
to read the entire thread.. But when we had to do a Geo search in a 
database of lat and long s...  what we did was the following.

1. Use a simplified "Box Search" to start out.  Instead of doing a 
radius search,  (with the trig functions) we did a quick db search to 
get the matching records that would be inside of a BOX as opposed to a 
circle.   We used whatever the basic rule about how many degrees in a 
mile etc, with some linear fudging to compensate for the shrinking 
dimensions in the latitude axis. as you go away from the equator.

2. Then since we wanted to know the exact distance for each record we 
calculated the distance in a loop.  (since we're only calculating it for 
records that are close, we're not wasting that much time)

This was quite a while ago though so I may be remembering things 
incorrectly.

/John
[EMAIL PROTECTED] wrote:
Jonah,
to avoid a lot of calculations: I have allready short the formula. The 
enclosed formula was only to show how it works finally.
Also I store allready the result for "SIN(<@COLUMN 
'Adressen.Geo_Breite'>) / COS(<@COLUMN 'Adressen.Geo_Breite'>)" in the 
database :-))

But this don't help me to make the sort or to make a search in a 
radius :-((

regards
Daniel
- Original Message - From: "Jonah Simpson" 
<[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 31, 2004 9:10 PM
Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search 
on...


Hey Daniel!
What database are you using? I know MySQL can do the trigonometric
functions in a select statement and you could order your result from
the database...
Doing trig functions is pretty gross efficiency wise. You might want
to store some of the functions that aren't going to change in your
location table. ie. Have columns for:
SIN(<@COLUMN 'Adressen.Geo_Breite'>)
COS(<@COLUMN 'Adressen.Geo_Breite'>)
in the same table that Adressen.Geo_Breite is stored in. As well, 
pre-calculate:
COS(@@User$Breite_1) and
SIN(@@User$Breite_1) to avoid doing this calculation 2500 times.

You might want to play with that formula and optimize it. I'm not
super hot with my trig identites, but I'm sure you could put it into a
form that allows you to store as much information in the database as
possible. Then you would only have to do a couple of calculations in
your actual select statement.
Interesting problem...let us know what route you eventually take.
Cheers,
Jonah Simpson
[EMAIL PROTECTED]
On Sun, 31 Oct 2004 19:22:39 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Distance Calculation is no problem, that works. Here the formula:
<@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
'Adressen.Geo_Breite'>)
+ COS(@@User$Breite_1)*COS(<@COLUMN 
'Adressen.Geo_Breite'>)*COS(<@COLUMN
'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">

The problem what I have is:
1) To do a sort of the result (OK, I can do it in a array, but this 
need to
much RAM [more as 2500 records, nearly 50x on one time])

2) To do a search in a specified area like "show me all points near x
miles(km).
One way what make sense is to store the formula in the database, but
- if i make a assign to a variable, then Witango store only the 
result. What
I like to store is the formula-text:

Second problem: I can't do a sort on the stored formula (Sort command:
<@COLUMN 'Adressen.formel' Encoding="Metahtml">)
Any Successions ?
THX for help
regards
Daniel
 

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Distance Calculations - Sort on..., search on...




Thank you Ben !
This will work on the sort problem, but not on the 
search...
 
BTW.: Do you know a way to store the formula 
directly in the database (and not only the result) ?
 
rs
 
Daniel

  - Original Message - 
  From: 
  Ben Johansen 
  
  To: [EMAIL PROTECTED] 
  Sent: Monday, November 01, 2004 4:04 
  PM
  Subject: RE: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
  
  
  Ok, I am at the 
  computer that had my test file.
   
  Here it 
  is
   
  
  Ben Johansen - http://www.pcforge.comAuthorized Witango 
  & MDaemon ResellerAvailable for Witango 
  Developement
  
  
  
  
  From: Ben 
  Johansen [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 3:01 
  PMTo: [EMAIL PROTECTED]Subject: RE: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
   
  Let me 
  clarify,
  I didnt mean just 
  doing the formula in script, I meant to process the array and sort it within 
  server side _javascript_.
   
  Ben
   
  
  
  
  
  From: Ben 
  Johansen [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 1:34 
  PMTo: 
  [EMAIL PROTECTED]Subject: RE: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
   
  Have you thought of 
  sever side scripting?
   
  I did a similar test 
  a while back where the array was passed into server side _javascript_ and it did 
  the calcs very fast
   
  <@SCRIPT 
  EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
  'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 
  'Adressen.Geo_Breite'>)*COS(<@COLUMN 
  'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 
  6378,388>
   
  Just a 
  thought
   
  Ben
   
   
  
  
  
  
  From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 10:23 
  AMTo: 
  [EMAIL PROTECTED]Subject: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
   
  
  Distance Calculation is no 
  problem, that works. Here the formula:
  
  <@CALC 
  EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
  'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 
  'Adressen.Geo_Breite'>)*COS(<@COLUMN 
  'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 
  6378,388" Precision="1">
  
   
  
  The problem what I have 
  is:
  
   
  
  1) To do a sort of the result (OK, 
  I can do it in a array, but this need to much RAM [more as 2500 records, 
  nearly 50x on one time])
  
   
  
  2) To do a search in a specified 
  area like "show me all points near x miles(km).
  
   
  
  One way what make sense is to 
  store the formula in the database, but 
  
  - if i make a assign to a 
  variable, then Witango store only the result. What I like to store is the 
  formula-text:
  
   
  
   
  
  Second problem: I can't do a sort 
  on the stored formula (Sort command: <@COLUMN 'Adressen.formel' 
  Encoding="Metahtml">)
  
   
  
  Any Successions 
  ?
  
   
  
  THX for 
  help
  
   
  
  regards
  
  Daniel
  
   
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

  
  

  TO 
  UNSUBSCRIBE: Go to 
http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Distance Calculations - Sort on..., search on...




Ben,
 
the calculation for the distance is very fast, it 
will be done on the flight. But thx for the suggestion with the server side 
script. This will be faster
 
rs
 
Daniel

  - Original Message - 
  From: 
  Ben Johansen 
  
  To: [EMAIL PROTECTED] 
  Sent: Sunday, October 31, 2004 9:34 
  PM
  Subject: RE: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
  
  
  Have you thought of 
  sever side scripting?
   
  I did a similar test 
  a while back where the array was passed into server side _javascript_ and it did 
  the calcs very fast
   
  <@SCRIPT 
  EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
  'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 
  'Adressen.Geo_Breite'>)*COS(<@COLUMN 
  'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 
  6378,388>
   
  Just a 
  thought
   
  Ben
   
   
  
  
  
  
  From: 
  [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, October 31, 2004 10:23 
  AMTo: [EMAIL PROTECTED]Subject: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
   
  
  Distance Calculation is no 
  problem, that works. Here the formula:
  
  <@CALC 
  EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
  'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 
  'Adressen.Geo_Breite'>)*COS(<@COLUMN 
  'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 
  6378,388" Precision="1">
  
   
  
  The problem what I have 
  is:
  
   
  
  1) To do a sort of the result (OK, 
  I can do it in a array, but this need to much RAM [more as 2500 records, 
  nearly 50x on one time])
  
   
  
  2) To do a search in a specified 
  area like "show me all points near x 
  miles(km).
  
   
  
  One way what make sense is to 
  store the formula in the database, but 
  
  - if i make a assign to a 
  variable, then Witango store only the result. What I like to store is the 
  formula-text:
  
   
  
   
  
  Second problem: I can't do a sort 
  on the stored formula (Sort command: <@COLUMN 'Adressen.formel' 
  Encoding="Metahtml">)
  
   
  
  Any Successions 
  ?
  
   
  
  THX for 
  help
  
   
  
  regards
  
  Daniel
  
   
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf




TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Distance Calculations - Sort on..., search on...

Jonah,
to avoid a lot of calculations: I have allready short the formula. The 
enclosed formula was only to show how it works finally.
Also I store allready the result for "SIN(<@COLUMN 'Adressen.Geo_Breite'>) / 
COS(<@COLUMN 'Adressen.Geo_Breite'>)" in the database :-))

But this don't help me to make the sort or to make a search in a radius :-((
regards
Daniel
- Original Message - 
From: "Jonah Simpson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Sunday, October 31, 2004 9:10 PM
Subject: Re: Witango-Talk: Distance Calculations - Sort on..., search on...


Hey Daniel!
What database are you using? I know MySQL can do the trigonometric
functions in a select statement and you could order your result from
the database...
Doing trig functions is pretty gross efficiency wise. You might want
to store some of the functions that aren't going to change in your
location table. ie. Have columns for:
SIN(<@COLUMN 'Adressen.Geo_Breite'>)
COS(<@COLUMN 'Adressen.Geo_Breite'>)
in the same table that Adressen.Geo_Breite is stored in. As well, 
pre-calculate:
COS(@@User$Breite_1) and
SIN(@@User$Breite_1) to avoid doing this calculation 2500 times.

You might want to play with that formula and optimize it. I'm not
super hot with my trig identites, but I'm sure you could put it into a
form that allows you to store as much information in the database as
possible. Then you would only have to do a couple of calculations in
your actual select statement.
Interesting problem...let us know what route you eventually take.
Cheers,
Jonah Simpson
[EMAIL PROTECTED]
On Sun, 31 Oct 2004 19:22:39 +0100, [EMAIL PROTECTED]
<[EMAIL PROTECTED]> wrote:
Distance Calculation is no problem, that works. Here the formula:
<@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
'Adressen.Geo_Breite'>)
+ COS(@@User$Breite_1)*COS(<@COLUMN 'Adressen.Geo_Breite'>)*COS(<@COLUMN
'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">

The problem what I have is:
1) To do a sort of the result (OK, I can do it in a array, but this need 
to
much RAM [more as 2500 records, nearly 50x on one time])

2) To do a search in a specified area like "show me all points near x
miles(km).
One way what make sense is to store the formula in the database, but
- if i make a assign to a variable, then Witango store only the result. 
What
I like to store is the formula-text:

Second problem: I can't do a sort on the stored formula (Sort command:
<@COLUMN 'Adressen.formel' Encoding="Metahtml">)
Any Successions ?
THX for help
regards
Daniel

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Distance Calculations - Sort on..., search on...




Number of Users: between 1.500 an 
20.000
Number of locations: Over 17.000
Used Database: MySQL
 
Storing the data's is not possible. Each user have 
a different start-point. See my prev. mail.
 
Do the calculation inside the database will be 
possible, but then I must stored the result a new table. Only on 5 
calcs, I have several thausend records, so...
 
Views: I'm not sure, if MySQL support views. If 
yes, it would be fine
 
regards
 
Daniel
 
 
- Original Message - 

  From: 
  Alan Wolfe 
  To: [EMAIL PROTECTED] 
  Sent: Sunday, October 31, 2004 8:35 
  PM
  Subject: Re: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
  
  I guess without more information here's the best 
  solution that i see...
   
  depending on number of users you have and number 
  of locations they are looking at, it might be best to store the distances to 
  each location the user cares about in the database (calc'ing them at some 
  point) and then just sort that way.  calculating distance for alot of 
  locations at one time is going to be alot of CPU and will take a long time no 
  matter how you calc them (i am a game programmer on the side and deal w/ these 
  kinds of problems all the time, if at all possible, pre-calculating distance 
  and storing it is the way to go in alot of situations).  If the user is 
  in a position to where they would be able to "relocate" themselves, if 
  feasible, you could just recalculate the distances at the time they 
  locate.
   
  I think by far the best solution would be to 
  store the data in the database if possible.
   
  If not possible, if you have few enough 
  locations, you could calculate distances on the fly, but if possible, having 
  the database calculate the distance instead of witango since most databases 
  seem to be better at doing massive amounts of math at a time then witango 
  is.
   
  another thing you could do is if your database 
  supported views you could create a view where one of the columns on the view 
  is the distance of the location, and then you could select data from the view 
  and do sorts etc.
   
  with more information, we could probably give 
  better help but dont know if you would be giving away "proprietary secrets" or 
  not to do so :P
  
- Original Message - 
From: 
[EMAIL PROTECTED] 
To: [EMAIL PROTECTED] 
Sent: Sunday, October 31, 2004 11:18 
AM
Subject: Re: Witango-Talk: Distance 
Calculations - Sort on..., search on...

Alan,
 
stored is only the altitude and longitude. So, 
no more informations. The rest is calculated.
 
rs
 
daniel
 
 

  - Original Message - 
  From: 
  Alan Wolfe 
  To: [EMAIL PROTECTED] 
  Sent: Sunday, October 31, 2004 7:40 
  PM
  Subject: Re: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
  
  Hi Richard,
   
  How is the list of locations generated and 
  what do they represent?  how are you using them in your 
  program?
   
  Just wondering, why is it you want to store 
  the formula-text in the database?  If the database gave you the 
  answer instead of the formula, would you still need the text of the 
  formula?
  
- Original Message - 
From: 
[EMAIL PROTECTED] 
To: [EMAIL PROTECTED] 

Sent: Sunday, October 31, 2004 
10:22 AM
Subject: Witango-Talk: Distance 
Calculations - Sort on..., search on...

Distance Calculation is no problem, that 
works. Here the formula:

<@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 
'Adressen.Geo_Breite'>)*COS(<@COLUMN 
'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">
 
The problem what I have is:
 
1) To do a sort of the result (OK, I can do 
it in a array, but this need to much RAM [more as 2500 records, nearly 
50x on one time])
 
2) To do a search in a specified area like 
"show me all points near x miles(km).
 
One way what make sense is to store the 
formula in the database, but 
- if i make a assign to a variable, then 
Witango store only the result. What I like to store is the 
formula-text:
 
 
Second problem: I can't do a sort on the 
stored formula (Sort command: <@COLUMN 'Adressen.formel' 
Encoding="Metahtml">)
 
Any Successions ?
 
THX for help
 
regards
Daniel
 
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

TO UNSUBSCRIBE: Go to

Re: Witango-Talk: Distance Calculations - Sort on..., search on...




I have stored all locations (city's) from Germany, 
Switzerland and Austria (in all 17.000 records).
The stored information are:
 


  
  
  
  
  
  
LAT
LONG
FULL_NAME_ND
  
521.166.667
86.833.333
Aa-Bach
  
521.333.333
75.166.667
Aa-Bach
  
52.35
77.333.333
Aa-Bach
  
51.05
81.166.667
Aabach
  
514.833.333
87.333.333
Aabach Stausee
  
507.708.333
61.052.778
Aachen
  
507.672.222
60.916.667
Hauptbahnhof Aachen
  
507.538.889
62.419.444
Kreis Aachen
  
507.708.333
61.052.778
Kreisfreie Stadt Aachen
  
507.333.333
60.666.667
Aachener Stadtforst
  
508.166.667
61.666.667
Aachen-Merzbruck
  
507.666.667
61.333.333
Aachen-Rothe Erde
  
507.666.667
60.666.667
Aachen-West
  
497.833.333
66.333.333
Aacher Bach
 
What I like to present the customer is "how fare is it to Hauptbahnhof 
Achen from your location". 
This is solved with this formula:
<@CALC EXPR="ACOS(SIN(@@User$LAT)*SIN(<@COLUMN 'Adressen.LAT'>) + COS(@@User$LAT)*COS(<@COLUMN 
'Adressen.LAT'>)*COS(<@COLUMN 'Adressen.LONG'>-@@User$LONG)) * 
6378,388" Precision="1">
 
Ps.: I know the exactly coordinates of the User, so 
the User$Var's are OK.
 
Also I like to present the distance, sorted from the short to the longest 
distance,
and to give the customer a chance to make a search like: "Show me all 
locations in a 50km radius from my point."
 
Normally, this is no problem if you have one fixed point from the start, 
but the start is not fix. Let say, one customer is located at "Aacher Bach" 
(like Chicago) and a other is from Aa-Bach (Austin)...
 
regards
 
Daniel
 
 
- Original Message - 

  From: 
  Alan Wolfe 
  To: [EMAIL PROTECTED] 
  Sent: Sunday, October 31, 2004 8:23 
  PM
  Subject: Re: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
  
  how many locations do you have stored and why are 
  you storing them if i may ask?
   
  and what is it you are trying to present to the 
  user?
   
  That is, if this doesnt give away too much info 
  that you dont want to share :P
   
  just sometimes, good solutions to problems can be 
  found be examining the situation as a whole, instead of just looking at the 
  brick wall of the dead end you may currently be at you know?
  
- Original Message - 
From: 
[EMAIL PROTECTED] 
To: [EMAIL PROTECTED] 
Sent: Sunday, October 31, 2004 11:18 
AM
Subject: Re: Witango-Talk: Distance 
Calculations - Sort on..., search on...

Alan,
 
stored is only the altitude and longitude. So, 
no more informations. The rest is calculated.
 
rs
 
daniel
 
 

  - Original Message - 
  From: 
  Alan Wolfe 
  To: [EMAIL PROTECTED] 
  Sent: Sunday, October 31, 2004 7:40 
  PM
  Subject: Re: Witango-Talk: Distance 
  Calculations - Sort on..., search on...
  
  Hi Richard,
   
  How is the list of locations generated and 
  what do they represent?  how are you using them in your 
  program?
   
  Just wondering, why is it you want to store 
  the formula-text in the database?  If the database gave you the 
  answer instead of the formula, would you still need the text of the 
  formula?
  
- Original Message - 
From: 
[EMAIL PROTECTED] 
To: [EMAIL PROTECTED] 

Sent: Sunday, October 31, 2004 
10:22 AM
Subject: Witango-Talk: Distance 
Calculations - Sort on..., search on...

Distance Calculation is no problem, that 
works. Here the formula:

<@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN 
'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN 
'Adressen.Geo_Breite'>)*COS(<@COLUMN 
'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">
 
The problem what I have is:
 
1) To do a sort of the result (OK, I can do 
it in a array, but this need to much RAM [more as 2500 records, nearly 
50x on one time])
 
2) To do a search in a specified area like 
"show me all points near x miles(km).
 
One way what make sense is to store the 
formula in the database, but 
- if i make a assign to a variable, then 
Witango store only the result. What I like to store is the 
formula-text:
 
 
Second problem: I can't do a sort on the 
stored formula (Sort command: <@COLUMN 'Adressen.formel' 
Encoding="Metahtml">)
 
Any Successions ?
 
THX for help
 
regards
Daniel
 
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.ta

RE: Witango-Talk: Distance Calculations - Sort on..., search on...

2004-11-01 Thread Ben Johansen









Ok, I am at the computer that had my test
file.

 

Here it is

 



Ben Johansen - http://www.pcforge.com
Authorized Witango & MDaemon Reseller
Available for Witango Developement











From: Ben Johansen
[mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 31, 2004
3:01 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk: Distance
Calculations - Sort on..., search on...



 

Let me clarify,

I didn’t mean just doing the formula
in script, I meant to process the array and sort it within server side
_javascript_.

 

Ben

 









From: Ben Johansen
[mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 31, 2004
1:34 PM
To: [EMAIL PROTECTED]
Subject: RE: Witango-Talk:
Distance Calculations - Sort on..., search on...



 

Have you thought of sever side scripting?

 

I did a similar test a while back where
the array was passed into server side _javascript_ and it did the calcs very fast

 

<@SCRIPT EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN
'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN
'Adressen.Geo_Breite'>)*COS(<@COLUMN
'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388”>

 

Just a thought

 

Ben

 

 









From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Sunday, October 31, 2004
10:23 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Distance
Calculations - Sort on..., search on...



 



Distance Calculation is no problem, that works. Here the
formula:





<@CALC EXPR="ACOS(SIN(@@User$Breite_1)*SIN(<@COLUMN
'Adressen.Geo_Breite'>) + COS(@@User$Breite_1)*COS(<@COLUMN
'Adressen.Geo_Breite'>)*COS(<@COLUMN
'Adressen.Geo_laenge'>-@@User$Laenge_1)) * 6378,388" Precision="1">





 





The problem what I have is:





 





1) To do a sort of the result (OK, I can do it in a array,
but this need to much RAM [more as 2500 records, nearly 50x on one time])





 





2) To do a search in a specified area like "show me all
points near x miles(km).





 





One way what make sense is to store the formula in the
database, but 





- if i make a assign to a variable, then Witango store only
the result. What I like to store is the formula-text:





 





 





Second problem: I can't do a sort on the stored formula
(Sort command: <@COLUMN 'Adressen.formel' Encoding="Metahtml">)





 





Any Successions ?





 





THX for help





 





regards






Daniel





 










TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf



TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


ScriptTest.taf
Description: Binary data

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Source control

I have a very old version of source Safe 5.0 which I have never been able to
get to work right so I can work from different machines.

Is there an open source or another alternative that works with witango.

I like the way source safe works but with history and rollback and it is
easy to set up but not easy or at least easy for me to get working on my
network.

Dan


-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com


"When you are born, you cry and those who love you rejoice.  And if you
live your life as you should, when you die, you rejoice and those who
love you cry."


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

RE: Witango-Talk: Urgent Help Needed

2004-11-01 Thread Robert Shubert

Make sure the client.ini file on the web server is configured to reach
the IP/Port of the Witango server, and the Witango.ini file is
configured to listen to same IP/Port and that the valid hosts is set to
the webserver.

If you are all on the same machine, the IP should be 127.0.0.1

The clients.ini file should have a line for the dll/cgi/plugin like:

WITANGO_SERVER=127.0.0.1,18100

Robert

-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Monday, November 01, 2004 7:14 AM
To: [EMAIL PROTECTED]
Subject: Witango-Talk: Urgent Help Needed

Win2k
IIS5
SQL7

I got here this morning, and on my production server I get this error 
whenever a database call is made...

"Client Error

Configuration file does not specify a host and port correctly."

It happens across the board for all my sites.

I desparately need help with this

Thanks

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Help with displaying results?

I got it
Encoding=multilinehtml


on 11/1/04 7:28, Dan Stein at [EMAIL PROTECTED] wrote:

> Just to be clear. If I take this text and paste it into Dreamweaver it
> displays fine.
> 
> So I just need the tag or whatever that will make this display as HTML.
> 
> on 11/1/04 6:01, Dan Stein at [EMAIL PROTECTED] wrote:
> 
>> I am puling this text from a FMP 7 database. It is using a getassCSS
>> function to take formatted text and translate it to a style sheet.
>> 
>> What do I need to do in the results page to get it to display as text
>> formatted rather then the code.
>> 
>> This is what is in the column and display when I call the variable
>> request$HTML
>> 
>> This is styled text
>> This is 
>> styled
>>  text
>> 
This is styled
>> text
>> This is 
>> styled
>>  
>> text
>> 
>> 
>> 
>> 
>> 
>> 

-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com


"When you are born, you cry and those who love you rejoice.  And if you
live your life as you should, when you die, you rejoice and those who
love you cry."


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Urgent Help Needed

2004-11-01 Thread webdude

Win2k
IIS5
SQL7
I got here this morning, and on my production server I get this error 
whenever a database call is made...

"Client Error
Configuration file does not specify a host and port correctly."
It happens across the board for all my sites.
I desparately need help with this
Thanks

TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: Help with displaying results?

Just to be clear. If I take this text and paste it into Dreamweaver it
displays fine.

So I just need the tag or whatever that will make this display as HTML.

on 11/1/04 6:01, Dan Stein at [EMAIL PROTECTED] wrote:

> I am puling this text from a FMP 7 database. It is using a getassCSS
> function to take formatted text and translate it to a style sheet.
> 
> What do I need to do in the results page to get it to display as text
> formatted rather then the code.
> 
> This is what is in the column and display when I call the variable
> request$HTML
> 
> This is styled text
> This is 
> styled
>  text
> 
This is styled
> text
 
> This is 
> styled
>  
> text
> 
> 
> 
> 
> 
> 

-- 
Dan Stein
Digital Software Solutions
799 Evergreen Circle
Telford PA 18969
Land: 215-799-0192
Cell: 610-256-2843
Fax 413-410-9682
FMP, WiTango, EDI,SQL 2000
[EMAIL PROTECTED]
www.dss-db.com


"When you are born, you cry and those who love you rejoice.  And if you
live your life as you should, when you die, you rejoice and those who
love you cry."


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Re: Witango-Talk: REPLACE

2004-11-01 Thread Anthony M. Humphreys

JavaScript is case sensitive.
And you can run it on the server side inside <@SCRIPT>

You could use the String.replace() method and the RegExp object.

Something like:

myString.replace(/ö/g, 'a');myString.replace(/ä/g,
'a');myString.replace(/å/g, 'a');

And the same again for uppercase:

myString.replace(/Ö/g, 'O');myString.replace(/Ä/g,
'A');myString.replace(/Å/g, 'A');

Is that what you're after?

Anthony -


- Original Message - 
From: "Peter Ternström" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 28, 2004 17:33
Subject: Re: Witango-Talk: REPLACE


> OK.
>
> say that I want to replace:
>
> Å -> A
> Ä -> A
> Ö -> O
>
> å -> a
> ä -> a
> ö -> o
>
> in a variable, with regex. How would I do this? Point me in the right
> direction, please.
>
> Peter
>
>
>
> - Original Message - 
> From: "Bill Conlon" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, October 29, 2004 12:13 AM
> Subject: Re: Witango-Talk: REPLACE
>
>
> REGEX
> On Thursday, October 28, 2004, at 03:06  PM, Peter Ternström wrote:
>
> > Oh no. I feel so stupid now. I read it wrong and thought it was
> > case-sensitive. Any ideas of making a case sensitive replace?
> >
> > :-)
> >
> >
> > - Original Message - From: "Ben Johansen" <[EMAIL PROTECTED]>
> > To: <[EMAIL PROTECTED]>
> > Sent: Thursday, October 28, 2004 11:58 PM
> > Subject: RE: Witango-Talk: REPLACE
> >
> >
> > Unless it is a typo in the 5.5 docs
> > Excerpt from 5.0 docs: "<@REPLACE> is case insensitive."
> >
> > Case is insensitive hence A = a
> >
> >
> > Ben Johansen - http://www.pcforge.com
> > Authorized Witango & MDaemon Reseller
> > Available for Witango Developement
> >
> > -Original Message-
> > From: Peter Ternström [mailto:[EMAIL PROTECTED]
> > Sent: Thursday, October 28, 2004 2:48 PM
> > To: [EMAIL PROTECTED]
> > Subject: Witango-Talk: REPLACE
> >
> > Hello everyone,
> >
> > in the documentation for Witango 5.5 it says that <@REPLACE> is case
> > sensitive. However in tests, it seems that it is not case sensitive and
> > thinks a and A is the same character. Is this a known bug?
> >
> > Peter
> >
> > ___
_
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> >
> >
> > ___
_
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> > ___
_
> > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
> >
>
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>
> 
> TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
>


TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf

Witango-Talk: Help with displaying results?