Category: Programming – Page 3

Laravel

Posted on March 10, 2018 (November 12, 2020) by ServerOk

Laravel Database Migration Error Key too long How to find Laravel Framework Version Create project using latest laravel

composer create-project --prefer-dist laravel/laravel blog

1	composer create-project --prefer-dist laravel/laravel blog

Create project using specific version of laravel.

composer create-project laravel/laravel=5.1.33 --prefer-dist blog

1	composer create-project laravel/laravel=5.1.33 --prefer-dist blog

You can see available laravel versions on site https://packagist.org/packages/laravel/laravel […]

Laravel Database Migration Error Key too long

Posted on March 10, 2018 (September 30, 2018) by ServerOk

When doing a database migration on Laravel, i get following error

$ php artisan migrate

  [Illuminate\Database\QueryException]                                                                                                                                                 
  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))  

  [PDOException]                                                                                                   
  SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes  
$

$ php artisan migrate

[Illuminate\Database\QueryException]

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes (SQL: alter table `users` add unique `users_email_unique`(`email`))

[PDOException]

SQLSTATE[42000]: Syntax error or access violation: 1071 Specified key was too long; max key length is 767 bytes

This is because MariaDB use different UTF8 format. To fix, edit file

vi ./app/Providers/AppServiceProvider.php

1	vi ./app/Providers/AppServiceProvider.php

Inside, find

    public function boot()
    {
        //
    }

public function boot()

{

}

Replace with

    public function boot()
    {
        Schema::defaultStringLength(191);
    }

public function boot()

{

Schema::defaultStringLength(191);

}

You will also need to add

use Illuminate\Support\Facades\Schema;

1	use Illuminate\Support\Facades\Schema;

here is how my file look like after editing.

$ cat ./app/Providers/AppServiceProvider.php
<?php

namespace App\Providers;

use Illuminate\Support\Facades\Schema;
use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider
{
    /**
     * Bootstrap any application services.
     *
     * @return void
     */
    public function boot()
    {
        Schema::defaultStringLength(191);
    }

    /**
     * Register any application services.
     *
     * @return void
     */
    public function register()
    {
        //
    }
}
$

$ cat ./app/Providers/AppServiceProvider.php

<?php

namespace App\Providers;

use Illuminate\Support\Facades\Schema;

use Illuminate\Support\ServiceProvider;

class AppServiceProvider extends ServiceProvider

{

/**

* Bootstrap any application services.

* @return void

public function boot()

{

Schema::defaultStringLength(191);

}

/**

* Register any application services.

* @return void

public function register()

{

}

Laravel […]

nodemon

Posted on February 22, 2018 (February 22, 2018) by ServerOk

Node.js applications when you run with nodejs command, you need to restart when a change is made to source code of the application. nodemon will watch your application source code for changes, restart if a change is detected. To install nodemon, run

npm install -g nodemon

1	npm install -g nodemon

Example

nodemon app.js 3000

1	nodemon app.js 3000

nodejs […]

pm2 process manager for node.js

Posted on February 21, 2018 (July 28, 2019) by ServerOk

Auto Start pm2 on boot pm2 is a process manager for node.js applications. It is similar to forever. http://pm2.keymetrics.io First you need to install npm, on Ubuntu/Debian, run

apt install npm

1	apt install npm

To install pm2, run

npm install pm2 -g

1	npm install pm2 -g

Start an Application

pm2 start app.js

1	pm2 start app.js

Start an Application with name

pm2 start app.js -n "app-name-here"

1	pm2 start app.js -n "app-name-here"

Start Application in Cluster mode with

pm2 start app.js -n "app-name-here" -i 5

1	pm2 start app.js -n "app-name-here" -i 5

To Scale a clustered […]

Check if PHP session is working

Posted on February 10, 2018 by ServerOk

To check if PHP session is working, upload following script

<?php 

session_start();

if (isset($_SESSION["ServerOk"])) {
    $_SESSION["ServerOk"] += 1;
} else {
    $_SESSION["ServerOk"] = 1;
}

echo $_SESSION["ServerOk"];

<?php

session_start();

if (isset($_SESSION["ServerOk"])) {

$_SESSION["ServerOk"] += 1;

} else {

$_SESSION["ServerOk"] = 1;

}

echo $_SESSION["ServerOk"];

Access the file, refresh the page in browser, if you see number increase with every refresh, PHP session is working properly on server. […]

Ruby On Rails

Posted on February 4, 2018 (January 30, 2019) by ServerOk

To create a ruby on rails project, run

rails new

rails new

Nginx Rails Origin header didn’t match request.base_url […]

PHP Script to List Enabled Extensions

Posted on January 21, 2018 by ServerOk

Create a php script with following content

<?php

echo "<pre>";

foreach (get_loaded_extensions() as $extn) {
	echo $extn  . "\n";
}

<?php

echo "<pre>";

foreach (get_loaded_extensions() as $extn) {

echo $extn . "\n";

}

See php […]

nodejs

Posted on January 16, 2018 (December 17, 2018) by ServerOk

Install Install Node.js on CentOS Install Node.js on Debian/Ubuntu Node.Js Version Manager Installing nvm (Node.js Version Manager) n – node version manager Node.js Tips nodemon pm2 process manager for node.js […]

node version manager

Posted on January 16, 2018 by ServerOk

n is node version manager. To install, run

npm install n -g

1	npm install n -g

To list versions of node.js available, run

n ls

n ls

To install latest stable node.js

n stable

n stable

Node.Js […]

Sending Emails from PHP using Amazon SES

Posted on January 15, 2018 by ServerOk

To create a PHP script to sent email using Amazon SES, create a folder

mkdir ses-test
cd ses-test

1 2	mkdir ses-test cd ses-test

Install phpMailer using composer

composer require phpmailer/phpmailer

1	composer require phpmailer/phpmailer

Create a PHP file with following content

<?php

use PHPMailer\PHPMailer\PHPMailer;
use PHPMailer\PHPMailer\Exception;

require 'vendor/autoload.php';

$mail = new PHPMailer(true);

try {
    //Server settings
    $mail->SMTPDebug = 2;
    $mail->isSMTP();
    $mail->Host = 'email-smtp.us-east-1.amazonaws.com';  // YOUR SES END POINT
    $mail->SMTPAuth = true;
    $mail->Username = 'AKIAJSKJUHBOU2ARXVLQ';                 // SMTP Username
    $mail->Password = 'AjMmd3gRkmTyCY2QoCDkWmkGKA345zuhseS7gV0X6uz0';                           // SMTP Password
    $mail->SMTPSecure = 'tls';
    $mail->Port = 587;

    //Recipients
    $mail->setFrom('info@YOUR_SES_VERIFIED_DOMAIN.com', 'YOUR_SES_VERIFIED_DOMAIN.com');
    $mail->addAddress('you@your-domain.com', 'Your Name');     // If your SES is in Sandbox, you need to verify your email. 
    $mail->addReplyTo('info@YOUR_SES_VERIFIED_DOMAIN.com', 'YOUR_SES_VERIFIED_DOMAIN.com');


    //Content
    $mail->isHTML(true);                                  // Set email format to HTML
    $mail->Subject = 'Here is the subject';
    $mail->Body    = 'This is the HTML message body <b>in bold!</b>';
    $mail->AltBody = 'This is the body in plain text for non-HTML mail clients';

    $mail->send();
    echo 'Message has been sent';
} catch (Exception $e) {
    echo 'Message could not be sent.';
    echo 'Mailer Error: ' . $mail->ErrorInfo;
}

<?php

use PHPMailer\PHPMailer\PHPMailer;

use PHPMailer\PHPMailer\Exception;

require 'vendor/autoload.php';

$mail = new PHPMailer(true);

try {

//Server settings

$mail->SMTPDebug = 2;

$mail->isSMTP();

$mail->Host = 'email-smtp.us-east-1.amazonaws.com'; // YOUR SES END POINT

$mail->SMTPAuth = true;

$mail->Username = 'AKIAJSKJUHBOU2ARXVLQ'; // SMTP Username

$mail->Password = 'AjMmd3gRkmTyCY2QoCDkWmkGKA345zuhseS7gV0X6uz0'; // SMTP Password

$mail->SMTPSecure = 'tls';

$mail->Port = 587;

//Recipients

$mail->setFrom('[email protected]_SES_VERIFIED_DOMAIN.com', 'YOUR_SES_VERIFIED_DOMAIN.com');

$mail->addAddress('[email protected]', 'Your Name'); // If your SES is in Sandbox, you need to verify your email.

$mail->addReplyTo('[email protected]_SES_VERIFIED_DOMAIN.com', 'YOUR_SES_VERIFIED_DOMAIN.com');

//Content

$mail->isHTML(true); // Set email format to HTML

$mail->Subject = 'Here is the subject';

$mail->Body = 'This is the HTML message body <b>in bold!</b>';

$mail->AltBody = 'This is the body in plain text for non-HTML mail clients';

$mail->send();

echo 'Message has been sent';

} catch (Exception $e) {

echo 'Message could not be sent.';

echo 'Mailer Error: ' . $mail->ErrorInfo;

}

Now test it by running

root@ok:~/ses-test# php 1.php
2018-01-15 08:45:54 SERVER -> CLIENT: 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-2762711029 fDkTVziQIcNhSCkxwSpA
2018-01-15 08:45:54 CLIENT -> SERVER: EHLO ok
2018-01-15 08:45:54 SERVER -> CLIENT: 250-email-smtp.amazonaws.com
                                      250-8BITMIME
                                      250-SIZE 10485760
                                      250-STARTTLS
                                      250-AUTH PLAIN LOGIN
                                      250 Ok
2018-01-15 08:45:54 CLIENT -> SERVER: STARTTLS
2018-01-15 08:45:54 SERVER -> CLIENT: 220 Ready to start TLS
2018-01-15 08:45:54 CLIENT -> SERVER: EHLO ok
2018-01-15 08:45:54 SERVER -> CLIENT: 250-email-smtp.amazonaws.com
                                      250-8BITMIME
                                      250-SIZE 10485760
                                      250-STARTTLS
                                      250-AUTH PLAIN LOGIN
                                      250 Ok
2018-01-15 08:45:54 CLIENT -> SERVER: AUTH LOGIN
2018-01-15 08:45:54 SERVER -> CLIENT: 334 VXNlcm5hbWU6
2018-01-15 08:45:54 CLIENT -> SERVER: <credentials hidden>
2018-01-15 08:45:54 SERVER -> CLIENT: 334 UGFzc3dvcmQ6
2018-01-15 08:45:54 CLIENT -> SERVER: <credentials hidden>
2018-01-15 08:45:54 SERVER -> CLIENT: 235 Authentication successful.
2018-01-15 08:45:54 CLIENT -> SERVER: MAIL FROM:<info@hostonnet.com>
2018-01-15 08:45:54 SERVER -> CLIENT: 250 Ok
2018-01-15 08:45:54 CLIENT -> SERVER: RCPT TO:<info@serverok.in>
2018-01-15 08:45:54 SERVER -> CLIENT: 250 Ok
2018-01-15 08:45:54 CLIENT -> SERVER: DATA
2018-01-15 08:45:54 SERVER -> CLIENT: 354 End data with <CR><LF>.<CR><LF>
2018-01-15 08:45:54 CLIENT -> SERVER: Date: Mon, 15 Jan 2018 03:45:54 -0500
2018-01-15 08:45:54 CLIENT -> SERVER: To: Yujin Boby <info@serverok.in>
2018-01-15 08:45:54 CLIENT -> SERVER: From: "hostonnet.com" <info@hostonnet.com>
2018-01-15 08:45:54 CLIENT -> SERVER: Reply-To: "hostonnet.com" <info@hostonnet.com>
2018-01-15 08:45:54 CLIENT -> SERVER: Subject: Here is the subject
2018-01-15 08:45:54 CLIENT -> SERVER: Message-ID: <4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4@ok>
2018-01-15 08:45:54 CLIENT -> SERVER: X-Mailer: PHPMailer 6.0.3 (https://github.com/PHPMailer/PHPMailer)
2018-01-15 08:45:54 CLIENT -> SERVER: MIME-Version: 1.0
2018-01-15 08:45:54 CLIENT -> SERVER: Content-Type: multipart/alternative;
2018-01-15 08:45:54 CLIENT -> SERVER:   boundary="b1_4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4"
2018-01-15 08:45:54 CLIENT -> SERVER: Content-Transfer-Encoding: 8bit
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER: This is a multi-part message in MIME format.
2018-01-15 08:45:54 CLIENT -> SERVER: --b1_4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4
2018-01-15 08:45:54 CLIENT -> SERVER: Content-Type: text/plain; charset=us-ascii
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER: This is the body in plain text for non-HTML mail clients
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER: --b1_4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4
2018-01-15 08:45:54 CLIENT -> SERVER: Content-Type: text/html; charset=us-ascii
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER: This is the HTML message body <b>in bold!</b>
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER: --b1_4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4--
2018-01-15 08:45:54 CLIENT -> SERVER:
2018-01-15 08:45:54 CLIENT -> SERVER: .
2018-01-15 08:45:55 SERVER -> CLIENT: 250 Ok 01000160f8ff15ea-af0d4268-6c9e-43ee-8bbb-4081917f75d6-000000
2018-01-15 08:45:55 CLIENT -> SERVER: QUIT
2018-01-15 08:45:55 SERVER -> CLIENT: 221 Bye
Message has been sentroot@ok:~/ses-test#

root@ok:~/ses-test# php 1.php

2018-01-15 08:45:54 SERVER -> CLIENT: 220 email-smtp.amazonaws.com ESMTP SimpleEmailService-2762711029 fDkTVziQIcNhSCkxwSpA

2018-01-15 08:45:54 CLIENT -> SERVER: EHLO ok

2018-01-15 08:45:54 SERVER -> CLIENT: 250-email-smtp.amazonaws.com

250-8BITMIME

250-SIZE 10485760

250-STARTTLS

250-AUTH PLAIN LOGIN

250 Ok

2018-01-15 08:45:54 CLIENT -> SERVER: STARTTLS

2018-01-15 08:45:54 SERVER -> CLIENT: 220 Ready to start TLS

2018-01-15 08:45:54 CLIENT -> SERVER: EHLO ok

2018-01-15 08:45:54 SERVER -> CLIENT: 250-email-smtp.amazonaws.com

250-8BITMIME

250-SIZE 10485760

250-STARTTLS

250-AUTH PLAIN LOGIN

250 Ok

2018-01-15 08:45:54 CLIENT -> SERVER: AUTH LOGIN

2018-01-15 08:45:54 SERVER -> CLIENT: 334 VXNlcm5hbWU6

2018-01-15 08:45:54 CLIENT -> SERVER: <credentials hidden>

2018-01-15 08:45:54 SERVER -> CLIENT: 334 UGFzc3dvcmQ6

2018-01-15 08:45:54 CLIENT -> SERVER: <credentials hidden>

2018-01-15 08:45:54 SERVER -> CLIENT: 235 Authentication successful.

2018-01-15 08:45:54 CLIENT -> SERVER: MAIL FROM:<info@hostonnet.com>

2018-01-15 08:45:54 SERVER -> CLIENT: 250 Ok

2018-01-15 08:45:54 CLIENT -> SERVER: RCPT TO:<info@serverok.in>

2018-01-15 08:45:54 SERVER -> CLIENT: 250 Ok

2018-01-15 08:45:54 CLIENT -> SERVER: DATA

2018-01-15 08:45:54 SERVER -> CLIENT: 354 End data with <CR><LF>.<CR><LF>

2018-01-15 08:45:54 CLIENT -> SERVER: Date: Mon, 15 Jan 2018 03:45:54 -0500

2018-01-15 08:45:54 CLIENT -> SERVER: To: Yujin Boby <info@serverok.in>

2018-01-15 08:45:54 CLIENT -> SERVER: From: "hostonnet.com" <info@hostonnet.com>

2018-01-15 08:45:54 CLIENT -> SERVER: Reply-To: "hostonnet.com" <info@hostonnet.com>

2018-01-15 08:45:54 CLIENT -> SERVER: Subject: Here is the subject

2018-01-15 08:45:54 CLIENT -> SERVER: Message-ID: <4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4@ok>

2018-01-15 08:45:54 CLIENT -> SERVER: X-Mailer: PHPMailer 6.0.3 (https://github.com/PHPMailer/PHPMailer)

2018-01-15 08:45:54 CLIENT -> SERVER: MIME-Version: 1.0

2018-01-15 08:45:54 CLIENT -> SERVER: Content-Type: multipart/alternative;

2018-01-15 08:45:54 CLIENT -> SERVER: boundary="b1_4Px5PcyItpZIBJeyp03zA7sVd6uBkNPwuctLKMLeU4"

2018-01-15 08:45:54 CLIENT -> SERVER: Content-Transfer-Encoding: 8bit