Clonweb: Difference between revisions

From CLONWiki
Jump to navigation Jump to search
Boiarino (talk | contribs)
No edit summary
Boiarino (talk | contribs)
Line 89: Line 89:
== phpmyadmin ==
== phpmyadmin ==


   #do all as 'root'
   su
  download 'phpMyAdmin-2.9.1.1-english.tar.gz' from web to '/usr/local/downloads'
  cp phpMyAdmin-2.9.1.1-english.tar.gz /www/apache2.2.3/htdocs
  cd /www/apache2.2.3/htdocs
  gunzip  phpMyAdmin-2.9.1.1-english.tar.gz
  tar xvf phpMyAdmin-2.9.1.1-english.tar
  mv phpMyAdmin-2.9.1.1-english phpMyAdmin
  cd phpMyAdmin
  cp config.sample.inc.php config.inc.php
 
Edit config.inc.php setting following (pass is root password to mysql):
If 'holla' is not set message 'The configuration file now needs a secret passphrase
(blowfish_secret).' will shows up ('holla' can be any word ???):
 
  $cfg['blowfish_secret'] = 'holla'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
  $cfg['Servers'][$i]['host'] = 'clondb1.jlab.org';
  $cfg['Servers'][$i]['controluser'] = 'root';
  $cfg['Servers'][$i]['controlpass'] = '********';


  #get phpmyadmin.tar.gz, place it to /apps/apache2.2.3/htdocs/
NOTE: following procedure was recommended but did not worked for me:
  #and untar


  cd phpMyAdmin
   mkdir config
   mkdir config
   chmod 777 config
   chmod 777 config
   cp config.sample.inc.php config/config.inc.php
   cp config.sample.inc.php config/config.inc.php
   chmod 666 config/config.inc.php
   chmod 666 config/config.inc.php
   open browser (as 'root' ?), type following URL:
   open browser (as 'root' ?), type following URL:
       http://clonweb/phpMyAdmin/scripts/setup.php
       http://clonweb/phpMyAdmin/scripts/setup.php
   Click on the "Add" button in the "Servers" section and fill in the following
   Click on the "Add" button in the "Servers" section and fill in the following
   fields:
   fields:
       Server hostname: clondb1.jlab.org
       Server hostname: clondb1.jlab.org
         (This is the host that your MySQL server is running on)
         (This is the host that your MySQL server is running on)
       Server port: 3306
       Server port: 3306
         (the port your MySQL server is configured to use)
         (the port your MySQL server is configured to use)
       Password for config auth: ....
       Password for config auth: ....
         (the root password for your MySQL server)
         (the root password for your MySQL server)
   Press the button that says "Add" in green. Then press the "Save" button in
   Press the button that says "Add" in green. Then press the "Save" button in
   the "Configuration" section.
   the "Configuration" section.
   Now copy the configuration file into the main directory and delete the config
   Now copy the configuration file into the main directory and delete the config
   directory:
   directory:
       cp config/config.inc.php ./
       cp config/config.inc.php ./
       rm -rf config
       rm -rf config
   Assuming your MySQL server is running, you are now ready to connect to it and
   Assuming your MySQL server is running, you are now ready to connect to it and
   administer it with phpMyAdmin.
   administer it with phpMyAdmin.
  >>>NOTE: all this did not worked for me, so I edited manually 'config.inc.php'
  >>>puting in clondb1.jlab.org, user 'root' and root mysql password on clondb1.




   Start a Web browser and enter the following URL:
   Start a Web browser and enter the following URL:
       http://clonweb/phpMyAdmin/
       http://clonweb/phpMyAdmin/
  ###############
  ###############
  if message 'The configuration file now needs a secret passphrase
  (blowfish_secret).' show up, do following:
  Edit config.inc.php. The line should look like this:
    $cfg['blowfish_secret'] = '';
  Enter in this line a password-like word or phrase, for example:
    $cfg['blowfish_secret'] = 'holla';
  ###############
  ###############

Revision as of 15:43, 2 January 2007

clonweb is CLON group web server holding monitoring and utility tools as well as documentation. It assume to be viewed by everybody but can be modified by CLON system experts only. It is running RHEL4 in almost standard configuration, with extra 'clonweb' partition from file server mounted as '/www' where all CLON applications are held. There are some restrictions since 'clonweb' is visible from outside of JLAB firewalls. Access to 'clonweb' is opened through port 80 only, so only web browsing shell be used. Main index.html menu contains full list of applications running on 'clonweb'.

Those restrictions includes: 

Following procedures were used to install an applications:


apache

 su
 download 'httpd-2.2.3.tar.gz' from web to '/usr/local/download/'
 cp /usr/local/download/httpd-2.2.3.tar.gz /usr/local/src
 cd /usr/local/src
 gunzip httpd-2.2.3.tar.gz
 tar xvf httpd-2.2.3.tar
 mv httpd-2.2.3 httpd-2.2.3_clonweb
 cd /usr/local/src/httpd-2.2.3_clonweb
 ./configure --enable-module=so --prefix=/www/apache2.2.3
 make
 make install

make sure that user set to 'apache' (should exist already):

 grep "^User" /www/apache2.2.3/conf/httpd.conf
 emacs /www/apache2.2.3/conf/httpd.conf
 set User (and Group) to 'apache' if necessary

php

 su
 download 'php-5.2.0.tar.gz' from web to '/usr/local/download/'
 cp /usr/local/download/php-5.2.0.tar.gz /usr/local/src
 cd /usr/local/src
 gunzip php-5.2.0.tar.gz
 tar xvf php-5.2.0.tar
 mv php-5.2.0 php-5.2.0_clonweb
 cd /usr/local/src/php-5.2.0_clonweb
 ./configure --with-mysql --with-apxs2=/www/apache2.2.3/bin/apxs
 make
 ##make install
 cp /usr/local/src/php-5.2.0_clonweb/libs/libphp5.so /www/apache2.2.3/modules

Fix apache config file /www/apache2.2.3/conf/httpd.conf:

 DirectoryIndex index.php index.html
 LoadModule php5_module modules/libphp5.so
 AddType application/x-httpd-php .php
 AddType application/x-httpd-php .php3
 AddType application/x-httpd-php .phtml

Edit /www/apache2.2.3/htdocs/index.html file.

To start/stop apache server do following:

 /www/apache2.2.3/bin/apachectl start
 /www/apache2.2.3/bin/apachectl stop

mediawiki

Create user 'clonwiki' with private group.

Create database:

 ssh root@clondb1
 mysql -u root -p
 create database wikidb\g
 grant create, select, insert, update, delete, lock tables on wikidb.* to boiarino@clonweb.jlab.org identified by    '*********'\g
 flush privileges\g
 \q

Download and install mediawiki:

 su
 download 'mediawiki-1.6.8.tar.gz' from web to '/usr/local/download'
 cp mediawiki-1.6.8.tar.gz /www/apache2.2.3/htdocs/
 cd /www/apache2.2.3/htdocs
 gunzip mediawiki-1.6.8.tar.gz
 tar xvf mediawiki-1.6.8.tar
 mv mediawiki-1.6.8 wiki

Installation procedure was not recorded - next time ...

phpmyadmin

 su
 download 'phpMyAdmin-2.9.1.1-english.tar.gz' from web to '/usr/local/downloads'
 cp phpMyAdmin-2.9.1.1-english.tar.gz /www/apache2.2.3/htdocs
 cd /www/apache2.2.3/htdocs
 gunzip  phpMyAdmin-2.9.1.1-english.tar.gz
 tar xvf phpMyAdmin-2.9.1.1-english.tar
 mv phpMyAdmin-2.9.1.1-english phpMyAdmin
 cd phpMyAdmin
 cp config.sample.inc.php config.inc.php

Edit config.inc.php setting following (pass is root password to mysql): If 'holla' is not set message 'The configuration file now needs a secret passphrase (blowfish_secret).' will shows up ('holla' can be any word ???):

 $cfg['blowfish_secret'] = 'holla'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
 $cfg['Servers'][$i]['host'] = 'clondb1.jlab.org';
 $cfg['Servers'][$i]['controluser'] = 'root';
 $cfg['Servers'][$i]['controlpass'] = '********';

NOTE: following procedure was recommended but did not worked for me:

 mkdir config
 chmod 777 config
 cp config.sample.inc.php config/config.inc.php
 chmod 666 config/config.inc.php
 open browser (as 'root' ?), type following URL:
     http://clonweb/phpMyAdmin/scripts/setup.php
 Click on the "Add" button in the "Servers" section and fill in the following
 fields:
     Server hostname:	clondb1.jlab.org
        (This is the host that your MySQL server is running on)
     Server port:	3306
        (the port your MySQL server is configured to use)
     Password for config auth:	....
        (the root password for your MySQL server)
 Press the button that says "Add" in green. Then press the "Save" button in
 the "Configuration" section.
 Now copy the configuration file into the main directory and delete the config
 directory:
     cp config/config.inc.php ./
     rm -rf config
 Assuming your MySQL server is running, you are now ready to connect to it and
 administer it with phpMyAdmin.


 Start a Web browser and enter the following URL:
     http://clonweb/phpMyAdmin/