Changeset 700 in ProjectBuilder for projects/fossology/pbconf

Timestamp:

Feb 18, 2009, 11:30:15 PM (16 years ago)

Author:

Bruno Cornec

Message:

Except one remaining issue to fix with postgresql conf, this fossology setup creates a nice rpm for centos 5

Location:

projects/fossology/pbconf/trunk

Files:

• fossology.pb (modified) (1 diff)
• fossology/rpm/fossology.spec (modified) (5 diffs)

projects/fossology/pbconf/trunk/fossology.pb

@@ -121 +121 @@
 # So the package name is indeed virtual
 #namingtype fossology = perl
+#
+# This project needs additional repository to be able to be built correctly
+#
+verepo centos-5-x86_64 = http://packages.sw.be/rpmforge-release/rpmforge-release-0.3.6-1.el5.rf.x86_64.rpm,ftp://ftp.project-builder.org/centos/5/pb.repo
+verepo centos-4-x86_64 = http://packages.sw.be/rpmforge-release/rpmforge-release-0.3.6-1.el4.rf.x86_64.rpm,ftp://ftp.project-builder.org/centos/4/pb.repo
+

projects/fossology/pbconf/trunk/fossology/rpm/fossology.spec

@@ -92 +92 @@
 grep -q kernel.shmmax /etc/sysctl.conf
 if [ $? -eq 0 ]; then
-    perl -pi -e "s/kernel.shmmax\s*=.*/kernel.shmmax=512000000/" /etc/sysctl.conf
+    perl -pi -e "s/^[#\s]*kernel.shmmax\s*=.*/kernel.shmmax=512000000/" /etc/sysctl.conf
 else
     echo "kernel.shmmax=512000000" >> /etc/sysctl.conf
 fi
 
-if [ ! -f /usr/share/pgsql/postgresql.conf ]; then
-    cp /usr/share/pgsql/postgresql.conf.sample /usr/share/pgsql/postgresql.conf
-    
-    # Adjust postgresql config (described in detail in section 2.1.4) for Fossology
-    cat >> /usr/share/pgsql/postgresql.conf << EOF
-listen_addresses = '*'
-max_connections = 50
-shared_buffers = 32768
-work_mem = 10240  
-max_fsm_pages = 100000          # min max_fsm_relations*16, 6 bytes each
-fsync = off   
-full_page_writes = off          # recover from partial page writes
-commit_delay = 1000 
-effective_cache_size = 25000
-log_min_duration_statement = -1 # -1 is disabled, 0 logs all statements
-log_line_prefix = '%t %h %c'    # prepend a time stamp to all log entries
-EOF
-else
-    echo "Please check that your postgresql configuration is aligned with fossology recommendations at section 2.1.4 of /usr/share/doc/fossology*/INSTALL"
+# Adjust postgresql config (described in detail in section 2.1.4) for Fossology
+PGCONF=/var/lib/pgsql/data/postgresql.conf
+if [ ! -f $PGCONF ]; then
+    cp /usr/share/pgsql/postgresql.conf.sample $PGCONF
+fi
+grep -qw listen_addresses $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*listen_addresses.*=.*/listen_addresses = '*'/" $PGCONF
+else
+    echo "listen_addresses = '*'" >> $PGCONF
+fi
+grep -qw max_connections $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*max_connections.*=.*/max_connections = 50/" $PGCONF
+else
+    echo "max_connections = 50" >> $PGCONF
+fi
+grep -qw shared_buffers $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*shared_buffers.*=.*/shared_buffers = 32768/" $PGCONF
+else
+    echo "shared_buffers = 32768" >> $PGCONF
+fi
+grep -qw work_mem $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*work_mem.*=.*/work_mem = 10240/" $PGCONF
+else
+    echo "work_mem = 10240" >> $PGCONF
+fi
+# min max_fsm_relations*16, 6 bytes each
+grep -qw max_fsm_pages $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*max_fsm_pages.*=.*/max_fsm_pages = 100000/" $PGCONF
+else
+    echo "max_fsm_pages = 100000" >> $PGCONF
+fi
+grep -qw fsync $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*fsync.*=.*/fsync = off/" $PGCONF
+else
+    echo "fsync = off" >> $PGCONF
+fi
+# recover from partial page writes
+grep -qw full_page_writes $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*full_page_writes.*=.*/full_page_writes = off/" $PGCONF
+else
+    echo "full_page_writes = off" >> $PGCONF
+fi
+grep -qw commit_delay $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*commit_delay.*=.*/commit_delay = 1000/" $PGCONF
+else
+    echo "commit_delay = 1000" >> $PGCONF
+fi
+grep -qw effective_cache_size $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*effective_cache_size.*=.*/effective_cache_size = 25000/" $PGCONF
+else
+    echo "effective_cache_size = 25000" >> $PGCONF
+fi
+# -1 is disabled, 0 logs all statements
+grep -qw log_min_duration_statement $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*log_min_duration_statement.*=.*/log_min_duration_statement = -1/" $PGCONF
+else
+    echo "log_min_duration_statement = -1" >> $PGCONF
+fi
+# prepend a time stamp to all log entries
+grep -qw log_line_prefix $PGCONF
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*log_line_prefix.*=.*/log_line_prefix = '%t %h %c'/" $PGCONF
+else
+    echo "log_line_prefix = '%t %h %c'" >> $PGCONF
 fi
 
@@ -122 +177 @@
 if [ $? -eq 0 ]; then
     /etc/init.d/postgresql start
-else
-    /etc/init.d/postgresql reload
-fi
+fi
+chkconfig --add postgresql
+
+cat >> /var/lib/pgsql/data/pg_hba.conf << EOF
+# Added for FOSSology connection
+# Local connections
+local   all         all                               md5
+# IPv4 local connections:
+host    all         all         127.0.0.1/32          md5
+EOF
+# reload doesn't seem to work here :-(
+/etc/init.d/postgresql restart
 
 # Adjust PHP config (described in detail in section 2.1.5)
 grep -qw memory_limit PBPHPINI
 if [ $? -eq 0 ]; then
-    perl -pi -e "s/memory_limit.*=.*/memory_limit = 702M/" PBPHPINI
+    perl -pi -e "s/^[#\s]*memory_limit.*=.*/memory_limit = 702M/" PBPHPINI
 else
     echo "memory_limit = 702M" >> PBPHPINI
@@ -135 +199 @@
 grep -qw post_max_size PBPHPINI
 if [ $? -eq 0 ]; then
-    perl -pi -e "s/post_max_size.*=.*/post_max_size = 702M/" PBPHPINI
+    perl -pi -e "s/^[#\s]*post_max_size.*=.*/post_max_size = 702M/" PBPHPINI
 else
     echo "post_max_size = 702M" >> PBPHPINI
@@ -141 +205 @@
 grep -qw upload_max_filesize PBPHPINI
 if [ $? -eq 0 ]; then
-    perl -pi -e "s/upload_max_filesize.*=.*/upload_max_filesize = 702M/" PBPHPINI
+    perl -pi -e "s/^[#\s]*upload_max_filesize.*=.*/upload_max_filesize = 702M/" PBPHPINI
 else
     echo "upload_max_filesize = 702M" >> PBPHPINI
 fi
+grep -qw allow_call_time_pass_reference PBPHPINI
+if [ $? -eq 0 ]; then
+    perl -pi -e "s/^[#\s]*allow_call_time_pass_reference.*=.*/allow_call_time_pass_reference = On/" PBPHPINI
+else
+    echo "allow_call_time_pass_reference = On" >> PBPHPINI
+fi
 
 # Add apache config for fossology (described in detail in section 2.1.6) - done in install
-LANGUAGE=C /etc/init.d/httpd status 2>&1 | grep -q stop
-if [ $? -eq 0 ]; then
-    /etc/init.d/httpd start
-else
-    /etc/init.d/httpd reload
-fi
-
 # Run the postinstall script
 /usr/lib/PBPROJ/fo-postinstall
+
+# Adds user httpd to fossy group
+perl -pi -e 's/^fossy:x:([0-9]+):/fossy:x:$1:httpd/' /etc/group
+
+# httpd
+LANGUAGE=C /etc/init.d/httpd status 2>&1 | grep -q stop
+if [ $? -eq 0 ]; then
+    /etc/init.d/httpd start
+else
+    /etc/init.d/httpd reload
+fi
+chkconfig --add httpd
 
 # Test that things are installed correctly
@@ -173 +248 @@
 # We should do some cleanup here (fossy account ...)
 /usr/lib/PBPROJ/fo-cleanold
-userdel fossy
-groupdel fossy
 
 %changelog