Hi Don, > -----Ursprüngliche Nachricht----- > Von: Don Greer [mailto:[email protected]] > Gesendet: Dienstag, 16. Juli 2013 15:53 > An: [email protected] > Betreff: Re: [PacketFence-users] Sponsored Guests - Arrgg! > > Francis and Florian, > Thanks for the responses! > I got this working (at least for the default profile, > Florian, I'll try creating another profile and see what > happens and report back on this thread). > I have a few questions: > First of all, I'm seeing the following error in the logs > during the sponsorship process: > Jul 16 08:39:24 email_activation.cgi(0) WARN: database query > failed with: Column 'category' cannot be null. (errno: 1048), > will try again (pf::db::db_query_execute) Jul 16 08:39:24 > email_activation.cgi(0) WARN: database query failed with: > Column 'category' cannot be null. (errno: 1048), will try > again (pf::db::db_query_execute) Jul 16 08:39:24 > email_activation.cgi(0) WARN: database query failed with: > Column 'category' cannot be null. (errno: 1048), will try > again (pf::db::db_query_execute) Jul 16 08:39:24 > email_activation.cgi(0) ERROR: Database issue: We tried 3 > times to serve query temporary_password_add_sql called from > pf::db::db_data and we failed. Is the database running? > (pf::db::db_query_execute) Jul 16 08:39:24 > email_activation.cgi(0) WARN: something went wrong creating a > new temporary password for [email protected] > (pf::temporary_password::generate) > > Should I go into the code and explicitly set "category" to > some value, or did I miss something in my setup? I suspect > the latter :^).
> Second, even though I've not specified it anywhere on the > profile (infact, it fails if I do), you appear to be using my > "ad1-Sponsor" source that was setup from 4.0.1. It's nice > that it figures this out, but seems sort of strange that it > would just "find" this source, when I have to specify other > sources explicitly. > Third, similar to the one above, it is accepting some > "catchall" rule, of which I find 2 (in "SMS" and "EMAIL") > neither of which appear to be the ones being used (based on > renaming those to "catchall-X" where X is "SMS" or "EMAIL" > respectively). Again, this seems strange that everywhere > else there are explicit rules, and here is a "catchall" that > doesn't seem to be visible to me (or modifiable). > Am I missing something? > Thanks in advance! > Don Can you attach you /usr/local/pf/conf/authentication.conf and profile.conf file? I think there's something messed up with your sources. Florian ------------------------------------------------------------------------------ See everything from the browser to the database with AppDynamics Get end-to-end visibility with application monitoring from AppDynamics Isolate bottlenecks and diagnose root cause in seconds. Start your free trial of AppDynamics Pro today! http://pubads.g.doubleclick.net/gampad/clk?id=48808831&iu=/4140/ostg.clktrk _______________________________________________ PacketFence-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/packetfence-users
