Thursday, May 26, 2011

Mysql Workbench Setup (Fedora 64 bit)


MySQL Workbench is a GUI database design tool that integrates SQL development, administration, database design, creation and maintenance into a single development environment for the database system of MySQL.It is a C/C++ program ,running in a multi-platform OS . The Software is now currently owned by Oracle yet most of its bundles are still available freely in the Open-source community.For further references please go to this wiki:

Hey, I guess am seriously focusing myself into an information system of business data processing.Just recently when I got involved on using SQL and the combined front end software(PHP,PERL,Python,Gambas and etc.).But for now, this workbench is for sure a great help to simplify databasing scheme.

Anyway, sooner or later l'll stick to some of my own coding applications from basic ,average and might as well into wizardness-huh?

Then let's go coding...

Here are some important packages:
python-paramiko.noarch 0:1.7.6-2.fc14

For complete requirements(cut and paste then try it with "yum"):
mysql++-devel.x86_64 0:3.1.0-2.fc14
mysql-bench.x86_64 0:5.1.51-2.fc14
mysql-connector-c++-devel.x86_64 0:1.1.0-0.2.bzr888.fc14
mysql-devel.x86_64 0:5.1.51-2.fc14
mysql-embedded-devel.x86_64 0:5.1.51-2.fc14
mysql-server.x86_64 0:5.1.51-2.fc14
mysql-test.x86_64 0:5.1.51-2.fc14
mysql-workbench-gpl.x86_64 0:5.2.34-1fc14
mysqltuner.noarch 0:1.1.1-1.fc13
mysqludf_xql.x86_64 0:1.0.0-1.fc13


1*)Our objective is to simplify Mysql Database application with the aid of its bundled tools-Mysql Workbench


root@localhost# yum install libzip

root@localhost# yum install perpect

root@localhost# yum install python-paramiko

root@localhost# yum install mysql mysql-server

Install MySql source code
root@localhost# groupadd mysql
root@localhost# useradd -r -g mysql mysql
root@localhost# cd /usr/local
root@localhost# tar zxvf /path/to/mysql-VERSION-OS.tar.gz
root@localhost# ln -s full-path-to-mysql-VERSION-OS mysql
root@localhost# cd mysql
root@localhost# chown -R mysql .
root@localhost# chgrp -R mysql .
root@localhost# scripts/mysql_install_db --user=mysql
root@localhost# chown -R root .
root@localhost# chown -R mysql data

You can have the Mysql configuration optional
root@localhost# cp support-files/my-medium.cnf /etc/my.cnf
root@localhost# bin/mysqld_safe --user=mysql &
root@localhots# cp support-files/mysql.server /etc/init.d/mysql.server

Then check if MyQL is installed:
Note: What we're talking here is a default username and password just to check
mysql is running.You should see where MySql is,and start running its daemon, so here is how to do it..

root@localhost# whereis mysql
root@localhost# cd /usr/local/mysql
root@localhost# ./bin/mysqld_safe &

Open another tab and then go to the same path "/usr/local/mysql/" take note "./bin/mysql" (the dot for mysql/bin).Or to have a soft link to the executable path "/usr/bin/mysql)-that could be a better idea know bro.
root@localhost# ./mysql
root@localhost# ln -s /usr/local/bin/mysql /usr/bin/mysql
root@localhots# mysql

Then proceed to Mysql Workbench
root@localhost# rpm -ivh mysql-workbench-gpl-5.2.34-1fc14.x86_64.rpm

Then goto File->Programming -> Mysql Workbench

Detail(1) Go to the Mysql Download Area

Detail(2) Choose mirror site for download

Detail(3) Downloaded myql work bench

Detail(4) CLI: rpm -ivh mysql-workbench

Detail(5) Run your first installed Mysql-Work bench

Detail (6) Open Mysql work bench connection

Detail(7) A new connection is established

Detail(8) Open Query

Detail(9) Add new table


For some troubles that might occur

1) Permission Denied
Trouble: chown: cannot access `./.gvfs': Permission denied
Solution: chown -R $USERNAME:$USERNAME $HOME

My SQL saga is just beginning..

Simply Mysql tools

Wednesday, May 4, 2011

RoBook Scanner Software (Beta Release)

The initial effort to informally published a RoBook Scanner software engineering program will just tackle minimal infos.The purpose of this techno blog is a sort of an article for a reader to gain an idea.Idea that really means "pinoy can do it" ,due to some confidentiality of the project ,it is less expected to pull out the whole detail ; yet its explanations therein would be sufficient enough to deal what RoBook Scanner is all about.

The Author is hoping that in a given time 'if given an authority for publishing such systematic idea without hesitant it will be blogged with full detail -clearly and free to the public.But this time as the date of writings just simple documentation is sufficient to depict the contents of this article.

In some ways, this could be another fruitful sharing of thoughts for all of us-I wish that.

Hmmmn, anyway, the software now has done almost its features and the test is how can it be ported to different Linux flavour.So here is what I did for the software package installer .

Need to assure these are available or installed in your OS
deb helper

Compile a package installer
1) In Fedora
2) In CentOS
3) In debian/Ubunto


Detail(0) At last..RoBook Scanner Software (Beta )

Detail(1)Package information


Detail(3)Target distributions

Detail(4)Package group

Detail(5)Destination directory

Detail(6)Creating the package

Detail(7)A bundle of installer ready for deployment