Testing Server Deployment

After developing a given feature, you may be required to deploy any changes to the testing server. To do this, you must have installed the putty SSH client (found here). Use the following information to connect to the testing server:

Linux Testing Server

You may save the information so it is easier to connect to the testing server in the future. After connecting (and entering your credentials) just navigate to /var/www/backend.sgiv10test.wm then enter the command sudo svn up to update the server's working copy.

If, among the updated files, there are new or altered migrations and/or seeds, you will have to run sudo php artisan migrate:fresh --seed.

Then navigate to /var/www/frontend.sgiv10test.wm and run sudo svn up. If there are new frontend plugins you may have to run jspm install. Then run sudo gulp export and the deployment will be complete (gulp export will take a while).

Configurations

Snappy

The file /var/www/backend.sgiv10test.wm/config needs to have the following configuration:

<?php

return [
    'pdf'   => [
        'enabled' => true,
        'binary'  => base_path('vendor/bin/wkhtmltopdf-i386'),
        'timeout' => false,
        'options' => [],
        'env'     => [],
    ],
    'image' => [
        'enabled' => true,
        'binary'  => base_path('vendor/bin/wkhtmltoimage-i386'),
        'timeout' => false,
        'options' => [],
        'env'     => [],
    ],
];

Windows Testing Server

Updating the windows server is almost similar to the linux server, the only difference is that instead of updating the frontend source code and execute the gulp exportcommand on the server, we just copy the files from the export folder after doing gulp export on any other machine.

The files are located in the C:\inetpub\wwwroot\backend and C:\inetpub\wwwroot\frontend

Things you need to be careful

Because in SQL Server the php artisan migrate:fresh doesn't work, you may need to delete the database sgiv10test and create it again. The database server is 192.168.0.22

Don't just replace the file C:\inetpub\wwwroot\frontend\env.js, this file has the configuration of the environment, so you have to check if there were any changes to the sample file, and add the missing configurations.

The line PDO::SQLSRV_ATTR_FETCHES_NUMERIC_TYPE => true line must be uncommented on the C:\inetpub\wwwroot\backend\config\database.php file.

The file C:\inetpub\wwwroot\backend\config\snappy.php needs to have the following configuration:

<?php

return [
    'pdf'   => [
        'enabled' => true,
        'binary'  => '"C:/Program Files/wkhtmltopdf/bin/wkhtmltopdf.exe"',
        'timeout' => false,
        'options' => [],
        'env'     => [],
    ],
    'image' => [
        'enabled' => true,
        'binary'  => '"C:/Program Files/wkhtmltopdf/bin/wkhtmltoimage.exe"',
        'timeout' => false,
        'options' => [],
        'env'     => [],
    ],
];