Integrate, install, test and debug SSL Certificate

I am working on a project and PM request me to create a CSR (Certificate Signing Request) for purchasing a SSL certificate. I do some research and of-course Google, suddenly get this informative hands-on video tutorial with commands in text format. So,just watch the video with full concentration and use the commands when you need it.

BTW, there is also a video on How do you get and integrate a free SSL with your domain/site.

So, Njoy and visit the link.

 

How to Integrate, install, test, debug #SSL Certificate. 5 videos cover many things. Also with free SSL Certificate from #Letsencrypt

  1.  Create CSR and Purchase and Install an SSL Certificate — https://serversforhackers.com/c/purchase-and-install-an-ssl-certificate
  2. Testing and Debugging SSL Certificates — https://serversforhackers.com/c/testing-and-debugging-ssl-certificates
  3. Self Signed SSL Certificates for Development — https://serversforhackers.com/c/self-signed-ssl-certificates-for-development
  4. Purchase & Install a Wildcard SSL Certificate — https://serversforhackers.com/c/purchase-install-a-wildcard-ssl-certificate
  5. Letsencrypt for Free & Easy SSL Certificates — https://serversforhackers.com/c/letsencrypt-for-free-easy-ssl-certificates (**FREE SSL)

And here is all together — https://serversforhackers.com/s/integrating-ssl-certificates

Here is the man (Chris Fidao) who secure my and your life too as well as time.

THANKS Chris Fidao.

Advertisements

How to find a column or filed name of a table from an entire database?

If you are working on a BIG project with lots of tables in the database, then it will be a good trick query for you to find out a column name of any table from that database.

 

My scenario was a bit different, I had to start work in the middle of a project and there was no one to guide/help me regarding  anything. And you know, about the deadline… really messed up. So, I didn’t hopeless and as usual did some google and prepare this query.

 

“SELECT TABLE_NAME, COLUMN_NAME

FROM INFORMATION_SCHEMA.COLUMNS

WHERE column_name LIKE ‘your_column_name’ “

 

As you can see it search information schema for the column name you are finding after the LIKE clause. And this query saved me and my ass 😉

 

I am writing this article for my future reference. Hope it will also help you and save your ass too 😉 as like mine. If this article save your time then you can comment and share this article to save others too. [sharing is caring]

 

 

[Note: May be you can find this query on other sites. As I said I did some google and make for me. Sorry forgot those site otherwise I put those on ref. section like my other post.]

How to print query or debug queries in Laravel

We often need to debug large queries in Laravel. And laravel have built-in functions almost for everything. Here is a simple query in laravel for example.

$data = User::where(‘status’, 1)

->select(‘name’, ‘username’, ‘email’, ‘password’)

->get();

 

but we want to see the sql query. So we have to use toSql() in the place of get() and to print the query we use dd() – die and dump function of laravel, so here is out update query

$data = User::where(‘status’, 1)

->select(‘name’, ‘username’, ‘email’, ‘password’)

// ->get()

->toSql();

And dump it

dd($data);

and the output is

“SELECT ‘name’, ‘username’, ‘email’, ‘password’ FROM user WEHRE status = 1”

 

n.b.: it also can be done by DB listen

DB::listen(function($sql) {

var_dump($sql);

});

 

Here is another option with Laravel DebugBar. It’s a full featured package and gives lots on insight of the application.

 

 

——————————————————————

Reff: https://scotch.io/tutorials/debugging-queries-in-laravel