1 Summary: phpMyAdmin - web-based MySQL administration
2 Summary(pl): phpMyAdmin - administracja bazami MySQL przez WWW
7 Group: Applications/Databases/Interfaces
8 Source0: http://dl.sourceforge.net/phpmyadmin/%{name}-%{version}.tar.bz2
9 # Source0-md5: 87ee2e17c9381e969c8f740242220e29
11 Patch0: %{name}-config.patch
12 URL: http://www.phpmyadmin.net/
13 BuildRequires: rpmbuild(macros) >= 1.268
14 Requires(triggerpostun): sed >= 4.0
19 #Suggests: php-mbstring
21 BuildRoot: %{tmpdir}/%{name}-%{version}-root-%(id -u -n)
23 %define _appdir %{_datadir}/%{name}
24 %define _webapps /etc/webapps
25 %define _webapp %{name}
26 %define _sysconfdir %{_webapps}/%{_webapp}
29 phpMyAdmin can administer a whole MySQL-server (needs a super-user)
30 but also a single database. To accomplish the latter you'll need a
31 properly set up MySQL-user who can read/write only the desired
32 database. It's up to you to look up the appropiate part in the MySQL
33 manual. Currently phpMyAdmin can:
34 - create and drop databases
35 - create, copy, drop and alter tables
36 - delete, edit and add fields
37 - execute any SQL-statement, even batch-queries
38 - manage keys on fields
39 - load text files into tables
40 - create (*) and read dumps of tables
41 - export (*) and import data to CSV values
42 - administer multiple servers and single databases
43 - communicate in more than 20 different languages
46 phpMyAdmin potrafi zarz±dzaæ ca³ymi bazami MySQL (potrzebne
47 uprawnienia superu¿ytkownika) jak i pojedynczymi bazami danych.
48 Potrzebny jest u¿ytkownik, który ma prawa zapisu/odczytu tylko tych
49 baz, którymi chcemy administrowaæ (wiêcej informacji w odpowiedniej
50 podrêcznika MySQL). Aktualnie phpMyAdmin potrafi:
51 - tworzyæ i usuwaæ bazy
52 - wykonywaæ create, copy, drop oraz alter na tabelach
53 - dodawaæ, usuwaæ i modyfikowaæ pola
54 - wykonywaæ dowolne zapytania SQL
55 - zarz±dzaæ kluczami na rekordach
56 - wczytywaæ tekst z plików do tabel
57 - obs³ugiwaæ ponad 20 jêzyków
58 - zarz±dzaæ wieloma serwerami i pojedynczymi bazami danych
59 - eksportowaæ i importowaæ dane do warto¶ci CSV
60 - tworzyæ i czytaæ zrzuty tabel
67 rm -rf $RPM_BUILD_ROOT
68 install -d $RPM_BUILD_ROOT{%{_sysconfdir},%{_appdir}/{css,js,lang,libraries/{auth,dbg,dbi,engines,export,fpdf/font,import,transformations}}}
70 install *.php *.html *.css $RPM_BUILD_ROOT%{_appdir}
71 install lang/*.php $RPM_BUILD_ROOT%{_appdir}/lang
72 cp -rf themes $RPM_BUILD_ROOT%{_appdir}
73 install css/* $RPM_BUILD_ROOT%{_appdir}/css
74 install js/* $RPM_BUILD_ROOT%{_appdir}/js
75 install libraries/*.php $RPM_BUILD_ROOT%{_appdir}/libraries
76 install libraries/auth/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/auth
77 install libraries/dbg/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/dbg
78 install libraries/dbi/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/dbi
79 install libraries/engines/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/engines
80 install libraries/export/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/export
81 install libraries/fpdf/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/fpdf
82 install libraries/fpdf/font/*.{php,z} $RPM_BUILD_ROOT%{_appdir}/libraries/fpdf/font
83 install libraries/import/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/import
84 install libraries/transformations/*.php $RPM_BUILD_ROOT%{_appdir}/libraries/transformations
86 install libraries/config.default.php $RPM_BUILD_ROOT%{_sysconfdir}/config.inc.php
87 ln -sf %{_sysconfdir}/config.inc.php $RPM_BUILD_ROOT%{_appdir}/config.inc.php
89 install %{SOURCE1} $RPM_BUILD_ROOT%{_sysconfdir}/httpd.conf
90 install %{SOURCE1} $RPM_BUILD_ROOT%{_sysconfdir}/apache.conf
93 rm -rf $RPM_BUILD_ROOT
96 %webapp_register apache %{_webapp}
99 %webapp_unregister apache %{_webapp}
101 %triggerin -- apache < 2.2.0, apache-base
102 %webapp_register httpd %{_webapp}
104 %triggerun -- apache < 2.2.0, apache-base
105 %webapp_unregister httpd %{_webapp}
107 %triggerpostun -- phpMyAdmin <= 2.5.3-2
108 for i in `grep -lr "/home/\(services/\)*httpd/html/myadmin" /etc/httpd/*`; do
110 sed -i -e "s#/home/httpd/html/myadmin#%{_appdir}#g" $i
111 sed -i -e "s#/home/services/httpd/html/myadmin#%{_appdir}#g" $i
112 echo "File changed by trigger: $i (backup: $i.backup)"
115 %triggerpostun -- %{name} < 2.7.0-pl1.2.5
116 # rescue app config from various old locations
117 if [ -f /home/services/httpd/html/myadmin/config.inc.php.rpmsave ]; then
118 mv -f %{_sysconfdir}/config.inc.php{,.rpmnew}
119 mv -f /home/services/httpd/html/myadmin/config.inc.php.rpmsav %{_sysconfdir}/config.inc.php
121 if [ -f /home/httpd/html/myadmin/config.inc.php.rpmsave ]; then
122 mv -f %{_sysconfdir}/config.inc.php{,.rpmnew}
123 mv -f /home/httpd/html/myadmin/config.inc.php.rpmsave %{_sysconfdir}/config.inc.php
125 if [ -f /etc/%{name}/config.inc.php.rpmsave ]; then
126 mv -f %{_sysconfdir}/config.inc.php{,.rpmnew}
127 mv -f /etc/%{name}/config.inc.php.rpmsave %{_sysconfdir}/config.inc.php
130 # nuke very-old config location (this mostly for Ra)
131 if [ -f /etc/httpd/httpd.conf ]; then
132 sed -i -e "/^Include.*%{name}.conf/d" /etc/httpd/httpd.conf
135 # migrate from httpd (apache2) config dir
136 if [ -f /etc/httpd/%{name}.conf.rpmsave ]; then
137 cp -f %{_sysconfdir}/httpd.conf{,.rpmnew}
138 mv -f /etc/httpd/%{name}.conf.rpmsave %{_sysconfdir}/httpd.conf
141 rm -f /etc/httpd/httpd.conf/99_%{name}.conf
142 /usr/sbin/webapp register httpd %{_webapp}
143 %service httpd reload
146 %defattr(644,root,root,755)
147 %doc Documentation.* CREDITS ChangeLog INSTALL README TODO translators.html scripts
148 %dir %attr(750,root,http) %{_sysconfdir}
149 %attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/apache.conf
150 %attr(640,root,root) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/httpd.conf
151 %attr(640,root,http) %config(noreplace) %verify(not md5 mtime size) %{_sysconfdir}/*.php