Hi Nigel: Thanks for answering. It was already in full debug mode. Here we go, from the moment the cbpolicyd process starts:
[2009/08/21-15:21:43 - 15659] [CORE] NOTICE: Process Backgrounded [2009/08/21-15:21:43 - 15659] [CBPOLICYD] NOTICE: Policyd v2 / Cluebringer - v2.1.0a [2009/08/21-15:21:43 - 15659] [CBPOLICYD] NOTICE: Initializing system modules. [2009/08/21-15:21:43 - 15659] [CBPOLICYD] NOTICE: System modules initialized. [2009/08/21-15:21:43 - 15659] [CBPOLICYD] NOTICE: Module load started... [2009/08/21-15:21:43 - 15659] [CORE] NOTICE: => AccessControl: enabled [2009/08/21-15:21:43 - 15659] [CORE] NOTICE: => CheckHelo: enabled [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: => CheckSPF: enabled [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: => Greylisting: enabled [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: => Quotas: enabled [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: => Accounting: enabled [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: => Protocol(Postfix): enabled [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: => Protocol(Bizanga): enabled [2009/08/21-15:21:44 - 15659] [CBPOLICYD] NOTICE: Module load done. [2009/08/21-15:21:44 - 15659] [CBPOLICYD] NOTICE: Session tracking is ENABLED. [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: 2009/08/21-15:21:44 cbp (type Net::Server::PreFork) starting! pid(15659) [2009/08/21-15:21:44 - 15659] [CORE] NOTICE: Binding to TCP port 10031 on host 127.0.0.1 [2009/08/21-15:21:44 - 15659] [CORE] WARNING: Group Not Defined. Defaulting to EGID '0 5 0 0' [2009/08/21-15:21:44 - 15659] [CORE] WARNING: User Not Defined. Defaulting to EUID '0' [2009/08/21-15:21:44 - 15659] [CORE] INFO: Setting up serialization via flock [2009/08/21-15:21:44 - 15659] [CORE] INFO: Beginning prefork (4 processes) [2009/08/21-15:21:44 - 15659] [CORE] INFO: Starting "4" children [2009/08/21-15:21:44 - 15679] [CORE] DEBUG: Child Preforked (15679) [2009/08/21-15:21:44 - 15679] [CBPOLICYD] DEBUG: Starting up caching engine [2009/08/21-15:21:44 - 15680] [CORE] DEBUG: Child Preforked (15680) [2009/08/21-15:21:44 - 15680] [CBPOLICYD] DEBUG: Starting up caching engine [2009/08/21-15:21:44 - 15681] [CORE] DEBUG: Child Preforked (15681) [2009/08/21-15:21:44 - 15681] [CBPOLICYD] DEBUG: Starting up caching engine [2009/08/21-15:21:44 - 15682] [CORE] DEBUG: Child Preforked (15682) [2009/08/21-15:21:44 - 15659] [CORE] DEBUG: Parent ready for children. [2009/08/21-15:21:44 - 15682] [CBPOLICYD] DEBUG: Starting up caching engine [2009/08/21-15:22:07 - 15659] [CORE] INFO: Starting "1" children [2009/08/21-15:22:07 - 15679] [CORE] INFO: 2009/08/21-15:22:07 CONNECT TCP Peer: "127.0.0.1:58217" Local: "127.0.0.1:10031" [2009/08/21-15:22:07 - 15679] [PROTOCOLS/Postfix] DEBUG: Possible Postfix protocol [2009/08/21-15:22:07 - 15679] [PROTOCOLS/Postfix] INFO: Identified Postfix protocol [2009/08/21-15:22:07 - 16125] [CORE] DEBUG: Child Preforked (16125) [2009/08/21-15:22:07 - 16125] [CBPOLICYD] DEBUG: Starting up caching engine [2009/08/21-15:22:07 - 15679] [TRACKING] ERROR: Failed to select session tracking info: awitpt::db::dblayer::DBSelect(127): Error executing select: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '""session_tracking %09%09%09%09WHERE %09%09%09%09%09Instance = '3ee9.4a8ee5ce.0'' at line 13 [2009/08/21-15:22:07 - 15679] [CBPOLICYD:15679] DEBUG: Error getting session data [2009/08/21-15:22:07 - 15680] [CORE] INFO: 2009/08/21-15:22:07 CONNECT TCP Peer: "127.0.0.1:55046" Local: "127.0.0.1:10031" [2009/08/21-15:22:07 - 15680] [PROTOCOLS/Postfix] DEBUG: Possible Postfix protocol [2009/08/21-15:22:07 - 15680] [PROTOCOLS/Postfix] INFO: Identified Postfix protocol [2009/08/21-15:22:07 - 15680] [TRACKING] ERROR: Failed to select session tracking info: awitpt::db::dblayer::DBSelect(127): Error executing select: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '""session_tracking %09%09%09%09WHERE %09%09%09%09%09Instance = '3ef6.4a8ee5cf.0'' at line 13 [2009/08/21-15:22:07 - 15680] [CBPOLICYD:15680] DEBUG: Error getting session data [2009/08/21-15:22:08 - 15681] [CORE] INFO: 2009/08/21-15:22:08 CONNECT TCP Peer: "127.0.0.1:60636" Local: "127.0.0.1:10031" [2009/08/21-15:22:08 - 15681] [PROTOCOLS/Postfix] DEBUG: Possible Postfix protocol [2009/08/21-15:22:08 - 15681] [PROTOCOLS/Postfix] INFO: Identified Postfix protocol [2009/08/21-15:22:08 - 15681] [TRACKING] ERROR: Failed to select session tracking info: awitpt::db::dblayer::DBSelect(127): Error executing select: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '""session_tracking %09%09%09%09WHERE %09%09%09%09%09Instance = '3ee9.4a8ee5ce.0'' at line 13 [2009/08/21-15:22:08 - 15681] [CBPOLICYD:15681] DEBUG: Error getting session data [2009/08/21-15:22:08 - 15682] [CORE] INFO: 2009/08/21-15:22:08 CONNECT TCP Peer: "127.0.0.1:60638" Local: "127.0.0.1:10031" [2009/08/21-15:22:08 - 15682] [PROTOCOLS/Postfix] DEBUG: Possible Postfix protocol [2009/08/21-15:22:08 - 15682] [PROTOCOLS/Postfix] INFO: Identified Postfix protocol [2009/08/21-15:22:08 - 15682] [TRACKING] ERROR: Failed to select session tracking info: awitpt::db::dblayer::DBSelect(127): Error executing select: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '""session_tracking %09%09%09%09WHERE %09%09%09%09%09Instance = '3f17.4a8ee5d0.0'' at line 13 [2009/08/21-15:22:08 - 15682] [CBPOLICYD:15682] DEBUG: Error getting session data [2009/08/21-15:22:08 - 15679] [CORE] INFO: 2009/08/21-15:22:08 CONNECT TCP Peer: "127.0.0.1:60639" Local: "127.0.0.1:10031" [2009/08/21-15:22:08 - 15679] [PROTOCOLS/Postfix] DEBUG: Possible Postfix protocol [2009/08/21-15:22:08 - 15679] [PROTOCOLS/Postfix] INFO: Identified Postfix protocol [2009/08/21-15:22:08 - 15679] [TRACKING] ERROR: Failed to select session tracking info: awitpt::db::dblayer::DBSelect(127): Error executing select: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '""session_tracking []'s Helio Pablo Picasso - "Computers are useless. They can only give you answers." - http://www.brainyquote.com/quotes/authors/p/pablo_picasso.html > Can you run policyd in full debug mode? > log_detail=modules,tracking,policies,protocols > > That will output what its getting from postfix. Make very very sure you > do not mix trunk files from both versions. > > -N > _______________________________________________ > Users mailing list > [email protected] > http://lists.policyd.org/mailman/listinfo/users _______________________________________________ Users mailing list [email protected] http://lists.policyd.org/mailman/listinfo/users
