medusa/api-resolver

resolver endpoint for an easy to use microservice implementation

0.0.8 2021-08-18 07:32 UTC

Requires

• php: >=8.0
• ext-curl: *
• ext-igbinary: *
• ext-mbstring: *
• ext-mysqli: *
• ext-openssl: *
• medusa/filesystem: 0.*
• medusa/functions: 1.*
• medusa/http-simple: 0.*

Requires (Dev)

• medusa/dev-tools-alias: *

MIT

• Pascal Schnell

README

webadmin account

CREATE TABLE webadminaccount
(
    webadminaccount_id       INT unsigned NOT NULL AUTO_INCREMENT,
    webadminaccount_username VARCHAR(255) NOT NULL,
    webadminaccount_password VARCHAR(255) NOT NULL,
    webadminaccount_enabled  BOOL     DEFAULT FALSE,
    webadminaccount_updated  DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    webadminaccount_created  DATETIME DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (`webadminaccount_id`),
    UNIQUE (`webadminaccount_username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

INSERT INTO webadminaccount (webadminaccount_username, webadminaccount_password, webadminaccount_enabled)
VALUES ("admin", "$2y$10$xQwvkmOBTagW7WNwijfJ6OTd8Yli/mGktkSt16eqpG/vitfHIGtWW", true);

account

CREATE TABLE account
(
    account_id       INT unsigned NOT NULL AUTO_INCREMENT,
    account_username VARCHAR(255) NOT NULL,
    account_password VARCHAR(255) NOT NULL,
    account_enabled  BOOL     DEFAULT FALSE,
    account_updated  DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    account_created  DATETIME DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (`account_id`),
    UNIQUE (`account_username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

userpermission

CREATE TABLE userpermission
(
userpermission_id            INT unsigned NOT NULL AUTO_INCREMENT,
userpermission_account_id INT unsigned NOT NULL,
userpermission_service    VARCHAR(255) NOT NULL,
userpermission_enabled    BOOL     DEFAULT FALSE,
userpermission_updated    DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
userpermission_created    DATETIME DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (`userpermission_id`),
    UNIQUE (`userpermission_account_id`, `userpermission_service`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

accountip

CREATE TABLE accountip
(
accountip_id         INT unsigned NOT NULL AUTO_INCREMENT,
accountip_account_id INT unsigned NOT NULL,
accountip_ip         VARCHAR(15) NOT NULL,
accountip_enabled    BOOL     DEFAULT FALSE,
accountip_updated    DATETIME DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
accountip_created    DATETIME DEFAULT CURRENT_TIMESTAMP,

    PRIMARY KEY (`accountip_id`),
    UNIQUE (`accountip_account_id`, `accountip_ip`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

config example

{
  "internalNetworks": [
    "192.168.178.0/24",
    "192.168.168.0/24",
  ],
  "debugMode": true,
  "database": {
    "tablePrefix": "apiresolver_",
    "user": "MYDBUSER",
    "pass": "MYDBPASS_PLAINTEXT",
    "db": "DATABASE",
    "host": "loclahost",
    "port": 3306,
    "charset": "utf8mb4"
  }
}

NGINX

server

server {
    #api.example.com/<project>/<controller>/<controller-version>/ (api.example.com/main/Foo/Bar/0.0.1/)
    server_name api.example.com;

    listen 80;

    location /index.php {
        fastcgi_split_path_info ^(.+?\.php)(/.*)$;
        fastcgi_pass unix:/tmp/php8.0-fpm.sock;
        fastcgi_index index.php;
        fastcgi_param API_RESOLVER /tmp/nginx/api-resolver.sock;
        fastcgi_param API_SERVICES_LOCATION /var/www/my_services;
        include fastcgi_params;
        fastcgi_connect_timeout 30;
        fastcgi_read_timeout 600;
        fastcgi_send_timeout 600;
    }

    root /var/www/api_resolver/application/app/public;
    index index.php;

    access_log /var/log/nginx/access-apiserver.log;
    error_log /var/log/nginx/error-apiserver.log;

    location / {
        try_files $uri /index.php?$args;
    }
}

entry points

server {
    listen unix:/tmp/nginx/api-resolver.sock;
    location /php8.0/ {
        rewrite /php8.0/(.*) /$1 break;
        proxy_redirect off;
        proxy_set_header Host $host;
        proxy_pass http://unix:/tmp/nginx/api-resolver-php8.0.sock;
    }
}

server {
    listen unix:/tmp/nginx/api-resolver-php8.0.sock;

    location ~ [^/]\.php(/|$) {

        if (!-f $request_filename) {
            return 404;
        }

        fastcgi_split_path_info ^(.+?\.php)(/.*)$;
        fastcgi_pass unix:/tmp/php8.0-fpm.sock;
        fastcgi_index index.php;
        include fastcgi_params;
        fastcgi_connect_timeout 30;
        fastcgi_read_timeout 600;
        fastcgi_send_timeout 600;

    }

    root /var/www/my_services/${http_x_service_resolver}/public;
    index index.php;

    access_log /var/log/nginx/access-apiphp8.log;
    error_log /var/log/nginx/error-apiphp8.log;
    location / {
        try_files $uri /index.php?$args;
    }
}

php entry point

<?php declare(strict_types = 1);

use Medusa\App\ApiResolver\Resolver;
use Medusa\App\ApiResolver\ResolverConfig;

chdir(__DIR__);

require_once '../vendor/autoload.php';

// Remove custom headers
foreach (headers_list() as $header) {
    header_remove(explode(':', $header, 2)[0]);
}

$response = (new Resolver(
    ResolverConfig::load('../env.json')
))->start();

array_map('header', $response->getHeaders(true));
echo $response->getBody();