Database

Upgrading major version Nextcloud

For those who have been facing the “Maintenance mode active” after applied a nextcloud upgrade by switching container image version, due a major versioning issue. Even when you issue the occ upgrade into continer you gets hit by something like below: www-data@87401bdd2fa8:~/html$ php /var/www/html/occ upgrade Nextcloud or one of the apps require upgrade - only a limited number of commands are available You may use your browser or the occ upgrade command to do the upgrade Setting log level to debug Exception: Updates between multiple major versions and downgrades are unsupported. Update failed Maintenance mode is kept active Resetting log level Keep a eye on this part: Updates between multiple major versions and downgrades are unsupported. as I was running 25 version I can no jump for above 27, if that’s our case, we can edit the file app/config/config.php edit the version of your nextcloud like below: ...

Open a Nextcloud's DB through a ssh connection

The following post explains how to open and connect your Nextcloud’s DB (MariaDB) by a ssh tunnel. Field description: Server side(GNULinux): Nextcloud: running on Docker-compose engine. OS: Debian with Docker compose installed. Database: MariaDB. Localhost side(GNULinux): OS: Fedora. CLient: Dbeader 7.2.5 Further information you can go to my docker compose Statement here. Edit your docker-compose.yml and add the “ports” key into the statement. $ nano docker-compose.yml ports: - 5555:3306 port: 5555 –> Host. port: 3306 –> Container. From the above the port “5555” it was used as example. ...

How to deploy Wordpress + Mariadb using Docker

Below you will see the statement I used to deploy a Wordpress as db mariadb (mysql); I shared it to you, cos I’ve been looking out for a good .yml statement piece, but some of them are older or put other set frontend as nginx, etc. I did a simple and easier deployment statement, so here we have: version: '3.3' services: wordpress: depends_on: - db image: wordpress:latest volumes: - ./html:/var/www/html ports: - "8080:80" restart: always environment: WORDPRESS_DB_HOST: db:3306 WORDPRESS_DB_USER: wordpress WORDPRESS_DB_PASSWORD: password links: - db depends_on: - db db: image: mariadb:10.5.4-focal volumes: - ./db_data:/var/lib/mysql restart: always environment: MYSQL_ROOT_PASSWORD: SECRET MYSQL_DATABASE: wordpress MYSQL_USER: wordpress MYSQL_PASSWORD: password ports: - "3306:3306" You can switch the local mount to volume mount it will depend of you design. ...

SQL some concepts & notes

SQL Structured Query Language, is a language designed to allow both technical and non-technical users query, manipulate, and transform data from a relational database. Some popular SQL databases: SQLite MySQL Postgres Oracle Microsoft SQL Server Relational database: Represents a collection of related ( two-dimensional) tables.Each of the tables are similar to an Excel spreadsheet, with a fixed number of named columns and any number of rows of data. DDL (Data Definition Language) refers to the CREATE, ALTER and DROP statements DDL allows to add / modify / delete the logical structures which contain the data or which allow users to access / maintain the data (databases, tables, keys, views…). DDL is about “metadata”. DML (Data Manipulation Language) refers to the INSERT, UPDATE and DELETE statements DML allows to add / modify / delete data itself. DQL (Data Query Language) refers to the SELECT, SHOW and HELP statements (queries) SELECT is the main DQL instruction. It retrieves data you need. SHOW retrieves infos about the metadata. HELP… is for people who need help. DCL (Data Control Language) refers to the GRANT and REVOKE statements DCL is used to grant / revoke permissions on databases and their contents. DCL is simple, but MySQL’s permissions are rather complex. DCL is about security. DTL (Data Transaction Language) refers to the START TRANSACTION, SAVEPOINT, COMMIT and ROLLBACK [TO SAVEPOINT] statements DTL is used to manage transactions (operations which include more instructions none of which can be executed if one of them fails). Some SQL queries: ...

Backup your Wikijs DB

This is a little resume of how I’m doing a backup procedure of my wikijs database based in Docker-compose. Below are the systems used in my enviroment: Project: Wikijs 2.0 Beta Platform: Docker-Compose DB: Postgres (9.6.14) Server: Fedora Server 30.x86_64 Workstation: Windows 10 (provided by work) 😬 PSQL basic commands: Here are 4 basic commands I use to connect into my Postgre DB and check out DB list and quite. $psql -h localhost -p 5416 -U <my-user> -d <my-database> ...

Pulling Mysql using Docker Hub into Linux workstation

$ systemctl start docker $ systemctl status docker $ docker pull mysql $ docker image ls $ docker run --name db -e MYSQL_ROOT_PASSWORD=mysql123 -d mysql Use the docker exec -it command to start a mysql client inside the Docker container you have started, like the following: $ docker exec -it db mysql -uroot -p