{"id":621,"date":"2009-11-19T17:16:49","date_gmt":"2009-11-19T10:16:49","guid":{"rendered":"http:\/\/adityo.blog.binusian.org\/?p=621"},"modified":"2009-11-19T17:16:49","modified_gmt":"2009-11-19T10:16:49","slug":"how-to-install-cherokee-mysql-phpmyadmin-htaccess-on-ubuntu-server-910","status":"publish","type":"post","link":"https:\/\/adityo.blog.binusian.org\/?p=621","title":{"rendered":"How to install cherokee + mysql + phpmyadmin + htaccess on ubuntu server 9.10"},"content":{"rendered":"

\"cherokee1\"<\/a><\/p>\n

Cherokee can be installed in a variety of ways. By default, Ubuntu has support for Cherokee in its existing repositories.\u00a0 However, development on Cherokee is happening at breakneck speeds. Since the default Ubuntu repositories are incapable of keeping up with this type of rapid development, that leaves only two real options: compile from source or use an alternative repository. For the sake of this HOWTO we opted for the latter, since using apt is the preferred Ubuntu installation method.
\nThat is why we use ppa.launchpad.net repository to install our cherokee, first go to your \/etc\/apt\/sources.list files<\/p>\n

# vim \/etc\/apt\/sources.list<\/p>\n

and\u00a0 you need to add this :<\/p>\n

deb http:\/\/ppa.launchpad.net\/cherokee-webserver\/ppa\/ubuntu karmic main
\ndeb-src http:\/\/ppa.launchpad.net\/cherokee-webserver\/ppa\/ubuntu karmic main<\/p>\n

Save and exit<\/p>\n

Install GPG key using the following command<\/p>\n

# apt-key adv –recv-keys –keyserver keyserver.ubuntu.com 0AD0B667B67DAA477F5FF89F51BB8E83EBA7BD49<\/p>\n

Executing: gpg –ignore-time-conflict –no-options –no-default-keyring –secret-keyring \/etc\/apt\/secring.gpg –trustdb-name
\n\/etc\/apt\/trustdb.gpg –keyring \/etc\/apt\/trusted.gpg –recv-keys –keyserver keyserver.ubuntu.com
\n0AD0B667B67DAA477F5FF89F51BB8E83EBA7BD49
\ngpg: requesting key EBA7BD49 from hkp server keyserver.ubuntu.com
\ngpg: key EBA7BD49: public key “Launchpad PPA for Cherokee Web Server” imported
\ngpg: Total number processed: 1
\ngpg:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 imported: 1\u00a0 (RSA: 1)<\/p>\n

Update the source list<\/p>\n

# apt-get update
\nGet:14 http:\/\/ppa.launchpad.net karmic\/main Sources [575B]<\/p>\n

install the cherokee
\n# apt-get install cherokee<\/p>\n

go to your web server ip address to checked it http:\/\/localhost<\/p>\n

\"cherokee2\"<\/a><\/p>\n

Install PHP support<\/p>\n

Use the following commands to install php support<\/p>\n

# apt-get install php5-cgi php5-mysql<\/p>\n

Test your php installation:<\/p>\n

go to \/var\/www and create test.php
\n# cd \/var\/www
\n# vi test.php
\n<? phpinfo(); ?><\/p>\n

Before you test your test.php file, first you need to add php extention behaviouron the cherokee virtual server. Activate<\/p>\n

your cherokee admin<\/p>\n

# cherokee-admin -b<\/p>\n

Login:
\nUser:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 admin
\nOne-time Password: 123Dbb5678tZ212
\nWeb Interface:
\nURL:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/localhost:9090\/<\/p>\n

Cherokee Web Server 0.99.27 (Nov\u00a0 6 2009): Listening on port ALL:9090, TLS
\ndisabled, IPv6 disabled, using epoll, 4096 fds system limit, max. 2041
\nconnections, caching I\/O, single thread<\/p>\n

then you got to your web server ip port 9090 ,http:\/\/101.18.181.111:9090<\/p>\n

\"cherokee3\"<\/a><\/p>\n

Go to Virtual Servers -> pick your virtual server nickname (at the first time it’s usually default) -> Behavior -> Wizards -> Languages -> php -> Run Wizards<\/p>\n

\"cherokee4\"<\/a>\"cherokee5\"\"cherokee6\"<\/a><\/a><\/p>\n

Then don’t forget to save changes by clicking the save button on the left, go to Test you installation\/test.php to checked it<\/p>\n

\"cherokee7\"<\/a><\/p>\n

Install Mysql server support<\/p>\n

Use the following commands to install mysql server support<\/p>\n

# apt-get install mysql-server mysql-client<\/p>\n

MySQL is now installed and should operate fairly smooth and without issue. However, if the goal is to strictly use WordPress<\/p>\n

then the MySQL daemon should be tweaked a bit in order to save on memory consumption.<\/p>\n

# sudo vi \/etc\/mysql\/my.cnf<\/p>\n

Ensure the following entries have similar options set in the MySQL configuration file:<\/p>\n

key_buffer\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 16M
\nmax_allowed_packet\u00a0\u00a0\u00a0\u00a0\u00a0 = 16M
\nthread_stack\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 192K
\nthread_cache_size\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 = 8
\nskip-innodb<\/p>\n

The last entry is an important one and will lower MySQL memory consumption considerably.<\/p>\n

Now you can checked yoru mysql status
\n# \/etc\/init.d\/mysql status
\n* \/usr\/bin\/mysqladmin\u00a0 Ver 8.42 Distrib 5.1.37, for debian-linux-gnu on x86_64
\nCopyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc.
\nThis software comes with ABSOLUTELY NO WARRANTY. This is free software,
\nand you are welcome to modify and redistribute it under the GPL license<\/p>\n

Server version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.1.37-1ubuntu5
\nProtocol version\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 10
\nConnection\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Localhost via UNIX socket
\nUNIX socket\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 \/var\/run\/mysqld\/mysqld.sock
\nUptime:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 51 min 38 sec<\/p>\n

Threads: 1\u00a0 Questions: 102\u00a0 Slow queries: 0\u00a0 Opens: 99\u00a0 Flush tables: 1\u00a0 Open tables: 23\u00a0 Queries per second avg: 0.32<\/p>\n

installing phpmyadmin on Cherokee<\/p>\n

# apt-get install phpmyadmin<\/p>\n

when you ge prompt with this question just ignored it and pick ok
\nPlease choose the web server that should be automatically configured to \u201a run phpMyAdmin.
\n\u201a Web server to reconfigure automatically:
\n[ ] apache2
\n[ ] lighttpd
\n<Ok><\/p>\n

Okay after it’s done we need to set the phpmyadmin on the cherokee, and the lates cherokee provide us with the wizard, just<\/p>\n

go to your cherokee admin<\/p>\n

# cherokee-admin -b<\/p>\n

Login:
\nUser:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 admin
\nOne-time Password: eCKD7WlY27KKhHeZ<\/p>\n

Web Interface:
\nURL:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 http:\/\/localhost:9090\/<\/p>\n

Cherokee Web Server 0.99.27 (Nov\u00a0 6 2009): Listening on port ALL:9090, TLS
\ndisabled, IPv6 disabled, using epoll, 4096 fds system limit, max. 2041
\nconnections, caching I\/O, single thread<\/p>\n

then go to virtual server -> your virtual server nickname -> behaviour -> wizards -> phpmyadmin -> run wizards<\/p>\n

\"cherokee8\"<\/a>
\n\"cherokee9\"<\/a><\/p>\n

your notice that Source Directory was set automaticly to \/usr\/share\/phpmyadmin, if you build your phpmyadmin from source you need to add the Source Directory manually you can use whereis command to located your phpmyadmin config files
\n# whereis phpmyadmin
\nphpmyadmin: \/etc\/phpmyadmin \/usr\/share\/phpmyadmin<\/p>\n

Then don’t forget to save, then go to your phpmyadmin link to test it http:\/\/101.18.181.111\/phpmyadmin\/<\/p>\n

\"cherokee10\"<\/a><\/p>\n

Okay we have installed phpmyadmin, now the question is how to add .htaccess on the phpmyadmin directory to make it more<\/p>\n

secure ? we can add .htaccess on the cheerokee
\nfirst you need to create htpasswd file first, you can add the file anywhere in my case i add it on \/var\/htpasswd
\nsince ubuntu by default did not include htpasswd we need to isntall it first
\n# apt-get install apache2-utils
\n# mkdir \/var\/htpasswd
\ni will create user admin
\n# \/usr\/bin\/htpasswd -c \/var\/htpasswd\/user.passwd admin
\nNew password:
\nRe-type new password:
\nAdding password for user admin<\/p>\n

you can see it now
\n# tail \/var\/htpasswd\/user.passwd
\nadmin:5tSClQs1NtlQA<\/p>\n

okay get back to cherokee admin -> virtual server -> your virtual server nickname -> behaviour -> click \/phpmyadmin-> security -> drop down and pick htpasswd file<\/p>\n

Methods\u00a0\u00a0\u00a0 \u00a0\u00a0 -> basic
\nRealm\u00a0\u00a0\u00a0 \u00a0\u00a0 -> the name of your htaccess
\nUsers\u00a0\u00a0\u00a0 \u00a0\u00a0 -> the username that have previledges to access
\nPassword File\u00a0\u00a0\u00a0 -> the path of .htpasswd<\/p>\n

\"cherokee11\"<\/a>
\nThe don’t forget to save<\/p>\n

then go to http:\/\/101.18.181.111\/phpmyadmin to test it<\/p>\n

\"cherokee12\"<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Cherokee can be installed in a variety of ways. By default, Ubuntu has support for Cherokee in its existing repositories.\u00a0 However, development on Cherokee is happening at breakneck speeds. Since the default Ubuntu repositories are incapable of keeping up with this type of rapid development, that leaves only two real options: compile from source or […]<\/p>\n","protected":false},"author":386,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4872],"tags":[4871],"class_list":["post-621","post","type-post","status-publish","format-standard","hentry","category-cherokee","tag-cherokee-mysql-phpmyadmin-htaccess-on-ubuntu-server-910"],"_links":{"self":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/621","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/users\/386"}],"replies":[{"embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=621"}],"version-history":[{"count":2,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/621\/revisions"}],"predecessor-version":[{"id":635,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=\/wp\/v2\/posts\/621\/revisions\/635"}],"wp:attachment":[{"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=621"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=621"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/adityo.blog.binusian.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=621"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}