So the scenario is this: you notice that you are no longer able to login on your Drupal site:

• the {users} table entry for your account looks just fine
• the login and access timestamps on your account are just a few seconds old, matching your latest attempt to login
• you reset your password in the DB, just in case, and it still does not work
• the telltale is that Drupal will not even tell you your login failed: it actually works, as the {users} table shows, but yet you are not logged in

Can you guess what can have been going wrong and fix it ?

mysql -BNe 'SELECT COUNT(*) FROM TABLES' information_schema

The symptoms

While browsing my servers Munin reports, I recently noticed how used disk space was constantly increasing on a filesystem which should not have been seeing such growth. After a bit of digging, it appeared the /usr/local/var/varnish/(host) directory was filled with dozens of sparse files all named varnish.??????. What could have been happening ?

Now that Drupalcon Chicago is over, I found some time to fix the slides from my session at the Drupal Dev Days in Brussels. It took some time because neither Google Presentations nor Slideshare apparently like the MgOpen font family.

The presentation is now on Slideshare at http://www.slideshare.net/fgm-osinet/drupal-views-development.

The progressive code samples are attached to this blog entry, as a tarred Git repository.

Unless you've been living under a rock these last few weeks, you are aware of the fork of OpenOffice.org created by The Document Foundation (TDF), called LibreOffice (LO), and wondering whether some code was already usable.

Well, I happened to have a mostly unencumbered Saturday, so I took it to try my hand at building the latest LO dev build from TDF...

The second Open Source Developers Conference (OSDC) will be held on saturday 9th and sunday 10th, October 2010 at "Carrefour Numérique de la Cité des Sciences", in Paris. OSDC is a cross-language event, set up by multiple french language-specific non-profits:

• PERL: Mongueurs de Perl
• Python: AFPy (Association Francophone Python)
• Ruby: Ruby France
• SmallTalk: European Smalltalk User Group

Much like many Drupal devs, I happen to make fairly intensive use of Dropbox, and even use a "pro50" account to sync my always increasing set of "current" source folders, including checkouts of all major Drupal versions and lots of contrib.

Which means that, beyond the number of gigabytes of data Dropbox has to sync, the number of the files making up these gigabytes has also been increasing, currently to around 100k files. After I started playing with checkouts of the Drupy project in preparation for the Drupyx experiment, I noticed that, when I created some new files under the Drupy directories, their creations and subsequent changes would not be tracked by Dropbox, but they would correctly sync if I renamed the Drupy directory itself or a directory above it. Something like this:

And all this while operations on a PC running Windows tied to the same account did not experience any similar problem. What could be going wrong ?

So we Drupalistas were supposed to gather for some sort of social event at a concept bar (more below), and I bid my time walking the subway corridors, among the incredible crowd one can find out in Munich any Saturday evening around 8pm, as shown below.

So I'm in Münich for the Drupal Dev Days since the beginning of the afternoon, (and no concert suggestion for this weekend, tsk, tsk !), and as always when visiting a neighbour country, I find the little differences more revealing of deeper cultural ravines than the obvious language difference

If you like Opera Dragonfly, as I do, you may have stumbled upon a small annoyance: if Opera is configured to start with the previous window, if you use Dragonfly in a separate window - maybe because you use a dual screen config - if you happen to close the main Opera window with Dragonfly still open, and close Dragonfly afterwards, then you will notice that Opera complies with your choices: when you restart it, it restarts with the main browsing window closed and Dragonfly opened.

At this stage, closing Dragonfly won't help, because Opera will faithfully restore it at every launch. Annoying. Luckily, there is a very simple workaround if you find yourself in that situation...