“Using MySQL for Apache Logging”

March 12th, 2010

The title of this chapter is “Using MySQL with Apache”. A more accurate title would be “Using MySQL for Apache Logging”.

A title like “Using MySQL with Apache” might make you think that this page discusses how to create a Web application with a database backend. In reality, this page only talks about using MySQL to hold your Apache log data.

It also makes a vague one-line reference to using MySQL for Apache authentication. In reality, using a database for Apache authentication & authorization is a big topic. But don’t be mislead by several dead projects like mod_auth_mysql. A starting point is at http://httpd.apache.org/docs/2.2/howto/auth.html .

in reference to: MySQL :: MySQL 5.0 Reference Manual :: 3.8 Using MySQL with Apache (view on Google Sidewiki)

Apache: Authentication & Authorization, Using multiple providers

March 4th, 2010

With the introduction of the new provider based authentication and authorization architecture, you are no longer locked into a single authentication or authorization method. In fact any number of the providers can be mixed and matched to provide you with exactly the scheme that meets your needs. In the following example, both the file and LDAP based authentication providers are being used.

in reference to:

“Using multiple providers”
- Authentication, Authorization and Access Control – Apache HTTP Server (view on Google Sidewiki)

mod_authn_alias: Allow authentication

March 4th, 2010

mod_authn_alias is a little known Authentication module for Apache HTTP server.

mod_authn_alias will allow authentication from multiple LDAP sources, even if they have completely different trees.

in reference to:

“mod_authn_alias”
- mod_authn_alias – Apache HTTP Server (view on Google Sidewiki)

The Bates Update – February 2010 – A New Downtown Plan

February 26th, 2010
———- Forwarded message ———-
From: Mayor's Office for the City of Berkeley <mayor@cityofberkeley.info>
Date: Fri, Feb 26, 2010 at 4:31 PM
Subject: The Bates Update – February 2010 – A New Downtown Plan


Having trouble viewing this email? Click here

The Bates Update
News from the Mayor's Office
February, 2010 – Vol 2, Issue 02

In This Issue
New Downtown Plan
Berkeley's Green Scorecard
Green Career Fair
DEAR Day
More Breaking News…
Join Our Mailing List!
Quick Links
Facebook 
 
Forward to a Friend
Greetings!
 
Mayor Tom BatesWelcome to another issue of the Bates Update.  If you enjoy receiving this information about what's happening in Berkeley please forward this email to a friend. 


New Downtown Area Plan
After months of consulting with members of the community – including environmentalists, developers, labor, affordable housing leaders, and community activists, we have put together an innovative plan that incentivizes environmental and economic public benefits in a way no other city in the Country has done.  The new plan with amendments was passed 8-1 on February 23rd and will now be sent to the City Manager for analysis and a schedule for action that will allow us to prepare for the November 2010 ballot.
Our new plan establishes an accelerated planning process for a Green Pathway that is voluntary. The Green Pathway will:
  • Create the Greenest Transit Oriented Downtown in America
  •  Get around the Palmer decision that says you can't require new building to provide affordable rental housing
  • Provide jobs for local residence and prevailing wages
  • Establish realistic buildable heights for new buildings
For more information please see our Council Item: Proposed Revisions to Downtown Area Plan 


Berkeley's Green Scorecard Website

See It 

 

Did you know that  Berkeley residents have reduced waste sent to the landfill by 25% over the last ten years?

 

The City of Berkeley launched an interactive web-based tool that presents scorecards on local sustainability trends such as annual energy use, waste disposal, and tree planting in our community.  The website is called the "Berkeley See-It."  See-It is a performance management and communications software developed by Visible Strategies.  Berkeley See-It received support from the San Francisco Foundation and the Bay Area Air Quality Management District.

 

The website enables residents to, with a few clicks of a mouse, access relevant, up-to-date information about Berkeley's progress toward its climate action goals.  In addition, the site provides a forum for questions and feedback regarding implementation of the City's Climate Action Plan.


To view the Berkeley See-It website, please visit the City of Berkeley website at:
www.cityofberkeley.info/climate

 


Green Career Exploration Fair

Green Corridor Logo

 

As chair of the East Bay Green Corridor Partnership, I am hosting our 1st Annual Green Career Exploration Fair on March 19 from 1:00-3:30 at Berkeley High School.

Students will be coming from seven high schools in the East Bay: Berkeley High School, El Cerrito High School, Emery Secondary, Oakland Tech High School, Richmond High School, Skyline High School and San Lorenzo High School.  Each of these schools is developing a dynamic Green Career Academy that will prepare our young people for the jobs of today and tomorrow.   If you're a green business and would like to have a table at the fair, please contact my Chief of Staff, Julie Sinai at jsinai@cityofberkeley.info 


Drop Everything and Read Day at Berkeley Public Schools

Join me and hundreds of other volunteers Friday morning March 5th,  to read to kids in Berkeley schools for half an hour at 9:30 a.m. This is the 16th Annual DEAR Day and we need volunteer readers! The event is short, only about an hour total, and really fun. Please contact the Berkeley School Volunteers to register for this great event!

 
Please email at bsv@berkeley.k12.ca.us if you are interested in volunteering.


Check Here for More Breaking News and Information
For more information please check out the following si
tes:

 
Mayor's Office Homepage: www.cityofberkeley.info/mayor
On Facebook: http://www.facebook.com/MayorTomBates 

 
Facebook
Please tune in to these important platforms and help make Berkeley the best it can be!
 

___________________________________________________________________________________
 
I hope you enjoyed this version of the Bates Update.  Look for us again next month and please forward this e-mail to an interested friend. 

 
Sincerely,
 

 
Tom Bates 

Safe Unsubscribe

Mayor's Office for the City Berkeley | 2180 Milvia Street | 5th Floor | Berkeley | CA | 94703





Stefan Lasiewski
http://stefanco.com

Berkeley Police Area 1 Update

February 26th, 2010

———- Forwarded message ———-
From: Pierantoni, Casimiro <CPierantoni@ci.berkeley.ca.us>
Date: Fri, Feb 5, 2010 at 3:55 PM
Subject: Berkeley Police Area 1 Update
To:

Dear Fellow Community Members,

In a recent update we discussed the topic of auto burglary and how we
had experienced an increase in auto burglary numbers from December '09
through early January of this year.  Recent numbers are showing that
we are no longer experiencing an increase, but as you already know,
auto burglary is a constant issue that we deal with in Area 1.  Beat 2
continues to be the hot-spot for auto burglary activity in our area,
particularly Hearst Ave. west of Euclid Ave. and the neighborhoods
just north of the U.C. Berkeley campus.  In the last week (since
Friday Jan. 29th), Beat 2 has had 10 reported auto burglaries compared
to 5 total auto burglaries for all of Beats 1, 3, and 18.  Parking
lots in the central and western parts of the city are also common
haunts for auto burglars.  Recently, we've become aware of auto
burglars targeting areas around schools during the morning student
drop-off and afternoon student pick-up times.  Auto burglars are
targeting parents' cars.  Often, valuables are left in plain sight
because the parents are only expecting to be away from their cars for
a short period of time.  As we have mentioned many many times before,
taking a few moments to practice simple crime prevention techniques
prior to leaving your parked car may prevent you from being the victim
of an auto burglary.

Knowing that auto burglary is a significant issue not just in Area 1
but in all parts of the city, your patrol officers respond quickly to
calls of suspicious activity and prowling in hopes of finding an auto
burglar and possibly taking a prolific criminal (which many auto
burglars are) off the streets.  An incident that occurred late last
month in West Berkeley illustrates this idea.  In the early morning of
Jan. 28th, at about 2:25am, a security officer of a large hotel on
University Ave. was walking the rear parking lot of the establishment.
The hotel had been experiencing a significant number of auto
burglaries in its parking lot and the security officer had begun to do
frequent checks of the lot in hopes of preventing further burglaries.
As he was checking the parking lot, he saw a suspicious man walk out
from behind a large van that was parked in the lot.  The security
officer stopped and let the man know that he had seen him by saying,
"What's up?"  The man responded by saying, "What's up?" then quickly
walked away from the security officer and out of the parking lot.
Because of the man's clearly suspicious behavior, the security officer
suspected the man was prowling for auto burglary.  The security
officer immediately asked a coworker to call the police then began
checking the lot for burglarized cars.

The call of the suspicious person was broadcast to the West Berkeley
patrol officers with a detailed description of the suspect.  Officer
William Cocke #143 responded to the area quickly and began a search
for the suspect.  Two blocks away from the hotel, on 6th St. just
south of University Ave., Officer Cocke detained a man that closely
matched the suspect description.  At about that same time, Officer
Darren Kacalek #88 arrived at the hotel parking lot and began the
criminal investigation.  Officer Kacalek met with the security officer
who pointed out a burglarized car he had located in the lot.  Officer
Kacalek asked Officer Elizabeth Bashan #111 (who had arrived to assist
in the investigation) to transport the security officer to Officer
Cocke's detention to see if he could identify the detained individual
as the man he saw prowling in the lot.  Officer Kacalek also went to
the detention location to interview the man.  The security officer
positively identified the individual Officer Cocke had detained as the
man he had seen earlier in the hotel parking lot.

A records check of the man showed he was on probation; a condition of
that probation was that officers had the authority to search the man's
home.  Officer Kacalek obtained the man's address from his probation
information.  Officer Kacalek, knowing he wanted to search the man's
home in hopes of locating stolen property, asked the man where he
lived just to confirm he would be checking the correct address.  The
man gave the same address that Officer Kacalek had obtained from his
probation records.  When Officer Kacalek told the man he was going to
conduct a probation search of his home, the man decided to change his
story and told Officer Kacalek that he lived in a tent, "Down by the
railroad tracks."

Officer Kacalek and other officers searched the man's apartment (which
happened to be about two blocks from the hotel) and discovered
suspected stolen property from several previous auto burglaries.  The
man's wife, who was home at the time officers were searching the home,
claimed to have no knowledge of where the items came from, just that
her husband had come home with them.  While officers were searching
the apartment, a second auto burglary was discovered in the hotel
parking lot.

Timothy L. Logan (7/6/62) of Berkeley was arrested for 2 counts of
auto burglary, five counts of possession of stolen property, and for
violation of probation.  Carolyn M. Grundy (11/29/60) of Berkeley was
arrested for five counts of possession of stolen property.

It seems safe to assume that Mr. Logan was a prolific auto burglar.
The security officer's immediate call to B.P.D., combined with the
quick and focused response by your police officers, resulted in the
arrest of a criminal that had victimized (and would have continued to
victimize) numerous community members.  This combination of a quick
call to the police followed by a fast response by your patrol officers
has once again shown itself to be a powerful tool to combat crime.

B.P.D. has a renewed focus on fighting crime.  Chief Michael Meehan
made it very clear in a speech he gave after his public swearing-in
ceremony on Jan. 28th that dealing with Berkeley's crime problem is a
priority for him.  He also stated that the police department can't
solve the crime problem alone.  I share the Chief's feelings and I'm
excited by the possibilities of what our community and our police
department can accomplish by working together.

As always, please feel free to contact me with any questions,
comments, or suggestions you may have.

Respectfully,

Officer Casimiro Pierantoni #96

   Area Coordinator-Area 1

   Community Services Bureau

   Berkeley Police Department

   Phn: (510) 981-5773

   Fax: (510) 981-5819

   cpierantoni@cityofberkeley.info>


Stefan Lasiewski
http://stefanco.com

FreeNAS 0.7 adds ZFS support

November 12th, 2009

FreeNAS is a free Network Attached Storage (A Network fileserver) based on FreeBSD. It offers many features. It is a specialized system dedicated to storage, not a general purpose operating system. Therefore, it should be better quality then hosting a NAS on a general purpose operating system.

FreeNAS also offers the stability of FreeBSD, which is often superior then Linux.

FreeNAS now includes ZFS. However, this appears to be an older version of ZFS (ZFS v6 according to http://wiki.freebsd.org/ZFSTuningGuide ). This means we won’t see the benefits of ZFS like deduplication. etc.

in reference to:

“FreeNAS 0.7 adds ZFS support”
- FreeNAS 0.7 adds ZFS support – The H Open Source: News and Features (view on Google Sidewiki)

sial.org – Great Sysadmin Resource.

October 9th, 2009

A great resource for System Administrators. Jeremy writes many insightful articles for Unix, Linux & *BSD system administration, including Cfengine, syslog, kickstart, etc.

in reference to: Jeremy Mates’s Domain (view on Google Sidewiki)

RedHat/ CentOS – How to remove a package group

October 8th, 2009

As a System Administrator, I often inherit Linux systems which were installed by someone else.

In some cases, these systems were installed with too many unnecessary packages — there is no need to run Gnome and Xwindow on a webserver, for example.

The RedHat and CentOS installers allow you to install multiple related packages by using “Package Groups”. A Package Group named “GNOME Desktop Environment” contains the dozens of RPMs and dependencies needed to install Gnome, including dependencies like the X window system.

With the worst cases, the former Sysadmin had no idea what they needed and simply selected all package in the installation GUI.

These packages need to be cleaned up.

Since this is a webserver and a headless machine, I can’t exactly fire up Gnome to view and remove packages using the convenient GUI. This is a headless machine, so my tools are SSH and the commandline.

Luckily, the Yum package manager includes a way to remove the “Package Groups” from the commandline. “yum grouplist” will show all installed and available package groups. To remove all GNOME packages on your system, simply run ‘yum groupremove “GNOME Desktop Environment”‘.

This is explained more in the “Managing Software with yum” guide, provided at centos.org .

-= Stefan

in reference to:

“su -c ‘yum groupremove “MySQL Database”‘”
- Managing Software with yum (view on Google Sidewiki)

California threatens to close ACCRC, an innovative computer recycler

October 2nd, 2007

The Alameda County Computer Resource Center is an innovative computer recycler in Berkeley, CA. They are an environmentalists dream– all waste is reused when possible, the rest is recycled. No waste is shipped to questionable trash dumps overseas. Locally, the ACCRC provides computers to local schools and nonprofits.

During the Makers Faire in San Mateo, California, the ACCRC brought in tons of computer and electronic parts which were salvaged and reused for various projects.

Sadly, the State of California is threatening to shut down the ACCRC, mostly for failing to maintain an inventory of all of their computer equipment, and for keeping interesting/historical equipment onsite (a Computer Museum), instead of destroying the equipment.

I’ve been using ACCRC (and their predecessors) for years, and I’ve volunteered for several Linux installfest events using their hardware. I sincerely hope that State is able to work with the ACCRC and reach a compromise.

Should the City of Berkeley provide free Wi-Fi to all residents?

May 29th, 2007

The City of Berkeley is thinking about offering free Wireless internet throughout the City of Berkeley.

Read about it, read comments by other people, add your own comments, and vote on the issue at KitchenDemocracy.org.