Forum Activity for @jimmy

# Jamroom Working NGINX site conf file
# This file is for a FORCED SSL site.  Non-SSL requests will be directed to SSL.

# Jamroom forum thread:  https://www.jamroom.net/the-jamroom-network/forum/off-topic/35854/jamroom-and-nginx-centmin-mod-lemp-stack
# Centminmod forum thread:  
# 10.0.0.151 is a demo IP.  Replace with your domain. Example:  yourdomain.com

# Redirect to HTTPS from port 80
# Redirect from www to non-www with forced SSL
server {
    listen  80;
    server_name 10.0.0.151;
    return 301 https://10.0.0.151$request_uri;
    
    # Access and Error Logs
    access_log /home/nginx/domains/10.0.0.151/log/access_via80.log combined buffer=256k flush=60m;
    error_log /home/nginx/domains/10.0.0.151/log/error_via80.log;
}

server {
    listen 443 ssl http2;
    server_name  10.0.0.151;
    root /home/nginx/domains/10.0.0.151/public;
    
    ssl_dhparam /usr/local/nginx/conf/ssl/10.0.0.151/dhparam.pem;
    ssl_certificate      /usr/local/nginx/conf/ssl/10.0.0.151/10.0.0.151.crt;
    ssl_certificate_key  /usr/local/nginx/conf/ssl/10.0.0.151/10.0.0.151.key;
    include /usr/local/nginx/conf/ssl_include.conf;
    
    # Mozilla Recommended
    ssl_ciphers ECDHE-ECDSA-CHACHA20-POLY1305:ECDHE-RSA-CHACHA20-POLY1305:ECDHE-RSA-AES128-GCM-SHA256:ECDHE-ECDSA-AES128-GCM-SHA256:ECDHE-RSA-AES256-GCM-SHA384:ECDHE-ECDSA-AES256-GCM-SHA384:DHE-RSA-AES128-GCM-SHA256:DHE-DSS-AES128-GCM-SHA256:kEDH+AESGCM:ECDHE-RSA-AES128-SHA256:ECDHE-ECDSA-AES128-SHA256:ECDHE-RSA-AES128-SHA:ECDHE-ECDSA-AES128-SHA:ECDHE-RSA-AES256-SHA384:ECDHE-ECDSA-AES256-SHA384:ECDHE-RSA-AES256-SHA:ECDHE-ECDSA-AES256-SHA:DHE-RSA-AES128-SHA256:DHE-RSA-AES128-SHA:DHE-DSS-AES128-SHA256:DHE-RSA-AES256-SHA256:DHE-DSS-AES256-SHA:DHE-RSA-AES256-SHA:AES128-GCM-SHA256:AES256-GCM-SHA384:AES128-SHA256:AES256-SHA256:AES128-SHA:AES256-SHA:AES:CAMELLIA:DES-CBC3-SHA:!aNULL:!eNULL:!EXPORT:!DES:!RC4:!MD5:!PSK:!aECDH:!EDH-DSS-DES-CBC3-SHA:!EDH-RSA-DES-CBC3-SHA:!KRB5-DES-CBC3-SHA:!CAMELLIA:!DES-CBC3-SHA;
    ssl_prefer_server_ciphers   on;
    #add_header Strict-Transport-Security "max-age=31536000; includeSubdomains;";
    #add_header  X-Content-Type-Options "nosniff";
    #add_header X-Frame-Options DENY;
    ssl_buffer_size 1400;
    ssl_session_tickets on;

    # ngx_pagespeed & ngx_pagespeed handler
    # include /usr/local/nginx/conf/pagespeed.conf;
    # include /usr/local/nginx/conf/pagespeedhandler.conf;
    # include /usr/local/nginx/conf/pagespeedstatslog.conf;

    # Limit Connections Per IP Address
    # Modified from default to allow Admin directory to have more connections
    # Modified in nginx.conf
    # limit_conn_zone $limitconn_map zone=limit_per_ip:16m;
    
    # ssi  on;

    # Access and Error Logs
    access_log /home/nginx/domains/10.0.0.151/log/access_via443.log combined buffer=256k flush=60m;
    error_log /home/nginx/domains/10.0.0.151/log/error_via443.log;

    # Prevent access to ./directories and files
    #location ~ (?:^|/)\. {
    #    deny all;
    #}

    location / {

        # block common exploits, sql injections etc
        # include /usr/local/nginx/conf/block.conf;

        # Enables directory listings when index file not found
        # autoindex  on;

        # Shows file listing times as local time
        autoindex_localtime on;
        
        index index.html index.php sitemap.xml $uri/modules/jrCore/router.php;

        try_files  $uri $uri/modules/jrCore/router.php?_uri=$1;
        
        rewrite ^(.*)$ /modules/jrCore/router.php?_uri=$1;

    }

    #location ^(.*)$ {
    #    try_files  $uri /modules/jrCore/router.php?_uri=$query_string;
    #}

    include /usr/local/nginx/conf/staticfiles.conf;
    include /usr/local/nginx/conf/php.conf;
    include /usr/local/nginx/conf/drop.conf;
    #include /usr/local/nginx/conf/errorpage.conf;
    include /usr/local/nginx/conf/vts_server.conf;
}

MariaDB [jr5]> show tables;
+----------------------------+
| Tables_in_jr5              |
+----------------------------+
| jr_jraction_item           |
| jr_jrblog_item             |
| jr_jrcore_cache            |
| jr_jrcore_count_ip         |
| jr_jrcore_form             |
| jr_jrcore_form_session     |
| jr_jrcore_item             |
| jr_jrcore_log              |
| jr_jrcore_log_debug        |
| jr_jrcore_menu             |
| jr_jrcore_modal            |
| jr_jrcore_module           |
| jr_jrcore_pending          |
| jr_jrcore_pending_reason   |
| jr_jrcore_performance      |
| jr_jrcore_play_key         |
| jr_jrcore_queue            |
| jr_jrcore_setting          |
| jr_jrcore_skin             |
| jr_jrcore_temp             |
| jr_jrcore_template         |
| jr_jrfollower_item         |
| jr_jrmailer_throttle       |
| jr_jrmarket_channel        |
| jr_jrmarket_install        |
| jr_jrmarket_system         |
| jr_jrpage_item             |
| jr_jrprofile_item          |
| jr_jrprofile_profile_link  |
| jr_jrprofile_quota         |
| jr_jrprofile_quota_setting |
| jr_jrprofile_quota_value   |
| jr_jrsearch_fulltext       |
| jr_jrsearch_item           |
| jr_jruser_cookie           |
| jr_jruser_device           |
| jr_jruser_forgot           |
| jr_jruser_item             |
| jr_jruser_language         |
| jr_jruser_session          |
| jr_jruser_url              |
+----------------------------+
41 rows in set (0.00 sec)

mysql --user=peachpum --password=0HSnJWDFIlUfKI1VsLhu jr5

MariaDB [jr5]> CREATE TABLE `jr_jruser_item_key` (
    ->   `_item_id` int(11) unsigned NOT NULL DEFAULT '0',
    ->   `key` varchar(128) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    ->   `index` smallint(5) unsigned NOT NULL DEFAULT '0',
    ->   `value` varchar(512) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
    ->   PRIMARY KEY (`key`,`_item_id`,`index`),
    ->   KEY `_item_id` (`_item_id`),
    ->   KEY `index` (`index`),
    ->   KEY `value` (`value`(255))
    -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
Query OK, 0 rows affected (0.06 sec)

MariaDB [jr5]> show tables;
+--------------------+
| Tables_in_jr5      |
+--------------------+
| jr_jruser_item_key |
+--------------------+
1 row in set (0.00 sec)

MariaDB [jr5]> Ctrl-C -- exit!

GRANT ALL PRIVILEGES ON jr5. * TO 'peachpum'@'localhost';