[Comm] Ред База Данных 2.0

Alexey Novikov =?iso-8859-1?q?shader_=CE=C1_yandex=2Eru?=
Пт Сен 21 16:38:24 MSD 2007


On Fri, Sep 21, 2007 at 11:45:16AM +0300, Motsyo Gennadi aka Drool wrote:
> Kostarev Alexey пишет:
> > Добрый день!
> > На странице www.altlinuc.ru появилось сообщение об базы данных Ред База 
> > Данных 2.0 (firebird).
> > Где можно поводробнее узнать о характеристиках данной базы данных 
> > (максимальный размер базы, данных и пр)
> > 
> > Есть ли сборка для ALt
> 
> 	Насколько я понял из статьи - она совместима в установке. Т.е. сборки 
> как бы нет, а родная становится и работает. Также, интересуясь биллингом 
> stargazer, так же видел сообщения что фирменная сборка firebird на ALT4 
> становится и работает.

Я для себя собирал (ну не нравится мне запихивать в hasher СУБД,
когда нужны только devel, к тому же он там не ставится). Спек
прилагаю, кому надо - {со,за}бирайте. Возможно там не все гладко,
но тем не менее работает, только sisyphus_check не проходит - надо
там control прикрутить (suid/sgid).

-- 
WBR, Alexey Novikov
JID: alex-novikov на jabber.ru
----------- следующая часть -----------
%define base_name	firebird
%define service_name	firebird
%define install_dir	%_localstatedir/firebird
%define install_dir_bin	%install_dir/bin
%define rel		-0

Summary:	Firebird Relational Database Super Server and Client tools
Name:		%base_name-classic
Version:	2.0.1.12855
Release:	alt0.M40.1
License:	IDPL (new modules), IPL (original modules), MPL (modified modules)
Group:		Databases
URL:		http://firebird.sourceforge.net
Source:		Firebird-%{version}%rel.tar.bz2
Patch1:		%base_name-2.0.1-insi.patch
Patch2:		%base_name-2.0.1-alt-libicu-system.patch
Patch3:		%name-2.0.1-alt-xinetd.patch
Patch4:		%base_name-2.0.1-alt-fix-build.patch

# Automatically added by buildreq on Tue Jun 22 2004
BuildRequires:	bison gcc4.1-c++ libicu-devel libncurses-devel libstdc++4.1-devel libtinfo-devel

%define see_base	For a description of Firebird see the base Firebird RPM or %url
%define see_base_ru	????????? ???irebird ? ?%url

%description
Firebird is a powerful, high-performance relational database designed to be embedded into
applications on multiple platforms.

%package server
Summary:	Firebird Classic Server
Group:		Databases
Requires:	%name-lib = %version-%release
Provides:	%base_name-server

%description server
Firebird Classic Server.
%see_base

%package lib
Summary:	Firebird shared library
Group:		System/Libraries
Provides:	%base_name-lib

%description lib
Firebird shared libraries.
%see_base

%package devel
Summary:	Header files for Firebird library
Group:		Development/Databases
Requires:	%name-lib = %version-%release
Provides:	%base_name-devel

%description devel
Header files for Firebird library.
%see_base

%package utils
Summary:	Utilities for operate Firebird SQL server
Group:		Databases
Requires:	%name-lib = %version-%release
Provides:	%base_name-utils

%description utils
Utilities for operate Firebird SQL server.
%see_base

%package doc
Summary:	Documentation for Firebird
Group:		Databases

%description doc
Documentation for Firebird.
%see_base

%prep
%setup -q -n Firebird-%{version}%rel
%patch1 -p1
%patch2 -p1
%patch3 -p1
%patch4 -p1
#find ./ \( -name .cvsignore -o -name CVS \) -print0 | xargs -0 rm -rf 
%__subst 's,\$(LIB_LINK_RPATH)\$(FirebirdInstallPrefix)/lib,,' builds/posix/make.defaults
chmod u+x src/misc/writeBuildNum.sh

%build
pushd src/dsql
bison -l -d -b dsql parse.y
%__subst 's/\\r//g' parse.sed
%__sed -f parse.sed < dsql.tab.c >parse.cpp
popd

sh autogen.sh --prefix=%install_dir
%make_build PROD_FLAGS="%optflags %optflags_shared -fno-omit-frame-pointer -fno-builtin -DNDEBUG -DLINUX -MMD"

%install
%__install -d %buildroot%install_dir/{UDF,data,help,intl,misc}
%__install -d %buildroot%install_dir_bin
%__install -d %buildroot{%_bindir,%_sbindir}
%__install -d %buildroot{%_includedir,%_libdir,%_initdir,%_sysconfdir/xinetd.d,%_docdir/%name-%version/{,examples}}

%__install -m644 gen/install/misc/*.xinetd 			%buildroot%_sysconfdir/xinetd.d/firebird

%__install -m755 gen/firebird/bin/fb_inet_server		%buildroot%install_dir_bin
%__install -m750 gen/firebird/bin/fb_lock_mgr			%buildroot%install_dir_bin
%__install -m700 gen/firebird/bin/gds_drop			%buildroot%install_dir_bin
%__install -m755 gen/firebird/bin/qli				%buildroot%_bindir

%__install -m755 gen/firebird/bin/gbak				%buildroot%_bindir
%__install -m755 gen/firebird/bin/gsplit 			%buildroot%_bindir
%__install -m755 gen/firebird/bin/nbackup 			%buildroot%_bindir
%__install -m755 gen/firebird/bin/gdef				%buildroot%_bindir
%__install -m755 gen/firebird/bin/fb_lock_print			%buildroot%install_dir_bin
%__install -m755 gen/firebird/bin/gfix 				%buildroot%_bindir
%__install -m755 gen/firebird/bin/gpre 				%buildroot%_bindir
%__install -m755 gen/firebird/bin/gsec 				%buildroot%_sbindir
%__install -m755 gen/firebird/bin/gstat 			%buildroot%_sbindir
%__install -m755 gen/firebird/bin/isql 				%buildroot%_bindir/isql-fb

%__install -m755 gen/firebird/bin/changeRunUser.sh		%buildroot%install_dir/misc
%__install -m755 gen/firebird/bin/restoreRootRunUser.sh		%buildroot%install_dir/misc

%__install -m755 gen/firebird/bin/changeDBAPassword.sh		%buildroot%install_dir/misc
%__install -m755 gen/firebird/bin/createAliasDB.sh		%buildroot%install_dir/misc

# Copy examples only if we have them
%__cp -R gen/firebird/examples/* 				%buildroot%_docdir/%name-%version/examples

%__install -m644 gen/firebird/help/help.fdb 			%buildroot%install_dir/help
%__install -m644 gen/firebird/*.msg 				%buildroot%install_dir
%__install -m600 gen/firebird/security2.fdb 			%buildroot%install_dir

%__install -m644 gen/firebird/intl/libfbintl.so 		%buildroot%install_dir/intl/fbintl
%__install -m644 gen/install/misc/fbintl.conf 			%buildroot%install_dir/intl/fbintl.conf
%__install -m644 gen/firebird/UDF/* 				%buildroot%install_dir/UDF

#   Copy the sql-declarations into the UDF-directory
%__install -m644 src/extlib/ib_udf.sql 				%buildroot%install_dir/UDF
%__install -m644 src/extlib/fbudf/fbudf.sql 			%buildroot%install_dir/UDF

#   Note that this copies files from outside the build tree.
%__cp -R doc/* %buildroot%_docdir/%name-%version

%__install -m644 gen/install/misc/firebird.conf 		%buildroot%install_dir
%__install -m644 gen/install/misc/aliases.conf 			%buildroot%install_dir

%__install -m644 gen/firebird/include/*.h 			%buildroot/%_includedir

%__cp -df gen/firebird/lib/*.so* %buildroot/%_libdir

touch %buildroot%install_dir/firebird.log

%files server
%dir %attr(755,firebird,firebird) %install_dir
%dir %install_dir_bin
%_sbindir/gstat
%_sbindir/gsec
%install_dir/UDF
%dir %attr(755,firebird,firebird) %install_dir/data
%install_dir/help
%install_dir/intl
%install_dir/misc
%install_dir/*.msg
%attr(644,firebird,firebird) %install_dir/firebird.log
%config(noreplace) %attr(600,firebird,firebird) %install_dir/security2.fdb
%config(noreplace) %install_dir/aliases.conf
%config(noreplace) %install_dir/firebird.conf
%config(noreplace) %_sysconfdir/xinetd.d/*
%install_dir_bin/fb_inet_server
%attr(6550,root,firebird) %install_dir_bin/fb_lock_mgr
%install_dir_bin/fb_lock_print
%install_dir_bin/gds_drop

%files lib
%_libdir/*.so.*
%_libdir/libib_util.so

%files devel
%_bindir/gdef
%_bindir/gpre
%_includedir/*
%_libdir/*.so
%exclude %_libdir/libib_util.so

%files utils
%_bindir/gbak
%_bindir/gsplit
%_bindir/gfix
%_bindir/isql-fb
%_bindir/qli
%_bindir/nbackup

%files doc
%_docdir/%name-%version

%pre lib
groupadd -g 84 -o -r %service_name &>/dev/null
useradd -r -o -M -d %install_dir -s /dev/null -c "Firebird Database Administrator" -g %service_name -u 84 %service_name &>/dev/null ||:

%post lib
FileName="/etc/services"

newLine="gds_db		3050/tcp			# Firebird SQL Database Remote Protocol"
oldLine=`grep "^gds_db" $FileName`

if [ -z "$oldLine" ]; then
    echo $newLine >> $FileName
fi

FileName="/etc/hosts.equiv"
if [ ! -f $FileName ]; then
    touch $FileName
    chown root:root $FileName
    chmod u=rw,go=r $FileName
fi

for i in localhost localhost.localdomain `hostname`; do
    Line=`grep "^$i\$" $FileName`
    if [ -z "$Line" ]; then
	echo $i >> $FileName
    fi
    shift
done
%post_ldconfig

%postun lib
%postun_ldconfig

%preun server
/sbin/chkconfig --del %service_name
/sbin/service xinetd condreload || :

%post server
/sbin/chkconfig --add %service_name
/sbin/service xinetd condreload || :


%changelog
* Wed Jun 27 2007 Alexey Novikov <shader на yandex.ru> 2.0.1.12855-alt0.M40.1
- build for 4.0 branch

* Mon Apr 02 2007 Alexey Novikov <shader на yandex.ru> 2.0.1.12855-alt1
- New version
- Removed super-server and rename packages

* Tue Feb 20 2007 Alexey Novikov <shader на yandex.ru> 2.0.1.12810-alt1
- New version
- Build against system libicu
- Added patch from InfoSystem Ltd.

* Mon Dec 20 2004 Evgeniy Kobzev <evgenik на altlinux.ru> 1.5.2.4731-alt1
- New version

* Thu Dec 02 2004 Evgeniy Kobzev <evgenik на altlinux.ru> 1.5.2.4721-alt1
- New version

* Sun Oct 31 2004 Evgeniy Kobzev <evgenik на altlinux.ru> 1.5.2.4634-alt1
- New version

* Sun Jun 1 2003 DH <dh на dh.net.ru> 1.0.3.969-alt1cvs030601
- New version (from CVS)

* Thu Mar 27 2003 DH <dh на dh.net.ru> 1.0.2.941-alt1cvs030327
- New version (from CVS)

* Wed Mar 12 2003 DH <dh на dh.net.ru> 1.0.2.935-alt3cvs030312
- Minor changes in spec
- New version (from CVS)

* Thu Dec 26 2002 DH <dh на dh.net.ru> 1.0.2.914-alt1cvs021225
- New version (from CVS)

* Wed Oct 23 2002 AEN <aen на altlinux.ru> 1.0.0.857-alt2cvs020623
- rebuild with gcc-3.2

* Sat Jul 13 2002 DH <dh на dh.net.ru> 1.0.0.857-alt1
- New version (form CVS)

* Sat May 25 2002 DH <dh на dh.net.ru> 1.0.0.824-alt1
- Minor fixes in spec
- New version (form CVS)

* Tue Mar 19 2002 DH <dh на dh.net.ru> 1.0.0.796-alt1
- Add xinetd script
- Changes in .spec
- New version

* Fri Aug 10 2001 Alexander Bokovoy <ab на altlinux.ru>
- Postinstall script fixed
- Permissions are fixed for databases

* Thu Mar 01 2001 Alexander Bokovoy <ab на avilink.net>
- Provides: interbase
- Several fixes to follow strict GLIBC 2.2.2 added
- Interbase build environment fixed to be self-contained
- muisql removed due absence of MultiUser environment for Interbase

* Mon Feb 19 2001 AEN <aen на logic.ru>
- group name fixed

* Wed Feb 14 2001 AEN <aen на logic.ru>
- root build :-(

* Mon Jan 22 2001 AEN <aen на logic.ru>
- bad patch from firebird

* Fri Jan 12 2001 AEN <aen на logic.ru>
- 0.9-4

* Tue Jan 2 2001 AEN <aen на logic.ru>
- first spec for RE



Подробная информация о списке рассылки community