Hi update:
[Question 1: solved] > (2)No such file or directory: httpd: could not open error log file > /usr/logs/error_log. This required to add a 'ErrorLog path/to/error_log' directive in the general section of the httpd.conf.apache22 template. [Question 2: not solved] So far I could identify these 3 mysql inserts that mysqld complains about when re-invoked by pfcmd service pf restart: query dhcp_fingerprint_add_sql called from pf::os::read_dhcp_fingerprints_conf (pf::db::db_query_execute) query node_add_sql called from pf::node::node_add (pf::db::db_query_execute) query os_mapping_add_sql called from pf::os::read_dhcp_fingerprints_conf (pf::db::db_query_execute) So far, I could only take a closer look at read_dhcp_fingerprints_conf. The SQL insert that leads to a 'Duplicate entry error' is executed if the trigger_in_range function from trigger.pm returns 1. This is the case if $trigger >= $begin && $trigger <= $end. I don't quite understand the sense of this code, nonetheless, this condition seems to be always true if the data is sourced from the dhcp_fingerprints.conf file. One example: OS class 17, members 1700-1799 OS 1705 In trigger_in_range language: Trigger: 1705, Begin: 1700, End: 1799 Hence, trigger_in_range returns 1, read_dhcp_fingerprints_conf executes dhcp_fingerprint_add_sql and then fails with 'Duplicate entry error'. Can you please help me out? Thanks, John Am 13.07.2011 21:33, schrieb John Adams: > Dear PacketFence Team > > I'm trying to setup/run packetfence 2.2.1 on a slackware 13.1 system, > > I'm stumbling over these issues: > > Checking configuration sanity... > service|command > config files|start > WARNING: MaxClients (10) must be at least as large > as ThreadsPerChild (25). Automatically > increasing MaxClients to 25. > (2)No such file or directory: httpd: could not open error log file > /usr/logs/error_log. > Unable to open logs > httpd|start > snmptrapd|start > pfsetvlan|start > pfdhcplistener|start > pfmon|start > > Checking the generated httpd.conf in %%install_dir%%/var/conf/ I don't > see any configuration setting that would mention "/usr/logs/error_log". > Also, no Include file includes anything that would use this path to > error_log. I wonder, where does that come from? > > Besides of that, when generating the database from scratch with the > ./installer.pl and starting packetfence for the frist time, I see this > in stdout without any warnings or errors in the logs (packetfence.log): > > Starting PacketFence...Checking configuration sanity... > service|command > config files|start > Use of uninitialized value $_[7] in join or string at > /usr/local/pf/lib/pf/class.pm line 170 (#1) > (W uninitialized) An undefined value was used as if it were already > defined. It was interpreted as a "" or a 0, but maybe it was a > mistake. > To suppress this warning assign a defined value to your variables. > > To help you figure out what was undefined, perl will try to tell > you the > name of the variable (if any) that was undefined. In some cases it > cannot > do this, so it also tells you what operation you used the undefined > value > in. Note, however, that perl optimizes your program and the operation > displayed in the warning may not necessarily appear literally in your > program. For example, "that $foo" is usually optimized into "that " > . $foo, and the warning will refer to the concatenation (.) operator, > even though there is no . in your program. > > Use of uninitialized value $_[8] in join or string at > /usr/local/pf/lib/pf/class.pm line 170 (#1) > Use of uninitialized value $_[6] in join or string at > /usr/local/pf/lib/pf/class.pm line 170 (#1) > > WARNING: MaxClients (10) must be at least as large > as ThreadsPerChild (25). Automatically > increasing MaxClients to 25. > httpd|start > snmptrapd|start > pfsetvlan|start > pfdhcplistener|start > pfmon|start > > When I restart packetfence (2nd packetfence start) then there are tons > of errors and warnings of this sort: > > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '2100-21' for key 'PRIMARY'. (errno: 1062), will try again > (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '2100-21' for key 'PRIMARY'. (errno: 1062), will try again > (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '2100-21' for key 'PRIMARY'. (errno: 1062), will try again > (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) ERROR: Database issue: We tried 3 times to > serve query os_mapping_add_sql called from > pf::os::read_dhcp_fingerprints_conf and we failed. Is the database > running? (pf::db::db_quer > y_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,15,44,46,47,137,215' for key 'PRIMARY'. (errno: 1062), will > try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,15,44,46,47,137,215' for key 'PRIMARY'. (errno: 1062), will > try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,15,44,46,47,137,215' for key 'PRIMARY'. (errno: 1062), will > try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) ERROR: Database issue: We tried 3 times to > serve query dhcp_fingerprint_add_sql called from > pf::os::read_dhcp_fingerprints_conf and we failed. Is the database > running? (pf::db::d > b_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,15,44,46,47,137,215,224,226' for key 'PRIMARY'. (errno: > 1062), will try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,15,44,46,47,137,215,224,226' for key 'PRIMARY'. (errno: > 1062), will try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,15,44,46,47,137,215,224,226' for key 'PRIMARY'. (errno: > 1062), will try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) ERROR: Database issue: We tried 3 times to > serve query dhcp_fingerprint_add_sql called from > pf::os::read_dhcp_fingerprints_conf and we failed. Is the database > running? (pf::db::d > b_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '2101-21' for key 'PRIMARY'. (errno: 1062), will try again > (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '2101-21' for key 'PRIMARY'. (errno: 1062), will try again > (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '2101-21' for key 'PRIMARY'. (errno: 1062), will try again > (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) ERROR: Database issue: We tried 3 times to > serve query os_mapping_add_sql called from > pf::os::read_dhcp_fingerprints_conf and we failed. Is the database > running? (pf::db::db_quer > y_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,12,15,17,26,28,40' for key 'PRIMARY'. (errno: 1062), will > try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,12,15,17,26,28,40' for key 'PRIMARY'. (errno: 1062), will > try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) WARN: database query failed with: Duplicate > entry '1,3,6,12,15,17,26,28,40' for key 'PRIMARY'. (errno: 1062), will > try again (pf::db::db_query_execute) > Jul 13 21:21:14 pfcmd(0) ERROR: Database issue: We tried 3 times to > serve query dhcp_fingerprint_add_sql called from > pf::os::read_dhcp_fingerprints_conf and we failed. Is the database > running? (pf::db::d > b_query_execute) > > > Can you please help me out? > > Thanks, > John > > ------------------------------------------------------------------------------ > AppSumo Presents a FREE Video for the SourceForge Community by Eric > Ries, the creator of the Lean Startup Methodology on "Lean Startup > Secrets Revealed." This video shows you how to validate your ideas, > optimize your ideas and identify your business strategy. > http://p.sf.net/sfu/appsumosfdev2dev > _______________________________________________ > Packetfence-users mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/packetfence-users ------------------------------------------------------------------------------ AppSumo Presents a FREE Video for the SourceForge Community by Eric Ries, the creator of the Lean Startup Methodology on "Lean Startup Secrets Revealed." This video shows you how to validate your ideas, optimize your ideas and identify your business strategy. http://p.sf.net/sfu/appsumosfdev2dev _______________________________________________ Packetfence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
