Require authentication for REST resources

Registered by Lars Vierbergen

Some REST resources need authentication for an action, this blueprint aims to provide such authentication

Blueprint information

Status:
Complete
Approver:
None
Priority:
Medium
Drafter:
None
Direction:
Approved
Assignee:
Lars Vierbergen
Definition:
Approved
Series goal:
Accepted for 3.x
Implementation:
Implemented
Milestone target:
None
Started by
Lars Vierbergen
Completed by
Lars Vierbergen

Sprints

Whiteboard

New table definitions:
-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 14 Sept 2011 om 21:29
-- Serverversie: 5.1.54
-- PHP-Versie: 5.3.5-1ubuntu7.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `remotecp-panel_oauth`
--

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

--
-- Tabelstructuur voor tabel `auth_consumers`
--

CREATE TABLE IF NOT EXISTS `auth_consumers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(128) NOT NULL,
  `ip` int(10) NOT NULL,
  `owner` char(36) NOT NULL,
  `shared_secret` char(40) NOT NULL,
  `active` int(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Gegevens worden uitgevoerd voor tabel `auth_consumers`
--

INSERT INTO `auth_consumers` (`id`, `domain`, `ip`, `owner`, `shared_secret`, `active`) VALUES
(1, 'http://remotecp.co.cc', -1062731675, '216867cf-5b04-11e0-aca9-00262d90d787', '9c9a8c36b540dfabe037464ac2948d92e11fae2e', 1);

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

--
-- Tabelstructuur voor tabel `auth_granted`
--

CREATE TABLE IF NOT EXISTS `auth_granted` (
  `user` char(36) NOT NULL,
  `to` int(11) unsigned NOT NULL,
  `use` int(10) unsigned NOT NULL DEFAULT '0',
  `until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `auth_granted`
--

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

--
-- Tabelstructuur voor tabel `auth_pending`
--

CREATE TABLE IF NOT EXISTS `auth_pending` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `consumer` int(11) unsigned NOT NULL,
  `use` int(10) unsigned NOT NULL DEFAULT '0',
  `tempkey` char(40) NOT NULL,
  `return_url` varchar(255) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `auth_pending`
--

Old: Table definitions:

-- phpMyAdmin SQL Dump
-- version 3.2.4
-- http://www.phpmyadmin.net
--
-- Machine: localhost
-- Genereertijd: 12 Sept 2011 om 21:28
-- Serverversie: 5.1.54
-- PHP-Versie: 5.3.5-1ubuntu7.2

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `remotecp-panel_oauth`
--

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

--
-- Tabelstructuur voor tabel `auth_consumers`
--

CREATE TABLE IF NOT EXISTS `auth_consumers` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `domain` varchar(128) NOT NULL,
  `owner` char(36) NOT NULL,
  `shared_secret` char(40) NOT NULL,
  `active` int(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `auth_consumers`
--

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

--
-- Tabelstructuur voor tabel `auth_granted`
--

CREATE TABLE IF NOT EXISTS `auth_granted` (
  `user` char(36) NOT NULL,
  `to` int(11) unsigned NOT NULL,
  `until` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Gegevens worden uitgevoerd voor tabel `auth_granted`
--

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

--
-- Tabelstructuur voor tabel `auth_pending`
--

CREATE TABLE IF NOT EXISTS `auth_pending` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `consumer` int(11) unsigned NOT NULL,
  `tempkey` char(40) NOT NULL,
  `created` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;

--
-- Gegevens worden uitgevoerd voor tabel `auth_pending`
--

(?)

Work Items

Dependency tree

* Blueprints in grey have been implemented.

This blueprint contains Public information 
Everyone can see this information.

Subscribers

No subscribers.