StructureCMS

November 11, 2010

MS Sydney to Wollongong ride – a big thanks

Filed under: Cycling — joel.cass @ 3:31 pm

Thanks to all who donated their money to the Multiple Schlerosis Foundation in support of my ride from Sydney to Wollongong.

All up, it was about 88km in 2 hours and 55 minutes. The weather held out for a beautiful day, albeit a bit chilly in the morning. The event was very well organised and I was impressed with the level of enthusiasm shown by so many volunteers, it really lifted the spirits to be cheered on by many whom were living or supporting people with the disease.

The starting line opened at around 6am, probably 500 or so people left at the same time, of which I was towards the end of the bunch. It was a bit tricky at first trying to find space to ride with so many people around so I took it pretty easy. After we hit the main roads things started to spread out a bit and I was getting to a comfortable pace. Things continued on that way through to the Royal National Park, which took all the riders down a steep, wet winding descent through some low lying cloud, it was pretty surreal. Coming back up was not quite as difficult as the way down. I was quite surprised, you might be riding uphill for a couple of hundred metres, then down a little, then up again. It was relatively easy to maintain a good pace.

Heading towards coalcliff the pace picked up, I found myself doing around 42 km/h for a while until I reached a group of cyclists who had stopped. I prepared myself for the worst – thinking that perhaps a rider had fallen off or gotten hit by a car I was reasonably relieved to see that it was just a ute that had rolled into a ditch holding the traffic up. Once we got the clear-all from the police it was back on the saddle again and I tagged along with the bunch until Coalcliff.

Another big descent, albeit a dry one this time, led to the Seacliff bridge – this was an awesome spot to slow down a little and soak in the view, then it was a matter of going back up again. This time the hills were a bit longer, aggravated moreso by the fact that the road was still open to traffic, which made it difficult to pass some other cyclists.

After that it was a cruisy trip. All the turns were signposted, the more difficult ones were manned by volunteers. We had to stop to let some traffic pass before another winding descent down to Wollongong. The police did a great job of directing traffic. One even commented on the bandanna I had wore beneath my helmet, “Bogans don’t need helmets do they?” Confused and sort of offended at being called a bogan, I asked him what he meant, but soon figured it was a joke and moved on. Can’t afford to offend the police.

Getting towards to finish line led us down a shared cycleway following the beach and some new housing developments – Wollongong is looking pretty nice these days. Decided to take it easy to the finish line, reaching the end was a mixed feeling of relief and bewilderment – like, is that it?

I had pre-ordered a bike lift back to Sydney, that was probably a mistake. I had arrived in Wollongong at just before 9:00am, however the buses did not start until 11:15. The first bus left around 11:30 and didn’t arrive in Sydney until 12:45, then we had to wait about half an hour for the bikes, which meant I wasn’t on my way back home until around 1:30, giving time for the bikes to get off the truck. This is probably a good option for someone who leaves a little later, but I think in the future I’ll be catching the train. Or, perhaps just ride back, after all it did take around 5 hours for me to get home and only 3 hours to get there.

Anyway, I’ll stop complaining. The ride was overall good and something I’ll definitely do again. Here’s some photos:

The starting line, around 5:50am

The starting line, around 5:50am

Temperature at the starting line: 14.5 degrees celsius

Temperature at the starting line: 14.5 degrees celsius

The view coming out of the Royal NP

The view coming out of the Royal NP

The finish line

The finish line

Wollongong beach (north)

Wollongong beach (north)

View from Stuart park

View from Stuart park

November 5, 2010

Setting up an extranet login page in Sitecore

Filed under: Sitecore — joel.cass @ 8:30 am

Recently, I had issues with the setup of a public logon page in Sitecore. The setup was very similar to the way that login work in the Intranet solution, e.g.

1. A login.aspx page is created in the project folder
2. Settings are added to the web.config <site> tag: loginPage=”/login.aspx” + requireLogin=”true”
3. The login page either displays a form or is secured in IIS and then gets the AUTH_USER header to login users (if implmenting an AD solution)

The problem is, so it seems, that the latest version of sitecore (6.2) works differently from previous versions as documented here and here. The URL parameters item, user, and site are no longer passed. Furthermore, adding a SecurityResolver pipeline didn’t seem to work any longer.

So in 6.2, when a user cannot be authenticated to access a page, they are simply redirected to /login.aspx without any return URL or other useful information. This makes the situation even worse if you are trying to preview a page from the administration interface – basically every initial request is redirected to /login.aspx, and once authenticated the user is returned to the home page, as the original URL was lost when the user was redirected to /login.aspx.

Things seemed futile until a text search of the various config’s revealed the following setting in the web config:

      <!--  SAVE RAW URL ON LOGIN
            Specifies whether the original request URL is passed to the login page
            (saved in 'url' query string parameter).
            Default: false
      -->
      <setting name="Authentication.SaveRawUrl" value="false" />

Changing this setting to “true” now means that the return URL is passed through to /login.aspx as the ‘url’ querystring parameter. You’ll need to modify your login.aspx to look for this parameter and decode the parameter using Server.UrlDecode before redirecting.

This solution is simpler than the previous options available. It’s probably documented somewhere, I just never got a chance to read about it. I hope this is of help to anyone else who may be facing the same issues.

October 26, 2010

Setting the editor stylesheet in Sitecore

Filed under: Sitecore — joel.cass @ 11:02 am

Recently I was working on a site in Sitecore, and was thinking that it would be great if the editor stylesheet could be changed in the system.

Searching the Internet was generally fruitless, and looking through the core data, I couldn’t find any stylesheet config strings. Then, I stumbled upon the SIP Intranet guide, which pointed out that the editor stylesheet is in the web.config:

(section 4.2.1) The stylesheet that is used for the styling of the rich text fields within the editor is determined by the WebStylesheet setting in the web.config file.

And there it is:



Changing this field did actually update the CSS used in the editor, as well as populate the styles listed.

October 19, 2010

Please sponsor me!

Filed under: Cycling — joel.cass @ 10:26 am

I have entered the 2010 MS Sydney to the Gong Bike Ride and have committed to fundraise $1000.00 in support of people living with Multiple Sclerosis. This year MS Australia aims to raise $4,000,000 through the event, and I want to play my part and “ride for a purpose”.

Multiple Sclerosis is a disease of the central nervous system affecting more young adult Australians than any other neurological condition. Your donation will go directly towards providing a wide range of services and support to people living with MS.

Please take a moment to view my online fundraising web page and help me reach my goal. It”s quick and easy. You can donate securely online using your credit card by clicking on the link below:

http://register.gongride.org.au/MS-Sydney-to-the-Gong-Bike-Ride/joelcass/e

All information is secure and all donations will be sent electronically to MS Australia ACT/NSW/VIC. A tax-deductible receipt will automatically be sent to your inbox once the donation is verified.

Did you know?
- The average age of diagnosis of MS is just 30 years
- 3 times more women than men are affected by MS
- An estimated 20,000 people in Australia have MS
- There is no known cause or cure

Your support is greatly appreciated.

October 6, 2010

SQL Server 2000 Replication – Good one Microsoft

Filed under: Database — joel.cass @ 3:56 pm

One thing that I hate having to deal with, is replication in SQL Server 2000. It just seems like it’s half finished, and no-one bothered to think about what they’re doing when they wrote it. I’m not going to profess that I’m an expert in the area, I just think that it should have been done differently.

Recently I’ve had to set up replication going both ways between two servers. I had been recommended to stick to transactional replication, as it is being used on other databases set up similarly. One problem I have been having with transactional replication however, is that if a table is replicated both ways, the transactions related to the replication of data will be replicated, resulting in a horrible circular reference and before too long, full logs and no more disk space.

Furthermore, you will get random errors that occur anytime new data is inserted into a table on either database: “Cannot insert duplicate key row in object [blah]” or “Violation of [blah] constraint ‘[blah]‘. Cannot insert duplicate key in object ‘[blah]‘.”. Microsoft erroneously suggest that you add the term “-SkipErrors 2601;2627″ to the startup of the Distribution agent. Wrong. It should be “-SkipErrors 2601:2627″ – and, no error occurs on startup if the parameter is incorrect.

So, solving the full logs issue? You will need to stop both agents from running continuously, and schedule one or both of the transfers to happen every [x] minutes, otherwise the transactions will be replicated non-stop until the logs are full.

But the best solution for two-way replication would not be to bother at all with SQL Server transactional replication, at least for 2000. You could try merge replication, or set up a web service to allow data only to be written to a master db and replicated back to the child databases. Two-way replication is a bad idea.

October 1, 2010

Seagate “Expansion” Drive powering itself off?

Filed under: Technology — joel.cass @ 4:13 pm

I don’t know what genius wrote the power management “feature” of Seagate’s new range of low-price external drives. I recently purchased a 2GB Seagate “Expansion” powered external drive, and continually while I was trying to make all-important backups of my data, the drive would power itself down and I’d continually get these “delayed write failed” messages, which indicate potentially lost data.

One would expect that such a dodgy feature would be turned off by default. But no, the drive is configured to power itself down every 15 minutes, no matter what you might be doing with it. It’s a bloody stupid feature and whoever designed it needs to read a book on logical decisions.. Or learn to read.. or whatever

Anyway I digress, to fix the problem you will need to download the FreeAgent software from Seagate’s website, install it, run it, select your drive, click on “Adjust power setting” and set it to “Never”. More details can be found in the FreeAgent User guide, page 9.

You will never need to use this feature, the drive will power down when your computer is turned off or in standby. It will not turn on by itself whilst disconnected, at least not in my experience.

Furthermore it’s frustrating that I had to figure this out on my own. Endless perusal of FAQ’s, forums on the Seagate site, came to no avail. These guys clearly do not care about their product or the opinions of the customer. Well, here they are: I bought once, will never buy again.

September 23, 2010

Turn right, next stop Parramatta river

Filed under: Cycling — joel.cass @ 3:57 pm

I really don’t know what they were thinking when they partially closed the gates on the shared use paths at Sydney olympic park the other day and left this misleading arrow sign directing it’s users into the parramatta river…

May 26, 2010

.Net based HTTP Client in ColdFusion?!

Filed under: .net, ColdFusion — joel.cass @ 5:12 pm

I’ve been banging my head up against the metaphorical walls around here for ages trying to get ColdFusion to access websites via a proxy server that only supports NTLM authentication.

Short answer: don’t bother. CFHTTP does not support NTLM Authentication. Most of the Java libraries claiming to do so are hopeless. Support is inconsistent because no-one knows anything about the standard. Except Microsoft.

So, it only came naturally that the best way to solve the issue would be to use .net – and now that ColdFusion has a gateway to .net components, I could actually write something that solves the problem!

So, what I have done is written a wrapper that can be accessed by ColdFusion, and a simple custom tag to finish it off.

Some more information regarding download and implementation is in the Projects section.

May 13, 2010

StructureCMS 1.4 Released

Filed under: StructureCMS — joel.cass @ 10:50 am

Recently I have received (finally) a little bit of feedback regarding StructureCMS. Mainly that the administration interface is, well… Ugly. SO I spent a little time sprucing it up and clearing out the cobwebs. Here are some screenshots:

I have also made the following modifications:
- Remove flash-based image uploader (mainly because I was having trouble using it via proxy)
- Added a logo to all templates
- Checked administration system functionality across all major browsers.

Project home | Download File

May 12, 2010

Good, Fast, or Cheap. Choose Two.

Filed under: Musings, Programming — joel.cass @ 4:53 pm

How true is the above statement, really? With the rise of open source products one would think that it’s possible to find a product that ticks all of the above products, and is free to boot.

I found this out recently when I tried using SQL server to load in some website log data so I could generate some reports. Geez, it was slow. It ran at about 45 records per second. Inserting about 64 million records could take a loooooong time. On the other hand, I remembered the faithful MySQL server that I had used a while ago. Loading data into MySQL was fast – about 600 records/sec fast. And it’s free. But is it good?

When actually getting around to running the reports, I was finding that MySQL was falling short. Due to its architecture, sorting operations had to be done by writing a temporary table to disk. This could be worked around by using indexes, however often the indexes would not be picked up, plus the reconfiguration of an index over 64 million records can take 2-3 hours, thus slowing things down.

So either way it was a headache. I know that SQL server is very efficient at sorting and searching records and has its own optimised low-level methods for searching data. If you’ve ever tried to run a database from a compressed drive / folder you would know that certain operations do not work because SQL server accesses data at such a low level. And I think it’s that sort of optimisation that you would happily pay for. Whilst it may be slow on the insert side, it’s fast on the searching side.

So, “Good, Fast, or Cheap. Choose Two.” – I think the saying has real meaning here. An open source product may have the commitment of a small group of developers or no commitment at all. A paid product has a real business motive to keep developers “on the ball”, continually optimising and improving the product.

« Newer PostsOlder Posts »