Skip to Content.
Sympa Menu

en - [sympa-users] problem installing a debian wheezy-backport sympa 6.1.22

Subject: The mailing list for listmasters using Sympa

List archive

Chronological Thread  
  • From: Daniel Viñar Ulriksen <address@concealed>
  • To: "address@concealed" <address@concealed>
  • Subject: [sympa-users] problem installing a debian wheezy-backport sympa 6.1.22
  • Date: Sun, 06 Jul 2014 15:54:38 -0300

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



Archive powered by MHonArc 2.6.19+.

Top of Page