Re: [U2] Interesting article
On 7/12/2011 4:06 PM, Dawn Wolthuis wrote: [chop] As to old SQL, there is a revolution going on out there and I'm wondering if other MV people have seen this: Look at the data storage for Android, Google App Engine, AmazonDB, etc. All of these platforms and others are using name/value pairs with some relational functionality, but they're not using SQL. Once again we're missing a whole new generation of data hungry applications. Yes, many of us have been suggestion (for more than a year and a half at least) that we should position ourselves (MV) to jump under this larger umbrella NoSQL (Not only SQL or yes-no-sql or in some cases No SQL). The MV products are some of the only ones in this arena that are proven. The problem goes way below the non-adoption of the NoSQL movement. It's a consistent stale state of emerging and adopting technology. Most of this is driven by shrinking customer bases and therefore a lack of revenue to justify seemingly unjustifiable new development that can incorporate the _required_ technologies. Look how long it took to get industry-wide HTTP support in MV. It should have _never_ taken that long to get enterprise stability in the web world. .NET is just now catching on as a major investment for development framework? While there are still new methods of data storage and retrieval being created all the time, the MV market needs to define a consistent web service / REST API for data access and rule execution, accessible from any client. Any clues on how to get any standard that all MV vendors would deploy? I'm thinking this would require third-party software and, even then, the vendors might have better solutions for anyone not needing a cross-MV-platform solution (most users of MV systems do not require such). Been there, done that and saw no interest. It will take code soldiers willing to consistently rush the lines and bash down the doors at all of the DB vendors until they realize that we aren't going to stop until we get what we want. Before that happens, though, there has to be an adopted RFC to define how the comm happens and gives granular detail that can not be misinterpreted by anyone implementing it. Once that is done, it's a matter of building wrappers and interfaces for all of the popular languages. Want the unfinished scrap of an MV ASCII protocol RFC I started back in 2002? More importantly are there more than 3 developers out there willing to suit up and then actually spend time building a language hook? (That's easy, I have done this many times for various projects and for most MV platforms.) From there, professionals in this community can position as experts to provide applications, DBMS support services, rules in BASIC, hosting, and mentoring for a new generation of people who might like to use BASIC for rules rather than Java, Ruby, Go, or whatever else they're just starting to learn. Yeah... as if... Yeah, I don't see it going that route. I do think we could possibly pop up a bit more into the NoSQL playground as an industry. The name is a tad bit unfortunate, but the idea is a good one. --dawn GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Frustrated with Rocket / Unidata 7.2
On 2/17/2011 10:14 PM, Kevin King wrote: I wonder if the ftp on Win2003 is better than the ftp on Win7? Sure, I realize that it's about impossible for Rocket to know every little incompatibility with Windows versions but ftp? That's pretty crucial. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users Kevin, Look on the bright side, SCP is a better and safer (snooping and bit-transfer wise) solution. I only use authenticated FTP when a vendor forces me due to a lack of technology. IMO FTP refuses to die specifically because of Windows software, so it's a bit ironic that this is a Microsoft platform related problem. This isn't yet-another-ftp-vs-scp-debate thread so I'll go back to lurking again. :) GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A new DML?
On 2/7/2011 11:48 PM, Steve Romanow wrote: How many companies sole source of income is from innovation and investment from 2-3 decades and 6 owners ago? ___ I know of many but they each have their own varying level of innovation due to varying focuses. What are you getting at? GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] A new DML?
On 2/7/2011 3:58 PM, Tony Gravagno wrote: From: Charles_Shaffer You will never be able to go completely away from UniBASIC while keeping a U2 database. I don't think that's possible. We use Uniobjects on our web servers to access our Unidata servers. Technically we could avoid UniBasic with Uniobjects, although I don't recommend it. It has makes more sense to push the database logic to the database server using Unibasic routines called by Uniobjects. I'll interject that there are two discussions going on here: language bindings outside the DBMS, connecting in via whatever pipes happen to be available (UO, C, Intercall, sockets, etc), and language bindings built into the DBMS alongside BASIC. I'll go on a limb and state my belief emphatically that we will never see another new language implemented within the DBMS itself. (The only other language I've ever seen built over MV was RPL (PQN+), which is now only available for D3 with variants in jBase and Reality). The DBMS vendors have no motivation to undertake the massive effort of creating a new compiler and runtime to operate over the DBMS engine. Claims of new sales potential with mainstream languages can't be substantiated; We obviously already have external bindings and MV sales have never spiked because of it. Now, as I've said recently, we can immediately build our own external language bindings with no help from any of the DBMS providers. Unfortunately this option leaves us to connect in via the above methods, and no matter how fast that happens, it's subject to a performance hit. A much more elegant solution would be an API that dynamically links with the DBMS monitor to perform direct read/write/call and other operations. Maybe someone can tell us if the UO server component really is this closer to the metal interface, but it's always seemed to me that even that server component is one step and a performance hit away from direct DBMS access. With such an API (and direct access for file open/read/write, etc) just about any language can be implemented inside the box, again with no help from the DBMS provider(s). I'm guessing we could count on two hands how many people might actually be intensely interested in any of this. T As an end-user developer, you probably won't find much interest. There's too much to do with the core business code as it is. Would it make life easier for the few solutions developers who actually might want it? I know I've wanted similar gut hooks for my own oddball projects but I have always found a way to make things happen without it. Just because we're clever enough to connect points A and B, though, doesn't mean we should simply accept that the steps involved always be convoluted and the process numbingly inefficient. Do the DBMS vendors not care about making the solutions-providing developer's lives easier? Who really sells their product? How many forward-thinking developers have left MV because these should-haves never have existed. How many migrations have happened due to a small subset of those must-haves have popped up in another flavor? GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Server Socket logic
I was not aware that you could pass file handles between phantoms and process or other phantoms. That's a no-brainer for Linux fork(), but in most of the MV socket services I've implemented I either: 1) use an inetd/Winetd tool to handle the socket-based muxing and all you have to do is make simple command-line calls to routines(or a single service program). They use stdin/stdout via normal keyboard and screen I/O. Gotta be careful with local echo, though. 2) Have the client first connect to the master (accept()ing process), get an available client phantom port from the pool and then reconnect to that idle phantom on that specific port# to handle the request. #1 makes the solution the easiest to code for and expand, IMO. #2 makes worker management a primary headache but it can all be kept inside the environment. Both solutions can either serve multiple applications from one port based on request data or they serve specific apps on different dedicated ports. A third option is to use request/response file queuing and what ever media type you feel comfortable with. Check out MVWWW on SourceForge for an idea of what I did there. It takes a little more leg work and the interesting(and potentially insecure) feature is that you can easily inject requests and hijack responses at the cross-roads using pretty much any tool at any layer. Local sockets aren't technically any safer, mind you, but it's much much simpler to get a text file into a directory than to spoof network packets. GlenB On 1/13/2011 11:28 AM, Symeon Breen wrote: PHANTOM From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Kevin King Sent: 13 January 2011 15:42 To: U2 Users List Subject: Re: [U2] Server Socket logic Yes, but how do you fork in universe? ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _ No virus found in this message. Checked by AVG - www.avg.com Version: 10.0.1191 / Virus Database: 1435/3376 - Release Date: 01/12/11 ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Code 128 Soft Font
Bob, Let me also extend an offer to help with general development off-hours, if you're willing to work with GPL libs for open development. I'm sure Artifex will be happy to work out a commercial distribution deal for their Ghostscript offerings. I've dealt with the GS devs on many occasions for both the GPL Ghostscript libs and the XPS/GPDL stuff for PCL, where I've found bugs. They are troopers in that regard. My time is limited @home and I don't have time @work right now to devote to co-developing something, but I could really use a PrintWizard product on our RH server. HTMLDOC is far from a perfect solution, but it's getting the job done right now. As Anthony has stated, I would rather have a local app running on an existing server than go through the hassle/time/expense of configuring yet another critical Windows machine. We will be using it extensively company-wide so it needs to be a fast and rock-solid solution from the power plug in the server it's running on to the PDF being sent via sendmail. I'm sure your customers have never had problems, but based on my previous experience with Windows updates and service pack conflicts I can't take chances with something like this. A perfect example of why I don't care for Windows as a server; I've been forced to hunt down a copy of Win2K3 SBS because FedEx has yet to certify their shipping server app on 2K8. I came - - close to dumping an entire shipping solution due to the OS version requirements and availability tied on by a third party as large as FedEx. C'mon, how long as 2K8 been out?! I've found one application, which I obtained back on RH7.2, that does not run properly on RH ES5. I don't want to get into a Linux/Windows argument, but the fact is I love Linux for core processing and it'll take a major business upset for me to even consider moving something as critical as global document gen to a Windows machine. I have no quarrels with using Windows as a desktop OS or even as an interim data processing platform as long as my approval stamp isn't on it. :) BTW, TRUSTPrice has retail 2K3 copies with 5 CALs for around $500. They're legit copies, or at least mine is. Regards, GlenB On 5/19/2010 1:15 PM, Glen Batchelor wrote: Bob, You don't directly use a printer driver to generate content for other printers, so what you suggest is a little misleading. I understand the Microsoft printing interface having done some coding myself. There are drawing and publishing libraries out there that will do what you want and produce vector or raster imaging depending on what output you're attempting. You can then reformat that using other tools/libraries. The Ghostscript libraries are very powerful and there are a lot of format, or device, output options included. The key with the GS/GPDL library is that everything gets processed as vector graphics. It is, afterall, based on Postscript. Bitmaps are not handled that well, so PCL output can get bloated. The GPDL library is getting better for PCL2PS conversion, but it's still not perfect. I would note that your best success will probably come from generating Postscript content in your tools and then leveraging the GS libs to output PCL, inkjet, jpeg, etc output. I also suggest you stop by #ghostscript on irc.freenode.net and chat with the devs if you're looking for a Microsoft-like drawing and formatting library replacement. While it may be off-topic, I'm sure someone will suggest a few options. There also is a user and dev mailing list if you're not IRC-inclined. Don't forget about Tetex and/or LaTex markup conversion possibilities too. Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 E-mail: webmas...@all-spec.com Web: http://www.all-spec.com Blog: http://blog.all-spec.com (]chomp[) for brevity ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Credit Card info
Typically, the last four are unique amongst corporate cards under a buyer who may buy for different departments or facilities with different departmental buying cards. They all are issued by the same bank so identifying a specific charge later is hard to do if you don't know the auth code and the last four. We run across this often with SmartPay 2 cards for the US Gov and related firms. There are 4 issuing banks for all of the cards so it's not a good idea for us to use the first four. Even then it can be difficult to do if the charged amounts are the same. We store card meta data in the orders to help with this, instead of being forced to sift through a batch report of hundreds of charges per day. Glen On 1/16/2010 6:37 PM, Anthony W. Youngman wrote: In message 32605-1263604391-637...@sneakemail.com, Tony Gravagno 3xk547...@sneakemail.com writes Final note: I recommend breaking up any secure data you have and storing it in different files. A compromised credit card number is no good without other data including name, address, zipcode, phone number, etc. If you store the card ID in pieces, and encrypted, and separate from this other data, then even if the environment is compromised, the only person who could make use of the data would be someone who is intimate with your code and file structures. That was something I was thinking of. I saw on Risks where somebody discussed this print only the last four digits of the card number. I *think* actually, that's NOT what you should do for credit cards. The reason is strange, but makes sense ... Certainly with Barclaycard/Visa, the *first* four digits are pretty much constant per the issuer. It's the last digits that vary most. So if you only display the *first* four digits, you will give enough info to the card owner for him to identify his card, but any attacker will only be able to identify the bank that issued the card. All Barclaycards, for example, begin with 4929 iirc (or they did, I think there are a couple of other variants around now). Other cards are, I gather, the other way round. That article on Risks was how people who didn't understand WHY a particular 4-digit group had been chosen, arbitrarily changed it and thereby actually undermined the entire security behind the idea. The danger is if different people print different bits of the number. An attacker can then put the whole number together from different printouts. Either way, if you're going to print 4 digits, DON'T pick which four at random or because someone else says this is the four. Ask yourself WHY pick that four, and there's a damn good argument which tells you which set to pick, and it isn't just because they're the first, or the last. Cheers, Wol ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions
Opera won't load it either, obviously, because it's not IE. GlenB Steve Romanow wrote: It is also a no-go for linux. -Original Message- From: Kevin King precisonl...@gmail.com Sent: Friday, August 21, 2009 11:04 PM To: U2 Users List u2-users@listserver.u2ug.org Subject: Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions Is this the same issue that's stopping Safari and Chrome as well? Not to throw stones but it seems like there's a lot of browser caveats for a ... um... browser-based tool. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Better and Better Application - Launching todayFriday 8/21/09 -- Browser instructions
David Wolverton wrote: Hey -- Is this your way of volunteering to help? Sweet! Drop Baker your information so we can get you set up! The project, being 100% volunteer, has been through LOTS of hands. If you'd like to help, you can then criticize the heck out of it. And if you don't want to help, then let your issues be known WITHOUT editorial. Is that so much to ask? There are probably LOTS of implementation issues on getting this out the door -- This is a VOLUNTEER project -- the work was started in Australia, loose ends as found updated from the U.S. on a server based in Europe - And we're on a machine that is 'under-licensed' for the onslaught of people curious to see what's behind the flap once it was tossed out there - there really wasn't a way to do a 'follow the sun' release announcement to limit the risk to running out of seats on a machine that will normally have 3 people a day touch it! I'm guessing many of the issues being seen are from too many people online at once. There WILL be issues for the first few weeks/months. Sorry about reality being such a bitch... REMEMBER -- This is volunteer work being done to make the world a better place for everyone... Cut some slack for those people so they have incentive to keep working on it. Volunteer projects can be rolled out with better browser support than currently demonstrated. The problem with relying on a specific browser's features is the fact that you end up building an app with lots of mods later that can become troublesome to debug and fix when the mods start affecting each other. Rushing a project to fruition solely based on IE's features is not a great way to demonstrate any public web app IMO. I have to agree with the poster's comments on that fact, but I also don't think it's proper to point fingers and name development methods if there are no facts to reference. They need the feedback on what is not working correctly so it can be fixed. The editorials... Not so much. Relying solely on IE's non-W3C features is the first bug. If this is an intranet app, then use whatever you want. If this is to be a public bug reporting tool then perhaps the initial approach is not the best one. And really folks -- give it a week or two to settle down. Send any 'found issues' or 'connection problems' to the group so they can be reviewed -- if possible, include the time (and your TimeZone!) and your browser used (along with version). Hopefully with the data they can find out if the issue is 'seats' (and then perhaps can get IBM to donate more!) or a particular browser is having issues that needs particular review. I can promise you no one tested this with Chrome or Safari -- no one in the volunteer groups uses those! So again, if you want to vollunteer to 'beta test' your favorite flavor of browser, PLEASE let Baker know -- they can always use more help. Without editorial. David W. The problem isn't the connection or the seats. It's the error reporting and the fact that you can't tell that you have to have IE to load the home page. Here's the URL I get redirected to: http://212.241.202.162:8080/db/errDisplay.asp?code=1011er=ERROR:%20EXP01%20MS%20Internet%20Explorer%206.0%20or%20later%20is%20required%20to%20use%20DesignBais.%20%20Please%20download%20IE6%20or%20later%20and%20try%20again. The page itself just says: Error Report An error occured in this application. Please contact your system administrator or your software vendor to report this problem. [Try Again] Why isn't the real error (in the URL) on the page itself? That would probably help some. GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] Better and Better Application - Launching today Friday 8/21/09 -- Browser instructions
Kevin King wrote: Having been on the board in a past life - for what little I did contribute - I can say that the U2UG board and volunteers work hard and should be commended for their efforts. That said, can we all please stay focused on the results without getting personal about it? I've yet to get personal about anything relating to this. However, I'm free to voice my opinion on the subject since public inquiries were requested. I'm all for the project, provided the masses can actually use it. Personally, I think this BB thing is an excellent idea and I'm looking forward to taking a peek at it. I also think that we as an industry need to be more forward thinking in adopting web technology, and I'm pleased that the board is making strong moves in that direction. (And hey, for this worldwide group, it just makes good sense.) Kevin, we both know the current state of the industry. It is moving forward (slowly), but is this vendor-specific forum of comments really going to affect the rest of the industry? It's great for IBM and for U2 and I'm all for it. I have no interest in seeing any volunteer project fail, as I've seen plenty of my own get buried in the bit bucket from a lack of interest and/or lack of vision. We need to be realistic here, though. Chrome, Safari, Opera, and Fire Fox are just as popular as IE and are the preferred or only browser available on many desktops. Luckily, there is a fix for Fire Fox. What about all of the Mac users, though? Chrome is growing in popularity as well, so it can not be ignored. Look at the iPhone's explosion. It has Safari, not IE. Would it not be nice to be able to submit bug reports and feature requests from your iPhone, waiting at the airport? The same can be said for all web-capable mobile devices that don't run some mobile version of Windows, which is a large percentage. This browser incompatibility issue rings oddly familiar, reminiscent of applications throughout history that only worked properly on Wyse50's or some other CRT. Anyone remember PROF on the old Reality systems? Early releases of that product were the poster child for terminal incompatibility (pun intended). And you know what? We worked through all that. Yeah, we ended up using emulation software that could handle them all. A decade later the web grew up and became useful for businesses. There are browser emulators available, but the only people that really use those are web devs. I just don't buy your logic here. Now we're faced with different terminal emulators going by the names of IE, FF, Chrome, Opera, Safari, and a few others. Sure, the whole connection method has changed - stateful telnet going the way of stateless http - yet at the most fundamental level, it's all just bits on a wire talking to some device on the other end. Too simple, you say? I disagree. It *is*simple. It's the same problems we've addressed before and that we will address again and again as the technology landscape evolves. The difference here is that there _is_ (and has been for a long time) a standard and it's called W3C. There is no incompatibility unless you develop outside of the W3C standards. AJAX and various other Javascript-based development methods (JQuery is great!) can work with all W3C compliant browsers if the standards are followed. Some extra coding is required and some features may have to be dropped or simulated using other methods to implement the desktop-like features users want now. Heck XHTML is the standard now and all of the mentioned browsers support it along with AJAX and CSS. I think even Konquerer will properly run AJAX sites, provided the site doesn't use IE-only features. Having established this context, I do have concerns about the premise that we need Microsoft technology to do the web properly or that Microsoft technologies give us something that we couldn't get any other way. Of course, the same could be said of IBM or Oracle or ... name any company here. As solution providers we need options, and therefore the best thing our vendors can do is to give us more options to do what we need to do as quickly, efficiently, and cost-effectively as possible. To that end, what the BB group is doing is positive steps in the right direction. ___ Yes. It's great, as a starting step. I just hate to see a ton of work go into a framework that is so browser restrictive. GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] ODBC to UPS WorldShip
Tony G wrote: I concur with Glen's assessment that some of these services can be unstable. Not long after writing NebulaShip (nospamNebula-RnD.com/products/ship.htm) I realized that even though the product was stable that we might be getting emergency calls when services were down. I stopped advertising the product, we're not currently selling it, and unless there is significant demand for some of the less critical functions (lookups, confirmations) I may withdraw it entirely. Make sure you have backup providers for critical services. That's a nice spin on my comments. I was actually promoting the API web intergration. WorldShip and Cafe' change too often to be long-term stable automated shipping components IMO. If you have someone standing at the terminal running batches, then OK have fun. I'd rather not waste employee time doing that. If you're only shipping a handful of packages then the desktop tools are fine. We ship way more than that and our shipment processing efficiency was suffering with WorldShip integration. WorldShip used to change once every 3 or 4 years (it seemed like) but now every year a new version comes out with some core change that affects a piece of software plugged into it. Plus, I never could get the post-shipping export to work with D3 ODBC and from what I've read it's not fun to do with U2 either. We use RF terminals to capture tracking barcodes and prompt for other box info. Of course, that is only when the order is hazardous or the rare instance that we can't process packages through the API. It really is a rare thing, so I wouldn't discount your NebulaShip. Anyone who specifically integrates web services must have an understanding of the cloud and the fact that stuff will get lost in the ether just like your ODBC lookup will fail at some point. Either way, a plan needs to be in place to handle the problem. No service is perfect. It won't happen daily, quarterly, or even semi-annually if you implement the proper infrastructure and failover plan. If you don't plan the cloud-operating infrastructure to support web services during processing hours then your disaster recovery is just as bad as sticking the backup tapes to the filing cabinet with magnets. GlenB Tony Gravagno Nebula Research and Development TG@ remove.pleaseNebula-RnD.com remove.pleaseNebula-RnD.com/blog Visit PickWiki.com! Contribute! From: Glen Batchelor 3) You're tied to a web service that can (and will) go down at some point. Have a backup processing plan with WorldShip. UPS has been good, for the most part. FedEx has gotten better, but there are still times when the FedEx Ground back-end disappears and we get goofy 'unavailable' errors. ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] wGet new failure
u2list0...@curt.com wrote: Windows XP was not involved. This is running on Windows Server 2003. I cured the problem. I wrote a .VBS Script that calls wget and renames the resultant item name and I use a uvRunCommand on it and it works perfectly. At 6/25/2009 01:28 PM, you wrote: Actually I think it's true for anything XP and newer, but I've not tried removing the carat on Vista. GlenB ___ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users
Re: [U2] U2 Application / Solutions providers list? PICK / U2 Hits? Any ERP Light applications out there?
Check out DDI System. We are running a legacy 9.1 version of green screen software from them, but the current software they sell is nothing like our ~12-year-old customized Linux-based solution. I believe their current app is totally U2 objects or ODBC based and runs solely on Windows now. Adam Waller is the guy to talk to: www.ddisys.com. Tell 'em Glen from All-Spec referred you on the U2 mailing list. GlenB Scott Richardson wrote: Hello folks, A good number of years ago, there used to be a published list / document / book of various PICK / U2 Solutions Providers or Value Added Resellers and ISV (aka Independent Software Vendors) listing the VAR or ISV, their vertical markets served, and descriptions of the applications they provided, (I think it was called PICK HITS or something like that?). Is there anything similar produced/published these days? It would appear that such a document would be an excellent vehicle for the continued proliferation of the multi-valued market. (IBM U2 Marketing - where are you?) I too am out of work, but in discussions with a small local MFG type operation about an IT Manager opportunity. One of the main aspects they're looking for in this IT Manager position is someone to find, and implement an ERP Light application. It should be noted these folks have previously attempted a Epicor solution that they were sold that when it came time to implement, they discovered that this Epicor product did not do what this company needed at all. This company was promised what they wanted it to do could be done, but then learned well AFTER shelling out big $$, (after expected delivery time of the mod's), that what they wanted was not currently possible, but could be attained with 10X the previously shelled out big $$ and a couple of years of development time from the Epicor development team. Needless to say, that implementation fell flat on its face, and now they're out looking again. Looking for something that does Sales Orders and Sales History, Inventory Control, AP / AR Financials and maybe a few other basic MFG type related applications. Surprisingly, these folks are not using any pre-existing package, but using a lot of home grown type spread sheet based improvised solutions. Ideas? Suggestions? Thank you. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] PDF printing, LaTeX, Ghostscript, etc.
Doesn't using PrintWizard imply the use of a Windows server somewhere? If not, then can you provide a link to your Linux version? I've looked your offering over several times and end up considering other options simply because I already have too many disparate servers forced to perform individual tasks due to vendor requirements. I'm hoping I missed something. I'm not yet at the virtualization point since one power supply has 10X higher of a chance of blowing up than 10 power supplies. GlenB -Original Message- From: owner-u2-us...@listserver.u2ug.org [mailto:owner-u2-us...@listserver.u2ug.org]on Behalf Of Bob Rasmussen Sent: Tuesday, January 27, 2009 7:42 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] PDF printing, LaTeX, Ghostscript, etc. On Tue, 27 Jan 2009, Norman Bauer wrote: Glen,Bill, Ron, and Brian, Thanks for the input on this. Glen's way seems to be about the same way I am thinking of going about it. And it is proof enough to me that it is possible, allthough I am going to probably use LaTex to do the markup, it looks nicer. We are running UV on Windows and will be for the forseeable future however this would be a great oppertunity to intro Linux into the environment. My company is under new managment and they were always opposed to the idea, the new managment is looking to improve and cut cost. Although I haven't looked at LaTex for some time (if ever), and it might provide a very good solution, let me chime in to reinforce the earlier reference to Tony G's description of Print Wizard, our product. In a nutshell, you could program your UV to output HTML-like page descriptions. In fact, much of it could be HTML, although there is some HTML we don't support. Conversely, there are things we support that HTML doesn't such as specifying: * Generation of barcodes * Paper size, orientation, etc. * Precise placement of text and graphics on the page. * Form overlays * and more. The output of Print Wizard can go to: * Any Windows-supported printer * Windows-only printers * TIFF * Fax * PDF When you generate a PDF, you can also: * Create a table of contents * Attach other documents * Create internal or external links * Certify the document * Email it, interactively, semi-interactively, or automatically We're talking $300. Regards, Bob Rasmussen, President, Rasmussen Software, Inc. personal e-mail: r...@anzio.com company e-mail: r...@anzio.com voice: (US) 503-624-0360 (9:00-6:00 Pacific Time) fax: (US) 503-624-0760 web: http://www.anzio.com street address: Rasmussen Software, Inc. 10240 SW Nimbus, Suite L9 Portland, OR 97223 USA --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Calling on AccuTerm users who are using the GUI designer
If you built it as a stand alone GUI app then you can wrap the main section of the code in a subroutine/return block and use it like any other subroutine call. I do that for search pop-up windows currently. Just make sure that bail-outs are handled correctly. GlenB -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Brenda Price Sent: Thursday, July 03, 2008 4:54 PM To: u2-users@listserver.u2ug.org Subject: [U2] Calling on AccuTerm users who are using the GUI designer OK, I'm just starting out with this. I have an existing program that has over lots of options from it that each call a subroutine. The record id is passed to the calling subroutine. I need to add a new option and I want to create a AccuTerm GUI program for it but I still need to pass in the record id. I went through the AccuTerm Tutorial and built the screen the way I want it, then found oops, it doesn't look like I can call that routine and pass in the record id, actually I need to pass in 3 variables. I thought I'd ask the list before I scrap this and go back to the normal green screen application. Brenda Price Affiliated Acceptance Corporation Sunrise Beach, MO --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Guaranteed unique sequential keys
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Merrall Sent: Friday, April 25, 2008 8:07 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Guaranteed unique sequential keys On Fri, Apr 25, 2008 at 10:19 PM, Marco Manyevere [EMAIL PROTECTED] wrote: So... in the best traditions of using a pile-driver to crack a nut you could roll your own . Of the top of my head, a locking service would be a U2 subroutine listening on a particular network port that is started/stopped along with the DB. Your client routines would use the socket functions to connect. The nice thing is you get the duplicate connection handling for free. U2 socket listeners are not multi-threaded so the first client in gets the socket. As long as you hold it for 1 clock tick before closing and have the other clients on a time-out longer than 1 clock-tick, you should get your unique keys. There are other options and they all have been tested. A master service phantom responds to all initial requests with a port# to connect back on. The client reconnects from the master over to the client phantom on that port. You can have X client phantoms handling the actual processes. That provides multi-client service, but it provides it at the cost of reconnections. I utilize a file-based spooling architecture in conjunction with inet/Winetd sockets in MVWWW to avoid this reconnection scenario, but that does have performance limitations. I did mention this was over-kill right? It's not overkill if you need a multi-app/multi-process service that offers a single source for sequential keys. The other option is disk file locking. Any way you look at it, you have to go to one place for the key. Don't relay on O/S random numbers either. Even those are flawed at high resolution. Although the code itself is pretty simple and, in my experience on Unidata, the U2 sockets routines work very well, I would spend some time benchmarking to make sure this kind of effort is worthwhile. Assuming you have some spare server capacity, if the phantoms are using a lock file on a frequent basis, the file will likely be in cache anyway. HTH but probably not. Adrian GlenB --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Guaranteed unique sequential keys
You'll need a central key generator to manage high resolution sortable sequential keys. You can use whatever connection medium is feasible and let a single process/phantom generate the keys in numerical order. The problem with using a key generator like this is that you could easily produce a bottleneck. On the other hand, the benefit of doing it this way is that the generator can be a single phantom. It can keep track of the last used key in memory and can pregenerate keys for near-future or parallel usage. If the connection medium you choose allows for multiple requests at a time, then your management code must be able to manage and pregenerate keys for each thread concurrently. A wide solution could be a socket service that serves unique keys to clients. I use base-16 for a lot of sequential keys so that I have many unique iterations per key length. I always use them as direct pointers and I never sort them, though. Hex sortability from LIST/SORT/SELECT could be questionable. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Marco Manyevere Sent: Thursday, April 24, 2008 5:55 AM To: u2-users@listserver.u2ug.org Subject: [U2] Guaranteed unique sequential keys What is the most reliable way to generate unique sequential keys without having to resort to a record on disk updated through readu/write? The keys don't have to be contiguous but only be sortable in the order in which they were generated by several phantom processes running concurrently. I'm currently approximating this using a concatenation of date and time with millisecondsB but I'm worried about the possibility of two phantoms generating exactly the same key. B Although no collision has been detected so far, I have added an extra check where after generating the key I first test if a record with that key exists. If so IB increment and append aB serial number and repeat the test until aB unique key is found. ItB seems to be working well but I still think there is a better way to do this. B Thanks for any help. B Marco. __ Sent from Yahoo! Mail. A Smarter Email http://uk.docs.yahoo.com/nowyoucan.html --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms
Well, I was actually only tasked with making the ATS more real time for our Asia sales office. Since they're entering orders during our night, they always get the short end of the stick, ATS may or may not be right; the batch updates are all timed/tuned for US timezone (and work pretty accurately heretofore). Anyway... we all hate partial solutions ... so one gets to contemplating, and one thing leads to another. I don't have enough clout around here to convince them to add yet another data store to their enterprise, but I agree with you - you must establish referential integrity to go real time with this cluster. UniVerse is presently the quasi-reference point [UniVerse is the center of our world - figure that out isaac asimov], but it's only perfectly accurate once a day. OK. So use the existing MS SQL server as your reference point. You don't _have_ to put another data store in the mix. I'm definately no SQL expert, but can't SQL views and stored procedures be used to blend tables and provide the proper updating and reference paths/points for the UV and the ISAM DB by themselves? The suggestion of the additional MySQL/MS SQL server was to serve as a live multi-point data store, but now that I think about it you would be able to get the same results with what you have. Answers to your questions: a) WCS uses an ISAM db b) Unix Windows I like your solution to the puzzle Glen. ... clear thinking as always. rgds, -Baker Thanks, I'm glad that you actually understood what I typed. I'm not known for clarity in my postings. g Glen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris Sent: Thursday, October 25, 2007 4:42 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Fastest Bi-Directional data transfer btwn MV and non-MV dbms That would be an [ad] ... but there are some people that may convince us to port Visage.DRS to UV as well -- slight tweak would go a long way to a proving parts of a solution for this scenario (but how did you know we were looking at replication to foreign databases?) Hrm.. Didn't we discuss something of this nature @ Spectrum Long Beach? Albeit, there were no definate plans in place at the time. I didn't mean to provoke attention in the wrong place, if that's the case. #;) Ross Ferris Stamina Software Visage Better by Design! You should ask Ross how he managed to get live data replication working with D3. g Glen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] HP PCL Commands
I use HTML formatting, html2ps, Ghostscript, and Postscript capable printers to handle all of that stuff along with EPS logos and signatures. If you are forced to use PCL (these days most PCL6 capable printers do Postscript level 1) then you are better off writing the raw PCL so that you aren't always at the will of the driver's settings. Honestly, Postscript is far more flexible, convertable, and portable than PCL. You can also generate print-quality output with EPS graphics and Postscript formatting without having to store/upload huge macros and logo fonts for each printer. The key, as always, is knowing which tools and devices fit your needs. Create Postscript for direct printing Convert it to PDF for e-mail, web, printing, local viewing, and e-doc archival Convert it to TIFF for faxing Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of MAJ Programming Sent: Wednesday, April 25, 2007 11:44 PM To: u2-users@listserver.u2ug.org Subject: [U2] HP PCL Commands I know that HP printer drivers create the PCL that causes typeface and font size changes etc and that we can create our own PCL strings to cause the same effect. But is there a way to imply the effect the same way that Microsoft programs like Word can border a word with boldWORD/bold and the driver interpets the bold and does the work. We have a program that presently uses hand-grown PCL commands for the nice output and the IT guy is thinking of including some non-HP/PCL printers in other depts that would use the same program and I don't want to manage multiple PCL-like tables when I know that printer drivers can do it for me. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UD: Best way to convert GMT date/times to internal?
There's a couple of bugs in this code that I just found. Ick! Shame on me! I've pasted the fixed code in-line. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glen Batchelor Sent: Friday, February 23, 2007 12:49 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UD: Best way to convert GMT date/times to internal? I think this is posted a long time ago on the d3www/mvwww sourceforge site as well. Hack it up and mangle it all you want. This is to convert current time into GMT and pass the ISO zone difference as a standalone var. For your need, you'll have to reverse engineer it. This was written on D3, but it should be vanilla code. SUBROUTINE GMT(GMT,ISOZONEDIFF) ! ! CONVERT CURRENT ZONE TIME TO GMT ! DAYLIGHT SAVINGS FOR NORTH AMERICA ONLY ! ! ATL = 4 HOUR DIFFERENCE ! EST = 5 HOUR DIFFERENCE ! EDT = 4 HOUR DIFFERENCE ! CST = 6 HOUR DIFFERENCE ! CDT = 5 HOUR DIFFERENCE ! MST = 7 HOUR DIFFERENCE ! MDT = 6 HOUR DIFFERENCE ! PST = 8 HOUR DIFFERENCE ! PDT = 7 HOUR DIFFERENCE ! ALA = 9 HOUR DIFFERENCE ! HAW = 10 HOUR DIFFERENCE ! SDAY = '' EDAY = '' ATL = -04:00 ATLDIFF=4 EST = -05:00 ESTDIFF=5 EDT = -04:00 EDTDIFF=4 CST = -06:00 CSTDIFF=6 CDT = -05:00 CDTDIFF=5 MST = -07:00 MSTDIFF=7 MDT = -06:00 MDTDIFF=6 PST = -08:00 PSTDIFF=8 PDT = -07:00 PDTDIFF=7 ALA = -09:00 ALADIFF=9 HAW = -10:00 HAWDIFF=10 ! ! CHANGE THE FOLLOWING TWO NUMBERS TO REFERENCE YOUR HOURLY DIFFERENCE ! ! DAYLIGHTSAVINGS (DST) VARIABLES CAN BE SET TO NULL, IF YOU SET THE ! DAYLIGHTSAVINGS FLAG TO ZERO. THIS SHOULD ONLY BE DONE FOR ZONES ! THAT DO NOT UTILIZE DST. ! DAYLIGHTSAVINGS=1 MYZONE=EST MYDSTZONE=EDT MYDIFF=ESTDIFF MYDSTDIFF=EDTDIFF ! LOCALTIME = TIME() GMT='' YR=OCONV(DATE(),'DY') ! FIGURE OUT THE EXACT START AND END DATES FOR DAYLIGHT SAVINGS TIME ! FOR THIS YEAR ! !#NORTH AMERICAN DST STARTS ON THE FIRST SUNDAY OF APRIL AND ENDS ON !#THE LAST SUNDAY OF OCTOBER. ! !NORTH AMERICAN DST CHANGED TO SECOND SUNDAY IN MARCH - FIRST SUNDAY IN NOVEMBER ! AS OF 02/2007 ! IF DAYLIGHTSAVINGS=1 THEN TDT=03/01/:YR ITDT=ICONV(TDT,'D4/') TDTE=11/01/:YR IDTE=ICONV(TDTE,'D4/') SUNDAYS = 0 FOR X = 1 TO 31 DOW=OCONV(ITDT,'DW') MON=OCONV(ITDT,'DMA') IF MON # March THEN GO 100 IF DOW = 7 THEN SUNDAYS = SUNDAYS + 1 END IF SUNDAYS = 2 THEN SDAY = X GO 100 END ITDT=ITDT+1 NEXT X IF MON # November THEN GO 200 100 FOR X = 1 TO 31 DOW=OCONV(IDTE,'DW') MON=OCONV(IDTE,'DMA') IF DOW = 7 THEN EDAY = X GO 200 END IDTE=IDTE+1 NEXT X 200 EDTSTART = 03/:SDAY:/:YR EDTSTART = ICONV(EDTSTART,'D4/') EDTEND = 11/:EDAY:/:YR EDTEND = ICONV(EDTEND,'D4/') IF DATE() = EDTSTART AND DATE() = EDTEND THEN LOCALTIME=TIME() GMT=LOCALTIME+(60*60*MYDSTDIFF) ISOZONEDIFF=MYDSTZONE END ELSE LOCALTIME=TIME() ISOZONEDIFF = MYZONE GMT=LOCALTIME+(60*60*MYDIFF) END END ! ! NO DAYLIGHT SAVINGS ! IF DAYLIGHTSAVINGS = 0 THEN LOCALTIME=TIME() GMT=LOCALTIME+(60*60*MYDIFF) ISOZONEDIFF=MYZONE END RETURN --- Glen Batchelor IT Director All-Spec Industries phone: (910) 332-0424 fax: (910) 763-5664 e-mail: [EMAIL PROTECTED] --- www.allspec.com --- -Original Message- From: [EMAIL PROTECTED] [mailto:owner-u2- [EMAIL PROTECTED] On Behalf Of Raymond DeGennaro II Sent: Friday, February 23, 2007 10:49 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UD: Best way to convert GMT date/times to internal? It seems to me that you've left out a great deal of what you are trying to get. Sorry, I'm looking to convert a GMT date/time group that is DST-less and in Zulu-time to the local date/time (several timezones east and potentially shifted another hour by DST). The data is coming from a service provider and we have no control over the format. The data is sent as ISO8601 DTG's like: -MM-DDThh:mm:ss-00:00 (The time zone offset is always 00:00) and a minimal character format: MMDDHHMMSS, depending whether the transaction is being passed real-time or as
RE: [U2] Java Script
JavaScript: http://partners.adobe.com/public/developer/en/acrobat/sdk/pdf/javascript/Acr oJS.pdf Command line printing tool(with source): http://www.geocities.com/sea_sbs/files/pdfp.zip DDE/COM interface docs for VBA scripting: http://partners.adobe.com/public/developer/en/acrobat/sdk/pdf/iac/IACReferen ce.pdf Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, February 23, 2006 10:20 PM To: u2-users@listserver.u2ug.org Subject: [U2] Java Script A client of mine has a folder filled with PDF's. I want to cause the printing (choice and copies) from my MV application. Prior, I could set up a DOS command line with the /P print switches but Adobe now doesn't support switches. They suggested that I get at acrobat reader 5.0 using a java script. I want the user to be able to choose a reference from the MV app, create a batch file or script on their C: drive and print blindly (or at least without human intervention) the PDF. I probably can control the copy count from my end with multiple identical lines. The emulator is Wintegrate but could be Accuterm. Thanks in advance Mark Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Steve Cashman
It's not as simple as you might think. There have been long heated discussions about how to deal with vacation auto-responders on lists - including Majordomo. In the end, there's 2 options: 1) A subject filter that drops all messages with out of the office and away on vacation somewhere in the subject. That will also kill real postings with the strings in them. Also, various away responders may have different subject styles so the rules you implement may only work 50% of the time. As the list grows, the chances of a variety of vacation clutter grows. 2) The second option, which is typical for people who openly use mailing lists, is to set up your auto-responder to not send 'away' replies to e-mail addresses that are mailing lists. That can be done with partial address matching or by specifying the e-mail addresses manually. It only takes one step, by you or your mail admin, and it's dealt with for good. It would be great if people in very active lists, like U2-users, took the time to exclude their list subscriptions from their auto-responders. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Louie Bergsagel Sent: Saturday, February 25, 2006 2:13 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Steve Cashman You'd think something so simple would be part of any list server. Maybe we need to write an mvListserver... On 2/24/06, Mark Johnson [EMAIL PROTECTED] wrote: I'm guessing March 6. Just a hunch. I think that the list server should/could detect these and terminate. Otherwise, they could spin out of countrol. Mark Johnson - Original Message - ... Does anyone know when Steve Cashman will be back in the office? ... --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Is there a Better Editor?
http://www.mvtoolbox.com It's more than just an editor. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Caskey, Michael Sent: Tuesday, February 21, 2006 6:10 PM To: u2-users@listserver.u2ug.org Subject: [U2] Is there a Better Editor? Hi all, this is my first post to the board, so a big Hi to you all! I'm probably showing off my lack of knowledge here, but I hope someone might have the knowledge I seek, so... I have been tasked with creating reports from our UniData system using UniQuery. For building queries, I have been given a tool called PARADEX. This tool seems extremely ancient to me. The interface is extremely cumbersome. To edit anything, special commands are employed to edit my queries, one line at a time. I'm already fairly lost in the system, so the last thing I need is cumbersome tools to make my life even more difficult. I like things to be easy peasy. :) So, my questions are: 1. Is there a better way to run these queries? and 2. Is there a better query editor; text-based or GUI or both? Thank you all! Michael T. Caskey --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UniVerse server socket issues
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Gyle Iverson Sent: Wednesday, December 14, 2005 7:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UniVerse server socket issues Hello, Tony. Tony Gravagno opined... Clients need to know the port of a server, so a server absolutely requires a fixed and well-known port. A server can have a randomly assigned port that is fixed and well-known only between the client and the server. If the server only exists for the benefit of one client, it is up to them to figure out how to assign and communicate the port dynamically. The fixed and well-known port requirement does not imply that the assignment is permanent. FTP transfer is a good example of a dynamic port assignment. Client commands are passed through server port 21, while the file data is sent to the server through a dynamically spawned transfer service on a dynamically assigned port. Why do you need an assigned port for a server? Think about the problem of a client needing to spawn a unique server on demand of the client. Each client may spawn a server dedicated to that client. Certainly if one were using real UNIX/Windows processes, one could single-thread through a central process and fork a new process, however, U2 products do not allow forking of processes. No MV products can share the same user heap through forking or child threading. If you want some options for socket services with MV, e-mail me directly. execv() is a possibility using a C call, but it's not a fork or thread solution. I don't want to flood the group with a bunch of potentially meaningless text. 2) The other issue with the initServerSocket() is that it does not recognize when another process already has a given port open for listening. I haven't read the specs for initServerSocket but if it doesn't return a non-zero for an attachment failure then yes, it's probably broken. Yep. However, in general, a given service should only have one listening process. Not always true. There are dynamic services too. FTP once again is a good example. It is valid to have a range of ports which all respond to inbound connections as a single service - that is, multiple servers will be listening to different socket ports, even if they support the same application/transport service. Interesting idea but it does not help with this issue. Have you tried supporting multiple listening sockets in U2? You can not get anywhere without a select() or poll() function analogue. While one could spawn numerous phantoms, each listening on a unique port, one is left with how to coordinate data and such between the phantoms. Not a pretty solution. No, it's not, but there are ways around this using external pooling. Like I said, e-mail me. JD3 is a good example of a phantom pool, but phantom pooling requires a lot of socket reconnections and that just puts unneeded load on the network sub-system. It's a stable design, but I personally don't like that architecture when there is a stream of short-term connections. Coordination of what ports are in use for a given service should be done by the application, so you should never really get to a failure in initServerSocket. Try the replication program using port 80. On my system initServerSocket returns success even though IIS is currently bound to that port. If nothing else you can use netstat to see what ports are in use and use a recognized port that is unallocated. Yes, but not a solution for this issue. Again, if you randomly generate a socket port for a service, how will any client know what port to connect to? They communicate the port number behind the scenes. broken recordFTP/broken record Good luck. Tony Gravagno Thanks, Tony. Best regards, Gyle Glen batchelg bell_south n.e.t --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML and Accuterm
OK I've tried this and got a response, so it ~will work. The problem lies in the DOM object. UPS isn't getting the document content and is sending back a missing XML document error. BTW, I'm on W2K and I didn't have to install the XML bundle. I have all the latest SP's though as well as the .NET development kit. I'll try to find the ActiveX control that contains both of these objects and post the filenames. Btw, if you want to kill Accuterm 2K2 regularly, just put a msgbox(xmldoc) right after the xmldoc is finished setting. I need to post this over to Pete on the Asent forum. PS: you will need an active UPS XML developer key and account in order to actually use this code. If you run it as-is you will get a response, but it won't be tracking info. g Sub Main() Dim oXMLServer As Object Dim oXMLDocument As Object Dim xmldoc As String Dim tracknum As String Set oXMLServer = CreateObject(Msxml2.ServerXMLHTTP.3.0) Set oXMLDocument = CreateObject(Msxml2.DOMDocument.3.0) oXMLDocument.async = False userid = my-UPS-dev-userid passwd=my-UPS-dev-password licensenum=my-UPS-dev-license tracknum = my-trackingnum xmldoc= xmldoc=xmldoc ?xml version= Chr(34) 1.0 Chr(34) ? Chr(13) Chr(10) xmldoc=xmldoc AccessRequest xml:lang= Chr(34) en-US Chr(34) Chr(13) Chr(10) xmldoc=xmldoc AccessLicenseNumber licensenum /AccessLicenseNumber Chr(13) Chr(10) xmldoc=xmldoc UserId userid /UserId Chr(13) Chr(10) xmldoc=xmldoc Password passwd /Password Chr(13) Chr(10) xmldoc=xmldoc /AccessRequest Chr(13) Chr(10) xmldoc=xmldoc ?xml version= Chr(34) 1.0 Chr(34) ? Chr(13) Chr(10) xmldoc=xmldoc TrackRequest xml:lang= Chr(34) en-US Chr(34) Chr(13) Chr(10) xmldoc=xmldoc Request Chr(13) Chr(10) xmldoc=xmldoc TransactionReference Chr(13) Chr(10) xmldoc=xmldoc CustomerContextExample 1/CustomerContext Chr(13) Chr(10) xmldoc=xmldoc XpciVersion1.0001/XpciVersion Chr(13) Chr(10) xmldoc=xmldoc /TransactionReference Chr(13) Chr(10) xmldoc=xmldoc RequestActionTrack/RequestAction Chr(13) Chr(10) xmldoc=xmldoc RequestOptionnone/RequestOption Chr(13) Chr(10) xmldoc=xmldoc /Request Chr(13) Chr(10) xmldoc=xmldoc TrackingNumber tracknum /TrackingNumber Chr(13) Chr(10) xmldoc=xmldoc /TrackRequest Chr(13) Chr(10) oXMLDocument.loadXML(xmldoc) oXMLServer.open (POST,https://www.ups.com/ups.app/xml/Track,False) oXMLServer.send (oXMLDocument) MsgBox(oXMLServer.responseXML.xml) End Sub Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, August 26, 2005 11:30 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] XML and Accuterm I wrote on 25/08/2005 19:42:13: In my original post, I admitted to not actually using Accuterm. I was basically saying that if Accuterm supported VBA then it should definitely be possible to send and receive XML just as you could in VB. I've since been on the Accuterm site just to check what it can do. It does seem to have the capability to use VB object libraries and here's a URL link to a page on their site which goes into a lot of detail: http://www.asent.com/email_white_paper.htm As for the actual code to send and receive XML, I will need to dig that out of an application and I'll post it tomorrow hopefully. I promised some pointers to sending and receiving XML using a Windows application such as Accuterm that supports VBA. Here is a link to a page on Microsoft's site that gives some ASP examples: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/xmlsdk/html/e5c17f89-0197-496c-9164-ce0bbbd8490f.asp Where the code has: var objSrvHTTP; objSrvHTTP = Server.CreateObject (Msxml2.ServerXMLHTTP.3.0); the VB equivalent that you would use would be something like: Dim oXMLServer As Object Set oXMLServer = CreateObject(Msxml2.ServerXMLHTTP.3.0) The last example on the page shows how to send and receive XML. The syntax is visual basic so it is identical to using the UniObject Libraries. You need to be aware that if you go down this route then every Accuterm client PC that requires the functionality would require the XML library installing locally (or the DLL registered). This is one of the reasons why getting code to execute on the server is preferable. In order to get hold of the library, go onto Micro$oft's site and do a search for MSXML from the Download Centre. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML and Accuterm
Interesting. If you have a registered ActiveX or DLL, then you can create an instance of it using 2K and 2K2's VBA scripting. You also will need documentation on the methods and elements that the object contains. I've been using 97 for many years now, so I never knew about that. I just recently upgraded to 2K2. Thanks for the info. So, there is a possibility to use an ActiveX object that can post and retrieve XML documents. The white paper is specifically for integrating Accuterm into Office, with a focus on Outlook. In order to post and retrieve XML documents, the ActiveX control or DLL will have to do that behind the scenes. Maybe there are some free or non-free controls out there specifically for that. I dunno. I still prefer to do things like that from MV using platform independant tools Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Thursday, August 25, 2005 2:42 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] XML and Accuterm In my original post, I admitted to not actually using Accuterm. I was basically saying that if Accuterm supported VBA then it should definitely be possible to send and receive XML just as you could in VB. I've since been on the Accuterm site just to check what it can do. It does seem to have the capability to use VB object libraries and here's a URL link to a page on their site which goes into a lot of detail: http://www.asent.com/email_white_paper.htm As for the actual code to send and receive XML, I will need to dig that out of an application and I'll post it tomorrow hopefully. Regards, Rob Wills (rob dot wills at tigerinfotech dot com) [EMAIL PROTECTED] wrote on 25/08/2005 15:20:08: In a message dated 8/25/2005 12:41:26 AM Pacific Standard Time, [EMAIL PROTECTED] writes: VB including using standard Microsoft XML libraries which include methods for sending and receiving XML via HTTP Do you have example code where you do this? Thanks I would also be interested in seeing any examples you have of that. thanks Victor St. Clair --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] XML and Accuterm
Why bother with Accuterm? You can do what you want straight from the command line using BASIC. I'm pretty sure that Accuterm has no capability to perform socket connections using scripts. It has VBA(Visual Basic for Applications) capabilities, which is nothing like VB. You could write an XML bridge in VB or VC++ and then load it. Using a DDE server in the application, you can post DDE client requests from Accuterm to the application using VBA calls. However, that's like building a speed bump out of glass. It'll do the job, sort of, but it'll end up breaking at some point and cost way too much time and money to build in the first place. Here's a (extremely trimmed) UPS XML tracking example I've done with cURL and directory Q-pointers under D3. Took me about 30 minutes to implement it. tbuffer=fill in this with the XML request header and document open 'tmp' to tmp.f else stop filen=tracknum:rnd(100):.txt write tbuffer on tmp.f, filen CMD = '!curl -s -H Content-type: text/xml https://www.ups.com/ups.app/xml/Track -d @/tmp/':FILEN EXECUTE CMD CAPTURING OUTPUT EXECUTE !rm -f /tmp/':FILEN CALL XMLPARSERSUB(OUTPUT,ELEMENTS,'0') LOCATE TrackResponse.Shipment.Package.Activity.Status.StatusType.Description IN ELEMENTS1 SETTING VM THEN PACKAGEACTIVITY = ELEMENTS3,VM END Since curl runs on just about all platforms, this is a cross-platform solution. Glen http://mvdevcentral.com http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Wednesday, August 24, 2005 6:53 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] XML and Accuterm In a message dated 8/24/05 1:04:59 PM Pacific Daylight Time, [EMAIL PROTECTED] writes: An XML request for what? Can you give us an example of how you would use that? XML is just a blob of text so it's no different than any other text. Here is a name, look up this person's address, using an internet service. The internet service can read XML and respond in some way. I can write the XML, I just don't have any examples in Accuterm script of people sending and getting a response. So I'm anticipating some sort of code like Response = SendHttp(myhttpstring, wait=5 seconds, error) If error then quit else ProcessResponse(Response) Thats all I'm really looking for is an example of sending and receiving back the response. Thanks Will Johnson --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [OT?] SATA vs SCSI drives
This totally depends on the chipset manufacturer. A $50 Adaptec SATA card isn't going to burn a hole in the case. Our Opteron file-server box is running a 320GB Barracuda RAID 5 on a 64-bit 3ware controller. It smokes every Adaptec SCSI RAID I have on site with ~500MB/sec read throughput and near 300MB/sec write over FTP on a 100MB full-duplex switch. For the best money/speed, SATA RAID is the way to go. For the overall best in speed, consider a multi-channel high-end SCSI system. Fiber is definitely the cleanest, but it's not cheap. A few thousand in drive hardware costing and you'll probably end up reviewing and comparing SATA again. :P But hey, if you've got the money, go full-blown 64-bit multi-channel SCSI. Keep in mind that when a 200GB drive dies on a SATA array, you're only out $150-200. Compare that with lower capacity 15K RPM SCSI drives running $400-$600. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Claus Derlien Sent: Tuesday, August 02, 2005 4:54 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] [OT?] SATA vs SCSI drives first of all, i can't give definitive information only information about our experience with the two different kind of i/o subsystems. We have two identical servers cpu/os but on the test server we have SATA drives in a no raid configuration on the production server we have SCSI in raid 1+0 configuration, and the speed in database operations is far better on the SCSI system than on the SATA system... When we test with multiple users and heavy batch run on the SATA system we have experienced i/o freeze for up to 3 seconds, on the SCSI system our users can't even detect a heavy batch run... I can't imagine you will ever get SCSI performance out of a SATA drive unless you are on a single user system, the primary benefits of a SCSI subsystem lies in its ability to command tagging and sorting according to drive geometry, thus enabling multible users read/write requests to be sorted for best usage of the drive. Some of the sorting of i/o commands will be handled by the OS, but to be fair, SCSI drivers have been under heavy scrutiny for best performance for more than a decade, so SCSI drivers will probably still be somewhat ahead of SATA drivers.. best regards from Denmark Claus Derlien -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ross Ferris Sent: Tuesday, August 02, 2005 3:48 AM To: u2-users@listserver.u2ug.org Subject: [U2] [OT?] SATA vs SCSI drives Somewhat off topic I know, but does anyone have any definitive information re these 2 technologies? Traditionally I've always used SCSI drives, as many years ago we discovered that although the specs if EIDE looked good on paper, in practice they were sub-optimal. Whilst I could do my own tests (have just installed a Windows/SATA box), I figure others here may have already done the investigation work. FWIW I'd just be looking at a little IBM x306 with RAID level 1 via the integrated RAID SATA - nothing too punishing, only around 50 users (anything more and I'd just feel safer with SCSI), and no external cache to the drive. Once more, on paper I see transfer rates of 1.5Gbs vs 320 on U320 SCSI drives, but slower RPMs on the SATA to the 15K SCSI's, so I'm guessing (know in my gut?) that SCSI makes sense, but ... Any comments from people who have kept more abreast of hardware than I have are welcome :-) Regards, Ross Ferris Stamina Software Visage - an Evolution in Software Development --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ ** ** Denne mail er blevet scannet af http://www.virus112.com ** ** Frie Funktionfrer - faglig organisation og tvfrfaglig a-kasse - www.f-f.dk ** * Denne email og alle filer vedlagt som bilag kan indeholde fortroligt materiale, der kun er beregnet for adressaten, og maa ikke udleveres eller kopieres til uvedkommende. Har De ved en fejltagelse modtaget denne email, bedes De venligst omgaaende meddele os dette pr. telefon : 6313 8550. Paa forhaand tak. ** * This email and any files transmitted with it may contain confidential information intended for the addressee(s) only. The information is not to be surrendered or copied to unauthorised persons. If you have received this communication in error, please notify us immediately by telephone: +45 6313 8550. Thank you.
RE: [U2] pcl to pdf converter
A direct PCL to PS conversion is dirty and mangled. You may or may not get exactly the same results between the two on their respective hardware. Ghostscript is free and will do a good job, for a huge range of conversions on *nix or Windows. I highly recommend using it to get your initial design and testing done for the documents. If you want to pay for a shrink wrapped package, then make sure you know exactly what you are getting out of it. Send the vendor some sample PCL and have them e-mail you the PS/PDF results. A custom PCLPS filter is usually employed and everyone writes theirs differently. You may be surprised at the quality drop when you convert a raster based PCL document into a vector based EPS/PS/PDF document. I've been fighting that battle myself for years, converting our old PCL docs into PS/PDF. I've gotten most of our documents stored as HTML templates and EPS images now. html2ps converts them over to PS and I let ghostscript generate PDFs when I need an e-mail or portable file. Glen http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Curt Sent: Thursday, July 28, 2005 12:08 PM To: u2-users@listserver.u2ug.org Subject: [U2] pcl to pdf converter I have a customer that prints invoices on an HP Laserjet justing PCL. Now they want to email the invoices as a PDF file. Does anyone have a suggestion as to a reliable and reasonably priced product that will convert a file containing PCL to a PDF under Universe currently on NT4, but shortly on Win2k3. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] THE variable names
I'm just wondering who comes up with this stuff. Those who use the language to it's most interpretable form. I have seen general BASIC programming instructors focus on the use of non-cryptic, non-abbreviated variables, instead of compact code. Afterall, the pcode generated is the same for THE.CUSTOMER.CITY as it is for CCITY or CUST_CITY. Which can you comprehend the quickest at a glance? You can also parse your own code, if you have a delimited variable structure that is consistent throughout the entire project. All good things, unless you're main focus is keeping the code short and cryptic. I have to agree, though, that THE is not really a useful variable keyword. It does help with programmatic variable identification, though. To each his own. Also, was there ever any lack of faith in the READ statement when assigning the variable REC. I'm now seeing some of this: REC= ; READ REC FROM FILE, ID ELSE REC= I use the else null clause religiously under D3. I have seen numerous accounts of read failures not resetting the target variable. The program chugs along happily with data from a previous read and it eventually blows up for a seemingly unknown reason. The extra null assignment is overkill, unless it exists once at the start of the program to prevent variable not assigned run-time notices. Glen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] OT: AVG
Sorry to see you had such bad luck. I've been running it on 30+ PCs with varying versions of Windows and never had it once crash a PC here. I have the network admin version, though. Some of the earlier editions of the personal free software were a little flaky and problematic, but the recent for-fee versions have been very stable even on older P3 boxes running Win98. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony W. Youngman Sent: Monday, July 11, 2005 4:06 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Recursive gosub subroutines and for/next loops In message [EMAIL PROTECTED], Glen B [EMAIL PROTECTED] writes Yay, another AVG fan. You can disable the outgoing tags for OK messages. :) And a very ANTI AVG guy here ... having had it trash my mother's system. I hate supporting Windows at the best of times, and having to fix that system down a phone line when I've never used the product and have no experience of it - NOT a pleasant experience. Glen Cheers, Wol -- Anthony W. Youngman [EMAIL PROTECTED] 'Yings, yow graley yin! Suz ae rikt dheu,' said the blue man, taking the thimble. 'What *is* he?' said Magrat. 'They're gnomes,' said Nanny. The man lowered the thimble. 'Pictsies!' Carpe Jugulum, Terry Pratchett 1998 Visit the MaVerick web-site - http://www.maverick-dbms.org Open Source Pick --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] OT: London
Same sentiments here. I hope that all is well. -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Hennessey, Mark F. Sent: Thursday, July 07, 2005 3:07 PM To: u2-users@listserver.u2ug.org Subject: [U2] OT: London I know some of the subscribers on this list are from the UK. I want you to know that our thoughts and prayers are with you today. Mark Hennessey State of Connecticut DSS/MIS Child Support Systems Voice: 860-424-5261 Fax: 860-424-4956 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Recommendations for reporting tools
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno Sent: Tuesday, June 07, 2005 6:11 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Recommendations for reporting tools Mark Ballinger mballinger-at-ballinger.cx |U2UG| wrote: On Tue, Jun 07, 2005 at 07:42:51AM -0700, Dave S wrote: You can purchase it from this company : http://www.sandritech.com/ Yes, I know. I'm just wondering what it costs. The best way to find out what products cost is to contact the supplier. Sandritech in particular has a good group of people and I'm sure you'll get good info, product, and service with them. I'm not one to support senseless cloaks of secrecy (I hate not seeing a price tag on items in a store) but there are many reasons to not publish pricing info. Retail and software services are two totally different styles of markets. However, a lack of base pricing will more than often deter prospective customers from inquiring on products. People are lazy these days, especially with the reduction in staff that most businesses are running under. The easier you make it for the buyer to shop and compare, the more likely you will be to get a sale. Do the comparison legwork yourself and post a price comparison by feature. I'll bet you sell more product that way, even if you are more expensive. Make sure you keep it updated, though. There's nothing worse than pulling up a comparison table to see it's 4 years old and the features list is 3 versions old. Pricing for some of these software products can vary widely depending on the VAR, their value-add in terms of support, training, etc, location, bundling, and many other factors. I might offer a well known product at cost if we agree to short or long term services or a training engagement. I might waive support fees for some period of time or offer an add-on component for less than list cost, not to mention quantity discounts. This is always an issue and everyone who is involved with buying software licenses and support understands that published pricing is only a top-level guide, not a real quote. However, published pricing is the only way to narrow down the huge list of software possibilities to those that fit in the general realm of a companies budget. I don't bother calling a small software firm for a price quote, if there is no published base pricing for their standard product. It could be a lot cheaper, but I don't have time to call 20 small software companies and get accurate price quotes to then narrow it down to 2 or 3 that fit our budget and feature requirements. If we let 'list price' stand as any guide by which we judge products then I dare say we'd consider a whole lot of products unworthy of further investigation, and these negotiable would never even be put on the table - I've seen it happen. If you sell any kind of product or service, you must have base pricing. Anyone who doesn't show it should either be the only one in their market or have an established name in the market. Selling cars with no window pricing is fine because you can touch what you are comparing and you can always pull out the Kelly Blue Book to see what the base prices are. You can't do that with software, unless you spend weeks getting quotes for features from every software vendor out there. No one in their right mind will do that, except maybe a consumer reporting group like CNET or a magazine. Typically, though, consumer reports are biased towards the advertisers that pay their salaries. Still, the deciding factor is going to be the overall feature/price point. Companies that know their market and know their price points can show base pricing without pushing away prospective buyers with high estimates or misleading weary shoppers with under-average pricing. A price that's published today may change tomorrow. You don't want to prospects to be discouraged by a price they see in a forum when the price isn't what was posted anymore. Also, sad but a fact of life, many companies use list price as one of their key differentiators to raise or lower their own pricing to find a competitive sweet spot. If someone publishes pricing in a public forum it may mess up the vendor's competitive positioning, and even encourage other vendors to just raise their own pricing - I've seen this happen too. That's because a lot of software vendors do not perform any kind of demographics to determine their price points. If you're going to sell a product in a market with a lot of competition, then you need to know what your min, max, and average pricing should be based on the competition's market share and the products they are offering. If I opened a hardware store next to an ACE store and offered the same products at the same price, then I'd never sell anything. On the flip-side, if I set my pricing 30% lower than ACE then I'd need to sell a LOT more product(lower
RE: [U2] Uniobjects hack
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, May 27, 2005 10:56 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Uniobjects hack The ability to bypass application security using UniObjects has really got me thinking. In the absence of any suitable remedies and perhaps as a stop gap solution whilst a better solution is written, I would recommend the following: 1. As Martin said, make sure that you do not let UniObjects traffic through your firewall. This cuts down the threat from outside but many hacks come from employees who are disgruntled or just plain nosey. 2. If you don't require UniObjects on all PCs then don't install it. If you do require it, don't install the documentation that gives the user a sample application to copy. Change the standard port used by UniObjects and don't advertise it. You can still sniff out open ports easily. Your best bet is to map port access by IP class range and exclude departments that don't need access. Of course, if the network is all over the place then you'll need to specify filtering by IP. 3. Consider an architecture where the UniObjects client is a separate server (e.g. web server or Citrix server) and users don't require the UniObjects DLLs on their own client. This is also easier to maintain when you upgrade. DMZ setup is still a big part of the equation if you use a remote machine to host a connectivity portal. The only problem there is traceability, if someone where to hack into that box and gain root/admin privs. The same can be said for any box on the LAN, except you won't be looking for oddball IP-based activity if it's all coming from one machine. :P 4. In addition to application security, make use of OS security. For example, if your HR system is only used by a handful of people, don't give all your users access to the data files and rely on the application security to keep them away. If they have to steal a password as well as write a VBA program, it is harder than just writing a VBA program. 5. Don't hard code usernames and passwords into your source code! They can be seen in the object code of any application. You can concatenate raw characters together to form a username or password, and you won't be able to easily pull the object code up in hexedit and look for stored strings. You can also use an internal character shifting algorithm to make it harder to dechiper what's what in the object code. 6. Keep an eye on logs and look out for unusual behaviour. Can anyone help me with this? What logs are written to when someone logs in and can you distinguish between a telnet login and a UniObjects login? If you are firewalling the box, then you should be able to log incoming traffic regardless of destination port. If not, then setup a firewall router that can log and report activity. A 586 with 32MB of RAM will run a Linux firewall just fine. Glen http://mvdevcentral.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] To Cron or Not To Cron?
cd /etc grep -r programname * Glen http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin King Sent: Monday, May 23, 2005 3:41 PM To: u2-users@listserver.u2ug.org Subject: [U2] [UV] To Cron or Not To Cron? I have a client system running UV 9.6 on Linux, and sometime between midnight and 4am in the morning, there's a job getting started that is horking up some data. I've checked cron and I'm not seeing anything getting started there, any other ideas where I should look? UV itself doesn't have a scheduler, does it? -Kevin HYPERLINK mailto:[EMAIL PROTECTED][EMAIL PROTECTED] http://www.PrecisOnline.com -- No virus found in this outgoing message. Checked by AVG Anti-Virus. Version: 7.0.322 / Virus Database: 266.11.15 - Release Date: 5/22/2005 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Include Vs Call - Software Maintenance
Functions are only useful when you are returning a single piece of data. Most of the designs I've written take advantage of multiple, bi-directional parameters. If you need to limit scope of the branch to a single local variable, then a function is good way to limit cross-contamination that subroutines can cause. You can still muck things up by assigning the same variable as the parameter being passed through the function. Reusing a variable on the same line is a naughty habit. I try to pinch myself every time I think about doing it. I think that there may be a memory limit, on some flavors, for the returned data of a function. I'm not 100% sure about that, but I think I remember a discussion elsewhere about the pro/cons of functions. I don't see why the call stack would be that different from a subroutine, so maybe I'm dreaming again. Glen http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mark Johnson Sent: Thursday, May 19, 2005 9:58 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Include Vs Call - Software Maintenance snip This reminds me of computer science class and the concepts of coupling and coherence (http://c2.com/cgi/wiki?CouplingAndCohesion). I need a UniBasic program that uses a lot of code from another program. snip I agree with ed's view on INCLUDES and SUBS. I wish this was more prevelant during the early 80's when most of my clients' code was developed. It's hard to backfill better ideas into existing code, especially with useful sharing concepts like INCLUDES and subs. I've seen 300 line coded INCLUDES (as opposed to declaration-style) that are very awkward as the primary program will say GOSUB 800 and 800 is in the INCLUDE. Very hard to follow. Plus, Microdata botched up INCLUDES as you gave up useful run-time errmsgs. Plus, their net source code had the 32k limit anyway. This causes me to think of the complement to subs and that is functions. Functions are quite useful in VB (et al) yet don't show up at all in legacy code and don't get that much airtime here on this forum. I've only ran into them once on UD when hooking into Redback. Every time I write a SUB that really is a function in purpose, I tend to name it GET.PRICE or GET.USER or GET.PRINTER etc. So are functions a kept secret in MV programming or has no-one had any issues with them? I'd like to know so I could either get better with them or ignore them and continue with subs. Thanks --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UV on Linux
Keep in mind that I'm not a certified Linux engineer. :P The only file I/O problem I know of, with 2.4 kernels, is the buffering issue. All kernel block devices are buffered by the kernel, unless they are bound by a raw device binding. This could be the culprit in the driver's bottleneck situation. Try binding a partition to raw, on that disk array, and then perform some high-speed read/write tests. You might be surprised at the throughput difference. raw -qa lists all bound block devices. I don't recommend raw bindings to be done when neither the hardware, nor the software writing to disk handles I/O buffering. You may end up making it worse. In my case, I have a fast caching RAID controller and D3 has a write buffering system in place. When the kernel jumps in and buffers too, things go wacko and user response drops to between 15 seconds and 1 minute under normal disk activity. That's for 25 users on an AMD 2+Ghz with 1GB ECC. I don't know if UV/Linux caches its own writes and reads. If it does, then using raw bindings should help with disk throughput by eliminating the middleman. Don't hold me to that, though. PS: Changing the kernel file-max will only increase the number of files that can be open at a time. If you have a well trained disk subsystem then it's kosher to do that, because the kernel probably won't have to use swap for buffering. Mine happens to be 104851 and it's been chugging along for a couple years now with no disk I/O problems. When you pound on swap ontop of a continuous heavy I/O load, then you're just begging for a kernel panic. According to the Linux configuration guide, you should set file-max to 256 files per 4MB of memory. 1GB would be (250 * 4MB) * 256 files = 64000 for file-max. Of course, you can tweak that number up until you hit a swap or disk subsystem threshold. Your box should only use a small amount of swap under normal operating conditions. If it is using over 25%, then it's time for more memory! Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Anthony Dzikiewicz Sent: Friday, April 29, 2005 3:58 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] UV on Linux We have been live since October. Everything is fine at the Universe level. We havent had any major issues at all. One thing we used to do to get users off at the end of the night or when needed is to do a 'MASTER OFF ALL'. It doesn't work on the Linux version. Other than that, Universe is peachy. I find that support for Linux is generally lacking. Red Hat support is 'alright'. We have RedHat support thru IBM, which is much better than the RedHat support (IBM is usually a knowledgeable person that speaks English very well vs the RedHat guy who is not always very knowledgeable and has an accent that requires a special hearing device to interpret). IBM support is cheaper too. We keep RedHat for the up2date functionality and the resources they have. It really is a nice way to keep things current. Are you using all Dell Hardware ? We are running an IBM xSeries Server and an EMC Clariion. We are having performance issues with intensive writes to the disk array. There is a minor issue with this when doing the same kind of operation on the internal disks. Intensive disk writes could be an batch application that reads records from one file, deletes and writes to another (say 100,000 records type 30 files with indexes). We do this for archiving data. It could be a linux 'cp' command copying a large file (100meg) to the disk array. What happens is that the system goes into an iowait state and user response is non-existent. Sometimes, the system will hang for close to a minute until the i/o completes. We are also using Qlogic 2340 HBA's to connect the IBM to the Clariion. If you look thru the RedHat Bugzilla, there have been issues with the driver for this hardware. We will be testing out some Emulex cards next week to see if that improves things. If you have the luxury to evaluate your system, definitely try copying some large files or 'archiving' type processes while users are on. Monitor performance with the 'top' command. Then determine if things are acceptable. We converted from a DG/UX box with a Clariion. Performance was never really an issue on that platform and these types of operations would absolutely go unnoticed. EMC has been trying to help with the issue since February. I have to say that their support SUCKS !!! It seems that there is no one there that knows anything about Linux. I am finding this in general. When you mention that you are running Linux, a dark cloud appears. So, you probably will not get the excellent type of support that you might be accustomed to with Solaris. I would assume that you like Dell support ? My experience with them is that they went from once upon a time very good (8 years ago or so) to the pits. Every time I call, I get transferred
RE: [U2] MvInternet - IBM Licensing Requirement
The gotcha there, is the fact that you *know* that 500 employees are using the DBMS simultaneously via 2 seats. If you said, I _know_ that no more than 10 employees are using the software at any given moment and I have 10 licenses to justify that, then there would be no problem. Whether or not it appears that 500 can use it within realistic timing is a completely separate investigation. The truth is, if you only have 10 seats then there can only be 10 active processes on the box at a time. The days of user=process are gone. It's time to wake up and realize the world has changed already. MV is always the last to smell the coffee burning. This thread is really getting moldy guys. The fact is, user-seat licensing and pooled licensing mix together like alcohol and mercury. There's a cost-per-unit sales problem inherent there. Either you loose all your single-seats to pooled muxes or you end up fighting the single-seat mux wars. IBM can try it, but I know it won't work. It's time for a CPU based license model, for those who want to configure MV for a non-persistent services model. There's no other realistic solution. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dean Fox Sent: Monday, April 18, 2005 7:54 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] MvInternet - IBM Licensing Requirement What people are doing is through special programs and queuing where they can run several users continuously with several background processes that stay active. This is what IBM has frowned upon. - My brain wiring doesn't allow me to separate this scenario from real life either. None of this falls under the rules of Piracy ie running one Microsoft Word on multiple PCs. That's spreading FUD and is so far off the point cannot be addressed directly. Look at it this way. I have 500 employees and I pay two full time people to do nothing but run reports for whoever dials their extension and makes a request. These two employees are logged in all day, they remember, manage and distribute the hundreds of requests they get all day. That's all they do. Does your scenario suggest I need 500 licenses rather than two? If not, how does this differ from web services running even from within UV? Is the difference human vs. program? I fully understand the loss of revenue to IBM argument. I'm not going to pay taxes I don't owe either. If I can replace a person with a program, a telephone extension with a web interface, I have saved my company money and have cost IBM nothing I didn't owe before. I'm just more productive. I failed ethics in college. I was failing my second attempt until my Professor gave me a clue. The test questions are supposed to be grey he said, your problem is Dean, you don't think like a criminal. And, I'm still confused today. If I replace a person with a program and a telephone extension with a web interface, do I go to jail or get promoted? What I'm hearing is jail. But my brain isn't wired to understand why. -[d]- On 4/18/05, Tony Gravagno [EMAIL PROTECTED] wrote: Until I saw Dean's posting I was also going to just let it go. The trigger for me was the equating of multi-user license usage to running multiple copies of software on different systems. Copying software allows more than one person to execute different functions at exactly the same time. All DBMS products are engineered to allow us to perform the following sequential functions: Accept connection and query Read state data from cache or disk Perform operation on all data Write state data to cache or disk Respond to user and disconnect This is the way web servers work and one common way of engineering a disconnected client/server model. There is no physical way that anyone process can perform those functions for two users simultaneously, the way two instances of pirated software does. All users must wait for any user consuming a license to disconnect before they consume the license in their own turn. The terms connect and disconnect may imply logging in or simply going inactive as someone else consumes the license resource - the point is that the way MV platforms are engineered, only one user can make use of the resource at any given moment in time. This use of licenses has a long standing legal precedent, here are two examples: Modems which came into use in 2nd to 3rd generation systems allowed one user to connect and then disconnect, followed by another user who did the same. Per-seat licensing, compared to named user licensing has always acknowleged this paradigm. Today, if we choose to allow one user to consume that license for a period of 2 hours before giving it up, or 200 milliseconds, that is a matter of design. There are no set standards for how long a user must consume a license in order to be considered legal, except where software
RE: [U2] Factory Floor Automation - Serial Connectivity ?
You can perform socket connections from UV and read/write directly from/to a TCP service. I agree that Lantronix makes nice equipment. The 802.11b dual-port box would work fine if you had a wireless access point to hook back into the LAN. The question comes down to laying cable or not. I would perform a signal test using a Laptop + PCMCIA card and an access point positioned near a permanent spot, for each area you planned on installing an 802.11b serial bridge. Poor signal = poor/no results = more money for antenna hardware. That's still cheaper than running cable and chaining high-grade switches as repeaters. There's so many ways to go about it all. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, April 11, 2005 4:12 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Factory Floor Automation - Serial Connectivity ? Replying to my own messaging... Kind of like talking to myself... With newer UV versions you shouldn't need the C socket program but be able to talk to the device server directly. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Monday, April 11, 2005 3:43 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Factory Floor Automation - Serial Connectivity ? At my last job, we often had to talk to laboratory instruments (bi-directional interfaces) that primarily serial based. We'd use single port Lantronix device servers (MSS-100 or UDS-100) which are basically single port terminal servers. On the host end we had a socket program that could talk to the device. From there you use a socket program on the UV box, and a phantom that talks to it. Pretty painless all in all... The lantronix boxes are often on ebay $50 if you wanted to try one out without getting in too deep. Short version: Machine (serial) - lantronix - network - C socket pgm - UV phantom I'm sure there are numerous other ways to do it as well without needing full pc. This is just one way we used. Enjoy, Robert --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] send data to IP address?
Don't make it so complicated! First, read the user guide and see all the nice protocols and services that Zebra has put into that overly expensive print server. ;) (Check out the D-Link DP-301P+ for ~$60 if all you need is a web-maintainable Parallel-to-TCP/IP raw spooler) Then, use the FTP service on the Zebra print server to transfer a local spool file over port 21. It'll print as soon as you send it. If you have a lot of labels being printed, you can have a phantom running that stays connected to the FTP service and transmits a local file spool. Make sure you send a keep-alive note of some kind periodically. Otherwise you may get kicked off for being idle. Or, you can connect and send on-demand like this(excuse the UV-izms I may be missing in the open/close calls): OPENPATH C:\zebraprintjobs TO ZEBRA ELSE CRT CAN'T OPEN ZEBRA SPOOL STOP END PRINTERIP=192.168.0.250 PATHTOJOB=C:\zebraprintjobs\ PRINTJOB=zebra:DATE():TIME():RND(100):.txt ! FILL OUT LABELREC WITH LABEL SCRIPT WRITE LABELREC ON ZEBRA, PRINTJOB ! CMD = ftp :PRINTERIP DATA put :PATHTOJOB:PRINTJOB DATA quit EXECUTE CMD DELETE ZEBRA, PRINTJOB CLOSEPATH ZEBRA Of course, you really should stick some error checking code in there to make sure the connection and job send actually worked. :P Glen http://mvdevcentral.com http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik Sent: Friday, April 01, 2005 5:29 PM To: 'u2-users@listserver.u2ug.org' Subject: RE: [U2] [UV] send data to IP address? Does UV 9.6 have callhttp? If the print server is a jetdirect workalike you can just open port 9100, send your data and close port 9100 at the Actually, now that I have done a port scan on this device, it apparently IS listening on port 9100. However, the same technique that produces output on a networked HP 4200 does not produce any results on the Zebra. I am missing something. Barry --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
[U2] MV Developer Central
I've finally gotten MV Developer Central back together, under Gforge 3.3.0. Stop by and check out the site. If you got my site e-mail the other day about updating your profiles, then please do it again. I had to redo the database right after sending that, after I messed up a table trying to manually import some other content. Sorry for the inconvenience. 'Site Chat' is now available from the home page. This is a general meeting room for anyone visiting the site. I plan on having an MV based chat bot running, that can answer some questions. I need to dig it out of the closet and clean it up. You can use the CGI-Web (firewall safe) chat client by clicking the long submit button or use the info provided on the chat page with your favorite IRC client. Most of the site is open to the public. You will be required to register, and sometimes be a member of a particular project, to access certain parts of the site. If you have any questions, feel free to send Site Admin an e-mail. I get all the e-mail sent to that member. You can also send me pickcoder e-mail. I have a few more of my own projects to register. One of them is a Perl phone call logging and reporting tool for Toshiba SMDR. Part of that is already posted on PickSource. I'm going to be adding a reporting tool. Another project is my MV Precompiler. I've started writing a precompiler base for everyone to build upon. This project is focused on reducing cross-flavor code base management. I have plans for plugin handling, as well as developer subroutine substitution for standard BASIC functions like OPEN, READ, WRITE, etc. I'm still pondering the idea of a code conversion tool, which will take standard dataBASIC and generate directive code from it. First things first. Glen http://mvdevcentral.com http://picksource.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MV Developer Central
I've just been informed of a registration problem with the user accounts. I don't even know where to start on that. I'll have to contact the developers. *pulling out hair and cursing GForge* Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glen B Sent: Wednesday, March 09, 2005 9:30 AM To: U2-Users Subject: [U2] MV Developer Central I've finally gotten MV Developer Central back together, under Gforge 3.3.0. Stop by and check out the site. If you got my site e-mail the other day about updating your profiles, then please do it again. I had to redo the database right after sending that, after I messed up a table trying to manually import some other content. Sorry for the inconvenience. 'Site Chat' is now available from the home page. This is a general meeting room for anyone visiting the site. I plan on having an MV based chat bot running, that can answer some questions. I need to dig it out of the closet and clean it up. You can use the CGI-Web (firewall safe) chat client by clicking the long submit button or use the info provided on the chat page with your favorite IRC client. Most of the site is open to the public. You will be required to register, and sometimes be a member of a particular project, to access certain parts of the site. If you have any questions, feel free to send Site Admin an e-mail. I get all the e-mail sent to that member. You can also send me pickcoder e-mail. I have a few more of my own projects to register. One of them is a Perl phone call logging and reporting tool for Toshiba SMDR. Part of that is already posted on PickSource. I'm going to be adding a reporting tool. Another project is my MV Precompiler. I've started writing a precompiler base for everyone to build upon. This project is focused on reducing cross-flavor code base management. I have plans for plugin handling, as well as developer subroutine substitution for standard BASIC functions like OPEN, READ, WRITE, etc. I'm still pondering the idea of a code conversion tool, which will take standard dataBASIC and generate directive code from it. First things first. Glen http://mvdevcentral.com http://picksource.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] MV Developer Central
OK. I fixed the new user registration problem. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Glen B Sent: Wednesday, March 09, 2005 9:30 AM To: U2-Users Subject: [U2] MV Developer Central I've finally gotten MV Developer Central back together, under Gforge 3.3.0. Stop by and check out the site. If you got my site e-mail the other day about updating your profiles, then please do it again. I had to redo the database right after sending that, after I messed up a table trying to manually import some other content. Sorry for the inconvenience. 'Site Chat' is now available from the home page. This is a general meeting room for anyone visiting the site. I plan on having an MV based chat bot running, that can answer some questions. I need to dig it out of the closet and clean it up. You can use the CGI-Web (firewall safe) chat client by clicking the long submit button or use the info provided on the chat page with your favorite IRC client. Most of the site is open to the public. You will be required to register, and sometimes be a member of a particular project, to access certain parts of the site. If you have any questions, feel free to send Site Admin an e-mail. I get all the e-mail sent to that member. You can also send me pickcoder e-mail. I have a few more of my own projects to register. One of them is a Perl phone call logging and reporting tool for Toshiba SMDR. Part of that is already posted on PickSource. I'm going to be adding a reporting tool. Another project is my MV Precompiler. I've started writing a precompiler base for everyone to build upon. This project is focused on reducing cross-flavor code base management. I have plans for plugin handling, as well as developer subroutine substitution for standard BASIC functions like OPEN, READ, WRITE, etc. I'm still pondering the idea of a code conversion tool, which will take standard dataBASIC and generate directive code from it. First things first. Glen http://mvdevcentral.com http://picksource.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Forcing a port to close
Nick, I looked this up in the socket guide and the syntax is correct. The only real issue that can arise by enabling address re-use is the slim possibility that partial data could be received into the socket buffer, from the sockets that were never shutdown down properly. This can lead to confusion in the application and/or the socket subsystem. I've never had that issue occur, but the possibility of the condition should be known. Just for clarity in future reading, socket shutdown and close are not synonymous. Close refers only to the release of a file handle. A handle can be closed and re-opened on the same socket address. Shutdown refers to the releasing of the file handle and also the addresses used by the socket. Glen http://picksource.com http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina Sent: Friday, February 25, 2005 8:29 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Forcing a port to close This is exactly what I am getting. The process is stopped, but for whatever reason, UniVerse is not closing and cleaning up the port. The program in question has LOGTO statements in it, and I think that it is causing itself to get crossed up on the socket port. If I include the following statement, will it help: X = setSocketOptions(SOCKETHANDLE, REUSEADDR : @VM : 1) Thanks, Nick Cipollina -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Thursday, February 24, 2005 6:13 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Forcing a port to close This is a typical socket address condition that can't be safely overridden by hand. If you look at your net stats, the socket in question is probably in a CLOSE_WAIT state. This is a subsystem status that says the remote has shutdown and it's waiting for the socket to close and cleanup. If the socket gets dumped improperly by the socket application, then the socket can be left in CLOSE_WAIT with no process attached to finish cleanup. The status will clear up, but it could take a long time. That all depends on the tcp_close_wait setup and whether or not the socket is setup with the SO_LINGER flag. If the socket's SO_REUSEADDR flag can be enabled using some kind of U2 setsocketopt function before you listen on it, then you can re-use the same socket address over and over again. Check out this sockets FAQ: http://www.unixguide.net/network/socketfaq/ Glen http://picksource.com http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina Sent: Thursday, February 24, 2005 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2][UV] Forcing a port to close Is anyone aware of a way to force a socket port to close at the operating system level. We are currently using Sun 9.xx. We have a process that opens a port and accepts socket connections. Whenever we stop it and try to restart it, we get a port in use message. The only way that I've been able to get it to release the port is to stop and start universe again. I'm just wondering if there is a way to force the port to close. Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Forcing a port to close
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Friday, February 25, 2005 11:32 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2][UV] Forcing a port to close setting option SO_REUSEADDR, has a number of uses, one being that if the listening gciserver is killed and there are still live connections, a new server can be started. Without this option the system will return error address already in use. This condition is typically encountered as follows: a) a listening server is started b) a connection request arrives and a child process is spawned to handle that client c) the listening server terminates but the child continues to service the client on the existing connection d) then an attempt is made to restart the listening server (will fail with address already in use due to client connection) SO_REUSEADDR also allows two listening servers to be started for the same port no, but specifying different ip addresses (if hosts has mulitple addresses). However we can still only start one server for each ip address available to the machine This is true. I have never heard of the shutdown issue mentioned below. I have been writing socket applications for a long time and use SO_REUSEADDR and have never come across this issue. Shutdown(in my terms) refers to the bi-directional termination of a TCP connection, not just the release of a socket handle. You can also shutdown() a socket, but that only partially closes the socket. shutdown() blocks recv() functionality, while still allowing send(). This is a great method of connection controlling that a lot of coders overlook. I didn't see it listed in the U2 sockets API, but it is available under most programming languages. If you've always used the flag, then CLOSE_WAIT makes no difference. However, if you see a LOT of connections in CLOSE_WAIT on your service port, then you should check your code. Something is definitely not kosher with your child processes. There are some other uses for RO_REUSEADDR which are quite advanced. Reason why close my not shutdown a socket. If a parent process and child process have a socket handle open. In the case of the parent forgetting to do a close on the socket handle after an accept call, then there will be two references to the same socket. When the close is called by the child then the open reference counter on the socket will be decremented but the socket will not be shutdown (as the parent still has it open). The socket will only be shutdown if the parent closes the socket too. This is a common mistake. However if the code is corrected and the parent does close the socket, then when the child calls close on the socket, there is only one reference count to the socket then a close will shutdown the socket too. This also happens when a parent is killed by an interrupt and there is no interrupt handling in the application. The parent bails without cleaning up and then waiting for the children to follow suit. Every child process gets set to CLOSE_WAIT. We are on the same page, but I think I'm writing it in a different language. :P James Glen http://picksource.com http://mvdevcentral.com --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2][UV] Forcing a port to close
This is a typical socket address condition that can't be safely overridden by hand. If you look at your net stats, the socket in question is probably in a CLOSE_WAIT state. This is a subsystem status that says the remote has shutdown and it's waiting for the socket to close and cleanup. If the socket gets dumped improperly by the socket application, then the socket can be left in CLOSE_WAIT with no process attached to finish cleanup. The status will clear up, but it could take a long time. That all depends on the tcp_close_wait setup and whether or not the socket is setup with the SO_LINGER flag. If the socket's SO_REUSEADDR flag can be enabled using some kind of U2 setsocketopt function before you listen on it, then you can re-use the same socket address over and over again. Check out this sockets FAQ: http://www.unixguide.net/network/socketfaq/ Glen http://picksource.com http://mvdevcentral.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Nick Cipollina Sent: Thursday, February 24, 2005 4:20 PM To: u2-users@listserver.u2ug.org Subject: [U2][UV] Forcing a port to close Is anyone aware of a way to force a socket port to close at the operating system level. We are currently using Sun 9.xx. We have a process that opens a port and accepts socket connections. Whenever we stop it and try to restart it, we get a port in use message. The only way that I've been able to get it to release the port is to stop and start universe again. I'm just wondering if there is a way to force the port to close. Thanks. Nick Cipollina Pick Programmer ACS - Heritage Information Systems, Inc. 2810 North Parham Road, Suite 210 Richmond, VA 23294 (804)644-8707 x 314 --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] U2 to web software
George, your implementation isn't cludgy by default. It's only slow and cludgy if the processes involved aren't tuned to function with file spooling. The basic design of MVWWW utilizes file spooling much in the same way. I get very good throughput using it. It is not anywhere as efficient as pipes, direct sockets, or shared memory, but it is portable and simple to design around. As with any software design, overall performance is based on the hardware running it. If you have a very slow file system, then your file-based solution is going to really drag. On the flipside, try running a ton of IPC based processes on a system that is heavily swapping to disk. If you fully understand an architecture and what it requires, then there is no reason why it can't outperform a poorly implemented better design. With that said, it's very hard to compare apples to apples, when one of them is apple sauce and the other is juice. I run FlashCONNECT and have been happy with it, with regards to processing time. Unfortunately, it still lacks proper phantom management. My error log still shows many 505 errors when processes get overstepped. To compensate for a large amount of errors, I run a couple more phantoms than is needed. That eats up my seat count, but I don't have any other options. I still see 505 errors pop up now and then. MVWWW may be 1/2-3/4 second slower to respond, but it's impossible for phantoms to step over each other. Phantoms can be added and removed at will, without any service problems arising on the client side. When it's been thoroughly tested and proven, I may be migrating my code. There's always a trade off, when it comes to architectures. This is a general response and probably useless info. I'm no expert, but this is a small tech niche I've been playing in for a long time now. Performance, in regards to architecture, is based on several things. First, there is the client (CGI in this case). Secondly, there is the DB-client bridge. Thirdly, there is the backend application (U2 in this case). How each of these components is designed and implemented determines the performance and flexibility of the architecture. In most cases, flexibility deters performance. The opposite is also true. You can, however, balance the two and get great performance without sacrificing flexibility. Most fast performers utilize a real-time connection across the DB bridge. The CGI client makes a local service connection via IPC(inter-process communication). The local service is already connected across the DB bridge, to a backend service. Therefore, the request time is near zero. Client requests return content to the browser as fast as the backend application can complete. If content monitoring and control is put in place, then performance will decrease. If a request for an invalid app comes in overly often from the same IP, then that IP should be temporarily blocked from accessing port 80,443,8080,etc. Some fast performers remove the DB bridge completely and offer direct client to backend connections. While these are the quickest, they may lack control and recovery capability. A DoS(denial of service) attack can flood the web services and backend to a halt. A good direct solution should always have load control(phantom management) and reliable content monitoring. Flexible implementations can utilize many techniques to handle processing. Most of them utilize modular components to handle each step of the process individually. When you get into complex architectures such as these, the performance is determined by the design of each component and also how well the components work together. A positive aspect of modular setups is the ability to monitor and control content between steps. You don't need an integral content manager. Plug-ins are a breeze to implement. The key to reliable modular implementations is reliance upon well known pre-built tools and services. For example, writing your own operating system socket service can lead to system stability issues. This is especially true if you don't know what you're doing. Also, relying on one specific component to handle most of the work can lead to load problems and possible system stability issues. Launching a U2 shell directly from a web server is an example of dangerous modular implementation. A good rule of thumb is: If you don't fully understand the good/bad of what is being done then don't do it. I don't know the architecture of RedBack, so I can't categorize it. Can someone provide some info on that? CGI is not a method, language, or API. CGI is a common gateway interface. This standard provides a set of operating system environment variables, much like TERM and PATH. Web based services can obtain information indirectly from the web server, using these environment variables and also 'standard input'. CGI environment variables and input content are available to all applications that can be executed from the web
RE: [U2] UV to Web interface
Vance, Thanks for the invite, but I don't repost other people's code. I finally have MV Developer Central up and running. If anyone is inclined to post snippets in the snippet library, or even start an open source project, then feel free to register and post this kind of stuff. The purpose of this site is to offload the code management from PickSource and centralize MV development efforts. PickSource is not really a code repository. It's actually a community portal. MV Developer Central will soon be(I hope) the single spot for MV open source development. I may extend this to include commercial tools, but that's undecided at this point. Tony and I are working on many things at the moment, but most of the site is ready to go. There are some quick-start guides available in the Site Docs area, for those wanting to start a project. A Tortoise CVS quick-start and a WinSCP overview are currently available. They're rough-drafts, but they'll help you figure out how to use CVS and WinSCP with your project. I will be writing a SourceForge project intro doc sometime this week, to inform newbies about SF projects, what they consist of, and how they can be used. A brief synopsis would be: Your own MV focused code publishing, management, and current version system with project web service and an extensive self-service project support center http://mvdevcentral.com I will have a CVS of MVWWW's dataBASIC code published soon. I need to make a couple changes to the code, to make a single flavor-configurable release. For the time being, a D3 pseudo account-save and a QM account directory tar are available for download. If anyone wants the bare text source, drop me an e-mail on mvdevcentral and I'll get you a zip of it. http://mvwww.mvdevcentral.com Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 15, 2005 9:32 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] UV to Web interface Glen, Apparently this is a hot topic... Maybe you should throw it up on picksource as well... It's nothing special. Will, In one of your responses you said you added username and pwd to the form. I hope this form is not web accessible, and if it is, you should atleast be serving it ssl. Way to easy to sniff in pure http Just my 2 cents... The web server (IIS in this case) will require UniObjects not the client side. The same code can also be taken and slightly modified to work in a VB app as well, then the client would need the UvObject loaded. Vance - Original Message - From: [EMAIL PROTECTED] To: u2-users@listserver.u2ug.org Sent: Monday, February 14, 2005 8:58 PM Subject: RE: [U2] UV to Web interface Does require each user to have UniObjects loaded on their PCs or is UniObjects only loaded on the web server? TIA Stewart Only on the web server Stewart. The asp pages serve up pure HTML to the remote browser and it's only by clicking something that the user requests a new asp page, which again, just runs on the web server. So the user needs nothing special to make it do the HOW of what it's doing. Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Friday, February 11, 2005 8:59 AM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 We've been through a very similar exercise recently (as you've probably guessed) and we came down to using IBMx445 servers with RHEL AS 3. As the clock speed of the SPARC is relatively low compared to a Xeon MP we found that combination outperformed the Sun (and was a lot cheaper once a large disk array was added in). There was nothing that Sun could do to improve the performance due to Universe being compiled against a very old solaris (7) version. Core clock speed, alone, is an irrelevant factor in the overall performance. It typically only makes a difference based on chip architecture, bus speed, memory access, and chipset performance. The Sun box is a RISC platform, right? I'd be interested in your comparison specs, if you can dig 'em up. I'd bet a few bucks that a dual Opteron(2.0Ghz-2.4Ghz) would smoke a Dual Xeon-MP of any current speed. I've never put them side by side with exactly the same peripheral hardware. A Xeon is basically just a Pentium on steroids. Have you looked at the Opteron whitepaper and architecture specs? The potential bandwidth those things have, as n-way configs, is totally awesome. I'm sure even a single 100 series, on a dual-board, will smoke a single Xeon. Check out the 800 series - if you've got a bottomless wallet, you can run an 8-way Opteron. *drool* You can probably imagine what the Sun engineers reaction to that was! He wasn't very complimentary about IBM. Interestingly Solaris 10 is supposed to be able to run any Linux application. Hrm.. I find that hard to believe. ANY Linux binary? Glen --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
OK. That's what I thought. UV is in the same situation as all the other flavors. If you can't pass a file handle between processes, then you can't effectively create a multi-client service by using just the sockets API. There have been numerous web/socket architecture examples published, in terms of code and/or postings on C.D.P. JD3 is a Java-focused socket service that uses a port gateway, which redirects(client disconnects and then reconnects) incoming connections from a master listener to 'child' listeners. This is a stable method, which does not require sessions to be initiated. The biggest drawbacks are the reconnect lag, port firewalling issues, and requirement of the port master to constantly keep up with who/what is really running on the MV side. This is considered an internal architecture. No non-MV components are needed. Coyote is an internal HTTP service all in its own world. hat off to Doug FlashCONNECT is an HTTP POST/GET service that has client-side and server-side services running. I don't know all the details of how the 2 services communicate, but the request is sent to a local(webserver-CGI-local) service. That service is already connected to matching services in MV. The communication paths are pre-established, so there is zero lag between CGI request and MV processing. The only problem there is the fact that the communication paths are pre-established. It's a dual-edged sword. Monitors have been added to recent releases, to deal with previous load and license balancing problems. This is the most effective mixed architecture I've seen so far. MVWWW is an open communications framework that utilizes an open mixed architecture. The 2(or 3 if you separate the client component) architecture 'zones' are separate. The CGI(or client), the spooler, and the service zones can be separated and used by themselves for other purposes. This modularization allows flexibility in integration. However, it also leads to security and content management issues. I, as a developer, prefer this style of architecture over mixed or internal-only simply because of the flexibility. RedBack.. hm.. never touched it. One of these days I'll get around to it. I run FlashCONNECT here mostly because I'm still running D3. Times'r changing though. I develop MVWWW on my OpenQM developer box. When Doug releases Coyote for OpenQM, I'll definitely be running it through the hoops too. When someone asks how I do pull MV data using my browser, I like to sit back and watch the fur fly. I lost count of the number of methods discussed for getting MV data into a browser. Maybe one of these days a web-based communication integration wizard will be created. Until then, I wish more of this kind of information was compacted, indexed, and published on the web. If anyone has any further comments or questions for me, e-mail me directly. I've wasted enough list space. Hey Chuck.. you lurkin? I got another article idea for ya. G -Glen http://picksource.com webmaster [at] mvdevcentral [dot] com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Simon Lewington Sent: Thursday, February 10, 2005 11:42 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface Glen B... If you can truly pass a UV socket handle to another UV process, then there's no reason why anyone can't write a stable multi-threaded socket server directly in UV BASIC. Is this true? Kevin P Lynch... here is the appropriate manual : http://publibfi.boulder.ibm.com/epubs/pdf/25119080.pdf You most definitely *cannot* pass a UV socket handle to another UV process. Simon --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10
It will as a 32-bit application. You can run a single Opteron on a dual-board and you still get the benefit of 64-bit hardware. I have Win2K Pro running on that setup right now serving huge files. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, February 10, 2005 5:55 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Yes (v490). Problem is that Universe is compiled against Solaris 7 so you get absolutely no benefit of later versions. Also as far as I know Universe does not run on Opteron. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Peter Ivanick Sent: 10 February 2005 21:04 To: u2-users@listserver.u2ug.org Subject: [U2] Has anyone played with/tested UniVerse 10+ under Solaris 10 Hola all - We've suddenly had some resources freed up from another project and are looking to rapidly replace the 12-14 year old SGI Challenge Ls (which, truly, are still performing magnificently in most respects) we have our UniVerse 9.6 installation on. We've so far primarily tested on U2 10.1.x running on redHat AS 3.2 and we're starting to get quotes for hardware, and we've concentrated on x86 so far; the Sun guys came by today pitched a very nice price for 4 way Opteron based 40Zs, but they also made a fairly strong case for the virtualization/compartmentalization features of Solaris 10. I know it's kind of early yet, but has anyone tried running U2 in these containers? I'm fascinated by the idea (as we could dual-purpose the box and not have to worry so much about our high-availability needs), but it will take a while before I can actually get to trying it out on the SunBlade 100 here, so I'm interested if anyone's tried this, perhaps from the Solaris 10 betas. Thanks very much for any input. -- Peter Ivanick Sr. Programmer/Analyst School of Veterinary Medicine, University of Pennsylvania Email: [EMAIL PROTECTED] Phone: 215.573.2306Fax: 215.573.8777 http://www.vet.upenn.edu/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
Stewart, Socket implementations don't work across flavors. I've written many socket apps for D3, but even the small differences in the socket designs between Win and *nix causes problems. Sockets are easy to implement, but only if you want to maintain separate code-sets for Win and *nix under each flavor you want to support. I won't get into the details here, since I'm not familiar with the UV socket API. Service sockets are meant for the O/S, not Pick. Doug Dumitru bit the bullet and wrote his own TCP stack in Pick ASM. That is about the only way I would recommend even contemplating Pick server sockets. For clients, the socket APIs are fine. The calls are nearly identical between Win and *nix. The only issue there is blocking control, which unfortunately most of MV socket developers are unknowledgeable of. OK...I'm not going to get into that... meditating The SELECT can be handled several ways, but it still comes down to global locking of some kind. Another method is to use a stack file, instead of a directory. Since there's no need to close the pick file pointer, the overhead of opening(refreshing) and closing a local directory is eliminated. The only problem here, is the fact that every phantom has to lock the file before it checks any kind of stack status. That's not a problem on the MV side, but it can cause general service issues. If the MV file locks aren't file system(flocks/perms) as well, then the spooler could easily corrupt the stack with phantoms polling it constantly. Then, you end up having to write a stack manager to deal with I/O. Yes, all of that would work much better than directory polling. It's a lot more design work and can tend to be debugging unfriendly. Another method, which was implemented in a prior release of MVWWW, was through the use of O/S TCL command tools. Instead of spooling the request, the request was posted directly to the HTTP service via command-line TCL. The biggest drawbacks there were session init lag and overall insecurity. Anyone could telnet to the local Inet service and hack into Pick through the HTTP service. Starting and stopping sessions ended up creating a lot of load under D3, since it's VME based. It could be that this is the answer for UV, UD, and possibly mvBase. My only concern would be the user permissions required to make something like this happen in UV. I could be wrong though, I'm still a UV newbie. Finally, there was the gateway/manager I wrote in C and the stand-alone MV TCP/IP listener. The gateway maintained a list of available IP ports and provided a transparent TCP/IP bridge for the CGI client, into Pick. The only problem there was the use of a shared segment to store the port map. I actually ported it to Win32. And it ran like doo-doo. After about 10 hits per second, the Linux port handler went bonkers and stuff stopped working. The Win32 threaded version never left Alpha, before I dropped it in the shredder. I have to say, this was the speediest Linux solution by far. Response time was sub-second, provided the web app didn't take too long. Maybe in a couple more years, when I get some more VC++ knowledge under my belt I'll try it again. Regards, -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stewart Leicester Sent: Tuesday, February 08, 2005 11:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Thanks for the reply. I wasn't critiquing so much as I'm curious: I was called in to accomplish this in a quick and dirty fashion 5 or 6 years ago and after a few days ended up with something very similar to what you describe. I wasn't happy with a loop which continuously performed SELECTs but SLEEPs seemed to slow it down too much. I recall looking for something I could use as a blocking read operation and believe I tried pipes. IIRC they worked OK but sometimes operations hung up. I thought of using sockets but never had the chance to try. Perhaps you could get it to work with sockets and let me know what you find. :-) Stewart -- Stewart Leicester| http://www.ThreatFocus.com V.P. Engineering | mailto:[EMAIL PROTECTED] Threat Focus, Inc. | 925-551-0130 Voice Knowledge is your best defense | 509-695-1373 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
Must be nice. I wish that capacity existed in every flavor. It would make the integration world a breeze. Well my real question would be; is the service external or internal? I'd be interested in knowing how the socket service is laid out. Do you have to manage connections yourself? How are socket handles passed to children under multiple listening conditions? Or, do you tell the UV service to listen 4-at-a-time, on port , and then call MYAPP when a connection is accepted? -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 1:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Glen, The UV socket server interface works the same in Unix and Windows, I have server programs running in both environments with no changes. Kevin Lynch The Systems House -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Stewart, Socket implementations don't work across flavors. I've written many socket apps for D3, but even the small differences in the socket designs between Win and *nix causes problems. Sockets are easy to implement, but only if you want to maintain separate code-sets for Win and *nix under each flavor you want to support. I won't get into the details here, since I'm not familiar with the UV socket API. Service sockets are meant for the O/S, not Pick. Doug Dumitru bit the bullet and wrote his own TCP stack in Pick ASM. That is about the only way I would recommend even contemplating Pick server sockets. For clients, the socket APIs are fine. The calls are nearly identical between Win and *nix. The only issue there is blocking control, which unfortunately most of MV socket developers are unknowledgeable of. OK...I'm not going to get into that... meditating The SELECT can be handled several ways, but it still comes down to global locking of some kind. Another method is to use a stack file, instead of a directory. Since there's no need to close the pick file pointer, the overhead of opening(refreshing) and closing a local directory is eliminated. The only problem here, is the fact that every phantom has to lock the file before it checks any kind of stack status. That's not a problem on the MV side, but it can cause general service issues. If the MV file locks aren't file system(flocks/perms) as well, then the spooler could easily corrupt the stack with phantoms polling it constantly. Then, you end up having to write a stack manager to deal with I/O. Yes, all of that would work much better than directory polling. It's a lot more design work and can tend to be debugging unfriendly. Another method, which was implemented in a prior release of MVWWW, was through the use of O/S TCL command tools. Instead of spooling the request, the request was posted directly to the HTTP service via command-line TCL. The biggest drawbacks there were session init lag and overall insecurity. Anyone could telnet to the local Inet service and hack into Pick through the HTTP service. Starting and stopping sessions ended up creating a lot of load under D3, since it's VME based. It could be that this is the answer for UV, UD, and possibly mvBase. My only concern would be the user permissions required to make something like this happen in UV. I could be wrong though, I'm still a UV newbie. Finally, there was the gateway/manager I wrote in C and the stand-alone MV TCP/IP listener. The gateway maintained a list of available IP ports and provided a transparent TCP/IP bridge for the CGI client, into Pick. The only problem there was the use of a shared segment to store the port map. I actually ported it to Win32. And it ran like doo-doo. After about 10 hits per second, the Linux port handler went bonkers and stuff stopped working. The Win32 threaded version never left Alpha, before I dropped it in the shredder. I have to say, this was the speediest Linux solution by far. Response time was sub-second, provided the web app didn't take too long. Maybe in a couple more years, when I get some more VC++ knowledge under my belt I'll try it again. Regards, -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stewart Leicester Sent: Tuesday, February 08, 2005 11:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Thanks for the reply. I wasn't critiquing so much as I'm curious: I was called in to accomplish this in a quick and dirty fashion 5 or 6 years ago and after a few days ended up with something very similar to what you describe. I wasn't happy with a loop which continuously performed SELECTs but SLEEPs seemed to slow it down too much. I recall looking for something I
RE: [U2] Universe to Web interface
Kevin, I read through the PDF. However, it is not clear on how the handles can be used. A lot of the API's I've seen have the same level of functionality, but they all lack the ability to pass handles from the acceptor process to a totally separate user process. This isn't really an issue of the API, it's more of a user environment issue. You can pass the handle value itself, but the other process loses the 'meaning' of the handle and it just becomes a worthless string. An example would be launching a new phantom and passing it the handle variable, after accepting an incoming connection. The same situation occurs when you pass any kind of memory reference(or offset) to anything outside the current user heap. Unix fork()ing generates a mapped/duplicate user heap, so all file/handle references still work properly without having to munge underlying memory addresses. If you can truly pass a UV socket handle to another UV process, then there's no reason why anyone can't write a stable multi-threaded socket server directly in UV BASIC. Is this true? If so, I want a developer copy so I can try to blow it up. :P eg -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 3:52 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface you manage the connections from basic, the whole interface is a set of basic extensions. basically you open a socket on a port , accept a connection on that socket and write to the socket. here is the appropriate manual : http://publibfi.boulder.ibm.com/epubs/pdf/25119080.pdf -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 2:31 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Must be nice. I wish that capacity existed in every flavor. It would make the integration world a breeze. Well my real question would be; is the service external or internal? I'd be interested in knowing how the socket service is laid out. Do you have to manage connections yourself? How are socket handles passed to children under multiple listening conditions? Or, do you tell the UV service to listen 4-at-a-time, on port , and then call MYAPP when a connection is accepted? -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Kevin P Lynch Sent: Wednesday, February 09, 2005 1:19 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Glen, The UV socket server interface works the same in Unix and Windows, I have server programs running in both environments with no changes. Kevin Lynch The Systems House -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Glen B Sent: Wednesday, February 09, 2005 12:04 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface Stewart, Socket implementations don't work across flavors. I've written many socket apps for D3, but even the small differences in the socket designs between Win and *nix causes problems. Sockets are easy to implement, but only if you want to maintain separate code-sets for Win and *nix under each flavor you want to support. I won't get into the details here, since I'm not familiar with the UV socket API. Service sockets are meant for the O/S, not Pick. Doug Dumitru bit the bullet and wrote his own TCP stack in Pick ASM. That is about the only way I would recommend even contemplating Pick server sockets. For clients, the socket APIs are fine. The calls are nearly identical between Win and *nix. The only issue there is blocking control, which unfortunately most of MV socket developers are unknowledgeable of. OK...I'm not going to get into that... meditating The SELECT can be handled several ways, but it still comes down to global locking of some kind. Another method is to use a stack file, instead of a directory. Since there's no need to close the pick file pointer, the overhead of opening(refreshing) and closing a local directory is eliminated. The only problem here, is the fact that every phantom has to lock the file before it checks any kind of stack status. That's not a problem on the MV side, but it can cause general service issues. If the MV file locks aren't file system(flocks/perms) as well, then the spooler could easily corrupt the stack with phantoms polling it constantly. Then, you end up having to write a stack manager to deal with I/O. Yes, all of that would work much better than directory polling. It's a lot more design work and can tend to be debugging unfriendly. Another method, which was implemented in a prior release of MVWWW, was through the use of O/S TCL command tools. Instead of spooling the request, the request was posted directly
RE: [U2] Universe to Web interface
There are many ways to accomplish that. I've been crunching the methods for years and finally picked a simple, but flexible architecture. The main thing to consider is execution permissions. You don't want just anyone being able to run anything on your UV box from a web server or console. Take a look at the guts of MVWWW if you want a starting point to build your own UV http service. If you do, PLEASE let me know so I can include it in the project! This is a file-spool based http service. For Windows, you will need ActivePerl in order to run the perl spooler and CGI client. You will also need Winetd or another Inet variant for Windows. If you just want the architecture, then here's a compressed version. Client-side (browser) calls a URL. (http://www.myhost.com/cgi-bin/mvwww.cgi?mvwrun=testapp) The web browser executes the CGI script (mvwww.cgi in this example) The CGI script makes a socket connection to the spooler (inetd service the standard I/O app called mvwspool.pl) The spooler generates a unique ID for the request. The spooler grabs the query, post, headers, etc from the CGI environment and saves them to a request queue file using the ID. The spooler broadcasts the presence of a new queue item, by writing an empty file in the main spool dir using the ID. At this point, the spooler waits for a response in a separate response directory. Server-side, our HTTP phantom runs and waits until new item IDs show up in a local directory (the main spooler dir) NOTE: Just like using a 'critical section' in threading, the directory is locked via MV file lock when it is being read or written to. This syncs all phantoms and allows for multi-threaded processing. When a new item ID is found, the empty item is deleted from the main spooler directory so other processes won't barge in and take over our request. The HTTP phantom then reads the actual request from the request queue, using the item ID as reference. The request is parsed, looking for a static CGI variable. In the case of MVWWW, it's mvwrun. The subroutine to be called, is assigned to this CGI variable. We use CALL @ to call the subroutine named in the MV variable. Once our MV subroutine has RETURNed, we write the response into the response directory. The spooler sees the response, picks it up, and then sends it back to the client via standard I/O. That's it, in a nutshell. Plans are in the works to implement a spool manager. As it is, this architecture is not DoS attack proof. It also needs to have injection management added. As it is, you can inject a request directly into the spooler. The future manager will monitor how many, and how often, requests come from a client. It will also determine who can access it. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, February 08, 2005 12:43 PM To: u2-users@listserver.u2ug.org Subject: Re: [U2] Universe to Web interface In a message dated 2/8/2005 9:33:25 AM Pacific Standard Time, [EMAIL PROTECTED] writes: It sounds like you want to visit a web page and see the output of a UV BASIC program, but I might be misunderstanding you. Really it doesn't matter so much what I'm trying to do. I'm just looking for an example of how ANYONE has done this UV on Windows. Examples for Unix or Linux aren't helping me :) Thanks Will --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Universe to Web interface
Not continuous, but the directory is polled. The only other sensible way around this is to use IPC or pipes, which is not portable. open the dir, select, and then readnext to see if there's a file item present. If so, delete it and process the request based on that ID. You're basically popping off the 'stack'. If your configuration isn't saturated, polling ( or stack poppin) takes a split-second to happen. It's not like there's 5000 items in the directory and you have to deal with select lag. I had one issue on OpenQM/Linux, with the select polling. A 'loosey-goosey' loop ate up all the CPU ticks. A half-second NAP or SLEEP solves the CPU problem, but it does reduce response time a tad. Adding another phantom will more than make up for that lag. Sure, there are a zillion other ways to manage a queue stack. This is the most platform and flavor cross-compatible. If you have another design suggestion that would work better, please let me know. Afterall, the project is GPL and needs some enhancing! -Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stewart Leicester Sent: Tuesday, February 08, 2005 5:37 PM To: u2-users@listserver.u2ug.org Subject: RE: [U2] Universe to Web interface The spooler broadcasts the presence of a new queue item, by writing an empty file in the main spool dir using the ID. At this point, the spooler waits for a response in a separate response directory. Server-side, our HTTP phantom runs and waits until new item IDs show up in a local directory (the main spooler dir) Glen http://picksource.com Glen: How does the HTTP phantom find a new item ID in the directory? ContinuousSELECTs? Stewart -- Stewart Leicester| http://www.ThreatFocus.com V.P. Engineering | mailto:[EMAIL PROTECTED] Threat Focus, Inc. | 925-551-0130 Voice Knowledge is your best defense | 509-695-1373 Fax --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] EDI anyone?
Most of the Aerospace and government agencies we deal with regularly are using web portals now for procurement and supply chain management. EDI/VAN is disappearing, as more large companies put their funds together to get out of their EDI sink holes. The costs of VANs, and operating an EDI infrastructure now, are a lot higher than before. That's mostly because so many people are moving off VANs, in favor of e-mail or web based EDI-friendly gateways. The portals are many times more intuitive and organized than EDI could ever be. In many cases, the move to web portals means less employee requirements and therefore layoffs. That is good or bad, depending on which side of the fence your sitting. However; EDI conversations are still in use, but the methods of the past are disappearing. We've looked into hooking up with EDI, but most of our large customers still use Sterling Commerce as their VAN. We don't have enough margin to pay Sterling, even with the small byte transmissions we'd probably be using. So, we do more business(and can offer better prices in general) to those who participate in a non-EDI required setting. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Daly, Mark Sent: Friday, October 22, 2004 6:19 AM To: '[EMAIL PROTECTED]' Subject: RE: [U2] EDI anyone? I've just been doing a bunch of work for EDI clients. There is a lot of infrastructure in place that works well, and won't be replaced. The standards are mature. Anyone wanting to interact with department stores (in the US anyway) had better get with EDI. I think the aerospace industry has it's own flavor. Now, the future of VANs That's a different story. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 22, 2004 5:00 AM To: [EMAIL PROTECTED] Subject: Re: [U2] EDI anyone? Bruce, not definitive, but an answer none-the-less. I would say Declining. The London (England) insurance market has been using EDI for many years, but has now commenced a migration to XML etc. Regards, John Appleyard Arthur J. Gallagher (UK) Limited Bruce Nichol [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by:cc: (bcc: John Appleyard/BSDUK/AJG) [EMAIL PROTECTED] Subject: [U2] EDI anyone? er.u2ug.org 22/10/2004 04:30 Please respond to u2-users Goo'day, Is there anybody out there that can give a definitive answer to the future of EDI. Growing?Peaked? Stagnated? Declining? Regards, Bruce Nichol --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Fusetalk
sad plug You know, that would probably be a good first application to build using MVWWW. For those who don't know about it, it's a cross-platform/cross-flavor HTTP integration toolkit that is being split from my original D3WWW project. I don't want to create a seperate SourceForge project for it right now, so there will just be code and release name changes. I'm hoping some of you folks will try it out and help me make it U2 friendly. I know U2 has an assortment of HTTP tools built-in, but this is a white box toolkit for software developers who are planning to go to market and support a variety of flavors. That is, after it's released... :P Eventually it will become a project of its own with many developers and admins(community willing nudgenudge). Then, I can continue to work on D3WWW. http://d3www.sourceforge.net /sad plug PS: Tony, I decided to put the C spooler on hold and work on a Perl substitute for now. I'm going memory/pointer bonkers and need a break. Actually, I had a working Perl app last night and accidentially used instead of | when cating a test request to it. *sigh* Next time I'll make a backup after every change I make, or just chill for 12 hours so my brain will stop smokin and I can actually think properly. Anyway, it should be just as quick and tons more stable than my C app. LOL (not that I'm a buggy coder or anything..) I should have a complete and functional alpha release of the project by tomorrow. (don't hold me to it though) Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tony Gravagno Sent: Thursday, September 09, 2004 10:01 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Fusetalk [EMAIL PROTECTED] wrote: Has anyone ever considerd moving the users group from e-mail to a web based forum software like fusetalk? http://www.fusetalk.com/ Or like this: http://www.u2ug.org/modules.php?op=modloadname=phpBB_14file=index Or these: http://www.picksource.com/modules.php?name=Forums (See Universe/Unidata sections) If you're looking for a web forum that supports e-mail I/O too then commercial-ware may be the only solution - unless someone here writes a basic solution in MV. :) (Thinking about it... Yeah, I could... Little voice saying No Tone, don't volunteer! Phew, the urge has been suppressed.) Tony Nebula RD --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] UvOdbc
WSOCK Error 10054 is connection reset. Sounds like the service doesn't exist, or it's refusing your connection. Why you'd need rexec, or any other *nix process, on Windows is beyond my knowledge. Maybe you should recheck your setup? Is there options for Unix versus Windows? Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Cooper, Rudy Sent: Wednesday, September 22, 2004 4:18 PM To: [EMAIL PROTECTED] Subject: [U2] UvOdbc I'm having a problem getting my odbc connection to UV working. I know many of you have already overcome this problem so I'm looking for some help in getting this going on my end. Here is what we have: UV 10.0.10 W2K (UV Server) W2K (Client) Wintegrate 4.2.1 Client side odbc driver = IBM Universe ODBC Driver 3.07.02.1130 File = FASTPA32.DLL Date = 06/19/2002 100 user license for UVODBC My ultimate goal is to query UV tables from Sql Server, but as a simple test I thought I would try using Excel. I used the existing user dsn for UV/ODBC Sales Sample. I changed the server connection information to reflect my system obviously. Here is my problem: I can ping my server without a problem, the moment I click the Test button I get the following error: UniVerse ODBC configuration test failed. [IBM][UVODBC][0301892]Error ID: 110 Severity: SEVERE Facility: LINKERR - TCP error The odbc documentation, yes I actually read the documentation, states the following for Error id 110: TCP error. Other error messages (including strange character sequences) typically indicate that the port number in the Link Parameters field in the configu-ration file is incorrectly specified; you have connected to a service other than the rexec daemon (UNIX). Use UniVerse ODBC Config to check the port number of the rexec or autostart daemon or service (typically 512). Retry the connection. If this fails, reboot your PC and try again. If this fails, check to see if the host and its TCP/IP inetd, rexec, or autostart daemon are running. Error ID: 110, Severity: SEVERE, Facility: LINKERR My odbc config says 512, so I'm not really sure where the problem could be. I even turned on the trace in the odbc configuration editor, I see the error, but I have no idea what it means. Here's the trace: If someone could enlighten me I would greatly appreciate it. thx, rudy e uvodbc_config 6c8-7f0 ENTER SQLAllocEnv HENV * 0142FBFC e uvodbc_config 6c8-7f0 EXIT SQLAllocEnv with return code 0 (SQL_SUCCESS) HENV * 0x0142FBFC ( 0x00911540) e uvodbc_config 6c8-7f0 ENTER SQLAllocConnect HENV00911540 HDBC * 0142FBF8 e uvodbc_config 6c8-7f0 EXIT SQLAllocConnect with return code 0 (SQL_SUCCESS) HENV00911540 HDBC * 0x0142FBF8 ( 0x009115e8) e uvodbc_config 6c8-7f0 ENTER SQLDriverConnectW HDBC009115E8 HWND000604BC WCHAR * 0x00237310 [ -3] **\ 0 SWORD -3 WCHAR * 0x00237310 SWORD8 SWORD * 0x UWORD3 SQL_DRIVER_COMPLETE_REQUIRED e uvodbc_config 6c8-7f0 EXIT SQLDriverConnectW with return code -1 (SQL_ERROR) HDBC009115E8 HWND000604BC WCHAR * 0x00237310 [ -3] **\ 0 SWORD -3 WCHAR * 0x00237310 SWORD8 SWORD * 0x UWORD3 SQL_DRIVER_COMPLETE_REQUIRED DIAG [08S01] [IBM][UVODBC][0301892]Error ID: 110 Severity: SEVERE Facility: LINKERR - TCP error (10054) e uvodbc_config 6c8-7f0 ENTER SQLErrorW HENV00911540 HDBC009115E8 HSTMT WCHAR * 0x0142FBB8 (NYI) SDWORD *0x0142FC04 WCHAR * 0x0142F7B8 SWORD 511 SWORD * 0x0142FC00 e uvodbc_config 6c8-7f0 EXIT SQLErrorW with return code 0 (SQL_SUCCESS) HENV00911540 HDBC009115E8 HSTMT WCHAR * 0x0142FBB8 (NYI) SDWORD *0x0142FC04 (10054) WCHAR * 0x0142F7B8 [ 84] [IBM][UVODBC][0301892]Error ID: 110 Sever SWORD 511 SWORD * 0x0142FC00
RE: [U2] spammed
You can change the default distribution header and remove the Sender: line, since it is not required by the RFC for proper mail transfer. This will eliminate possible harvesting. You can also mangle the $sender variable to make it spam-proof. There's always a way.. http://www.greatcircle.com/lists/majordomo-users/mhonarc/majordomo-users.200 312/msg00015.html Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Tuesday, September 21, 2004 12:49 PM To: [EMAIL PROTECTED] Subject: RE: [U2] spammed you post your address yourself everytime you post to this list just like the one i am replying to - take a look at the From: header. Sorry folks, but this is a limitation of Majordomo/Sendmail. We can't change the From: header, it's actually part of the RFC. After all the mail isn't from Majordomo or the list, it's only relayed from there. Larry Hiscock Moderator --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Attribute marks in comments?
Here's my typical marking convention. You can always make up your own, though. Why not use the @vars? ] = field mark / = value mark ^ = sub-value mark Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Barry Brevik Sent: Tuesday, September 21, 2004 1:45 PM To: U2-users (E-mail) Subject: [U2] Attribute marks in comments? Is there a standard or convention for representing attribute marks in program comments? In other words, if I want to document the structure of a dynamic array in a comment, are there single characters that I would use instead of @FM, @VM etc? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] ODBC from RH to MS SQL
Copy the ODBC shared library to /usr/local/lib and make it world readable? I dunno, just throwing dirt into the wind.. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of John Hester Sent: Tuesday, September 21, 2004 3:30 PM To: U2 Users Discussion List Subject: [U2] [UV] ODBC from RH to MS SQL Has anyone successfully used an ODBC driver from any vendor to connect from UV on RedHat AS 3.0 or RedHat 9.0 to MS SQL 2000? I'm running UV 10.1.4 on RH AS 3.0. I've attempted using drivers from OpenLink and DataDirect with no success. The OpenLink drivers don't work at all within UV, though they work fine directly from linux. This is the error I get: Enter username for connecting to 'goldmine' DBMS [root]: sa Enter password for sa: SQLConnect error: Status = -1 SQLState = IM003 Natcode = 0 [ODBC] [iODBC][Driver Manager]Specified driver could not be loaded Invalid parameter(s) found in configuration file The DataDirect drivers also work fine directly from linux, and from UV - but only as root. I can't even launch UV as a non-root user once /.uvlibs points to the DataDirect drivers. I get this error: uv: error while loading shared libraries: libodbcinst.so: cannot open shared object file: No such file or directory It's as if UV is resetting a necessary environment variable and the driver manager no longer knows how to get to the directory where the drivers are. When I execute ENV from within UV as root, everything necessary is there (ODBCINI, LD_LIBRARY_PATH). The environment variables also check out within UV when I'm using the OpenLink drivers. I discovered that I could use the OpenLink driver if I copied over the driver manager from the previous release (5.0 vs. 5.1), which is only supposed to be used on RH versions prior to AS 3.0 or 9.0 which have glibc 2.1 instead of glibc 2.3. This let me connect from within UV, and appeared to be stable, but I later discovered it broke UniObjects for java connections. I started getting the following errors in the unirpcd log file each time a UOJ connection was attempted: Abnormal termination of UniVerse. Fault type is 11. Layer type is Unknown. Seems the ODBC driver manager gets loaded anytime any UV process is started, and UOJ doesn't like launching something written for the wrong glibc version. Any suggestions for a workaround or another driver to try would be greatly appreciated. Thanks, John -- John Hester System Network Administrator Momentum Group Inc. (949) 833-8886 x623 http://memosamples.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] spammed
What I meant was, you can remove Sender: altogether and make From: be the list e-mail address. Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Tuesday, September 21, 2004 3:23 PM To: [EMAIL PROTECTED] Subject: RE: [U2] spammed You can change the default distribution header and remove the Sender: line, since it is not required by the RFC for proper mail transfer. This will eliminate possible harvesting. You can also mangle the $sender variable to make it spam-proof. The Sender: is [EMAIL PROTECTED], the From: is the original sender, so if we removed or munged the Sender: header line, then all you would see is the From: address, which doesn't solve the problem. Larry Hiscock Moderator --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] spammed
All it takes is for a bot to sign up for the list and begin harvesting. Without any decent bot-stops in place, everyone on the list is on a harvester buffet bar. If the only authorization required, is a 'reply' to the authorization response, then most harvesters can join without anyone realizing it. That is why our(All-Spec) commercial mailing list registration requires you to read an authorization code from the response e-mail and type it into a web form. Then, a human has to interpret a skewed/pixilated GIF and type in the visualized code into a separate web form. That stops most harvesters. Something else to consider, is the presence of your e-mail in cross-posting on lists/newsgroups and web forums. Spiders can pull e-mail addresses from just about anything now-a-days. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Allen E. Elwood (CA) Sent: Monday, September 20, 2004 12:44 PM To: [EMAIL PROTECTED] Subject: RE: [U2] spammed NET*SKY.*P and Net*sky.*P I got this morning on the address I use for this list. (asterisks added to avoid getting filtered away into the bit bucket) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of gerry Sent: Monday, September 20, 2004 08:13 To: [EMAIL PROTECTED] Subject: [U2] spammed i just received a viral mail delivery notification notice sent to my email address that is used solely for the u2 list and absolutely nothing else. anyone else get this ? gerry --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Processing a string
You're right about url encoding and forms. However, binary transmissions have nothing to with HTML or XML. Binary has to be transmitted via HTTP under specific MIME headers, so the web server/application won't try to parse it as text. My rule of thumb is, don't stick protected characters in text content, unless you're SURE it won't get parsed incorrectly. A sure bet that it won't get messed up, is inside a TEXTAREA block for example. Sure, you can use and anywhere you want, provided you don't break the cardinal rules. Try this on for size: HTML blah/ /HTML Then try: HTML blah / /HTML and finally: HTML lt;blah/gt; /HTML According to what I've been reading, all 3 of the above should display the string blah\. However, option 1 breaks the rules by not having white space or ! after to identify that it's not an HTML element. Since there is a / before the , the parser thinks it's a self-closing tag. In this case, you will have to encode the string with either hex values or representations. On a side note, my XML subroutine will only extract tags and content between matching pairs. will be included in any wrapping elements, unless there is a matching /. Self-closing tags are handled differently, due to their syntax difference. Is it 100% fool proof? No, it's not a commercially developed application. It does a good job though. TAG/TAG will return as the element content for TAG. TAG//TAG will return TAG as null and delete the tag pair. TAG value=1/ wil return TAG = 1. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Craig Bennett Sent: Thursday, September 16, 2004 7:34 PM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Processing a string Glen, Per HTTP 1.0-1.2 specifications, and are not exempt from content encoding requirements. They are protected characters and must be treated as such when sending content. Light bulb going off yet? Surely you don't mean the HTTP specifications? (Which the W3 have officially closed at HTTP/1.1). If you must use a or character as a non-elemental string, in ANY media, transferred through an HTTP 1.0 to 1.2 compliant application then you MUST URL-encode them as lt;, gt; or their equiv. charset hex values as %XX;. Comments are an exception to this rule, but you can still have problems with general parsing if you put protected characters in the comments. I always url-encode my non-alpha-numeric strings. You do not have to URL encode these characters at all, otherwise you could never send XML or indeed binary data over HTTP (image/jpeg). If you are sending a body with a specific content then encoding rules will apply, but these are defined by other standards. Perhaps you are thinking of the HTML standards for POSTING data using the application/x-www-form-urlencoded content type? Craig --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Processing a string
This gets better and better every day. *LOL* Per HTTP 1.0-1.2 specifications, and are not exempt from content encoding requirements. They are protected characters and must be treated as such when sending content. Light bulb going off yet? If you must use a or character as a non-elemental string, in ANY media, transferred through an HTTP 1.0 to 1.2 compliant application then you MUST URL-encode them as lt;, gt; or their equiv. charset hex values as %XX;. Comments are an exception to this rule, but you can still have problems with general parsing if you put protected characters in the comments. I always url-encode my non-alpha-numeric strings. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Beahm Sent: Thursday, September 16, 2004 10:16 AM To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Processing a string I agree, inside of a tag the Unicode equivalent is, if not required, certainly prudent: !ENTITY % xx '#60;zz;' Think outside the tag. ;) Consider: thisdatahere's some text saying 2 3 2/thisdata If you FIELD() or EREPLACE or whatever on or then you're going to have problems when a document contains them in text. quoted 2.2 Characters [Definition: A parsed entity contains text, a sequence of characters, which may represent markup or character data.] [Definition: A character is an atomic unit of text as specified by ISO/IEC 10646:2000 [ISO/IEC 10646]. Legal characters are tab, carriage return, line feed, and the legal characters of Unicode and ISO/IEC 10646. The versions of these standards cited in A.1 Normative References were current at the time this document was prepared. New characters may be added to these standards by amendments or new editions. Consequently, XML processors MUST accept any character in the range specified for Char. ] /quoted Ref: http://www.w3.org/TR/2004/REC-xml-20040204/ Best, David Beahm Kevin King wrote: Is it not against the XML standard to have a quoted string containing or in a tag? --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] ANNOUNCEMENT: Commercial MultiValue Database released as Open Source under GPL
Awesome! I definitely want a development part. I also want to work my projects into it, when they hit a stable release. If you want, I can devote a section of PickSource to it. Glen aka PickCoder http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Doug Dumitru Sent: Thursday, September 16, 2004 1:16 PM To: [EMAIL PROTECTED] Subject: [U2] ANNOUNCEMENT: Commercial MultiValue Database released as Open Source under GPL I am pleased to announce the creation of the first operational, production MultiValue database environment released as Open Source software. This new package is based on the commercial MultiValue database QM, developed by Ladybridge Systems in the UK. About QM * Originally developed for in-house use at Ladybridge in 1995 * Released as a stand-along database engine in 2001 * Not beta code. Full production code with real users. * Complete MultiValue environment * Basic comiler and run-time * Query language with dictionaries * MultiValue filesystem with dynamic files * external C/VP API * Update triggers * User defined functions Announcing OpenQM OpenQM is an open-source fork of QM with all features intact. OpenQM is being released under the GNU General Public License (GPL) allowing for full access to source code and free use for all applications that are compatible with the GPL license. For applications that need other license terms, commercial licenses are also available at a cost that is 15-20% that of similar sized U2 systems. Call for Developers Most of OpenQM is implemented in BASIC. Even internal functions such as the Basic debugger, TCL, and line INPUT are implemented in BASIC. Almost the entire system can be extended in BASIC. If you are a MultiValue developer and want to get under the hood of a remarkable platform, we want to here from you. Join the 'openqm-devel' mailing list at: http://lists.sourceforge.net/lists/listinfo/openqm-devel Call for Users Take control of your MultiValue destiny. Control costs. Help build a community. While the open-source version of QM is not quite available yet, you can get a demo copy of the existing QM software to start working with right now. The release for Linux is only a 460K download with a seperate, much larger, download for documentation and the client API code. Come Visit Us While still pretty new, we are working hard on building an internet presence for OpenQM. Come to our welcome page (which has a bunch of links) http://openqm.sourceforge.net Doug Dumitru 800-470-2756 (610-237-2000) EasyCo LLC [EMAIL PROTECTED] http://easyco.com --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Over quoting
*bowing to the all-seeing moderator* Just a reminder, a 'maxlength = bytes' string can be set in each list config. Or, are you already getting too many bounces b/c of that? Man, how do you find the time to moderate this list. I can't even keep up with CDP, much less my own site. I wish my site was as intellectually active as this list. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Moderator Sent: Tuesday, September 14, 2004 3:49 PM To: U2 Users Discussion List Subject: [U2] Over quoting To all our subscribers, Please try to trim excess quotes from your responses. Over quoting is annoying to subscribers with slow connections and it inflates the digest versions immensely. Aside from all that, a trimmed quote makes it easier for everyone to understand which of the points encouraged you to respond. All consideration appreciated. - Charles Barouch, Moderator --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Avoiding automatic e.mails to the list
You can configure major donut to drop out-of-office bounces. You need to look into the majordomo.cf file for $global_taboo_headers = 'END'; There should be a list, under that, of bad subjects to bounce mail for. Add lines like this: /^subject:\s.*\bout of the office\b/i /^subject:\s.*\bout-of-the-office\b/i or (for vacations) /^subject:\s.*\bam on vacation\b/i /^subject:\s.*\baway on vacation\b/i You can tweak the conf file as you see new ones making through. Those four will handle most of the auto-replies from Outcast. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Larry Hiscock Sent: Monday, September 13, 2004 12:00 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Avoiding automatic e.mails to the list The U2 lists DON'T filter out-of-office replies. We've been fortunate, that most of the out-of-office messages we've received have been setup to only reply once (per email address, I'm assuming). Most of these seem to have come from the IBMers on the lists. We DID have one subscriber who sent an out-of-office message to EVERY post on the list, but I unsubscribed him quickly before it became a problem. Larry Hiscock Moderator --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Anyone heard of DDi
How interesting. Do you mean Dynamic Distrubtion Inc.? Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Wednesday, September 08, 2004 11:11 AM To: [EMAIL PROTECTED] Subject: [U2] Anyone heard of DDi Just curious and looking for feedback if anyone has ever had any experience with a company called DDi out of Connecticut --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Anyone have experience mirroring a HDD over a WAN
You can do that with rsync on *nix. Only the changed bits of files are transferred. There are other remote sync tools, just do a google for it. I wouldn't rely on the sync'd data, except as a 'last-resort backup', if the local copy folds up completely. It's not a good idea to try and keep a remote instantly live. The local copy can be rebuilt from off-site sources very quickly, using the same tools. For local hot-swap action and redundancy, refer to your neighborhood SATA or SCSI RAID vendor. 1 is the cheapest solution, while 10 is the best for overall error proofing and reliability. Also, 10 spans across multiple spindles before mirroring, so your throughput can be decreased significantly from that of a RAID-1 setup. http://graphics.adaptec.com/pdfs/ACSP_RAID_Ch4.pdf Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Dennis Bartlett Sent: Thursday, September 02, 2004 9:20 AM To: [EMAIL PROTECTED] Subject: [U2] Anyone have experience mirroring a HDD over a WAN Anyone have experience mirroring a HDD over a WAN? We have a scenario where triggers were going to be the data collection and a distribution program to blow extracted data to various end of the earth. All this was an attempt to maintain a 24/7 access to a working system. = All log on to the main server and work as at present. = When comms break at any branch, they log into their own server and continue to work (the data being an exact copy of that on the HO server up until the night before = synchronization to take place at night, when network traffic is lowest) We've now had to abandon triggers, moving to a scenario where we get to modify source code (not a preferred route). This has caused us to stop and think... if this can go wrong, how much more the distribution of data onto every server at every branch (20 branches, plus HO). An alternative solution is to set up a hardware mirror to handle the movement of data. A google produces an overwhelming array of choices... What does the collective authority of the list say? PRE - GWK BEPERK/LIMITED (REG: 1997/022252/06) POSBUS 47 PO BOX 8730 DOUGLAS Direkteure/Directors: NB Jacobs, FJ Lawrence, J v/d S Botes, JH Coetzee, JGD Smit, JF Jacobs, AO M|ller, JW Smit, JP Snyman, JG Stander, JH van Dyk(MD/BD), JG Jacobs, A M|ller, M van Zyl, Sekr/Secr: E van Niekerk. Hierdie e-pos is onderworpe aan 'n vrywaring beskikbaar by: http://www.gwk.co.za/DisclaimerVrywaring.asp This e-mail is subjected to the disclaimer that can be viewed at: http://www.gwk.co.za/DisclaimerVrywaring.asp/PRE --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Senior Pick Programmer position Denver, Colorado
I think codingitis is the cause. Time to lay off the keyboard for a while, man. You know, semi-colons start to disappear after 6 hours of continuous coding. Any higher amount of time can cause strange things to happen. I remember starting during mid-day and missing night-time once, while programming a test application in Borland C 3.0. I think my brain crashed and rebooted to idle, for the rest of the day. Though, I can't really remember much about that day.. or the application for that matter. *pondering look* I do remember that there was one compiling error that never went away. Probably a missing semi-colon... :P Glen -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Debster Sent: Wednesday, September 01, 2004 2:09 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Senior Pick Programmer position Denver, Colorado Chuck Did you have nourishment today? Eat some carrots lately? Have your glasses on? ;-) It's in the subject line...Denver ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Results Sent: Wednesday, September 01, 2004 1:59 PM To: [EMAIL PROTECTED] Subject: Re: [U2] Senior Pick Programmer position Denver, Colorado William, Unless I missed it, there's no locational information in the post, which makes Relocation will not be considered - we are seeking a local candidate. difficult. -- - Charles Barouch (718) 762-3884 x 1 - Key Ally Voice Mail [EMAIL PROTECTED] - Consulting services [EMAIL PROTECTED] - News [EMAIL PROTECTED] - U2-Users Moderator [EMAIL PROTECTED]- Zeus Data Integration Mount Olympus, Home of Zeus Data Integration --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Anti-virus recommendations for Universe on Windows?
I'd prefer the entire file to be scanned every time. You never know if a virus is slowly plugging its bits into a file. A diff check on a file will not detect a known virus signature. The signature would be spread all over the file. Look at the B1 virus. It destroys FAT partitions by taking its time and deleting a link here and there. Nothing major to start with, until your files start to blow up one by one. :P A well programmed scanner with heuristic analysis can blaze through a 200MB file. Most virus scanners is a harsh term, considering I've seen 100-200%+ performance difference in scanning with 3 or 4 different scanners checking the same files. Every virus scanner has a focal point. Some focus on run-time checking, while another may focus on batch scanning or protocol sniffing. I've yet to find one that does it all extremely well and doesn't interfere with performance on a regular basis. F-PROT is about the best, overall, for all platforms. AVG is a great well-rounded tool for Windows. Panda isn't bad, but I still feel it's over marketed for what's really there. I remember them badgering me @ Comdex `99, every time I walked by their booth. Maybe I'm biased now? Sophos is OK, but it's popular enough to be a direct virus target. Does Sophos have integrity measures, to assure its own files can't be changed? I don't know how many times I've had to re-install Norton AV due to direct infection. I'm sure there are some other scanners that I haven't road-tested. For the most part, I'm happy with AVG on Windows and don't wanna look any further at the moment. If I was running X-windows, I'd have F-PROT running. After all, it was one of the first scanners and they have it down to a science now. I had the free version running on DOS 6.22 for my BBS back in the early 90's. Scary eh? Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Adrian Matthews Sent: Thursday, August 26, 2004 9:57 AM To: [EMAIL PROTECTED] Subject: RE: [U2] [UV] Anti-virus recommendations for Universe on Windows? so it only scans files that have changed. That's the problem with most virus scanners. Consider a 200mb file with a million records in it. What do you think the virus scanner is going to do each time a record (even one character) is changed in that file? Some of them must be intelligent enough to only access the parts of the file that have changed, such as the higher level backup programs do now. But I bet the majority will just see the file as changed and scan the whole thing. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: 26 August 2004 13:58 To: [EMAIL PROTECTED] Subject: Re: [U2] [UV] Anti-virus recommendations for Universe on Windows? Date: Wed, 25 Aug 2004 09:51:36 -0700 From: David Scoggins [EMAIL PROTECTED] ... We now are considering installing McAfee AV on the Universe servers anyway in light of this event. Does anyone have any recommendations regarding how to eliminate the McAfee/UV conflict, or is there a better alternative - e.g. Symantec/Norton, AVG, F-Prot, etc? Consider looking at Sophos (http://www.sophos.com). You can download an evaluation version from their website, although you do have to register to get it. I don't use U2 on Windows, but I know that Sophos takes a very non-intrusive approach and does not affect system performance as much as Norton. The on access scanner keeps track of clean files, so it only scans files that have changed. --Tom Pellitieri Century Equipment Toledo, Ohio --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ The information contained in this email is strictly confidential and for the use of the addressee only, unless otherwise indicated. If you are not the intended recipient, please do not read, copy, use or disclose to others this message or any attachment. Please also notify the sender by replying to this email or by telephone +44 (0)20 7896 0011 and then delete the email and any copies of it. Opinions, conclusions (etc.) that do not relate to the official business of this company shall be understood as neither given nor endorsed by it. IG Markets Limited and IG Index Plc are authorised and regulated by the Financial Services Authority and, in Australia, by the Australian Securities and Investments Commission. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Precision question...
The main advantage of not storing the decimal, is being able to easily display a precision value any way you want. We do this (4-digit precision) for sale price calculations(cost * markup). The only drawback is making sure you keep all the values, for a specific record, in the same decimal length. On the other hand, you could store the masking length for each value, in a relative sub-value. I dunno why you'd wanna do that, though. MD (Decimal Mask) or MD (Decimal Output) (Decimal Mask) A=1.01643452 B=ICONV(A,MD8) ; 101643452 C=OCONV(B,MD28); 1.02 D=OCONV(B,MD48); 1.0165 E=OCONV(B,MD68); 1.016436 F=OCONV(B,MD8); 1.0164352 Forgive me if my rounding logic is incorrect. I can't remember if MD rounds up, if the next digit is not zero. Maybe some more caffeine would help. Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Shawn Waldie Sent: Thursday, August 26, 2004 4:47 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Precision question... Since storage space is relatively cheap these days, what's the advantage of storing numbers without decimal points? Or is that not even the issue? -Original Message- From: Allen E. Elwood (CA) [mailto:[EMAIL PROTECTED] Sent: Thursday, August 26, 2004 1:46 PM To: [EMAIL PROTECTED] Subject: RE: [U2] Precision question... Ahh...apparently the system you work with is actually storing the decimal point. The systems I've worked with do not store the actual decimal point, so therefore the MD82 dealy-bob wouldn't be applicable. --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] [UV] Anti-virus recommendations for Universe on Windows?
Check out AVG. It's fairly inexpensive and it runs well on Win2K and up. Norton hinders more than it helps. I remove all copies of the NAV stuff from OEM PCs. I've never had anything but problems from it. Grisoft uses Inktomi for their updates, so upgrades and updates are typically fast. Plus, it's not a famous virus scanner, so trojans and bugs won't look for scanner files to mask. I dunno how many times NAV has gotten infected before it even knew there was a virus! http://www.grisoft.com Glen http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of David Scoggins Sent: Wednesday, August 25, 2004 12:52 PM To: U2 Users (E-mail) Subject: [U2] [UV] Anti-virus recommendations for Universe on Windows? Unfortunately, we have just discovered that one of our UV servers (UV 10, W2K) has become infected with the Blaster worm. We have McAfee (formerly Network Associates) AV installed on all of our client PCs, but we haven't installed it on any of the UV servers because of conflicts between McAfee and Universe reported on this list and elsewhere. We suspect it was brought in on a visitors laptop, and we're trying to determine how it managed to get into a privileged part of the network, but that's really closing the barn door after the horse has escaped at this point. We now are considering installing McAfee AV on the Universe servers anyway in light of this event. Does anyone have any recommendations regarding how to eliminate the McAfee/UV conflict, or is there a better alternative - e.g. Symantec/Norton, AVG, F-Prot, etc? David Scoggins IT Analyst CornerStone Propane mailto:[EMAIL PROTECTED] --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/
RE: [U2] Data Security
Look at OpenSSL. You can use the -a switch to base64 encode/decode the binary encrypted blob. I'm using that right now for DES3 credit card data on D3. http://picksource.com/modules.php?name=Newsfile=articlesid=97mode=thread; order=1thold=0 Glen aka PickCoder http://picksource.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Robert Gisi Sent: Tuesday, August 24, 2004 1:38 PM To: [EMAIL PROTECTED] Subject: [U2] Data Security I understand from IBM that there is a problem storing Encrypted data in a Unidata database because some of the Encrytpion characters are in conflict with our restrictive characters Multi-values ,Sub-values and others. So how is this issue being resolved in the user community? Please feel free to email me directly since I am aware this is a sensitive subject. I have an urgent need of a resolution . --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/ --- u2-users mailing list [EMAIL PROTECTED] To unsubscribe please visit http://listserver.u2ug.org/