installsqlite
Build SQLite 3.53.4 from source and install the
sqlite3command-line shell on a GoAdmio server
- Command:
/go/installsqlite - Category: Databases
- Required option: None
- Output: Plain text (download, unzip, configure, and build output)
- Last updated: 2026-11-20
On this page: Overview · Quick start · Syntax · Options · Output · Examples · Troubleshooting · Details · See also
Overview
/go/installsqlite downloads the SQLite source release, compiles it, and installs it. It:
- downloads
sqlite-src-3530400.zip(SQLite 3.53.4) from sqlite.org into/tmp - unpacks it, then runs
./configure,make, andmake install - copies the freshly built
sqlite3shell to/usr/bin/sqlite3 - logs each run to
/var/log/go/installsqlite.log
The version is fixed in the script. The command installs that version, not whatever SQLite release is newest. See Changing the version.
[!NOTE] This command installs the
sqlite3command-line shell. It doesn't create SQLite databases for hosted sites. To create a per-site database, usesqlite.
Quick start
# Build and install SQLite 3.53.4
/go/installsqlite
Then check the result:
sqlite3 --version
Syntax
/go/installsqlite
Run it as root. Most steps use sudo, but cd and ./configure run as the calling user, so a non-root user can't complete the build in /tmp reliably.
Options
None. Any arguments you pass are written to the log file and otherwise ignored.
Output
The command doesn't print a success message and doesn't stop on errors: every step runs even if an earlier one failed. The exit status is that of the last command.
Expect the following on the screen:
| Stage | What you see |
|---|---|
| Download | Nothing. wget runs quietly, with one attempt and a 20-second timeout. |
| Unpack | The list of files extracted by unzip. |
| Build | The output of ./configure, make, and make install. |
| Stray URL line | An error such as No such file or directory near the start. It is harmless. See Limitations. |
Every run adds a line to /var/log/go/installsqlite.log:
[Nov 20 14:03:11]# installsqlite
Security
[!WARNING] The download is made with
--no-check-certificate, so the server's TLS certificate isn't verified, and the file is not checked against a published hash. On an untrusted network, someone could substitute the download. Compare the SHA3-256 hash of/tmp/sqlite-src-3530400.zipwith the value on the sqlite.org download page if the server's integrity matters.
Examples
# Run the installer
/go/installsqlite
# Check the installed version
sqlite3 --version
# List every sqlite3 binary on the PATH (the build installs two copies)
which -a sqlite3
# Confirm the shell works
sqlite3 :memory: "select sqlite_version();"
# Review past runs
tail /var/log/go/installsqlite.log
# Remove the download and build folder afterwards
rm -rf /tmp/sqlite-src-3530400 /tmp/sqlite-src-3530400.zip
Troubleshooting
| Symptom | Likely cause | Fix |
|---|---|---|
Nothing is built and /tmp has no sqlite-src-3530400.zip |
The download failed. wget tries once and gives up after 20 seconds. |
Check the server's internet access and DNS, then run the command again. |
sqlite-src-3530400: No such file or directory, followed by configure errors |
The download or unzip failed, so the folder doesn't exist. | Fix the download first. See the previous row. |
configure: error: no acceptable C compiler found |
The build tools aren't installed. | Install a C compiler and make, then run the command again. |
tclsh: command not found or a Tcl error during make |
The full source tree needs Tcl to generate its build files. | Install Tcl (tcl on the RHEL family, tcl or tclsh on Debian and Ubuntu), then run the command again. |
unzip asks whether to replace files, or wget saves sqlite-src-3530400.zip.1 |
A previous run left files in /tmp. |
Delete the zip and the extracted folder, then run the command again. |
| Nothing happens after the download | The value in /usr/local/goadmio/linux/os.db isn't an exact match for a supported system. |
Check the file. It must contain exactly one of the names in Supported systems. |
sqlite3 --version still shows an old version |
A different sqlite3 comes first on the PATH. |
Run which -a sqlite3 and call the right one, such as /usr/bin/sqlite3. |
| PHP or other programs still use the old SQLite | They use the system libsqlite3, which this command doesn't replace. |
Update the system library with your package manager, or rebuild the program against the new library. |
Details
Supported systems
The command reads the operating system name from /usr/local/goadmio/linux/os.db and requires an exact match.
| Family | Names matched |
|---|---|
| RHEL family | AlmaLinux, Rocky, CentOS, Red Hat, Fedora |
| Debian family | Debian, Ubuntu |
Both families run the same steps. On any other value, the command only downloads and unpacks the source and then stops without building.
The command also reads /usr/local/goadmio/linux/version.db, but the value isn't used.
What it does
| Step | Action |
|---|---|
| 1 | Writes the command and a timestamp to /var/log/go/installsqlite.log. |
| 2 | Changes to /tmp. |
| 3 | Downloads https://www.sqlite.org/2026/sqlite-src-3530400.zip. |
| 4 | Unpacks it and enters the sqlite-src-3530400 folder. |
| 5 | Runs ./configure, make, and make install. |
| 6 | If the built sqlite3 file exists in the build folder, copies it to /usr/bin/sqlite3. |
flowchart TD
A["installsqlite"] --> B["Log the run"]
B --> C["Download sqlite-src-3530400.zip to /tmp"]
C --> D["Unzip and enter the source folder"]
D --> E{"OS in os.db"}
E -- "Supported" --> F["./configure, make, make install"]
E -- "Other" --> X["Stop: nothing built"]
F --> G{"sqlite3 built?"}
G -- "Yes" --> H["Copy sqlite3 to /usr/bin"]
G -- "No" --> Y["Done"]
H --> Y
Where the files go
./configure runs with its defaults, so make install uses the prefix /usr/local: the shell goes to /usr/local/bin, and the library and headers go to /usr/local/lib and /usr/local/include. The extra copy in step 6 puts a second sqlite3 in /usr/bin, which replaces the one supplied by your distribution. A later package update of the distribution's SQLite package can overwrite it again.
Changing the version
The year folder and the version number are written into the script. To install another release, change 2026 and 3530400 in the download, unzip, and cd lines. The number encodes the version: 3530400 is 3.53.4 (major, minor, and patch, with the patch padded to two digits followed by 00).
Limitations
Build tools aren't installed
The command doesn't install a C compiler, make, wget, unzip, or Tcl. Install them first, or run package, which installs the base packages GoAdmio needs. Check that the result includes the tools above.
Leftover files and running it again
The command doesn't clean up. /tmp/sqlite-src-3530400.zip and the extracted folder remain, and a second run can stall at the unzip replace prompt. Remove them before running the command again.
The system library isn't replaced
Programs that link to the system libsqlite3, such as PHP's pdo_sqlite and sqlite3 extensions, keep using the distribution's version. This command updates the command-line shell and installs the new library under /usr/local, which those programs don't use by default.
A stray line in the script
The script contains an unquoted https://sqlite.org/2026/sqlite-amalgamation-3530400.zip line that is run as a command. It downloads nothing and prints an error, and the rest of the script continues.
See also
| Command | Description |
|---|---|
sqlite |
Create a per-site SQLite database and register access |
package |
Install all base packages required by GoAdmio |
extension |
List, install, or remove a PHP extension across every installed PHP version |
installphp |
Install a PHP version with its extensions and PHP-FPM service |
multiphp |
Change the PHP version of one domain or all domains |
backup |
Back up one or all GoAdmio accounts to local disk or remote storage |