Tag Archives: snafu

UT3 for Linux?

Posted on by
Reply

after upgrading my pc hardware and adjusting my system to ubuntu 9.10 i remembered the good programming style of ut2004 which runs unter linux like a charme. when i bought ut3 i didn’t like playing it as much as playing ut2004. the movement and the whole gameplay had changed… but i think there enough reviews of that game in the collective memory of the web. i still want to be able to play ut3 under linux. it seems nobody is interested in that linux client anymore. how can that be? where is that linux movement…

it seems that two years are enough to make all demands to bring a linux client for this game disappear to /dev/null and this is a shame. no client available, no news.  i’m not going to play games under wine or so, can’t i demand a good software planning like it worked for ut2004?

Unreal_Tournament_3_Splash_Fix_by_coreperMaybe, now as the unreal engine 3 has been opened, there could be a little chance that some geeky linux programmer team could adapt enough lines to produce a buggy alpha version ;) but afaik the udev kit is also only for windows platforms. not so good, if you ask me. my knowledge about first person shooter development ended at designing multiplayer maps in the early days of being student (no evidence left hehe). but i still can try to understand how good those developers for ut2004 worked the system out. maybe you get my point, i really adore that game and it’s technique.

left to say: i’ll keep playing unreal tournament 2004 on linux, my in-game nickname is b1gbabou. i think, you can get the game for 10 € in every big electronics or games shop. unreal tournament 3 for linux is not provided on the purchaseable dvd and there’s also no steam client for linux.

if you have news on the ut3 on linux issue… feel free to drop a comment!

mysql replace http://typo3/http://

Posted on by
1

remember when the links out of the rte looked like http://typo3/http://yourlink.tld/ ? well, as i still prod at links looking like this, i’d rather post the relieving sql statement here. it’s simple but handy. the replace function just makes backend work even faster.

UPDATE tt_content SET bodytext = REPLACE(bodytext, 'http://typo3/http://', 'http://');

obvious things obvious – the 7 windows sins

Posted on by
Reply

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)

piwik shows General error: 126

Posted on by
Reply

last week there was everything working fine. no changes made. today, stuff is not running fine. piwik in version 0.4.1 does not show useful content anymore. if you ever get to see all your widgets showing the General error 126″ you can start over with mysqlrepair.

General error: 126 Incorrect key file for table ‘/tmp/#sql_6d3c23.MYI’; try to repair it

SQLSTATE[HY000]

Yes sir, we’re going to repair the database totally. To do so, we fire up

mysqlrepair -B piwik -force -p

which will show a lot of OK rows. option -A is for all databases, so if your mysql server is in production and you’ve got a bunch of dbs on it hot, you propably consider using -B option to point to the single piwik database. I had to retry this with different options but now the things looks okay.

so today’s view is fixed, but since the problem existed for around three days, two days of data are corrupted. so i open config/global.ini.php and set the debugsters to 1.

[Debug]
; the archiving process will always be triggered, even if the archive has already been computed
always_archive_data_period = 1;
always_archive_data_day = 1;

; if set to 1, all the SQL queries will be recorded by the profiler
enable_sql_profiler = 1;

after having reprocessed the complete archive, which does take quite a while, there is still a report of an incorrect key file. But now with nice SQL profiling., d’oh.

<?xml version="1.0" encoding="utf-8" ?>
<result>
<error message="SQLSTATE[HY000]: General error: 126 Incorrect key file for table '/tmp/#sql_694e23.MYI'; try to repair it" />
</result>

solution

the problem was caused by a /tmp partition defined too small (16mb on a guest). now as i raised the tmpfs size the system works normal again. in vserver landscapes you can search a while before finding the corresponding fstab in /etc/vservers/yourvserver/fstab on the host. All this can be found in the vserver faq section.

Thanks to @schommr for the tip.

Best of it all, your data won’t be gone if you have a problem like this. It just can’t be processed to show correctly. My concerns about several days loss of data were flushed away when piwik’s archive.sh ran through in about twenty minutes. go piwik!

alphabetical order of fe_groups in the access dialog of TYPO3 pages

Posted on by
Reply

here’s some useful snippet to control the size and the order of the access groups of a page.

access user group list

standard size of the page access list

access user group listwhen working with larger TYPO3 sites, the access groups can become increasingly complex. the list view to select the groups from is about only five elements long by default, but that maybe a bit too short when it comes to more than 200 user groups out of i.e. an ldap structure.

this makes selecting the right group painful, especially when this list is not ordered by natural alphabetical order but by id or other fancy computer data.

// more space to select fe_groups
$TCA['pages']['columns']['fe_group']['config']['size'] = 12;
$TCA['pages']['columns']['fe_group']['config']['foreign_table_where'] = 'ORDER BY fe_groups.title';

$TCA['be_users']['columns']['usergroup']['config']['size'] = 12;
$TCA['be_users']['columns']['usergroup']['config']['foreign_table_where'] = 'ORDER BY be_groups.title';

Add this code to your extTables.php file and things get smoother again. The last two lines apply the same for the backend user dialog with the backend user selection.