smeserver-phpmyadmin-multiuser/contribs7/smeserver-phpmyadmin-multiuser.spec

# $Id$
# Authority: nocvs
# Name: Michel Van hees

Summary: PhpMyAdmin for SME server
%define name smeserver-phpmyadmin-multiuser
Name: %{name}
%define version 2.11.3
%define release 1
Version: %{version}
Release: %{release}%{?dist}
License: Freely distributable
Group: Apache
Source: %{name}-%{version}.tar.gz
#Patch0: %{name}-%{version}.patch.yyyymmddnn
BuildRoot: /var/tmp/e-smith-buildroot
BuildRequires: e-smith-devtools
BuildArchitectures: noarch
Requires: smeserver-release >= 7
AutoReqProv: no

%changelog
* Wed Dec  13 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.11.3

* Fri Nov  23 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.11.2.2

* Tue Nov  13 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.11.2.1
 
* Mon Oct  29 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.11.2

* Mon Oct  22 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phmyadmin 2.11.1.2

* Sat Sep  22 2007 Michel Van hees <michel@vanhees.cc>
- Update contrib to phpmyadmin 2.11.1

* Mon Aug  27 2007 Michel Van hees <michel@vanhees.cc>
- Update contrib to phpmyadmin 2.11.0
- Add all available themes

* Wed Jul  25 2007 Michel Van hees <michel@vanhees.cc>
- Update contrib to phpmyadmin 2.10.3

* Mon Jun  18 2007 Michel Van hees <michel@vanhees.cc>
- Update contrib to phpmyadmin 2.10.2
- Adding redirection from http to https
- Securing httpd.conf configuration
- Adding ability to limit access to internal network - That's the default option!

* Thu May  24 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.10.1

* Sun Mar  04 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.10.0.2

* Thu Jan  18 2007 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.9.2

* Wed Jan  10 2007 Michel Van hees <michel@vanhees.cc>
- Template move

* Mon Nov  20 2006 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.9.1.1

* Fri Nov  17 2006 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin 2.9.1

* Fri Nov  03 2006 Michel Van hees <michel@vanhees.cc>
- update contrib to phpmyadmin version 2.9.0.3

* Sun Oct  29 2006 Michel Van hees <michel@vanhees.cc>
- update contrib to last version of phpmyadmin

* Sat Jun  06 2006 Michel Van hees <mvanhees@vanhees.homeip.net>
- initial release

%description
SME server - phpmyadmin multiuser for smeserver

%prep
%setup
#%patch0 -p1
#%patch1 -p1

%build
perl createlinks

%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
echo "%doc COPYING"          >> %{name}-%{version}-filelist

%clean 
rm -rf $RPM_BUILD_ROOT

%pre
/sbin/e-smith/db accounts set phpmyadminmulti reserved

%preun

%post
/sbin/e-smith/db configuration set phpmyadminmulti service
/sbin/e-smith/db configuration setprop phpmyadminmulti access private

/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
service httpd-e-smith sigusr1

if [ $1 = 1 ] ; then
  mysql --execute="grant all privileges on *.* to admin@localhost identified by 'admin' WITH GRANT OPTION"
  mysql --execute="flush privileges"
fi

case "${LANG:0:2}" in
    fr)
        echo ""
        echo "Vous pouvez maintenant acceder à phpmyadmin via un browser web de la maniere suivante https://nom_server/myadmin"
        echo "Vous pourrez vous loger sous admin avec comme mot de pass admin. N'oublier pas de le changer!"
        echo "Si vous mettez à jour une version 2.1 ou supérieur, le mot de passe admin n'aura pas changer!"
        echo ""
        echo "Attention !!!!!"
        echo "PHPMyadmin est limité en accès au réseau interne, donc pas depuis internet"
        echo "Vous pouvez changer cette option avec les commandes :"
        echo "db configuration setprop phpmyadminmulti access public"
        echo "signal-events console-save"
        echo ""
    ;;
    *)
        echo ""
        echo "Now you can access phpmyadmin though your browser at  https://server_name/myadmin"
        echo "You can connect using login admin and password admin. Don't forget to change it"
        echo "If you update a 2.1 version of this contribs, admin password don't change!"
        echo ""
        echo "BEWARE !!!"
        echo "PHPMyadmin is now limited to internal network, so it couldn't be access from internet"
        echo "You can change this with the following command :"
        echo "db configuration setprop phpmyadminmulti access public"
        echo "signal-events console-save"
        echo ""
    ;;
esac

%postun
/sbin/e-smith/db configuration delete phpmyadminmulti
/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
/sbin/e-smith/db accounts delete phpmyadminmulti
service httpd-e-smith sigusr1
if [ $1 = 0 ] ; then
  mysql --execute="delete from mysql.user where User='admin'"
  mysql --execute="flush privileges"
fi

%files -f %{name}-%{version}-filelist
%defattr(-,root,root)
1	slords	1.2	# $Id$
2			# Authority: nocvs
3			# Name: Michel Van hees
4
5	slords	1.1	Summary: PhpMyAdmin for SME server
6			%define name smeserver-phpmyadmin-multiuser
7			Name: %{name}
8			%define version 2.11.3
9			%define release 1
10			Version: %{version}
11			Release: %{release}%{?dist}
12			License: Freely distributable
13			Group: Apache
14			Source: %{name}-%{version}.tar.gz
15			#Patch0: %{name}-%{version}.patch.yyyymmddnn
16			BuildRoot: /var/tmp/e-smith-buildroot
17			BuildRequires: e-smith-devtools
18			BuildArchitectures: noarch
19			Requires: smeserver-release >= 7
20			AutoReqProv: no
21
22			%changelog
23			* Wed Dec 13 2007 Michel Van hees <michel@vanhees.cc>
24			- update contrib to phpmyadmin 2.11.3
25
26			* Fri Nov 23 2007 Michel Van hees <michel@vanhees.cc>
27			- update contrib to phpmyadmin 2.11.2.2
28
29			* Tue Nov 13 2007 Michel Van hees <michel@vanhees.cc>
30			- update contrib to phpmyadmin 2.11.2.1
31
32			* Mon Oct 29 2007 Michel Van hees <michel@vanhees.cc>
33			- update contrib to phpmyadmin 2.11.2
34
35			* Mon Oct 22 2007 Michel Van hees <michel@vanhees.cc>
36			- update contrib to phmyadmin 2.11.1.2
37
38			* Sat Sep 22 2007 Michel Van hees <michel@vanhees.cc>
39			- Update contrib to phpmyadmin 2.11.1
40
41			* Mon Aug 27 2007 Michel Van hees <michel@vanhees.cc>
42			- Update contrib to phpmyadmin 2.11.0
43			- Add all available themes
44
45			* Wed Jul 25 2007 Michel Van hees <michel@vanhees.cc>
46			- Update contrib to phpmyadmin 2.10.3
47
48			* Mon Jun 18 2007 Michel Van hees <michel@vanhees.cc>
49			- Update contrib to phpmyadmin 2.10.2
50			- Adding redirection from http to https
51			- Securing httpd.conf configuration
52			- Adding ability to limit access to internal network - That's the default option!
53
54			* Thu May 24 2007 Michel Van hees <michel@vanhees.cc>
55			- update contrib to phpmyadmin 2.10.1
56
57			* Sun Mar 04 2007 Michel Van hees <michel@vanhees.cc>
58			- update contrib to phpmyadmin 2.10.0.2
59
60			* Thu Jan 18 2007 Michel Van hees <michel@vanhees.cc>
61			- update contrib to phpmyadmin 2.9.2
62
63			* Wed Jan 10 2007 Michel Van hees <michel@vanhees.cc>
64			- Template move
65
66			* Mon Nov 20 2006 Michel Van hees <michel@vanhees.cc>
67			- update contrib to phpmyadmin 2.9.1.1
68
69			* Fri Nov 17 2006 Michel Van hees <michel@vanhees.cc>
70			- update contrib to phpmyadmin 2.9.1
71
72			* Fri Nov 03 2006 Michel Van hees <michel@vanhees.cc>
73			- update contrib to phpmyadmin version 2.9.0.3
74
75			* Sun Oct 29 2006 Michel Van hees <michel@vanhees.cc>
76			- update contrib to last version of phpmyadmin
77
78			* Sat Jun 06 2006 Michel Van hees <mvanhees@vanhees.homeip.net>
79			- initial release
80
81			%description
82			SME server - phpmyadmin multiuser for smeserver
83
84			%prep
85			%setup
86			#%patch0 -p1
87			#%patch1 -p1
88
89			%build
90			perl createlinks
91
92			%install
93			rm -rf $RPM_BUILD_ROOT
94			(cd root ; find . -depth -print \| cpio -dump $RPM_BUILD_ROOT)
95			rm -f %{name}-%{version}-filelist
96			/sbin/e-smith/genfilelist $RPM_BUILD_ROOT > %{name}-%{version}-filelist
97			echo "%doc COPYING" >> %{name}-%{version}-filelist
98
99			%clean
100			rm -rf $RPM_BUILD_ROOT
101
102			%pre
103			/sbin/e-smith/db accounts set phpmyadminmulti reserved
104
105			%preun
106
107			%post
108			/sbin/e-smith/db configuration set phpmyadminmulti service
109			/sbin/e-smith/db configuration setprop phpmyadminmulti access private
110
111			/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
112			service httpd-e-smith sigusr1
113
114			if [ $1 = 1 ] ; then
115			mysql --execute="grant all privileges on . to admin@localhost identified by 'admin' WITH GRANT OPTION"
116			mysql --execute="flush privileges"
117			fi
118
119			case "${LANG:0:2}" in
120			fr)
121			echo ""
122			echo "Vous pouvez maintenant acceder à phpmyadmin via un browser web de la maniere suivante https://nom_server/myadmin"
123			echo "Vous pourrez vous loger sous admin avec comme mot de pass admin. N'oublier pas de le changer!"
124			echo "Si vous mettez à jour une version 2.1 ou supérieur, le mot de passe admin n'aura pas changer!"
125			echo ""
126			echo "Attention !!!!!"
127			echo "PHPMyadmin est limité en accès au réseau interne, donc pas depuis internet"
128			echo "Vous pouvez changer cette option avec les commandes :"
129			echo "db configuration setprop phpmyadminmulti access public"
130			echo "signal-events console-save"
131			echo ""
132			;;
133			*)
134			echo ""
135			echo "Now you can access phpmyadmin though your browser at https://server_name/myadmin"
136			echo "You can connect using login admin and password admin. Don't forget to change it"
137			echo "If you update a 2.1 version of this contribs, admin password don't change!"
138			echo ""
139			echo "BEWARE !!!"
140			echo "PHPMyadmin is now limited to internal network, so it couldn't be access from internet"
141			echo "You can change this with the following command :"
142			echo "db configuration setprop phpmyadminmulti access public"
143			echo "signal-events console-save"
144			echo ""
145			;;
146			esac
147
148			%postun
149			/sbin/e-smith/db configuration delete phpmyadminmulti
150			/sbin/e-smith/expand-template /etc/httpd/conf/httpd.conf
151			/sbin/e-smith/db accounts delete phpmyadminmulti
152			service httpd-e-smith sigusr1
153			if [ $1 = 0 ] ; then
154			mysql --execute="delete from mysql.user where User='admin'"
155			mysql --execute="flush privileges"
156			fi
157
158			%files -f %{name}-%{version}-filelist
159			%defattr(-,root,root)