Tracker
SCM

Bugs: Browse | Download .csv | Monitor

[#3150] Sympa 5.3b.5: distribution logs for lists unavailable

Date:
2007-06-25 22:29		 Priority:
3
State:
Open
Submitted by:
Thomas Berry (tmberry) 		Assigned to:
Nobody (None)
:
None		 Category:
Logs
Group:
None		 Resolution:
None
Platform:
 
Summary:
Sympa 5.3b.5: distribution logs for lists unavailable

Detailed description
When accessing the distribution logs through wwsympa an error is displayed "INTERNAL SERVER ERROR (viewlogs) - Database error."

The following message was sent to the postmaster of the server:

User postmaster@dev-list.jpl.nasa.gov has encountered an internal server error
(Web interface - ACTION : Command process) :

db_error

See logs for more details.


And the following logs were found in /var/log/messages:


Jun 25 13:03:46 dev-list wwsympa[10964]: WWSympa started
Jun 25 13:03:46 dev-list wwsympa[10964]: [robot dev-list.jpl.nasa.gov] [client 128.149.196.69] [user postmaster@dev-list.jpl.nasa.gov] [list testlist] main::do_viewlogs() do_viewlogs(0)
Jun 25 13:03:46 dev-list wwsympa[10964]: Log::get_first_db_log() Unable to execute SQL statement "SELECT date_logs AS date, robot_logs AS robot, list_logs AS list, action_logs AS action, parameters_logs AS parameters, target_email_logs AS target_email,msg_id_logs AS msg_id, status_logs AS status, error_type_logs AS error_type, user_email_logs AS user_email, client_logs AS client, daemon_logs AS daemon FROM logs_table WHERE robot_logs='dev-list.jpl.nasa.gov' AND list_logs = 'testlist' GROUP BY date_logs " : Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation '='
Jun 25 13:03:46 dev-list wwsympa[10964]: [robot dev-list.jpl.nasa.gov] [client 128.149.196.69] [user postmaster@dev-list.jpl.nasa.gov] [list testlist] main::do_viewlogs() do_viewlogs failed to get logs from DB
Jun 25 13:03:49 dev-list sympa(command)[8219]: main::DoFile() Processing /usr/local/jpl/msg/list/sympa/spool/msg/sympa@dev-list.jpl.nasa.gov.1182801826.5617 ; sender: SYMPA <sympa@dev-list.jpl.nasa.gov> ; message-id:
Jun 25 13:03:49 dev-list sympa(command)[8219]: main::DoSendMessage() Processing web message for postmaster@dev-list.jpl.nasa.gov
Jun 25 13:03:49 dev-list sympa(command)[8219]: main::DoSendMessage() Message for postmaster@dev-list.jpl.nasa.gov sent

Followup

Message
Date: 2008-02-11 12:10
Sender: David Verdin

Well it looks like a MySQL bug. We declare that we send all our messages in the UTF-8 collation when creating the SQLSource object (line 222 of SQLSource.pm): $dbh->do("SET NAMES 'utf8'"); This is the recommended behaviour in the MySQL doc: http://dev.mysql.com/doc/refman/4.1/en/charset-collation-charset.html MySQL should then handle the data transfered, converting them into its own collation prior to compare strings. However, it looks like it doesn't do this conversion. Just to be sure: is your database encoding the varchars in Latin 1 ?

Attached Files:

No Files Currently Attached

Changes:

No Changes Have Been Made to This Item
Powered By FusionForge