If you are using a older version of php connecting to a recent mysql (like os X Server 10.4 has) you will probably need to use the OLD_PASSWORD function in your SQL when creating the user or setting the password.

Normally you might do something like this to set a users password:

mysql> SET PASSWORD FOR root@localhost = PASSWORD('mypassword');

Whereas if you see this message from php:

"Client does not support authentication protocol requested by server; consider upgrading MySQL client"

You will almost certainly need to use the OLD_PASSWORD function to encrypt the password, like this:

mysql>

SET PASSWORD FOR root@localhost = OLD_PASSWORD('mypassword');

This is documented more in the MySQL Reference Manual (Broken link ~~http://dev.mysql.com/doc/refman/5.0/en/old-client.html~~).

It might appear to those paying vague attention that all I do these days is create large fires. This, I admit, is partly true.

All the fence panels have gone. Next project, get rid of the shed!

Took this from the top of a car park at the Brent Cross shopping centre.

About a month ago we left my little flat in Dartmouth Park. Oh my the last 3 and a bit weeks have flown by. To much to do, to much to repair. At least the new place is starting to look like a home!

It glows no more. It might be time for a new ‘book.

Random lunchtime sighting near work

Just down the road from our new house there is this little picturesque bowling green and pavillion. Taken with the mobile, I’ve not used the SLR for weeks. Must dig it out…

Just discovered that split (version 1.6) on Mac OS X Version 10.4.8 (PPC) does not handle files greater than 2Gb.

I’ve found two work arounds to this problem, the first is the one I typically do, but it requires darwin (Broken link http://darwinports.opendarwin.org/) ports to be installed, I happen to have this installed everywhere anyway.

Darwin Ports

Simply ‘port install coreutils’:

% port search coreutils
coreutils                      sysutils/coreutils 5.97         GNU File, Shell, and Text utilities
% sudo port install coreutils
Password:
--->  Fetching coreutils
--->  Attempting to fetch coreutils-5.97.tar.bz2 from ftp://ftp.gnu.org/gnu/coreutils
--->  Verifying checksum(s) for coreutils
--->  Extracting coreutils
--->  Configuring coreutils
--->  Building coreutils with target all
--->  Staging coreutils into destroot
--->  Installing coreutils 5.97_0
--->  Activating coreutils 5.97_0
--->  Cleaning coreutils
%

Thats it, the only caveat is the new GNU split is named gsplit. So remember to type that when you want to split files over 2Gb!

Compile from source

The second method was found here. I like to keep things in my own logbook so I’ve put a copy of the instructions below

1. Download the latest NetBSD split source from here
2. Add the following somewhere near the top: #include
3. Compile with either

• For your architecture cc -Os -o split split.c
• Or a Universal binary: cc -Os -isysroot /Developer/SDKs/MacOSX10.4u.sdk -arch i386 -arch ppc -o split split.c

4. Copy the binary in place:

$ sudo mv /usr/bin/split /usr/bin/split.apple
$ sudo cp split /usr/bin/split
$ sudo chmod ugo-w /usr/bin/split
$ sudo chmod ugo+rx /usr/bin/split
$ sudo chown root:wheel /usr/bin/split

We have the Be (Broken link https://www.bethere.co.uk/) 24 meg adsl in the office which uses their own Thompson Speedtouch 716 router. I’ve had some fun tracking down how you enable SNMP. This is what I had to do.

Check if the SNMP_AGENT system service is enabled, mine was not:

id="typed" id="typed"{Administrator}=>service system list

Idx Name             Protocol         SrcPort  DstPort  Group            State
---------------------------------------------------------------------------------
  1 CWMP_client      tcp                       80                        disabled
  2 CWMP_server      tcp                       51005                     disabled
  3 DHCP-S           udp                       49152                     disabled
  4 DNS-C            udp                       53                        enabled
  5 DNS-S            udp                       53                        enabled
  6 Dynamic DNS                                                          enabled
  7 FTP              tcp                       21                        enabled
  8 HTTP             tcp                       80                        enabled
  9 HTTPI            tcp                       8080                      disabled
 10 HTTPs            tcp                       443                       enabled
 11 IGMP-Proxy       igmp                                                disabled
 12 IP_COMMANDS                                                          enabled
 13 MDAP             udp                       3235                      enabled
 14 PING_RESPONDER   icmp                      8                         enabled
 15 PPTP                                                                 enabled
 16 RIP              udp              520      520                       disabled
 17 SNMP_AGENT       udp                       161                       enabled
 18 SNTP             udp              123      123                       disabled
 19 SSDP             udp                       1900                      enabled
 20 TELNET           tcp                       23                        enabled
 21 VOIP_SIP                                   5060                      disabled
 22 WEBF             tcp                       80                        disabled
{Administrator}=>

Turn it on

{Administrator}=>service system modify
name = SNMP_AGENT
[state] = enabled
[log] = false
:service system modify name=SNMP_AGENT state=enabled log=disabled
{Administrator}=>

Add a RO community

{Administrator}=>snmp community add
securityname = ROCommunity
communityname = ******
Please retype communityname for verification.
communityname = ******
:snmp community add securityname=ROCommunity communityname=_DEV_E43BC822A4BAE52F
{Administrator}[snmp community]=>

Where the asterisks are type your chosen community name.

Once this is done I could access the router using SNMP version 1 and my RO community string