null when working on tickets

[Michael LiVolsi]

I have an interesting issue.

There's an issue that whenever  a particular person opens up a ticket, or replies to a ticket, it gets set to null in the "ticket_change" table under "author".

We authenticate against LDAP, but I compared them to active users, and their account seems correct.

The only thing that stood out was in the session_attribute table. This person did not have an email record. I manually added it. I'm not 100% sure this will fix the issue as there are a number of active users without this attribute but doesn't seem to affect them. 

Is there anything else I should be looking at ?

[Jun Omae]

I guess that something wrong in your installed plugin(s) leads the
issue. Trac core doesn't have the issue.

* What version of Trac are you using?
See "System Information" in /about page of your Trac.
* What plugins installed and enabled are you using?
See "Installed Plugins" in /about page of your Trac.
* Please share your trac.ini

--
Jun Omae <jun...@gmail.com> (大前 潤)

[Michael LiVolsi]

Trac 1.4.3

Plugins:

Name
Version
Location
remote-user-auth
N/A
/var/trac/sites/traffic/plugins/remote-user-auth.pyc
TicketImport
0.9.1
/usr/local/lib/python2.7/dist-packages/TicketImport-0.9.1-py2.7.egg
TracAccountManager
0.6.dev0
/home/admin/.local/lib/python2.7/site-packages
TracAutocompleteUsersPlugin
0.4.8.dev0
/usr/local/lib/python2.7/dist-packages
TracCustomFieldAdmin
0.4.0.dev0
/usr/local/lib/python2.7/dist-packages
TracHtmlNotificationPlugin
0.12.0.3
/usr/local/lib/python2.7/dist-packages
TracSimpleTicket
5.0
/usr/local/lib/python2.7/dist-packages
TracSubTickets
0.5.5.dev0
/usr/local/lib/python2.7/dist-packages/TracSubTickets-0.5.5.dev0-py2.7.egg
TracTags
0.12.1
/usr/local/lib/python2.7/dist-packages
TracTocMacro
12.0.0
/usr/local/lib/python2.7/dist-packages

Trac.ini (removed PII info)

# -*- coding: utf-8 -*-

[TracPM]
date_format = %Y-%m-%d
default_estimate = 4.0
estimate_pad = 0.0
goal_ticket_type = milestone
hours_per_estimate = 1

[account-manager]
account_changes_notify_addresses = xx...@xxx.xxx
auth_init = enabled
authentication_url =
db_htdigest_realm =
default_format.email = text/plain
force_passwd_change = disabled
hash_method = HtDigestHashMethod
htdigest_file =
htdigest_realm =
htpasswd_file = blanked_out_for_obvious
htpasswd_hash_type = crypt
notify_actions = new,delete
password_file =
password_store = HtPasswdStore
persistent_sessions = enabled
refresh_passwd = disabled
verify_email = disabled

[attachment]
max_size = 8388608
max_zip_size = 8388608
render_unsafe_content = disabled

[browser]
color_scale = enabled
downloadable_paths = /trunk,/branches/*,/tags/*
hide_properties = svk:merge
intermediate_color =
intermediate_point =
newest_color = (255, 136, 136)
oldest_color = (136, 136, 255)
oneliner_properties = trac:summary
render_unsafe_content = disabled
wiki_properties = trac:description

[changeset]
max_diff_bytes = 10000000
max_diff_files = 0
wiki_format_messages = enabled

[components]
acct_mgr.admin.accountmanageradminpage = enabled
acct_mgr.admin.accountmanageradminpanel = enabled
acct_mgr.admin.configurationadminpanel = enabled
acct_mgr.admin.useradminpanel = enabled
acct_mgr.api.accountmanager = enabled
acct_mgr.configurationadminpanel = enabled
acct_mgr.db.sessionstore = enabled
acct_mgr.htfile.abstractpasswordfilestore = enabled
acct_mgr.htfile.htdigeststore = enabled
acct_mgr.htfile.htpasswdstore = enabled
acct_mgr.http.httpauthstore = enabled
acct_mgr.notification.accountchangelistener = enabled
acct_mgr.notification.accountchangenotificationadminpanel = enabled
acct_mgr.pwhash.htdigesthashmethod = enabled
acct_mgr.pwhash.htpasswdhashmethod = enabled
acct_mgr.svnserve.svnservepasswordstore = enabled
acct_mgr.useradminpanel = enabled
acct_mgr.web_ui.accountmodule = disabled
acct_mgr.web_ui.loginmodule = disabled
announcer.* = enabled
autocompleteusers.* = enabled
customfieldadmin.* = enabled
datefield.* = enabled
ldapplugin.* = enabled
simpleticket.* = enabled
talm_importer.importer.* = enabled
trac.db.mysql_backend.mysqlconnector = disabled
trac.db.postgres_backend.postgresqlconnector = enabled
trac.web.auth.* = disabled
trachtmlnotification.* = enabled
trachtmlnotification.notification.htmlnotificationmodule = enabled
tracjsgantt.* = enabled
tracopt.ticket.deleter.ticketdeleter = enabled
tracopt.versioncontrol.svn.svn_fs.subversionconnector = enabled
tracopt.versioncontrol.svn.svn_prop.subversionmergepropertydiffrenderer = enabled
tracopt.versioncontrol.svn.svn_prop.subversionmergepropertyrenderer = enabled
tracopt.versioncontrol.svn.svn_prop.subversionpropertyrenderer = enabled
tracsubtickets.api.* = enabled
tracsubtickets.web_ui.* = enabled
tractoc.* = enabled

[datefield]
format = ymd
separator = /

[header_logo]
alt = XXXXX
height = 66
link = /traffic/
src = /img/logo.gif
width = 217

[inherit]
htdocs_dir =
plugins_dir =
templates_dir = /var/trac/sites/traffic/templates/

[logging]
log_file = trac.log
log_format =
log_level = DEBUG
log_type = file

[mainnav]
admin.order = 8.0
browser.order = 3.0
newticket.order = 2.0
roadmap.order = 6.0
search.order = 7.0
tickets.order = 4.0
timeline.order = 5.0
wiki.label = Home
wiki.order = 1.0

[metanav]
about.order = 5.0
help.order = 4.0
login.order = 1.0
logout.order = 2.0
prefs.order = 3.0

[milestone]
default_group_by = component
default_retarget_to =
stats_provider = DefaultTicketGroupStatsProvider

[mimeviewer]
max_preview_size = 262144
mime_map = text/x-dylan:dylan,text/x-idl:ice,text/x-ada:ads:adb
mime_map_patterns = text/html:README(?!\.rst)|INSTALL(?!\.rst)|COPYING.*
tab_width = 8
treat_as_binary = application/octet-stream,application/pdf,application/postscript,application/msword,application/rtf

[notification]
admit_domains =
ambiguous_char_width = single
batch_subject_template = ${prefix} Batch modify: ${tickets_descr}
default_format.email = text/plain
email_address_resolvers = SessionEmailResolver
email_sender = SmtpEmailSender
ignore_domains =
message_id_hash = md5
mime_encoding = base64
sendmail_path = sendmail
smtp_always_bcc =
smtp_always_cc =
smtp_default_domain = XXXX.org
smtp_enabled = enabled
smtp_from = ad...@trac.XXXX
smtp_from_author = disabled
smtp_from_name = Trafficking System
smtp_password = xxxxxxx
smtp_port = xxx
smtp_replyto =
smtp_server = smtp.gmail.com
smtp_subject_prefix = Traffic
smtp_user = admin@XXXXX
ticket_subject_template = ${prefix} [${ticket.owner}] #${ticket.id}: ${summary}
use_public_cc = enabled
use_short_addr = disabled
use_tls = enabled

[notification-subscriber]
always_notify_cc = CarbonCopySubscriber
always_notify_owner = TicketOwnerSubscriber
always_notify_previous_updater = TicketPreviousUpdatersSubscriber
always_notify_reporter = TicketReporterSubscriber
always_notify_updater = disable

[project]
admin =
admin_trac_url = .
descr = Ticketing System for the XXXXX
footer = Visit the Trac open source project at<br /><a href="https://trac.edgewall.org/">https://trac.edgewall.org/</a>
icon = common/trac.ico
name = Traffic
url = https://trac.xxxx.xxxx/traffic/

[query]
default_anonymous_query = status!=closed&cc~=$USER
default_query = status!=closed&owner=$USER
items_per_page = 100
ticketlink_query = ?status=!closed

[report]
items_per_page = 100
items_per_page_rss = 0

[revisionlog]
default_log_limit = 100
graph_colors = #cc0,#0c0,#0cc,#00c,#c0c,#c00

[roadmap]
stats_provider = DefaultTicketGroupStatsProvider

[search]
default_disabled_filters =
min_query_length = 3

[sqlite]
extensions =

[svn]
branches = trunk,branches/*
tags = tags/*

[ticket]
allowed_empty_fields = milestone,version
default_cc =
default_component = xxxxx.xxx
default_description =
default_keywords =
default_milestone =
default_owner = < default >
default_priority = Normal
default_resolution = complete
default_severity =
default_summary =
default_type =
default_version =
max_comment_size = 262144
max_description_size = 262144
max_summary_size = 262144
preserve_newlines = default
restrict_owner = enabled
workflow = ConfigurableTicketWorkflow

[ticket-custom]
approval = text
approval.format = plain
approval.label = Additional approval
approval.order = 6
approval.value =
current_status = select
current_status.label = Current status
current_status.options = None|To-Do|Doing|Done
current_status.order = 8
current_status.value = None
department = select
department.label = Submitting department
department.options = xxxxx
department.order = 1
department.value =
due_date = time
due_date.date = enabled
due_date.date_empty = disabled
due_date.format = date
due_date.label = Due Date
due_date.order = 2
due_date.value =
home_page = checkbox
home_page.label = Affects home page?
home_page.order = 3
home_page.value = 0
job_code = text
job_code.format = plain
job_code.label = Project job code
job_code.order = 7
job_code.value =
member_email = checkbox
member_email.label = E-mail to all members?
member_email.order = 5
member_email.value = 0
parents = text
parents.format = plain
parents.label = Parent Tickets
parents.order = 0
parents.value =
#-----------
task_due_date = time
task_due_date.date = enabled
task_due_date.date_empty = disabled
task_due_date.format = date
task_due_date.label = Task due date
task_due_date.order = 4
task_due_date.value =


[ticket-workflow]
accept = new,assigned,accepted,reopened -> accepted
accept.operations = set_owner_to_self
accept.permissions = TICKET_MODIFY
create = <none> -> new
create.default = 1
create_and_assign = <none> -> assigned
create_and_assign.label = assign
create_and_assign.operations = may_set_owner
create_and_assign.permissions = TICKET_MODIFY
leave = * -> *
leave.default = 1
leave.operations = leave_status
reassign = new,accepted,assigned,reopened -> assigned
reassign.operations = set_owner
reassign.permissions = TICKET_CREATE
reopen = closed -> reopened
reopen.operations = del_resolution
reopen.permissions = TICKET_CREATE
resolve = new,assigned -> closed
resolve.operations = set_resolution
resolve.permissions = TICKET_ADMIN

[timeline]
abbreviated_messages = enabled
changeset_collapse_events = disabled
changeset_long_messages = disabled
changeset_show_files = 0
default_daysback = 30
max_daysback = 90
newticket_formatter = oneliner
ticket_show_component = disabled
ticket_show_details = disabled

[trac]
anonymous_session_lifetime = 90
auth_cookie_domain =
auth_cookie_lifetime = 0
auth_cookie_path =
auto_preview_timeout = 2.0
auto_reload = disabled
backup_dir = db
base_url = https://trac.xxxxx.xxx/traffic/
check_auth_ip = disabled
database = postgres://trac:xxxxx@xxxxxxx:5432/tracdb?schema=xxxxxxx
debug_sql = disabled
default_charset = utf-8
default_date_format =
default_dateinfo_format = relative
default_handler = WikiModule
default_language =
default_timezone = America/New_York
genshi_cache_size = 128
htdocs_location =
ignore_auth_case = disabled
jquery_location =
jquery_ui_location =
jquery_ui_theme_location =
mainnav = wiki,newticket,tickets,browser,timeline,roadmap,search
metanav = login,logout,prefs,help
mysqldump_path = mysqldump
never_obfuscate_mailto = enabled
obey_remote_user_header = enabled
permission_policies = DefaultWikiPolicy,DefaultTicketPolicy,DefaultPermissionPolicy,LegacyAttachmentPolicy
permission_store = DefaultPermissionStore
pg_dump_path = pg_dump
request_filters =
resizable_textareas = enabled
secure_cookies = disabled
show_email_addresses = enabled
show_full_names = enabled
timeout = 20
use_base_url_for_redirect = enabled
use_chunked_encoding = enabled
use_xsendfile = disabled
wiki_toolbars = enabled
xsendfile_header = X-Sendfile

[versioncontrol]
allowed_repository_dir_prefixes =
default_repository_type = svn

[wiki]
default_edit_area_height = 30
ignore_missing_pages = enabled
max_size = 262144
render_unsafe_content = disabled
safe_origins = data:
safe_schemes = cvs,file,ftp,git,irc,http,https,news,sftp,smb,ssh,svn,svn+ssh
split_page_names = disabled

[Jun Omae]

Please share plugins/remote-user-auth.py and configuration of the web server (apache?). All components for IAuthenticator are disabled in the trac.ini.

Jun Omae <jun...@gmail.com> (大前 潤)

--
You received this message because you are subscribed to the Google Groups "Trac Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to trac-users+...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/trac-users/d1f9a3bd-233e-411f-8d1b-6b4eac91dc71n%40googlegroups.com.