By the way, these are the grants and hashed passwords on my test VM.
You guys are welcome to try to hack it.
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-25, at 9:37 , 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
