Tuesday, February 14, 2012

Introduction to HeidiSQL

Some infos around HeidiSQL Project website: http://www.heidisql.com/ Google Code: http://code.google.com/p/heidisql/ *** What is HeidiSQL? HeidiSQL is an easy-to-use interface and a "working-horse" for web-developers using the popular MySQL-Database. It allows you to manage and browse your databases and tables from an intuitive Windows® interface. With HeidiSQL you will also be able to * Manage Microsoft SQL Servers, with a reduced feature set * Generate nice SQL-exports * Synchronize tables between two databases * Manage user-privileges * Import text-files * Export grid-data as CSV, HTML, XML, SQL, LaTeX and Wiki style * Browse and edit table-data using a comfortable grid * Create and edit tables, views, stored routines, triggers and scheduled events * Bulk edit tables (move to db, change engine, collation etc.) * Batch-insert ascii or binary files into tables * Write queries with customizable syntax-highlighting and code-completion * Profile your queries * Pretty reformat disordered SQL * Monitor and kill client-processes * Connect to servers via commandline * Find specific text in all tables of all databases of one server * Optimize and repair tables in a batch manner * And much more *** Requirements: HeidiSQL runs fine on Windows 2000, XP, Vista and 7. Running HeidiSQL on Wine/Linux also works fine, apart from some minor graphical glitches, e.g. the transparent areas of all icons are displayed with black color. HeidiSQL does not run on Windows 95/98 or ME, as the Unicode extensions are not available on these systems. *** Command line switches Although HeidiSQL is a pure GUI application, it can be automated for connecting and opening files via command line parameters. Parameter names are case sensitive and are based on those used by the MySQL command line applications, e.g. mysqldump. -d, -description Session name -h, -host Host name -u, -user User name -p, -password Password -P, -port Port (defaults to 3306 if not given) -S, -socket Socket name (for connecting via named pipe) --psettings Custom filename for portable settings. Ignored if file does not exist. Examples: * Start over using stored settings from session "xyz": c:\path\to\heidisql.exe -d=xyz c:\path\to\heidisql.exe -description=xyz * Connect with different username or port: c:\path\to\heidisql.exe -d=xyz -u=OtherUser c:\path\to\heidisql.exe -d=xyz -P=3307 * Connect to a non-stored session: c:\path\to\heidisql.exe -h=localhost -u=root -p=Mypass -P=3307 * Open multiple .sql files in query tabs: c:\path\to\heidisql.exe fileA.sql path\to\fileB.sql fileC.sql ... * Use custom portable settings file: c:\path\to\heidisql.exe --psettings=c:\temp\p.txt *** License: HeidiSQL is OpenSource and released under GPL (GNU GENERAL PUBLIC LICENSE). Probably HeidiSQL saved you a lot of time and you like it. In this case you may make a donation here: http://www.heidisql.com/donate.php *** Credits: Ansgar Becker (project lead and development), David Dindorp (former development), Francisco Ernesto Teixeira (former development), Andrew Brampton (LaTeX export), Sven Lorenz (graphics), Mikkel M. Gerhardt-Pedersen (additional bugfixes), Mike Lischke + Timo Tegtmeier (VirtualTreeView, GLPL), Maël Hörz (SynEdit, MPL), Iztok Kacin (Cromis.DirectoryWatch, BSD License), Mark James (Silk icons, Creative Commons 2.5), Jordan Russell (Inno Setup) 1000 thanks to MySQL for great database software To download file install: heidisql.googlecode.com/files/HeidiSQL_7.0_Setup.exe Resource: file readme.txt content of heidisql

Friday, February 10, 2012

Introduction to iReport

iReport is the free, open source report designer for JasperReports. Create very sophisticated layouts containing charts, images, subreports, crosstabs and much more. Access your data through JDBC, TableModels, JavaBeans, XML, Hibernate, CSV, and custom sources. Then publish your reports as PDF, RTF, XML, XLS, CSV, HTML, XHTML, text, DOCX, or OpenOffice.

Thursday, February 9, 2012

Kloxo Installation Guide

Kloxo Installation Guide


1) A dedicated or virtual server running CentOS or Red Hat EL 5.x. CentOS 6.x is not currently supported.
2) At least 256 MB of RAM (enough to run Yum).
3) At least 2 GB of free disk space for Kloxo and related services.
4) If you partitioned your disks manually, make sure you have a large /tmp. Kloxo uses /tmp to create and store backups temporarily and the process will fail if there is not enough space.

Before we begin...

You have to disable SELinux by editing /etc/sysconfig/selinux and changing the line to selinux=disabled. This will keep SELinux from being enabled on your server next boot.

Then you must run the following command as root to disable SELinux for the current session:

# su - root
# setenforce 0

If you are unsure this procedure worked, you can run /usr/sbin/sestatus to check its status. Failure to correctly disable SELinux will render your Kloxo install useless and an OS reload may be required to properly reinstall it.
Also, make sure the ports 7778/tcp and 7777/tcp are open in your server firewall or you won't be able to connect to Kloxo web panel when the install completes.

Installing Kloxo

Kloxo installation consists of downloading kloxo-installer.sh from download.lxcenter.org and executing it as root. The script will present you with a few questions and sometimes ask for a password (enter your root password).

If you don't have MySQL server already installed, you must run:

# su - root
# yum install -y wget
# wget http://download.lxcenter.org/download/kloxo/production/kloxo-installer.sh

To install as Master (Default Single Server):
# sh ./kloxo-installer.sh --type=master

To install as Slave:
# sh ./kloxo-installer.sh --type=slave

If you already have MySQL installed and set a root password, you must run:

# su - root
# yum install -y wget
# wget http://download.lxcenter.org/download/kloxo/production/kloxo-installer.sh
# sh ./kloxo-installer.sh --type=<master/slave> --db-rootpassword=PASSWORD

Once kloxo is installed, you can connect to http://YOUR_SERVER_IP:7778 and you will be presented with a login screen. Login as admin with password adminand once you are in, Kloxo will ask you to change the default password to a secure one.

Packages installed initially1:

Web ServicesFunction
apache (2.x)The Apache HTTP Server is a powerful, efficient, and extensible web server.
php (5.2.x)PHP is an HTML-embedded scripting language.
pure-ftpdPure-FTPd is a fast, production-quality, secure and standard-comformant FTP server especially designed for modern Linux and FreeBSD kernels.
awstatsWeb Statistics

Mail ServicesFunction
qmail-toasterqmail is a small, fast, secure replacement for the sendmail package, which is the program that actually receives, routes, and delivers electronic mail.
courier-imap-toasterCourier-IMAP is an IMAP server for Maildir mailboxes.
vpopmailvpopmail is a collection of programs and a library to automate the creation and maintence of virtual domain email for qmail installations.
RoundcubeWebmail (Ajax)

DNS ServicesFunction
bindBIND (Berkeley Internet Name Domain) is an implementation of the DNS (Domain Name System) protocols.
bind-chrootSecures BIND server

Database ServiceFunction
mysql-serverMySQL is a multi-user, multi-threaded SQL database server.

1 You are able to switch services after install at the web panel. Apache/Lighttpd; BIND/djbdns; spamassassin/bogofilter; etc.


If you cannot connect to you Kloxo Control Panel, please check if Kloxo is running and your server firewall is not blocking access to ports 7777/tcp and 7778/tcp. You may temporarily disable it by running /etc/init.d/iptables stop and if that is the cause you may be interested in the firewall script example contributed by Kloxo users.

If you still cannot access your panel, go to our forums at http://forum.lxcenter.org (external link) and request help (you may want attach the file /root/kloxo-install/kloxo-linux/kloxo_install.log for easier troubleshooting).

Final Considerations

1) Keep in mind that Kloxo will not manage your server firewall (iptables rules). For that, you may want to install third-party firewall management scripts such as CSF (external link) (cache) or APF (external link) (cache) and its complements to detect and block threats like brute-force attacks and unauthorized processes and users.
2) If you are not familiar with the command line (shell), you might want to try Webmin (external link) (cache) for basic system administration tasks. It should not conflict with Kloxo as long as you avoid managing the services listed before with it.
3) Kloxo will never update your OS (CentOS/Red Hat) automatically. It's up to you to monitor security bulletins for your Operating System and update as necessary.
4) Kloxo will never update itself by default. You can set Auto-Update? Kloxo within the GUI. The Auto update will run at the 10th day each month and you as "Admin" will be notified by email. To update manualy, click the Update home button from the web panel OR run on the shell (as root) /script/upcp. At the web panel, you are presented with release notes that describe what's changed in the newer versions so you can act at your own discretion.

Resources: http://wiki.lxcenter.org/Kloxo+Installation+Guide

Introduction to Kloxo

Introduction to Kloxo
Kloxo is a light-weight control panel that is both memory friendly and powerful. It has all the features included in all leading control panels such as mail, spam filter, PHP, CGI, Perl, SUexec, FTP, MySQL and much more. This guide is meant to get you started with Kloxo and explain the basic features needed to get your website up and running.

Logging In

There are several ways to access Kloxo:

1. By clicking the "Kloxo" tab through HyperVM (no login required)

2. or - You can access the control panel through any IP address allocated to the server. This is useful when your domain transfer has not yet propagated. (replace with your VPS's IP address)

3. http://yourdomain:7778 - You can access the control panel through any hosted domain by putting :7778 at the end of the domain. (non-SSL)

4. https://yourdomain:7777 - You can access the control panel securely using SSL through any hosted domain by putting :7777 at the end of the domain.

A login window will appear. Enter your username (admin) and password and you should have successfully logged in.

Tuesday, February 7, 2012

Zend Framework & MVC Introduction

Zend Framework 

Zend Framework is an open source, object oriented web application framework for PHP 5. Zend Framework is often called a 'component library', because it has many loosely coupled components that you can use more or less independently. But Zend Framework also provides an advanced Model-View-Controller (MVC) implementation that can be used to establish a basic structure for your Zend Framework applications. A full list of Zend Framework components along with short descriptions may be found in the » components overview. This QuickStart will introduce you to some of Zend Framework's most commonly used components, including Zend_ControllerZend_Layout,Zend_ConfigZend_DbZend_Db_TableZend_Registry, along with a few view helpers.


So what exactly is this MVC pattern everyone keeps talking about, and why should you care? MVC is much more than just a three-letter acronym (TLA) that you can whip out anytime you want to sound smart; it has become something of a standard in the design of modern web applications. And for good reason. Most web application code falls under one of the following three categories: presentation, business logic, and data access. The MVC pattern models this separation of concerns well. The end result is that your presentation code can be consolidated in one part of your application with your business logic in another and your data access code in yet another. Many developers have found this well-defined separation indispensable for keeping their code organized, especially when more than one developer is working on the same application.
NoteMore InformationLet's break down the pattern and take a look at the individual pieces: 

  • Model - This is the part of your application that defines its basic functionality behind a set of abstractions. Data access routines and some business logic can be defined in the model.
  • View - Views define exactly what is presented to the user. Usually controllers pass data to each view to render in some format. Views will often collect data from the user, as well. This is where you're likely to find HTML markup in your MVC applications.
  • Controller - Controllers bind the whole pattern together. They manipulate models, decide which view to display based on the user's request and other factors, pass along the data that each view will need, or hand off control to another controller entirely. Most MVC experts recommend » keeping controllers as skinny as possible.
Of course there is » more to be said about this critical pattern, but this should give you enough background to understand the guestbook application we'll be building.

Resources.... http://framework.zend.com/manual/en/learning.quickstart.intro.html

Google Maps

Google Maps

Find local businesses, view maps and get driving directions in Google Maps.

It is really nice to work in Google map. It is very basic concept of what Google map is.
how to edit map, create map. let's check what I just mention http://maps.google.com/maps/ms?hl=en&ie=UTF8&oe=UTF8&msa=0&msid=218142667203742216287.0004a17c502c45a7f4aea

You can find my work done on google map

View Western International School in a larger map