Ci-dessous, les différences entre deux révisions de la page.
Les deux révisions précédentes Révision précédente Prochaine révision | Révision précédente | ||
doc:dak:installation_de_dak_sur_ondine [2005/08/03 16:36] lehobey |
doc:dak:installation_de_dak_sur_ondine [2005/08/03 18:06] lehobey |
||
---|---|---|---|
Ligne 1: | Ligne 1: | ||
- | ====== Installation de dak ====== | ||
- | Notes de mon installation de dak sur ondine (d'après plusieurs journaux de telles installations). | ||
- | |||
- | [[projet:machines:Ondine]] est une machine de test en **sarge**. | ||
- | |||
- | Je suis la procédure du [[/usr/share/doc/dak/README.Debian]] dont j'ai aussi fait une [[README.Debian.fr|traduction française]]. | ||
- | |||
- | ===== Installations ===== | ||
- | ==== Installation de dak ==== | ||
- | |||
- | # aptitude install dak | ||
- | |||
- | <code> | ||
- | Les NOUVEAUX paquets suivants vont être installés : | ||
- | dak libpq3 python-apt python-egenix-mxdatetime python-gnupginterface | ||
- | python-ldap python-pygresql python2.3-egenix-mxdatetime | ||
- | python2.3-egenix-mxtools python2.3-ldap python2.3-pygresql sudo | ||
- | </code> | ||
- | |||
- | === Réponses aux questions debconf === | ||
- | J'essaie de suivre au maximum les choix par défaut. | ||
- | |||
- | == Where to put the base directory for dak? == | ||
- | /opt/dak | ||
- | |||
- | == Nom d'hôte de l'archive : == | ||
- | localhost.localdomain | ||
- | |||
- | **NB** : c'est nécessaire, en l'absence de domaine perso, pour que [[rose]] fonctionne bien. | ||
- | |||
- | == Nom de votre archive : == | ||
- | archive FDL (ondine) | ||
- | |||
- | == The name of your dak user. == | ||
- | deb-dak | ||
- | |||
- | **NB** : L'utilisation d'un tiret nécessite d'être précautionneux avec postgresql. | ||
- | |||
- | == The name of your dak group. == | ||
- | debadmin | ||
- | |||
- | **NB** : Il ne demande rien sur le groupe //debuser//. | ||
- | |||
- | === Résultat === | ||
- | <code> | ||
- | Paramétrage de dak (1.0-8) ... | ||
- | Domain: localhost.localdomain | ||
- | Creating/updating dak user account and group... | ||
- | Adding group `debadmin' (105)... | ||
- | Fait. | ||
- | Ajout de l'utilisateur système deb-dak... | ||
- | Adding new user `deb-dak' (104) with group `debadmin'. | ||
- | Création du répertoire personnel /var/lib/dak. | ||
- | Creating config file /opt/dak/katie/apt.conf with new version | ||
- | Creating config file /opt/dak/katie/cron.unchecked with new version | ||
- | Creating config file /opt/dak/katie/katie.conf with new version | ||
- | Creating config file /etc/katie/katie.conf with new version | ||
- | Creating config file /opt/dak/katie/vars with new version | ||
- | Creating config file /opt/dak/katie/Contents.top with new version | ||
- | Creating config file /opt/dak/katie/templates/alicia.bug-close with new version | ||
- | Creating config file /opt/dak/katie/templates/amber.advisory with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.accepted with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.announce with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.bug-close with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.bug-experimental-fixed with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.bug-nmu-fixed with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.new with new version | ||
- | Creating config file /opt/dak/katie/templates/jennifer.override-disparity with new version | ||
- | Creating config file /opt/dak/katie/templates/katie.rejected with new version | ||
- | Creating config file /opt/dak/katie/templates/kelly.installed with new version | ||
- | Creating config file /opt/dak/katie/templates/kelly.unaccept with new version | ||
- | Creating config file /opt/dak/katie/templates/lauren.stable-rejected with new version | ||
- | Creating config file /opt/dak/katie/templates/lisa.bxa_notification with new version | ||
- | Creating config file /opt/dak/katie/templates/lisa.prod with new version | ||
- | Creating config file /opt/dak/katie/templates/melanie.bug-close with new version | ||
- | Creating config file /opt/dak/katie/templates/uma.added with new version | ||
- | </code> | ||
- | |||
- | ==== Installation de postgresql ==== | ||
- | |||
- | Je suis : | ||
- | <file> | ||
- | 6. Steps to a working dak | ||
- | ------------------------- | ||
- | |||
- | a. Have your postgresql up and running. I assume it is on the localhost, | ||
- | if not change your config files (katie.conf) for dak. | ||
- | </file> | ||
- | |||
- | # aptitude install postgresql | ||
- | |||
- | <code> | ||
- | Les NOUVEAUX paquets suivants vont être installés : | ||
- | postgresql postgresql-client | ||
- | </code> | ||
- | |||
- | === Réponses aux questions debconf === | ||
- | |||
- | == Où créer la base de données de PostgreSQL ? == | ||
- | /var/lib/postgres/data | ||
- | |||
- | == Faut-il supprimer les données à la purge du paquet ? == | ||
- | Non | ||
- | |||
- | == Paramètres régionaux utilisés par le moteur de bases de données : == | ||
- | fr_FR@euro | ||
- | |||
- | == ordre jour/mois des dates == | ||
- | Européen | ||
- | |||
- | === Résultat === | ||
- | <code> | ||
- | Paramétrage de postgresql (7.4.7-6sarge1) ... | ||
- | |||
- | Creating config file /etc/postgresql/postmaster.conf with new version | ||
- | The files belonging to this database system will be owned by user "postgres". | ||
- | This user must also own the server process. | ||
- | |||
- | The database cluster will be initialized with locale fr_FR@euro. | ||
- | |||
- | fixing permissions on existing directory /var/lib/postgres/data... ok | ||
- | creating directory /var/lib/postgres/data/base... ok | ||
- | creating directory /var/lib/postgres/data/global... ok | ||
- | creating directory /var/lib/postgres/data/pg_xlog... ok | ||
- | creating directory /var/lib/postgres/data/pg_clog... ok | ||
- | selecting default max_connections... 100 | ||
- | selecting default shared_buffers... 1000 | ||
- | creating configuration files... ok | ||
- | creating template1 database in /var/lib/postgres/data/base/1... ok | ||
- | initializing pg_shadow... ok | ||
- | enabling unlimited row size for system tables... ok | ||
- | initializing pg_depend... ok | ||
- | creating system views... ok | ||
- | loading pg_description... ok | ||
- | creating conversions... ok | ||
- | setting privileges on built-in objects... ok | ||
- | creating information schema... ok | ||
- | vacuuming database template1... ok | ||
- | copying template1 to template0... ok | ||
- | |||
- | Success. The database server should be started automatically. | ||
- | If not, you can start the database server using: | ||
- | |||
- | /etc/init.d/postgresql start | ||
- | |||
- | Creating config file /etc/postgresql/postgresql.conf with new version | ||
- | |||
- | </code> | ||
- | |||
- | Et le paquet nous informe : | ||
- | <file> | ||
- | A new PostgreSQL database structure was installed. | ||
- | |||
- | Use /usr/bin/createdb to create a specific database and | ||
- | /usr/bin/createuser to enable other users to connect to a | ||
- | PostgreSQL database. | ||
- | |||
- | In the first instance, these commands must be run by the | ||
- | user 'postgres'. | ||
- | </file> | ||
- | |||
- | ===== Configurations ===== | ||
- | ==== Création de l'utilisateur de la base ==== | ||
- | <file> | ||
- | b. run createuser YOURDAKUSERNAME with a user that is allowed to create | ||
- | databases and allow YOURDAKUSERNAME to create a database. This user | ||
- | needs to be superuser in the database as it runs COPY from a file later. | ||
- | </file> | ||
- | |||
- | # su - postgres | ||
- | $ createuser deb-dak | ||
- | |||
- | <code> | ||
- | Shall the new user be allowed to create databases? (y/n) y | ||
- | Shall the new user be allowed to create more new users? (y/n) y | ||
- | CREATE USER | ||
- | </code> | ||
- | |||
- | ==== Création des répertoires (par défaut) ==== | ||
- | <file> | ||
- | c. su - YOURDAKUSERNAME | ||
- | d. rose | ||
- | e. Watch how the directories are created. | ||
- | </file> | ||
- | |||
- | # su - deb-dak | ||
- | $ rose | ||
- | |||
- | <code> | ||
- | Creating /opt/dak/ftp/ ... | ||
- | Creating /opt/dak/ftp/pool/ ... | ||
- | Creating /opt/dak/database/dists/ ... | ||
- | Creating /opt/dak/log/ ... | ||
- | Creating /opt/dak/morgue/ ... | ||
- | Creating /opt/dak/scripts/override/ ... | ||
- | Creating /opt/dak/testing/urgencies/ ... | ||
- | Creating /opt/dak/queue/accepted/ ... | ||
- | Creating /opt/dak/queue/byhand/ ... | ||
- | Creating /opt/dak/queue/done/ ... | ||
- | Creating /opt/dak/queue/holding/ ... | ||
- | Creating /opt/dak/queue/new/ ... | ||
- | Creating /opt/dak/queue/reject/ ... | ||
- | Creating /opt/dak/queue/unchecked/ ... | ||
- | Creating /opt/dak/queue/bts_version_track/ ... | ||
- | Creating /opt/dak/web ... | ||
- | Creating /opt/dak/katie/neve-files ... | ||
- | Creating /opt/dak/morgue/shania ... | ||
- | Creating /opt/dak/morgue/rhona ... | ||
- | Creating /opt/dak/katie-database/ ... | ||
- | Creating /opt/dak/ftp/dists/unstable ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-alpha ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-amd64 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-arm ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-hppa ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-hurd-i386 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-i386 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-ia64 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-mips ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-mipsel ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-m68k ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-powerpc ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-s390 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-sh ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/binary-sparc ... | ||
- | Creating /opt/dak/ftp/dists/unstable/main/source ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-alpha ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-amd64 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-arm ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-hppa ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-hurd-i386 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-i386 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-ia64 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-mips ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-mipsel ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-m68k ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-powerpc ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-s390 ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-sh ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/binary-sparc ... | ||
- | Creating /opt/dak/ftp/dists/unstable/contrib/source ... | ||
- | Creating /opt/dak/ftp/project/experimental ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-alpha ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-amd64 ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-arm ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-hppa ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-hurd-i386 ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-i386 ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-ia64 ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-mips ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-mipsel ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-m68k ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-powerpc ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-s390 ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-sh ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/binary-sparc ... | ||
- | Creating /opt/dak/ftp/project/experimental/main/source ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-alpha ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-amd64 ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-arm ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-hppa ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-hurd-i386 ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-i386 ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-ia64 ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-mips ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-mipsel ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-m68k ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-powerpc ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-s390 ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-sh ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/binary-sparc ... | ||
- | Creating /opt/dak/ftp/project/experimental/contrib/source ... | ||
- | </code> | ||
- | |||
- | ==== Création de la base de données de dak ==== | ||
- | Son nom dans les configurations par défaut est //projectb//. | ||
- | |||
- | # su - deb-dak | ||
- | $ createdb projectb | ||
- | <code> | ||
- | CREATE DATABASE | ||
- | $ psql -l | ||
- | List of databases | ||
- | Name | Owner | Encoding | ||
- | -----------+----------+---------- | ||
- | projectb | deb-dak | LATIN9 | ||
- | template0 | postgres | LATIN9 | ||
- | template1 | postgres | LATIN9 | ||
- | (3 rows) | ||
- | |||
- | </code> | ||
- | |||
- | ==== Création du groupe ftpmaster ==== | ||
- | <file> | ||
- | f. Add a group "ftpmaster" to your postgresql database. | ||
- | At a psql prompt a CREATE GROUP ftpmaster; should do it. | ||
- | Add your YOURDAKUSERNAME to this group. | ||
- | </file> | ||
- | |||
- | # su - deb-dak | ||
- | $ psql projectb | ||
- | |||
- | <code> | ||
- | Welcome to psql 7.4.7, the PostgreSQL interactive terminal. | ||
- | |||
- | Type: \copyright for distribution terms | ||
- | \h for help with SQL commands | ||
- | \? for help on internal slash commands | ||
- | \g or terminate with semicolon to execute query | ||
- | \q to quit | ||
- | |||
- | </code> | ||
- | |||
- | projectb=# CREATE GROUP ftpmaster ; | ||
- | |||
- | CREATE GROUP | ||
- | |||
- | projectb=# ALTER GROUP ftpmaster ADD USER "deb-dak" ; | ||
- | **NB** la présence des guillemets est expliquée dans l'anomalie [[http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=23945]]. | ||
- | |||
- | ALTER GROUP | ||
- | |||
- | projectb=# \q | ||
- | |||
- | ==== Initialisation de la base de données ==== | ||
- | <file> | ||
- | g. Change to your DAKDIR/katie and run /usr/share/dak/neve -a and watch | ||
- | her creating the database. If it ends with some VACUUM and two GRANTs | ||
- | it worked. | ||
- | Be careful, neve DROPS your database, so don't run it if you like the | ||
- | data that is in that database! | ||
- | </file> | ||
- | |||
- | # su - deb-dak | ||
- | $ cd /usr/share/dak ; neve -a | ||
- | **NB :** Le //cd// est important ! | ||
- | |||
- | <code> | ||
- | Re-Creating DB... | ||
- | DROP DATABASE | ||
- | CREATE DATABASE | ||
- | You are now connected to database "projectb". | ||
- | psql:init_pool.sql:11: NOTICE: CREATE TABLE créera des séquences implicites «archive_id_seq» pour la colonne "serial" "archive.id" | ||
- | psql:init_pool.sql:11: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «archive_pkey» pour la table «archive» | ||
- | psql:init_pool.sql:11: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «archive_name_key» pour la table «archive» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:18: NOTICE: CREATE TABLE créera des séquences implicites «component_id_seq» pour la colonne "serial" "component.id" | ||
- | psql:init_pool.sql:18: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «component_pkey» pour la table «component» | ||
- | psql:init_pool.sql:18: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «component_name_key» pour la table «component» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:24: NOTICE: CREATE TABLE créera des séquences implicites «architecture_id_seq» pour la colonne "serial" "architecture.id" | ||
- | psql:init_pool.sql:24: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «architecture_pkey» pour la table «architecture» | ||
- | psql:init_pool.sql:24: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «architecture_arch_string_key» pour la table «architecture» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:29: NOTICE: CREATE TABLE créera des séquences implicites «maintainer_id_seq» pour la colonne "serial" "maintainer.id" | ||
- | psql:init_pool.sql:29: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «maintainer_pkey» pour la table «maintainer» | ||
- | psql:init_pool.sql:29: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «maintainer_name_key» pour la table «maintainer» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:34: NOTICE: CREATE TABLE créera des séquences implicites «uid_id_seq» pour la colonne "serial" "uid.id" | ||
- | psql:init_pool.sql:34: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «uid_pkey» pour la table «uid» | ||
- | psql:init_pool.sql:34: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «uid_uid_key» pour la table «uid» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:40: NOTICE: CREATE TABLE créera des séquences implicites «fingerprint_id_seq» pour la colonne "serial" "fingerprint.id" | ||
- | psql:init_pool.sql:40: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «fingerprint_pkey» pour la table «fingerprint» | ||
- | psql:init_pool.sql:40: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «fingerprint_fingerprint_key» pour la table «fingerprint» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:48: NOTICE: CREATE TABLE créera des séquences implicites «location_id_seq» pour la colonne "serial" "location.id" | ||
- | psql:init_pool.sql:48: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «location_pkey» pour la table «location» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:60: NOTICE: CREATE TABLE créera des séquences implicites «files_id_seq» pour la colonne "serial" "files.id" | ||
- | psql:init_pool.sql:60: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «files_pkey» pour la table «files» | ||
- | psql:init_pool.sql:60: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «files_filename_key» pour la table «files» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:71: NOTICE: CREATE TABLE créera des séquences implicites «source_id_seq» pour la colonne "serial" "source.id" | ||
- | psql:init_pool.sql:71: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «source_pkey» pour la table «source» | ||
- | psql:init_pool.sql:71: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «source_file_key» pour la table «source» | ||
- | psql:init_pool.sql:71: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «source_source_key» pour la table «source» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:78: NOTICE: CREATE TABLE créera des séquences implicites «dsc_files_id_seq» pour la colonne "serial" "dsc_files.id" | ||
- | psql:init_pool.sql:78: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «dsc_files_pkey» pour la table «dsc_files» | ||
- | psql:init_pool.sql:78: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «dsc_files_source_key» pour la table «dsc_files» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:92: NOTICE: CREATE TABLE créera des séquences implicites «binaries_id_seq» pour la colonne "serial" "binaries.id" | ||
- | psql:init_pool.sql:92: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «binaries_pkey» pour la table «binaries» | ||
- | psql:init_pool.sql:92: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «binaries_file_key» pour la table «binaries» | ||
- | psql:init_pool.sql:92: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «binaries_package_key» pour la table «binaries» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:102: NOTICE: CREATE TABLE créera des séquences implicites «suite_id_seq» pour la colonne "serial" "suite.id" | ||
- | psql:init_pool.sql:102: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «suite_pkey» pour la table «suite» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:108: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «suite_architectures_suite_key» pour la table «suite_architectures» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:115: NOTICE: CREATE TABLE créera des séquences implicites «bin_associations_id_seq» pour la colonne "serial" "bin_associations.id" | ||
- | psql:init_pool.sql:115: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «bin_associations_pkey» pour la table «bin_associations» | ||
- | psql:init_pool.sql:115: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «bin_associations_suite_key» pour la table «bin_associations» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:122: NOTICE: CREATE TABLE créera des séquences implicites «src_associations_id_seq» pour la colonne "serial" "src_associations.id" | ||
- | psql:init_pool.sql:122: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «src_associations_pkey» pour la table «src_associations» | ||
- | psql:init_pool.sql:122: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «src_associations_suite_key» pour la table «src_associations» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:127: NOTICE: CREATE TABLE créera des séquences implicites «section_id_seq» pour la colonne "serial" "section.id" | ||
- | psql:init_pool.sql:127: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «section_pkey» pour la table «section» | ||
- | psql:init_pool.sql:127: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «section_section_key» pour la table «section» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:133: NOTICE: CREATE TABLE créera des séquences implicites «priority_id_seq» pour la colonne "serial" "priority.id" | ||
- | psql:init_pool.sql:133: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «priority_pkey» pour la table «priority» | ||
- | psql:init_pool.sql:133: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «priority_priority_key» pour la table «priority» | ||
- | psql:init_pool.sql:133: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «priority_level_key» pour la table «priority» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:138: NOTICE: CREATE TABLE créera des séquences implicites «override_type_id_seq» pour la colonne "serial" "override_type.id" | ||
- | psql:init_pool.sql:138: NOTICE: CREATE TABLE / PRIMARY KEY créera un index implicite «override_type_pkey» pour la table «override_type» | ||
- | psql:init_pool.sql:138: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «override_type_type_key» pour la table «override_type» | ||
- | CREATE TABLE | ||
- | psql:init_pool.sql:149: NOTICE: CREATE TABLE / UNIQUE créera un index implicite «override_suite_key» pour la table «override» | ||
- | CREATE TABLE | ||
- | CREATE TABLE | ||
- | CREATE INDEX | ||
- | CREATE INDEX | ||
- | CREATE INDEX | ||
- | CREATE INDEX | ||
- | CREATE INDEX | ||
- | CREATE INDEX | ||
- | CREATE INDEX | ||
- | Adding static tables from conf file... | ||
- | Writing data to `files' table... | ||
- | Writing data to `source' table... | ||
- | Writing data to `src_associations' table... | ||
- | Writing data to `dsc_files' table... | ||
- | Writing data to `binaries' table... | ||
- | Writing data to `bin_associations' table... | ||
- | Committing... | ||
- | Running alyson... | ||
- | |||
- | Running add_constraints.sql... | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | ALTER TABLE | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | CREATE FUNCTION | ||
- | setval | ||
- | -------- | ||
- | |||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | |||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | |||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | |||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | |||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | |||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | 136 | ||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | 12 | ||
- | (1 row) | ||
- | |||
- | setval | ||
- | -------- | ||
- | 6 | ||
- | (1 row) | ||
- | |||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | VACUUM | ||
- | GRANT | ||
- | GRANT | ||
- | </code> | ||
- | |||
- | ==== Création des utilisateurs ==== | ||
- | <file> | ||
- | h. You need to get your maintainers in the database. The Debian Archive | ||
- | uses a script (emilie) that syncs with its LDAP Server, but you | ||
- | probably don't want to sync with Debian's LDAP. :) | ||
- | If you have a setup with an LDAP Server, look at emilie and their | ||
- | config options. If not, there is a script called uma which helps you | ||
- | to do this. You basically give it a keyid with the -k parameter and | ||
- | it will do the rest, after asking you if you like the action. | ||
- | If you told it to create a system user for the new account it will | ||
- | run useradd to do the stuff, for that YOURDAKUSERNAME needs sudo | ||
- | access to useradd, with NOPASSWD set. It will also add new users to | ||
- | the mail whitelist file, if you have that option enabled (it is per | ||
- | default). | ||
- | </file> | ||
- | |||
- | === uma et exim4 === | ||
- | Il est nécessaire, pour que les courriels d'[[uma]] partent, d'avoir ajouté à ///etc/email-addresses// quelque chose qui ressemble à : | ||
- | <file> | ||
- | nobody: LEHOBEY@free.fr | ||
- | </file> | ||
- | |||
- | === uma et sudo === | ||
- | J'ajoute la ligne suivante à la configuration de sudo (///etc/sudoers//), avec //visudo// : | ||
- | <file> | ||
- | deb-dak ALL = NOPASSWD: /usr/sbin/useradd | ||
- | </file> | ||
- | |||
- | === Initialisation du trousseau de deb-dak === | ||
- | <file> | ||
- | k. You should setup the keyring for katie now. Do a command similar to | ||
- | the following, but adjust your path: | ||
- | gpg --no-default-keyring --keyring /opt/dak/keyrings/keyring.gpg | ||
- | </file> | ||
- | |||
- | Que je comprends comme s'appliquant à l'utilisateur //deb-dak//. | ||
- | |||
- | # su - deb-dak | ||
- | $ gpg --no-default-keyring --keyring /opt/dak/keyrings/keyring.gpg --keyserver pgp.mit.edu --recv-keys 2B022951 | ||
- | <code> | ||
- | gpg: directory `/var/lib/dak/.gnupg' created | ||
- | gpg: new configuration file `/var/lib/dak/.gnupg/gpg.conf' created | ||
- | gpg: WARNING: options in `/var/lib/dak/.gnupg/gpg.conf' are not yet active during this run | ||
- | gpg: keyring `/var/lib/dak/.gnupg/secring.gpg' created | ||
- | gpg: keyring `/opt/dak/keyrings/keyring.gpg' created | ||
- | gpg: requesting key 2B022951 from hkp server pgp.mit.edu | ||
- | gpg: key 2B022951: duplicated user ID detected - merged | ||
- | gpg: /var/lib/dak/.gnupg/trustdb.gpg: trustdb created | ||
- | gpg: key 2B022951: public key "Frederic LEHOBEY <Frederic.Lehobey@free.fr>" imported | ||
- | gpg: no ultimately trusted keys found | ||
- | gpg: Total number processed: 1 | ||
- | gpg: imported: 1 | ||
- | </code> | ||
- | |||
- | ===== Désinstallations ===== | ||
- | ==== Désinstallation de dak ==== | ||
- | Avec les ajouts nécessaires pour contourner l'anomalie de dak dans sarge (avec les valeurs de debconf par défaut). | ||
- | |||
- | # aptitude purge dak | ||
- | |||
- | Pour virer les configurations oubliées par l'anomalie : | ||
- | # ucf --purge /opt/dak/katie/apt.conf | ||
- | # ucf --purge /opt/dak/katie/cron.unchecked | ||
- | # ucf --purge /opt/dak/katie/katie.conf | ||
- | # ucf --purge /etc/katie/katie.conf | ||
- | # ucf --purge /opt/dak/katie/vars | ||
- | # ucf --purge /opt/dak/katie/Contents.top | ||
- | |||
- | Pour faire le propre : | ||
- | # rm -r /etc/katie | ||
- | (attention, ci-dessous c'est toute l'archive que le mainteneur a fait exprès de laisser) | ||
- | # rm -r /opt/dak | ||
- | |||
- | **Penser à virer le //crontab// de deb-dak** si on a mis quelque chose dedans. | ||
- | |||
- | Pour aussi virer les utilisateur et groupe créés. | ||
- | # deluser deb-dak | ||
- | # delgroup debadmin | ||
- | et s'il a été créé : | ||
- | # delgroup debuser |