Summary: 	MySQL Database Web Administration
Summary(fr): 	Admisnistration des bases de données MySQL par le web
Name: 		phpMyAdmin
Version: 	2.8.2
Release: 	1%{?dist}
License: 	GPL
Group: 		Development/Tools
Source0: 	%{name}-%{version}.tar.bz2
Source1: 	phpMyAdmin.conf
Source2:	phpMyAdmin-config.inc.php
BuildRoot: 	%{_tmppath}/%{name}-buildroot
URL: 		http://www.phpmyadmin.net/
Requires:  	mysql-server >= 4.1.2, httpd, php-mbstring, php-mysql
BuildArchitectures: noarch

%description
phpMyAdmin is a tool written in PHP intended  to  handle  the
administration of MySQL over the Web. Currently it can create 
and drop databases, create/drop/alter tables, delete/edit/add
fields, execute any SQL statement,  manage  keys  on  fields, 
manage privileges, export data into various  formats  and  is
available in 50 languages.

%description -l fr
phpMyAdmin est un outil écrit en PHP permettant l'administration
de MySQL à travers le "Web". Actellement il permet de créer et
détruire les bases de données, créer/modifier/détruire les
tables, détruire/modifier/ajouter des champs, exécuter toutes
les requêtes SQL, gérer les index sur les champs, gérer les
privilèges, exportes les données dans différents formats.
Il est disponible dans 50 langues.

%prep
%setup -q -n %{name}-%{version}

%build
echo nothing to do

%install
rm -rf %{buildroot}
%{__mkdir_p} %{buildroot}
%{__mkdir_p} %{buildroot}%{_sysconfdir}/httpd/conf.d
%{__mkdir_p} %{buildroot}%{_var}/www/phpMyAdmin
for dir in css js lang libraries themes
do
	 %{__cp} -r $dir %{buildroot}%{_var}/www/phpMyAdmin
done
%{__cp} *.html *.php *.css ChangeLog %{buildroot}%{_var}/www/phpMyAdmin/
%{__cp} %{SOURCE1} %{buildroot}%{_sysconfdir}/httpd/conf.d/
%{__cp} %{SOURCE2} %{buildroot}%{_var}/www/phpMyAdmin/config.inc.php

%clean
rm -rf %{buildroot}

%files
%defattr(-,root,root)
%{_var}/www/phpMyAdmin
%config(noreplace) %attr(0644,root,root)     %{_sysconfdir}/httpd/conf.d/phpMyAdmin.conf
%config(noreplace) %attr(0400,apache,apache) %{_var}/www/phpMyAdmin/config.inc.php
%doc ChangeLog CREDITS Documentation.txt Documentation.html INSTALL LICENSE 
%doc README RELEASE-DATE-%{version} TODO scripts

%post
if [ "$1" -ne "1" ]; then
	echo "Update: configuration preserved"
	exit 0
fi

if /usr/bin/mysql -hlocalhost -uUNKNOWN_MYSQL_USER -equit 2>&1 | grep -q 'ERROR 2002' 
then	echo mysqld not running
	exit 0
else	echo mysqld is running
fi

if /usr/bin/mysql -hlocalhost -equit 2>&1 | grep -q 'Access denied for user' 
then	echo Access denied
	exit 0
fi

HOST=$(/bin/hostname)
USER=phpmyadmin
PASS=top${RANDOM}secret${RANDOM}
BASE=$USER
CONF=/var/www/phpMyAdmin/config.inc.php

echo Creating user $USER

/usr/bin/mysql -hlocalhost <<EOF
GRANT USAGE ON mysql.* TO '$USER'@'localhost' IDENTIFIED BY '$PASS';
GRANT SELECT (
    Host, User, Select_priv, Insert_priv, Update_priv, Delete_priv,
    Create_priv, Drop_priv, Reload_priv, Shutdown_priv, Process_priv,
    File_priv, Grant_priv, References_priv, Index_priv, Alter_priv,
    Show_db_priv, Super_priv, Create_tmp_table_priv, Lock_tables_priv,
    Execute_priv, Repl_slave_priv, Repl_client_priv
    ) ON mysql.user TO $USER@localhost;
GRANT SELECT ON mysql.db TO $USER@localhost;
GRANT SELECT ON mysql.host TO $USER@localhost;
GRANT SELECT (Host, Db, User, Table_name, Table_priv, Column_priv)
    ON mysql.tables_priv TO $USER@localhost;
EOF

if /usr/bin/mysql -hlocalhost -u$USER -p$PASS -equit 2>&1 | grep -q 'Access denied for user' 
then	echo Access denied for $USER
	exit 0

else 	echo Success, Updating phpMyAdmin config
	sed -i -e s/THESECRET/$PASS/ $CONF
fi

if /usr/bin/mysql -hlocalhost -equit $BASE 2>&1 | grep -q 'Unknown database' 
then	echo Creating database $BASE

/usr/bin/mysql -hlocalhost <<EOF
CREATE DATABASE $BASE;
GRANT SELECT, INSERT, UPDATE, DELETE ON $BASE.* TO $USER@localhost;
USE $BASE;

CREATE TABLE pma_bookmark (
  id int(11) NOT NULL auto_increment,
  dbase varchar(255) NOT NULL default '',
  user varchar(255) NOT NULL default '',
  label varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
  query text NOT NULL,
  PRIMARY KEY  (id)
)
  ENGINE=MyISAM COMMENT='Bookmarks'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE pma_column_info (
  id int(5) unsigned NOT NULL auto_increment,
  db_name varchar(64) NOT NULL default '',
  table_name varchar(64) NOT NULL default '',
  column_name varchar(64) NOT NULL default '',
  comment varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
  mimetype varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
  transformation varchar(255) NOT NULL default '',
  transformation_options varchar(255) NOT NULL default '',
  PRIMARY KEY  (id),
  UNIQUE KEY db_name (db_name,table_name,column_name)
)
  ENGINE=MyISAM COMMENT='Column information for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE pma_history (
  id bigint(20) unsigned NOT NULL auto_increment,
  username varchar(64) NOT NULL default '',
  db varchar(64) NOT NULL default '',
  \`table\` varchar(64) NOT NULL default '',
  timevalue timestamp(14) NOT NULL,
  sqlquery text NOT NULL,
  PRIMARY KEY  (id),
  KEY username (username,db,\`table\`,timevalue)
)
  ENGINE=MyISAM COMMENT='SQL history for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE pma_pdf_pages (
  db_name varchar(64) NOT NULL default '',
  page_nr int(10) unsigned NOT NULL auto_increment,
  page_descr varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL default '',
  PRIMARY KEY  (page_nr),
  KEY db_name (db_name)
)
  ENGINE=MyISAM COMMENT='PDF relation pages for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE pma_relation (
  master_db varchar(64) NOT NULL default '',
  master_table varchar(64) NOT NULL default '',
  master_field varchar(64) NOT NULL default '',
  foreign_db varchar(64) NOT NULL default '',
  foreign_table varchar(64) NOT NULL default '',
  foreign_field varchar(64) NOT NULL default '',
  PRIMARY KEY  (master_db,master_table,master_field),
  KEY foreign_field (foreign_db,foreign_table)
)
  ENGINE=MyISAM COMMENT='Relation table'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE pma_table_coords (
  db_name varchar(64) NOT NULL default '',
  table_name varchar(64) NOT NULL default '',
  pdf_page_number int(11) NOT NULL default '0',
  x float unsigned NOT NULL default '0',
  y float unsigned NOT NULL default '0',
  PRIMARY KEY  (db_name,table_name,pdf_page_number)
)
  ENGINE=MyISAM COMMENT='Table coordinates for phpMyAdmin PDF output'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;

CREATE TABLE pma_table_info (
  db_name varchar(64) NOT NULL default '',
  table_name varchar(64) NOT NULL default '',
  display_field varchar(64) NOT NULL default '',
  PRIMARY KEY  (db_name,table_name)
)
  ENGINE=MyISAM COMMENT='Table information for phpMyAdmin'
  DEFAULT CHARACTER SET utf8 COLLATE utf8_bin;
quit
EOF

else	echo Database already created
fi

%changelog 
* Sat Jul  8 2006 Remi Collet <RPMS@FamilleCollet.com> - 2.8.2-1.fc{3,4,5}.remi
- update to 2.8.2

* Sat Jun  3 2006 Remi Collet <RPMS@FamilleCollet.com> - 2.8.1-1.fc{3,4,5}.remi
- update to 2.8.1

* Sat Apr  8 2006 Remi Collet <RPMS@FamilleCollet.com> - 2.8.0.3-1.fc{3,4,5}.remi
- update to 2.8.0.3

* Fri Mar 17 2006 Remi Collet <RPMS@FamilleCollet.com> - 2.8.0.2-1.fc{3,4}.remi
- update to 2.8.0.2

* Fri Mar 10 2006 Remi Collet <RPMS@FamilleCollet.com> - 2.8.0.1-1.fc{3,4}.remi
- update to 2.8.0.1
- add Requires mysql >= 4.1.2 (for FC3, because of embebded SQL in post)
- don't change make config on update

* Sat Nov 19 2005 Remi Collet <remi.collet@univ-reims.fr> 2.6.4.4-1.fc4.remi
- version phpMyAdmin 2.6.4-pl4

* Thu Oct 13 2005 Remi Collet <remi.collet@univ-reims.fr> 2.6.4.2-1.FC4.remi
- version phpMyAdmin 2.6.4-pl2
- change detection for running MySQL.

* Sat Sep 17 2005 Remi Collet <remi.collet@univ-reims.fr> 2.6.4.1-1.FC4.remi
- version phpMyAdmin 2.6.4-pl1

* Wed Sep 14 2005 Remi Collet <remi.collet@univ-reims.fr> 2.6.4-1.FC4.remi
- version phpMyAdmin 2.6.4

* Sat Aug 27 2005 Remi Collet <remi.collet@univ-reims.fr> 2.6.3.1-1.FC4.remi
- version phpMyAdmin 2.6.3-pl1
- first build for FC4 (requires mysql >= 4.1.2)