current/SPECS/phpmyadmin.spec

%define rname phpMyAdmin

Summary:        Handles the administration of MySQL over the web
Name:           phpmyadmin
Version:        3.5.3
Release:        %mkrel 3
License:        GPLv2
Group:          System/Servers
URL:            http://www.phpmyadmin.net/
Source0:        http://prdownloads.sourceforge.net/phpmyadmin/%{rname}-%{version}-all-languages.tar.xz
Source1:        phpmyadmin-16x16.png
Source2:        phpmyadmin-32x32.png
Source3:        phpmyadmin-48x48.png
Requires:       apache-mod_php
Requires:       php-mysqli
Requires:       php-mbstring
Requires:       php-mcrypt
BuildArch:      noarch
Obsoletes:      phpMyAdmin

%description
phpMyAdmin is intended to handle the administration of MySQL over the web.
Currently it can : create and drop databases, create, copy, drop and alter
tables, delete, edit and add fields, execute any SQL-statement, even
batch-queries, manage keys on fields, load text files into tables, create and
read dumps of tables, export data to CSV value, administer multiple servers
and single databases.

%prep
%setup -q -n %{rname}-%{version}-all-languages

%build

%install
export DONT_RELINK=1

install -d %{buildroot}%{_sysconfdir}/%{name}
install -d %{buildroot}%{_datadir}/%{name}

cp -aRf * %{buildroot}%{_datadir}/%{name}/

# cleanup
pushd %{buildroot}%{_datadir}/%{name}
    rm -f CREDITS ChangeLog Documentation.txt INSTALL LICENSE README 
    rm -f README.VENDOR RELEASE-DATE-* TODO
    rm -rf scripts
    rm -rf contrib
    rm -f lang/*.sh libraries/transformations/*.sh
    find -name "\.htaccess" | xargs rm -f
popd

# fix config file location
mv %{buildroot}%{_datadir}/%{name}/config.sample.inc.php \
    %{buildroot}%{_sysconfdir}/%{name}/config.php

pushd  %{buildroot}%{_datadir}/%{name}
    ln -s %{_sysconfdir}/%{name}/config.php config.inc.php
popd
chmod 640 %{buildroot}%{_sysconfdir}/%{name}/config.php

cat > README.urpmi << EOF
The actual configuration file is /etc/phpmyadmin/config.php.
The config.default.inc.php file contains default values, and is not supposed to 
be modified.
EOF

install -d -m 755 %{buildroot}%{_webappconfdir}
cat > %{buildroot}%{_webappconfdir}/%{name}.conf << EOF
Alias /%{name} %{_datadir}/%{name}

<Directory %{_datadir}/%{name}>
    Require local granted
    ErrorDocument 403 "Access denied per %{_webappconfdir}/%{name}.conf"

    php_flag session.auto_start 0
</Directory>

<Directory %{_datadir}/%{name}/libraries>
    Require all denied
</Directory>
EOF

# new Icons
install -d %{buildroot}%{_iconsdir}
install -d %{buildroot}%{_miconsdir}
install -d %{buildroot}%{_liconsdir}

install -m0644 %{SOURCE1} %{buildroot}%{_miconsdir}/%{name}.png
install -m0644 %{SOURCE2} %{buildroot}%{_iconsdir}/%{name}.png
install -m0644 %{SOURCE3} %{buildroot}%{_liconsdir}/%{name}.png

# install menu entry.
# XDG menu
install -d %{buildroot}%{_datadir}/applications
cat > %{buildroot}%{_datadir}/applications/%{_real_vendor}-%{name}.desktop << EOF
[Desktop Entry]
Name=phpMyAdmin
Comment=%{summary}
Exec=%{_bindir}/www-browser http://localhost/%{name}/
Icon=%{name}
Terminal=false
Type=Application
Categories=X-MandrivaLinux-MoreApplications-Databases;
EOF

# fix borked permissions
find %{buildroot}%{_datadir}/%{name} -type d -exec chmod 755 {} \;
find %{buildroot}%{_datadir}/%{name} -type f -exec chmod 644 {} \;

%pretrans
# fix configuration file name change
if [ -f %{_sysconfdir}/phpmyadmin/config.default.php ]; then
    mv %{_sysconfdir}/phpmyadmin/config.default.php \
        %{_sysconfdir}/phpmyadmin/config.php
fi
if [ -L /var/www/phpmyadmin/libraries/config.default.php ]; then
    rm -f /var/www/phpmyadmin/libraries/config.default.php
fi
if [ -L %{_datadir}/phpmyadmin/libraries/config.default.php ]; then
    rm -f %{_datadir}/phpmyadmin/libraries/config.default.php
fi

%post
# generate random secret
secret=%_get_password 46

# blowfish secret
perl -pi \
    -e "s|\\\$cfg\\['blowfish_secret'\\] = ''|\\\$cfg\\['blowfish_secret'\\] = '$secret'|" \
    %{_sysconfdir}/%{name}/config.php

%clean

%files
%doc ChangeLog Documentation.txt LICENSE README RELEASE-DATE-* README.urpmi
%config(noreplace) %{webappconfdir}/%{name}.conf
%dir %{_sysconfdir}/%{name}
%attr(-,root,apache) %config(noreplace) %{_sysconfdir}/%{name}/config.php
%{_datadir}/%{name}
%{_iconsdir}/%{name}.png
%{_miconsdir}/%{name}.png
%{_liconsdir}/%{name}.png
%{_datadir}/applications/*.desktop
1	ennael	67657	%define rname phpMyAdmin
2
3			Summary: Handles the administration of MySQL over the web
4			Name: phpmyadmin
5	zezinho	304499	Version: 3.5.3
6	tmb	306855	Release: %mkrel 3
7	ennael	67657	License: GPLv2
8			Group: System/Servers
9			URL: http://www.phpmyadmin.net/
10	fwang	117607	Source0: http://prdownloads.sourceforge.net/phpmyadmin/%{rname}-%{version}-all-languages.tar.xz
11	ennael	67657	Source1: phpmyadmin-16x16.png
12			Source2: phpmyadmin-32x32.png
13			Source3: phpmyadmin-48x48.png
14			Requires: apache-mod_php
15	zezinho	262522	Requires: php-mysqli
16	ennael	67657	Requires: php-mbstring
17			Requires: php-mcrypt
18			BuildArch: noarch
19			Obsoletes: phpMyAdmin
20
21			%description
22			phpMyAdmin is intended to handle the administration of MySQL over the web.
23			Currently it can : create and drop databases, create, copy, drop and alter
24			tables, delete, edit and add fields, execute any SQL-statement, even
25			batch-queries, manage keys on fields, load text files into tables, create and
26			read dumps of tables, export data to CSV value, administer multiple servers
27			and single databases.
28
29			%prep
30			%setup -q -n %{rname}-%{version}-all-languages
31
32			%build
33
34			%install
35			export DONT_RELINK=1
36
37			install -d %{buildroot}%{_sysconfdir}/%{name}
38			install -d %{buildroot}%{_datadir}/%{name}
39
40			cp -aRf * %{buildroot}%{_datadir}/%{name}/
41
42			# cleanup
43			pushd %{buildroot}%{_datadir}/%{name}
44			rm -f CREDITS ChangeLog Documentation.txt INSTALL LICENSE README
45			rm -f README.VENDOR RELEASE-DATE-* TODO
46			rm -rf scripts
47			rm -rf contrib
48			rm -f lang/.sh libraries/transformations/.sh
49			find -name "\.htaccess" \| xargs rm -f
50			popd
51
52			# fix config file location
53			mv %{buildroot}%{_datadir}/%{name}/config.sample.inc.php \
54			%{buildroot}%{_sysconfdir}/%{name}/config.php
55
56			pushd %{buildroot}%{_datadir}/%{name}
57			ln -s %{_sysconfdir}/%{name}/config.php config.inc.php
58			popd
59			chmod 640 %{buildroot}%{_sysconfdir}/%{name}/config.php
60
61			cat > README.urpmi << EOF
62			The actual configuration file is /etc/phpmyadmin/config.php.
63			The config.default.inc.php file contains default values, and is not supposed to
64			be modified.
65			EOF
66
67	guillomovitch	291120	install -d -m 755 %{buildroot}%{_webappconfdir}
68			cat > %{buildroot}%{_webappconfdir}/%{name}.conf << EOF
69	ennael	67657	Alias /%{name} %{_datadir}/%{name}
70
71			<Directory %{_datadir}/%{name}>
72	guillomovitch	291120	Require local granted
73			ErrorDocument 403 "Access denied per %{_webappconfdir}/%{name}.conf"
74	ennael	67657
75			php_flag session.auto_start 0
76			</Directory>
77
78			<Directory %{_datadir}/%{name}/libraries>
79	guillomovitch	291120	Require all denied
80	ennael	67657	</Directory>
81			EOF
82
83	ennael	71888	# new Icons
84	ennael	67657	install -d %{buildroot}%{_iconsdir}
85			install -d %{buildroot}%{_miconsdir}
86			install -d %{buildroot}%{_liconsdir}
87
88			install -m0644 %{SOURCE1} %{buildroot}%{_miconsdir}/%{name}.png
89			install -m0644 %{SOURCE2} %{buildroot}%{_iconsdir}/%{name}.png
90			install -m0644 %{SOURCE3} %{buildroot}%{_liconsdir}/%{name}.png
91
92			# install menu entry.
93			# XDG menu
94			install -d %{buildroot}%{_datadir}/applications
95	wally	91807	cat > %{buildroot}%{_datadir}/applications/%{_real_vendor}-%{name}.desktop << EOF
96	ennael	67657	[Desktop Entry]
97			Name=phpMyAdmin
98			Comment=%{summary}
99			Exec=%{_bindir}/www-browser http://localhost/%{name}/
100			Icon=%{name}
101			Terminal=false
102			Type=Application
103			Categories=X-MandrivaLinux-MoreApplications-Databases;
104			EOF
105
106			# fix borked permissions
107			find %{buildroot}%{_datadir}/%{name} -type d -exec chmod 755 {} \;
108			find %{buildroot}%{_datadir}/%{name} -type f -exec chmod 644 {} \;
109
110			%pretrans
111			# fix configuration file name change
112			if [ -f %{_sysconfdir}/phpmyadmin/config.default.php ]; then
113			mv %{_sysconfdir}/phpmyadmin/config.default.php \
114			%{_sysconfdir}/phpmyadmin/config.php
115			fi
116			if [ -L /var/www/phpmyadmin/libraries/config.default.php ]; then
117			rm -f /var/www/phpmyadmin/libraries/config.default.php
118			fi
119			if [ -L %{_datadir}/phpmyadmin/libraries/config.default.php ]; then
120			rm -f %{_datadir}/phpmyadmin/libraries/config.default.php
121			fi
122
123			%post
124			# generate random secret
125			secret=%_get_password 46
126
127			# blowfish secret
128			perl -pi \
129			-e "s\|\\\$cfg\\['blowfish_secret'\\] = ''\|\\\$cfg\\['blowfish_secret'\\] = '$secret'\|" \
130			%{_sysconfdir}/%{name}/config.php
131
132			%clean
133
134			%files
135	zezinho	230515	%doc ChangeLog Documentation.txt LICENSE README RELEASE-DATE-* README.urpmi
136	ennael	67657	%config(noreplace) %{webappconfdir}/%{name}.conf
137			%dir %{_sysconfdir}/%{name}
138			%attr(-,root,apache) %config(noreplace) %{_sysconfdir}/%{name}/config.php
139			%{_datadir}/%{name}
140			%{_iconsdir}/%{name}.png
141			%{_miconsdir}/%{name}.png
142			%{_liconsdir}/%{name}.png
143			%{_datadir}/applications/*.desktop