Bug 670878

Summary: When installed per /usr/share/dspam/sql-scripts/mysql/mysql_objects-space.sql dspam is missing tables
Product: [Fedora] Fedora EPEL Reporter: Matěj Cepl <mcepl>
Component: dspamAssignee: Nathanael Noblet <nathanael>
Status: CLOSED NOTABUG QA Contact: Fedora Extras Quality Assurance <extras-qa>
Severity: medium Docs Contact:
Priority: low    
Version: el5CC: mcepl, nathanael, perl-devel
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2011-01-19 15:35:55 UTC Type: ---
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:

Description Matěj Cepl 2011-01-19 15:29:17 UTC
Description of problem:
When MySQL tables for dspam are initialized with /usr/share/dspam/sql-scripts/mysql/mysql_objects-space.sql dspam fails to filter a message with /var/log/dspam/sql.errors containing lines:

[01/19/2011 16:14:45] 13154: Table 'dspam.dspam_virtual_uids' doesn't exist: SELECT uid FROM dspam_virtual_uids WHERE username='matej'

Version-Release number of selected component (if applicable):
dspam-mysql-3.9.0-9.el5

Comment 1 Matěj Cepl 2011-01-19 15:35:55 UTC
Sorry, my fault. I haven't imported virtual_users.sql.