MariaDB

Player

Player has made a commitment?<p>Tell us where<p>×<p>Notify PBR<p>has committed to:<p>* Data will be sent to PBR for reviewSend<p>Query failed: You have an error in …

Databases

MariaDB - cannot login as root

I am trying to setup MariaDB (10.0.29) on Ubuntu (16.04.02). After I installed it and started the process (sudo service mysql start), I cannot login …

Databases

Adding Django CMS to an existing Django site. Can it damage the existing site and data?

A friend asked if they could/update their existing site to Django CMS It has a n e-commerce section added to it and apparently uses the Maris DB. He …

Databases

Django and mariadb not working with istartswith correctly using german umlauts

the following query should only return all cities starting with "Ö" (German umlaut).But it returns cities starting with O and Ö.I use django 1.11 and …

Databases

Announcing Amazon Linux 2 with Long Term Support (LTS)

The extras mechanism in Amazon Linux 2 provides the latest application software on a stable base of Amazon Linux 2. Extras provides topics to select …

Linux

How to install nextCloud 13 on Ubuntu 18.04

Jack Wallen walks you through the process of installing nextCloud 13 on the Ubuntu 18.04 server platform.<p>We've covered nextCloud plenty of times here …

Linux

Amazon RDS Performance Insights Preview

Amazon RDS Performance Insights is accepting preview signup requests. Performance Insights helps you quickly assess the load on your RDS database, …

Cloud Computing

Install Nginx, MariaDB, PHP and PhpMyAdmin in Ubuntu 18.04

A LEMP stack is made up of Nginx (pronounced Engine X), MySQL/MariaDB and PHP/Python packages installed on a Linux system, and configured to work …

Linux

How to set up a Binlog Server for Amazon RDS for MySQL and MariaDB using MariaDB MaxScale | Amazon Web Services

One of the key features of Amazon RDS for MySQL and Amazon RDS for MariaDB is the ability to create Read Replicas. You can easily create up to five …

Databases

How to Install LAMP Stack with PhpMyAdmin in Ubuntu 18.04

A LAMP stack is composed of packages such as Apache, MySQL/MariaDB and PHP installed on a Linux system environment for hosting websites and apps. …

Linux

Pass coordinates (google maps API) React to Express MongoDB

(Sorry for my bad English)...I have a question that I hope you will help me solve, it is about how to pass the coordinates of an address taken from …

JavaScript

What is a good practice to distribute a Django app to different customers

I've developed a Django v11.1 application (it uses a MariaDB database). Now, there are different customers interested on installing this application …

Customers

OdbcException: ERROR [23000] [ma-3.0.3][5.7.12]Cannot add or update a child row: a foreign key constraint fails

I am getting this error when using MariaDB Connector/ODBC with nHibernate to connect MySql databaseOdbcException: ERROR [23000] …

Databases

MariaDB guns for Oracle with latest release of open-source database engine

MariaDB Corp. is openly targeting database kingpin Oracle Corp., releasing a new version of its open-source database today with features that have …

Databases

SD Times news digest: WhiteSource’s software composition analysis, MapR’s AI training program, and MariaDB TX 3.0

WhiteSource has announced the launch of its software composition analysis tool, Effective Usage Analysis. The solution provides details on how …

Oracle nemesis MariaDB tries to lure enterprise folk with TX 3.0

Release adds Big Red compatibility, migration serviceOpen-source database biz MariaDB has upped the ante in its war against Oracle, promising …

Databases

MariaDB launches Oracle compatible enterprise open source database

Enterprise computing has often been reliant on proprietary database architecture, but this can be both complex and costly, putting up a barrier to …

Databases

Customizing an OpenShift Ansible Playbook Bundle

Today I want to talk about Ansible Service Broker and Ansible Playbook Bundle. These components are relatively new in the Red Hat OpenShift …

DevOps

Driver for .Net Application using NHibernate to support failover functionality of AWS Aurora

I am migrating my Database from MSSQL to Aurora(MYSQL). The application is using .net and NHibernate. We tried the Nhibernate driver for MYSQL …

Databases

Cakephp + php-fpm

Last night I had the exciting idea to upgrade my OS to Fedora 27. With all my joy, my web apps do not work anymore. I discovered that the folks at …

CakePHP

Why won't this Perl DBI/DBD MySQL (MariaDB) connect to locahost work?

Results in an error message:DBI connect('host=localhost;database=test','user',...) failed: Can't connect to MySQL server on 'localhost' (10061) at …

Linux

SQL generated by jOOQ for nested select doesn't work in MySQL/MariaDB

For a classical ranking problem (sum of best 3 results per player) I came up with the following sub-query using the <b>jOOQ DSL</b> and <b>Scala</b> (to be embedded …

Databases

How To Install Joomla on Ubuntu 18.04 LTS

In this tutorial we will show you how to install Joomla on Ubuntu 18.04 LTS. For those of you who didn’t know, For those of you who didn’t know, …

Linux

How to enable large index in MariaDB 10?

In Debian Jessie I installed MariaDB server 10.0.30 and I try to increase max key length. AFAIU it depends of the config parameter …

Databases

How to Install PyroCMS on Ubuntu Linux

PyroCMS is a free, open source, powerful, easy to use and modular CMS and development platform built with Laravel 5. In this tutorial, I will explain …

Linux

Deploying both Django and MySql Server to one CentOS 7 Server Conflicts

I'm trying to deploy a Django App with MySQL server to a CentOS 7 server, but I'm having issue with installing MySQL server and mysqlclient on the …

Linux

Announcing Amazon Linux 2 LTS Candidate 2

Amazon Linux 2 LTS Candidate 2 is available as an Amazon Machine Image (AMI) for use on Amazon Elastic Compute Cloud (Amazon EC2), and as a Docker …

Linux

DISTINCT and LAG window function

There is simple table:<p>And query:<p>Output - result is consistent across RDBMSes.<p>DBFiddle Demo - PostgreSQL<p>DBFiddle Demo - SQL Server<p>DBFiddle Demo - …

Databases

Docker Tip #49: Importing a Database SQL File with Docker Compose

I’m going to write this in the context of using PostgreSQL and psql but these commands work just the same with MariaDB / MySQL and mysql. I’m also …

Databases

How to make Hibernate @Lock annotation work for Oracle DB?

I stumbled upon a problem with locking row in Oracle DB. The purpose of the lock is to prevent more than one transaction reading data from the DB …

Oracle