Expert Advice

Solution Search:
How difficult is it still for an enterprise to switch out Microsoft Office for OpenOffice? How will OpenOffice hold up over time, in terms of being compatible with other office suites and formats?

Switching from one office suite to another has a lot of variables that depend on preparedness, the documents themselves, the expertise... More...

Open source software is considered to be more secure than proprietary software in many respects, but certainly there are some security issues that open source users should keep in mind. What are the most important of those issues?

I think that both open source and commercial, proprietary software have security issues and... More...

I am using MySQL 5.0. When I go to connect to it, I get the error message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client." How do I update my client library?

I answer this on such a regular basis that I have a FAQ entry dedicated to it on my site. Click here to read the response. MySQL expert... More...

Are there any high-availability database architectural issues or options to be conscious of on Linux?

Generally speaking, because Unix has been around longer and is more mature with high-availability solutions, I would recommend that you at least consider Unix for enterprise mission-critical, high-availability applications... More...

How do firms compete with open source? What resources become critical in managing their growth? What strategies do they adopt to co-exist with dominant proprietary software firms? How do they interface with communities of practice to exploit network externalities? What strategies do they adopt to lock-in developers?

Firms... More...

What are the differences between policies and rules? Policies and rules perform two distinct functions:

Policies represent the default behavior of your iptables firewall. They tell iptables what to do if no rule deals with a particular packet. There are three possible policies you can set: ACCEPT, REJECT or DROP. Respectively... More...

It has been recommended that companies need an open source strategy. What exactly does that mean? Open source software has arrived in the enterprise, and we'll see it used alongside proprietary software for years to come. CIOs and IT Directors need to have an understanding of how open source will fit into their existing... More...
What is the difference between a compiler and an interpreter? They are both similar as they achieve similar purposes, but inherently different as to how they achieve that purpose. Compiled code takes programs (source) written in some kind of programming language, and then ultimately translates it into object code or machine... More...
How can I run Windows applications on Linux? There are two common options for running Windows applications on Linux:

Win4Lin
Win4Lin is software that runs on top of Linux and provides a guest operating system. It currently supports Windows 95, Windows ME, Windows 2000, Windows NT, and Windows XP. With Win4Lin, you run the entire Windows... More...

For those of us who work in small IT shops, isn't open source code irrelevant? Isn't open source code so complex that we'd have to have a code guru on staff to modify it? If we don't have the in-house expertise to do this, then why should we use open source software?

Yes and no. The trick here is to choose open source software that has made it beyond... More...

My organization has decided to use Active Directory for authentication puposes. I've been asked to deploy AD in 80 different sites around the world. In about 35 sites, I have Linux servers used as file & print -- and authentication as well, since we didn't have a clear policy up to now regarding authentication. I've read the SAMBA Howto and it... More...
I currently am using Windows XP and want to keep it, but at the same time I would like Linux as a second operating system. How to I go about installing Linux with out losing XP? I would like to keep XP as the primary boot.

You can set up Linux as another operating system on the same machine that can be chosen at boot time. This is called "dual... More...

I'm planning on porting my organization's apps to Linux. What sort of training do I need to implement for personnel in order to prepare them properly? What should I consider when creating a porting schedule?

It depends on several factors. What is your staff using now? Is it Windows or Unix? If it is Unix, your learning curve will be lower... More...

Can you tell me how I can create linked tables in MySQL as I'm able to do in Access? I have two databases. Master tables are in one database and other tables are in another database. I want to be able to use all tables from one database with either of the two databases.

If all the databases exist on the same MySQL server, there is no need to set up... More...

Does Firefox offer an IE emulator with Linux or BSD?

The closet you can get to running IE on a Linux or BSD system is to actually run it under WINE.

What people think of as the "IE Emulator" for Firefox on Windows is actually a Firefox tab in which IE is embedded, so that it is running- on Windows, naturally. Firefox also offers an extension... More...

My apps now run on 32-bit servers. What are some indicators that they need to be moved up to 64-bit servers? Can you offer some best practices when moving apps up to 64-bit servers?

How are your applications running? Are they experiencing performance problems? Are you looking to scale upwards to a larger system or possibly run more... More...

I'm using MySQL 5.0.18, and I'm trying to use LOAD DATA INFILE to load data into a table with large BIT columns. I've tried various formats for the BIT column values (0x01, b'01', 1), but the resulting value is never correct. If I export an existing table using SELECT INTO OUTFILE, it creates the text file with an irreproducible binary value for the... More...
How do you set a table to timestamp one field on insert and another on update?

Unfortunately, MySQL does yet not support table definitions with two different automatic timestamps. There are a few ways around this limitation.

One solution is to forego attempts at automatic timestamps, and explicitly set the time in the data... More...

How many slaves can be set with MySQL 5.0? We plan to set a configuration with a single master on many boxes serving as slaves, but we have to know tha maximum number of slaves that can be set to avoiding troubles on the master side.

Generally traffic from slave machines has a minimal impact on the master. The presence of more slaves... More...

What are some automated open source tools that can scan for flaws in software? I am not aware of any open source tools that perform this function. All of the tools I have seen are commercial: Fortify, Coverity and Agitar.

I think is also important to note that scanning cannot totally replace manual audits. Tools can remove some of the... More...

I am a UNIX/Oracle/Progress technical consultant. I know my way around the system prompt. But what really bugs me is installing software that is not part of the distribution. Dependancies, prerequisites, kernelsources, etc, it's all to much for me and sometimes leaves me in despair. Is there a package that incorporates all of these... More...
Most of what I use my PC for I can do with Linux and OpenOffice, Firefox, GIMP, etc. We have already abandoned Microsoft Office for OpenOffice and IE/Outlook for Firefox/Thunderbird throughout the company. I am keen to migrate (myself, three PCS, the 15 users and their PCs that I look after) to Linux but I need book-keeping software that will... More...
I have already moved most of my company's server applications to Linux. Now, I want to test commercial desktops. SuSE and Red Hat are on my list. Are there others I should check? If I decide to roll SuSE out to our users -- now running Windows XP -- are there any gotchas I should watch out for?

In my experience, SuSE is pretty straightforward to use... More...

I am a starter for MySQL 5.0 for Win2000. MySQL 5.0 showed a DOS-type interface. Is there a GUI/IDE interface for MySQL like we have for Microsoft SQL Server and most other Windows packages?

There are several GUI interfaces to MySQL. Some are free under GPL; others require purchase of a per-user license. Official products from the company... More...

It has been recommended to me to have a security audit performed on a Linux server hosted by an outside hosting company. Can you please provide me with a checklist of things to look for? Is it worth hiring an outside company to perform this security audit for me? If so, do you have any recommendations?

If you aren't aware of what to look for... More...

SUSE White Papers
DB2 10: What's new in DB2 10 for Linux, UNIX, and Windows by IBM
  • productivity
  • And more.

Discover how DB2 10 for Linux, UNIX and Windows can help you support your complex, demanding business environment.

Riverbed Stingray Traffic Manager VA Performance on vSphere 4 by Riverbed Technology, Inc.
VA) improves traffic performance compared to a Linux install.

Cloud infrastructure platforms like VMware vSphere 4.0 can significantly benefit from load balancers that connect users to the most suitable datacenter. This white paper outlines how the Riverbed Stingray Traffic...

Migrating Your Legacy IBM Database Environment to the Latest Oracle Technologies by Oracle Corporation
the Intel Xeon Processor 7560 running Oracle Linux 5.5 Operating System.

This guide reviews the recommended approach for planning and implementing the migration of applications on an IBM Power system running AIX to Oracle’s Sun Fire X4800 Server with the Intel Xeon Processor...

Linux Security Corner
Uptime and the Value of Clustering for Linux Servers by Global Knowledge
to any number of remaining nodes. Now imagine this in your data center, with your already deployed Linux servers, on your existing commodity x86 hardware. This is the promise of clustering.

This white paper explores the need for uptime, explains the three components that...

DB2 10: What's new in DB2 10 for Linux, UNIX, and Windows by IBM
  • savings
  • Better application performance
  • Higher productivity
  • And more.

Discover how DB2 10 for Linux, UNIX and Windows can help you support your complex, demanding business environment.

How Cox Enterprises Cut Costs, Improved Performance in One Week by Red Hat and HP
Access this resource to learn how one organization migrated to the Red Hat Enterprise Linux platform to improve performance, achieve cost savings and increase flexibility for its critical architecture.

Access this resource to learn how one organization...