Installing Sweeper on Mac OS X v10.6.6
47 views
Skip to first unread message
Amit
Mar 21, 2011, 5:44:03 PM3/21/11
to SwiftRiver
Hello,
This post documents all that I did to install SwiftRiver v0.3 on Mac
OS X Version 10.6.6 (including the issues I ran into, and what I
needed to do to overcome them) I spent about 4 hours getting it all to
work, so I hope this post saves other people some time ;-)
1. Read install guide for Ubuntu: http://wiki.ushahidi.com/doku.php?id=swiftserversetup
2. Signup to SwiftRiver forum: http://groups.google.com/group/swiftriver
3. Check whether PHP is installed?
bart:Documents $ php -v
PHP 5.3.3 (cli) (built: Aug 22 2010 19:41:55)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
bart:Documents $
So PHP 5.3.3 came built-in.. sweet!
4. Turn on apache server via System Preferences->Sharing and enable
'Web Sharing'
browse to http://localhost/
bart:Documents $ telnet localhost 80
Trying ::1...
Connected to localhost.
Escape character is '^]'.
GET / HTTP/1.0
HTTP/1.1 200 OK
Date: Mon, 21 Mar 2011 16:34:27 GMT
Server: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8l DAV/2
Content-Location: index.html.en
Vary: negotiate
TCN: choice
Last-Modified: Mon, 21 Mar 2011 16:13:05 GMT
ETag: "130d9-33-49f006713a640"
Accept-Ranges: bytes
Content-Length: 51
Connection: close
Content-Type: text/html
Content-Language: en
<html><body><h1>It REALLY works!</h1></body></html>Connection closed
by foreign host.
bart:Documents $
Great.. apache is there too. Now MySQL.
5. Read 'Installing MySQL on Mac OS X'
http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html
Check for previously installed mysql client and server
$ which mysql
$ which mysqld
Found none.
MySQL installation requires a Mac OS X user account named mysql. A
user account with this name should exist by default on Mac OS X 10.2
and up.
Check for username 'mysql' in /etc/passwd
Found:
_mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false
Perhaps this should be renamed to 'mysql' ?
6. Download MySQL package (.DMG) here: http://dev.mysql.com/downloads/mysql/
Make sure to choose the version suited to your OS build / processor.
Mine was 32 bit Mac OS X ver 10.6
Install MySQL Community Server, as well as Preferences Pane.
Add aliases to your .profile (or other shell startup profile file) as
required:
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
bart:~ $ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 1.1.5 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.10 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | i386 |
| version_compile_os | osx10.6 |
+-------------------------+------------------------------+
7 rows in set (0.01 sec)
mysql>
We currently have ver. 5.5.10 installed
7. Now to enable PHP with the default built-in Apache web server read
this:
http://www.php.net/manual/en/install.macosx.bundled.php
**IMPORTANT! Read the full article, including the comments! It will
save you time ;-)
AddModule and AddType are the main edits to httpd.conf as described in
the comments.
You also would need to add:
php_value mysql.default_socket /tmp/mysql.sock
to /private/etc/apache2/other/php5.conf
8. Create the /Library/WebServer/Documents/phpinfo.php file with the
following line of code:
<?php phpinfo(); ?>
Save file, restart Apache Webserver via System PReferences, and browse
to: http://localhost/phpinfo.php
If you can see the PHPinfo dump you know that PHP scripts can now be
served by Apache. yay!
9. cURL
When i looked up phpinfo.php output I found cURL was already
enabled..phew!
Saved me compiling it from source ;-)
10. PEAR
I ran $pear and got output!! So pear also came installed by default..
cool.
I have no idea what pear does, so a quick look at the man pages:
DESCRIPTION
PEAR is an acronym for "PHP Extension and Application Repository"
and is pronounced just like the
fruit. The purpose of PEAR is to provide:
o A structured library of open-source code for PHP users
o A system for code distribution and package maintenance
o A standard style for code written in PHP
o The PHP Extension Community Library (PECL)
o A web site, mailing lists and download mirrors to support
the PHP/PEAR community
So.. its kinda like CPAN for PHP (for those familiar with perl)
nice! :-)
Now install log module as so:
$ sudo pear install log
WARNING: channel "pear.php.net" has updated its protocols, use "pear
channel-update pear.php.net" to update
WARNING: "pear/DB" is deprecated in favor of "pear/MDB2"
Did not download optional dependencies: pear/DB, pear/MDB2, pear/Mail,
use --alldeps to download automatically
pear/Log can optionally use package "pear/DB" (version >= 1.3)
pear/Log can optionally use package "pear/MDB2" (version >= 2.0.0RC1)
pear/Log can optionally use package "pear/Mail"
downloading Log-1.12.5.tgz ...
Starting to download Log-1.12.5.tgz (46,311 bytes)
.............done: 46,311 bytes
install ok: channel://pear.php.net/Log-1.12.5
11. Setup a MySQL DB and User
Connect to MySQL like so:
bart:/ $ mysql -u root -p
(By default the root account has no password, just hit enter, you
should change that immediately though! See
http://www.cyberciti.biz/faq/mysql-change-root-password/)
Now create a new database:
create database swiftriver;
And create a user and give them permissions to the new database:
grant usage on *.* to swiftriver@localhost identified by '[your
password here]';
grant all privileges on swiftriver.* to swiftriver@localhost;
12. Download code from https://github.com/downloads/ushahidi/Sweeper/Sweeper_V0.3.zip
13. Unzip Sweeper to your DocumentRoot, in my case:
$ unzip Sweeper_V0.3.zip -d /Library/WebServer/Documents/
Change the permissions of some of the files that Sweeper needs to
manage.
I changed them to a+rw for all files under DocumentRoot (Note, this is
probably a security issue, dont do this witha production webserver!)
14. Now go to your browser and fire up http://localhost/index.php
I passed the first 3 checks (Introduction / Server Checks /
Permissions)
On Step 4, I input:
Database server: localhost
Username: swiftriver
Password: your_password_here
DB Name: swiftriver
15. Hit an error!!
Something went wrong while trying to connect to the database. Here are
the details: exception 'PDOException' with message 'SQLSTATE[HY000]
[2002] No such file or directory' in /Library/WebServer/Documents/
installer/steps/DBSetup.php:146
A search for PDO in phpinfo shows that PHP was compiled to look for -
with-mysql-sock=/var/mysql/mysql.sock
whereas on Mac OS X its installed in /tmp/mysql.sock
So do the following:
sudo cp /etc/php.ini.default /etc/php.ini
sudo vim /etc/php.ini
search for and change to:
mysql.default_port = /tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
pdo_mysql.default_socket=/tmp/mysql.sock
Now restart Apache and MySQL services and fire up http://localhost/index.php
16. Everything works smoothly until you hit the Kohana error :-/
First read this: http://michaeldpeters.com/userguide/guide/kohana/tutorials/clean-urls
and make the appropriate changes to DocumentRoot/web/applications/
bootstrap.ini
Kohana::init(array(
'base_url' => '/web/',
'index_file' => FALSE,
));
Add following to /private/etc/apache2/httpd.conf
# Adding Kohana specific <Directory/> directive to httpd.conf
<Directory "/Library/WebServer/Documents/web">
Order allow,deny
Allow from all
AllowOverride All
</Directory>
**NOTE In the above bit, you need to set your own DocumentRoot in my
case it is /Library/WebServer/Documents
Restart Apache and MySQL services!
This post documents all that I did to install SwiftRiver v0.3 on Mac
OS X Version 10.6.6 (including the issues I ran into, and what I
needed to do to overcome them) I spent about 4 hours getting it all to
work, so I hope this post saves other people some time ;-)
1. Read install guide for Ubuntu: http://wiki.ushahidi.com/doku.php?id=swiftserversetup
2. Signup to SwiftRiver forum: http://groups.google.com/group/swiftriver
3. Check whether PHP is installed?
bart:Documents $ php -v
PHP 5.3.3 (cli) (built: Aug 22 2010 19:41:55)
Copyright (c) 1997-2010 The PHP Group
Zend Engine v2.3.0, Copyright (c) 1998-2010 Zend Technologies
bart:Documents $
So PHP 5.3.3 came built-in.. sweet!
4. Turn on apache server via System Preferences->Sharing and enable
'Web Sharing'
browse to http://localhost/
bart:Documents $ telnet localhost 80
Trying ::1...
Connected to localhost.
Escape character is '^]'.
GET / HTTP/1.0
HTTP/1.1 200 OK
Date: Mon, 21 Mar 2011 16:34:27 GMT
Server: Apache/2.2.15 (Unix) mod_ssl/2.2.15 OpenSSL/0.9.8l DAV/2
Content-Location: index.html.en
Vary: negotiate
TCN: choice
Last-Modified: Mon, 21 Mar 2011 16:13:05 GMT
ETag: "130d9-33-49f006713a640"
Accept-Ranges: bytes
Content-Length: 51
Connection: close
Content-Type: text/html
Content-Language: en
<html><body><h1>It REALLY works!</h1></body></html>Connection closed
by foreign host.
bart:Documents $
Great.. apache is there too. Now MySQL.
5. Read 'Installing MySQL on Mac OS X'
http://dev.mysql.com/doc/refman/5.0/en/macosx-installation.html
Check for previously installed mysql client and server
$ which mysql
$ which mysqld
Found none.
MySQL installation requires a Mac OS X user account named mysql. A
user account with this name should exist by default on Mac OS X 10.2
and up.
Check for username 'mysql' in /etc/passwd
Found:
_mysql:*:74:74:MySQL Server:/var/empty:/usr/bin/false
Perhaps this should be renamed to 'mysql' ?
6. Download MySQL package (.DMG) here: http://dev.mysql.com/downloads/mysql/
Make sure to choose the version suited to your OS build / processor.
Mine was 32 bit Mac OS X ver 10.6
Install MySQL Community Server, as well as Preferences Pane.
Add aliases to your .profile (or other shell startup profile file) as
required:
alias mysql=/usr/local/mysql/bin/mysql
alias mysqladmin=/usr/local/mysql/bin/mysqladmin
bart:~ $ mysql
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.5.10 MySQL Community Server (GPL)
Copyright (c) 2000, 2010, Oracle and/or its affiliates. All rights
reserved.
Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.
Type 'help;' or '\h' for help. Type '\c' to clear the current input
statement.
mysql> SHOW VARIABLES LIKE "%version%";
+-------------------------+------------------------------+
| Variable_name | Value |
+-------------------------+------------------------------+
| innodb_version | 1.1.5 |
| protocol_version | 10 |
| slave_type_conversions | |
| version | 5.5.10 |
| version_comment | MySQL Community Server (GPL) |
| version_compile_machine | i386 |
| version_compile_os | osx10.6 |
+-------------------------+------------------------------+
7 rows in set (0.01 sec)
mysql>
We currently have ver. 5.5.10 installed
7. Now to enable PHP with the default built-in Apache web server read
this:
http://www.php.net/manual/en/install.macosx.bundled.php
**IMPORTANT! Read the full article, including the comments! It will
save you time ;-)
AddModule and AddType are the main edits to httpd.conf as described in
the comments.
You also would need to add:
php_value mysql.default_socket /tmp/mysql.sock
to /private/etc/apache2/other/php5.conf
8. Create the /Library/WebServer/Documents/phpinfo.php file with the
following line of code:
<?php phpinfo(); ?>
Save file, restart Apache Webserver via System PReferences, and browse
to: http://localhost/phpinfo.php
If you can see the PHPinfo dump you know that PHP scripts can now be
served by Apache. yay!
9. cURL
When i looked up phpinfo.php output I found cURL was already
enabled..phew!
Saved me compiling it from source ;-)
10. PEAR
I ran $pear and got output!! So pear also came installed by default..
cool.
I have no idea what pear does, so a quick look at the man pages:
DESCRIPTION
PEAR is an acronym for "PHP Extension and Application Repository"
and is pronounced just like the
fruit. The purpose of PEAR is to provide:
o A structured library of open-source code for PHP users
o A system for code distribution and package maintenance
o A standard style for code written in PHP
o The PHP Extension Community Library (PECL)
o A web site, mailing lists and download mirrors to support
the PHP/PEAR community
So.. its kinda like CPAN for PHP (for those familiar with perl)
nice! :-)
Now install log module as so:
$ sudo pear install log
WARNING: channel "pear.php.net" has updated its protocols, use "pear
channel-update pear.php.net" to update
WARNING: "pear/DB" is deprecated in favor of "pear/MDB2"
Did not download optional dependencies: pear/DB, pear/MDB2, pear/Mail,
use --alldeps to download automatically
pear/Log can optionally use package "pear/DB" (version >= 1.3)
pear/Log can optionally use package "pear/MDB2" (version >= 2.0.0RC1)
pear/Log can optionally use package "pear/Mail"
downloading Log-1.12.5.tgz ...
Starting to download Log-1.12.5.tgz (46,311 bytes)
.............done: 46,311 bytes
install ok: channel://pear.php.net/Log-1.12.5
11. Setup a MySQL DB and User
Connect to MySQL like so:
bart:/ $ mysql -u root -p
(By default the root account has no password, just hit enter, you
should change that immediately though! See
http://www.cyberciti.biz/faq/mysql-change-root-password/)
Now create a new database:
create database swiftriver;
And create a user and give them permissions to the new database:
grant usage on *.* to swiftriver@localhost identified by '[your
password here]';
grant all privileges on swiftriver.* to swiftriver@localhost;
12. Download code from https://github.com/downloads/ushahidi/Sweeper/Sweeper_V0.3.zip
13. Unzip Sweeper to your DocumentRoot, in my case:
$ unzip Sweeper_V0.3.zip -d /Library/WebServer/Documents/
Change the permissions of some of the files that Sweeper needs to
manage.
I changed them to a+rw for all files under DocumentRoot (Note, this is
probably a security issue, dont do this witha production webserver!)
14. Now go to your browser and fire up http://localhost/index.php
I passed the first 3 checks (Introduction / Server Checks /
Permissions)
On Step 4, I input:
Database server: localhost
Username: swiftriver
Password: your_password_here
DB Name: swiftriver
15. Hit an error!!
Something went wrong while trying to connect to the database. Here are
the details: exception 'PDOException' with message 'SQLSTATE[HY000]
[2002] No such file or directory' in /Library/WebServer/Documents/
installer/steps/DBSetup.php:146
A search for PDO in phpinfo shows that PHP was compiled to look for -
with-mysql-sock=/var/mysql/mysql.sock
whereas on Mac OS X its installed in /tmp/mysql.sock
So do the following:
sudo cp /etc/php.ini.default /etc/php.ini
sudo vim /etc/php.ini
search for and change to:
mysql.default_port = /tmp/mysql.sock
mysql.default_socket = /tmp/mysql.sock
pdo_mysql.default_socket=/tmp/mysql.sock
Now restart Apache and MySQL services and fire up http://localhost/index.php
16. Everything works smoothly until you hit the Kohana error :-/
First read this: http://michaeldpeters.com/userguide/guide/kohana/tutorials/clean-urls
and make the appropriate changes to DocumentRoot/web/applications/
bootstrap.ini
Kohana::init(array(
'base_url' => '/web/',
'index_file' => FALSE,
));
Add following to /private/etc/apache2/httpd.conf
# Adding Kohana specific <Directory/> directive to httpd.conf
<Directory "/Library/WebServer/Documents/web">
Order allow,deny
Allow from all
AllowOverride All
</Directory>
**NOTE In the above bit, you need to set your own DocumentRoot in my
case it is /Library/WebServer/Documents
Restart Apache and MySQL services!
Jon Gosier
Mar 21, 2011, 10:54:52 PM3/21/11
to swift...@googlegroups.com
Thanks for this Amit, this is a really valuable contribution to the community!
--
You received this message because you are subscribed to the Google Groups "SwiftRiver" group.
To post to this group, send email to swift...@googlegroups.com.
To unsubscribe from this group, send email to swiftriver+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/swiftriver?hl=en.
Matthew Griffiths
Mar 22, 2011, 3:02:42 AM3/22/11
to swift...@googlegroups.com
Agreed,
Thanks Amit!
Matt
Thanks Amit!
Matt
Amit
Mar 21, 2011, 6:58:21 PM3/21/11
to SwiftRiver
Oh one last thing..
You will probably also run into this login issue:
https://github.com/ushahidi/Swiftriver/issues/43
Create the user table by hand and rerun the install and all works
well !
You will probably also run into this login issue:
https://github.com/ushahidi/Swiftriver/issues/43
Create the user table by hand and rerun the install and all works
well !
Jonathan Gosier
Mar 27, 2011, 1:24:12 PM3/27/11
to swift...@googlegroups.com, Amit
Amit, I've added your guide to - http://wiki.ushahidi.com/doku.php?id=install_s
You have edit access if you want to update anything. Again, many thanks!
Mark Simpkins
Mar 28, 2011, 8:13:55 AM3/28/11
to swift...@googlegroups.com, Amit
Just a quick not in addition to this excellent piece of work.
To follow the above instructions you need to be installing Swiftriver in the main system web documents folder. I was originally trying to install it under a users /Sites folder (with a localhost URL of something like localhost/~username/Sweeper/web/ ) even following the above and swapping in the new path didn't work. Moving the install to the /Library/WebServer/Documents/Sweeper/web directory worked.
Onto the next steps...
Mark
Jon Gosier
Mar 28, 2011, 9:14:16 AM3/28/11
to swift...@googlegroups.com, Mark Simpkins, Amit
thanks, Mark we'll add that too the document. If you'd like edit access to it, just let me know!
--
Amit
Mar 28, 2011, 8:37:28 AM3/28/11
to swift...@googlegroups.com
Thank you Mark
Can you tell me where it failed and I will add the root cause to the how-to
Thanks
--
Sent from my mobile device
Ahmed Mohamed Maawy
Mar 28, 2011, 9:38:44 AM3/28/11
to swift...@googlegroups.com, Amit
Hi Amit,
Cool stuff :) Thanks for all the support on the documentation.
Ahmed
--
Ahmed Mohamed Maawy
SwiftRiver Platform Software Engineer
Ushahidi
http://www.ushahidi.com
http://www.swiftly.org
Skype: ultimateprogramer
Phone: +254-714-960627
Cool stuff :) Thanks for all the support on the documentation.
Ahmed
--
You received this message because you are subscribed to the Google Groups "SwiftRiver" group.
To post to this group, send email to swift...@googlegroups.com.
To unsubscribe from this group, send email to swiftriver+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/swiftriver?hl=en.
--
Ahmed Mohamed Maawy
SwiftRiver Platform Software Engineer
Ushahidi
http://www.ushahidi.com
http://www.swiftly.org
Skype: ultimateprogramer
Phone: +254-714-960627
Reply all
Reply to author
Forward
0 new messages