How to get it done

Being trying out some seo stuff, well, have yet to optimise this site, but was workin on a wordpress site for a client, many interesting reads. one pretty good one will be this:
WordPress SEO by Joost de Valk
well if u googled, he will probably be among the top few in the PR for that search term.

Being using Lynx through SSH on my unix server, so now that i got a mac, Lynx on mac!
a very easy install

may want to check out this cool page SEO Browser
what i find so interesting is that it show you how your site is redirected like those permanently moved 301 and stuff. very good, in fact, i am trying to do something like this now. but more for searching for orphans links, missing images etc.

This is for ppl who are mac lover and mysql lover but due to work requirement have to conenct to mssql server on their mac.

if you had installed PHP Apache Module from Entropy.ch the following instruction is for you, else, you may try my earlier post on installing msSQL extension for php in *nix/Centos Server, largely used by WHM/cPanel.

entropy’s php for the version i install for mac is still in beta. but it comes with freeTDS installed, i am not too sure about the earlier versions. so to conenct to mssql server you jus have to configure your freetds.conf file which should be located in, the path,

you may had name “php5″ with something else instead.

vi this file or open with a text editor and insert the following line at the end.

note that MSHOSTNAME for both case mus be the same, and is something like 192.168.0.100 or mssql.somehost.com etc. it should be the hostname you are connecting to probably in your php script.

tds version depends on the mssql server version you are connecting to, gennerally 8.0, and port is standard 1433 unless your remote mssql server connects on weird port number.

save, and you are done!

so you jus brought an apple remote and you want to pair it with your macbook, macbook pro etc, what do you do?

from Apple, it says:
1. Log in as an Admin user.
2. Get extra close to your Mac (about 3 or 4 inches away).
3. Point the remote at the Apple logo on the front of your Mac.
4. Press and hold the Menu and Next/Fast-forward buttons simultaneously on the remote for 5 seconds.

well, it got me trying for hours and still nothing works, until i found this webpage!

So, if the above 4 steps dun work for you,
replace step 4 with:
Press and hold the Menu and Play buttons simultaneously on the remote for 5 seconds.

simple! it is time apple update their support articles!

phew! mySQL is finally working on my Mac OS X 10.5

Leopard comes with Apache and PHP installed but you will need to start Apache
by opening terminal and run:
apachectl -k start

to enable php
refer to Foundation PHP

to auto start apache, go to “System Preference” and under “Sharing”, check on “Web Sharing” this will auto start Apache on bootup

to install mySQL, the pretty challenging part here.
if not done correctly, u probably will get permission error on data, failure to start automatically etc.
jus follow the instruction here:
Installing MySQL on Leopard – Red91.com
will archieve the tutorial here when i can find more time.

a mac addict already, i should be having writing quite a lot of post on mac related stuff.

you generally wun need to see the hidden files in mac except prolly if you are using subversion, cos i was attempting to delete the .svn folder. which is by default and definitely hidden.

to show hidden files, open Terminal, and type the following:

1. defaults write com.apple.finder AppleShowAllFiles TRUE
2. killall Finder

omit “1.” or “2.”
statement 1. will state show hidden to TRUE, so to hide hidden files, jus do the same 2 line with FALSE.
statment 2. kill all “Finder” forcing a restart, warning! dun killall Finder if you are moving files or copying, etc.

Source: Slash Dot Dash

so like i said in the previous post, i m migrating to mac, and having email being a important communication with my clients, i desperately need to export my mail over to mac and start getting things gng here.

so being desperately googling around for a tool which can convert outlook pst to something mac mail or ms entourage can read.. seriously they should allow direct import from pst.. well.. sadly, i cannot find any free tool, but then found this O2M by littlemachines.com

LittleMachines.com

it cost US$10, which i can consider is pretty cheap considering it let u test to make sure your outlook works well with the program and create sample mbox file for u to test importing into mac mail. if you are looking for something to convert from outlook to mac mail, i can say, look no further, jus pay that 10 bucks and get it done, i spent the whole nite and this is really the best solution already. work very smoothly for me.

the only thing that can be improved is if it can directly create sub folders for entourage, not too sure mac mail have sub folders, haven really try it out, but yes, if the folder structure can be retained that will be the best.

i recently jus migrate over to mac. apple is more healthy than anything else.

but then there is this thing tat is very irritating, the loud startup sound. that u cannot really switch off, it still jus blast away even when you earpiece is plugged in, so did a goggle search and found this cool website which have a plug-in to system preference which will do just the job!

http://www5e.biglobe.ne.jp/~arcana/index.en.html

check them out.
you can switch off the startup sound, or adjust the volume to way max of too soft. or u can even mute it, which is very much the same as disabling the startup sound.

Had being having this weird issue of connection tray not responding on shutdown and prior to this usually come with lose of internet connection. where the network adapter seems to have weird issues, is like the interface software hanged.

did some googling and found this.. changed the stuff but ain’t sure if this will works. will update.

Go to Start -> Run -> type in “msconfig”
The “System Configuration Utility” window will pop up.
Go to the “Services” tab then scroll down looking for “Telephony” which is very much useless! just uncheck it, click “OK” then you should be good to go!

microsoft is really crap 100% of the time.

update: the method didn’t really help, as i later realise “Telephony” is needed for modem connection, i am using Vodafone GSM Modem. argh. so this don’t solve the problem at all. and i still cannot find the irritating problem.

woh! okie.. this installation is gng to be long a tough.. took me a few days of google crawling and testing before i finally get it to work.

okie, why will u need to install mssql extension on php? possibly becos u need to connect to a ms sql server of ur vendor or something like that. for integration i hope. cos unix works best w php and mysql, ie, installation, it is almost already thr. correct me if i m wrong.

so wad you need?
if your server is jus fresh out of the box or say u had installed whm/cpanel there will be quite a far bit of stuff u will need.

1. Txt2man
2. unixODBC
3. freeTDS
4. PHP mssql.so

if this point if you are wondering if i m using any rpm for installation?
sorry,i m not, cos my server centos installed w whm/cpanel seems to be poorly equipped or configured for rpm installation, too many dependencies required. so jus download all the binary and upload them onto ur server.

Setup 1: Install unixODBC package

Install unixODBC first. Download the software in your home directory or anywhere you like and uncompress and untar the software.

You can do this by using following command

Once it is done, go to the unixODBCxxxx dir and run the configure command.

Note: If you dont use enable-gui option and dont have Qt package, you will get the error. So make sure you use it if no Qt is installed.

After configure is successfully completed, run the make and then make install commands.

Install it

Step 1.1: Installing Txt2man
this step is optional if your server already have txt2man installed.
txt2man is required by freeTDS to man it documentation, i do find this portion pretty useless though.
else jus download the package, and run the make

Install it

Step 2: Install freeTDS package

Download the freeTDS package and untar and uncompress it.

Run the configure.

Run the make

Install it

Step 3: Configuration freeTDS
Start configuration with freeTDS. Look for the freetds.conf file and add the entry for the MS SQL server.

Sql server standard port is the 1433. The tds version for MS SQL server 2000 is 8. You can try 8.0 with new version as well.
Important: the host need to be the same as the declaration. ie
if you have [mssql.hostname.com], ur host will be = mssql.hostname.com

Step 4: Configuration – unixODBC

The unixODBC need two main configuration files called odbcinst.ini and odbc.ini. These files should be in the /etc/ dir.

I. The first file odbcinst.ini contain the definition of ODBC driver.

Note: Before making above entries, make sure libtdsodbc.so exists in the /usr/local/lib dir.
In the above configuration, we have define TDS as driver.

II. The second file is odbc.ini. This file has information about your MS SQL database.

You can notice above that the freeTDS driver is the name defined in odbcinst.ini while servername is the one defined in freetds.conf.

Step 5: Test MS SQL connectivity from Linux box
Check if you can connect to MS SQL database using unixODBC tool called isql.

If you see the results, you are connected.

Step 6: Getting your mssql.so file
Update: I came back to follow this to create an .so file and realise, mmm, this instruction wasn’t too clear. So here it goes. From PHP.net Download page, download the source code, then if you unzip, you will find a folder “ext” and “mssql” in the “ext” folder. tat’s the folder i m referring to, ‘cd’ to this folder and then run phpize as below mentioned.

Add: for the benefits of those who just need the .so file, you can download the mssql.so from here. however, i don’t assure, compatibility with you php version. is built with php 5.2.10 binaries.

php.net is not distrubuting the binary version of php package for *nix server, so you will have to create the .so extension file yourself. download the source file for php and upload the folder /ext/mssql/ into your server
then

this commands will automatically create a copy of mssql.so in the installed extension folder.
you can check your extension folder from

Step 7: Enabling the extension

or you can use a texteditor and add that value manually into php.ini

Step 8: Restarting Apache Server!
dependin on version installed and location

and you are done!
do drop me an email should you face any problem at any step!
i know the pain in gettin this extension installed on unix. and considering rpm fails to work in the first place.
i will say, this is the best way to get it installed, cos u have full control over it. and didn’t fail me, of cos, after hell lots of googling around.

Source:
dpacool.com
unixodbc.org
Scott’s Blog
PHP PECL

okie, first post, i jus formatted my thinkpad t60. and the first thing that was totally irritating is the beeping sound whenever 3 or more keys are pressed.

so here’s how you can disable it.

1. Open the Device Manager. You can do this from My Computer -> Properties -> Hardware -> Device Manager.

2. Show Hidden Devices. You can do this from View -> Show hidden devices.
Okie, this part is quite important, cos if u miss this step, u cannot really proceed further.

3. Under Non-Plug and Play Drivers, open the properties for Beep. Go to Driver -> Stop, and the beeping will cease.
You can also Disable the device from starting up by Selecting Disabled in the startup type dropdown list.

Source: Elliot Lee