Got it! Thanks!
--
Max McGrath
Network Administrator
Carthage College
262-552-5512
[email protected]
On Wed, Sep 25, 2013 at 8:37 AM, Louis Munro <[email protected]> wrote:
> Hi Max,
>
> The pf userdoes not have ALL privileges on the pf tables.
> Only root does.
> You will need to either run a delete statement or truncate as root.
>
>
> mysql> show grants for pf;
>
> +---------------------------------------------------------------------------------------------------+
> | Grants for pf@%
> |
>
> +---------------------------------------------------------------------------------------------------+
> | GRANT USAGE ON *.* TO 'pf'@'%' IDENTIFIED BY PASSWORD
> '*7D8422E7D0652EAAF568D5CDBA8ADEDD83531359' |
> | GRANT SELECT, INSERT, UPDATE, DELETE, LOCK TABLES, EXECUTE ON `pf`.* TO
> 'pf'@'%' |
>
> +---------------------------------------------------------------------------------------------------+
> 2 rows in set (0.01 sec)
>
>
> mysql> show grants ;
>
> +----------------------------------------------------------------------------------------------------------------------------------------+
> | Grants for root@localhost
> |
>
> +----------------------------------------------------------------------------------------------------------------------------------------+
> | GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY
> PASSWORD '*7D8422E7D0652EAAF568D5CDBA8ADEDD83531359' WITH GRANT OPTION |
>
> +----------------------------------------------------------------------------------------------------------------------------------------+
> 1 row in set (0.00 sec)
>
>
> Regards,
> --
> Louis Munro
> [email protected] :: www.inverse.ca
> +1.514.447.4918 *125 :: +1 (866) 353-6153
> Inverse inc. :: Leaders behind SOGo (www.sogo.nu) and PacketFence (
> www.packetfence.org)
>
> On 2013-09-24, at 16:53 , Max McGrath <[email protected]> wrote:
>
> As the subject says, I am trying to truncate the violation table:
>
> mysql> truncate violation;
> ERROR 1142 (42000): DROP command denied to user 'pf'@'localhost' for
> table 'violation'
>
> But get the above error. Shouldn't the mysql PF user have access to a PF
> table?
> --
> Max McGrath
> Network Administrator
> Carthage College
> 262-552-5512
> [email protected]
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
>
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk_______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
>
>
> ------------------------------------------------------------------------------
> October Webinars: Code for Performance
> Free Intel webinars can help you accelerate application performance.
> Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most
> from
> the latest Intel processors and coprocessors. See abstracts and register >
> http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
> _______________________________________________
> PacketFence-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/packetfence-users
>
>
------------------------------------------------------------------------------
October Webinars: Code for Performance
Free Intel webinars can help you accelerate application performance.
Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from
the latest Intel processors and coprocessors. See abstracts and register >
http://pubads.g.doubleclick.net/gampad/clk?id=60133471&iu=/4140/ostg.clktrk
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users
