klkl

While playing with my /etc/hosts file for testing a new server setup I needed to flush my DNS cache. As ever, terminal came to my aid.

dscacheutil -flushcache

Now all is well in the world of DNS.

The last couple of days I’ve been thinking about setting up a local copy of my websites on my laptop so that I can develop them before I make them live.

Last night I enabled PHP on the apache server built into Mac OSX on my new laptop and installed MySQL on it. I also set up some bash aliases to rsync commands so that I could synchronise the websites from the server to the laptop and back again.

Now that I had local copies of the sites that are synchronised it was time to turn my attention to synchronising the databases between the server and my local machine. I could of configured the server’s MySQL installation to allow remote connections, however, I did not want to do this for security reasons. I decided that I would connect to the MySQL server over SSH by forwarding a port on my local machine to a remote port on the server.

First I needed to create an SSH tunnel using the following command

ssh -fNg -L 3307:127.0.0.1:3306 server.host.name Read the rest of this entry »

If you have never set a root password for MySQL, the server does not require a password at all for connecting as root.

To setup root password for first time, use mysqladmin command at shell prompt as follows:

$ mysqladmin -u root password NEWPASSWORD

However, if you want to change (or update) a root password, then you need to use following command

$ mysqladmin -u root -p’oldpassword’ password newpass

Recently I’ve had a bother with the Mac firewall asking me if I want it to accept incomming network connections every time I open a particular application.

The appropriate setting can be found under:

System Preferences : Personal > Security > Firewall

I have mine configured to “Set access for specific services and applications” which normally asks me if I want to allow an application to accept incoming connections the first time I run it and that’s normally the end of it. The trouble comes when you try and update certain applications using Software Update. I’m not exactly sure what causes the problem but for some reason with specific applications the firewall then proceeds to ask you, each time, if you would like it to accept incoming network connections. This you can imagine is superlatively tedious.

The answer though is to just delete the application from you applications folder and reinstall it. The first time you open the freshly installed application it will ask the question and then bug you no more. Then all you have to worry about is not updating it via software update again.

To Test POP3

telnet xxx.xxx.xxx.xxx 110 (xxx = mailserver)
+OK Hello there.
user USERNAME
+OK Password required.
pass PASSWORD
+OK logged in.
stat
+OK (Information about your mail)
quit
+OK Bye-bye.

Read the rest of this entry »

Remember now as you pass by,

that as you are so once was I.

And as I am you too shall be,

prepare ye then to follow me.

Only a breach of criminal law may lead to prosecution. Breach of civil law, however, could well lead to the defendant being sued.

As trespass is a civil offence and not a criminal one then trespassers will most certainly not be prosecuted.

This post is attributed to my brother whom provided the information in the same conversation he tricked me into mis-answering a QI like question. More on that story later.

I’ve been working on some sites locally on my Mac but by default the files are stored in a directory in the individuals user account called Sites and the address you’ve got to type into your browser is http://localhost/~username/etc… this annoyed me because I didn’t want to have to type the tilde character in the address and also that I had to have the files showing in a subdirectories of my user. I couldn’t be doing with it, I wanted to have addresses like ‘http://localhost/subdomain/’ and the solution of course is to use symbolic links.

Read the rest of this entry »

…what I know now!

Today I’ve been having a conversation with my mother and we were talking about relationships and personality. We’re both of the opinion that its futile to attempt to change yourself in order to please someone else. If only I knew then, what I know now cropped up.

A paradox. The epiphany can never be true. I find in conversation that this phrase usually refers to attitudes and not knowledge. I have now the attitude I do only because of the experiences between then and now so it becomes impossible to ever have the vogue attitude without the requisite experience.

Jase

I want to hold you close to me.
I want to feel your warmth embrace me.

I want to feel your heart beat.
I want to smell your scent, sweet.

Your touch is all I need.
Your attention my only greed.

When all I wanted was for you to stay.
It wasn’t right, now, you’ve gone astray.