File froxlor.spec of Package froxlor

%define name       froxlor
%define version    0.9.28.1
%if 0%{?suse_version}
%define apache_serverroot /srv/www/htdocs
%endif
%if 0%{?fedora_version} || 0%{?rhel_version} || 0%{?redhat_version} || 0%{?centos_version}
%define apache_serverroot /var/www/html
%endif

Name:           %{name}
Version:        %{version}
Release:        1.1
Source0:        froxlor-%{version}.tar.bz2
Source1:        froxlor.suse.adapt.template.config.tar.bz2 
Patch0:  	froxlor-0.9.28.1-sql.patch
URL:            http://www.froxlor.org
License:        GPLv2 http://files.froxlor.org/misc/COPYING.txt
BuildRoot:      %{_tmppath}/%{name}-%{version}-build
BuildArch:      noarch
Group:          Productivity/Networking/Web/Utilities
Summary:        Froxlor Server Management Panel a php web-based administration software

%if 0%{?suse_version}
BuildRequires:  apache2
Requires:       apache2, apache2-mod_php5, php5, php5-mysql, php5-posix, php5-bcmath, postfix, mysql, courier-imap, courier-authlib, courier-authlib-mysql, courier-authlib-userdb, cyrus-sasl-sqlauxprop, cyrus-sasl-saslauthd, pure-ftpd
%endif

%if 0%{?fedora_version} || 0%{?rhel_version} || 0%{?redhat_version} || 0%{?centos_version}
BuildRequires:	httpd
Requires:	httpd, php, php-mysql, php-bcmath, postfix, mysql-server, courier-imap, courier-authlib, courier-authlib-mysql, courier-authlib-userdb, cyrus-sasl-sql, cyrus-sasl, proftpd
%endif

%description
A Server Management Panel is a php web-based administration software.
Developed by experienced server administrators and based on the system control panel SysCP with main focus on simplicity and usability.

Froxlor can help you set up and manage a lot of system-services, like web-, mail- and ftpserver and it also brings some nice features such as a complete support-ticket system and an implementation of the Application Packaging Standard.

%prep
%setup -q -n  %{name}
%setup1 -T -D -b 1 -n %{name}
%setup2 -T -D -b 1 -n %{name}
%if 0%{?suse_version}
%patch0  
%endif

%build

%install
idir=$RPM_BUILD_ROOT%{apache_serverroot}/%{name}
mkdir -p $idir
cp -aRf * $idir
find $idir -type f -iname \*.orig -exec rm {} \;

%if 0%{?suse_version}
echo "froxlor installation see doc http://wiki.froxlor.org/contrib/opensuse-11.x" > $idir/README.SUSE
echo "see also froxlor website http://www.froxlor.org/" >> $idir/README.SUSE
echo "For SLE11 and SLE10 see README" >> $idir/README.SUSE
%endif

%clean
rm -rf "$RPM_BUILD_ROOT"

%files
%defattr(-,wwwrun,www)
%{apache_serverroot}/%{name}

%changelog
* Tue Mar 29 2011 Carsten Schoene <cs@linux-administrator.com> - 0.9.19
- upstream upgrade to version 0.9.19
  ~ Bug #592: missing build-dependancy on cdbs
  ~ Bug #618: Sortierung der Kunden
  ~ Bug #647: froxlor relies on being installed in docroot/froxlor
  ~ Bug #649: undefined variable $entry in cron_autoresponder.php
  ~ Bug #653: Froxlor-Passwort zurücksetzen: Fehlermeldung trotz erfolgreicher Durchführung
  ~ Bug #654: Install script error
  ~ Bug #656: Vorlage "Hinweis zum Speicherverbrauch" wird nicht beachtet
  ~ Bug #657: [Design] Falscher Pfad bei Domains mit URLs
  ~ Bug #658: Doppel-Slash bei Domain-Redirects
  ~ Bug #659: Inhalt von CGI-BIN wird beim SuExec Workaround gelöscht
  ~ Bug #660: Skripte werde beim SuExec Workaround nicht ausgeführt (403-Fehler)
  ~ Bug #662: Es wurde eine falsche Id übergeben
  ~ Bug #663: FreeBSD aps installer
  ~ Bug #669: Redirect Code wird via mod_rewrite nicht gesetzt
  ~ Bug #670: FreeBSD 8.2 , php 5.3.5, php-fpm, mysql 5.5.9 - aps installer
  ~ Bug #671: Leeres Feld "Eigene vHost-Einstellungen" in "IPs und Ports"
  ~ Bug #674: Suchfunktion von Ticket-Archiv funktioniert nicht
  ~ Bug #675: Rechtschreibfehler: Einstellungen->Log Einstellungen
  ~ Feature #550: Please adjust the package recommendations for Exim4 as MTA
  ~ Feature #627: Fehlender Eintrag in der Postfix Vorlage für TLS
  ~ Feature #651: Variabeln für E-Mail-Vorlage "Hinweis zum Speicherverbrauch"
  ~ Feature #661: "Kunden anlegen" Schaltfläche über die Tabelle
  ~ Feature #666: Gesperrt lassen was gesperrt gehört
  ~ Feature #667: AWStats Ordner der Standarddomain löschen wenn diese entfernt wird
  ~ Feature #672: Werte für Formular beim Auftreten von Fehlern beibehalten
  ~ Feature #676: Add checkbox support to formfield generator

* Sat Mar 26 2011 Carsten Schoene <cs@linux-administrator.com> - 0.9.18.1
- upstream upgrade to version 0.9.18.1
  ~ Creating a mail forwarder: Only white site after creation and no success
  ~ no traffic bars in customer view
  ~ PHP Configurations in new thems is damaged
  ~ Can not create absence-messages
  ~ image loading problem
  ~ Unable to view configuration page
  ~ domain path is not displayed
  ~ Confusing row design in customers/admins/domains list
  ~ FTP-user can't be changed
  ~ Customer Frontend -> Creating email account
  ~ HTTP Config on SUSE
  ~ [nginx|php-fpm] Wrong ip and port setting for default vhost

* Mon Feb 28 2011 asemen@suse.de
- upstream upragde to version 0.9.18
  + Complete new design
  + Theme - switcher
  + Feature #579: Ability to add idna domains that contains the German "ß"
  ~ Bug #543: Customer details get cut when entering special characters
  ~ Bug #553: Heimatverzeichnis des FTP-Benutzers löschen
  ~ Bug #562: open_basedir settings are ignored when using php-fpm
  ~ Bug #563: Round values for {DISKAVAILABLE}, {DISKUSED}... in mails
  ~ Bug #564: resolve php warnings when using php-5.3 and greater
  ~ Bug #566: Placeholder on sendmail fail
  ~ Bug #568: dovecot-sql.conf incorrect in gentoo ebuild
  ~ Bug #569: /etc/postfix/mysql-virtual_sender_permissions.cf doesn't get copied to config dir
  ~ Bug #592: missing build-dependancy on cdbs
  ~ Bug #571: Domain deletion fails
  ~ Bug #572: Unable to start Dovecot with configuration from froxlor panel
  ~ Bug #573: Wrong pathes at Postfix MX-Access (anti spam) configuration
  ~ Bug #574: Wrong path at PowerDNS configuration
  ~ Bug #575: Wrong path at Crond (cronscript) configuration
  ~ Bug #578: du -s shows wrong size
  ~ Bug #599: php-fcgi Docroot anpassung bei gesperrten Usern
  ~ Bug #610: phpMyAdmin doesnt work with nginx php-fpm https vhost
  ~ Bug #611: function.findDirs stops after first unreadable directory
  ~ Bug #612: function.findDirs gives a warning about not executable directories
  ~ Feature #544: cron_traffic.php: mysql error number: 2006 - MySQL server has gone away
* Fri Jan 28 2011 asemen@suse.de
- adding awstats and roundcubemail howto in file README.INSTALL.SUSE
* Thu Jan 27 2011 asemen@suse.de
- awstats fix in configuration file for openSUSE 11.X
* Wed Jan 26 2011 asemen@suse.de
- adaption in pure-ftp Configuration template setting froxlor as
  user and MySQL db name
* Wed Jan 26 2011 asemen@suse.de
- upstream upragde to version 0.9.17
  + Rebuilding configurations after a setting is changed (bug #535)
  + Added notification by email about client/reseller limits (bug #153)
  + Added notification mail for customers when 90%% percent of disk space is exhausted (bug #466)
  ~ FTP: fixed wrong sorting method in "Create Account" (bug #534)
  ~ Configuration: various freebsd-config enhancements (bugs #537, #538)
  ~ Webserer: fixed SSL Redirect vhost container (bugs #541, #542)
  ~ UI: fixed undefined index when editing a MySQL-database (bug #554)
  ~ UI: fixed editing admin mail quota is limited to 3 character (bug #559)
* Mon Jan 24 2011 asemen@suse.de
- optimizing build spec file and patching froxlor.sql file
  changing apache DocumentRoot to srv
* Thu Jan  6 2011 asemen@suse.de
- fix visibility of configuration files in admin back end
* Wed Jan  5 2011 asemen@suse.de
- fix froxlor.sql database file for opensuse (bug #539)
* Tue Dec 28 2010 asemen@suse.de
- upstream upragde to version 0.9.16
  + Froxlor now supports php-fpm (bug #482)
  ~ Update for the dutch language file (bug #506)
  ~ Fixed newlines in "reset-password"-mail (bug #507)
  ~ Fixed some issues with gentoo and emerge (bug #510 #511 #512)
  ~ Fixed install.sql to work with mysql 5.5 (bug #529)
  ~ Added check for php-xml extension (bug #530)
* Fri Dec  3 2010 asemen@suse.de
- upstream upragde to version 0.9.15.1
  + Quickfix dovecot-sql.conf
* Mon Nov 29 2010 asemen@suse.de
- upstream upragde to version 0.9.15
  + Webserver: Froxlor now supports the NGINX webserver (bug #103)
  + Unlocking of locked accounts via the panel (bug #473)
  + Added --force parameter for the master-cronjob
  + Tickets: pre-set the next available number for logical order when adding a new category (bug #464)
  ~ AWstats: fix undefined variable in webserver-cronjob (bug #454)
  ~ Configuration: determine own path for cronjob-configuration-template (bug #455)
  ~ Fixed issue if 'store default-index' is 'no' (bug #459)
  ~ Ebuild: fixed typo when setting permissions (bug #463)
  ~ Fixed possible wrong vhost-order for standard-subdomains (bug #465)
  ~ Corrected mailserver configs so they check for imap-allowed and pop3-allowed (bug #475)
  ~ Autoresponder: fixed sender if the receiver of the original mail is not the owner of the autoresponder (bug #476)
  x Configuration-templates and support for Debian Etch
* Mon Oct 25 2010 asemen@suse.de
- upstream upragde to version 0.9.14
  + Allow login to panel using domains (bug #374)
  + Added configuration templates for DKIM for Debian/Ubuntu systems (bug #384)
  + Allow custom documentroot for IP/Port vHosts (bug #417)
  + Added SSLCertificateChainFile-directive to Apache-SSL configuration (bug #418)
  + Allow domains with port-statement as documentroot/redirect (bug #431)
  ~ AWstats: fix multiple calculation of traffic (bug #246)
  ~ AWstats: add images to created stats-pages (bug #257)
  ~ AWstats: chown stats directories after creation (bug #258)
  ~ Fixed resource calculation for APS-packages (bug #425)
  ~ Various improvements of language files (bugs #434 and #439)
  ~ Fixed order of domains in single-vhost-file (bug #437)
  ~ Corrected descriptions for edit-database view (bug #444)
  x Realtime update-feature has been removed due to problems and possible skipped/unfinished tasks
* Fri Oct  1 2010 asemen@suse.de
- upstream upragde to version 0.9.13.1
  * Allow selection of php-configuration for Froxlor vhost [FCGID-Mode] (bug #414)
  * Added missing $smtpd_sender_login_maps in postfix-main.cf [FreeBSD] (bug #420)
  * Fixed Autoresponder if Reply-To header is present (bug #423)
* Wed Sep 29 2010 asemen@suse.de
- adding apache alias for froxlor roundcubemail squirrelmail to config file
* Wed Sep 29 2010 asemen@suse.de
- upstream upragde to version 0.9.13
  * Fix monthly Awstats generation (bug #240)
  * Improve behavior of security-questions (bug #332)
  * Added checkbox to prevent creation of index.html in home directory (bug #369)
  * Added checkbox to prevent creation of unneeded statistics directories (bug #370)
  * Control amount of autoresponders per customer (bug #377)
  * Restrict sender address to logged-in SMTP user in postfix (bug #379)
  * Removed display of RegEx within the password-complexity error-message (bug #392)
  * Correction of domain-list view (bug #394)
  * Fixed SQL-query in customer management (bug #397)
  * Fixed autoresponder when automatically answered mails being received (bug #399)
  * Fixed postfix-dovecot configuration-templates for Ubuntu Lucid (bug #401)
  * Added support for CGI APS-packages (bug #404)
  * Fixed usage of usernames instead of uid/gid when fcgid is not enabled (bug #407)
  * Fixed up irritating texts on the panel (bug #408)
  * [Gentoo Ebuild] Added php.ini creation for own vhost (bug #411)
  * Fixed deletion of files when a domain gets deleted (bug #415)
* Wed Aug 25 2010 asemen@suse.de
- upstream upragde to version 0.9.12
  * Allow files to be set as 40x & 500 error-handler (bug #267)
  * Added possibility to use FCGID also for the Froxlor-panel itself (bug #305)
  * Improved/Reviewed autoresponder-source (bug #308)
  * Fixed various file-permission-commands in the configuration-area (bug #309, #310)
  * Added pure-ftpd to Gentoo, fixed configuration for debian-based systems (bug #311)
  * Added possibility to use Perl/CGI for Apache+SuExec users (bug #319)
  * Fixed editing of mysql-databases in customer-panel (bug #325)
  * Added possibility to add a subdomain of another domain as "full"-domain in admin-interface (bug #329)
  * Fixed issues when saving settings with attribute "dir" (bug #331)
  * Set default path for FTP-accounts to customerroot (bug #338)
  * Fixed usage of chattr under FreeBSD, it is named chflgs there (bug #339)
  * Added possibility to customize the description of a directory-protection via htpasswd (bug #345)
  * Added e-mail notification template for 'forgot password' (bug #354)
  * Remove fcgi-starter if domain has been deleted (bug #367)
  * Added '{COMPANY}' template variable for all e-mail templates (bug #376)
* Mon Jul 26 2010 asemen@suse.de
- upstream upragde to version 0.9.11
  New features / Bugfixes and more:
  * Adminpanel: [feature-request] Renice error message for froxlor mail notification
  * Configfiles: Set umask in php-fcgi-starter script
  * Adminpanel: Password strengt for new customer accounts
  * Userpanel: Optional: Bei löschen von FTP-User abfragen ob Home-DIR löschen
  * Configfiles: Rename the xinetd.d template file
  * Adminpanel: redirect code always "---" if you edit domain
* Mon Jun 28 2010 asemen@suse.de
- upstream upragde to version 0.9.10
  New features / Bugfixes and more:
  * Uninstalling  an APS package does not delete the installed files (bug #273)
  * Database does not show in  client database (bug #272)
  * When APS contingent for  customer is reached, no hint is shown (bug #278)
  * Lighttpd   auth.backend: If more than one directory is protected, the users of them  are not saved in the htpasswd file (bug #281)
  * spelling error in german  language file (bug #279)
  * Create  customer task not deleted if customer is deleted (bug #276)
  * language selector does not work on login - page (bug #277)
  * Default path for AWStats (bug #275)[
  * ipandport_xxx.conf DocumentRoot now manageable in settings (bug #270)
  * A variable name leading to invalid paths was corrected
* Fri Jun 18 2010 asemen@suse.de
- upstream upragde to version 0.9.9
  New features / Bugfixes and more:
  * implemented APS-1.2 standard (bug #232)
  * fixed DNS mail A record is not created when using external MX servers (bug #242)
  * added possiblility for customer to get its e-mail account data deleted from the filesystem when removing an account from the panel (bug #245)
  * fixed duplicate config variable in lighttpd.conf (bug #254)
  * fixed incorrect form field in autoresponder form (bug #256)
  * corrected chown'ing of awstats-directory (bug #258)
  * fixed incorrect (additional) directory-creation in webserver-cron (bug #259)
  * fixed sed expressions in the configuration manual (bug #263)
  * Thu Jul 09 09:00:00 CEST 2010 Andrej Semen <asemen@suse.de>
  * initial build of froxlor version 0.9.8