MySQL date range, case study

Just stumble upon situation where I need to find out if specific date in a date range. I’ve try using lower than with greater than operator and use between in second attempt. Quick mysql shell mode Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\alam>cd c:\appserv\mysql\bin   C:\AppServ\mysql\bin>mysql -uroot -p Enter …

More

No ALTQ support in kernel

ftp# pfctl -d No ALTQ support in kernel ALTQ related functions disabled pf disabled ftp# pfctl -e -f /etc/pf.conf No ALTQ support in kernel ALTQ related functions disabled altq not defined on rl0 altq not defined on rl0 /etc/pf.conf:34: errors in queue definition pfctl: Syntax error in config file: pf rules not loaded what happen? …

More

Distro News 2008, January – Week 2 & 3

 Distronews for week 2 and 3, conutinously of previous post : 1. Frugalware linux,  Version 0.8.2 Pre 2     Download Iso : frugalware-0.8pre2-i686-dvd1.iso 2. Linux Ubuntu, Version 8.04 Alpha 3     Download Iso : hardy-desktop-i386.iso | kubuntu | edubuntu 3. Linux Parsix, version 1.0r0 Test 3     Download Iso : parsix_1.0r0-test-3-i386.iso 4. Mandriva Linux , …

More

101 CodeIgniter Resources

CodeIgniter already attract my attention since version 1.5, we even try to build application based on it. Beside its clear documentation, their user support awesome too. I’ll try to collect every resource that might useful to share with others who want to learn codeigniter. This post will be update regularly as soon as I get …

More

Distro News 2008, January – Week 1

Whats new in this week? My friend in Australia ask me that question, we known each other after long discuss around linux and unix world. His question refer to newest distro news, I refer him to distrowatch. I myself like distrowatch but as iso maintainer in our campus I prefer to make my own summary. …

More

Make lowercase followed by uppercase data

Question : I have table A with field id, name and address. The data in name field seem not consistent, big letter name sometime found in record. How to update that field with uppercase in name field. For example :                  id              name                                       address                  1               FreAKHolicz  wORker            the moon                  2              tHE atMOSFER bluEZ            …

More

how to do chmod in windows?

[phpbay]nintendo wii,2[/phpbay] How to do chmod 644 in windows? my friend ask me that question when he try to install oscommerce in his windows xp. hmmm….. IMHO, thereis no chmod in windows but they have ‘properties‘ to play with, for example : 1. Pick one file to experiment with.   2.  Right click on selected …

More

/dev/null: No such file or directory

Mayday….mayday, my /dev/null no longer exist help me….. mknod /dev/null c 2 2 chmod 666 /dev/null from man of mknod : c ->      Type of device.  If the device is a block type device such as a              tape or disk drive which needs both cooked and raw special files,              the type is b.  …

More

Trying freebsd-update for upgrade FreeBSD 7.0 Beta4 to FreeBSD 7.0-RC1

Trying to upgrade FreeBSD from 7.0 Beta4 to 7.0-RC1 monitor# uname -a FreeBSD monitor.alamster.net 7.0-BETA4 FreeBSD 7.0-BETA4 #0: Mon Dec 17 13:36:                                                                              40 UTC 2007     three@monitor.alamster.net:/usr/obj/usr/src/sys/GENERIC  i386 monitor# locate freebsd-update.conf /etc/freebsd-update.conf /usr/jail/etc/freebsd-update.conf /usr/jail/usr/share/examples/etc/freebsd-update.conf /usr/obj/usr/src/share/man/man5/freebsd-update.conf.5.gz /usr/share/examples/etc/freebsd-update.conf /usr/share/man/man5/freebsd-update.conf.5.gz /usr/src/etc/freebsd-update.conf /usr/src/share/man/man5/freebsd-update.conf.5 /usr/titan/ports/security/freebsd-update/files/Attic/freebsd-update.conf.5,v /usr/titan/src/etc/freebsd-update.conf,v /usr/titan/src/share/man/man5/freebsd-update.conf.5,v monitor# freebsd-update -f /etc/freebsd-update.conf -r 7.0RC1 upgrade Looking up update.FreeBSD.org mirrors… 1 mirrors found. …

More

FreeBSD 6.3 RC2 is out, happy new year

FreeBSD 6.3 RC2 is out, with two distinct version of FreeBSD 6 and 7 I try to maintain existing servers with this pattern : 1. Upgrade to minor for email server as we need stable operation 2. Upgrade backup server with FreeBSD 7 as we need to use their ZFS capability Your choice is vary …

More

FreeBSD 7.0 release candidate 1 available

From FreeBSD mailing list : FreeBSD 7.0 RC 1 available for download. Some information that might useful for upgrading : 1. Use source, just point cvsup to RELENG_7_0 2. Use freebsd-update utility with two options available :      1. Minor upgrade      2. Major upgrade Ready to grab FreeBSD 7.0 RC1, get now via : …

More

/usr/local/etc/rc.d in FreeBSD

How do I make mysql server start  in startup? How to make apache server start in startup? How to make ftp server start in startup? Simply, just installed via ports or package,  in FreeBSD there is relation between /etc/rc.conf and /usr/local/etc/rc.d/ for example : monitor# cat /etc/rc.conf usbd_enable="NO" sshd_enable="YES" apache_enable="YES" mysql_enable="YES" svscan_enable="YES" linux_enable="YES" radiusd_enable="YES" just …

More