Saturday, June 30, 2012

How to Install .deb File [iPhone/iPod/iPad Cydia Tutorial]


How to Install .deb File [iPhone/iPod/iPad Cydia Tutorial]
4 Methods to install a .deb file  into your iOS, choose the easier  for you! Applicable to:
  • iPhone (3G/3Gs/4/4s), iPod touch (3G/4G), iPad/iPad 2/iPad3
  • iOS 4.0+/ iOS 5.0 +

1st Method: Install with iOS Safari Browser + iFile

Requirements:  iPhone/iPod/iPad Safari Browser + iFile 
  1. Download .deb file with iPhone/iPod/iPad Safari browser
  2. Choose >> Open in “iFile”
  3. Once iFile opens >> Select  Installer
  4. Respring
  5. YOU ARE DONE

2nd Method: Install with SSH Client + iFile

Requirements: SSH Client (iFunbox for Windows/Cyberduck for MacOS) + iFile
  1. Download iFunbox >> (www.i-funbox.com) Windows , or Cyberduck for MacOS
  2. Download desired (.deb) file to your desktop
  3. Run iFunbox and connect your iOS (iPhone, iPod or iPad)
  4. iFunBox will show your device contents, Now navigate to any folder for example:  var/mobile/Documents
  5. Move (.deb) file from your desktop to var/mobile/Documents
  6. Run iFile from your iOS, and navigate to the same folder i.e. var/mobile/Documents
  7. Click on (.deb) file and select install
  8. YOU ARE DONE
TIP : I can not SSH into my iPhone/iPod/iPad!
  • I can not find var/root?
  • I can not SSH into my iPhone/iPad?
  • I have jailbroken device, my SSH client is discovering my iPhone/iPad as (JAILED)?
>> Install OpenSSH from Cydia, reboot, then try again.
>> If you still having problems>> Install afc2add from Cydia then reboot.

3rd Method: AutoInstallation Folder

Requirements: SSH Client (iFunbox for Windows/Cyberduck for MacOS)
  1. Download iFunbox >> (www.i-funbox.com) Windows , or Cyberduck for MacOS
  2. Download desired (.deb) file to your desktop
  3. Run iFunbox and connect your iOS (iPhone, iPod or iPad)
  4. iFunBox will show your device contents, Now navigate to var/root/Media/
  5. Create the folder Cydia/AutoInstall (if not already created)
  6. Move (.deb) file from your desktop to var/root/Media/Cydia/AutoInstall
  7. Reboot your iOS
  8. YOU ARE DONE

4th Method: Install with Mobile Terminal

Requirements: Mobile Terminal + OpenSSH
“Steps 2 and 3 are only if you have never installed a .deb file with this method”
  1. Download the .deb file you want (example : LockInfo)
  2. Start Cydia, go to “Search”, type “Mobile Terminal” and install it
  3. Repeat step 2 for “OpenSSH”
  4. Start “MobileTerminal”
  5. Type the following commands , then reboot:

Friday, June 15, 2012

SQL :: Standard Query Language :: Basic commands and Advances


Login & Change / Set password to MySQL :

$ mysql -h hostname -u username -p

$ mysql -u username -p

$ mysql -u username

$ mysqladmin -u root password
Set password for root

SQL : Standard Query Language :

:: Show / Delete / Create Databases ::

mysql> SHOW DATABASES;
show list database in mysql

mysql> DROP DATABASE database_name;
delete database in mysql

mysql> CREATE DATABASE database_name;
create new database


:: Cancel command typing ::

mysql> .....\c
cancel the command while type

:: Logout mysql ::

mysql> quit
to logout of mysql

:: Using Database & Create / Show / Delete Table ::

mysql> USE database_name;
choose database to use

mysql> CREATE TABLE table_name(
-> field_name1 field_type,
-> field_name2 field_type,
-> ........ );
Create a table with fields,
field_type : CHAR(N),VARCHAR(N),INT,DOUBLE,FLOAT,DATE....

mysql> SHOW TABLES;
To show all table in database you selected.

mysql> DROP TABLE table_name;
To delete table in database you selected.





:: Inserting Data to Table ::

mysql> INSERT INTO table_name SET
-> field_name1 = value1,
-> field_name2 = value2,
-> .....
-> ;
OR

mysql> INSERT INTO table_name
-> ( field_name1 , field_name2 , .... )
-> VALUES ( value1 , value2 , ....);

OR

mysql> INSERT INTO table_name VALUES
-> ( field_name1 = value1 ,
-> field_name2 = value2 ,
-> .....
-> );
Ex.
mysql> INSERT INTO person VALUES
-> ( birth = "1987-06-12" ,
-> name = "MR.KEOVESSNA" ,
-> sex = 'm',
-> id = 53160083 );

:: Viewing Stored Data ::

mysql> SELECT * FROM person;
show all fields' values in table person.

mysql> SELECT * FROM person WHERE name = "MR.KEOVESSNA";
show all field's value of table person which name = "MR.KEOVESSNA".

mysql> SELECT name FORM person WHERE sex = 'm';
show all name value of table person which sex = 'm'.

mysql> SELECT name,sex,birth FROM person;
show all name,sex,birth values of table person.

mysql> SELECT ID, LEFT(name,5) FROM person;
show id number and 5 characters from name field at from left of person.
Ex. name = "123456789" => LEFT(name,5) = "12345" .

mysql> SELECT COUNT(*) FORM person;
To count the number of result returned.

mysql> SELECT name FORM person WHERE name LIKE "%EO%";
Show name which are contented ..EO.. .

mysql> SELECT name FORM person WHERE sex = 'f' AND birth < "1980-1-1" ; Show name which are sex = 'f' and birth under year 1980. Logical operator : AND , OR Operator : = , < , > , <= , >= , !=

mysql> SELECT name FORM person WHERE
-> name IN (SELECT name FROM person WHERE sex = 'f')
-> AND name IN (SELECT name FROM person WHERE sex = 'm');
Find name from set of 2 sets who are sex = 'm' and 'f' to Intersection.
IN use to make as Set.



mysql> SELECT * FROM pet
> ORDER BY date;
To show all data in table pet by order by field date

:::: Cartesian Product :::

 
Ex. we have a table pet in manageries database.
if want to show the who fet both bird and dog

mysql> SELECT p1.owner FROM pet AS p1 , pet As p2
// pet AS p1 , pet AS p2 : p1 x p2 ( cartesian product which p1,p2 // from pet table ).













Wednesday, June 13, 2012

How to install MySQL server on Mac OSX 10.x or Lion with using terminal


:: How to download MySQL community server on Mac OSX 10.7 or Lion
:: How to install MySQL command in terminal on Mac OSX 10.7or Lion

1. MySQL Community Server
2. Then install the *.dmg file with two of *.pkg and one *.prefpanel
3. How to make your terminal work with mysql command :
     ::follow these instructions::

Bash will complain that it can’t find mysql. So we have to help it like so:

1. Create a file .bash_profile with your own editor with content below
* make sure you check that it has existed directory mysql in /usr/local/ ?
export PATH=$PATH:/usr/local/mysql/bin 
2. Save .bash_profile to /Users/%username% which %username% is your username directory
3. Restart the terminal the make a command :
source ~/.bash_profile

4. Checking your PATH by type :
$PATH

5. There will be showed look like this :
/usr/bin:/bin:/usr/sbin:/sbin:/usr/local/bin:/usr/X11/bin:/usr/local/mysql/bin

6. Now you should able to run mysql:
mysql -u -root 

*Note : which means you have no password for root.

mysqladmin -u root password



By Jack@COMPUTER-SCIENCE

Monday, June 11, 2012

How to burn Image Disk *.ios to Blank disk in Mac OX

Disc images are a fairly common packaging standard for large software programs. If you want to try out a new Linux distribution, for example, chances are you'll need to download a disc image in ISO format and burn it to a blank CD-ROM or DVD.

But ever since I began using Mac OS X, I've been perpetually confused about how to burn ISO images. I'm used to disc burning utilities that have an obvious, explicit command like "Burn ISO Image to CD." To make life even more confusing, OS X's Disk Utility does have a Burn command, but it becomes disabled when you click on the blank disc you'd like to use for the burn.

The problem here is that most Mac disc utilities, including the built-in Disk Utility, take a different approach when it comes to image burning. Instead of telling the program you want to burn an image, then choosing the file, you're supposed to do the reverse: You choose the file, then tell the program you want to burn it. So, to burn an ISO image to disc, here's what to do:
  1. Insert a blank disc.
  2. Start Disk Utility.
  3. From the File menu, choose Open Disk Image and select the ISO to be burned.
  4. In the list of volumes, you will now see an item representing the ISO file. Select it.
  5. Click the Burn button and follow the instructions.
That's it! Sure, it may seem simple enough, but when you've been using Linux and Windows utilities for years, these steps can be a little perplexing and hard to remember.