Installing MySQL
by Vinita Choudhary, Pallika Majmudar, Amita Bhandari, Munwar Shariff
Alfresco 3 Web Content Management
- Alfresco 3 Web Content Management
- Alfresco 3 Web Content Management
- Credits
- About the Authors
- Acknowledgement
- About the Reviewers
- Preface
- 1. A Publishing Style Web CMS
- 2. Installation and Configuration
- Installing a JDK
- Installing MySQL
- Alfresco WCM
- Installation option that is suitable for you
- Installing Alfresco
- Installing Alfresco on Windows
- Installing Alfresco on Red Hat Linux
- Installing Alfresco on Mac
- Installing the Alfresco WAR on any platform
- Modifying the directory paths for Tomcat 6.x
- Downloading the extension samples
- Deploying Share into a separate Tomcat instance
- Installing Alfresco components
- Installing Alfresco WCM
- Verifying the WCM installation
- Installing the WCM standalone deployment receiver
- Compiling and deploying the customizations on top of the WCM core
- Installing OpenOffice
- Installing ImageMagick
- Installing Microsoft Office add-ins
- Installing Flash Player
- Installing SWFTools
- Installing TinyMCE language packs
- Installing an Alfresco Module Package
- Installing Microsoft Office SharePoint Protocol Support
- Installing the SharePoint Protocol Support AMP
- Running Alfresco
- Starting and stopping Alfresco as a console application
- Installation folder structure
- Configuring Alfresco as a Windows service
- Summary
- 3. Getting Started with Alfresco WCM
- 4. Web Content Production with Web Forms
- Why web forms
- Introduction to web forms
- Creating web forms
- Rendition templates
- Associating web forms and renditions for specific/multiple project(s)
- Creating dynamic content
- Edit web forms for renditions
- Web publishing dashlets
- Summary
- 5. WCM Workflows
- Why workflows are required
- Introduction to the workflow
- Configuring workflows
- Creating a custom WCM Workflow for a group
- Expiring content in WCM
- Summary
- 6. Dynamic Deployment and Customizations
- Dynamic deployment
- Dynamic models
- Dynamic Resource Bundles
- Dynamic workflows
- Dynamic Alfresco Explorer
- Deploying Alfresco Explorer customizations
- Reloading web client customizations
- Reloading web client customizations
- Testing the workflow
- Customization of existing workflow to use e-mail notifications
- Remove workflow for specific staging submission
- Test using Submit Items wizard
- Test using Submit Items wizard
- Test using Submit Items wizard
- 7. Content Delivery and Deployment
- 8. Managing Multiple Websites Using WCM
- 9. Alfresco Surf and Web Editor
- 10. Integrating WCM Using Web Scripts
- Concepts of WCM web scripts
- Alfresco web script framework
- What's new in Alfresco 3 web scripts
- Using web scripts with Alfresco WCM
- Implementing web scripts for WCM
- Root objects of FreeMarker
- FreeMarker methods for the AVM repository
- Root objects for an execution script
- JavaScript methods for the AVM repository
- Java-backed controller
- Integrating WCM with external applications—case studies
- Integrating Alfresco WCM and Liferay with a news portlet
- Web script for getting news headlines
- Storing/registering a web script in Alfresco
- Portlet in Liferay
- Integrating Alfresco WCM and Drupal with monthly blogs
- Web script for getting monthly blogs
- Storing/registering the web script in Alfresco
- Calling the web script in Drupal
- Integrating Alfresco WCM with any J2EE web application
- Web script for getting the details of a particular news item
- Calling web scripts from a JSP page
- Web script for getting the details of a particular news item
- Summary
- 11. Leveraging Alfresco Framework for WCM
- Membership and Security Mechanism
- Common repository
- Image transformation in WCM
- Advanced search in WCM
- Case study: User Interface for Advanced Search in WCM
- Summary
- 12. WCM Administration
- Test using Submit Items wizard
- Test using Submit Items wizard
- Reloading web client customizations
- Deploying Alfresco Explorer customizations
- Dynamic deployment
This section describes how to set up a MySQL open source Relational Database Management System (RDBMS) to use with Alfresco. Some of the Alfresco installation wizards install an embedded instance of MySQL that is configured with the correct settings. If you prefer to install MySQL database independently, this section describes the configuration settings that you should use:
- Browse to the MySQL download site: http://dev.mysql.com/downloads.
- Locate and select the appropriate package for your platform. Alfresco requires MySQL 5.0.67 or higher.
- If prompted, specify a location on your system in which to download and install MySQL.
- Browse to the location where you downloaded MySQL and double-click on the installer file.
- The MySQL Server Setup wizard guides you through the MySQL installation, followed by the Configuration wizard.
Once you have installed MySQL, this task describes how to verify that it was installed correctly:
- Open the command prompt.
- In the prompt, enter:
mysql -u root -p
- Type the password that you set during the installation and press Enter. Information about the installed MySQL version displays. If no errors are reported, MySQL is installed and running.
- In the
mysql>prompt, typeexitto exit MySQL. You have verified that the MySQL installation was successful.
-
No Comment
..................Content has been hidden....................
You can't read the all page of ebook, please click here login for view all page.