new database with user in mysql console

this will create a new database on the server with the new user having all rights granted on that db.


CREATE USER 'uname'@'localhost' IDENTIFIED  BY 'pass';

GRANT  USAGE ON *.* TO 'uname'@'localhost' IDENTIFIED  BY 'pass' WITH  MAX_QUERIES_PER_HOUR 0  MAX_CONNECTIONS_PER_HOUR  0  MAX_UPDATES_PER_HOUR  0  MAX_USER_CONNECTIONS  0 ;

CREATE  DATABASE  IF  NOT  EXISTS 'uname' ;

GRANT  ALL  PRIVILEGES  ON 'uname'.*  TO 'uname'@'localhost';

if there´s a problem when creating the database,  do not use the ‘ ‘ signs around the db name.

just to avoid phpmyadmin for this little task ;) i didn´t like to look that up everytime.

how got my ethernet disk interface access back

fancy stuff to do with an lacie ethernet neil poulton disk 500gb item

network space

And i just wanted to reset the admin password of the lacie web interface due to froob-style loss. for those seeking a quick answer for that:

  • turn OFF your ethernet disk (if it’s running now). after the light stopped flashing…
  • turn it ON again for around 2-3 secs and…
  • turn if OFF again and prepare to…
  • turn it ON immediately. Now the blue light is flashing frenzy and you’re about to be able to log into the interface with admin/admin

You see, no need to be a geek to gain access to an ethernet disk standing around ^^

typo3 4.3 up and running

most of my projects are updated and as expected the update to TYPO3 4.3 hadn’t been a problem. everything went well and the new backend look is charming.

all went well

the sites get even faster,i did not instatiate the new caching factory, though. the new recycler is great and a must for every mid sizes website. the new recycler works way better when deleting tons of entries from a table.

the update of the extension templavoila to version 1.4.1 was also no problem, though on the biggest site i administrate (with more than 60 backend editors) i’m preparing for some bug reports. newest tv style finishes the new interface design at all – a feature that impresses them all is the drag and drop feeling.

tt_news 3.0.0 – don’t update live

but beware of upgrading tt_news too fast from version 2.5.2 (which is the highest in the 2.x branch) to 3.0.0 if you not have checked how the templates change! the whole morning was consumed by the fixing of tt_news styling. tt_news come with new caching mechanism that promises to speed up some data work that needs to be done every time news are rendered. tt_news 3.0.0 comes with that cool new update script that checks for possible problems – where it removes relations to templates as far as i remember.

falling back to the standard template coming with v3 the title wrapping changed from h3 to h2 and stuff like this – thus breaking the layout of the website on every page. if you’re using tt_news as main function for a big web site that should not be done “live”. ;)

also there had been problems in the realurl configuration after the update. solution was to grab a selection of the content of res/realUrl_example_setup.txt in the tt_news ext folder and drop it in typo3conf/realurl.php and so the errors were gone.

i don’t know why this was necessary, but tt_news showed a nasty red bordered error if now singlePid was set (which can be done in the constant editor) even if the site worked before with tt_news 2.5.2 due to single-page target was set per plugin settings.

another thing you might want to avoid is the output of some php stuff before the website’s head section.

all in all i’m happy away how simple it’s getting to create web content management. many of the tricks you need to learn are now turned into guides (i.e. compare database is the final step of the update in form of a button in the update wizard process – before that you just “needed to know” that).

great job TYPO3 core team!

my remix for röyksopp´s tricky tricky

today is the last day of the remix contest for röyksopp´s fantastic track tricky tricky and as i had spare time for the weekend, i attended with this remix. It´s my straightbeat weekend story to interpret… maybe it´s an aural time lapse for a clubbing time from friday afternoon to sunday midnight, maybe it´s a two parter to be played in a club from one style to another, or… maybe it´s all nonsense and it´s just 7m 25s for the subwoofer. as the track itself sais: this is what you get, a bunch of stories to interpret.

Dare to listen to it :)

As, like for the most, the voice makes up the most of the track, i took that and adapted it in whole. a saw synth is quasicoded by the vocals and brings the needed body for the track. even more important to me is the sub line of the original track, which i took into account for my remix. it has been a little bit boosted for club convenience. A little fm synth in a 3/2 pattern is installed so those nerds have something to shift on and the main part is aided by röyksopp´s marvelous chord part. this is the stuff i´m searching for in the acid-music: beautiful melancholy. 143 BPM.

Hope you like it. Nevertheless, you may find another remix more fitting your taste. a lot of cool work is summing up there!

obvious things obvious – the 7 windows sins

good old times there were when the number of the beast contained the nifty 6, but after cracking hell open on personal computers with a forced push of ‘vista’ the company in question went on to give the 7 a try. it´s like perdition 2.0  ^^

it´s bad enough that so many friends fell to that call that they literally jumped out of the windows they have been accustomed to. i´m not supporting nor running vista or 7, so wtf? it´s so easy and comfortable nowadays getting up running an ubuntu or sabayon or what. no pact with the devil at all, and image: you need a bit time to configure the system the way you want it – but you learn for the future with open standards! don´t be dazzled by the professional moves of the manufacturers of the 7!

We become what we behold. We shape our tools and then our tools shape us.
Neil Postman

so…

… the next time you sit in front of your cool pc running a crippled windows as os you could surf to distrowatch and read about your new, future operating system! distrowatch has plenty of them with detailled description. open source has some neat advantages, you will see. and there´s so much love out there, people writing tutorials i.e. on how to install your graphics card or how to get a tv tuner card running. okay there is lots of noise around windows, too. ;) but see these seven sins of the 7 and be enlightened to throw it off your pc in the next 48hrs.

changing the system can be a hard task; almost as hard to change an old aged behaviour. that needs time and confidence… and positive feedback (that should be doable!).

so to speak, forget about infected files, the vast amount of security issues, nasty hidden services, apps phoning to the home of evil and the internet explorer. forget about digital rights management (d´oh!) and your learned behaviour to press Start to shut down the computer… we´ve all been trained to go for the banana hehe.

you can do all your regluar stuff on a linux system

  • open office is way more sticking to standards and has overall equal functions like the office blowfessional
  • pidgin is capable of letting you chat on icq, msn, yahoo, jabber… except for skype, but you can download skype for linux if you like it
  • access the web with opera firefox iron
  • email organizing, planning, programming, mindmapping, image editing, project managment, web publishing, gaming… open source is growing everywhere! and that´s so heavenly good.
  • media players are onboard almost every desktop linux os these days… what else could one need in the everyday mode?

if there´s a task you need perform, you can always use the packet manager of the system to download binaries or source code (depending on your chosen system). in that packet manager you can search for tags and descriptions fitting your needs. in most cases you´ll find an appropriate piece of software that does the job.

… hmm that felt good, i wanted to write about that for a long time… (as you can see on blog posts like uninstall vista baby that are well known for their brevity)