<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=ISO-8859-15">
  </head>
  <body bgcolor="#FFFFFF" text="#000000">
    <font face="Helvetica, Arial, sans-serif">OK! I succeeded in
      upgrading! Thanks to David!<br>
      <br>
      I've not only created conf_table but, by hand, upgraded all
      database structure. (diff  between old and new create_db).<br>
      On the bottom of this mail the SQL I've used ... if may be useful
      for somebody.<br>
      <br>
      Than, when upgrading with "apt-get install sympa" there was till
      an error.<br>
      I ran "sympa.pl --upgrade" and get:<br>
      <br>
           "Cannot access cafile /usr/share/sympa/ca-bundle.crt"<br>
      <br>
      I copied the old file "ca-bundle.crt" from 5.4 files and than
      upgrade went ok till the end.<br>
      <br>
      The file was deleted while upgrading debian package: is this an
      error?<br>
      <br>
      (now problems with wwsympa but this is another story!)<br>
      <br>
      Giorgio<br>
      <br>
      ------------------------------------------------------<br>
      <br>
      alter table user_table add column last_login_date_user  int4;<br>
      alter table user_table add column last_login_host_user  varchar
      (60);<br>
      alter table user_table add column wrong_login_count_user  int4;<br>
      alter table user_table add column data_user               varchar
      (255);<br>
      <br>
      alter table subscriber_table add column
      custom_attribute_subscriber varchar (500);<br>
      alter table subscriber_table add column suspend_subscriber     
      smallint;<br>
      alter table subscriber_table add column
      suspend_start_date_subscriber    int4;<br>
      alter table subscriber_table add column
      suspend_end_date_subscriber      int4;<br>
      CREATE INDEX subscriber_idx2 ON subscriber_table
      (user_subscriber);<br>
      <br>
      alter TABLE admin_table add column visibility_admin       
      varchar(20);<br>
      <br>
      CREATE TABLE exclusion_table (<br>
              list_exclusion          varchar(50),<br>
              user_exclusion          varchar(100),<br>
              date_exclusion          int4,<br>
              CONSTRAINT ind_exclusion PRIMARY KEY (list_exclusion,
      user_exclusion)<br>
      );<br>
      CREATE  INDEX exclusion_idx ON exclusion_table(list_exclusion,
      user_exclusion);<br>
      <br>
      CREATE TABLE session_table (<br>
              id_session                      int8 NOT NULL,<br>
              start_date_session              int4 NOT NULL,<br>
              date_session                    int4 NOT NULL,<br>
              remote_addr_session             varchar(60),<br>
              robot_session                   varchar(80),<br>
              email_session                   varchar(100),<br>
              hit_session                     int4,<br>
              data_session                    varchar(255),<br>
              CONSTRAINT ind_session PRIMARY KEY (id_session)<br>
      );<br>
      CREATE  INDEX session_idx ON session_table(id_session);<br>
      <br>
      CREATE TABLE one_time_ticket_table (<br>
              ticket_one_time_ticket          varchar(30),<br>
              robot_one_time_ticket           varchar(80),<br>
              email_one_time_ticket           varchar(100),<br>
              date_one_time_ticket            bigint,<br>
              data_one_time_ticket            varchar(200),<br>
              remote_addr_one_time_ticket     varchar(60),<br>
              status_one_time_ticket  varchar(60),<br>
              CONSTRAINT ind_one_time_ticket PRIMARY KEY
      (ticket_one_time_ticket)<br>
      );<br>
      CREATE  INDEX one_time_ticket_idx ON
      one_time_ticket_table(ticket_one_time_ticket);<br>
      <br>
      CREATE TABLE bulkmailer_table(<br>
              messagekey_bulkmailer   varchar(80),<br>
              packetid_bulkmailer     varchar(33),<br>
              messageid_bulkmailer    varchar(100),<br>
              receipients_bulkmailer  text,<br>
              returnpath_bulkmailer   varchar(100),<br>
              robot_bulkmailer        varchar(80),<br>
              listname_bulkmailer     varchar(50),<br>
              verp_bulkmailer         smallint,<br>
              merge_bulkmailer        smallint,<br>
              priority_message_bulkmailer     int4,<br>
              priority_packet_bulkmailer      int4,<br>
              reception_date_bulkmailer       int4,<br>
              delivery_date_bulkmailer        int4,<br>
              lock_bulkmailer         varchar(30),<br>
              constraint ind_bulkmailer PRIMARY KEY
      (messagekey_bulkmailer, packetid_bulkmailer)<br>
      );<br>
      CREATE INDEX  messagekey_bulkmailer_idx ON
      bulkmailer_table(messagekey_bulkmailer);<br>
      CREATE INDEX  packetid_bulkmailer_idx ON
      bulkmailer_table(packetid_bulkmailer);<br>
      <br>
      CREATE TABLE bulkspool_table (<br>
              messagekey_bulkspool    varchar(33),<br>
              messageid_bulkspool     varchar(100),<br>
              message_bulkspool       text,<br>
              lock_bulkspool  smallint,<br>
              dkim_privatekey_bulkspool  varchar(100),<br>
              dkim_selector_bulkspool varchar(50),<br>
              dkim_d_bulkspool varchar(50),<br>
              dkim_i_bulkspool varchar(50),<br>
              dkim_header_list_bulkspool varchar(500),<br>
              constraint ind_bulkspool primary key
      (messagekey_bulkspool)<br>
      );<br>
      CREATE INDEX messagekey_bulkspool_idx ON
      bulkspool_table(messagekey_bulkspool);<br>
      <br>
      CREATE TABLE conf_table (<br>
        robot_conf varchar(80),<br>
        label_conf varchar(80),<br>
        value_conf varchar(300),<br>
        constraint ind_conf primary key (robot_conf,label_conf)<br>
      );<br>
      CREATE INDEX robot_conf_idx ON conf_table(robot_conf,label_conf);<br>
      <br>
      GRANT ALL on exclusion_table,session_table, one_time_ticket_table,
      bulkmailer_table,bulkspool_table, conf_table TO sympa;<br>
      <br>
      <br>
    </font>
  </body>
</html>