Search Results: "will"

5 April 2008

Junichi Uekawa: Debian JP leader.

Debian JP leader. I have been selected as Debian JP leader for 2008. This is my third consecutive term since 2006, and will be the second full term since 2007.

Steve Kemp: You know how to use candles?

Mutt
Fran ois Marier has recently been posting some interesting entries about the Mutt mail client upon his blog. His tips are pretty basic, but that doesn't make them less useful. So here's my tip of the day: reply_regexp. When you're viewing a mail, and you choose to reply it the subject of that mail is the basis of your message's subject. For example given a message with "Subject: hello" your reply will typically have the subject "Subject: Re: hello". This is real rocket science here, people. Imagine you're using SPAM filtering which tags messages it isn't sure about with a prefix "UNS:". Suddenly things don't look so hot, as you might end up with a mail with the subject:
Subject: UNS: Re: Hello
Reply to that mail, whilst being half-asleep, and what do you get? You get this:
Subject: Re: UNS: Re: Hello
Bad. Ugly. Wrong. The following snippet in my ~/.muttrc file correctly deals with this case:
set reply_regexp="^(((UNS:[ \t]) [rR][eE]:[ \t])*)+"
Neat. Cool. Nice.
Advertising
I've paid for some advertising upon the LWN.net site. (No link, I'm not trying to game things here.) I didn't know what to expect, but I was willing to risk the expenditure as a way of saying thanks to them for their great content. (Because of my Debian Project membership I get a free LWN subscription, as do all developers. see here for details if you're a developer without a subscription.) I've paid $30 and that has given me a months run of my advert, with clickthroughs hovering around 1%. Not horribly bad at all! I probably won't repeat the experiment for the forseeable future, but I'm glad that I did it at least once. If you have something appropriate for a Debian-based audience don't forget you're welcome to advertise upon the Debian Administration website for free - See the Advert FAQ for details.
ObQuote: The Craft Update: jquery was accepted yesterday. Today I uploaded a new version to more closely align it with the javascript-policy.

Yves-Alexis Perez: Printing

I'm currently looking for a printer. I want a Laser printer, black & white should be enough, but color may be ok too if not too expensive (especially toner). I guess I prefer a network one, even if I don't really understand the way everything should work. As I understand it, a network printer just listens on a defined port (9100/jetdirect or ipp/63), and prints jobs sent by a spooler. There is no integrated spooler, so there are two solutions: Maybe I shouldn't buy a network printer and just pick a usb one (especially since the FreeboxHD can serve as a laser printer if one plugs a usb printer on it. It listens on 9100/jetdirect so one can configure cups to pick it). I've currently narrowed my choices to: Moe on #xfce avised me to pick a printer a bit more expensive, because it would be safer on a long term, and advised: I don't really know what to do so, dear lazyweb, I'm asking you. What should I pick? This is for a home installation where we don't really print that often, so I don't want to spend too much, but where goodies like network and duplex printing are cool to have. Cups support is mandatory (except if there's another way to print easily, especially from gtk apps)

4 April 2008

Gintautas Miliauskas: The meaning of code

I had an "Aha!" moment today when I came to a Wittgensteinian realization that while the sense of a piece of code corresponds to the formal behaviour of that code, the meaning of the snippet is the set of possible contexts where this code could be used. This idea has changed my view of teaching programming (I have been teaching Python in a local school for a couple months now). This attitude is nothing new, but for some reason I have not come across it, or rather, I have never seen it applied. (The fashionable problem-based learning thing has some similarities, but isn't quite it.) Having an idea to start from, it was not hard to find good articles expanding the idea. I especially liked Robert Strandh's short writeup on idioms and Elliot Soloway's Learning To Program = Learning To Construct Mechanisms And Explanations (1986). Experienced programmers will not learn much, but anyone dealing with CS education, teachers and students alike, ought to have a look. The moral is that emphasis should be placed on reading exemplary code ("experienced programmers do X this way") rather than definitions ("function Y does Z"). Programming seems to be closer to language use than to mathematics, and teaching methods should reflect that.

Gunnar Wolf: Vote casted!

Some readers might not now that Debian is in this annual process where we vote for our Leader for the following next year.
I just submitted my vote.
I think it is worth mention that this year there is very little discussion on this subject among DDs. Also, I've practically seen nobody publicly posting their votes or preferences, as it is usual (well, usually we get maybe 10 votes posted to the planet or the different lists).
It must be related to the fact that this year we have neither a candidate or quasi-candidate who raises passions for or against (as the two last years), nor there are very significant differences between the three candidates. They are all quite OK, IMHO, uncontroversial.
This years' elections will probably be the first (at least, since I was accepted in the project) where no candidate is ranked below None of the above. And that, I think, is a good sign. It might be more boring, but shows maturity ;-) And yes, it also shows off good work from our current (and active, and much loved) leader, Sam.
...And yes, I'm not posting my vote either. As things are, the platforms/rebuttals/debate did shape my vote a bit, but the main differentiator ended up being... My personal relationship and opinion towards each of them.

Sylvain Le Gall: OpenOffice.org fonts too big in XFCE

UI fonts of OpenOffice.org Writer and XFCE thunar are really not the same ... years of seeing this ugly font and being force to scale the OpenOffice.org UI display to 80%. I just found the solution! All his related to a X settings: Xft.dpi. People are suggesting around to set it to 96 or something like that. I just decide to use the one i can find xdpyinfo (does it make sense?) and send the result to X settings using xrbd. Here is the script $HOME/bin/xfce4-xft.sh:
#!/bin/sh
xrdb -query Xft.dpi   grep Xft.dpi > /dev/null && exit 0
RESOLUTION= xdpyinfo   grep resolution   sed "s/.* \\([0-9][0-9]*\\)x.*/\\1/" 
TMP= mktemp 
trap "rm -f $TMP" EXIT
echo "Xft.dpi: $RESOLUTION" > $TMP
xrdb -merge $TMP
Copy/paste/chmod a+x this file. And then add a file $HOME/.config/autostart/xfce4-xft.desktop to autostart the previous script:
[Desktop Entry]
Encoding=UTF-8
Type=Application
Name=XFCE-XFT
Comment=Fix XFCE Xft.dpi settings
Exec=/home/gildor/bin/xfce4-xft.sh
StartupNotify=false
Terminal=false
Hidden=false
(replace /home/gildor/ by your own home directory) Thats it. Your Xft.dpi will be fixed depending on the configuration of your X server. This allow you to have a laptop and a desktop with different screen resolution. I am waiting the email from bugzilla.xfce.org to submit this script to XFCE bug tracking. Enjoy. Update: Following the comment of this entry, another better solution is to use openoffice.org-gtk which works out-of-the-box with a clean UI. I don't even have to force OO to gnome style. Thanks to Dan Callahan, Vasilis and Corsac for their suggestion.

Neil Williams: HP laptop repaired (and wireless)!

OK, after a mainboard replacement by HP, I have my AMD64 HP Pavilion DV6000 (DV6615ea) back and a quick update has given me working wireless! The last remaining obstacle has gone - the most recent 2.6.24 kernel update includes working support for the Broadcom Corporation BCM94311MCG wlan mini-PCI (rev 02) in the b43 kernel driver.
a little tip
When connecting this laptop to the mains for a recharge, plug into the mains before connecting the mains lead to the laptop itself. I have a strong suspicion (but it is no more than that) the repair was caused by a power spike from a dodgy extension cable. Plugging into the extension without the other end being connected to the laptop isolates such spikes.
Necessary support
$ uname -a
Linux dwarf 2.6.24-1-amd64 #1 SMP Thu Mar 27 16:52:38 UTC 2008 x86_64 GNU/Linux

 $ dpkg -l 'linux-image-2.6*'
linux-image-2.6-amd64 2.6.24+13
linux-image-2.6.24-1-amd64 2.6.24-5

Wireless config
The first dmesg output showed a useful tip:
Apr  4 20:07:06 dwarf kernel: b43-phy0 ERROR: 
YOUR FIRMWARE IS TOO NEW. Please downgrade your firmware.
Apr 4 20:07:06 dwarf kernel: b43-phy0 ERROR:
Use this firmware tarball: http://downloads.openwrt.org/sources/broadcom-wl-4.80.53.0.tar.bz2
Apr 4 20:07:06 dwarf kernel: b43-phy0 ERROR:
Use this b43-fwcutter tarball: http://bu3sch.de/b43/fwcutter/b43-fwcutter-009.tar.bz2
Apr 4 20:07:06 dwarf kernel: b43-phy0 ERROR: Read, understand and _do_ what this message says, please.

Unpack the b43-fwcutter and call make. Execute ./b43-fwcutter ../broadcom-wl-4.80.53.0/kmod/wl_apsta.o, remove any existing firmware in /lib/firmware/b43/ and replace it with the content created by b43-fwcutter.
Reboot to load the updated firmware into the kernel and your amber wireless light will flash blue. sudo iwlist scan then shows the available access points and network-manager is able to connect without problems.
I'm posting this from the HP laptop over wireless.
Summary: this laptop should be eminently supportable in Lenny
After all my doubts and all the hassle, providing you use 'noapic nolapic' and the support of the Debian-Installer for Lenny.

Manoj Srivastava: Manoj: Schemes for packaging using Git: An analysis

Are you rebasing or merging? seems to be the 64 thousand dollar question over in vcs-pkg discussions. Various people have offered their preferences, and indeed, several case studies of work flows have been presented, what is lacking is an analysis of the work-flow; an exploration of which methodology has advantages, and whether there are scenarios in which the other work flow would have been better. Oh, what are all these work flows about, you ask? Most of the issues with packaging software for distributions have a few things in common: there is a mainline or upstream source of development. There are zero or more independent lines of development or ongoing bug fixes that are to be managed. And then there is the tree from which the distribution package is to be built. All this talk about packaging software work flows is how to best manage asynchronous development upstream and in the independent lines of development, and how to create a coherent, debuggable, integrated tree from which to build the distributions package. The rebasing question goes to the heart of how to handle the independent lines of development using git; since these lines of development are based off the main line of development, and must be periodically synchronized. Here is a first look at a couple of important factors that will have bearing on that question, and packaging software for a distribution using Git in general. This is heavily geared towards git (nothing else does rebases so easily, I think), but some of the concepts should be generic. I am not considering the stacked set of quilt patches source controlled with Git in this article (I don t understand that model well enough to do an analysis) As a teaser, there is a third answer: neither. You can just add an independent line of development, and just let it sit: don t rebase, and don t merge; and in some circumstances that is a winning strategy.

Julian Andres Klode: debimg 0.0.3 - the checksum - released


Dear readers, The third release of debimg is available now: 0.0.3 Get the tarball: http://alioth.debian.org/~jak-guest/debimg_0.0.3.tar.gz
Verify it: http://alioth.debian.org/~jak-guest/debimg_0.0.3.tar.gz.asc
The ChangeLog: http://alioth.debian.org/~jak-guest/ChangeLog-0.0.3 Clone git repo: git://git.debian.org/git/users/jak-guest/debimg.git
Browse the repo: http://git.debian.org/?p=users/jak-guest/debimg.git More Information: http://wiki.debian.org/DebImg
Daily images: http://jak-linux.org/cdimage/daily-builds/testing/
    About debimg debimg is a software designed to replace debian-cd, written in Python, and
    supporting the creation of single disks for the i386 and amd64 architectures. debimg is of course free software and licensed under the terms of the GNU
    General Public License 3 or (at your option) any later version. About “the checksum” This release is called “the checksum”, because the software knows
    the MD5SUM, SHA1SUM and SHA256SUM of every file on the disk. News
    • Introduction of the media module
      • Add md5sum.txt and sha1sum.txt to the image
      • NEW OPTION: JigdoMap, see the config file
      • Lot of code cleanup
    • Support for custom installer images
      • Modify InstallerImages to an url supported by apt
    • Renamed most options in the configuration file for better
      readability
    • debimg requires Python 2.5, as it uses the with statement.
    Description of the Release This release of debimg introduces the media module with its classes
    MediaFile, BaseMedia and DebianMedia. The MediaFile class contains information about a file.
    It contains the absolute path to the file on the filesystem,
    the path on the media, its size, md5sum, sha1sum and sha256sum. The BaseMedia class provides methods to add files to the
    image, open files on it, and creating the final image. It also
    provides methods to create the files md5sum.txt and sha1sum.txt,
    and methods to support Jigdo file creation. The DebianMedia class provides methods to add packages to
    the image, creating Release and Packages files for dists. Quick start To get started with debimg, get the tarball and extract it to
    some directory. Now, open the file debimg.cfg and change the option Mirror to the URL
    of your preferred mirror. This mirror may be any kind of mirror supported by
    apt, but if you use file:/ they have to be on the same mountpoint, as the files
    are hardlinked. (use copy:/ to get them copied). Now, run ./debimg debimg.cfg. This will create an ISO image named
    debian-lenny-i386-netinst.iso. This image is a normal netinst (except for
    missing documentation and some other small things), and contains the Lenny d-i. To change more settings, take a look at debimg.cfg. Future
    • Cleanup of the configuration format (almost finished)
    • Support for splitting disks
      • Introduction of MediaSet class
      • Changes to the lists required
    • Add documentation to the disks
    • Support for PowerPC
    • Create Debian package (almost finished)
    Another interesting feature will be the libisofs [0] support provided by
    the python-libisofs extension, which is currently under development. [1] Previous release announcements Links

    Michal Čihař: phpMyAdmin is in Summer of Code

    Well not directly, but MySQL is and they will also accept our projects. So if you are student interested in getting some money for improving free software, you're welcome to contact us. We have written down our ideas to wiki, but feel free to come with your own thought. But don't forget that deadline is this Monday! While talking about this improving phpMyAdmin, phpMyAdmin team would also like to take part in Hackontest, so vote and suggest there features for us! If you have no idea for phpMyAdmin, Debian is also taking part there ;-).

    William Pitcock: Litigation vs. Innovation - further reflection on the state of SCO UnixWare, and what it could have been

    In my previous satire about SCO UnixWare, some SCO people of course didn’t think it was very nice. So, I guess I need to explain more about why I wrote the “review” the way I did. But, first the comment: SCO comments back! Obviously any human being can recognize satire. There is obvious motivation on behalf of SCO’s PR department (correct me if I am wrong on where this comment originated; I did just some basic Google lookups, and also, this is a PR tactic known as “dead agenting”) to ignore the fact that this was clearly a satirical review. I would say, “perhaps SCO doesn’t understand why it is criticized,” but I believe it is obvious that they know why people are being critical and satirical of their company and their efforts. I would like for everyone to think, for a moment, about how things could be if SCO didn’t take the litigious strategy that they have taken over the past 6 years. SCO UnixWare could have remained a successful product, and could have in reality become a major asset to the open source world. SCO could have been the good guys here, but instead they chose a path of litigation instead of innovation. In the Open Source and Free Software world, innovation is what is seen as important. Companies may be in some sense rival to each other, but when it comes down to it, everyone appreciates and respects the work that everyone else contributes to the ecosystem. When people do not contribute in a positive way, or worse, betray their peers like SCO has done, it opens them up for criticism. As I see the situation, I think that SCO’s current tactics as a company represent those of someone who is paranoid. People who are paranoid attack first, instead of defend their position. So, while I am sure this is a pointless question, I believe it must be asked anyway: “What would SCO UnixWare have been like if they did not take a litigious strategy against Linux users?” If you look at it like this, it doesn’t really matter if we’re right, or SCO is right on who has the basic cases (well, it does, but we all know how that’s going to come out anyway). Why does SCO keep pursuing a strategy of litigation when the feasibility of this strategy is at best, unknown? To some extent, I think it is now a matter of morale. After all, it’s bad if you have to admit that the strategy you have taken for the last six years, was wrong. In some ways, you could say that SCO’s current strategy is cult-like. Furthermore, if any SCO people are interested in doing an interview about this whole matter, I encourage you to comment back, and I’ll be happy to publicize SCO’s viewpoint of this. It’s only fair.

    William Pitcock: Fun with GoDaddy

    Today I woke up and found that nenolod.net expired. What? I hadn’t even received any expiration notifications from them. So, I immediately renewed and transferred to another registrar, and they sent me an e-mail with some hilarious excerpts begging me to stay with them:
    GoDaddy.com, Inc. delivers superior value. Here’s how: 1. Guaranteed renewal price
    2. Risk-free, money-back guarantee transfers
    3. More FREE, value-added services with every domain
    4. Consistently lower prices
    5. Best-in-industry live customer support, 24/7
    6. Fast, easy bulk domain transfers and registrations
    7. Just-right, affordable hosting options
    8. Superior domain search and management tools
    9. Fierce protection of your personal information
    10. Unique, valuable and innovative software and services
    I’m not sure why I need any of these in a domain registrar. After all, it’s just a domain. I don’t think I will be missing these guys much. So if anyone was trying to send me mail and it didn’t go through, sorry about that.

    John Goerzen: Pennsylvania and Irrelevance

    NPR has been doing an interesting series this week. They've sent out a reporter who is going all across Pennsylvania interviewing people at local food markets. He found a fish shop in Pittsburgh, a market in Lancaster, and some shops in Philadelphia. He sought out Democratic voters to ask them about their thoughts on Clinton vs. Obama.

    A lot of the Pennsylvania voters were for Clinton. When asked why, most of them said that they liked Bill Clinton and his policies. A few said they liked how Hillary handled the Lewinsky affair. To me, none of that has anything to do with whether Clinton or Obama would be better for the country.

    Then there was the person this morning who was criticizing Obama for not offering specifics. She said she is Jewish, and so Israel is important to her, and Obama hasn't said anything about helping along the peace process. So I went to barackobama.com, clicked Enter the Site, went to Issues, Foreign Policy, then Israel. Then I clicked on the full fact sheet, which was a full 2 pages on Israel, including far more detail than the voter said she wanted.

    I often wonder about these people that say Obama doesn't have specifics. Just because each speech doesn't read off a whole lot of information doesn't mean that he doesn't have it -- it's all there on the website. I'm sure people that don't have Internet access could call the Obama campaign and get information, too. It seems Obama ought to do a better job of mentioning this fact at every possible opportunity.

    Then I hear a lot of Clinton supporters saying that since Clinton has won states like Ohio in the primaries, she'd do better there in the general election. I think that is a totally facetious argument. Just because Clinton did better with Democrats doesn't mean that she'd do better in the general election. We can generally assume that the Democratic voters will vote for the Democratic nominee, whoever it is. The question is how many independents and Republicans a person can win over.

    MJ Ray: Tour of Britain launch notes

    ToB Taunton Banner The Tour of Britain organisers emailed me to announce their launch. The race this year will be 7th - 14th September (starting stage 2 in my old stomping grounds of MK and finishing stage 3 in Burnham on Sea, the next town south from my home) and they announce daily coverage on itv4
    on their front page. Well done ToB and itv! That should be a vast improvement on the 2 hours on the last day that BBC were giving it, although I expect it’s highlights rather than live.

    Martin F. Krafft: Document management system sought

    A client of mine seeks a document management system to be run on a Linux machine, and I have no experience in this domain. I am turning to you for help, dear lazyweb, my client will make a donation to a FLOSS project of your choosing in return. I define document management system as an online file storage for OpenOffice.org/Word documents, spreadsheets, PDFs, and pictures. Thus, this is less about content management than about file storage and organisation, aimed at collaboration. The following are the sought features: Do you know of any tool we could deploy? I did come across BFExplorer, but that seems to lack support for tags, direct data access, bulk uploads, multiuser environment, and it s not received updates in more than a year. Suggestions welcome! NP: Pulp: Freaks

    3 April 2008

    Runa Sandvik: Fancy titles are for jazz musicians

    An email saying that Nectarine now has three, new dedicated streams for music is not spam, and it never will be. You can now find one stream for chiptunes, one for oldskool songs, and one for songs only included in a demoscene production. And yes, this is the right time to sign up for Solskogen 2008.

    Steve Kemp: It's just a puzzle box!

    Chronicle
    I've made a new release of the chronicle blog compiler, primarily to allow the "Subject:" header to be used for new blog subjects. (That allows new entries to be automatically posted via email, with an appropriate procmail setup. I'll add one as an example shortly.)
    RSS Utility
    Whilst on the subject of RSS creation (huh?) I've written a tiny utility which will create an RSS feed from a list of text files. It will also create an index.html file to match. To see why this is useful you could view my recent changelog. I think there is a need for a small tool to read files and create feeds from them - like mod_index_rss does, but without messing with Apache. If there is any interest I'd be happy to release the code, as-is it doesn't use a template..
    Anonymous Hosting?
    Online privacy is important. Mostly when this is discussed it is in the context of client-side anonymity. Looking at it from the other side, though, How do you host a website anonymously? You could register the domain via a proxy, or with bogus details. But if you host the site yourself the IP address may be traced to the hosting provider, and that may be used to trace back to you. So, the alternatives? Well you could use a hosted site such as livejournal / wordpress / googlepages / etc. But pretty surely they'll be able to trace content back to you - and if you don't host it there's a high chance they'll just pull it if you talk about "bad things". (I guess you could use TOR for uploading / your connections there.) So, going back to the question. How can you host something, easily accessible to the world, without risk of your identity/association being discovered?
    I'm, obviously, ignoring FreeNet. Two reasons for that:
    • It's slow, has no search-engine goodness, and is unproven.
    • It requires an atypical client. Aunt Milly won't be able to surf Freenet...
    I almost think the best way forward would be to write a site which was a proxy for a file-sharing protocol, then link people to items that way. Relying on the swarm to host the files.. The downside is that you'd have to have a convincing argument for when RIAA comes calling, suggesting that you're sharing their stuff too. If it wasn't a general purpose proxy then the deniability is gone, and if it is you're at risk of general copyright infringement claims. Hard problem. Shame.
    ObQuote: HellRaiser

    Alastair McKinstry: OOXML: Time to defend standards

    After the April fools joke that wasn't, the hangovers have cleared and OOXML has passed. Unless it is successfully appealed, it will become standard in 2 months. Thankfully, it is being appealed. If you can, lobby your national standards authority to appeal and stop this. All around the blogosphere, people have been slating ISO for passing this. While a lot of irregularities happened to pass it, for which the ISO should be ashamed, we need to be aware of one thing: ISO is on the good side, folks: we want standards. Most people who are involved in ISO, want good standards. Microsoft don't. Those on ISO committees felt worldly wise about corporate lobbying: they'd seen it before. They were used to companies lobbying them to rubberstamp their technology as an international standard. But Microsoft were playing a different game. They don't want standards. They already have their monopoly. They don't even want their formats to be standarised. They want to be able to change them every release, and force another sale of Office 2010,etc. What they want to do is trash the idea of standards, and they're succeeding. ISO was used to being the battleground, the referee. Instead it was the target, and didn't know how to cope. This battle is like the Celts fighting the Romans. Used to cattle-raids-as-warfare, they hole up and defend themselves when the Romans come marching in, and expect the Romans to give up in a day or two when their 'cattle raid' fails. Instead the Romans dig in for the long siege, and win, while the Celts look on puzzled, and lose. We need to retake ISO and defend it. I set up the iso-codes project within Debian several years ago to minimize the number of country and language lists out there. Now with OOXML it appears we have to also track the Microsoft list, and incompatabilities, as OOXML requires it. Ditto with DrawingML instead of SVG, and a wholew host of other standards. Standards committee work is hard and boring. But if we don't get involved theres a lot of boring coding ahead, just tracking Microsoft. Time to join the National standards committees, somehow. Or should we lobby ISO to join as an international body? Tags , , ,

    David Pashley: InnoDB being silently disabled

    Regular viewers will know that I don't think favourably of MySQL. Here is yet another reason. Let's create an InnoDB table:
    mysql> CREATE TABLE  User_  (
    mysql> ...
    mysql> ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
    Query OK, 0 rows affected, 1 warning (0.04 sec) 
    One warning, but we're running this as part of an import, so we'll fail to spot this and even if we did, we wouldn't be able to get it back out of mysql because SHOW WARNINGS only shows the last command. So let's look at the table we just created:
    mysql> show create table User_\G
    *************************** 1. row ***************************
           Table: User_
    Create Table: CREATE TABLE  User_  (
    ...
    ) ENGINE=MyISAM DEFAULT CHARSET=latin1
    1 row in set (0.00 sec)
    
    Eh? what's going on? We asked for InnoDB, but have got a MyISAM table. Lets look at the engines available.
    mysql> show engines;
    +------------+----------+----------------------------------------------------------------+
      Engine       Support    Comment                                                         
    +------------+----------+----------------------------------------------------------------+
      MyISAM       DEFAULT    Default engine as of MySQL 3.23 with great performance           
      MEMORY       YES        Hash based, stored in memory, useful for temporary tables        
      InnoDB       DISABLED   Supports transactions, row-level locking, and foreign keys       
      BerkeleyDB   NO         Supports transactions and page-level locking                     
      BLACKHOLE    NO         /dev/null storage engine (anything you write to it disappears)   
      EXAMPLE      NO         Example storage engine                                           
      ARCHIVE      YES        Archive storage engine                                           
      CSV          YES        CSV storage engine                                               
      ndbcluster   DISABLED   Clustered, fault-tolerant, memory-based tables                   
      FEDERATED    YES        Federated MySQL storage engine                                   
      MRG_MYISAM   YES        Collection of identical MyISAM tables                            
      ISAM         NO         Obsolete storage engine                                          
    +------------+----------+----------------------------------------------------------------+
    12 rows in set (0.00 sec)
    Oh, so innodb has been disabled. We can fix that easily by removing skip-innodb from my.cnf.
    root@cmsdb01:/var/log# grep skip-innodb /etc/mysql/my.cnf
    root@cmsdb01:/var/log#
    But hang on a second, that's not in the config file. What's going on? It turns out that the reason InnoDB is disabled is because of the innodb_log_file_size setting not matching the files on disk.
    root@cmsdb01:/var/log# grep innodb_log_file_size /etc/mysql/my.cnf
    innodb_log_file_size            = 512M
    root@cmsdb01:/var/log# ls -lh /var/lib/mysql/ib_logfile*
    -rw-rw---- 1 mysql mysql 5.0M 2006-12-19 18:39 /var/lib/mysql/ib_logfile0
    -rw-rw---- 1 mysql mysql 5.0M 2006-12-19 18:39 /var/lib/mysql/ib_logfile1
    
    Rumour has it that you can just stop MySQL, delete these log files and start MySQL again. I'm yet to try this as the server in question is in production use. The alternative is to change the innodb_log_file_size setting to match the file. So in summary the problems with MySQL are:
    • Not logging warnings anywhere useful.
    • Converting engine types with a warning rather than throwing an error. This can be fixed by setting sql_mode to include NO_ENGINE_SUBSTITUTION.
    • Starting up and disabling InnoDB when there is a problem rather than failing to start, giving a false impression that everything is working.
    MySQL has not impressed me this week.
    Read Comments (3)

    Stefano Zacchiroli: moving well moved

    /me has moved to Paris Well, this is not really an "I'm moving" post, but rather a "I've moved" post: starting from past Tuesday I'm now living in Paris. I will be working as a post-doc in the mancoosi project, which is a wonderful occasion to merge my research work with my free software enthusiasm. I've also submitted a talk proposal about mancoosi for DebConf8, ... it will be a good occasion to chat about it if you are interested. My office is in the PPS lab, which was already quite packed of Debianers, /me is just one more, happy to join the crowd! The first day of shopping in Paris forces me to post a picture on the very same lines of Enrico's "how to freak out a French person". Mine below can be titled how to freak out an inhabitant of Modena: fake balsamic vinegar Here you are: balsamic vinegar flavoured with figs or honey ..., tasty eh? (dedicated to gareuselesinge) PS unfortunately at home I'm still without network connectivity (unless you count poorly working, up 1 random hour per day, stolen wi-fi as connectivity), so I won't be able to work on Debian et al. a lot from home in the next few weeks.

    Next.

    Previous.