The mailing list for listmasters using Sympa

[David Verdin <address@concealed>]

Le 10/07/14 05:23, Daniel Viñar Ulriksen a écrit :

address@concealed">

Sorry - this mail just after my first on sunday left wuth a wrong "from". Thanks for your valuable answers.
I answer to myself:
I forgot to mention I user postgresql, and I think I found the answer here:
https://www.sympa.org/manual_6.1/database#database_automatic_creation_and_update

sympa.pl process will create the database or update its structure for you. Note however that this feature is available with mysql and SQLite only,

with postgres, I have to manually update my database structure.

Indeed. Good news: Sympa 6.2 does the automatic upgrade for PostgreSQL too. :)

address@concealed">

regards!
daniel

El 06/07/14 15:54, Daniel Viñar Ulriksen escribió:

address@concealed">

Hello,

e are experimenting bounce problems (specially to yahoo) so I want to
update our sympa server 6.1.7 on a debian squeeze
(www.softwarelibre.edu.uy and virtual robots) to a 6.1.22 on a debian
wheezy.

First I'm triyng to install a clean 6.1.22 on a debian wheezy server.

After triyng to deal with the fcgi and the cpan modules, I realized it
was the
use_fast_cgi    1
in /etc/sympa/wwsympa.conf

Now I can see the wws interface: https://watson.csic.edu.uy/wws/

I try to activate a sympa account: it sends me the ont-shot URL, but
when I want to set up the password, it fails to login. Nor wws can open
a session, as we can see in the log:

Jul  6 15:42:29 watson wwsympa[32333]: err ::load() Unable to execute SQL statement "SELECT id_session AS id_session, prev_id_session AS prev_id,#012#011#011     date_session AS "date",#012#011#011     remote_addr_session AS remote_addr,#012#011#011     email_session AS email,#012#011#011     data_session AS data, hit_session AS hit,#012#011#011     start_date_session AS start_date,#012#011#011     refresh_date_session AS refresh_date#012#011      FROM session_table#012#011      WHERE id_session = ? AND prev_id_session IS NOT NULL OR#012#011#011    prev_id_session = ?" : ERROR:  no existe la columna <AB>prev_id_session<BB>#012LINE 1: SELECT id_session AS id_session, prev_id_session AS prev_id,#012                                         ^
Jul  6 15:42:29 watson wwsympa[32333]: err List::send_notify_to_listmaster() List::send_notify_to_listmaster(failed_to_create_web_session,watson.csic.edu.uy) : error on incoming parameter "$param", it must be a ref on HASH or a ref on ARRAY
Jul  6 15:42:29 watson wwsympa[32333]: info [robot watson.csic.edu.uy] [client 179.25.174.99] Failed to create session
Jul  6 15:42:29 watson wwsympa[32333]: info [robot watson.csic.edu.uy] [session 35705656223149] [client 179.25.174.99] main::do_firstpasswd() do_firstpasswd()
Jul  6 15:42:29 watson wwsympa[32333]: info [robot watson.csic.edu.uy] [session 35705656223149] [client 179.25.174.99] main::do_renewpasswd() do_renewpasswd()
Jul  6 15:42:29 watson wwsympa[32333]: err SympaSession::store() Unable to update session information in database while execute SQL statement "INSERT INTO session_table#012#011      (id_session, prev_id_session,#012#011       date_session, refresh_date_session,#012#011       remote_addr_session, robot_session,#012#011       email_session, start_date_session, hit_session, data_session)#012#011      VALUES ('35705656223149', '35705656223149', 1404672149, 1404672149, '179.25.174.99', 'watson.csic.edu.uy', 'nobody', 1404672149, 1, ';is_family_owner="";redirect_url="https://watson.csic.edu.uy/wws/firstpasswd/";data="""')"" : ERROR:  no existe la columna <AB>prev_id_session<BB> en la relaci<F3>n <AB>session_table<BB>#012LINE 2:        (id_session, prev_id_session,#012                            ^

It seems that sympa or wwsympa can't write or read in the database.
Where am I doing wrong?

Thanks for your help.
daniel

--
A bug in Sympa? Quick! To the bug tracker!

David Verdin Études et projets applicatifs
Tél : +33 2 23 23 69 71 Fax : +33 2 23 23 71 21   www.renater.fr	RENATER 263 Avenue du Gal Leclerc 35042 Rennes Cedex

Attachment: smime.p7s
Description: Signature cryptographique S/MIME