The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

I couldn't agree more with your reaction. It is indeed a pain to people using other RDBMS to update to a new Sympa version.
We did some work recently to at least have correct (auto-genreated) db creation script for each RDBMS. It's in the development trunk. But we still did not find the time to code a universal db updater.

Subsequently to the current thread, several people manifested interest towards this issue and offred some help. So you may see some future improvments on this topic sooner than expected.

Regards,

David

Amos a écrit :

I have to agree.  It's rather tedious to look at a recent db dump, and
the current db create script, and try to deduce what changed, and what
I need to do.   Realistically, this negates the usefulness of the
other db products, and we'll likely see about migrating this app to
mysql.


On Fri, Dec 3, 2010 at 3:13 AM, Holger Rabbach (ICT)
<address@concealed> wrote:
  

Hi David,



What would have been helpful would have been at least a document that lists
the differences between the previous and the current database schema. Even
if you can’t make it automatic for postgresql users, by not providing that
kind of information, you’re making it harder than necessary…



Best regards,

Holger



From: address@concealed [mailto:address@concealed] On
Behalf Of David Verdin
Sent: 03 December 2010 09:23
To: address@concealed
Subject: Re: [sympa-users] upgrade process: is postgresql supported?



Hi Amos,

Sorry, the db upgrade is automatic for MySQL and SQLite only. We don't have
enough expertise with the other RDBMS to provide an automatic upgrade.
For PostgreSQL, Sybase and Oracle, you must update the database manually. We
provide the query to use to create the database in the sources directory:
src/etc/script

Regards,

David

Le 02/12/2010 21:43, Amos a écrit :

When attempting to upgrade from 6.0.3 to 6.1.3 I get an error because

a table doesn't have the column wrong_login_count_user.  This is what

it looks like.  I tried to open a bug issue for this, but must admit

that tracker doesn't seem to be very intuitive (I guess I'm too used

to JIRA.)





dsympa:/opt/sympa# /opt/sympa/bin/sympa.pl --upgrade

info Configuration file read, default log level 1

debug Conf::_load_auth() Conf::_load_auth(/opt/sympa/etc/auth.conf)

debug Running server 13444 for sympa purpose

notice Sympa 6.1.3 started

notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2

has changed; updating static CSS file

/opt/sympa/static_content/css/sty

le.css ; previous file renamed

notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2

has changed; updating static CSS file

/opt/sympa/static_content/css/pri

nt.css ; previous file renamed

notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2

has changed; updating static CSS file

/opt/sympa/static_content/css/ful

lPage.css ; previous file renamed

notice Conf::checkfiles() TT2 file /opt/sympa/default/web_tt2/css.tt2

has changed; updating static CSS file

/opt/sympa/static_content/css/pri

nt-preview.css ; previous file renamed

DBD::Pg::st execute failed: ERROR:  column "wrong_login_count_user"

does not exist

LINE 1: ...AS data, last_login_date_user AS last_login_date, wrong_logi...

                                                             ^ at

/opt/sympa/bin/List.pm line 4819.

err List::get_user_db() Unable to execute SQL statement "SELECT

email_user AS email, gecos_user AS gecos, password_user AS password,

cookie_d

elay_user AS cookie_delay, lang_user AS lang , attributes_user AS

attributes, data_user AS data, last_login_date_user AS

last_login_date, wro

ng_login_count_user AS wrong_login_count, last_login_host_user AS

last_login_host FROM user_table WHERE email_user = 'address@concealed' " :

ERROR:  column "wrong_login_count_user" does not exist

LINE 1: ...AS data, last_login_date_user AS last_login_date, wrong_logi...

                                                             ^

debug Language::PushLang() Language::PushLang(en_US)

debug Language::PopLang()

debug mail::sending() NOT USING BULK

notice Upgrade process...

notice Upgrading from 6.0.3 to 6.1.3...

notice Upgrade::upgrade() Upgrade::upgrade(6.0.3, 6.1.3)

notice Upgrade::upgrade() Rebuilding config.bin files for ALL

lists...it may take a while...





--
David Verdin
Comité réseau des universités

Due to the limitations of human brain, I fail to remember all the mails.
So if you want your bug reports or feature requests for Sympa to be
processed, please post them to the Sympa tracker