avs-code / PREM-Podium-race-E-manager

Description PREM (Podium race e manager) is management software for races and race leagues. It can be used to create overviews of race results. Based on Paddock 7.10beta by: demontpx
https://arv187.github.io/PREM-Podium-race-E-manager/
GNU General Public License v3.0
5 stars 1 forks source link

Avoid editing manually admin password in database. #22

Closed avs-code closed 7 years ago

avs-code commented 7 years ago

Avoid this step for web admins without knowledge:

What is the admin password?

You need to add a record to the user table. The password should be SHA1 hashed. This SQL statement will add the user admin with the password admin:

INSERT INTO user (name, passwd, active)

VALUES ('admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 1);

Set a default user password in database: admin/admin and encourage to web admin to change the password on url/PREM/?page=users

avs-code commented 7 years ago

Please, @inguni check if this is right:


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

--
-- Estructura de tabla para la tabla `user`
--

CREATE TABLE IF NOT EXISTS `user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `passwd` varchar(40) CHARACTER SET utf8 NOT NULL DEFAULT '',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

--
-- Volcado de datos para la tabla `config`
--

INSERT INTO `user` (`name`, `passwd`, `active`) VALUES
('admin', 'd033e22ae348aeb5660fc2140aec35850c4da997', 1);

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