Re: Witango-Talk: Load Balanceing
Each Witango service will need to see the location of the files in the same way. There are two and a half ways to do this. A) Copied Code (the half method). On each Witango server, copy the code to the same location (eg, c: \inetpub\wwwroot\). Configure IIS to share one of these as the website. You will need to manually maintain consistency between the copies (think customer file uploads, etc). Pros: Good Witango load sharing. Good for read only sites Quick and dirty. Cons: Manual work involved to ensure code is consistent between all Witango instances. No Witango service redundancy (they 'see' different copies of the files). B) Mapped Drive. Share wwwroot, and map a drive (eg, 'K:\') against it on _all_ Witango servers. Configure IIS to share drive K as the website. Pros: Good redundancy across application elements. Good load sharing. Easy to update code. Code is consistent between all Witango instances. Simple to configure Cons: Only works for a single site (you need a new drive letter for each site) If the mapped drive fails for any reason, manual intervention is required to restore the connection. C) Share Point Have your code in a shared directory, eg., \\Host\wwwroot\code.taf Configure IIS in the 'Home Directory' tab so that 'the content for this resource should come from [X] A share located on another computer', and point it at \\Host\wwwroot\ Ensure that the privileges required to access \\Host\wwwroot are available to the account that Witango is running under. With the above configuration, you can have single or multiple IIS front ends, with single or multiple Witango services. The share point could be served from any one of them, or an unrelated server (such as a NAS box). Pros: Good redundancy across application elements. Good load sharing. Easy to update code. Code is consistent between all Witango instances. Single hardware installation can support multiple sites Cons: Pain to get going. More to go wrong. More to look after. Regards, Jason. On 04/10/2007, at 3:32 PM, Fogelson, Steve wrote: Andre and others, I have done some testing with the following setup Server A will run one Witango service and the databases will reside here. Server B will run IIS, Witango Client and one Witango service I assumed you had to have copies of all the taf, tml, tcf, images and html files on both servers. Is this true or do you only have to have the files on the IIS and Witango Client server (B)? WITH IMAGINATION Planning, Implementation and Management of Web Applications Level 1, 44 Miller Street North Sydney NSW Australia 2060 phone + 612 9929 9229 fax + 612 9460 4770 web - www.wi.com.au email - [EMAIL PROTECTED] -- This message has been scanned for viruses and dangerous content by ESVA, and is believed to be clean. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
RE: Witango-Talk: Load Balanceing
Andre and others, I have done some testing with the following setup Server A will run one Witango service and the databases will reside here. Server B will run IIS, Witango Client and one Witango service I assumed you had to have copies of all the taf, tml, tcf, images and html files on both servers. Is this true or do you only have to have the files on the IIS and Witango Client server (B)? Thanks, Steve Fogelson -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 03, 2007 2:51 PM To: witango-talk@witango.com Subject: Re: Witango-Talk: Load Balanceing Hi, Steve. There's no doubt you can run another Witango IIS Plug-in on your current DB Server. You can even have that client cross reference the Witango instance on Web Server. Basically you can create any mesh of Witango clients/servers as long as you keep all your servers listed in clients.ini, and all your clients authorized in witango.ini. Whether or not you wat to reference multiple Witango Instances on Server B is your choice, It should work either way. I'd say this Load Splitting has been one of the greatest features of Witango since the very beginning. Good luck. Andre Rekthine IS Consultant Moveable Online Inc. > I have a few questions about setting up load balancing. I have two Windows > 2003 Web Edition servers using Witango 5.5. > > > > Server A will run IIS, Witango Client and one Witango service > > Server B will run one Witango service and the databases will reside here. > > > > I will move the databases to a 3rd server as budget permits. > > > > All my links do not include <@USERREFERENCE> > > > > I setup the client.ini on Sever A as follows > > [witango55_iis.dll] > > WITANGO_SERVER=ICS14,127.0.0.1,18155:ICS9,10.10.20.9,18155 > > ERROR_HTML=C:\\Program > Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html > > CONNECTION_TIMEOUT=0 > > FORCE_SERVER_ARG_NAME=_SrvID > > REPORTCLIENTERROR=TRUE > > SENDFULLHEADER=FALSE > > > > Do I need to revise the client.ini on Server B as follows: > > [witango55_iis.dll] > > WITANGO_SERVER= ICS9,127.0.0.1,18155:ICS14,10.10.20.14,18155 > > ERROR_HTML=C:\\Program > Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html > > CONNECTION_TIMEOUT=0 > > FORCE_SERVER_ARG_NAME=_SrvID > > REPORTCLIENTERROR=TRUE > > SENDFULLHEADER=FALSE > > > > Or leave it as > > WITANGO_SERVER= 127.0.0.1,18155 > > ERROR_HTML=C:\\Program > Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html > > REPORTCLIENTERROR=TRUE > > SENDFULLHEADER=FALSE > > > > Do I need to revise anything in Witango.ini when I am only running one > Witango service on each server? > > > > Is it possible to run IIS service and Witango Client on Server B as well > with different Witango web sites hitting this server? > > > > Thanks > > > > Steve Fogelson > > Internet Commerce Solutions > > > > 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: WitangoCMS SourceForge project is up
Hi all- Here's a link to the project on SourceForge. http://sourceforge.net/projects/witangocms I'll add/approve those who either send their SourceForge info to me or request to be added to the project. Cheers, Jason - Jason Pamental Director of Web Services North Sails Office: 401.643.1415 Fax: 401.643.1420 Mobile: 401.743.4406 Email: [EMAIL PROTECTED] TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Witango Customer Support
See http://www.witango.com/support/support.taf? vnav=support&page=contracts for support pricing. The web site says to write to [EMAIL PROTECTED] to obtain a support contract. I have no experience with the support contract. Bill William M. Conlon, P.E., Ph.D. To the Point 2330 Bryant Street Palo Alto, CA 94301 vox: 650.327.2175 (direct) fax: 650.329.8335 mobile: 650.906.9929 e-mail: mailto:[EMAIL PROTECTED] web: http://www.tothept.com On Oct 3, 2007, at 1:19 PM, Wolf, Gene wrote: Hey all, quick question. We are reorganizing here at DRS and moving our servers to our data center in Dallas (we're in Florida) and centralizing our networking support there as well. This is all a good thing. Needless to say Witango is an unknown to everyone in Dallas and they want to understand as much as they can about Witango and supporting it. They have written several e-mails to [EMAIL PROTECTED] and I've been told they have received no reply. I have always used this forum to get answers and do not know the best way to put our networking and support folks in touch with Witango support. How do you folks do it? Do you basically rely on this list, or is there some e-mail address other than the one listed above that should be used for support issues? Thanks! Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State." __ __ 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 Customer Support
You have to piss them off on this list, and then they respond. Of give them a credit card number. Those are the only ways that are most likely to work. Their support is horrible. -- Robert Garcia President - BigHead Technology VP Application Development - eventpix.com 13653 West Park Dr Magalia, Ca 95954 ph: 530.645.4040 x222 fax: 530.645.4040 [EMAIL PROTECTED] - [EMAIL PROTECTED] http://bighead.net/ - http://eventpix.com/ On Oct 3, 2007, at 1:19 PM, Wolf, Gene wrote: Hey all, quick question. We are reorganizing here at DRS and moving our servers to our data center in Dallas (we're in Florida) and centralizing our networking support there as well. This is all a good thing. Needless to say Witango is an unknown to everyone in Dallas and they want to understand as much as they can about Witango and supporting it. They have written several e-mails to [EMAIL PROTECTED] and I've been told they have received no reply. I have always used this forum to get answers and do not know the best way to put our networking and support folks in touch with Witango support. How do you folks do it? Do you basically rely on this list, or is there some e-mail address other than the one listed above that should be used for support issues? Thanks! Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. "This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior written approval from the U.S. Department of State." __ __ 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 Customer Support
Hey all, quick question. We are reorganizing here at DRS and moving our servers to our data center in Dallas (we're in Florida) and centralizing our networking support there as well. This is all a good thing. Needless to say Witango is an unknown to everyone in Dallas and they want to understand as much as they can about Witango and supporting it. They have written several e-mails to [EMAIL PROTECTED] and I've been told they have received no reply. I have always used this forum to get answers and do not know the best way to put our networking and support folks in touch with Witango support. How do you folks do it? Do you basically rely on this list, or is there some e-mail address other than the one listed above that should be used for support issues? Thanks! Gene Wolf Supervisor, Business Systems DRS Sensors & Targeting Systems-Optronics 2330 Commerce Park Drive NE Palm Bay, Florida 32905 Phone: 321-309-0685 321-309-0202 (fax) Dictionary.com Word of the Day http://dictionary.reference.com/wordoftheday/ This e-mail, including any attached files, may contain confidential and privileged information for the sole use of the intended recipient. Any review, use, distribution, or disclosure by others is strictly prohibited. If you are not the intended recipient (or authorized to receive information for the intended recipient), please contact the sender by reply e-mail and delete all copies of this message. > "This (document/presentation) may contain technical data as defined in > the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. > Export of this material is restricted by the Arms Export Control Act > (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons > without prior written approval from the U.S. Department of State." > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Re: Witango-Talk: Primebase,Procedures,@@resultset
Its been a while, but I believe you need to look at some example PB
procedures, and return a cursor, not print a value.
--
Robert Garcia
President - BigHead Technology
VP Application Development - eventpix.com
13653 West Park Dr
Magalia, Ca 95954
ph: 530.645.4040 x222 fax: 530.645.4040
[EMAIL PROTECTED] - [EMAIL PROTECTED]
http://bighead.net/ - http://eventpix.com/
On Oct 3, 2007, at 12:49 PM, David Mark Weiss wrote:
Hi To All,
I have written this procedure in the primebase scripts folder.
declare procedure ShowPrincipals(oq,pn,sd,ed)
returns varchar;
{
close database;
open database "TWCdb";
select WiOnhand len from workingInventory where wiPartNumber = pn
and wiLocation = "Portland";
fetch;
int BeginningInventory = len;
print BeginningInventory;
select sum(odQuanOrdered) TotalReserved from OrderDetail,
Ordermaster where odPrincPartNum = pn and
OMTWCOrdNum = ODTWCOrdNum and OMMustShip >= sd and OMMustShip <= ed;
fetch;
int NewTotal = (BeginningInventory + TotalReserved) - oq;
Print NewTotal;
}
end procedure ShowPrincipals;
Using the Primebase Console, I do the following and get the results
just fine.
1: 1> execute file "showprincipals.dal";
1: 2> showprincipals("15","6800","01/01/2004","01/31/2004");
1: > go
1: > 56812
1: : Done OK.
So it works just great.
However, when I do the same in a DBMS Action:
execute file "showprincipals.dal" in location "/Applications/
PrimeBase_DS.4229/setup/scripts/";
showprincipals("15","6800","2004-01-01","2004-01-31");
(changing the dates to ODBC Style of course)
It executes just fine, but @@resultset returns nothing.
Does anyone know what I need to do do get text to return calling a
procedure?
The reason for this is that I have some complex calculations to do,
and updating to do, that requires loops and Witango just isn't set
up for a long execution of loops. The procedures work great and are
lighting fast executed that way.
Thanks for any tips you can pass on.
Mark Weiss
http://trustthechildren.blogspot.com
__
__
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: Load Balanceing
Hi, Steve. There's no doubt you can run another Witango IIS Plug-in on your current DB Server. You can even have that client cross reference the Witango instance on Web Server. Basically you can create any mesh of Witango clients/servers as long as you keep all your servers listed in clients.ini, and all your clients authorized in witango.ini. Whether or not you wat to reference multiple Witango Instances on Server B is your choice, It should work either way. I'd say this Load Splitting has been one of the greatest features of Witango since the very beginning. Good luck. Andre Rekthine IS Consultant Moveable Online Inc. > I have a few questions about setting up load balancing. I have two Windows > 2003 Web Edition servers using Witango 5.5. > > > > Server A will run IIS, Witango Client and one Witango service > > Server B will run one Witango service and the databases will reside here. > > > > I will move the databases to a 3rd server as budget permits. > > > > All my links do not include <@USERREFERENCE> > > > > I setup the client.ini on Sever A as follows > > [witango55_iis.dll] > > WITANGO_SERVER=ICS14,127.0.0.1,18155:ICS9,10.10.20.9,18155 > > ERROR_HTML=C:\\Program > Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html > > CONNECTION_TIMEOUT=0 > > FORCE_SERVER_ARG_NAME=_SrvID > > REPORTCLIENTERROR=TRUE > > SENDFULLHEADER=FALSE > > > > Do I need to revise the client.ini on Server B as follows: > > [witango55_iis.dll] > > WITANGO_SERVER= ICS9,127.0.0.1,18155:ICS14,10.10.20.14,18155 > > ERROR_HTML=C:\\Program > Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html > > CONNECTION_TIMEOUT=0 > > FORCE_SERVER_ARG_NAME=_SrvID > > REPORTCLIENTERROR=TRUE > > SENDFULLHEADER=FALSE > > > > Or leave it as > > WITANGO_SERVER= 127.0.0.1,18155 > > ERROR_HTML=C:\\Program > Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html > > REPORTCLIENTERROR=TRUE > > SENDFULLHEADER=FALSE > > > > Do I need to revise anything in Witango.ini when I am only running one > Witango service on each server? > > > > Is it possible to run IIS service and Witango Client on Server B as well > with different Witango web sites hitting this server? > > > > Thanks > > > > Steve Fogelson > > Internet Commerce Solutions > > > > TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Primebase,Procedures,@@resultset
Hi To All,
I have written this procedure in the primebase scripts folder.
declare procedure ShowPrincipals(oq,pn,sd,ed)
returns varchar;
{
close database;
open database "TWCdb";
select WiOnhand len from workingInventory where wiPartNumber = pn
and wiLocation = "Portland";
fetch;
int BeginningInventory = len;
print BeginningInventory;
select sum(odQuanOrdered) TotalReserved from OrderDetail,
Ordermaster where odPrincPartNum = pn and
OMTWCOrdNum = ODTWCOrdNum and OMMustShip >= sd and OMMustShip <= ed;
fetch;
int NewTotal = (BeginningInventory + TotalReserved) - oq;
Print NewTotal;
}
end procedure ShowPrincipals;
Using the Primebase Console, I do the following and get the results
just fine.
1: 1> execute file "showprincipals.dal";
1: 2> showprincipals("15","6800","01/01/2004","01/31/2004");
1: > go
1: > 56812
1: : Done OK.
So it works just great.
However, when I do the same in a DBMS Action:
execute file "showprincipals.dal" in location "/Applications/
PrimeBase_DS.4229/setup/scripts/";
showprincipals("15","6800","2004-01-01","2004-01-31");
(changing the dates to ODBC Style of course)
It executes just fine, but @@resultset returns nothing.
Does anyone know what I need to do do get text to return calling a
procedure?
The reason for this is that I have some complex calculations to do,
and updating to do, that requires loops and Witango just isn't set up
for a long execution of loops. The procedures work great and are
lighting fast executed that way.
Thanks for any tips you can pass on.
Mark Weiss
http://trustthechildren.blogspot.com
TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: Load Balanceing
I have a few questions about setting up load balancing. I have two Windows 2003 Web Edition servers using Witango 5.5. Server A will run IIS, Witango Client and one Witango service Server B will run one Witango service and the databases will reside here. I will move the databases to a 3rd server as budget permits. All my links do not include <@USERREFERENCE> I setup the client.ini on Sever A as follows [witango55_iis.dll] WITANGO_SERVER=ICS14,127.0.0.1,18155:ICS9,10.10.20.9,18155 ERROR_HTML=C:\\Program Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html CONNECTION_TIMEOUT=0 FORCE_SERVER_ARG_NAME=_SrvID REPORTCLIENTERROR=TRUE SENDFULLHEADER=FALSE Do I need to revise the client.ini on Server B as follows: [witango55_iis.dll] WITANGO_SERVER= ICS9,127.0.0.1,18155:ICS14,10.10.20.14,18155 ERROR_HTML=C:\\Program Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html CONNECTION_TIMEOUT=0 FORCE_SERVER_ARG_NAME=_SrvID REPORTCLIENTERROR=TRUE SENDFULLHEADER=FALSE Or leave it as WITANGO_SERVER= 127.0.0.1,18155 ERROR_HTML=C:\\Program Files\\WitangoServer\\5.5\\MiscFiles\\clienterror.html REPORTCLIENTERROR=TRUE SENDFULLHEADER=FALSE Do I need to revise anything in Witango.ini when I am only running one Witango service on each server? Is it possible to run IIS service and Witango Client on Server B as well with different Witango web sites hitting this server? Thanks Steve Fogelson Internet Commerce Solutions TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: <@script>
I would like to call a javascript json parser using the script command so that I may return an array back to a witango array variable. The json parser requires other libs. Is there a way to load the libs inside the <@script> action so the parser may work. Thanks TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
Witango-Talk: external action call
I'm running tomcat on the same webserver as IIS and trying to make an external call to my jsp pages using the external action and getting the following error. The documentation for the external action is vague. Any Ideas. Thanks Error communicating with Java server. Invalid magic number. TO UNSUBSCRIBE: Go to http://www.witango.com/developer/maillist.taf
