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

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

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

Dynagen – interim 0.11.0 build for win xp and linux

From Dynagen website, a few enhancement in Dynagen in progress as a result of merge the confDynagen codebase into Dynagen like : dynamic reconfiguration Pemu server support (aka PIX emulation) with a lot of major improvement and bugs handling. To play with this version, you can download here. Pavel.Skovajsa also write some tutorials : pemututorial, …

More

NetBSD 4.0 released, grab it while its Hot

Form NetBSD mailinglist : The  NetBSD  Project  is  pleased  to announce that release 4.0 of the    NetBSD  operating  system  is now available. NetBSD is a free, secure,    and  highly  portable Unix-like Open Source operating system available    for  many  platforms, from 64-bit Opteron machines and desktop systems    to  handheld  and  embedded  devices.  …

More

Build email server Tutorials, choose one for You

Every linux distro, unix system or windows server came with smtp system. But it’s not enough for small home office requirement that need to provide mailbox for their employee.   Another solution is signup for web hosting that include mail management such cpanel, whm etc. If this solution wont fit too, maybe dedicated email server …

More