/ Register

Want more timely Centmin Mod News Updates?
Become a Member

Install MSSQL conflicts?

Discussion in 'Install & Upgrades or Pre-Install Questions' started by Qu Don, May 3, 2020.

Tags:
Previous Thread Next Thread
Loading...
  1. May 3, 2020 #1
    Qu Don

    Qu Don Member

    79
    7
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +22
    Local Time:
    9:50 PM
  2. May 3, 2020 #2
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:50 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    Certainly is possible as CentOS is just another linux distro. But how to install, configure and manage MSSQL server is another thing altogether. Unfortunately have no experience with Microsoft SQL server (MSSQL) so wouldn't have a clue. Centmin Mod does have optional support for PHP MSSQL extension Beta Branch - add PHPMSSQL_ALWAYS variable for 123.09beta01+ if you use Centmin Mod PHP to connect to a remote MS SQL server. So probably be easier for you to test MS SQL install on a test VPS server until you figure it out.

    Google search has plenty of CentOS 7 guides like https://computingforgeeks.com/how-to-install-microsoft-sql-2019-on-centos-7-fedora/
     
  3. May 4, 2020 #3
    Qu Don

    Qu Don Member

    79
    7
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +22
    Local Time:
    9:50 PM
    Thats very kind of you. Thanks
     
  4. May 6, 2020 #4
    Qu Don

    Qu Don Member

    79
    7
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +22
    Local Time:
    9:50 PM
  5. May 6, 2020 #5
    Qu Don

    Qu Don Member

    79
    7
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +22
    Local Time:
    9:50 PM
    Is there any redundancy here I should disregard? The nginx setting for Nopcommerce is
    Installing on Linux

    Code:
    # Default server configuration
#
server {
    listen 80 default_server;
    listen [::]:80 default_server;

    server_name   nopCommerce-420.com;

    location / {
    proxy_pass         http://localhost:5000;
    proxy_http_version 1.1;
    proxy_set_header   Upgrade $http_upgrade;
    proxy_set_header   Connection keep-alive;
    proxy_set_header   Host $host;
    proxy_cache_bypass $http_upgrade;
    proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
    proxy_set_header   X-Forwarded-Proto $scheme;
    }

    # SSL configuration
    #
    # listen 443 ssl default_server;
    # listen [::]:443 ssl default_server;
    #
    # Note: You should disable gzip for SSL traffic.
    # See: https://bugs.debian.org/773332
    #
    # Read up on ssl_ciphers to ensure a secure configuration.
    # See: https://bugs.debian.org/765782
    #
    # Self signed certs generated by the ssl-cert package
    # Don't use them in a production server!
    #
    # include snippets/snakeoil.conf;
}
     
  6. May 6, 2020 #6
    eva2000

    eva2000 Administrator Staff Member

    58,893
    12,490
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +19,122
    Local Time:
    11:50 AM
    Nginx 1.31.x
    MariaDB 10.x/11.4+/12.3+
    use your existing centmin mod nginx vhost and just replace the existing location / context with

    Code (Text):
       location / {
   proxy_pass         http://localhost:5000;
   proxy_http_version 1.1;
   proxy_set_header   Upgrade $http_upgrade;
   proxy_set_header   Connection keep-alive;
   proxy_set_header   Host $host;
   proxy_cache_bypass $http_upgrade;
   proxy_set_header   X-Forwarded-For $proxy_add_x_forwarded_for;
   proxy_set_header   X-Forwarded-Proto $scheme;
   }


    existing location / context you replace may look something like
    Code (Text):
      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;

  # Wordpress Permalinks example
  #try_files $uri $uri/ /index.php?q=$uri&$args;

  }
     
  7. May 7, 2020 #7
    Qu Don

    Qu Don Member

    79
    7
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +22
    Local Time:
    9:50 PM
    It looks like some internal mappings are making the installation impossible, like placing nopcommerce in /var/www/nopCommerce420 instead of home/nginx/domains/domain name/

    I ignored that and site installation into extracted files into /home/nginx/domains/domain.com/public.

    However, final part of install requires I create systemmd service file
    "Create the /etc/systemd/system/nopCommerce420.service file with the following contents:"

    Code:
    [Unit]
Description=Example nopCommerce app running on XUbuntu

[Service]
WorkingDirectory=/var/www/nopCommerce420
ExecStart=/usr/bin/dotnet /var/www/nopCommerce420/Nop.Web.dll
Restart=always
# Restart service after 10 seconds if the dotnet service crashes:
RestartSec=10
KillSignal=SIGINT
SyslogIdentifier=nopCommerce420-example
User=www-data
Environment=ASPNETCORE_ENVIRONMENT=Production
Environment=DOTNET_PRINT_TELEMETRY_MESSAGE=false

[Install]
WantedBy=multi-user.target

    I am stuck between process 2 and 3 on the guide Installing on Linux

    I would really appreciate a linux expert insight on how to proceed on this
     
Previous Thread Next Thread
Loading...

.