Criar pen USB bootable linux em Macosx

Depois de ter a imagem da distro de Linux que pretendemos (no meu caso, Ubuntu), abrimos um terminal e navegamos até ao directório onde está a imagem.

jimmy@machine:~$ cd Downloads/

Executamos agora o comando que converte a imagem de iso para img:

jimmy@machine:~/Downloads$ hdiutil convert -format UDRW -o ubuntu-12.04.3-desktop-i386.img ubuntu-12.04.3-desktop-i386.iso
Reading Master Boot Record (MBR : 0)…
Reading Ubuntu 12.04.3 LTS i386 (Apple_ISO : 1)…
Reading (Windows_NTFS_Hidden : 2)…
................................................................................................................................................................................................................
Elapsed Time: 21.860s
Speed: 32.3Mbytes/sec
Savings: 0.0%
created: /Users/jimmy/Downloads/ubuntu-12.04.3-desktop-i386.img.dmg

Por omissão, o macosx cria as imagens com .dmg no final, para resolver o problema basta trocar o nome do ficheiro.

jimmy@machine:~/Downloads$ mv ubuntu-12.04.3-desktop-i386.img.dmg ubuntu-12.04.3-desktop-i386.img

Inserimos a drive USB e executamos o seguinte comando para saber onde está a nossa pen, neste caso em (/dev/disk1)

jimmy@machine:~/Downloads$ diskutil list
/dev/disk0
#: TYPE NAME SIZE IDENTIFIER
0: GUID_partition_scheme *320.1 GB disk0
1: EFI 209.7 MB disk0s1
2: Apple_HFS brain 319.7 GB disk0s2
/dev/disk1
#: TYPE NAME SIZE IDENTIFIER
0: FDisk_partition_scheme *8.0 GB disk1
1: DOS_FAT_32 8.0 GB disk1s1

ATENÇÃO: memorize o numero da drive USB, neste caso é 1 (/dev/disk1)

"Desmontamos" a pen com o comando seguinte:

jimmy@machine:~/Downloads$ diskutil unmountDisk /dev/disk1
Unmount of all volumes on disk1 was successful

E corremos o comando que irá preparar a pen com o SO, troque o 1 (/dev/rdisk1) pelo número identificado no passo anterior:

jimmy@machine:~/Downloads$ dd if=ubuntu-12.04.3-desktop-i386.img of=/dev/rdisk1 bs=1m
707+0 records in
707+0 records out
741343232 bytes transferred in 77.944528 secs (9511165 bytes/sec)

Download Symfony 1.4

$ svn co http://svn.symfony-project.com/tags/RELEASE_1_4_20 .

PHP5 Unable to load dynamic library

Problema

PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/mysqli.so' - /usr/lib/php5/20090626/mysqli.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/mysql.so' - /usr/lib/php5/20090626/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/apc.so' - /usr/lib/php5/20090626/apc.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/curl.so' - /usr/lib/php5/20090626/curl.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/gd.so' - /usr/lib/php5/20090626/gd.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/intl.so' - /usr/lib/php5/20090626/intl.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/mysql.so' - /usr/lib/php5/20090626/mysql.so: cannot open shared object file: No such file or directory in Unknown on line 0
PHP Warning: PHP Startup: Unable to load dynamic library '/usr/lib/php5/20090626/mysqli.so' - /usr/lib/php5/20090626/mysqli.so: cannot open shared object file: No such file or directory in Unknown on line 0

Solução:

sudo apt-get install php5-mcrypt
sudo apt-get install php5-mysql
sudo apt-get install php5-intl
sudo apt-get install php5-curl
sudo apt-get install php5-gd
sudo apt-get install php-apc

Alterar monitor principal no ubuntu

Para alterar o monitor principal do Ubuntu, Mint, etc... (O monitor com a barra)

#!/bin/bash
# Author: Andrew Martin
# Credit: http://ubuntuforums.org/showthread.php?t=1309247
echo "Enter the primary display from the following:" # prompt for the display
xrandr --prop | grep "[^dis]connected" | cut --delimiter=" " -f1 # query connected monitors

read choice # read the users's choice of monitor

xrandr --output $choice --primary

mysql user and database

Moved to a more complete version here


Criar a base de dados:

mysql> CREATE database my_db;

Criar um utilizador mysql:

mysql> CREATE USER 'my_user'@'localhost' IDENTIFIED BY 'my_pass';

Verificar as permissões do utilizador:

mysql> SELECT * FROM mysql.user WHERE User = 'my_user'\G

Verificar os GRANTS de um utilizador:

mysql> SHOW GRANTS FOR my_user;

Sometimes we all need it

Drop Foereign Key Error 1025

Apagar uma Foreign Key nem sempre é simples, seguem os passos para contornar o erro 1025 do mysql:

mysql> SHOW CREATE TABLE user_preference;
+---------------------------------------------------------------------------------------------------------+
|CREATE TABLE `user_preference` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`field` varchar(255) DEFAULT NULL,
`user_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `user_preference_user_id_idx` (`user_id`)
CONSTRAINT `user_preference_user_id` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 |
+---------------------------------------------------------------------------------------------------------+

mysql> ALTER TABLE user_preference DROP FOREIGN KEY user_preference_user_id;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings: 0

mysql> ALTER TABLE user_preference DROP user_id;
Query OK, 0 rows affected (0.14 sec)
Records: 0 Duplicates: 0 Warnings: 0