[Pkg-sympa-devel] Bug#651942: Upgrade from sympa_5.3.4-6.1 fails (relation "conf_table" does not exist)

[Giorgio Volpe]

OK! I succeeded in upgrading! Thanks to David!

I've not only created conf_table but, by hand, upgraded all database structure. (diff  between old and new create_db).
On the bottom of this mail the SQL I've used ... if may be useful for somebody.

Than, when upgrading with "apt-get install sympa" there was till an error.
I ran "sympa.pl --upgrade" and get:

      "Cannot access cafile /usr/share/sympa/ca-bundle.crt"

I copied the old file "ca-bundle.crt" from 5.4 files and than upgrade went ok till the end.

The file was deleted while upgrading debian package: is this an error?

(now problems with wwsympa but this is another story!)

Giorgio

------------------------------------------------------

alter table user_table add column last_login_date_user  int4;
alter table user_table add column last_login_host_user  varchar (60);
alter table user_table add column wrong_login_count_user  int4;
alter table user_table add column data_user               varchar (255);

alter table subscriber_table add column custom_attribute_subscriber varchar (500);
alter table subscriber_table add column suspend_subscriber      smallint;
alter table subscriber_table add column suspend_start_date_subscriber    int4;
alter table subscriber_table add column suspend_end_date_subscriber      int4;
CREATE INDEX subscriber_idx2 ON subscriber_table (user_subscriber);

alter TABLE admin_table add column visibility_admin        varchar(20);

CREATE TABLE exclusion_table (
         list_exclusion          varchar(50),
         user_exclusion          varchar(100),
         date_exclusion          int4,
         CONSTRAINT ind_exclusion PRIMARY KEY (list_exclusion, user_exclusion)
);
CREATE  INDEX exclusion_idx ON exclusion_table(list_exclusion, user_exclusion);

CREATE TABLE session_table (
         id_session                      int8 NOT NULL,
         start_date_session              int4 NOT NULL,
         date_session                    int4 NOT NULL,
         remote_addr_session             varchar(60),
         robot_session                   varchar(80),
         email_session                   varchar(100),
         hit_session                     int4,
         data_session                    varchar(255),
         CONSTRAINT ind_session PRIMARY KEY (id_session)
);
CREATE  INDEX session_idx ON session_table(id_session);

CREATE TABLE one_time_ticket_table (
         ticket_one_time_ticket          varchar(30),
         robot_one_time_ticket           varchar(80),
         email_one_time_ticket           varchar(100),
         date_one_time_ticket            bigint,
         data_one_time_ticket            varchar(200),
         remote_addr_one_time_ticket     varchar(60),
         status_one_time_ticket  varchar(60),
         CONSTRAINT ind_one_time_ticket PRIMARY KEY (ticket_one_time_ticket)
);
CREATE  INDEX one_time_ticket_idx ON one_time_ticket_table(ticket_one_time_ticket);

CREATE TABLE bulkmailer_table(
         messagekey_bulkmailer   varchar(80),
         packetid_bulkmailer     varchar(33),
         messageid_bulkmailer    varchar(100),
         receipients_bulkmailer  text,
         returnpath_bulkmailer   varchar(100),
         robot_bulkmailer        varchar(80),
         listname_bulkmailer     varchar(50),
         verp_bulkmailer         smallint,
         merge_bulkmailer        smallint,
         priority_message_bulkmailer     int4,
         priority_packet_bulkmailer      int4,
         reception_date_bulkmailer       int4,
         delivery_date_bulkmailer        int4,
         lock_bulkmailer         varchar(30),
         constraint ind_bulkmailer PRIMARY KEY (messagekey_bulkmailer, packetid_bulkmailer)
);
CREATE INDEX  messagekey_bulkmailer_idx ON bulkmailer_table(messagekey_bulkmailer);
CREATE INDEX  packetid_bulkmailer_idx ON bulkmailer_table(packetid_bulkmailer);

CREATE TABLE bulkspool_table (
         messagekey_bulkspool    varchar(33),
         messageid_bulkspool     varchar(100),
         message_bulkspool       text,
         lock_bulkspool  smallint,
         dkim_privatekey_bulkspool  varchar(100),
         dkim_selector_bulkspool varchar(50),
         dkim_d_bulkspool varchar(50),
         dkim_i_bulkspool varchar(50),
         dkim_header_list_bulkspool varchar(500),
         constraint ind_bulkspool primary key (messagekey_bulkspool)
);
CREATE INDEX messagekey_bulkspool_idx ON bulkspool_table(messagekey_bulkspool);

CREATE TABLE conf_table (
   robot_conf varchar(80),
   label_conf varchar(80),
   value_conf varchar(300),
   constraint ind_conf primary key (robot_conf,label_conf)
);
CREATE INDEX robot_conf_idx ON conf_table(robot_conf,label_conf);

GRANT ALL on exclusion_table,session_table, one_time_ticket_table, bulkmailer_table,bulkspool_table, conf_table TO sympa;


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.alioth.debian.org/pipermail/pkg-sympa-devel/attachments/20120106/be5ff065/attachment.html>