Search Results: "tar"

8 April 2008

Michael Prokop: Re: I am only mad on IRC

Martin, sorry for calling you Madduck on the debian.ch-mailinglist. Luckily I didn’t use that name during our meeting in Zurich last week. *pfuh* ;) To take part in the pdo-game with my own name (being Michael Prokop ;-)): as many of you might know I’m known as Mika in the community. The name was invented for me around 1999 (IIRC) by a greek flat collegue who liked to call me “Mika” - refering to Mika H kkinen (for whatever reason). From that on several people started to call me that way. I’m signing mails “to the community” with that nick since many years as well as using it in usenet and on freenode (IRC); on OFTC (another IRC network) I’ve to use mikap instead because mika was registered by another user already. Outside “the community” I’m usually known as Michael, good friends also use Michi and the family of my girlfriend uses Michl when the sister of my girlfriend (named Michaela and known as Michi as well) is present. Oh, and during grammar school I was AKA Proke.</secret> 8-) So calling me Mika is perfectly fine because it’s a kind of uniqueness for me. There might be just too many Michaels around and at least in Austria my nickname is everything but common. Quoting the marketing department: Great trademark! ;) Oh and my speech parser knows to handle Michael, Michi and Michl as well - though it strongly depends on the situation, place, environment,…. Oh but using Proke is like talking to /dev/null - you’ve never heard of that name, ok?

Kartik Mistry: Late report: fossmeet@NITC, Calicut


* With uncertainty principle playing in full form with me, I decided to go to Fossmeet@NITC. But, came to know that there is no bus tickets available! What to do? I called up dear tuxmaniac aka Aanjhan and he suggested me to go by taxi. wow. Pretty expensive it will be, I thought. What ever, we decided to go with burning (hip) pockets and the journey was terrible. I did such long travel (7 hours) in taxi after long time. Anyway, we reached at NITC around 6 AM. The Keralian atmosphere was excellent and I felt similar humidity like Mumbai and that made me a bit sad. Ah. The event was already kicked off the day before and I attended Praveen’s talk on openid while figuring out that wifi is not working for us (proxy and they didn’t care to let us know password etc). So, we headed towards lab and enjoyed some Internet while seating in ‘Foss for school children’ workshop. Lunch was ok, but I enjoyed talking with different people and it was nice talk with Ani Peter about current localization work from Redhat. These guys simply rocks! Got my conference tshirt before ‘Medium’ size is out-of-stock. We were eagerly waiting for our dear Pradeepto, and voila, he came and started his talk! I was attending his talk first time (always missed due to some or other reasons..). Excellent and interactive. No slides. /me need to learn something from this fellow! We were 100% tired at evening. So, first we changed to better ‘room’. Thanks to NITC co-coordinators who did quick action for this (Why we requested for changing room? Answer: The previous room had only one power-supply plug! and we want to do hacking at night!). We then headed towards ‘Malabar Palace’. Excellent South Indian food and beer. The next day — I was suppose to give talk on ‘Contributing to Debian’ but by some magic, the talk was disappeared from schedule. Sad. Anyway, we (me, tuxmaniac and pradeepto) gave live talk on ‘How to contribute to free software’. We used SVN, Bugzilla, Wiki, SF.Net and other tools (IRC!) to show how students can use these in college projects and make it much better and how it can lead to Free Software development. I did svn commit for KDE Gujarati (Idea stoled from Rusty’s talk at Foss.in/2007). We then decided to leave the place. The return trip was amazing. Pookat lake and Mysore Palace. Amazing places. We had nice dinner and Kamat Hotel and I bought one wood penguin too (Total number of Penguin toys=4, Now). I learned that Calicut is also known as Kozikode :)

7 April 2008

Adam Rosi-Kessel: How to be a superstar associate

I do very little law-firm-life blogging here, although that life is where I spend the overwhelming majority of my time. Consider Real Lawyers Have Blogs (something of a misnomer — they mean real firms have blogs). Counterpoint: Be Careful What You Post (motion to amend to assert defamation counterclaim against new defendant for comment on blog entry granted). In any event, in case I have any law firm associate readers, I’ll send props to the ABA’s free Litigation Podcast. It has a high signal to noise ratio, and the episodes are usually short enough to complete in my walk to and from the train. I’d like to draw attention to the latest post (”cast?”), The Secrets of Superstar Associates (21.1 MB MP3). Although on some level the advice should seem obvious, the “rules of the game” are seldom spelled out so clearly. I recommend it to any law students looking to join a firm and junior associates as well. In fact, even if you’re not a lawyer, much of the advice is transferable to surviving in any highly-skilled-professional organization. Technorati Tags: , , ,

6 April 2008

Mike Hommey: WebKit on the rocks

I’m preparing a new upload for WebKit, which will be targetted at unstable. It is much easier to deal with than Gecko, fortunately, so it won’t take several months to get something in shape. The main “difficulties” here is that I’m dropping the Qt WebKit package, since this will be provided along Qt, and the upstream build system for the Gtk port switched from qmake to autotools, which is not a really bad thing ; so, nothing impossible. Note that switching to autotools also means using libtool, which means no way to use -Wl,–as-needed anymore :-/. Yes, libtool, by trying to be smart, puts it almost at the last position in the arguments list, making it useless. ACID3 in new GtkLauncher

Andreas Metzler: snowboarding season 07/08

Today was the last day the local ski resorts were open. I had a rather strange last day with a lot of freshly fallen snow, running off-piste almost the whole day. Following up on previous entries here is my balance sheet:
2005/062006/072007/08
number of (partial) days251729
Damüls10105
Diedamskopf15424
Warth/Schröcken030
total meters of altitude12463474096219936
highscore10247m8321m12108m
# of runs309189503
New highscore! Still puny, compared to what other people manage on one day. I doubt it is possible to do 24500m (81000 ft) in the local resorts, you would need steeper slopes for that. ;-) Weather/climate was strange. We had an early first snow in the middle of November (about 60cm). Up to start of march no big snowfall followed, but we had (basically the same) snow continuously even down in the valley. Then there was some thawing, and finally more snow. Now that the ski resorts are closing they probably have got more snow up on the mountain than ever this season.

5 April 2008

Yves-Alexis Perez: Xfce battery plugin broken?

Using Xfce on your laptop running Debian? The battery plugin is unusable? Don't panic, we're aware of this. Basically, the situation is a mess, for some reasons: There is an open bug in Debian and in Xfce where we track the situation. Somebody proposed on the Xfce bug a patch to enable sysfs support on the battery plugin, and we integrated this patch on Debian (starting 0.5.0-3), but the patch is not really good, as it hardcodes too many things, and especially the directory names (it uses AC and BAT* while some people are know to have ACAD). So with the sysfs patch included, the plugin doesn't work at all on some users's config. The next plan is to remove this sysfs patch and revert to procfs, until we know better how everything will be in Lenny. In the meantime, Nick Schermer is hacking on a hal based branch of the battery plugin. I'm currently running it daily, and it works fine. Nearly all the low-level work is let to hal, and the battery plugin only takes care of the display, in Xfce panel. This is nice, but add a dependency on hald for the battery plugin, wich is something some user may not want. At first, I thought it would be better to release Lenny with 0.5.0 battery plugin and only after switch to the hal based one, and add the hald dep, especially since the plugin is still kind of experimental. But seeing the mess it is currently, we may have to switch before, and sooner than we thought. [EDIT]: xfce4-battery-plugin_0.5.0-6 was just ACCEPTED. It contains a fixed sysfs patch which fixes the “hardcode” problem. Thanks to Daniel Gibson!

Norbert Tretkowski: MySQL plugins in Debian

MySQL 5.1 and up supports a plugin interface that allows the loading and unloading of server components at runtime, without restarting the server. Today I started working on a mysql-storage-engines package for MySQL 5.1 in Debian, which includes the PrimeBase XT and Sphinx storage engines. I currently don't plan to create separate binary packages (like mysql-engine-pbxt and mysql-engine-sphinx) for every single plugin.

Suggestions for additional plugins which should be added are welcome.

Daniel Burrows: aptitude 0.4.11.1 released

Last weekend, I released version 0.4.11.1 of the aptitude package manager (release notes). This is a minor release focusing mostly on bug-fixes and on a few features that I've been meaning to add but that didn't make it into 0.4.11. I think the most interesting addition is --show-why, which is like --show-deps but traces back to the closest manually installed package. In some wide-character locales, the fix for bug #472625 in this upload of aptitude triggers bug #473874 and bug #474065 in apt; the symptoms are an error message about line N too long (max 1024) on start-up, and messages saying that method http has died unexpectedly! when you try to update the package lists or install new packages. I've written patches to fix these bugs in apt, and once they're reviewed by the other apt maintainers they should be fixed in the next upload of apt (version 0.7.12). Until then, if you're bitten by this bug, you can work around it by diverting /usr/share/aptitude/aptitude-defaults.$LANG and replacing it with an empty file. For instance, for Russian (ru):
 # dpkg-divert --rename --local --divert /usr/share/aptitude/aptitude-defaults.ru.real --add /usr/share/aptitude/aptitude-defaults.ru
 # echo > /usr/share/aptitude/aptitude-defaults.ru
Once a fixed apt is uploaded, you can remove the diversion like this:
 # rm /usr/share/aptitude/aptitude-defaults.ru
 # dpkg-divert --rename --local --remove /usr/share/aptitude/aptitude-defaults.ru

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.

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.

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

    Bdale Garbee: sdcc and git

    I've been using git for a while, like it a lot, and finally decided it's time to move all my Debian packaging work over from CVS. After a frustrating few hours trying, I gave up on trying to use git-cvsimport. It generates mangled repositories even for simple packages like sudo. The git-import-dsc tool in the git-buildpackage package works fine as far it goes, but I'd really like to preserve my history. So, after some consultation on IRC, I took a look at parsecvs. It didn't quite work out of the box, either, but looks promising, and the author showed an immediate interest in the problems I'm having and offered to help. So, perhaps I'll be able to use it before long... In the meantime, a while back I offered to help Gudjon I. Gudjonsson restructure the sdcc packages so that a DFSG compliant version can return to main with a full version under a different package name going in non-free. This is all necessary because some of the assemblers provided in the package have a non-commercial use clause in the license, and there are also license issues with the HTML documentation. I care about this because sdcc is a build dependency for gnuradio, which I maintain for Debian (it uses the 8051 toolchain to build downloadable code for the USRP, etc). While waiting for parsecvs to get some love and attention, I sat down this evening to restructure sdcc and move it to git. I'm pretty happy with my progress so far, though there's a bit left to do before uploads happen. Gudjon and I decided to use the collab-maint facilities on alioth.debian.org for collaboration, which took me a little head-scratching to figure out, but looks like a perfect fit for our needs. I updated the wiki page about Git on Alioth with a few of my learnings as I went through the process. Using git branching to handle non-DFSG-compliant upstream sources is pretty obvious, the notes in the git-buildpackage documentation helped. Using pristine-tar to capture the deltas required to regenerate orig.tar.gz files from the git repo is amazingly cool. It's hard to believe how much friendlier the world seems when you don't have to drag a bunch of tarballs around with you to do useful work! And git-buildpackage has suitable options to make using it pretty automatic. Great stuff! It's likely to be a few days before I can get back to this, finish up, and upload the results of this restructuring work. In the meantime, I'm writing this entry largely to offer my compliments to everyone involved in making git-buildpackage, alioth, and collab-maint work so well. Special thanks to Joey Hess, whose pristine-tar package is another in a long line of absolutely brilliant tools that contribute to making my life easier! I'm going to end up using it a lot.

    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.

    3 April 2008

    Raphael Geissert: OOXML, an ISO standard?



    (image found at www.noooxml.org/start)

    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.

    Joachim Breitner: Distance Map Morpher

    In my last blog entry, I was asking for algorithms to morph a picture so that contour lines would become circles. I then started to write some python/gtk/cairo code to actually visualize my thought. It came out relatively pretty, so I made the GUI around it usable (although far from nice, I guess) and put the current, early version in a darcs repostory (DarcsWeb browser available).
    This is a screenshot (click for full version) of a map of my part of town, shamlessly stolen off the internet. The red shading shows the distance from the thick point of the graph the redder, the closer. On the right the image is morphed so that all points on a circle around the center have the same distance to it. The blue shape on the left and the blue circle on the right are points with distance 205.Below the user canCurrently, there is one algorithm to determine the distance of a point to the center: Travel along the graph to the most suitable edge, leave at the point closest to the target and then go crossroads , which comes at a greater cost.There are some things to do, most notable:Comments and patches are, as always, welcome. If you want to try it out make sure you have python2.5, pygtk and numeric-python installed.

    Vincent Fourmond: mk-build-deps: create a dummy package depending on a package's build-deps

    When I work on a package, I often find that I want to have build-deps installed in a way that I remember why I did install them in the first place. apt-get build-dep is not a proper solution for me for two reasons: As I'm starting to work on vegastrike, who's in great need of tender care, I though time had to find a more decent solution. The answer is mk-build-deps, a small Perl script that takes a control file or a package name and uses equivs to create a dummy package depending on its build-deps. Pretty useful (for me at least). Maybe it would be worth including in the devscipts package ?

    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)

    Next.

    Previous.