connect to a webdav with windows 7

if you try to enable the webdav (web based distributed authoring and versioning) service with a linux server and apache2 it´s a piece of cake. the only thing you need to keep in mind is to make it ssl and auth_digest. this is so that windows clients can connect to the thing. theoretically. after all my unsuccessful attempts with the wizard ( i tried it like a hundred times with all different url formats ) a desperate try with net use made it work!

net use z: \\subdomain.domain.tld@SSL:443\webdavfoldername

will ask for a user and a password to gain access and to mount the webdavfoldername (your webdav alias in apache´s virtualhost conf) to drive letter z:

this is a hell of a lack that windows 7 has, but of course webdav seems to be an anathema to microsoft.

useful addendums to the command above are /persistent:yes and /User:user password and i hope it helps you save worthy hours.

piwik archive.sh out of memory

if you happen to run into memory issues piwik/core/DataTable.php with the archive.sh script of piwik you might go to free up memory on the server, like i did. memory problems with the archive script are known.

since php5/cli/php.ini shows memory_limit=-1 which means no mem limit (which i thought is a good value), i didn´t care too much about this. but at the end it turns out, a little add (-d memory_limit=1024M) to the archive shell script worked things out for me:


// snip---
echo "Archiving period = $period for idsite = $idsite..."
 CMD="$PHP_BIN -d memory_limit=1024M -q $PIWIK_PATH -- module=API&method=VisitsSummary.getVisits&idSite=$idsite&period=$period&date=last52&format=xml&token_auth=$TOKEN_AUTH"
 $CMD
// snap---

this made finally happen to bypass the archiving process for month/year and the server now has lower memory footprint because i tuned stuff down as much as i could before that :)

so, if you want to override an ini setting for the script you´re calling, the -d flag is the one to help.

keep TYPO3 sysfolders clean

just a small hint to restrict the creation of new elements inside a page (eg. a sysfolder) so that this sysfolder will only hold tt_news entries or sys_templates or whatever. you put that code into the pageTS of the sysfolder/page:

mod.web_list.allowedNewTables := addToList(sys_template)

if you´d like to only contain tt_news entries and tt_news categories you´d put addToList(tt_news,tt_news_cat) into the TS and then these are the only elements to create new inside that folder. if you want the sysfolder to hold only entries for the nifty contagged extension, you use addToList(tx_contagged_terms). here´s more on contagged as tool tip manager.

simple way to access websites that seem to be censored

fortunately, i find myself living in a country that appears to accept freedom of speech, freedom of data. while i´m quite aware that this ideology is not to be supported in future concepts to keep masses controlled i find every citizen should try to gain knowledge in bypassing common web censoring methods. how do you think about that? i find this very interesting and simultaneously hope that the information in the web remains free.

bypass ip locks

if you happen to sit behind an ip barrier that i.e. stops wikileaks you might bypass it in ways (free of charge) like these

  • use translate.google.com and open the page that is censored, if google is not cooperating with the bad guys ;)
  • use compressor services like loband if you can live with the html only version
  • use proxies –> ixquick allows you to use a search result in proxy manner
    • use ixquick search engine and search for the censored page
    • click “proxy” behind the url of interest, then ixquick will serve as proxy

ixquick screenshot

simple thing to do and it does not cost anything. of course you could set up tor to communicate privately (hence making ip resolving useless).

another approach would be to ask a service like web2mail to compress the website you want to see and let them send it to your email box. then you see the requested page after unpacking the file you received. clicking a link would result in asking web2mail for the target and another email.

All these ways were told during a talk at this year´s sigint that you can watch at media.ccc.de

IPv6 addrconf: prefix with wrong length

after i got up my ubuntu server i checked the syslog where the kernel kept griping about the following.

IPv6 addrconf: prefix with wrong length 48

To keep the syslog clean i searched for a way to suppress that message. it´s simple.

In /etc/sysctl.conf i add two lines

net.ipv6.conf.all.accept_ra = 0
net.ipv6.conf.all.autoconf = 0

There you go.

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.