takizo, not takezo

Quick installation of MySQL Database on FreeBSD Server. Make sure you are on the latest FreeBSD Port Tree with portsnap, refer to keeping update ports. If you want to browse through what version of MySQL is available in FreeBSD;

shell> cd /usr/ports
shell> make search name=mysql | less
shell> Port:   mysql-server-5.1.34
Path:   /usr/ports/databases/mysql51-server
Info:   Multithreaded SQL database (server)
Maint:  ale@FreeBSD.org
B-deps: gettext-0.17_1 gmake-3.81_3 libiconv-1.11_1 libtool-1.5.26 mysql-client-5.1.34
R-deps: mysql-client-5.1.34
WWW:    http://www.mysql.com/

Port:   mysql-client-6.0.10
Path:   /usr/ports/databases/mysql60-client
Info:   Multithreaded SQL database (client)
Maint:  ale@FreeBSD.org
B-deps: gettext-0.17_1 gmake-3.81_3 libiconv-1.11_1 libtool-1.5.26
R-deps:
WWW:    http://www.mysql.com/

Port:   mysql-scripts-6.0.10
Path:   /usr/ports/databases/mysql60-scripts
Info:   Multithreaded SQL database (scripts)
Maint:  ale@FreeBSD.org
B-deps: gettext-0.17_1 gmake-3.81_3 libiconv-1.11_1 libtool-1.5.26 mysql-client-6.0.10 perl-5.8.9_2
R-deps: mysql-client-6.0.10 p5-DBD-mysql60-4.010 p5-DBI-1.60.7 p5-Storable-2.18 perl-5.8.9_2
WWW:    http://www.mysql.com/

Port:   mysql-server-6.0.10
Path:   /usr/ports/databases/mysql60-server
Info:   Multithreaded SQL database (server)
Maint:  ale@FreeBSD.org
B-deps: gettext-0.17_1 gmake-3.81_3 libiconv-1.11_1 libtool-1.5.26 mysql-client-6.0.10
R-deps: mysql-client-6.0.10
WWW:    http://www.mysql.com/

Read the rest of this entry »

Do you have IPV6 network ready in your office? Lets configure IPV6 on your machine running on either Windows/Mac. We have IPV6 network running on our office network, running dual stack with IPV4, not running fully on IPV6 DNS at the moment. But will try it out and share soon.

How to Configure IPV6 on Windowx XP

Turn on your command prompt, try this command ipv6, you should see the command replies;

C:\Documents and Settings\takizo>ipv6
usage: ipv6 [-p] [-v] if [ifindex]
       ipv6 [-p] ifcr v6v4 v4src v4dst [nd] [pmld]
       ipv6 [-p] ifcr 6over4 v4src
       ipv6 [-p] ifc ifindex [forwards] [-forwards] [advertises] [-advertises] [
mtu #bytes] [site site-identifier] [preference P]
       ipv6 rlu ifindex v4dst
       ipv6 [-p] ifd ifindex
       ipv6 [-p] adu ifindex/address [life validlifetime[/preflifetime]] [anycas
t] [unicast]
       ipv6 nc [ifindex [address]]
       ipv6 ncf [ifindex [address]]
       ipv6 rc [ifindex address]
       ipv6 rcf [ifindex [address]]
       ipv6 bc
       ipv6 [-p] [-v] rt
       ipv6 [-p] rtu prefix ifindex[/address] [life valid[/pref]] [preference P]
 [publish] [age] [spl SitePrefixLength]
       ipv6 spt
       ipv6 spu prefix ifindex [life L]
       ipv6 [-p] gp
       ipv6 [-p] gpu [parameter value] ... (try -?)
       ipv6 renew [ifindex]
       ipv6 [-p] ppt
       ipv6 [-p] ppu prefix precedence P srclabel SL [dstlabel DL]
       ipv6 [-p] ppd prefix
       ipv6 [-p] reset
       ipv6 install
       ipv6 uninstall
Some subcommands require local Administrator privileges.

To configure IPV6, you need the command ipv6 if; Read the rest of this entry »

When doing Symfony development, I usually build the database schema manually through phpPgAdmin or writing my own schema file. I like propel-generate-crud in symfony, which can generate the admin form on the fly.

Previously I was having problem with PostgreSQL Database’s sequence id. When I did propel-build-model, the seq_id from Postgresql database is not sync with the model been built by symfony. To solve that, I did manual change on PostgreSQL by renaming the tablename_id_seq to tablename_seq. After I have did some testing, found a way to solve the sequence id problem.

Read the rest of this entry »

umask? What?

What is umask command use for in linux/unix system?

umask is uses to set the default file or directory permission when a user create a new file or directory. By default, when a user created new file/directory, Read the rest of this entry »

There are few shell scripts I need to run when I log on to my server. One of my favorite is to use screen to launch the scripts when I log on to the server or using screen to access multiple screen. screenrc file does help me on this, I can build my own screenrc file and update screenrc file whenever I have new script or command wanted to run when I log on to the server. Here is how I configure your personal screenrc file. Read the rest of this entry »