AWS collector
Install:
-
You must install aws-sdk Use this instruction: https://github.com/aws/aws-sdk-php#installing-via-composer
-
Change path for aws-sdk in file bypassing.php default path is "require 'vendor/autoload.php';"
-
Copy file base.conf.example to file base.conf and change user, password and host for mysql database.
-
Create user with privalaging for databse 'r2'. See command below: 'grant all on base.* to user@localhost identified by "password"'
Run command for refreshing information about user's files in S3
- Run in console command bypassing.php with paramter user_id Example: php bypassing.php user@company.com
Where user@company.com is username in database
Show information on web.
-
You need copy files bs3.php index.html and file base.conf and directories jquery and css to web directory
-
Run browser for view result
Information:
Database: r2
CREATE TABLE s3objects (
id bigint(20) NOT NULL AUTO_INCREMENT,
id_parent bigint(20) DEFAULT NULL,
id_user int(11) DEFAULT NULL,
title varchar(200) DEFAULT NULL,
folder tinyint(1) DEFAULT NULL,
size bigint(20) DEFAULT NULL,
timepassing timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
actual tinyint(1) DEFAULT NULL,
PRIMARY KEY (id),
KEY id_parent (id_parent),
KEY id_user (id_user)
) ENGINE=InnoDB