+2004-10-01 Roland Mas <99.roland.mas@aist.enst.fr>
+
+ * db/20041001.sql, deb-specific/db-upgrade.pl: Created new views
+ for NSS-PGSQL.
+
2004-09-29 Francisco Gimeno <kikov@kikov.org>
* gforge-plugin-scmsvn/include/SVNPlugin.class,
--- /dev/null
+CREATE VIEW nss_groups AS
+ SELECT group_id+10000 AS gid,
+ unix_group_name AS name,
+ CHAR(1) 'x' AS passwd
+ FROM groups;
+
+CREATE VIEW nss_accounts AS
+ SELECT unix_uid+20000 AS uid,
+ unix_uid+20000 AS gid,
+ user_name AS login,
+ unix_pw AS passwd,
+ realname AS gecos,
+ shell,
+ '/var/lib/gforge/chroot/home/users/' || user_name AS homedir
+ FROM users
+ WHERE status='A';
+
+CREATE VIEW nss_usergroups AS
+ SELECT group_id+10000 AS gid,
+ user_id+20000 AS uid
+ FROM user_group
+ WHERE group_id!=800; -- drop unused and overfull Debian group
$dbh->commit () ;
}
+ $version = &get_db_version ;
+ $target = "3.3.0-2+3" ;
+ if (&is_lesser ($version, $target)) {
+ &debug ("Upgrading with 20041001.sql") ;
+
+ @reqlist = @{ &parse_sql_file ("/usr/lib/gforge/db/20041001.sql") } ;
+ foreach my $s (@reqlist) {
+ $query = $s ;
+ # debug $query ;
+ $sth = $dbh->prepare ($query) ;
+ $sth->execute () ;
+ $sth->finish () ;
+ }
+ @reqlist = () ;
+
+ &update_db_version ($target) ;
+ &debug ("Committing.") ;
+ $dbh->commit () ;
+ }
+
&debug ("It seems your database $action went well and smoothly. That's cool.") ;
&debug ("Please enjoy using Gforge.") ;
* [Christian] Changed default sys_theme to gforge, so web frontend is not
broken when theme pack is not installed
* [Christian] sys_project_reg_restricted=false by default
+ * [Roland] Added views for NSS-PGSQL (form Wichert Akkerman).
- -- Christian Bayle <bayle@debian.org> Mon, 20 Sep 2004 12:48:07 +0200
+ -- Roland Mas <lolando@debian.org> Fri, 1 Oct 2004 13:25:09 +0200
gforge (3.3.0-12) unstable; urgency=low