Saturday, June 26, 2010

Drupal 6 on GlassFish 3 with Quercus using NetBeans 6.9 in less than 5 minutes

This is an update to my previous blog post on using Drupal on GlassFish with Quercus. Since I have been writing blog posts I have found that it is important to distinguish which versions of software I am using.

Software
Mac OS X 10.6.4
MySQL 5.1.48
MySQL Connector/J 5.1.12
NetBeans 6.9
GlassFish 3.0.1
Drupal 6.17
Quercus 4.0.3

Database:
  1. Create the Drupal user in the database.


    GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER ON drupal.* TO 'drupal'@'localhost' IDENTIFIED BY 'drupal';

    Note: This is not secure and should only be used for demo.

  2. Create a new database in mySQL called drupal.


    create database drupal character set utf8;
Quercus:

Download and extract the quercus-4.0.3.war file.

jar -xvf quercus-4.0.3.war WEB-INF
 
Drupal:
  1. Download and extract Drupal 6.17
  2. Copy the WEB-INF directory and files from the Quercus into the Drupal directory.
MySQL Connector/J
  1. Extract mySQL Connector/J


    unzip mysql-connector-java-5.1.12.zip
  2. Copy the mysql-connector-java-5.1.12-bin.jar to the ../glassfish-3.0.1/glassfish/domains/domain1/lib/ext directory. This allows any project deployed to domain1 to connect to a mySQL server.

NetBeans
  1. Create a new project. Select Java Web and Web Application with Existing Sources. Click Next.



  2. Select the location of the files we previously extracted for the Location.
  3. Accept default project name.
  4. Change the project folder name to drupal. Click Next.



  5. Ensure GlassFish Server 3 is selected as the server.
  6. The Java EE version should be Java EE 6.
  7. Change the context path to /drupal. Click Next.



  8. Set the Web Pages Folder: to point to the top level of our sources. In our case it is drupal-6.17. Click Finish.



  9. Open the Web Pages -> sites -> default folder. You should see a file called default.settings.php. Copy the file and rename it to settings.php. Our application configuration is complete.






  10. Go to the Services tab. Expand the Databases tree. Select MySQL Server. Right click and select Create Database from the context menu.
  11. Create a database called drupal. Check the checkbox for Grant Full Access To:. Pick the drupal@localhost user. Press OK.






  12. Click on the deploy button. After the application is deployed to GlassFish, you should see Drupal Configuration screen below.



  13. Select Install Drupal in English
  14. Set up the database configuration. In my case, I chose the mysqli radio button and provided database name: drupal, database username: drupal, and database password: drupal.

    Note: I had to fill in the information twice. DO NOT USE MY CONFIGURATION IN PRODUCTION.



  15. Fill in the site configuration parameters.




    Note: Once the site is deployed. I received an SMTP error as noted below. It seems that it can be safely ignored.



  16. Installation Complete.

Here is an example of what my finished site looks like.


If you want to watch a 5 minute video on the whole process, please check the link below.

Wednesday, June 16, 2010

Early Year End Predictions

I was just reading an article from Scot Finnie from Computerworld http://draft.blogger.com/post-create.g?blogID=36773632magazine on early technology predictions which usually comes out at the end of the year. It is interesting that he notes that the computer press does not engage in this activity. Really? Yet, he does just that like all tech rags do. Anyway...here are his topics and my thoughts.

1. Green IT - I think it will become more prevalent because consumer focused companies like Apple push green initiatives. The push being smaller electronic devices which are recyclable, long lived (using little power), aesthetically and morally pleasing. The advances in these technologies get pushed back to the data center in forms like flash drives, and ARM computing. It will probably not get the fanfare, but will grow like trees: slowly.

2. Cloud Computing - Look it is everywhere. See the paper on the fallacies of distributed computing. I am a big advocate for clouds, but I am not sure that public clouds are where you can reliably place your business interests. DoS attacks are a simple, but reliable way for hackers to cause immense damage to a business which is focused on cloud spaces. They may not break into your public cloud infrastructure, but simply causing your users to tire of slow, or no response is a business killer. Patience is not an American virtue. Private clouds I think are going to become more prevalent, along with businesses aggregating their cloud initiatives in shared "private" clouds in private data centers. Facilities like Immedion in Greenville, SC are positioned to provide data center services, and a semi-privatem or shared cloud offerings to customers within a data center.

3. Mobile Devices - Agreed with Scot..."Get ready, or get run over."

4. Unified Communications - I have heard this story over and over. I have been part of this pipe dream. Every new communication method needs to be considered, and they are growing without bounds. What do I mean? Social media is part of the communication spectrum. Twitter is just as valuable as email. Today's teens through 30 somethings like 140 character digestible bites of information. Earlier I noted that American's have a patience issue, I discovered the Europeans have SMS addictions. Lotus Notes and Outlook are currently not up to this task.

5. Business Intelligence - 5 years ago this was just a talking point for the future. Today it is here and growing like Kudzu. Be careful, there are so many offerings and vendors; a consolidation is coming.

6. Data De-duplication - This, in my judgement, goes along with Green IT. Reducing the amount of redundant data means less hardware, and energy.  There are so many silos at most companies, that this should be a priority. I can recommend this to AT&T for sure.

They had an epic FAIL at Southeast Linuxfest, and it took many calls to different people on different systems just to find out they could not tell us anything. The accounts had varying incorrect (and correct) information which was duplicated between systems. Can you say one-to-many relationship. Instead we had four separate accounts for one company. How many more companies are like that? That is just one example.

7. Enterprise 2.0 - Really? Why not call it Web 2.0 ... I am not really keen on the terms, but since we are looking a major release numbers instead of dot releases, I should be happy. This is a result of consumers having the same level of expectations from big businesses as they do from Google Mail. We will see more without a doubt. I think businesses should really think about what they are doing in the rich web experience though. A example of an application which is horrible on low bandwidth is Quickbooks Online. The AJAX calls make it nearly unusable on a heavily used network. Just because you can use auto-complete doesn't mean you need to use it.

8. Videoconferencing - Epic Fail. Cisco Telepresence is a nice concept, but I had a couple of less than favorable encounters, and they were supposedly good implementations. I love the idea of making a video call. It has been a dream from 2001: A Space Odyssey. It shows up on a number of sci-fiction films and is used really well for example Blade Runner. Corporate environments should avoid it as much as possible. I still like to shake hands with the people I am doing business with. Call me old fashioned, but I see a number of people back-lashing on video calls. Use it internally and not externally.

9. Identity Management - Funny, I just handed my wife a t-shirt last night from a vendor who was offering Identity Management solutions. It is a two year-old t-shirt from a conference I attended. I have not even worn the shirt. It has lasted longer than the vendor. All I have to say is SSO, and we know how successful Identity Management is at this point. I think companies should spend more time working on it, but have an understanding it is an ongoing process and not a project.

10. Security - Vendors should focus on making security easy and innate in their products. Do you use gpg, or can you generate and install client certificates? What is Camilla, or SHA? Exactly. If you can answer "Yes", or explain those terms, you are a small segment of the IT population. Security is complex and it is that complexity that makes implementing some basic security models difficult, for example SSL. This is just the tip of the ice berg. It is also a process which means by definition it is on-going. I hope to see more from vendors, regulators, and governments to make it easier to implement.

Southeast Linuxfest

This last weekend was the Southeast Linuxfest in Spartanburg, SC. All I can say is that if you missed it, you missed a great time which was had by all.

In the spirit of full disclosure, I am the treasurer for the foundation that supports the festival, but based on the comments, emails, and tweets; everyone had a blast.

We will begin planning the event for 2011 in a couple of weeks. All of the board members, and coordinators need a couple of weeks break after the event. The last couple of weeks have been crazy, but it was worth it.

Our preliminary attendance for the event was 742 people. This represents a significant growth from last year. This is the second year of the festival, and we had some growing pains. Our overconfidence was partly our undoing. I can say that the difference maker for the event was our volunteers. I can not say enough nice things about them. They put in some long hours, but remarked that it was worth it.

Our sponsors were really cool. I had a chance to talk to a number of them, and they were enjoying the event. I was very busy during the event so I did not get a chance to meet with all of them. Next year I will make it a priority to visit them all.

We had a number of kids working at the event including my 9 year old son who were great. They worked the registration desk, sold raffle tickets, and were runners bringing drinks (soda/water) to vendors. They also were tasked with handing out swag. Universally, everyone at the event thought they were polite, and helpful. BZ to the kids.

We will be publishing all the talks as we get the videos edited. We did the same thing last year, and it was very popular.

Popular Posts