Installing your favorite mysql version in FreeBSD

Ports offer more flexibility than package in general but when dealing with size I prefer using package 🙂

My common question when see this on freebsd ports page :

to get mysql support on php, I must install mysql-client-5.0.41 thats means I must install mysql5 server too if I decide to install mysql in my server, I prefer to install mysql4. Is it possible?

I’m luckly, freebsd ports offer flexible options, simple trick to use mysql 4.0.27 with php4 is installing mysql4 server first.

after installing mysql server version 4 then php4-mysql will use mysql4-client automatically.

with this option some options for favorit mysql version available, depend on you.

-bash-2.05b$ cd /usr/ports/databases/
-bash-2.05b$ ls | grep mysql

Continue reading

DNS service, freedom to manage your server

A lot of scenario in my mind with "free" things around domain, hosting and email which is DNS.

There is many provider offer DNS management for free like :

these provider offer dns management that you can use for  :

  1. Hosting your blog for free at awardspace, pointing your email at google apps plus other facility in google like gtalk etc.
  2. Hosting your blog in your own server, pointing your email at google apps
  3. Hosting your own email with free hosting from awardspace or other free hosting

Off course first scenario is the best, only need domain to start

Wait, if you wanna free domain then you can check out this thread :

"Win a year’s worth of hosting at BloggingTips.com"

Make sure to prepare yourself to win by reading this article :

 

in Blog | 158 Words

Some mysql sql basic command I must remember

I use phpmyadmin in daily environment, do I still know  sql command?

My sql file too large, it’s hard to import using phpmyadmin, please help me

Some question around mysql from my student, my false make them spoil using phpmyadmin all day long 🙂

Here’s my answers :

1. Command to create database

create database databasename

2. Delete database

drop database databasename

3. Import database

mysql -uusername -ppassword databasename < databasename.sql

4. Export database

mysqldump -uusername -ppassword databasename > databasename.sql

5. Pick database and choose one to manage

use databasename

6. List all table in database

show tables

 Illustration in mysql command line :

Continue reading

php 5.2.3 ports

New release php5.2.3 make me curious to test upgrade from php4.4.7 to php5.2.3

kongja# cd /usr/ports/lang/php5

 

kongja# ee Makefile

 

PORTNAME=       php5
PORTVERSION=    5.2.3
PORTREVISION?=  0
CATEGORIES?=    lang devel www

 

kongja# make fetch

=> php-5.2.3.tar.bz2 is not in /data3/ports/lang/php5/distinfo.
=> Either /data3/ports/lang/php5/distinfo is out of date, or
=> php-5.2.3.tar.bz2 is spelled incorrectly.
*** Error code 1

kongja# ee distinfo

MD5 (php-5.2.2.tar.bz2) = d084337867d70b50a10322577be0e44e
SHA256 (php-5.2.2.tar.bz2) = cd69e73c46e1d171ac0cf27b7ee492c3bf8f6b45a763a77fd0cb79d5afa9f407
SIZE (php-5.2.2.tar.bz2) = 7310926
MD5 (suhosin-patch-5.2.2-0.9.6.2.patch.gz) = 081fe08d584820a6ece1fe2e8629711f
SHA256 (suhosin-patch-5.2.2-0.9.6.2.patch.gz) = 932d8155028686b96d3ebf89215dab7cd9353ac72f9ea82c252d0999fb4bd864
SIZE (suhosin-patch-5.2.2-0.9.6.2.patch.gz) = 22850
MD5 (php-5.2.2-mail-header.patch) = 6b2562b5230b1f85a2ccb292e124a91a
SHA256 (php-5.2.2-mail-header.patch) = 5394732be1953c7eedc2de9529d10971d85959af6352c8a67b4561124ddc8df5
SIZE (php-5.2.2-mail-header.patch) = 3420

                                        Options for php5 5.2.3                       
                            │ ┌────────────────────────────────────────────────────────────────┐ │
                            │ │  [X] CLI        Build CLI version                              │ │
                            │ │  [ ] CGI        Build CGI version                              │ │
                            │ │  [X] APACHE     Build Apache module                            │ │
                            │ │  [ ] DEBUG      Enable debug                                   │ │
                            │ │  [X] SUHOSIN    Enable Suhosin protection system               │ │
                            │ │  [ ] MULTIBYTE  Enable zend multibyte support                  │ │
                            │ │  [ ] IPV6       Enable ipv6 support                            │ │
                            │ │  [ ] MAILHEAD   Enable mail header patch                       │ │
                            │ │  [ ] REDIRECT   Enable force-cgi-redirect support (CGI only)   │ │
                            │ │  [ ] DISCARD    Enable discard-path support (CGI only)         │ │
                            │ │  [ ] FASTCGI    Enable fastcgi support (CGI only)              │ │
                            │ │  [ ] PATHINFO   Enable path-info-check support (CGI only)      │ │
                            │ │                                                                │ │
                            │ │                                                                │ │
                            │ │                                                                │ │
                            ├─└────────────────────────────────────────────────────────────────┘─┤
                                                    [  OK  ]       Cancel

===>  php5-5.2.3 : Your apache does not support DSO modules.
*** Error code 1

Stop in /data3/ports/lang/php5.
*** Error code 1

Stop in /data3/ports/lang/php5.

hehehehe, I should wait for official ports 😉

in Unix | 1,346 Words

FreeBSD new logo on T-shirts

Just try to spread the word 🙂

FreeBSD mall put new t-shirts, see below example t-shirts + FreeBSD new logo that pick from their place

I love that design with silk screen

Wanna yours?, then go visit FreeBSD mall

p.s : get the full news from  Florent  Thoumie blog

in Unix | 50 Words