I need to run adminer on my remote dev server(ubuntu 18.04 using apache 2 under digital ocean)
Reading some articles like https://linux.how2shout.com/how-to-install-adminer-on-ubuntu-22-04-lts/
I expected that after installing adminer I would have some default url, but opening
http://NNN.NN.NNN.N/adminer
I got Not found error
and
http://NNN.NN.NNN.N/
shows Apache2 Ubuntu Default Page
I have several sites installed on this hosting using virtual hosting and having files like :
/etc/apache2/sites-available/sitename.com.conf
and added lines into /etc/hosts like :
NNN.NN.NNN.N sitename.com
I have in my OS:
root@remote-server:/var/www/html/phppgadmin# apt list --installed adminer
Listing... Done
adminer/bionic,now 4.6.2-1 all [installed]
root@remote-server:/var/www/html/phppgadmin# dpkg -s adminer
Package: adminer
Status: install ok installed
Priority: optional
Section: web
Installed-Size: 1906
Maintainer: Ubuntu Developers <ubuntu-devel-discuss@lists.ubuntu.com>
Architecture: all
Version: 4.6.2-1
Depends: libapache2-mod-php | php-cgi | php, php-mysql | php-sqlite3 | php-pgsql
Recommends: php-cli, php-mysql, php-pgsql, php-sqlite3
Suggests: default-mysql-server | virtual-mysql-server | postgresql | sqlite3
Description: Web-based database administration tool
Adminer (formerly phpMinAdmin) is a full-featured database management tool
written in PHP. Conversely to phpMyAdmin, it is a light weight application
with these priorities in order: security, user experience, performance,
feature set and size.
Original-Maintainer: Chris Lamb <lamby@debian.org>
Homepage: https://www.adminer.org/
root@remote-server:/var/www/html/phppgadmin# uname -a
Linux remote-server 4.15.0-197-generic #208-Ubuntu SMP Tue Nov 1 17:23:37 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
How can I run adminer properly ? Have I use different options for mysql, mariadb, postgres ?
If I run from my home console:
curl http://NNN.NN.NNN.N/adminer
<!DOCTYPE HTML PUBLIC "-//IETF//DTD HTML 2.0//EN">
<html><head>
<title>404 Not Found</title>
</head><body>
<h1>Not Found</h1>
<p>The requested URL was not found on this server.</p>
<hr>
<address>Apache/2.4.29 (Ubuntu) Server at 127.0.0.1 Port 80</address>
</body></html>
where NNN.NN.NNN.N is ip of my remote server...
STEPS TO UPGRADE: I try to follow steps in the link, but I got unexpected error
Please install all available updates for your release before upgrading
even after I upgrated the system:
root@remote-server:~# uname -r; uname -a
4.15.0-213-generic
Linux remote-server 4.15.0-213-generic #224-Ubuntu SMP Mon Jun 19 13:30:12 UTC 2023 x86_64 x86_64 x86_64 GNU/Linux
root@remote-server:~# do-release-upgrade
Checking for a new Ubuntu release
Please install all available updates for your release before upgrading.
root@remote-server:~# sudo apt-get update
Ign:1 http://repo.mongodb.org/apt/ubuntu bionic/mongodb-org/6.0 InRelease
Hit:2 http://ppa.launchpad.net/certbot/certbot/ubuntu bionic InRelease
Hit:3 http://security.ubuntu.com/ubuntu bionic-security InRelease
Get:4 https://download.docker.com/linux/ubuntu bionic InRelease [64.4 kB]
Hit:5 https://deb.nodesource.com/node_16.x bionic InRelease
Hit:6 http://ppa.launchpad.net/ondrej/php/ubuntu bionic InRelease
Hit:7 http://mirrors.digitalocean.com/ubuntu bionic InRelease
Hit:8 http://mirrors.digitalocean.com/ubuntu bionic-updates InRelease
Hit:9 http://mirrors.digitalocean.com/ubuntu bionic-backports InRelease
Hit:10 http://repo.mongodb.org/apt/ubuntu bionic/mongodb-org/6.0 Release
Fetched 64.4 kB in 1s (70.6 kB/s)
Reading package lists... Done
root@remote-server:~# sudo apt-get upgrade
Reading package lists... Done
Building dependency tree
Reading state information... Done
Calculating upgrade... Done
The following packages have been kept back:
base-files docker-ce docker-ce-cli ubuntu-advantage-tools ubuntu-server
0 upgraded, 0 newly installed, 0 to remove and 5 not upgraded.
root@remote-server:~# do-release-upgrade
Checking for a new Ubuntu release
Please install all available updates for your release before upgrading.
How to fix this error and move next?
