Self Signed 1.14 -- is a psuedo-scientific and psuedo-legal correct method of signing documents online... I have extensively tested this and in 3 minor version this seem to be the right one for this release in series 1.1.
You can download it from:~ Digital Signatures
You can see this module operating on:--
I have started planning version 2.xx which will include all the file resources being encrypted in the RAW File stores.. The database which is designed to be minimal as the signature data is stored in flat files will probably not expand much out of the following:~
CREATE TABLE `signed_signatures` (
`signid` mediumint(16) unsigned NOT NULL auto_increment,
`state` enum('active', 'inactive', 'progress', 'expired') NOT NULL default 'progress',
`type` varchar(128) NOT NULL default '',
`serial` varchar(42) NOT NULL default '',
`bytes` int(24) unsigned NOT NULL default '0',
`entity` varchar(255) NOT NULL default '',
`name` varchar(255) NOT NULL default '',
`file` varchar(255) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`method` enum('json', 'serial', 'xml') NOT NULL default 'json',
`saltid` mediumint(19) unsigned NOT NULL default '0',
`expires` int(13) unsigned NOT NULL default '0',
`expired` int(13) unsigned NOT NULL default '0',
`saved` int(13) unsigned NOT NULL default '0',
`issued` int(13) unsigned NOT NULL default '0',
`used` int(13) unsigned NOT NULL default '0',
`flagged` int(13) unsigned NOT NULL default '0',
`group` varchar(42) NOT NULL default '',
`uid` int(13) unsigned NOT NULL default '0',
`zoneid` mediumint(19) unsigned NOT NULL default '0',
PRIMARY KEY (`signid`),
KEY `hash` (`state`, `type`(19), `entity`(9), `name`(9), `group`(13), `signid`),
KEY `meters` (`expires`, `expired`, `saved`, `issued`, `used`, `flagged`, `uid`, `method`, `saltid`, `zoneid`, `signid`),
) ENGINE=INNODB;
CREATE TABLE `signed_events` (
`eventid` mediumint(19) unsigned NOT NULL auto_increment,
`system` varchar(128) NOT NULL default '',
`type` varchar(128) NOT NULL default '',
`comment` text,
`key` varchar(42) NOT NULL default '',
`uid` int(13) unsigned NOT NULL default '0',
`begun` int(26,17) unsigned NOT NULL default '0',
`finish` int(26,17) unsigned NOT NULL default '0',
`took` int(26,17) unsigned NOT NULL default '0',
`group` varchar(42) NOT NULL default '',
`uid` int(13) unsigned NOT NULL default '0',
`began` int(13) unsigned NOT NULL default '0',
`micro` int(13) unsigned NOT NULL default '0',
`log_storage` enum('json', 'serial', 'xml') NOT NULL default 'json',
`log_path` varchar(255) NOT NULL default '',
`log_file` varchar(255) NOT NULL default '',
`log_saltid` mediumint(19) unsigned NOT NULL default '0',
`zoneid` mediumint(19) unsigned NOT NULL default '0',
PRIMARY KEY (`eventid`),
KEY `hash` (`key`(13), `group`(13), `type`(11), `system`(9), `eventid`),
KEY `meters` (`uid`, `begun`, `finish`, `took`, `zoneid`, `eventid`),
) ENGINE=INNODB;
CREATE TABLE `signed_event_links` (
`linkid` mediumint(33) unsigned NOT NULL auto_increment,
`group` varchar(42) NOT NULL default '',
`when` int(13) unsigned NOT NULL default '0',
`signid` mediumint(12) unsigned NOT NULL default '0',
`eventid` mediumint(19) unsigned NOT NULL default '0',
`zoneid` mediumint(19) unsigned NOT NULL default '0',
PRIMARY KEY (`linkid`),
KEY `hash` (`when`, `key`(13), `group`(13), `signid`(11), `eventid`, `linkid`),
) ENGINE=INNODB;
## Table for secondary copy of file salts for security
CREATE TABLE `signed_salts` (
`saltid` mediumint(19) unsigned NOT NULL auto_increment,
`type` varchar(128) NOT NULL default '',
`algorithm` varchar(128) NOT NULL default 'AES',
`filename` varchar(255) NOT NULL default '',
`path` varchar(255) NOT NULL default '',
`method` enum('json', 'serial', 'xml') NOT NULL default 'json',
`salt` tinytext,
`refeshed` int(26,17) unsigned NOT NULL default '0',
`zoneid` mediumint(19) unsigned NOT NULL default '0',
PRIMARY KEY (`saltid`),
KEY `hash` (`type`(13), `algorithm`(13), `filename`(11), `path`(9), `saltid`),
KEY `meters` (`method`, `refeshed`, `zoneid`, `saltid`),
) ENGINE=INNODB;
## Table for Date Zoning and Chronologicist!
CREATE TABLE `signed_zones` (
`zoneid` mediumint(19) unsigned NOT NULL auto_increment,
`zone` varchar(128) NOT NULL default 'Australia/Sydney',
`metrix` int(18) NOT NULL default '0',
PRIMARY KEY (`zoneid`),
KEY `xonier` (`zone`(13), `metrix`(13), `zoneid`),
) ENGINE=INNODB;
I will be using my storage.php class and modifying the IO class so it crypts and decrypts on the fly, this will when you upgrade it encrypt all your datastores and backup the keys in the database..
The class I am talking about is this one:~
io.php +
RadiooCrypt.php both of these are part of another new module for people to have streaming playlists and radios on there portal, this is called Radioo the module, next one when this one is finished, then the chat rooms xAlky.
Thanks
Simon/Alesha
