Rss Feed

  1. lighttpd and WordPress

    8 June 2011 by admin

    By default, lighttpd will not support your WordPress installation and it won’t give you any information about why not. It’s a total pain but here’s how to get it up and running.

    lighttpd.conf
    Make sure “mod_fastcgi” is enabled in the server.modules section.
    Make sure you have the following lines:

    fastcgi.server = ( “.php” => ((
    “bin-path” => “/usr/bin/php-cgi”,
    “socket” => “/tmp/php.socket”,
    “max-procs” => 2,
    “bin-environment” => (
    “PHP_FCGI_CHILDREN” => “16″,
    “PHP_FCGI_MAX_REQUESTS” => “10000″
    ),
    “bin-copy-environment” => (
    “PATH”, “SHELL”, “USER”
    ),
    “broken-scriptfilename” => “enable”
    )))

    You may need to change some things around for your environment. Restart lighttpd and make sure it’s still working.
    Try reloading your WordPress site, for example and you’ll likely see Your PHP installation appears to be missing the MySQL extension which is required by WordPress.
    You can solve this one of a number of ways. I just ran sudo apt-get install php5-mysql.
    Restart lighttpd.
    Assuming you have the correct database credentials, you should now be good to go. :-) .

    Category Uncategorized | Tags: ,,, | No Comments

  2. MyISAM table corruption causes

    31 October 2010 by admin

    Even though the MyISAM table format is very reliable (all changes to a table made by an SQL statement are written before the statement returns), you can still get corrupted tables if any of the following events occur:

    * The mysqld process is killed in the middle of a write.
    * An unexpected computer shutdown occurs (for example, the computer is turned off).
    * Hardware failures.
    * You are using an external program (such as myisamchk) to modify a table that is being modified by the server at the same time.
    * A software bug in the MySQL or MyISAM code.

    MySQL has some additional documentation on this topic.

    Category Uncategorized | Tags: | No Comments

  3. Remembering OSI Layers

    18 June 2010 by admin

    All people seem to need data processing

    Application
    Presentation
    Session
    Transport
    Network
    Data link
    Physical

    Category Uncategorized | Tags: ,,,,,,,,, | No Comments

  4. Forgotten MySQL Root Password

    by admin

    It happens to the best of us all the time. (Three times in a 24-hour period is my record…) On my Ubuntu VPSs, this is what I do when that happens:

    $-> /etc/init.d/mysql stop
    $-> mysqld_safe --skip-grant-tables &
    $-> mysql -u root

    Use the ‘msyql’ database to issue this query:
    UPDATE user set password=PASSWORD("ice_cream") where User='root';
    Flush privs and then stop and start MySQL (normally).

    Category Uncategorized | Tags: ,,,,,, | No Comments

  5. Is MySQL OK?

    by admin

    There are always many ways to skin a cat but here’s a neat way to check on MySQL:

    root@aleida:/home/aleida# mysqladmin -p ping
    Enter password:
    mysqld is alive

    Kinda neat, no?

    Category Uncategorized | Tags: ,,,, | No Comments