Join the community today
Become a Member

Install MSSQL conflicts?

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

  1. Qu Don

    Qu Don Member

    64
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +14
    Local Time:
    2:51 PM
  2. eva2000

    eva2000 Administrator Staff Member

    44,163
    10,066
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,556
    Local Time:
    4:51 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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/
     
    • Like Like x 1
  3. Qu Don

    Qu Don Member

    64
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +14
    Local Time:
    2:51 PM
    Thats very kind of you. Thanks
     
  4. Qu Don

    Qu Don Member

    64
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +14
    Local Time:
    2:51 PM
    • Informative Informative x 1
  5. Qu Don

    Qu Don Member

    64
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +14
    Local Time:
    2:51 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. eva2000

    eva2000 Administrator Staff Member

    44,163
    10,066
    113
    May 24, 2014
    Brisbane, Australia
    Ratings:
    +15,556
    Local Time:
    4:51 AM
    Nginx 1.17.x
    MariaDB 5.5/10.x
    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;
    
      }
     
    • Like Like x 1
    • Informative Informative x 1
  7. Qu Don

    Qu Don Member

    64
    5
    8
    Aug 21, 2017
    Brooklyn, New York
    Ratings:
    +14
    Local Time:
    2:51 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