* [gentoo-commits] gentoo-x86 commit in mail-filter/sqlgrey: ChangeLog sqlgrey-1.7.6.ebuild
@ 2011-06-21 16:11 Eray Aslan (eras)
0 siblings, 0 replies; 5+ messages in thread
From: Eray Aslan (eras) @ 2011-06-21 16:11 UTC (permalink / raw
To: gentoo-commits
eras 11/06/21 16:11:13
Modified: ChangeLog sqlgrey-1.7.6.ebuild
Log:
Fix conditional USE dependency - bug #168179
(Portage version: 2.1.10.3/cvs/Linux x86_64)
Revision Changes Path
1.14 mail-filter/sqlgrey/ChangeLog
file : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.14&view=markup
plain: http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.14&content-type=text/plain
diff : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/ChangeLog?r1=1.13&r2=1.14
Index: ChangeLog
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v
retrieving revision 1.13
retrieving revision 1.14
diff -u -r1.13 -r1.14
--- ChangeLog 17 Oct 2009 17:52:02 -0000 1.13
+++ ChangeLog 21 Jun 2011 16:11:13 -0000 1.14
@@ -1,6 +1,9 @@
# ChangeLog for mail-filter/sqlgrey
-# Copyright 1999-2009 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.13 2009/10/17 17:52:02 dertobi123 Exp $
+# Copyright 1999-2011 Gentoo Foundation; Distributed under the GPL v2
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.14 2011/06/21 16:11:13 eras Exp $
+
+ 21 Jun 2011; Eray Aslan <eras@gentoo.org> sqlgrey-1.7.6.ebuild:
+ Fix conditional USE dependency - bug #168179
17 Oct 2009; Tobias Scherbaum <dertobi123@gentoo.org>
-sqlgrey-1.6.7.ebuild, -sqlgrey-1.7.4.ebuild:
1.5 mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild
file : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.5&view=markup
plain: http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.5&content-type=text/plain
diff : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?r1=1.4&r2=1.5
Index: sqlgrey-1.7.6.ebuild
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v
retrieving revision 1.4
retrieving revision 1.5
diff -u -r1.4 -r1.5
--- sqlgrey-1.7.6.ebuild 20 Sep 2009 21:46:11 -0000 1.4
+++ sqlgrey-1.7.6.ebuild 21 Jun 2011 16:11:13 -0000 1.5
@@ -1,6 +1,6 @@
-# Copyright 1999-2009 Gentoo Foundation
+# Copyright 1999-2011 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.4 2009/09/20 21:46:11 maekke Exp $
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.5 2011/06/21 16:11:13 eras Exp $
inherit eutils
@@ -15,11 +15,10 @@
dev-perl/net-server
dev-perl/Date-Calc
virtual/mailx
- || ( postgres? ( dev-perl/DBD-Pg )
- sqlite? ( dev-perl/DBD-SQLite )
- mysql? ( dev-perl/DBD-mysql )
- dev-perl/DBD-Pg
- )"
+ postgres? ( dev-perl/DBD-Pg )
+ sqlite? ( dev-perl/DBD-SQLite )
+ mysql? ( dev-perl/DBD-mysql )
+ !postgres? ( !mysql? ( !sqlite? ( dev-perl/DBD-Pg ) ) )"
DEPEND="$RDEPEND
sys-apps/sed"
KEYWORDS="amd64 ~sparc x86"
^ permalink raw reply [flat|nested] 5+ messages in thread
* [gentoo-commits] gentoo-x86 commit in mail-filter/sqlgrey: ChangeLog sqlgrey-1.7.6.ebuild
@ 2015-04-23 23:16 Manuel Rueger (mrueg)
0 siblings, 0 replies; 5+ messages in thread
From: Manuel Rueger (mrueg) @ 2015-04-23 23:16 UTC (permalink / raw
To: gentoo-commits
mrueg 15/04/23 23:16:17
Modified: ChangeLog
Removed: sqlgrey-1.7.6.ebuild
Log:
Remove old.
(Portage version: 2.2.18/cvs/Linux x86_64, signed Manifest commit with key )
Revision Changes Path
1.18 mail-filter/sqlgrey/ChangeLog
file : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.18&view=markup
plain: http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.18&content-type=text/plain
diff : http://sources.gentoo.org/viewvc.cgi/gentoo-x86/mail-filter/sqlgrey/ChangeLog?r1=1.17&r2=1.18
Index: ChangeLog
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v
retrieving revision 1.17
retrieving revision 1.18
diff -u -r1.17 -r1.18
--- ChangeLog 20 Jul 2014 12:08:47 -0000 1.17
+++ ChangeLog 23 Apr 2015 23:16:16 -0000 1.18
@@ -1,6 +1,9 @@
# ChangeLog for mail-filter/sqlgrey
-# Copyright 1999-2014 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.17 2014/07/20 12:08:47 pacho Exp $
+# Copyright 1999-2015 Gentoo Foundation; Distributed under the GPL v2
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.18 2015/04/23 23:16:16 mrueg Exp $
+
+ 23 Apr 2015; Manuel Rüger <mrueg@gentoo.org> -sqlgrey-1.7.6.ebuild:
+ Remove old.
20 Jul 2014; Pacho Ramos <pacho@gentoo.org> sqlgrey-1.7.6-r1.ebuild:
amd64/x86 stable, bug #509376
^ permalink raw reply [flat|nested] 5+ messages in thread
* [gentoo-commits] gentoo-x86 commit in mail-filter/sqlgrey: ChangeLog sqlgrey-1.7.6.ebuild
@ 2009-09-20 21:46 Markus Meier (maekke)
0 siblings, 0 replies; 5+ messages in thread
From: Markus Meier (maekke) @ 2009-09-20 21:46 UTC (permalink / raw
To: gentoo-commits
maekke 09/09/20 21:46:12
Modified: ChangeLog sqlgrey-1.7.6.ebuild
Log:
amd64/x86 stable, bug #283386
(Portage version: 2.2_rc41/cvs/Linux x86_64)
Revision Changes Path
1.12 mail-filter/sqlgrey/ChangeLog
file : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.12&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.12&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?r1=1.11&r2=1.12
Index: ChangeLog
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v
retrieving revision 1.11
retrieving revision 1.12
diff -u -r1.11 -r1.12
--- ChangeLog 19 Sep 2009 16:01:41 -0000 1.11
+++ ChangeLog 20 Sep 2009 21:46:11 -0000 1.12
@@ -1,6 +1,9 @@
# ChangeLog for mail-filter/sqlgrey
# Copyright 1999-2009 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.11 2009/09/19 16:01:41 tove Exp $
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.12 2009/09/20 21:46:11 maekke Exp $
+
+ 20 Sep 2009; Markus Meier <maekke@gentoo.org> sqlgrey-1.7.6.ebuild:
+ amd64/x86 stable, bug #283386
19 Sep 2009; Torsten Veller <tove@gentoo.org> sqlgrey-1.7.6.ebuild:
Remove the dev-perl/IO-Multiplex check from pkg_setup because
1.4 mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild
file : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.4&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.4&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?r1=1.3&r2=1.4
Index: sqlgrey-1.7.6.ebuild
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v
retrieving revision 1.3
retrieving revision 1.4
diff -u -r1.3 -r1.4
--- sqlgrey-1.7.6.ebuild 19 Sep 2009 16:01:41 -0000 1.3
+++ sqlgrey-1.7.6.ebuild 20 Sep 2009 21:46:11 -0000 1.4
@@ -1,6 +1,6 @@
# Copyright 1999-2009 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.3 2009/09/19 16:01:41 tove Exp $
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.4 2009/09/20 21:46:11 maekke Exp $
inherit eutils
@@ -22,7 +22,7 @@
)"
DEPEND="$RDEPEND
sys-apps/sed"
-KEYWORDS="~amd64 ~sparc ~x86"
+KEYWORDS="amd64 ~sparc x86"
pkg_setup() {
enewgroup sqlgrey
^ permalink raw reply [flat|nested] 5+ messages in thread
* [gentoo-commits] gentoo-x86 commit in mail-filter/sqlgrey: ChangeLog sqlgrey-1.7.6.ebuild
@ 2009-09-19 16:01 Torsten Veller (tove)
0 siblings, 0 replies; 5+ messages in thread
From: Torsten Veller (tove) @ 2009-09-19 16:01 UTC (permalink / raw
To: gentoo-commits
tove 09/09/19 16:01:42
Modified: ChangeLog sqlgrey-1.7.6.ebuild
Log:
Remove the dev-perl/IO-Multiplex check from pkg_setup because dev-perl/net-server now depends on dev-perl/IO-Multplex.
(Portage version: 2.2_rc40/cvs/Linux x86_64)
Revision Changes Path
1.11 mail-filter/sqlgrey/ChangeLog
file : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.11&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.11&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?r1=1.10&r2=1.11
Index: ChangeLog
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v
retrieving revision 1.10
retrieving revision 1.11
diff -u -r1.10 -r1.11
--- ChangeLog 15 Jul 2008 19:45:31 -0000 1.10
+++ ChangeLog 19 Sep 2009 16:01:41 -0000 1.11
@@ -1,6 +1,10 @@
# ChangeLog for mail-filter/sqlgrey
-# Copyright 1999-2008 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.10 2008/07/15 19:45:31 bluebird Exp $
+# Copyright 1999-2009 Gentoo Foundation; Distributed under the GPL v2
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.11 2009/09/19 16:01:41 tove Exp $
+
+ 19 Sep 2009; Torsten Veller <tove@gentoo.org> sqlgrey-1.7.6.ebuild:
+ Remove the dev-perl/IO-Multiplex check from pkg_setup because
+ dev-perl/net-server now depends on dev-perl/IO-Multplex.
15 Jul 2008; Friedrich Oslage <bluebird@gentoo.org> sqlgrey-1.7.6.ebuild:
Add ~sparc keyword, requested by agaffney
1.3 mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild
file : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.3&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.3&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?r1=1.2&r2=1.3
Index: sqlgrey-1.7.6.ebuild
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v
retrieving revision 1.2
retrieving revision 1.3
diff -u -r1.2 -r1.3
--- sqlgrey-1.7.6.ebuild 15 Jul 2008 19:45:31 -0000 1.2
+++ sqlgrey-1.7.6.ebuild 19 Sep 2009 16:01:41 -0000 1.3
@@ -1,6 +1,6 @@
-# Copyright 1999-2008 Gentoo Foundation
+# Copyright 1999-2009 Gentoo Foundation
# Distributed under the terms of the GNU General Public License v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.2 2008/07/15 19:45:31 bluebird Exp $
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.3 2009/09/19 16:01:41 tove Exp $
inherit eutils
@@ -25,7 +25,6 @@
KEYWORDS="~amd64 ~sparc ~x86"
pkg_setup() {
- has_version dev-perl/IO-Multiplex || die "IO-Multiplex needed. Please emerge it or run g-cpan.pl IO::Multiplex"
enewgroup sqlgrey
enewuser sqlgrey -1 -1 /var/spool/sqlgrey sqlgrey
}
^ permalink raw reply [flat|nested] 5+ messages in thread
* [gentoo-commits] gentoo-x86 commit in mail-filter/sqlgrey: ChangeLog sqlgrey-1.7.6.ebuild
@ 2008-06-14 19:59 Tobias Scherbaum (dertobi123)
0 siblings, 0 replies; 5+ messages in thread
From: Tobias Scherbaum (dertobi123) @ 2008-06-14 19:59 UTC (permalink / raw
To: gentoo-commits
dertobi123 08/06/14 19:59:28
Modified: ChangeLog
Added: sqlgrey-1.7.6.ebuild
Log:
Version bump (#169734), keepdir on /var/spool/sqlgrey (#161300), fix initskript (#174505)
(Portage version: 2.1.5.5)
Revision Changes Path
1.9 mail-filter/sqlgrey/ChangeLog
file : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.9&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?rev=1.9&content-type=text/plain
diff : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/ChangeLog?r1=1.8&r2=1.9
Index: ChangeLog
===================================================================
RCS file: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v
retrieving revision 1.8
retrieving revision 1.9
diff -u -r1.8 -r1.9
--- ChangeLog 19 Mar 2007 03:42:21 -0000 1.8
+++ ChangeLog 14 Jun 2008 19:59:28 -0000 1.9
@@ -1,6 +1,13 @@
# ChangeLog for mail-filter/sqlgrey
-# Copyright 1999-2007 Gentoo Foundation; Distributed under the GPL v2
-# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.8 2007/03/19 03:42:21 kloeri Exp $
+# Copyright 1999-2008 Gentoo Foundation; Distributed under the GPL v2
+# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/ChangeLog,v 1.9 2008/06/14 19:59:28 dertobi123 Exp $
+
+*sqlgrey-1.7.6 (14 Jun 2008)
+
+ 14 Jun 2008; Tobias Scherbaum <dertobi123@gentoo.org>
+ +files/sqlgrey-1.7.6-init.patch, +sqlgrey-1.7.6.ebuild:
+ Version bump (#169734), keepdir on /var/spool/sqlgrey (#161300), fix
+ initskript (#174505)
19 Mar 2007; Bryan Østergaard <kloeri@gentoo.org> metadata.xml:
Remove vivo from metadata.xml due to retirement.
1.1 mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild
file : http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.1&view=markup
plain: http://sources.gentoo.org/viewcvs.py/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild?rev=1.1&content-type=text/plain
Index: sqlgrey-1.7.6.ebuild
===================================================================
# Copyright 1999-2008 Gentoo Foundation# Distributed under the terms of the GNU General Public License v2
# Distributed under the terms of the GNU General Public License v2
# $Header: /var/cvsroot/gentoo-x86/mail-filter/sqlgrey/sqlgrey-1.7.6.ebuild,v 1.1 2008/06/14 19:59:28 dertobi123 Exp $
inherit eutils
DESCRIPTION="SQLgrey is a postfix policy service implementing a grey-listing policy"
SRC_URI="mirror://sourceforge/sqlgrey/${P}.tar.bz2"
HOMEPAGE="http://sqlgrey.sourceforge.net/"
LICENSE="GPL-2"
SLOT="0"
IUSE="mysql postgres sqlite"
RDEPEND="dev-lang/perl
dev-perl/DBI
dev-perl/net-server
dev-perl/Date-Calc
virtual/mailx
|| ( postgres? ( dev-perl/DBD-Pg )
sqlite? ( dev-perl/DBD-SQLite )
mysql? ( dev-perl/DBD-mysql )
dev-perl/DBD-Pg
)"
DEPEND="$RDEPEND
sys-apps/sed"
KEYWORDS="~amd64 ~x86"
pkg_setup() {
has_version dev-perl/IO-Multiplex || die "IO-Multiplex needed. Please emerge it or run g-cpan.pl IO::Multiplex"
enewgroup sqlgrey
enewuser sqlgrey -1 -1 /var/spool/sqlgrey sqlgrey
}
src_unpack() {
unpack ${A}
epatch "${FILESDIR}/${P}-init.patch"
}
src_install () {
make gentoo-install ROOTDIR="${D}"
dodoc HOWTO FAQ README README.OPTINOUT README.PERF COPYING TODO Changelog
# keeps SQLgrey data in /var/spool/sqlgrey
diropts -m0775 -o sqlgrey -g sqlgrey
keepdir /var/spool/sqlgrey
}
pkg_postinst() {
echo
einfo "To make use of greylisting, please update your postfix config."
einfo
einfo "Put something like this in /etc/postfix/main.cf:"
einfo " smtpd_recipient_restrictions ="
einfo " ..."
einfo " check_policy_service inet:127.0.0.1:2501"
einfo
einfo "Remember to restart Postfix after that change. Also remember"
einfo "to make the daemon start durig boot:"
einfo " rc-update add sqlgrey default"
einfo
echo
einfo "To setup SQLgrey to run out-of-the-box on your system, run:"
einfo "emerge --config ${PN}"
echo
ewarn "Read the documentation for more info (perldoc sqlgrey) or the"
ewarn "included howto /usr/share/doc/${PF}/HOWTO.gz"
echo
ewarn "If you are using MySQL >= 4.1 use \"latin1\" as charset for"
ewarn "the SQLgrey db"
echo
ebeep 2
epause 5
}
pkg_config () {
# SQLgrey configuration file
local SQLgrey_CONFIG="/etc/sqlgrey/sqlgrey.conf"
local SQLgrey_DB_USER_NAME="sqlgrey"
local SQLgrey_DB_NAME="sqlgrey"
# Check if a password is set in sqlgrey.conf
local SQLgrey_CONF_PWD=""
if [ -f "${SQLgrey_CONFIG}" ]; then
if (grep -iq "^[\t ]*db_pass[\t ]*=[\t ]*.*$" ${SQLgrey_CONFIG}); then
# User already has a db_pass entry
SQLgrey_CONF_PWD="$(sed -n 's:^[\t ]*db_pass[\t ]*=[\t ]*\(.*\)[\t ]*:\1:gIp' ${SQLgrey_CONFIG})"
else
SQLgrey_CONF_PWD=""
fi
else
ewarn "SQLgrey configuration missing. Exiting now."
echo
exit 0
fi
# Check if we need SQLgrey to configure for this system or not
local SQLgrey_DB_HOST="localhost"
local SQLgrey_KEY_INPUT="l,r,x"
einfo "SQLgrey database backend configuration"
einfo " Please select where SQLgrey database will run:"
einfo " [l] Database backend runs on localhost"
einfo " [r] Database backend runs on remote host"
einfo " [x] Exit"
echo
einfo " Press one of the keys [${SQLgrey_KEY_INPUT}]: "
while true; do
read -n 1 -s SQLgrey_ACCESS_TYPE
case "${SQLgrey_ACCESS_TYPE}" in
"r" | "R" )
SQLgrey_ACCESS_TYPE="r"
einfo " remote setup"
read -p " Please enter the remote hostname: " SQLgrey_DB_HOST
echo
break
;;
"l" | "L" )
SQLgrey_ACCESS_TYPE="l"
einfo " local setup"
echo
break
;;
"x" | "X" )
exit 0
;;
esac
done
# Generate random password
if [[ "${SQLgrey_CONF_PWD}" == "" ]]; then
einfo "Generating random database user password..."
local SQLgrey_PWD_MATRIX="0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz"
local SQLgrey_DB_USER_PWD=""
while [ "${n:=1}" -le "16" ]; do
SQLgrey_DB_USER_PWD="${SQLgrey_DB_USER_PWD}${SQLgrey_PWD_MATRIX:$(($RANDOM%${#SQLgrey_PWD_MATRIX})):1}"
let n+=1
done
else
einfo "Reusing current database user password..."
local SQLgrey_DB_USER_PWD="${SQLgrey_CONF_PWD}"
fi
echo
# Configure the various database backends
local SQLgrey_KEY_INPUT=""
einfo "Creating SQLgrey database backend data and configuration"
einfo " Please select what kind of database you like to use:"
if use postgres || has_version dev-perl/DBD-Pg ; then
einfo " [p] PostgreSQL"
SQLgrey_KEY_INPUT="${SQLgrey_KEY_INPUT},p"
fi
if use mysql || has_version dev-perl/DBD-mysql ; then
einfo " [m] MySQL"
SQLgrey_KEY_INPUT="${SQLgrey_KEY_INPUT},m"
fi
if use sqlite || has_version dev-perl/DBD-SQLite ; then
einfo " [s] SQLite"
SQLgrey_KEY_INPUT="${SQLgrey_KEY_INPUT},s"
fi
einfo " [x] Exit"
SQLgrey_KEY_INPUT="${SQLgrey_KEY_INPUT},x"
echo
einfo " Press one of the keys [${SQLgrey_KEY_INPUT:1}]: "
while true; do
read -n 1 -s SQLgrey_DB_TYPE
case "${SQLgrey_DB_TYPE}" in
"p" | "P" )
SQLgrey_DB_TYPE="p"
einfo " PostgreSQL database backend"
echo
break
;;
"m" | "M" )
SQLgrey_DB_TYPE="m"
einfo " MySQL database backend"
echo
break
;;
"s" | "S" )
SQLgrey_DB_TYPE="s"
einfo " SQLite database backend"
echo
break
;;
"x" | "X" )
exit 0
;;
esac
done
# If we don't use SQLite, the password must not be set
if [[ ( "${SQLgrey_DB_TYPE}" != "s" ) && ( "${SQLgrey_CONF_PWD}" != "" ) ]]; then
ewarn "This configuration is only for new installations. You seem to"
ewarn "have already a modified sqlgrey.conf"
ewarn "Do you want to continue?"
SQLgrey_KEY_INPUT="y,n"
einfo " Press one of the keys [$SQLgrey_KEY_INPUT]: "
while true; do
read -n 1 -s SQLgrey_Ignore
case "$SQLgrey_Ignore" in
"y"|"Y" )
break
;;
"n"|"N" )
exit 0
;;
esac
done
fi
## Per-RDBMS configuration ##
# POSTGRESQL
if [[ "${SQLgrey_DB_TYPE}" == "p" ]] ; then
ewarn "If prompted for a password, please enter your PgSQL postgres password"
ewarn ""
einfo "Creating SQLgrey PostgreSQL database \"${SQLgrey_DB_NAME}\" and user \"${SQLgrey_DB_USER_NAME}\""
/usr/bin/psql -h ${SQLgrey_DB_HOST} -d template1 -U postgres -c "CREATE USER ${SQLgrey_DB_USER_NAME} WITH PASSWORD '${SQLgrey_DB_USER_PWD}' NOCREATEDB NOCREATEUSER; CREATE DATABASE ${SQLgrey_DB_NAME}; GRANT ALL PRIVILEGES ON DATABASE ${SQLgrey_DB_NAME} TO ${SQLgrey_DB_USER_NAME}; GRANT ALL PRIVILEGES ON SCHEMA public TO ${SQLgrey_DB_USER_NAME}; UPDATE pg_database SET datdba=(SELECT usesysid FROM pg_shadow WHERE usename='${SQLgrey_DB_USER_NAME}') WHERE datname='${SQLgrey_DB_NAME}';"
einfo "Changing SQLgrey configuration in sqlgrey.conf"
sed -i "s:^[# ]*\(db_type[ \t]*= \).*:\1Pg:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_user[ \t]*= \).*:\1${SQLgrey_DB_USER_NAME}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_pass[ \t]*= \).*:\1${SQLgrey_DB_USER_PWD}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_host[ \t]*= \).*:\1${SQLgrey_DB_HOST}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_name[ \t]*= \).*:\1${SQLgrey_DB_NAME}:gI" ${SQLgrey_CONFIG}
elif [[ "${SQLgrey_DB_TYPE}" == "m" ]] ; then
# MYSQL
ewarn "If prompted for a password, please enter your MySQL root password"
ewarn ""
einfo "Creating SQLgrey MySQL database \"${SQLgrey_DB_NAME}\" and user \"${SQLgrey_DB_USER_NAME}\""
echo -ne " "
/usr/bin/mysql -u root -h ${SQLgrey_DB_HOST} -p -e "CREATE DATABASE IF NOT EXISTS ${SQLgrey_DB_NAME} CHARACTER SET latin1; GRANT ALL ON ${SQLgrey_DB_NAME}.* TO ${SQLgrey_DB_USER_NAME}@${SQLgrey_DB_HOST} IDENTIFIED BY '${SQLgrey_DB_USER_PWD}';FLUSH PRIVILEGES;" -D mysql
echo
einfo "Changing SQLgrey configuration in sqlgrey.conf"
sed -i "s:^[# ]*\(db_type[ \t]*= \).*:\1mysql:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_user[ \t]*= \).*:\1${SQLgrey_DB_USER_NAME}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_pass[ \t]*= \).*:\1${SQLgrey_DB_USER_PWD}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_host[ \t]*= \).*:\1${SQLgrey_DB_HOST}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_name[ \t]*= \).*:\1${SQLgrey_DB_NAME}:gI" ${SQLgrey_CONFIG}
elif [[ "${SQLgrey_DB_TYPE}" == "s" ]] ; then
einfo "Changing SQLgrey configuration in sqlgrey.conf"
sed -i "s:^[# ]*\(db_type[ \t]*= \).*:\1SQLite:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_name[ \t]*= \).*:\1${SQLgrey_DB_NAME}:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_user[ \t]*=.*\)$:# \1:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_pass[ \t]*= .*\)$:# \1:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_host[ \t]*= .*\)$:# \1:gI" ${SQLgrey_CONFIG}
sed -i "s:^[# ]*\(db_cleandelay[ \t]*= .*\)$:# \1:gI" ${SQLgrey_CONFIG}
fi
echo
if [[ "${SQLgrey_DB_TYPE}" != "s" ]]; then
einfo "Note: the database password is stored in $SQLgrey_CONFIG"
fi
}
--
gentoo-commits@lists.gentoo.org mailing list
^ permalink raw reply [flat|nested] 5+ messages in thread
end of thread, other threads:[~2015-04-23 23:16 UTC | newest]
Thread overview: 5+ messages (download: mbox.gz follow: Atom feed
-- links below jump to the message on this page --
2011-06-21 16:11 [gentoo-commits] gentoo-x86 commit in mail-filter/sqlgrey: ChangeLog sqlgrey-1.7.6.ebuild Eray Aslan (eras)
-- strict thread matches above, loose matches on Subject: below --
2015-04-23 23:16 Manuel Rueger (mrueg)
2009-09-20 21:46 Markus Meier (maekke)
2009-09-19 16:01 Torsten Veller (tove)
2008-06-14 19:59 Tobias Scherbaum (dertobi123)
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox