Learning On Demand Learning anything from anywhere

Archive for the ‘Work’ Category

Learn MS Access 2003

04.29.2011 · Posted in Step By Step, Work

A client want me to convert their application that use MS Access 2003 to web based application using php and mysql. I agree to do so and this post is just for myself future reference when I have to deal with other MS Access 2003 application. Open MS Access 2003 in design mode double click ...

How to update / renew Zimbra License

10.10.2010 · Posted in Linux, Step By Step, Work

Your Zimbra Network License expired 24 days ago Yes, that message show up when I log in to one of my client and they ask me to renew the license. Well, the process itself isn’t difficult as what you need to extend zimbra license just ask sales at zimbra.com. they will email license key and ...

Change php.ini for adjust max upload file size

06.30.2010 · Posted in Linux, Work

File too large That simple message when marketing team want to upload new support ticket that include attachment with size 4 MB. Yes, that my mistake for not adjust default max upload file size. The solution is simple : Edit php.ini file I use ubuntu and because I more familiar with freebsd I use phpinfo() ...

Install pureftp with unixauthentification on ubuntu

06.28.2010 · Posted in Work

I used to use winscp to upload file to vps server. It’s easy and I just need to keep dedicated user. Due to request for ftp support I decide to install ftp server called pure-ftp on ubuntu jaunty. Install pure-ftp # apt-get install pure-ftpd Reading package lists… Done Building dependency tree Reading state information… Done ...

freebsd unzip ports

06.17.2010 · Posted in Work

I just use gunzip as tool for unzip an .zip file at ubuntu 10.04 when I try same utility at freebsd. Now I want to try something new with utility called unzip. Try to call it ( it might be installed) # unzip unzip: Command not found. Not found, try to find installation file. # ...

Warning: No configuration file found!

06.15.2010 · Posted in Work

Try to install gammu with newest ubuntu version (lucid). smsdrc edited and lauch gammu–identify # gammu –identify Warning: No configuration file found! Warning: No configuration read, using builtin defaults! No response in specified timeout. Probably phone not connected. I check the cable and it looks fine. Check configuration file and yes, still at /etc/gammu-smsdrc Retry ...

Setting PATH for MYSQL bin

01.28.2010 · Posted in Work

MYSQL PATH! Yes, that thing come to my mind when I playing around with MYSQL. Before setting PATH : Microsoft Windows XP [Version 5.1.2600] (C) Copyright 1985-2001 Microsoft Corp. C:\Documents and Settings\Administrator>cd c:\wamp\bin\mysql\mysql5.1.36\bin C:\wamp\bin\mysql\mysql5.1.36\bin>mysql -uroot -p Enter password: Welcome to the MySQL monitor.  Commands end with ; or \g. Your MySQL connection id is 1 ...

Preparing ubuntu usb install for nettop installation

12.24.2009 · Posted in Work

Due to budget limitation and energy saving campaign in my office we try to explore more machine for our sms gateway. The criteria for this low traffic machine is clear : Lowest energy with high storage facility and price within the range $100 – $250 Hardware Search in the net give me a few result ...

Step by step Install Pure-FTP inside pfSense

12.15.2009 · Posted in Unix, Work

pfSense is great stuff when you’re looking for Firewall but I need more Case : A user want to store his file in the form of FTP but pfSense is the only server that available in the office. New HDD ready to support this method. Solution : Add new HDD and install FTP server inside ...

Howto reset mysql password on ubuntu server 9.10

11.25.2009 · Posted in Work

New IBM server has arrived, its IBM X3100-42X. Standard install required; DNS, LAMP and OpenSSH server on  Ubuntu Server 9.10. Problem came when I forgot password for MySQL. I think the solution isn’t far from what I done in FreeBSD. First attempt login to MySQL server : # mysql -uroot -p Enter password: ERROR 1045 ...

Download FreeBSD 8 RC3 iso file

11.16.2009 · Posted in Unix, Work

FreeBSD 8 RC3 already out, ready to test for all your machine. Choose your favourite forms : BootOnly CD (disc 1) DVD LifeFS MemStick Upgrade method : cvsup, use  “RELENG_8_0″ freebsd-update ( freebsd-update upgrade -r 8.0-RC3 ) More information for freebsd-update available here. More information about this RC please read release announcement. freenas 8 downloaddownload ...