smeserver-mediawiki/contribs7/smeserver-mediawiki.spec

%define name smeserver-mediawiki
%define version 1.6.10
%define release 8
%define rpmver   4.0.4

Summary:            Mediawiki Web Application for SME Server 7.x based on Mediawiki 1.6.10
Name:               %{name}
Version:            %{version}
Release:            %{release}
License:            GPL
Group:              /Web/Applications
Source:             %{name}-%{version}.tar.gz
Patch0:             smeserver-mediawiki-1.6.10-1.patch
Packager:           Dietmar Berteld  <dietmar@berteld.com>
URL:                http://mediawiki.org/
BuildRoot:          /var/tmp/%{name}-%{version}-%{release}-buildroot
BuildArchitectures: noarch
Requires:           e-smith-base, e-smith-release >= 7

%description
This RPM is an unofficial addon for the SME Server 7.x.
The target audience is the Linux/E-smith administrator
who wants to add Wikipedia-SW.
Mediawiki is a very popular Wiki and is used by the wikipedia-project.
After installation open your webbrowser your local site
http://your_e-smith-server_adress/wiki

%changelog
* Mon May 12 2008 Dietmar Berteld>
- [1.6.10-8]    Adding PwAuth-function, SME users can login with their SME passwords
                Automatic creation of a few default mw_groups and list them in the
                configuration file as well so admins only need to add users to the proper
                groups in the server-manager

* Thu Feb 26 2008 Dietmar Berteld>
- [1.6.10-7] Fixed httpd-settings for local access only

* Thu Oct 23 2007 Dietmar Berteld>
- [1.6.10-6] Fixed automated uninstall issue for MySQL-DB and MySQL-user

* Fri Oct 19 2007 Dietmar Berteld>
- [1.6.10-5] Fixed short URL's
                  - Improved Apache template for better security
                  - Improved integration in SME (PublicAccess local/global - global)

* Wed Oct 10 2007 Sylvain Gomez <sylvaingomez@free.fr>
- [1.6.10-4] Fixed short URL's
             Fixed Apache restarting at the wrong time while uninstalling
             Added missing MySQL User
             Added automatic lang detection at install stage
             Changed sme.png logo

* Wed Sep 05 2007 Dietmar Berteld <dietmar@berteld.com>
- [1.6.10-3] Simpler method to create MySQL-Datebase
              Using short URL's

* Wed Apr 25 2007 Dietmar Berteld <dietmar@berteld.com>
- [1.6.10-2] Security Improvements (template, MySQL, directory-rights)
             Thanks for the help to Sylvain Gomez <sylvain.gomez@free.fr>

* Thu Apr 12 2007 Dietmar Berteld <dietmar@berteld.com>
- [1.6.10-1] Initial version

%prep
rm -rf $RPM_BUILD_ROOT

%setup

%patch0 -p1

%build

%install
rm -rf $RPM_BUILD_ROOT
(cd root ; find . -depth -print | cpio -dump $RPM_BUILD_ROOT)
rm -f %{name}-%{version}-filelist
/sbin/e-smith/genfilelist $RPM_BUILD_ROOT > %{name}-%{version}-filelist

%clean
rm -rf $RPM_BUILD_ROOT

%pre

UPDATE=$(ls /opt | grep -c mediawiki)
case $UPDATE in
  0)
    echo "Installing MediaWiki... Please wait!"
    ;;
  *)
    echo "Updating MediaWiki... Please wait!"
    mkdir -p /opt/MW_RPM_BACKUP
    cd /opt
    echo "Backing up installation files..."
    tar -czf /opt/MW_RPM_BACKUP/mediawiki.tar.gz mediawiki
    echo "Backing up MySQL database..."
    mysqldump mediawiki > /opt/MW_RPM_BACKUP/mediawiki.sql
    /sbin/e-smith/db configuration show mediawiki > /opt/MW_RPM_BACKUP/config.txt
    ;;
esac

%post

# General Information
/etc/e-smith/events/actions/initialize-default-databases
# General Information
APP=MediaWiki
URL=wiki
WORKDIR=/root
INSTALLDIR=/usr/share/doc/mediawiki-1.6.10/Sources
HTMLDIR=/opt/mediawiki
MYSQLDB=mediawiki
MYSQLUSER=mediawikiuser
MYSQLPASS=$(/sbin/e-smith/db configuration getprop mediawiki DbPassword)
DOMAIN=$(/sbin/e-smith/db configuration get DomainName)
SRVNAME=$(/sbin/e-smith/db configuration get SystemName)
UPDATE=$(ls /opt | grep -c mediawiki)
grep "LANG=" /etc/sysconfig/i18n > lang1
sed -e 's/LANG="//g' lang1 > lang2
sed -e 's/"//g' lang2 > lang
LANG=$(cat lang)
rm -rf lang*
#Untar application
echo "Decompressing files..."
mkdir -p $HTMLDIR
tar xzf $INSTALLDIR/mediawiki-1.6.10.tar.gz -C /opt
case $UPDATE in
   0) mv -f /opt/mediawiki-1.6.10/* $HTMLDIR ;;
   *) cp -ufR /opt/mediawiki-1.6.10/* $HTMLDIR --reply=yes ;;
esac
rm -rf /opt/mediawiki-1.6.10
cp $INSTALLDIR/sme.* $HTMLDIR/skins/common/images
#Prepare config settings
sed 's.mediawikipassword.'$MYSQLPASS'.g' $INSTALLDIR/LocalSettings.php > $HTMLDIR/LocalSettings.php
sed "s/mydomain/$DOMAIN/g" $HTMLDIR/LocalSettings.php > $HTMLDIR/LocalSettings2.php
case "$LANG" in
        de_DE) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "de";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
        es_ES) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "es";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
        fr_FR) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "fr";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
        it_IT) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "it";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
            *) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "en";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
esac
rm $HTMLDIR/LocalSettings2.php
cp $INSTALLDIR/PwAuthPlugin.php $HTMLDIR/extensions/PwAuthPlugin.php
#Creating SME-Groups for MediaWiki (disabled)
#/sbin/e-smith/db accounts set mw_read group
#/sbin/e-smith/db accounts setprop mw_read Description "MediaWiki Read" 
#/sbin/e-smith/db accounts set mw_edit group
#/sbin/e-smith/db accounts setprop mw_edit Description "MediaWiki Edit" 
#/sbin/e-smith/db accounts set mw_createpage group
#/sbin/e-smith/db accounts setprop mw_createpage Description "MediaWiki Create Page" 
#/sbin/e-smith/db accounts set mw_createtalk group
#/sbin/e-smith/db accounts setprop mw_createtalk Description "MediaWiki Create Talk" 
#/sbin/e-smith/signal-event group-create
#Changing some rights
chmod 644 $HTMLDIR/extensions/PwAuthPlugin.php
chown -R root:root $HTMLDIR
chown    root:www  $HTMLDIR/images
chown    root:www  $HTMLDIR/LocalSettings.php
chmod 775 $HTMLDIR/images
chmod 440 $HTMLDIR/LocalSettings.php
#Creating DataBase
echo "MySQL installation:"
case $UPDATE in
  0)
    echo "Creating MySQL User and DataBase..."
    mysqladmin -u root create $MYSQLDB
    mysql $MYSQLDB < $INSTALLDIR/$MYSQLDB.sql
    mysql -u root -e "SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD( '$MYSQLPASS' ) "
    mysqladmin flush-privileges
    ;;
  *)
    echo "Fixing MySQL rights..."
    mysql -u root -e "SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD( '$MYSQLPASS' ) "
    mysqladmin flush-privileges
    ;;
esac
# Rebuilding Wiki language menus
php $HTMLDIR/maintenance/rebuildMessages.php --rebuild
echo "Applying modifications to services..."
# Uncomment the PwAuth-function
sed 's.#!..g' $HTMLDIR/LocalSettings.php > $HTMLDIR/LocalSettings2.php
mv $HTMLDIR/LocalSettings2.php $HTMLDIR/LocalSettings.php
/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
/usr/local/bin/svc -h /service/httpd-e-smith
echo "-------------------------------------------------------------------------------"
case $UPDATE in
  0)
    echo "$APP Installation completed."
    echo "Reminder:"
    echo "- Website open globally"
    echo "- go to http://$DOMAIN/$URL"
    echo "- Usernames are identical with SME users"
    echo "- Passwords are identical with SME passwords"
    echo "- MediaWiki admin = SME admin"
    ;;
  *)
    echo "$APP update completed."
    echo "Reminder:"
    echo "- The old install was backed up and can be found in /opt/MW_RPM_BACKUP"
    echo "  PLEASE MOVE THIS DIRECTORY TO A SAFE PLACE!!!"
    echo "- Website open globally"
    echo "- go to http://$DOMAIN/$URL"
    echo "- Usernames are identical with SME users"
    echo "- Passwords are identical with SME passwords"
    echo "- MediaWiki admin = SME admin"
    ;;
esac
echo "-------------------------------------------------------------------------------"
echo "Following DB parameters are allowed:"
echo "    # config setprop $MYSQLDB HTTPS on/off"
echo "    # config setprop $MYSQLDB PublicAccess local/global"
echo " "
echo "Don't forget to apply modifications with following commands:"
echo "    # expand-template /etc/httpd/conf/httpd.conf"
echo "    # svc -h /service/httpd-e-smith"
echo " "
echo "For more details, see http://wiki.contribs.org/Mediawiki"
echo "-------------------------------------------------------------------------------"

%preun
INSTALLDIR=/usr/share/doc/mediawiki-1.6.10/Sources
if [ $1 = 0 ] ; then
  mv $INSTALLDIR/DO_NOT_USE_OR_DELETE/MW-Full-Uninstall.sh /root/
fi

%postun
if [ $1 = 0 ] ; then
  echo "Restarting services..."
  /sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
  /usr/local/bin/svc -h /service/httpd-e-smith
  echo " "
  echo "Uninstallation finished!"
  echo "If you want to completly remove it (installation files and MySQL user+database)"
  echo "please issue the following command at the prompt:"
  echo "# sh /root/MW-Full-Uninstall.sh"
fi

%files -f %{name}-%{version}-filelist

%defattr(-,root,root)
1	%define name smeserver-mediawiki
2	%define version 1.6.10
3	%define release 8
4	%define rpmver 4.0.4
5
6	Summary: Mediawiki Web Application for SME Server 7.x based on Mediawiki 1.6.10
7	Name: %{name}
8	Version: %{version}
9	Release: %{release}
10	License: GPL
11	Group: /Web/Applications
12	Source: %{name}-%{version}.tar.gz
13	Patch0: smeserver-mediawiki-1.6.10-1.patch
14	Packager: Dietmar Berteld <dietmar@berteld.com>
15	URL: http://mediawiki.org/
16	BuildRoot: /var/tmp/%{name}-%{version}-%{release}-buildroot
17	BuildArchitectures: noarch
18	Requires: e-smith-base, e-smith-release >= 7
19
20	%description
21	This RPM is an unofficial addon for the SME Server 7.x.
22	The target audience is the Linux/E-smith administrator
23	who wants to add Wikipedia-SW.
24	Mediawiki is a very popular Wiki and is used by the wikipedia-project.
25	After installation open your webbrowser your local site
26	http://your_e-smith-server_adress/wiki
27
28	%changelog
29	* Mon May 12 2008 Dietmar Berteld>
30	- [1.6.10-8] Adding PwAuth-function, SME users can login with their SME passwords
31	Automatic creation of a few default mw_groups and list them in the
32	configuration file as well so admins only need to add users to the proper
33	groups in the server-manager
34
35	* Thu Feb 26 2008 Dietmar Berteld>
36	- [1.6.10-7] Fixed httpd-settings for local access only
37
38	* Thu Oct 23 2007 Dietmar Berteld>
39	- [1.6.10-6] Fixed automated uninstall issue for MySQL-DB and MySQL-user
40
41	* Fri Oct 19 2007 Dietmar Berteld>
42	- [1.6.10-5] Fixed short URL's
43	- Improved Apache template for better security
44	- Improved integration in SME (PublicAccess local/global - global)
45
46	* Wed Oct 10 2007 Sylvain Gomez <sylvaingomez@free.fr>
47	- [1.6.10-4] Fixed short URL's
48	Fixed Apache restarting at the wrong time while uninstalling
49	Added missing MySQL User
50	Added automatic lang detection at install stage
51	Changed sme.png logo
52
53	* Wed Sep 05 2007 Dietmar Berteld <dietmar@berteld.com>
54	- [1.6.10-3] Simpler method to create MySQL-Datebase
55	Using short URL's
56
57	* Wed Apr 25 2007 Dietmar Berteld <dietmar@berteld.com>
58	- [1.6.10-2] Security Improvements (template, MySQL, directory-rights)
59	Thanks for the help to Sylvain Gomez <sylvain.gomez@free.fr>
60
61	* Thu Apr 12 2007 Dietmar Berteld <dietmar@berteld.com>
62	- [1.6.10-1] Initial version
63
64	%prep
65	rm -rf $RPM_BUILD_ROOT
66
67	%setup
68
69	%patch0 -p1
70
71	%build
72
73	%install
74	rm -rf $RPM_BUILD_ROOT
75	(cd root ; find . -depth -print \| cpio -dump $RPM_BUILD_ROOT)
76	rm -f %{name}-%{version}-filelist
77	/sbin/e-smith/genfilelist $RPM_BUILD_ROOT > %{name}-%{version}-filelist
78
79	%clean
80	rm -rf $RPM_BUILD_ROOT
81
82	%pre
83
84	UPDATE=$(ls /opt \| grep -c mediawiki)
85	case $UPDATE in
86	0)
87	echo "Installing MediaWiki... Please wait!"
88	;;
89	*)
90	echo "Updating MediaWiki... Please wait!"
91	mkdir -p /opt/MW_RPM_BACKUP
92	cd /opt
93	echo "Backing up installation files..."
94	tar -czf /opt/MW_RPM_BACKUP/mediawiki.tar.gz mediawiki
95	echo "Backing up MySQL database..."
96	mysqldump mediawiki > /opt/MW_RPM_BACKUP/mediawiki.sql
97	/sbin/e-smith/db configuration show mediawiki > /opt/MW_RPM_BACKUP/config.txt
98	;;
99	esac
100
101	%post
102
103	# General Information
104	/etc/e-smith/events/actions/initialize-default-databases
105	# General Information
106	APP=MediaWiki
107	URL=wiki
108	WORKDIR=/root
109	INSTALLDIR=/usr/share/doc/mediawiki-1.6.10/Sources
110	HTMLDIR=/opt/mediawiki
111	MYSQLDB=mediawiki
112	MYSQLUSER=mediawikiuser
113	MYSQLPASS=$(/sbin/e-smith/db configuration getprop mediawiki DbPassword)
114	DOMAIN=$(/sbin/e-smith/db configuration get DomainName)
115	SRVNAME=$(/sbin/e-smith/db configuration get SystemName)
116	UPDATE=$(ls /opt \| grep -c mediawiki)
117	grep "LANG=" /etc/sysconfig/i18n > lang1
118	sed -e 's/LANG="//g' lang1 > lang2
119	sed -e 's/"//g' lang2 > lang
120	LANG=$(cat lang)
121	rm -rf lang*
122	#Untar application
123	echo "Decompressing files..."
124	mkdir -p $HTMLDIR
125	tar xzf $INSTALLDIR/mediawiki-1.6.10.tar.gz -C /opt
126	case $UPDATE in
127	0) mv -f /opt/mediawiki-1.6.10/* $HTMLDIR ;;
128	) cp -ufR /opt/mediawiki-1.6.10/ $HTMLDIR --reply=yes ;;
129	esac
130	rm -rf /opt/mediawiki-1.6.10
131	cp $INSTALLDIR/sme.* $HTMLDIR/skins/common/images
132	#Prepare config settings
133	sed 's.mediawikipassword.'$MYSQLPASS'.g' $INSTALLDIR/LocalSettings.php > $HTMLDIR/LocalSettings.php
134	sed "s/mydomain/$DOMAIN/g" $HTMLDIR/LocalSettings.php > $HTMLDIR/LocalSettings2.php
135	case "$LANG" in
136	de_DE) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "de";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
137	es_ES) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "es";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
138	fr_FR) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "fr";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
139	it_IT) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "it";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
140	*) sed 's.$wgLanguageCode = "en";.$wgLanguageCode = "en";.g' $HTMLDIR/LocalSettings2.php > $HTMLDIR/LocalSettings.php ;;
141	esac
142	rm $HTMLDIR/LocalSettings2.php
143	cp $INSTALLDIR/PwAuthPlugin.php $HTMLDIR/extensions/PwAuthPlugin.php
144	#Creating SME-Groups for MediaWiki (disabled)
145	#/sbin/e-smith/db accounts set mw_read group
146	#/sbin/e-smith/db accounts setprop mw_read Description "MediaWiki Read"
147	#/sbin/e-smith/db accounts set mw_edit group
148	#/sbin/e-smith/db accounts setprop mw_edit Description "MediaWiki Edit"
149	#/sbin/e-smith/db accounts set mw_createpage group
150	#/sbin/e-smith/db accounts setprop mw_createpage Description "MediaWiki Create Page"
151	#/sbin/e-smith/db accounts set mw_createtalk group
152	#/sbin/e-smith/db accounts setprop mw_createtalk Description "MediaWiki Create Talk"
153	#/sbin/e-smith/signal-event group-create
154	#Changing some rights
155	chmod 644 $HTMLDIR/extensions/PwAuthPlugin.php
156	chown -R root:root $HTMLDIR
157	chown root:www $HTMLDIR/images
158	chown root:www $HTMLDIR/LocalSettings.php
159	chmod 775 $HTMLDIR/images
160	chmod 440 $HTMLDIR/LocalSettings.php
161	#Creating DataBase
162	echo "MySQL installation:"
163	case $UPDATE in
164	0)
165	echo "Creating MySQL User and DataBase..."
166	mysqladmin -u root create $MYSQLDB
167	mysql $MYSQLDB < $INSTALLDIR/$MYSQLDB.sql
168	mysql -u root -e "SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD( '$MYSQLPASS' ) "
169	mysqladmin flush-privileges
170	;;
171	*)
172	echo "Fixing MySQL rights..."
173	mysql -u root -e "SET PASSWORD FOR $MYSQLUSER@localhost = PASSWORD( '$MYSQLPASS' ) "
174	mysqladmin flush-privileges
175	;;
176	esac
177	# Rebuilding Wiki language menus
178	php $HTMLDIR/maintenance/rebuildMessages.php --rebuild
179	echo "Applying modifications to services..."
180	# Uncomment the PwAuth-function
181	sed 's.#!..g' $HTMLDIR/LocalSettings.php > $HTMLDIR/LocalSettings2.php
182	mv $HTMLDIR/LocalSettings2.php $HTMLDIR/LocalSettings.php
183	/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
184	/usr/local/bin/svc -h /service/httpd-e-smith
185	echo "-------------------------------------------------------------------------------"
186	case $UPDATE in
187	0)
188	echo "$APP Installation completed."
189	echo "Reminder:"
190	echo "- Website open globally"
191	echo "- go to http://$DOMAIN/$URL"
192	echo "- Usernames are identical with SME users"
193	echo "- Passwords are identical with SME passwords"
194	echo "- MediaWiki admin = SME admin"
195	;;
196	*)
197	echo "$APP update completed."
198	echo "Reminder:"
199	echo "- The old install was backed up and can be found in /opt/MW_RPM_BACKUP"
200	echo " PLEASE MOVE THIS DIRECTORY TO A SAFE PLACE!!!"
201	echo "- Website open globally"
202	echo "- go to http://$DOMAIN/$URL"
203	echo "- Usernames are identical with SME users"
204	echo "- Passwords are identical with SME passwords"
205	echo "- MediaWiki admin = SME admin"
206	;;
207	esac
208	echo "-------------------------------------------------------------------------------"
209	echo "Following DB parameters are allowed:"
210	echo " # config setprop $MYSQLDB HTTPS on/off"
211	echo " # config setprop $MYSQLDB PublicAccess local/global"
212	echo " "
213	echo "Don't forget to apply modifications with following commands:"
214	echo " # expand-template /etc/httpd/conf/httpd.conf"
215	echo " # svc -h /service/httpd-e-smith"
216	echo " "
217	echo "For more details, see http://wiki.contribs.org/Mediawiki"
218	echo "-------------------------------------------------------------------------------"
219
220	%preun
221	INSTALLDIR=/usr/share/doc/mediawiki-1.6.10/Sources
222	if [ $1 = 0 ] ; then
223	mv $INSTALLDIR/DO_NOT_USE_OR_DELETE/MW-Full-Uninstall.sh /root/
224	fi
225
226	%postun
227	if [ $1 = 0 ] ; then
228	echo "Restarting services..."
229	/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
230	/usr/local/bin/svc -h /service/httpd-e-smith
231	echo " "
232	echo "Uninstallation finished!"
233	echo "If you want to completly remove it (installation files and MySQL user+database)"
234	echo "please issue the following command at the prompt:"
235	echo "# sh /root/MW-Full-Uninstall.sh"
236	fi
237
238	%files -f %{name}-%{version}-filelist
239
240	%defattr(-,root,root)