Thanks James it's works !

Adding an entry on admin doc with this tricks could help a lot off admin ;)

Have a good days


De : James Rouzier [mailto:[email protected]]
Envoyé : mardi 7 juin 2016 15:35
À : [email protected]
Objet : Re: [PacketFence-users] Erasing admin user after claering user on DB


You can look in the db schema for you version of PacketFence here 
https://github.com/inverse-inc/packetfence/tree/devel/db/ to find the correct 
initialization of the system users.

Below you can find the current initialization sql of the system users

INSERT INTO `person` (pid,notes) VALUES ("admin","Default Admin User - do not 
delete");
INSERT INTO `person` (pid,notes) VALUES ("default","Default User - do not 
delete");

If you also clear the password table then you should also do the following.

INSERT INTO password (pid, password, valid_from, expiration, access_duration, 
access_level, category) VALUES ('admin', 'admin', NOW(), '2038-01-01', NULL, 
'ALL', NULL);

James Rouzier

[email protected]<mailto:[email protected]> :: +1.514.447.4918 (x115)  ::  
http://www.inverse.ca

Inverse inc. :: Leaders behind SOGo (http://www.sogo.nu) and PacketFence 
(http://www.packetfence.org)
On 2016-06-07 6:32 AM, PROST pierrick wrote:
Hi everyone,

I'm a bit confuse, i deleted admin user on mysql DB (I clear the "person" 
table). Someone can give me a trick to recreate an admin account ? There is no 
other solution for clearing user from packet fence than make a big delete on 
this table (and possibly make a blunder like me) ?


Regards

Pierrick Prost






------------------------------------------------------------------------------

What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic

patterns at an interface-level. Reveals which users, apps, and protocols are

consuming the most bandwidth. Provides multi-vendor support for NetFlow,

J-Flow, sFlow and other flows. Make informed decisions using capacity

planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e




_______________________________________________

PacketFence-users mailing list

[email protected]<mailto:[email protected]>

https://lists.sourceforge.net/lists/listinfo/packetfence-users

------------------------------------------------------------------------------
What NetFlow Analyzer can do for you? Monitors network bandwidth and traffic
patterns at an interface-level. Reveals which users, apps, and protocols are 
consuming the most bandwidth. Provides multi-vendor support for NetFlow, 
J-Flow, sFlow and other flows. Make informed decisions using capacity 
planning reports. https://ad.doubleclick.net/ddm/clk/305295220;132659582;e
_______________________________________________
PacketFence-users mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/packetfence-users

Reply via email to