The mailing list for listmasters using Sympa

[Amos <address@concealed>]

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