Sophen Developer

Introduction to HeidiSQL 7.0.0.4053

noreply@blogger.com (Sophen Pho) — Tue, 14 Feb 2012 04:19:00 +0000

Some infos around HeidiSQLProject 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-developersusing the popular MySQL-Database. It allows you to manage and browse yourdatabases 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/Linuxalso works fine, apart from some minor graphical glitches, e.g. the transparentareas of all icons are displayed with black color. HeidiSQL does not run on Windows 95/98 or ME, as the Unicode extensions are notavailable on these systems.*** Command line switchesAlthough HeidiSQL is a pure GUI application, it can be automated for connectingand opening files via command line parameters. Parameter names are case sensitiveand 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 maymake 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, CreativeCommons 2.5), Jordan Russell (Inno Setup)1000 thanks to MySQL for great database softwareTo download file install: heidisql.googlecode.com/files/HeidiSQL_7.0_Setup.exeResource: file readme.txt content of heidisql

Introduction to iReport

noreply@blogger.com (Sophen Pho) — Fri, 10 Feb 2012 10:16:00 +0000

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.

Kloxo Installation Guide

noreply@blogger.com (Sophen Pho) — Thu, 09 Feb 2012 09:04:00 +0000

Kloxo Installation Guide

Prerequisites

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 initially¹:

Web Services	Function
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-ftpd	Pure-FTPd is a fast, production-quality, secure and standard-comformant FTP server especially designed for modern Linux and FreeBSD kernels.
awstats	Web Statistics

Mail Services	Function
qmail-toaster	qmail is a small, fast, secure replacement for the sendmail package, which is the program that actually receives, routes, and delivers electronic mail.
courier-imap-toaster	Courier-IMAP is an IMAP server for Maildir mailboxes.
vpopmail	vpopmail is a collection of programs and a library to automate the creation and maintence of virtual domain email for qmail installations.
Roundcube	Webmail (Ajax)
Horde	Webmail

DNS Services	Function
bind	BIND (Berkeley Internet Name Domain) is an implementation of the DNS (Domain Name System) protocols.
bind-chroot	Secures BIND server

Database Service	Function
mysql-server	MySQL is a multi-user, multi-threaded SQL database server.

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

Troubleshooting

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 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 (cache) or APF (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 (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

noreply@blogger.com (Sophen Pho) — Thu, 09 Feb 2012 09:01:00 +0000

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. http://192.168.0.1:7778 or https://192.168.0.1:7777 - 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 192.168.0.1 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.

Zend Framework & MVC Introduction

noreply@blogger.com (Sophen Pho) — Tue, 07 Feb 2012 10:25:00 +0000

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_Controller, Zend_Layout,Zend_Config, Zend_Db, Zend_Db_Table, Zend_Registry, along with a few view helpers.

Model-View-Controller ¶

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.

Note: More 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

noreply@blogger.com (Sophen Pho) — Tue, 07 Feb 2012 03:45:00 +0000

Google Maps

maps.google.com/

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

Countdown 2012

noreply@blogger.com (Sophen Pho) — Fri, 30 Dec 2011 01:12:00 +0000

By day to day, I count toward next and next. So what happen? Oh oh it is nearly New Year 2012 na. I have a plan to go .... I don't know yet. How about you? Do you have any plan to go on New Year? When Countdown who with you? lol..

I wish you happy and safe on countdown na.

How do I create a blog that Blogger will host for free?

noreply@blogger.com (Sophen Pho) — Thu, 08 Dec 2011 07:13:00 +0000

How do I create a blog that Blogger will host for free?

Before you can create a free blog on Blog*Spot, Blogger's hosting service, you need to have already created an account on blogger.com. Once you've logged into blogger.com, click the Create a Blog link above your list of blogs:
On Step 2, enter a Title and Address (URL). You'll also need to type in the verification word displayed on this page, to confirm that you are a real person and not a computer. When you're done, click continue:
On Step 3, you can choose a template for your blog; this is how it will appear when you publish it. Next, Blogger will create your new blog and reserve your spot on BlogSpot. As soon as you make your first post, your page will appear at the address you chose. You're all ready to blog!

Sophen Developer

Introduction to HeidiSQL 7.0.0.4053

Introduction to iReport

Kloxo Installation Guide

Kloxo Installation Guide

Packages installed initially1:

Introduction to Kloxo

Zend Framework & MVC Introduction

Zend Framework

Model-View-Controller ¶

Google Maps

Google Maps

Countdown 2012

How do I create a blog that Blogger will host for free?

How do I create a blog that Blogger will host for free?

Related Articles:

Packages installed initially¹: