Welcome!

Linux Authors: Yeshim Deniz, Elizabeth White, Carmen Gonzalez, Trevor Parsons, Pat Romanski

Related Topics: Linux

Linux: Article

State Government Leads the Way with LAMP

An online database using open source tools

Jim Willis, director of e-Government Services for the Rhode Island Office of the Secretary of State, was a consultant for the state when he implemented an online database using open source tools. The ability to use open source technologies was a condition of his hiring, and the state has benefited as a result of his leadership.

Putting Linux in Plain View

The first project Willis undertook was an online rules and regulations database available to the public and other government agencies. It was the proof that open source tools could deliver value for less. The whole project was delivered for $40,000 with Willis working alone part time for four months. Because the new online database faced the public, it was the perfect test for open source value.

Willis was promoted to director of e-Government after the next election of a new Secretary of State, and he took on the role of advising other agencies on the use of open source. A high-level member of the new secretary's staff was well versed in open source, and encouraged a more open attitude toward Willis' proposals. A trend of working to improve efficiency in IT has also worked in favor of open source adoption.

The LAMP Development Model

A major trend has emerged in Internet development utilizing four open source tools or platforms: Linux for the operating system; Apache for the Web server; MySQL for the database; and PHP, Perl, or Python for the custom code (LAMP). Willis used these tools for the rules and regulations database and was able to complete the project in less time than other development models would have allowed.

Willis has been consistently pleased with the performance of the MySQL database. It is running on a Dell server with Red Hat preinstalled, with almost perfect uptime. MySQL was also included in the Red Hat installation. Agencies use a custom PHP form to upload their regulation files in PDF format. Willis was already familiar with PHP, so it was a natural choice. Some freely available Perl code was adapted to provide certain functions as well, but the vast majority of development occurred using PHP.

A big advantage of open source is that help is easier to find. Willis recommends developing staff who are able to find the solutions to problems because no one has memorized how to handle every situation. You just have to know where to look. "I've called Red Hat for support just once, when I was getting started. Google is really the first line of support."

Saving Time Is More Important Than Saving Money

After his initial success with the rules and regulations online database, Willis looked for other ways to use open source software. He started by replacing an Exchange server with Courier IMAP and QMail on Linux, and replacing Outlook with SquirrelMail, a Web-based e-mail client. Users were having trouble with Outlook, and his staff was spending too much time supporting it. Willis picked the e-mail system as a good migration candidate because he knew it would save both money and time. It took Willis' team two days to migrate the mail server. They saved money in licensing costs by replacing Windows and Microsoft Exchange, but the biggest benefit has been the free time to devote to other projects. Willis says that he saves between 6–10 hours per week of support time with the new system. The reliability of open source software on Linux is allowing him to pursue other projects that will benefit the public.

Cost is still an issue, of course. Before starting on any migration to open source, Willis does an informal analysis to find out how much it will save the state. In his case, it's sufficient justification to proceed.

Web Servers and Databases

The next step was to start migrating Web servers and database servers. Willis had several Microsoft IIS servers that needed to be upgraded. By now, his staff was familiar with Apache, so they used Linux and Apache as a replacement for Windows and IIS. There was one glitch, however. They had previously written Active Server Pages that needed to be converted to PHP and Perl.

According to Willis, when you have applications "write" code for you, rather than code by hand, it's hard to know later what you've done. This made it somewhat difficult to convert the applications. They tried some conversion tools, such as asp2php. It worked sometimes, but Willis found that it was easier to rewrite the applications. Most of them were just database query scripts, which were easy to rewrite, and took about 3–4 days per script. All of the servers that Willis' team has converted have paid for themselves already.

Advice for Other States

Now other states are asking Jim Willis for advice in adopting open source. His advice for getting started is to take on a small migration project first to prove to colleagues that it will work. "Don't pick something critical for the first project.

Pick a server that provides an important service, though, that people will be able to see in action."

He generally plans a migration when one of two things happen: he is tired of always supporting a problem system, or he needs to purchase an upgrade.

Open Source Software Utilized

The State of Rhode Island Secretary of State's office saves 6–10 hours per week of support time with a migration to Linux and a Web-based e-mail solution, instead of Microsoft Exchange and Outlook.

Open source products used are:

  • Red Hat Linux
  • Apache Web server
  • MySQL database
  • PHP Web scripting language
  • Courier IMAP, QMail
  • SquirrelMail

More Stories By Maria Winslow

Maria Winslow is the author of The Practical Manager's Guide to Open Source, available at http://www.lulu.com/practicalGuide and can be contacted at [email protected]

Comments (0)

Share your thoughts on this story.

Add your comment
You must be signed in to add a comment. Sign-in | Register

In accordance with our Comment Policy, we encourage comments that are on topic, relevant and to-the-point. We will remove comments that include profanity, personal attacks, racial slurs, threats of violence, or other inappropriate material that violates our Terms and Conditions, and will block users who make repeated violations. We ask all readers to expect diversity of opinion and to treat one another with dignity and respect.


@ThingsExpo Stories
The definition of IoT is not new, in fact it’s been around for over a decade. What has changed is the public's awareness that the technology we use on a daily basis has caught up on the vision of an always on, always connected world. If you look into the details of what comprises the IoT, you’ll see that it includes everything from cloud computing, Big Data analytics, “Things,” Web communication, applications, network, storage, etc. It is essentially including everything connected online from hardware to software, or as we like to say, it’s an Internet of many different things. The difference ...
Cloud Expo 2014 TV commercials will feature @ThingsExpo, which was launched in June, 2014 at New York City's Javits Center as the largest 'Internet of Things' event in the world.
An entirely new security model is needed for the Internet of Things, or is it? Can we save some old and tested controls for this new and different environment? In his session at @ThingsExpo, New York's at the Javits Center, Davi Ottenheimer, EMC Senior Director of Trust, reviewed hands-on lessons with IoT devices and reveal a new risk balance you might not expect. Davi Ottenheimer, EMC Senior Director of Trust, has more than nineteen years' experience managing global security operations and assessments, including a decade of leading incident response and digital forensics. He is co-author of t...

ARMONK, N.Y., Nov. 20, 2014 /PRNewswire/ --  IBM (NYSE: IBM) today announced that it is bringing a greater level of control, security and flexibility to cloud-based application development and delivery with a single-tenant version of Bluemix, IBM's platform-as-a-service. The new platform enables developers to build ap...

The major cloud platforms defy a simple, side-by-side analysis. Each of the major IaaS public-cloud platforms offers their own unique strengths and functionality. Options for on-site private cloud are diverse as well, and must be designed and deployed while taking existing legacy architecture and infrastructure into account. Then the reality is that most enterprises are embarking on a hybrid cloud strategy and programs. In this Power Panel at 15th Cloud Expo (http://www.CloudComputingExpo.com), moderated by Ashar Baig, Research Director, Cloud, at Gigaom Research, Nate Gordon, Director of T...
Explosive growth in connected devices. Enormous amounts of data for collection and analysis. Critical use of data for split-second decision making and actionable information. All three are factors in making the Internet of Things a reality. Yet, any one factor would have an IT organization pondering its infrastructure strategy. How should your organization enhance its IT framework to enable an Internet of Things implementation? In his session at Internet of @ThingsExpo, James Kirkland, Chief Architect for the Internet of Things and Intelligent Systems at Red Hat, described how to revolutioniz...
Technology is enabling a new approach to collecting and using data. This approach, commonly referred to as the "Internet of Things" (IoT), enables businesses to use real-time data from all sorts of things including machines, devices and sensors to make better decisions, improve customer service, and lower the risk in the creation of new revenue opportunities. In his General Session at Internet of @ThingsExpo, Dave Wagstaff, Vice President and Chief Architect at BSQUARE Corporation, discuss the real benefits to focus on, how to understand the requirements of a successful solution, the flow of ...
The security devil is always in the details of the attack: the ones you've endured, the ones you prepare yourself to fend off, and the ones that, you fear, will catch you completely unaware and defenseless. The Internet of Things (IoT) is nothing if not an endless proliferation of details. It's the vision of a world in which continuous Internet connectivity and addressability is embedded into a growing range of human artifacts, into the natural world, and even into our smartphones, appliances, and physical persons. In the IoT vision, every new "thing" - sensor, actuator, data source, data con...
"BSQUARE is in the business of selling software solutions for smart connected devices. It's obvious that IoT has moved from being a technology to being a fundamental part of business, and in the last 18 months people have said let's figure out how to do it and let's put some focus on it, " explained Dave Wagstaff, VP & Chief Architect, at BSQUARE Corporation, in this SYS-CON.tv interview at @ThingsExpo, held Nov 4-6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
Focused on this fast-growing market’s needs, Vitesse Semiconductor Corporation (Nasdaq: VTSS), a leading provider of IC solutions to advance "Ethernet Everywhere" in Carrier, Enterprise and Internet of Things (IoT) networks, introduced its IStaX™ software (VSC6815SDK), a robust protocol stack to simplify deployment and management of Industrial-IoT network applications such as Industrial Ethernet switching, surveillance, video distribution, LCD signage, intelligent sensors, and metering equipment. Leveraging technologies proven in the Carrier and Enterprise markets, IStaX is designed to work ac...
"There is a natural synchronization between the business models, the IoT is there to support ,” explained Brendan O'Brien, Co-founder and Chief Architect of Aria Systems, in this SYS-CON.tv interview at the 15th International Cloud Expo®, held Nov 4–6, 2014, at the Santa Clara Convention Center in Santa Clara, CA.
C-Labs LLC, a leading provider of remote and mobile access for the Internet of Things (IoT), announced the appointment of John Traynor to the position of chief operating officer. Previously a strategic advisor to the firm, Mr. Traynor will now oversee sales, marketing, finance, and operations. Mr. Traynor is based out of the C-Labs office in Redmond, Washington. He reports to Chris Muench, Chief Executive Officer. Mr. Traynor brings valuable business leadership and technology industry expertise to C-Labs. With over 30 years' experience in the high-tech sector, John Traynor has held numerous...
Bit6 today issued a challenge to the technology community implementing Web Real Time Communication (WebRTC). To leap beyond WebRTC’s significant limitations and fully leverage its underlying value to accelerate innovation, application developers need to consider the entire communications ecosystem.
The 3rd International @ThingsExpo, co-located with the 16th International Cloud Expo - to be held June 9-11, 2015, at the Javits Center in New York City, NY - announces that it is now accepting Keynote Proposals. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devices - computers, smartphones, tablets, and sensors - connected to the Internet by 2020. This number will continue to grow at a rapid pace for the next several decades.
The Internet of Things is not new. Historically, smart businesses have used its basic concept of leveraging data to drive better decision making and have capitalized on those insights to realize additional revenue opportunities. So, what has changed to make the Internet of Things one of the hottest topics in tech? In his session at @ThingsExpo, Chris Gray, Director, Embedded and Internet of Things, discussed the underlying factors that are driving the economics of intelligent systems. Discover how hardware commoditization, the ubiquitous nature of connectivity, and the emergence of Big Data a...
Almost everyone sees the potential of Internet of Things but how can businesses truly unlock that potential. The key will be in the ability to discover business insight in the midst of an ocean of Big Data generated from billions of embedded devices via Systems of Discover. Businesses will also need to ensure that they can sustain that insight by leveraging the cloud for global reach, scale and elasticity.
SYS-CON Events announced today that Windstream, a leading provider of advanced network and cloud communications, has been named “Silver Sponsor” of SYS-CON's 16th International Cloud Expo®, which will take place on June 9–11, 2015, at the Javits Center in New York, NY. Windstream (Nasdaq: WIN), a FORTUNE 500 and S&P 500 company, is a leading provider of advanced network communications, including cloud computing and managed services, to businesses nationwide. The company also offers broadband, phone and digital TV services to consumers primarily in rural areas.
SYS-CON Events announced today that IDenticard will exhibit at SYS-CON's 16th International Cloud Expo®, which will take place on June 9-11, 2015, at the Javits Center in New York City, NY. IDenticard™ is the security division of Brady Corp (NYSE: BRC), a $1.5 billion manufacturer of identification products. We have small-company values with the strength and stability of a major corporation. IDenticard offers local sales, support and service to our customers across the United States and Canada. Our partner network encompasses some 300 of the world's leading systems integrators and security s...
IoT is still a vague buzzword for many people. In his session at @ThingsExpo, Mike Kavis, Vice President & Principal Cloud Architect at Cloud Technology Partners, discussed the business value of IoT that goes far beyond the general public's perception that IoT is all about wearables and home consumer services. He also discussed how IoT is perceived by investors and how venture capitalist access this space. Other topics discussed were barriers to success, what is new, what is old, and what the future may hold. Mike Kavis is Vice President & Principal Cloud Architect at Cloud Technology Pa...
Cloud Expo 2014 TV commercials will feature @ThingsExpo, which was launched in June, 2014 at New York City's Javits Center as the largest 'Internet of Things' event in the world. The next @ThingsExpo will take place November 4-6, 2014, at the Santa Clara Convention Center, in Santa Clara, California. Since its launch in 2008, Cloud Expo TV commercials have been aired and CNBC, Fox News Network, and Bloomberg TV. Please enjoy our 2014 commercial.