Making stuff better: the Agaric way
Agaric Design Collective uses the power of open source free software, the internet, and people to build sites that give control to our clients and their communities.
We build individual, organization, and business sites. Our passions are for community-driven sites, democratic communication in the service of human coordination, and great design.
A full service branding and web presence company, we also provide hosting on our dedicated servers, training, and brochure and business card design. Our core offerings, custom development, and consulting are based on the state-of-the-art content management framework Drupal.
Our founding principles include the goal of helping all people gain the most power possible over their own lives. We apply this to our work and build online applications that our clients can easily update and expand on their own. Agaric Design proudly uses world-class open source free software that means freedom from lock-in and always keeps our clients in control.
Thank you for visiting our site, which we will continue to improve on the rare occasions we can take time from working for you!
Making stuff better: the Agaric way.
Ask Agaric
Dev Talk
Theming
Notable Blogs
Featured Content
Apache access control the Agaric way
Key words and phrases:
require password authentication
Apache authorization
limiting access to test server
control who can view development sites
Description & Info:
Clients don't like their test site competing with their live, production site for Google results. Therefore, we have put our entire set of test sites behind a pop-up requiring basic Apache authentication.
For ongoing maintenance — adding new people to access the test environment behind the authorization wall — the operative command is:
Roughly following the instructions here:
http://httpd.apache.org/docs/2.2/howto/auth.html
sudo mkdir /etc/apache2/passwd
sudo htpasswd -c /etc/apache2/passwd/passwords dan
New password:
Re-type new password:
Adding password for user dan
sudo htpasswd /etc/apache2/passwd/passwords benjamin
New password:
Re-type new password:
Adding password for user benjamin
I love that no matter how many times I do it
I love that no matter how many times I do it – leave off a semicolon, have more opening than closing parentheses, or have an extra curly brace – the PHP parser still finds my error unexpected.
It's that kind of unconditional confidence that a coder needs to get through the day... and the night.
With XAMPP, permission denied for MySQL user with % (all) host access but works for localhost
Key words and phrases:
Drupal development environment
localhost User 'jonasconstructio'@'localhost' : Edit Privileges
@% @localhost at percent all hosts
Description & Info:
For reasons not known to man nor beast, on XAMPP on Mac OS X (and not XAMP but another all in one WAMP stack, but not that name either) will not work with the wildcard availability host name (%). It will work (or anyhow may work for you, it worked for Agaric!) with the @localhost for host name.
Too-true Typo of the Week: the wanders of unit testing
Description & Info:
The too-true typo of the week, from Kyle Mathews' Unit Testing Success Story:
The Lullabot crew had a recent podcast on the wanders of unit testing.
The wanders, indeed.
In a shell script, create a database if it does not exist
Key words and phrases:
mysql create database from bash script
mysql if database exists
automate creation of database if it doesn't already exist
PHP script
bash script if mysql database does not exist create
Description & Info:
Use the MySQL: SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = 'database_name'
<?php
if (mysql_num_rows(mysql_query("SELECT SCHEMA_NAME FROM INFORMATION_SCHEMA.SCHEMATA WHERE SCHEMA_NAME = '". $dbname ."'"))) {
echo "Database $dbname already exists.";
}
else {
// go on and create the user, database, etc.
// create the user
