sqlsmith command not found

Introduction

When you run more command in linux terminal / console, you get the following error message

sqlsmith: command not found

or when using sudo you get the following error message

sudo: sqlsmith: command not found

Solutions to sqlsmith: command not found

How To Fix sqlsmith: command not found in Ubuntu / Debian / Kali Linux / Raspbian

In Ubuntu sqlsmith is provided by sqlsmith package.

sqlsmith is:

SQLsmith is a random SQL query generator. Its paragon is Csmith, which proved valuable for quality assurance in C compilers.

It currently supports generating queries for PostgreSQL 9.5+ and sqlite3.

Besides PostgreSQL developers, users developing extensions of PostgreSQL might also be interested in exposing their code to SQLsmith’s random workload.

During its prototyping stage, it already found about thirty bugs in PostgreSQL alphas, betas and releases, including security vulnerabilities in released versions.

To fix this problem, we can install more using the command below.

sudo apt-get -y install sqlsmith

This command might take some time to finish depending on your machine internet connection.

You can also use apt command to install sqlsmith.

sudo apt -y install sqlsmith

Or if you have aptitude installed you can use the following command.

sudo aptitude install sqlsmith

Summary

In this tutorial we learn how to fix sqlsmith command not found error in Ubuntu / Debian / Kali Linux or Raspbian distribution.