+# TODO
+# - add codepress (http://codepress.org/index.php) patch
+# - use system jquery (js/jquery), tcpdf (libraries/tcpdf) and php-gettext (libraries/gettext)
Summary: phpMyAdmin - web-based MySQL administration
-Summary(pl): phpMyAdmin - administracja bazami MySQL przez WWW
+Summary(pl.UTF-8): phpMyAdmin - administracja bazami MySQL przez WWW
Name: phpMyAdmin
-Version: 2.7.0
-%define _pl pl2
-# release 1 is for Ra
-%define _rel 2
-Release: %{_pl}.%{_rel}
+Version: 4.0.8
+Release: 1
License: GPL v2
Group: Applications/Databases/Interfaces
-Source0: http://dl.sourceforge.net/phpmyadmin/%{name}-%{version}-%{_pl}.tar.bz2
-# Source0-md5: 19a46b06254276f4e7c3803ea2d9b335
-#Source0: http://dl.sourceforge.net/phpmyadmin/%{name}-%{version}.tar.bz2
-Source1: %{name}.conf
+Source0: http://downloads.sourceforge.net/phpmyadmin/%{name}-%{version}-all-languages.tar.xz
+# Source0-md5: c99d13b84b57bd1d97149a60f775bb4e
+Source1: %{name}-apache.conf
+Source2: %{name}-lighttpd.conf
+Source3: %{name}-httpd.conf
Patch0: %{name}-config.patch
+Patch1: %{name}-ServerSelectDisplayName.patch
+Patch2: %{name}-ServerSelectDisplayName-config.patch
URL: http://www.phpmyadmin.net/
-Requires(triggerpostun): sed >= 4.0
-Requires: php
-Requires: php-mysql
-Requires: php-pcre
+BuildRequires: rpmbuild(macros) >= 1.268
+BuildRequires: tar >= 1:1.22
+BuildRequires: xz
+Requires: php(core) >= 5.2
+Requires: php(ctype)
+Requires: php(filter)
+Requires: php(json)
+Requires: php(mbstring)
+Requires: php(mcrypt)
+Requires: php(mysql)
+Requires: php(pcre)
+Requires: php(session)
+Requires: php(simplexml)
Requires: webapps
-#Suggests: php-mbstring
+Requires: webserver(access)
+Requires: webserver(alias)
+Requires(triggerpostun): sed >= 4.0
+Suggests: php-mysqli
+Suggests: webserver(indexfile)
+Suggests: webserver(php)
+Conflicts: apache-base < 2.4.0-1
BuildArch: noarch
BuildRoot: %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
-%define _appdir %{_datadir}/%{name}
+%define _appdir %{_datadir}/%{name}
%define _webapps /etc/webapps
%define _webapp %{name}
%define _sysconfdir %{_webapps}/%{_webapp}
- create (*) and read dumps of tables
- export (*) and import data to CSV values
- administer multiple servers and single databases
-- communicate in more than 20 different languages
-
-%description -l pl
-phpMyAdmin potrafi zarz±dzaæ ca³ymi bazami MySQL (potrzebne
-uprawnienia superu¿ytkownika) jak i pojedynczymi bazami danych.
-Potrzebny jest u¿ytkownik, który ma prawa zapisu/odczytu tylko tych
-baz, którymi chcemy administrowaæ (wiêcej informacji w odpowiedniej
-podrêcznika MySQL). Aktualnie phpMyAdmin potrafi:
-- tworzyæ i usuwaæ bazy
-- wykonywaæ create, copy, drop oraz alter na tabelach
-- dodawaæ, usuwaæ i modyfikowaæ pola
-- wykonywaæ dowolne zapytania SQL
-- zarz±dzaæ kluczami na rekordach
-- wczytywaæ tekst z plików do tabel
-- obs³ugiwaæ ponad 20 jêzyków
-- zarz±dzaæ wieloma serwerami i pojedynczymi bazami danych
-- eksportowaæ i importowaæ dane do warto¶ci CSV
-- tworzyæ i czytaæ zrzuty tabel
+- check referencial integrity
+- create complex queries automatically connecting required tables
+- create PDF graphics of your database layout
+- communicate in more than 50 different languages
+
+%description -l pl.UTF-8
+phpMyAdmin potrafi zarządzać całymi bazami MySQL (potrzebne
+uprawnienia superużytkownika) jak i pojedynczymi bazami danych.
+Potrzebny jest użytkownik, który ma prawa zapisu/odczytu tylko tych
+baz, którymi chcemy administrować (więcej informacji w odpowiedniej
+podręcznika MySQL). Aktualnie phpMyAdmin potrafi:
+- tworzyć i usuwać bazy
+- wykonywać create, copy, drop oraz alter na tabelach
+- dodawać, usuwać i modyfikować pola
+- wykonywać dowolne zapytania SQL
+- zarządzać kluczami na rekordach
+- wczytywać tekst z plików do tabel
+- obsługiwać ponad 20 języków
+- zarządzać wieloma serwerami i pojedynczymi bazami danych
+- eksportować i importować dane do wartości CSV
+- tworzyć i czytać zrzuty tabel
%prep
-%setup -q -n %{name}-%{version}-%{_pl}
-%patch -p1
+%setup -q -n %{name}-%{version}-all-languages
+%patch0 -p1
+%patch1 -p0
+%patch2 -p0
%install
rm -rf $RPM_BUILD_ROOT
-install -d $RPM_BUILD_ROOT{%{_sysconfdir},%{_appdir}/{css,lang,libraries/{auth,export,dbg,dbi,transformations}}}
-
-install *.php *.html *.css $RPM_BUILD_ROOT%{_appdir}
-install lang/*.php $RPM_BUILD_ROOT%{_appdir}/lang
-cp -rf themes $RPM_BUILD_ROOT%{_appdir}
-install css/* $RPM_BUILD_ROOT%{_appdir}/css
-install libraries/*.{js,php} $RPM_BUILD_ROOT%{_appdir}/libraries
-install libraries/auth/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/auth
-install libraries/export/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/export
-install libraries/dbg/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/dbg
-install libraries/dbi/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/dbi
-install libraries/transformations/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/transformations
-
-install config.default.php $RPM_BUILD_ROOT%{_sysconfdir}/config.inc.php
+install -d $RPM_BUILD_ROOT{%{_sysconfdir},%{_appdir}}
+
+install *.php *.css favicon.ico robots.txt $RPM_BUILD_ROOT%{_appdir}
+cp -a locale themes js libraries $RPM_BUILD_ROOT%{_appdir}
+
+install libraries/config.default.php $RPM_BUILD_ROOT%{_sysconfdir}/config.inc.php
ln -sf %{_sysconfdir}/config.inc.php $RPM_BUILD_ROOT%{_appdir}/config.inc.php
install %{SOURCE1} $RPM_BUILD_ROOT%{_sysconfdir}/httpd.conf
-install %{SOURCE1} $RPM_BUILD_ROOT%{_sysconfdir}/apache.conf
+install %{SOURCE3} $RPM_BUILD_ROOT%{_sysconfdir}/apache.conf
+install %{SOURCE2} $RPM_BUILD_ROOT%{_sysconfdir}/lighttpd.conf
%clean
rm -rf $RPM_BUILD_ROOT
-%triggerin -- apache1
+%triggerin -- apache1 < 1.3.37-3, apache1-base
%webapp_register apache %{_webapp}
-%triggerun -- apache1
+%triggerun -- apache1 < 1.3.37-3, apache1-base
%webapp_unregister apache %{_webapp}
-%triggerin -- apache >= 2.0.0
+%triggerin -- apache-base
%webapp_register httpd %{_webapp}
-%triggerun -- apache >= 2.0.0
+%triggerun -- apache-base
%webapp_unregister httpd %{_webapp}
-%triggerpostun -- phpMyAdmin <= 2.5.3-2
-for i in `grep -lr "/home/\(services/\)*httpd/html/myadmin" /etc/httpd/*`; do
- cp $i $i.backup
- sed -i -e "s#/home/httpd/html/myadmin#%{_appdir}#g" $i
- sed -i -e "s#/home/services/httpd/html/myadmin#%{_appdir}#g" $i
- echo "File changed by trigger: $i (backup: $i.backup)"
-done
-
-%triggerpostun -- %{name} < 2.7.0-pl1.2.5
-# rescue app config from various old locations
-if [ -f /home/services/httpd/html/myadmin/config.inc.php.rpmsave ]; then
- mv -f %{_sysconfdir}/config.inc.php{,.rpmnew}
- mv -f /home/services/httpd/html/myadmin/config.inc.php.rpmsav %{_sysconfdir}/config.inc.php
-fi
-if [ -f /home/httpd/html/myadmin/config.inc.php.rpmsave ]; then
- mv -f %{_sysconfdir}/config.inc.php{,.rpmnew}
- mv -f /home/httpd/html/myadmin/config.inc.php.rpmsave %{_sysconfdir}/config.inc.php
-fi
-if [ -f /etc/%{name}/config.inc.php.rpmsave ]; then
- mv -f %{_sysconfdir}/config.inc.php{,.rpmnew}
- mv -f /etc/%{name}/config.inc.php.rpmsave %{_sysconfdir}/config.inc.php
-fi
-
-# nuke very-old config location (this mostly for Ra)
-if [ -f /etc/httpd/httpd.conf ]; then
- sed -i -e "/^Include.*%{name}.conf/d" /etc/httpd/httpd.conf
-fi
-
-# migrate from httpd (apache2) config dir
-if [ -f /etc/httpd/%{name}.conf.rpmsave ]; then
- cp -f %{_sysconfdir}/httpd.conf{,.rpmnew}
- mv -f /etc/httpd/%{name}.conf.rpmsave %{_sysconfdir}/httpd.conf
-fi
-
-rm -f /etc/httpd/httpd.conf/99_%{name}.conf
-/usr/sbin/webapp register httpd %{_webapp}
-if [ -f /var/lock/subsys/httpd ]; then
- /etc/rc.d/init.d/httpd reload 1>&2
-fi
+%triggerin -- lighttpd
+%webapp_register lighttpd %{_webapp}
+
+%triggerun -- lighttpd
+%webapp_unregister lighttpd %{_webapp}
%files
%defattr(644,root,root,755)
-%doc Documentation.* CREDITS ChangeLog INSTALL README TODO translators.html scripts
+%doc ChangeLog README
%dir %attr(750,root,http) %{_sysconfdir}
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/apache.conf
%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/httpd.conf
+%attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/lighttpd.conf
%attr(640,root,http) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/*.php
%dir %{_appdir}
-%{_appdir}/css
-%{_appdir}/themes
-%{_appdir}/lang
+%{_appdir}/js
%{_appdir}/libraries
+%{_appdir}/locale
+%{_appdir}/themes
%{_appdir}/*.css
-%{_appdir}/*.html
%{_appdir}/*.php
+%{_appdir}/favicon.ico
+%{_appdir}/robots.txt