similar to: Using environment variables in mariadb

On 03/14/2017 06:29 PM, Richard wrote: > >> Date: Tuesday, March 14, 2017 14:53:01 -0700 >> From: Robert Moskowitz <rgm at htt-consult.com> >> >> I want to script a rather simple create database operation. Thing >> is, I have to provide the password for that database. I would like >> to do this with an environment variable, but the simple approach

> Date: Tuesday, March 14, 2017 14:53:01 -0700 > From: Robert Moskowitz <rgm at htt-consult.com> > > I want to script a rather simple create database operation. Thing > is, I have to provide the password for that database. I would like > to do this with an environment variable, but the simple approach > dose not work: > > mailpswd=charlie > > mysql -u

As I have noted in previous messages, I been getting the following on my new mailserver: Apr 7 10:17:27 z9m9z dovecot: dict: Error: mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) - waiting for 25 seconds before retry They go away when I setenforce 0. It is not a timing issue as I

I reread my sql.conf.ext files and realized they were actually connecting to localhost. So I did some googling, and found how to connect to the socket: connect = host=/var/lib/mysql/mysql.sock dbname=postfix user=postfix password=Postfix_Database_Password And all fixed. No more failures. Plus probably securer. On 04/07/2017 10:57 AM, Robert Moskowitz wrote: > The strange thing is that

Hi there, I know this is off-topic or semi off-topic but I really need some help since I am stucked. I'm trying to redirect MariaDB logs to `/var/log/mysql/*.log` files as shown below on the `/etc/my.cnf.d/server.cnf` file: # # These groups are read by MariaDB server. # Use it for options that only the server (but not clients) should see # # See the examples of server

Hey all, I just unstalled MariaDB version 10 from the mariadb repositories under a CentOS 7 host. The install went fine! [root at nfsdb1 ~]# rpm -qa | grep -i mariadb MariaDB-common-10.0.19-1.el7.centos.x86_64 MariaDB-server-10.0.19-1.el7.centos.x86_64 MariaDB-client-10.0.19-1.el7.centos.x86_64 MariaDB-shared-10.0.19-1.el7.centos.x86_64 However, when I go to start up the service, I'm

My C7 system has mariadb 5.5.37, installed from the Centos repository. The latest version (with a security update is 5.5.39). Mariadb.org has its own repositories, but they don't list Centos 7 as an option. Is anyone using the repository for Centos 6 with Centos 7? See

Hi Earl, >I think I found your problem, you do not have the correct package installed >[root at c7-db1 ~]# rpm -qa | grep maria >mariadb-libs-5.5.41-2.el7_0.x86_64 >mariadb-server-5.5.41-2.el7_0.x86_64 >mariadb-5.5.41-2.el7_0.x86_64 >[root at c7-db1 ~]# >Install the mariadb-x package and you should be able to start the service Thanks. While I could go with mariadb 5, the

I've looked high and low and I cannot a package that has the mariadb driver to go with bind-sdb-9.9.4-14.el7_0.1.x86_64. Everything I'm finding is how to build from source, which for this project will not be maintainable. Is there a yum repo with this driver anywhere? Thanks much, Jim

Folks I'm having problems installing Mariadb in Centos 7. Here's what I did: 0) Become root 1) Make sure that mariadb and mysql are NOT installed. 2) Delete residual libs rm -rf /var/lib/mysq* 3) yum install -y mariadb-server installed mariadb-5.5.50-1.el7_2.x86_64 from the Centos 'updates' repository 4) systemctl start mariadb 5) systemctl status mariadb

Todor Petkov wrote: >> I'm running CentOS-7, but I left some MySQL databases >> on my old CentOS-6.5 partition which I'd like to retrieve. >> I assume they are contained in the file /var/lib/mysql/ibdata1 ? >> >> Could I just copy this file to /var/lib/mysql in CentOS-7? >> Or is there some way Mariadb or phpMyAdmin can import mysql databases >>

I have been getting the following on my new mailserver: Apr 7 10:17:27 z9m9z dovecot: dict: Error: mysql(localhost): Connect failed to database (postfix): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (13) - waiting for 25 seconds before retry They go away when I setenforce 0. So I googled dovecot mysql selinux and the only worthwhile hit was:

On Mon, Nov 30, 2015 at 5:50 PM, Wes James <comptekki at me.com> wrote: > Does this help: > > > http://dba.stackexchange.com/questions/98732/how-to-enable-queries-logs-in-mariadb > < > http://dba.stackexchange.com/questions/98732/how-to-enable-queries-logs-in-mariadb > > > > did search online - maybe you need to change mysql log location that might >

On 5/10/2015 1:04 PM, Earl A Ramirez wrote: > Did a little Googling [0] and I saw that they recommend starting it as > follows: > > /etc/init.d/mysql start which is old school sysVinit style. my guess is, you'll need to fix up a systemd service description file, like /usr/lib/systemd/system/mariadb.service -- john r pierce, recycling bits in santa cruz

Dear list, we're actually using # lsb_release -a LSB Version: :core-4.1-amd64:core-4.1-noarch Distributor ID: CentOS Description: CentOS Linux release 7.2.1511 (Core) Release: 7.2.1511 Codename: Core on our database server using # yum info mariadb-server Loaded plugins: fastestmirror Loading mirror speeds from cached hostfile * EPEL_7: ftp.pbone.net * base: centosmirror.netcup.net *

I'm running CentOS-7, but I left some MySQL databases on my old CentOS-6.5 partition which I'd like to retrieve. I assume they are contained in the file /var/lib/mysql/ibdata1 ? Could I just copy this file to /var/lib/mysql in CentOS-7? Or is there some way Mariadb or phpMyAdmin can import mysql databases from a server that is no longer running? -- Timothy Murphy gayleard /at/

Hi, somehow phpmyadmin messed things up when I was trying to modify a table. The table disappeared, and now it's impossible to re-create it: MariaDB [time]> create table etikettend_metainfo (userID integer(6) unsigned, stationsnummer integer(4) unsigned, primary key (userID)); ERROR 1005 (HY000): Can't create table `time`.`etikettend_metainfo` (errno: 150 "Foreign key

marcos valentine wrote: > Disk cache is not recommended for databases servers. > > it'll slow down the performance. More ram equals more performance. > > This link help me understand memory usage on linux. > > https://www.linuxatemyram.com/ > > Basically you need yo worry about > > free memory is close to 0 > used memory is close to total Almost 3GB

Hello! I've found it out, how you can solve/work around the problem: Nextcloud needs MariaDB. It won't work (so it seems) with MySQL. So mariadb- server needs to be installed. This replaces MySQL (mysql-server-core-5.7 and mysql-client-core-5.7) with MariaDB. The problem is that after that, Akonadi won't start any longer. "aconadictl start" outputs a lot of messages.

Hey all, I just got around to trying out CentOS 7. And for some reason when I attempt to install mysql-server, instead I'm offered mariadb? I'm using epel and remi as my repos. [root at web1:/etc/yum.repos.d] #cat /etc/redhat-release Red Hat Enterprise Linux Server release 7.0 (Maipo) [root at web1:/etc/yum.repos.d] #yum repolist Loaded plugins: amazon-id, rhui-lb repo id