Finally another Drupal meetup in Old Town Pasadena. The meetup will be held on Monday, November 1, 2010 from 7-9pm. Everyone is invited. This week's presentation will be "From Development Server to Live Production Server" and presented by Christefano. Please bring laptops and chargers if you would like to follow along. There will be time for discussion and job announcements.
Please RSVP by signing up below so we know how many to accommodate. Depending on the turn out we may need people to bring chairs. If you can't attend this month's meetup but would like to come to one in the future, we will be hosting meetups on the first Monday of each month.
Address: 1 S Fair Oaks Ave., Suite 202, Pasadena, CA 91105 (this has changed from the previous 201)
Parking: There is free parking after 8pm if you can find a spot on the street. There is also a parking garage across the street. First hour and a half is free and $2/hour after that.
We realize that traffic for people on the West Side is less than ideal so we are working on setting up a live broadcast for this presentation. If there are any companies that would be willing to let us use their WebEx or GoTo Webinar account that would be extremely helpful! There will be a screencast for this presentation, however, we encourage all that can attend to attend. As the other meetups say- "Attending the LA Drupal meetups is one of the best ways to meet and talk with other Drupaleros and we encourage you to attend as many meetings as you can..."
Join us afterward for a Drupal After Dark at Intelligentsia for some drinks, networking opportunities and continued discussion.
Comments
Time Change
The time of the Pasadena meetup changed to 7pm. Hopefully the time change is more accommodating. This also opens the door for a Drupal After Dark at Intelligentsia.
A Digital Entrepreneur and Technical Consultant.
Founder, CEO of FoggyTrail
Drupal from development to production
Is there anything in particular that people want to see in my presentation? My plan right now is to talk about what makes up a Drupal site (the codebase, the database and the files directory) and demonstrate how to synchronize these across multiple sites. I can demo the tools I use and highlight existing and emerging best practices for this type of work.
Perhaps.
Not wanting to stretch the scope of your talk too far, but, I am currently trying to add some separate sub-domain sites to an existing Drupal installation. I have complete control over the server and I have several sites working on virtual servers that I set up. I want these sub domains to share the codebase with one of the existing sites running in one of the virtual servers. If that can be addressed without expanding the scope of your presentation excessively it would be appreciated.
Sure, we can talk about this.
Sure, we can talk about this. How this is done depends on which control panel (if any) you're using. I'll be using Virtualmin during the demo.
Data Sanatizing
If there are any Drupal specific scripts for sanitizing the database and stripping all usernames and passwords. I have been avoiding the problem altogether and know it is time.
The script I usually point
The script I usually point people to is the one at crackingdrupal.com. Josh's presentation at DrupalCamp LA had a script, too. I recommend starting with one of those and modifying it to suit your needs.
Great Sanatizing script
Thanks for that. I am assuming this goes into an executable file and can be called as part of my migration process either through drush or one of my own...
Nice new pic by the way!
MySQL sanitizing script excerpt
Here's the excerpt of our standard sanitizing script that I showed tonight. Again, you can either use sed to perform string replacements on a database dump or run SQL queries on a copy of the database. The following is if you do the latter.
1. first dump your database
2. reimport it using a different database name (or perhaps on a different database server)
3. then run the queries and dump the database again
-- not everyone disables outgoing email on their development sites, so replace user email addresses
update users set mail=concat('user', uid, '@example.com') where uid > 0;
-- disable modules that aren't needed for local development
delete from system where name in ('securepages', 'secure_login', 'session443', 'googleanalytics', 'twitter');
-- replace user account passwords with "user_password"
update users set pass = md5('user_password') where uid in (select uid from users_roles where rid > 2) and uid > 0;
-- replace admin account password with "admin_password"
update users set pass = md5('admin_password') where uid = 1;
-- replace the SMTP password with... you guessed it, "smtp_password"
update variable set value = 's:4:"smtp_password";' where name = 'smtp_password';
ps. Thanks! The photo was taken by Tof, a fellow ringflyer and LA Drupal member.
another one
Here's another database sanitizing script:
http://joshuabrauer.com/2010/11/scrubbing-drupal-databases-development
This is the same one that's at http://acquia.com/node/1531062 but Acquia's input filters are messed up and there are HTML tags in the script, so be sure to remove them first.
Have you tried different profile settings in backup/migrate?
The backup/migrate module lets you select (a) which tables you want to include in your dump and (b) if you want to include data from that table as part of your dump. In your scenario, you could skip exporting the data that is in the users table. The other way (and I guess this could be scripted) would be to then have some setting which could strip out, (or hash) particular columns in each table (though I'm not sure what the interface for managing something like that would be like). I'm not sure how easy/hard it is to extend the backup/migrate module, however for this part (though it would be easy to create a second module to hand you some sql to run (or run particular sql).
The Acquia webinar today,
The Acquia webinar today, Drupal Staging and Deployment Best Practices, showed some bash scripts for sanitizing a database and the presenters said the scripts would be posted on Acquia's site soon.
The Acquia webinar today missed it
Anyone knows if there is a recorded version of that webinar out there?
It looks like Acquia post their webinars here http://acquia.com/resources/recorded_webinars but not this one.
The recorded webinar was
The recorded webinar was available when I checked.
It looks very similar to Josh Brauer's presentation this year at DrupalCamp LA.
Ah, the day (Monday) in
Ah, the day (Monday) in general doesn't work for me, but hopefully when it opens up I can make it out!
WizOne Solutions - https://wizone.solutions - Drupal module development, theme implementation, and more
FillPDF Service - https://fillpdf.io - Hosted solution for FillPDF
Trellon WebEx
We can use Trellon's WebEx tonight if you're still looking to webcast the meeting. I'll be there around 7 so we can coordinate when I arrive.
That would be great! Thank
That would be great! Thank you so much.
A Digital Entrepreneur and Technical Consultant.
Founder, CEO of FoggyTrail
Thanks for a great
Thanks for a great meetup!
Chris
Chris Grant
Senior Visualization Artist | HMC Architects
Portfolio | christophergrant.com
IE Drupal | g.d.o/inland-empire
Really good meetup :)
Things mentioned through the meetup (or atleast what I remember):
All in all, this was a really good evening and great to see so many new faces :D
Small update on info regarding drush and sanitizing data
Looks like someone else (or a series of someone elses) have been thinking along the same lines - would be a good idea to look at http://drupal.org/node/861822