GNU-Linux

Two and a half wasted hours trying to set up a test environment so I could develop offline.

Couldn't import the database file:

SQL query:

/*!40000 ALTER TABLE `access` DISABLE KEYS */;

MySQL said: Documentation
#1065 - Query was empty

Don't get that at all.

Couldn't get NetInfo manager to make wsf2008.site point to anything MAMP could recognize.

No more trying to work without the internet.

DAMN!

Resolution

http://svnbook.red-bean.com/en/1.0/re09.html

Resolution

Dirty secret is this will work with Windows or anything else that runs MySQL, as well as the recommended Debian, Ubuntu, Red Hat / RHEL (which is what CentOS really is) etc.

mysql -u root -p

(The long form, which is quite unnecessary, is " mysql --user=user-name --password=your-password")

Once in the MySQL command line utility:

SHOW DATABASES;

Then to see what's in a particular database:

USE agaric_example
SHOW TABLES;

Setting up a new site into Agaric's system.

Some standard new site stuff

ben@server:/var/www/drupal-5_3-live/profiles$ sudo svn co file:///srv/svn/agaric/agaric-profiles/agaric_recipes agaric_recipes

[and a bunch of similar checkouts I failed to record]
[Including for the site itself into the sites/ directory]

Note: the agaric installation profile hit an error on a call to a token module function, but seemed to do everything anyway.

I still think the first thing to try is Boost is the first step to take.

I think it will cache the javascript needed to call and run the maps. And Language switching is done via the URL so that will work with a static HTML-ized site for anonymous users.

However, here's a recent approach to phased scaling with Drupal that makes a good start for WSF. We should stop short of database replication I think.

MySQL Binary Logs of Death (er, I mean, "on Debian")

This guy (a man very much after my own heart, he started logging this problem of a full root partition before he had a solution) had the same problem, but didn't seem to think it was a problem:
MySQL binary log space (Debian) 10/15/07
http://fplanque.com/dev/linux/mysql-binary-log-space-debian

We need to keep track of our own modules.

Here's a plan:

• Keep using trunk for development, with all the modules checked into it.
• More importantly, use another directory for stable. We repeatedly tag/branch (same thing in SVN I think) out to stable, and stable can be directly checked out into an agaric directory within sites/all/modules.

Supposedly we can also check our modules in development directly to sites/specific/modules if we need to
use our modules before surely stable.

UPDATE: Short and sweet the error and the fix (on Ubuntu, at least) with none of the jibber-jabber below.

ben@ebony-ubuntu:~/code/anjali/drupal$ drush updatecode

Fatal error: Allowed memory size of 33554432 bytes exhausted (tried to allocate 122880 bytes) in /home/ben/code/anjali/drupal/sites/all/modules/quiz/quiz.module on line 677
Drush command could not be completed. [error]

Start editing the command line php configuration (initialization) file with:
sudo vi /etc/php5/cli/php.ini

updating the big D.O:

killes
:
hunmonk: actually, make it: take down site, , clear sessions, dump db

(don't clear your own session, apparently)

Resolution

connecting to a server that does security by IP address

Both
http://whatismyipaddress.com/staticpages/index.php/lookup-ip
and
http://www.lawrencegoetz.com/programs/ipinfo/

Gave the same answer.