After trying for 2 days the 2.0.4 release and not going anywhere i
finally decided to switch database backend to mysql ( i was using pg 8.3
). Everything works on mysql, but on postgres i get lots of errors. I'm
pretty sure the errors are due to the capitals in the queries, since PG
converts all database names and fileds to lowercase. Here's the log :
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Going to resolve session
data into policy: $VAR1 = {
'Recipient' => '[EMAIL PROTECTED]',
'SASLUsername' => '',
'QueueID' => '',
'RecipientData' => '',
'Instance' => '158d.48c0dcef.c8934.0',
'EncryptionCipher' => '',
'Size' => '0',
'EncryptionKeySize' => '0',
'EncryptionProtocol' => '',
'Helo' => 'shiny.bgservice.net',
'ClientAddress' => '10.7.15.13',
'ClientName' => 'unknown',
'Sender' => '[EMAIL PROTECTED]',
'SASLSender' => '',
'Protocol' => 'ESMTP',
'ClientReverseName' => 'unknown',
'SASLMethod' => ''
};
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Found policy member with
ID '' in policy ''
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Found policy member with
ID '' in policy ''
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Found policy member with
ID '' in policy ''
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Found policy member with
ID '' in policy ''
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Found policy member with
ID '' in policy ''
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Source not
defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Source
matching result: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Destination
not defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Destination
matching result: matched=1
Use of uninitialized value in hash element at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 207.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Source not
defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Source
matching result: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Destination
not defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Destination
matching result: matched=1
Use of uninitialized value in hash element at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 207.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.[2008/09/05-07:17:03
- 5513] [POLICIES] DEBUG: [ID:/Name:]: Destination not defined or 'any',
explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Destination
matching result: matched=1
Use of uninitialized value in hash element at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 207.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Source not
defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Source
matching result: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Destination
not defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Destination
matching result: matched=1
Use of uninitialized value in hash element at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 207.
Use of uninitialized value within %matchedPolicies in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 213.
Use of uninitialized value within %matchedPolicies in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 213.
Use of uninitialized value within %matchedPolicies in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 213.
Use of uninitialized value within %matchedPolicies in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 213.
Use of uninitialized value within %matchedPolicies in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 213.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: END RESULT: prio= =>
policy ids: ,,,,
Argument "" isn't numeric in sort at
/usr/local/lib/policyd-2.0/cbp/modules/AccessControl.pm line 84.
Argument "" isn't numeric in sort at
/usr/local/lib/policyd-2.0/cbp/modules/CheckHelo.pm line 90.
Argument "" isn't numeric in sort at
/usr/local/lib/policyd-2.0/cbp/modules/CheckSPF.pm line 92.
Argument "" isn't numeric in sort at
/usr/local/lib/policyd-2.0/cbp/modules/Greylisting.pm line 86.
Argument "" isn't numeric in sort at
/usr/local/lib/policyd-2.0/cbp/modules/Quotas.pm line 110.
Use of uninitialized value in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 550.
Use of uninitialized value in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 550.
Use of uninitialized value in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 550.
Use of uninitialized value in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 550.
Use of uninitialized value in join or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 550.
[2008/09/05-07:17:04 - 5511] [CORE] INFO: 2008/09/05-07:17:04 CONNECT
TCP Peer: "127.0.0.1:47260" Local: "127.0.0.1:10031"
[2008/09/05-07:17:04 - 5511] [PROTOCOLS/Postfix] DEBUG: Possible Postfix
protocol
[2008/09/05-07:17:04 - 5511] [PROTOCOLS/Postfix] INFO: Identified
Postfix protocol
Use of uninitialized value $recipientData in split at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 565.
Use of uninitialized value $cidr in pattern match (m//) at
/usr/local/lib/policyd-2.0/cbp/system.pm line 117.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Source not
defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Source
matching result: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Destination
not defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Destination
matching result: matched=1
Use of uninitialized value in hash element at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 207.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
Use of uninitialized value in sprintf at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 124.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Source not
defined or 'any', explicit match: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] INFO: [ID:/Name:]: Source
matching result: matched=1
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: [ID:/Name:]: Destination
not defined or 'any', explicit match: matched=1
m line 116.
Use of uninitialized value in concatenation (.) or string at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 116.
[2008/09/05-07:17:03 - 5513] [POLICIES] DEBUG: Found policy member with
ID '' in policy ''
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
Use of uninitialized value in string eq at
/usr/local/lib/policyd-2.0/cbp/policies.pm line 111.
_______________________________________________
Users mailing list
[email protected]
http://lists.policyd.org/mailman/listinfo/users
