Australia abroad

Entries from September 2008

Weekend

September 28, 2008 · 2 Comments

Had a nice party weekend. Yesterday the AFL (Australian Football League) Finals took place, and people went crazy in the city afterwards. They know how to party.

At first, it seemed like me buying some books in the city and returning afterwards to my place for a nice read. Well, Mike (from Germany) texted me if I’d like to join going to Glenelg for some Frisbee beach session. Why not? So we went there, but it was too windy to play. The guys had some beer cans with them, so we had them near the beach. But generally, beaches are “dry zones”, means alcohol drinking is not allowed there. Right when we opened the cans, a police car stopped by. Officers told us to ex the beers, and they won’t fine us. So we did, and saved 200 bucks each, a total of 800. Thank you guys! Nice one, we thought, and went for a walk, direction city. After half an hour walking and chatting, somebody suggested to go into a pub, so we did, had some drinks and moved on back to the city. There we split, I met with Gavin and Mark (from French speaking Switzerland) in Duke of Yorks, where everybody was dancing like crazy. So I just went crazy too and enjoyed myself and people around me throughout the night :)

More pics on facebook.

Categories: Leisure · adelaide
Tagged: ,

Intern News

September 26, 2008 · Leave a Comment

At the end of the fourth week in Adelaide a short recall of topics:

Linux

Debian:

  • server setup, port configuration, JAVA application deployment
  • services: apache2, SSH, webmin, firestarter
  • configuration of sudoers, proxy configuration;
  • issues with blocking site partially solved with increasing time between requests (other options: running several instances of the application, randomize requests);
  • moved to server room, up and running.

Ubuntu:

  • desktop GUI setup;
  • Oracle setup following an excellent tutorial on http://www.pythian.com/blogs/968/installing-oracle-11g-on-ubuntu-804-lts-hardy-heron A tricky part was the creation of a database using dbca. All wizard steps where pretty smooth. There were no errors at all. But the last screen of the wizard just showed a Grey window without any buttons, so the process couldn’t be completed. Problem solved with disabling all visual effects in Ubuntu (System->Preferences->Appearance->Visual Effects->’None’);
  • without a startup script, the $ORACLE_SID has to be set to the database name before connecting with SQL Plus: export ORACLE_SID=dbname
  • connect to database using command history recall (‘Up’-Key): rlwrap sqlplus username

Commands: sed, cp, mv, nc, ssh, dhclient, ifconfig,…

Databases

Oracle

  • played with several SQL statements and PL/SQL procedures to determine relationship between queries and documents, starting with (query, doc1, doc2) triples. Each triple represents a graph; the graphs connected result in a ‘forest’ which can then be explored (emergent semantics);
  • wrote documentation

PostGres

As we’re running Macs in our Lab, we’d like to keep the TimeMachine funcionality on the Mac Pro where the database is going to run. Therefore, no Linux. In fact, there’s no Oracle 11g server distribution for MacOS. As we won’t need Oracle’s Spatial functionality like we thought before, we might port to PostGres.

Oracle – PostGres differences

Oracle PostGres
VARCHAR2(n) no VARCHAR2(n), use VARCHAR(n) instead
no autoincremention, use triggers instead auto incrementation data type SERIAL4
sequence.NEXTVAL, sequence.CURRVAL
  • nextval(’sequence’)
  • currval(’sequence’)
  • lastval (returns value most recently obtained)
  • setval(’sequence’, bigintvalue)
PL/SQL unique constraint exception DUP_VAL_ON_INDEX UNIQUE_VIOLATION
RETURN RETURNS
DROP FUNCTION fname; DROP FUNCTION fname(TYPE, TYPE,…);
EXEC fname(arg1, arg2,…); SELECT fname(arg1, arg2,…);
Before creating a function: CREATE LANGUAGE plpgsql; define to use this language in function header: … RETURNS void AS $$ DECLARE …; after function creation: $$ LANGUAGE ‘plpgsql’;
DESC tablename; \d tablename;
START script.sql; \i script.sql;
Start client from command line: rlwrap sqlplus username sudo -u user psql database
Exit command line: exit \q
Show user tables: select table_name from user_tables; \dt

Categories: UniSA
Tagged: , , , , ,

Morning Hour Has Gold In It’s Mouth

September 21, 2008 · 2 Comments

Maybe I should stop translating German phrases into English… Today I got up at 6 am, and that’s very early compared to what I’m used to on weekends. (Not going out yesterday paid off obviously.) So I had the exciting idea to grab my picture cam and go for a run. There’s also another pic, which is more related to my last post.

Categories: Leisure · Sports · adelaide
Tagged: ,

Partytime With A Burned End

September 19, 2008 · 4 Comments

A great thing about living in Adelaide: There are parties almost everytime. At least on weekends. If one would like to get out on weekends, there’s not doubt that somewhere in your area something’s going on. In Adelaide City, Saturday’s the right day to stay awake till early in the morning. You can find a lot of pubs and clubs. But keep in mind to always carry your ID, in my case that’s the passport. Otherwise you could run into trouble trying to get in certain clubs. On my first Saturday night in town, of course I didn’t think of my ID and went to the city, which is a 30 minutes drive with the bus. Btw, public transport drivers in Australia are generally very helpful, as most of Australians are. If you ask for how to get somewhere, they always do as much as they can to guide you. And on that Saturday, I didn’t even had to pay for my bus ride, which is normally about 2 $ for one direction (the main reason was, that I wanted to pay with a 20 $ note and the driver had no change).

So I got on that bus, happy to ride for free, and after half an hour I arrived at a club called ‘Duke of York’. At half past eight, hardly any people were there, so I just made my way to the entrance, where a blonde girl waited for me. “May I see your ID please?” she asked me. “No, you can’t” I thought, I haven’t had it with me. “aahhm… well… here’s my International Student ID. How’s about that?” I asked, trying to look nice and handsome. But the blonde girl was very strict and answered: “I’m sorry, you can’t get in. I’m the manager. You can’t get in without an ID.” Damn it. I knew that it’s usual to carry your ID when going out in Australia, I did it in Sydney before. So I was kind of pissed off. After a few minutes, Gavin which whom I was supposed to meet, arrived and I told him my story, which pissed him off too. Moreover, he started complaining about my sport shoes. (Yes, maybe they look kind of crappy. But so many people weared sport shoes in Sydney, so I thought, well, why not me on a Saturday night?).

As there’s only one bus route I actually know to get from and to the city, I had to wait about 20 minutes for my bus home. Of course I wanted to go out that night, even if I wasted two hours to go home again to get my passport. That was my opinion when I waited for the bus. In fact, back at home, somehow I felt tired and my motivation for going out was gone. So I sent Gavin a message to chancel the meeting, he had some other friends to meet anyway. I felt hungry, put up a nice pot of rice and switched my notebook on. A few minutes later, my mobile indicated a message arrival, in which Gavin stated that they were betting either if I came back to the city or not. Two beers for me were the odds if I came. And I thought: ‘Well, he’s right, it’s my first night out in Adelaide, the club looked nice, I should really go out. And there are those beers!’ So I grabed my stuff, put on stylish leather shoes and a jacket and hurried up to catch the bus.

Beside the fact that I didn’t have to pay for the second bus ride to the city again (AdelaideMetro ftw!), after the first station I recognized it: No passport again! Damn! I was on the last bus to the city, so getting out, walking back, picking up the ID and catching another bus was no option at all. So I did the only possible thing that made sense: Trying to get in another time without passport. But instead with new shoes and jacket.

And guess what: It was as easy as it is for 14 year old teenagers in Austria to get into ‘Nachtschicht’ on weekends. I showed her (that time, it was another girl) my International Student ID again, and everybody was fine. The dance floor inside burned already, music was great and Gavin was really surprised to see me. After the first beers (the local Coopers is really worth a try!) and a nice chat with his friends we all made it to move our bodies to the hottest rythms on earth. We had a great time and enjoyed ourselfs til early in the morning.

At about 4 we (Charlotte, Rose, Gavin, me) decided to leave ‘Duke of Yorks’ to get out for some fresh air. Gavin hunted the whole night for Rose, but Rose played some games girls sometimes like to play. Those kind of games, where several guys are involved at the same time. Those games, were it seems like there’re loosers and winners (stupid, I don’t like those games). And it seemed like he lost (to him, IMHO the other homeboy didn’t had a chance at all!). Anyway, Charlotte (I think that was her name) was still after Gavin. So why not give it a try? They did, and we finally all crashed Rose’s place. She provided us with yummy pasta, and after another two hours we felt kind of tired and went to bed.

Unfortunately, Gavin had to get up at 8 again. Because I had no idea were I was (we went with the cab in the morning) I joined him. His brother picked him up, and after a short visit at his house I was dropped off at a bus station, where I expected a certain bus. Which didn’t show up. After one and a half hour I decided to try another bus, which first took me back to the city where I could take my default bus route home.

Four hours after getting up, I finally got off at my home station 33 (right next to McDonalds) and suddenly (surprisingly) felt very hungry. At that moment, I was thunderstruck! You know that feeling, when you forgot something very important, like an exam the next day and you didn’t learn anything yet? Increasing heartbeat rate and Adrenalin rush! When I was at home the night before, I actually didn’t intentioned to go back to the city. And I felt hungry. And I put a pot with rice on the gas stoven. And I didn’t turn the gas stove off when I left the house! So what could have happened? Either the whole house already burned down and there’s nothing more to rescue or some of my housemates smelled the burned rice and turned the cooker off. In both cases, it wouldn’t have had made anything better if I stressed myself and therefore went to McDonalds for two double-cheeseburger and a coffee.

Back at home, the house was still there. No smoke coming out of the door or windows. Inside it smelled a little bit. And the pot was… well, I bought a new one. Happy that nothing serious happend, I decided to stay at home and chilled with some old-school computer games after a nice Skype session with a great girl.

Categories: Leisure · adelaide
Tagged: ,

Around the World

September 5, 2008 · 1 Comment

My course of study KWM (Communication and Knowledge Media) could also be called International Communication and Knowledge Media. Currently, a third of students are on their internships, somewhere abroad. UK, Sweden, Germany, Australia, USA. It’s really impressive.

But when it comes to the local time in a particular city, things get messed up quickly. Want to have a nice chat with someone 15,000 km away? Just check the Foxclocks in your Firefox toolbar and you’re ready to go. Configure Foxclocks to show the current local time from as many cities around the world as you’d like to see (btw, I couldn’t figure out a city in Wisconsin, so I took Chicago, seems to have the same local time as Milwaukee).

Categories: Leisure
Tagged: ,

Debian and Future Tasks

September 5, 2008 · Leave a Comment

Work diary, second week:

The Debian server is almost ready to go. Managed to get Apache2 with phpWiki running this week. Reminder: Always delete every other Apache installation. And: Watch out for existing log dirs when setting up a VirtualHost (entries have to be the same as in filesystem).

Set up Webmin, a great webinterface for Linux systems. You can manage almost everything: Apache server, MySQL server, processes, etc… from remote. Disabled automatic boot startup and changed port for Webmin. SSH works great.

Main application is running, although it seems to have still some problems with particular sites.

Future tasks: Discussed goals with Helen. As soon as the server setup is finalized and the application runs smoothly, the system is going to move (still open: try .sh scripts, port from Mac to Debian; access from only within the Lab network?). Subsequently, based on the image retrieval project I outlined in another post, I’m going to rebuild the experiment and do research in a new direction.

Categories: UniSA
Tagged: , ,

Linux and Living in a community

September 1, 2008 · Leave a Comment

Firstly, thanks to everybody who messaged or called me on my new mobile. Actually, I missed most calls and can’t write back. I still don’t have any credit.

The last two working days of last week I spent with some papers and an old workstation, trying to get Debian (Linux) installed and prepared for server use. That worked out pretty well, although the Internet connection had to be established manually today. After a modification of the .bashrc with two additional lines for the HTTP and FTP proxy, almost everything was done. Tomorrow I’m going to get the Sun Java Runtime Environment installed and the firewall configured. This particular machine is ment to be the system for a Java application, which is going to gather information about particular Internet services over the next six months. Afterwards the gathered information is going to be analyzed. Next tasks maybe to write a user documentation, get the application installed and ready to run and take care that it keeps running.

For the last weekend I didn’t have any plans so I stayed in my bed almost the whole Saturday sleeping, watching films, setting up a fresh Windows XP and regenerating. I didn’t feel healthy anyway. But staying at home really paid off. On Sunday I felt so much better. And today my cold is almost gone!

Some words about “living in a community”: I remember those days, back at home when there were people (particularly parents) cleaning up for me when I messed up something or “forgot” to put my dishes into the dishwasher. For me, those sweet days are gone for more than a year and I’m fine. But it seems like some of my housemates still need someone, who cleans up after them. There were some serious kitchen cleaning issues the days before my arrival, they got almost physical. Therefore, a house meeting has been issued for last Sunday, were everybody agreed to a key point: Immediate clean up after kitchen use, including fat splatter and similar. In fact, the days right after the meeting, some just ignored what everybody agreed on. As a result, the former kitty manager wrote a very emotional mail to the landlord, mentioning names and informing him about the situation. That lead to some emotional reactions by the mentioned guy, who was supposed to be the “bad guy”… Anyway, with the beginning of September, I’m the new kitty manager, and therefore responsible for our cash, buying general stuff like toilett paper, reminding others to take care of a clean environment and keep the landlord informed if necessary. I’ll try to avoid that, and personally talk to everybody before doing anything else. And today, the kitchen was perfectly cleaned, anyway.

Finally, some pictures from inside the house.

chair, bed, commode

My room: chair, bed, commode

cabinet, chair, desk

My room: cabinet, chair, desk

big window

My room: big window

Favorite bathroom

Favorite bathroom

Kitchen

Kitchen

Dining table, living area in the background

Dining table, living area in the background

Community area outside, car ports across

Community area outside, car ports across

Washing room, big dustbins outside

Washing room, big dustbins outside

Categories: UniSA · adelaide
Tagged: , , ,